APPS.OKL_INS_QUOTE_PVT dependencies on OKL_IPY_SEQ

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 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 7464: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;

7460: l_ipyv_rec := l_inqv_rec ;
7461:
7462: -- Smoduga Fix for 3232868 Increment policy number for optional quotes.
7463: BEGIN
7464: SELECT OKL_IPY_SEQ.NEXTVAL INTO l_seq FROM dual;
7465: EXCEPTION
7466: WHEN NO_DATA_FOUND THEN
7467: -- store SQL error message on message stack for caller
7468: OKC_API.set_message(G_APP_NAME, 'OKL_NO_SEQUENCE' );