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 DUAL

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 3444: l_inav_rec.org_id FROM dual;

3440: INTO l_inav_rec.REQUEST_ID,
3441: l_inav_rec.PROGRAM_APPLICATION_ID,
3442: l_inav_rec.PROGRAM_ID,
3443: l_inav_rec.PROGRAM_UPDATE_DATE,
3444: l_inav_rec.org_id FROM dual;
3445: l_inav_rec.CREATED_BY := l_okl_inav_pk_csr.CREATED_BY ;
3446: l_inav_rec.CREATION_DATE := l_okl_inav_pk_csr.CREATION_DATE ;
3447: l_inav_rec.LAST_UPDATED_BY := l_okl_inav_pk_csr.LAST_UPDATED_BY ;
3448: l_inav_rec.LAST_UPDATE_DATE := l_okl_inav_pk_csr.LAST_UPDATE_DATE ;

Line 3498: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;

3494: WHERE id = l_ipyv_rec.ipt_id;
3495: BEGIN
3496: l_ipyv_rec := l_inqv_rec ;
3497: BEGIN
3498: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;
3499: EXCEPTION
3500: WHEN NO_DATA_FOUND THEN
3501: -- store SQL error message on message stack for caller
3502: OKC_API.set_message(G_APP_NAME, 'OKL_NO_SEQUENCE' );

Line 3535: l_ipyv_rec.org_id FROM dual;

3531: INTO l_ipyv_rec.REQUEST_ID,
3532: l_ipyv_rec.PROGRAM_APPLICATION_ID,
3533: l_ipyv_rec.PROGRAM_ID,
3534: l_ipyv_rec.PROGRAM_UPDATE_DATE,
3535: l_ipyv_rec.org_id FROM dual;
3536: l_ipyv_rec.created_by := OKC_API.G_MISS_NUM;
3537: l_ipyv_rec.creation_date := OKC_API.G_MISS_DATE ;
3538: l_ipyv_rec.last_updated_by := OKC_API.G_MISS_NUM;
3539: l_ipyv_rec.last_update_date := OKC_API.G_MISS_DATE ;

Line 3897: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;

3893:
3894: l_ipyv_rec.SFWT_FLAG := 'T' ;
3895: -- Policy Number // Quote Number generation
3896: BEGIN
3897: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;
3898: EXCEPTION
3899: WHEN NO_DATA_FOUND THEN
3900: -- store SQL error message on message stack for caller
3901: OKC_API.set_message(G_APP_NAME, 'OKL_NO_SEQUENCE' );

Line 3982: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;

3978: l_ipyv_rec.SFWT_FLAG := 'T' ;
3979: l_ipyv_rec.deductible := 0 ;
3980: -- Policy Number // Quote Number generation
3981: BEGIN
3982: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;
3983: EXCEPTION
3984: WHEN NO_DATA_FOUND THEN
3985: -- store SQL error message on message stack for caller
3986: OKC_API.set_message(G_APP_NAME, 'OKL_NO_SEQUENCE' );

Line 7457: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;

7453: l_ipyv_rec := l_inqv_rec ;
7454:
7455: -- Smoduga Fix for 3232868 Increment policy number for optional quotes.
7456: BEGIN
7457: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;
7458: EXCEPTION
7459: WHEN NO_DATA_FOUND THEN
7460: -- store SQL error message on message stack for caller
7461: OKC_API.set_message(G_APP_NAME, 'OKL_NO_SEQUENCE' );