Advertisement
Guest User

Edukacija Dan 4

a guest
Jul 18th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. -- upit za GRID
  2. select stavka_id
  3. ,racun_id
  4. ,naziv
  5. ,kolicina
  6. ,cijena
  7. ,ukupno
  8. from racun_stavka
  9. where racun_id = :P10_RACUN_ID
  10.  
  11. -- proces Pripremi
  12. :P10_RACUN_ID := racun_seq.nextval;
  13. :P10_BROJ := pck_ipc_apex_demo.get_broj_racuna;
  14. :P10_DATUM_RACUNA := to_char(sysdate, 'dd.mm.rrrr hh24:mi');
  15.  
  16. -- proces Insert računa
  17. insert into racun
  18. values (:P10_RACUN_ID, :P10_BROJ, to_date(:P10_DATUM_RACUNA, 'dd.mm.rrrr hh24:mi'), :APP_USER);
  19.  
  20. -- proces Dohvat računa
  21. select broj
  22. ,datum_racuna
  23. into :P10_BROJ
  24. ,:P10_DATUM_RACUNA
  25. from racun
  26. where racun_id = :P10_RACUN_ID;
  27.  
  28. -- DA na GRID koloni
  29. :UKUPNO := nvl(:KOLICINA, 0) * nvl(:CIJENA, 0);
  30.  
  31. -- Račun LOV
  32. select broj d
  33. ,racun_id r
  34. from racun
  35.  
  36. -- APEX URL
  37. :P11_URL := apex_util.prepare_url('f?p=&APP_ID.:10:&SESSION.:PREGLED:&DEBUG.:10:P10_RACUN_ID:'||:P11_RACUN_ID);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement