Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- upit za GRID
- select stavka_id
- ,racun_id
- ,naziv
- ,kolicina
- ,cijena
- ,ukupno
- from racun_stavka
- where racun_id = :P10_RACUN_ID
- -- proces Pripremi
- :P10_RACUN_ID := racun_seq.nextval;
- :P10_BROJ := pck_ipc_apex_demo.get_broj_racuna;
- :P10_DATUM_RACUNA := to_char(sysdate, 'dd.mm.rrrr hh24:mi');
- -- proces Insert računa
- insert into racun
- values (:P10_RACUN_ID, :P10_BROJ, to_date(:P10_DATUM_RACUNA, 'dd.mm.rrrr hh24:mi'), :APP_USER);
- -- proces Dohvat računa
- select broj
- ,datum_racuna
- into :P10_BROJ
- ,:P10_DATUM_RACUNA
- from racun
- where racun_id = :P10_RACUN_ID;
- -- DA na GRID koloni
- :UKUPNO := nvl(:KOLICINA, 0) * nvl(:CIJENA, 0);
- -- Račun LOV
- select broj d
- ,racun_id r
- from racun
- -- APEX URL
- :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