DBA Data[Home] [Help]

APPS.OKL_BOOK_CONTROLLER_PVT dependencies on DUAL

Line 120: FROM DUAL;

116: l_batch_num OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER%TYPE;
117:
118: CURSOR get_batch_num IS
119: SELECT OKL_BKG_CONTL_SEQ.NEXTVAL
120: FROM DUAL;
121:
122: BEGIN
123: --get batch id for conc requests from seq
124: OPEN get_batch_num;

Line 417: -- the concurrent request id and status of the individual

413: -- Start of comments
414: --
415: -- Procedure Name : update_book_ctrl_trx
416: -- Description : Procedure to update controller transaction table with
417: -- the concurrent request id and status of the individual
418: -- concurrent requests.
419: -- Business Rules :
420: -- Parameters : p_batch_num,p_srl_num,p_prog_status,p_request_id,
421: -- x_return_status