eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_SIF_SEQ

Line 640: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

636: RAISE OKC_API.G_EXCEPTION_ERROR;
637: END IF;
638:
639: BEGIN
640: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
641:
642:
643: EXCEPTION
644: WHEN NO_DATA_FOUND THEN

Line 1064: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

1060:
1061: p_stmv_rec.khr_id := p_ipyv_rec.khr_id ;
1062: p_stmv_rec.kle_id := p_ipyv_rec.kle_id ;
1063: BEGIN
1064: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
1065:
1066: -- call to get the stream type id, change made for insurance user defined streams, bug 3924300
1067: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1068: 'INSURANCE_INCOME_ACCRUAL',

Line 1301: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

1297: --- if multi gaap enabled , create another set of streams
1298: IF(l_multigaap_flag = 'Y') THEN
1299:
1300: BEGIN
1301: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
1302:
1303:
1304: -- call to get the stream type id, change made for insurance user defined streams, bug 3924300
1305:

Line 1516: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

1512: p_stmv_rec.kle_id := p_kle_id ;
1513: -- nEW
1514: BEGIN
1515:
1516: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
1517:
1518: -- NEW
1519: -- Begin : changes for Insurance user defined streams, bug 3924300
1520:

Line 1737: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

1733: IF(l_multigaap_flag = 'Y') THEN
1734:
1735: BEGIN
1736:
1737: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
1738:
1739: -- Begin : changes for Insurance user defined streams, bug 3924300
1740: -- call to get the stream type id, change made for insurance user defined streams
1741:

Line 2722: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;

2718: p_stmv_rec.khr_id := p_ipyv_rec.khr_id ;
2719: p_stmv_rec.kle_id := p_ipyv_rec.kle_id ;
2720: -- nEW
2721: BEGIN
2722: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
2723: --p_stmv_rec.transaction_number := OKL_SIF_SEQ.nextval();
2724: --p_stmv_rec.sty_id := 236689050485873337900191164493000819371;
2725: -- Removed after calling genarate _ins stream from genrate _insrecv_stream,generate_inspayb_stream
2726: -- and so on where sty_id is retrieved depending on stream type

Line 2723: --p_stmv_rec.transaction_number := OKL_SIF_SEQ.nextval();

2719: p_stmv_rec.kle_id := p_ipyv_rec.kle_id ;
2720: -- nEW
2721: BEGIN
2722: select OKL_SIF_SEQ.nextval INTO p_stmv_rec.transaction_number from dual;
2723: --p_stmv_rec.transaction_number := OKL_SIF_SEQ.nextval();
2724: --p_stmv_rec.sty_id := 236689050485873337900191164493000819371;
2725: -- Removed after calling genarate _ins stream from genrate _insrecv_stream,generate_inspayb_stream
2726: -- and so on where sty_id is retrieved depending on stream type
2727: