DBA Data[Home] [Help]

APPS.OKL_STREAM_GENERATOR_PVT dependencies on OKL_SIF_SEQ

Line 2613: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;

2609:
2610: BEGIN
2611:
2612: --print( l_prog_name, 'begin' );
2613: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;
2614:
2615: -- NOTE: UV for Streams inquiry (OKL_ASSET_STREAMS_UV) assumes a denormalized use of KHR_ID
2616:
2617: l_stmv_rec.khr_id := p_khr_id;

Line 6648: SELECT okl_sif_seq.nextval

6644: print(l_prog_name, l_del_stm_id_idx || ' | ' || l_del_stm_id_tbl(l_del_stm_id_idx) );
6645: END LOOP;
6646: IF l_wrk_strm_trx_number IS NULL
6647: THEN
6648: SELECT okl_sif_seq.nextval
6649: INTO l_wrk_strm_trx_number
6650: FROM DUAL;
6651: END IF;
6652: print(l_prog_name, 'l_wrk_strm_trx_number = ' || l_wrk_strm_trx_number );