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_INSURANCE_POLICIES_PVT dependencies on OKL_STRM_TYPE_V

Line 1598: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS

1594: where OINB.IPY_ID = p_ipyv_rec.ID
1595: GROUP BY OINB.IPY_ID;
1596:
1597:
1598: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS
1599: select ID
1600: from OKL_STRM_TYPE_V
1601: where code = p_stream_type;
1602:

Line 1600: from OKL_STRM_TYPE_V

1596:
1597:
1598: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS
1599: select ID
1600: from OKL_STRM_TYPE_V
1601: where code = p_stream_type;
1602:
1603:
1604: CURSOR c_total_paid(l_stm_type_id NUMBER) IS

Line 1785: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');

1781: -- Money should have been paid (System profile)
1782: ln_premium := li_months * l_total_lessor_premium ;
1783: -- How much have we paid him
1784:
1785: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1786: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1787: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1788: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1789: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');

Line 1786: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;

1782: ln_premium := li_months * l_total_lessor_premium ;
1783: -- How much have we paid him
1784:
1785: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1786: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1787: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1788: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1789: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1790: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 1787: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

1783: -- How much have we paid him
1784:
1785: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1786: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1787: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1788: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1789: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1790: x_return_status := OKC_API.G_RET_STS_ERROR ;
1791: CLOSE C_OKL_STRM_TYPE_V ;

Line 1791: CLOSE C_OKL_STRM_TYPE_V ;

1787: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1788: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1789: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1790: x_return_status := OKC_API.G_RET_STS_ERROR ;
1791: CLOSE C_OKL_STRM_TYPE_V ;
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END if ;
1794: CLOSE C_OKL_STRM_TYPE_V;*/
1795: -- cursor fetch replaced with the call to get the stream type id

Line 1794: CLOSE C_OKL_STRM_TYPE_V;*/

1790: x_return_status := OKC_API.G_RET_STS_ERROR ;
1791: CLOSE C_OKL_STRM_TYPE_V ;
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END if ;
1794: CLOSE C_OKL_STRM_TYPE_V;*/
1795: -- cursor fetch replaced with the call to get the stream type id
1796: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1797: 'INSURANCE_PAYABLE',
1798: l_return_status,

Line 2807: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

2803: AND STR.STY_ID = c_sty_id
2804: AND STRE.DATE_BILLED IS NOT NULL
2805: AND STR.KHR_ID = c_contract_id
2806: AND STR.KLE_ID = c_contract_line_id;
2807: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
2808: SELECT ID
2809: FROM OKL_STRM_TYPE_TL
2810: WHERE NAME = ls_stm_code
2811: AND LANGUAGE = 'US';

Line 2814: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');

2810: WHERE NAME = ls_stm_code
2811: AND LANGUAGE = 'US';
2812: BEGIN
2813: l_ipyv_rec := p_ipyv_rec;
2814: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2815: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2816: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2817: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2818: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');

Line 2815: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;

2811: AND LANGUAGE = 'US';
2812: BEGIN
2813: l_ipyv_rec := p_ipyv_rec;
2814: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2815: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2816: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2817: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2818: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2819: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 2816: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

2812: BEGIN
2813: l_ipyv_rec := p_ipyv_rec;
2814: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2815: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2816: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2817: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2818: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2819: x_return_status := OKC_API.G_RET_STS_ERROR ;
2820: CLOSE C_OKL_STRM_TYPE_V ;

Line 2820: CLOSE C_OKL_STRM_TYPE_V ;

2816: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2817: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2818: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2819: x_return_status := OKC_API.G_RET_STS_ERROR ;
2820: CLOSE C_OKL_STRM_TYPE_V ;
2821: RAISE OKC_API.G_EXCEPTION_ERROR;
2822: END IF ;
2823: CLOSE C_OKL_STRM_TYPE_V;
2824: -- get total amount received from customer

Line 2823: CLOSE C_OKL_STRM_TYPE_V;

2819: x_return_status := OKC_API.G_RET_STS_ERROR ;
2820: CLOSE C_OKL_STRM_TYPE_V ;
2821: RAISE OKC_API.G_EXCEPTION_ERROR;
2822: END IF ;
2823: CLOSE C_OKL_STRM_TYPE_V;
2824: -- get total amount received from customer
2825: OPEN c_total_amount_paid(l_stm_type_rcvbl_id,l_ipyv_rec.KHR_ID,l_ipyv_rec.KLE_ID) ;
2826: FETCH c_total_amount_paid INTO l_no_of_rec;
2827: IF(c_total_amount_paid%NOTFOUND) THEN

Line 5977: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

5973: AND language = cp_language;
5974:
5975:
5976:
5977: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
5978: select ID
5979: from OKL_STRM_TYPE_TL
5980: where NAME = ls_stm_code
5981: AND LANGUAGE = 'US';

Line 6452: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');

6448: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6449: RAISE OKC_API.G_EXCEPTION_ERROR;
6450: END IF;
6451: */
6452: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');
6453: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6454: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6455: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6456: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');

Line 6453: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;

6449: RAISE OKC_API.G_EXCEPTION_ERROR;
6450: END IF;
6451: */
6452: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');
6453: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6454: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6455: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6456: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6457: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 6454: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

6450: END IF;
6451: */
6452: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');
6453: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6454: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6455: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6456: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6457: x_return_status := OKC_API.G_RET_STS_ERROR ;
6458: CLOSE C_OKL_STRM_TYPE_V ;

Line 6458: CLOSE C_OKL_STRM_TYPE_V ;

6454: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6455: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6456: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6457: x_return_status := OKC_API.G_RET_STS_ERROR ;
6458: CLOSE C_OKL_STRM_TYPE_V ;
6459: RAISE OKC_API.G_EXCEPTION_ERROR;
6460: END if ;
6461: CLOSE C_OKL_STRM_TYPE_V;*/
6462:

Line 6461: CLOSE C_OKL_STRM_TYPE_V;*/

6457: x_return_status := OKC_API.G_RET_STS_ERROR ;
6458: CLOSE C_OKL_STRM_TYPE_V ;
6459: RAISE OKC_API.G_EXCEPTION_ERROR;
6460: END if ;
6461: CLOSE C_OKL_STRM_TYPE_V;*/
6462:
6463: /* Bug#5955320
6464: -- cursor fetch replaced with the call to get the stream type id
6465: -- changes done for user defined streams, bug 3924300

Line 6683: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');

6679: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
6680: RAISE OKC_API.G_EXCEPTION_ERROR;
6681: END IF;
6682: */
6683: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');
6684: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6685: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6686: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6687: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');

Line 6684: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;

6680: RAISE OKC_API.G_EXCEPTION_ERROR;
6681: END IF;
6682: */
6683: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');
6684: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6685: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6686: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6687: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6688: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 6685: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

6681: END IF;
6682: */
6683: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');
6684: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6685: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6686: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6687: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6688: x_return_status := OKC_API.G_RET_STS_ERROR ;
6689: CLOSE C_OKL_STRM_TYPE_V ;

Line 6689: CLOSE C_OKL_STRM_TYPE_V ;

6685: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6686: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6687: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6688: x_return_status := OKC_API.G_RET_STS_ERROR ;
6689: CLOSE C_OKL_STRM_TYPE_V ;
6690: RAISE OKC_API.G_EXCEPTION_ERROR;
6691: END if ;
6692: CLOSE C_OKL_STRM_TYPE_V;*/
6693:

Line 6692: CLOSE C_OKL_STRM_TYPE_V;*/

6688: x_return_status := OKC_API.G_RET_STS_ERROR ;
6689: CLOSE C_OKL_STRM_TYPE_V ;
6690: RAISE OKC_API.G_EXCEPTION_ERROR;
6691: END if ;
6692: CLOSE C_OKL_STRM_TYPE_V;*/
6693:
6694: /* Bug#5955320
6695: -- cursor fetch to get the stream type id replaced with the call,
6696: -- changed for insurance user defined streams, bug 3924300

Line 7028: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

7024: l_sty_id NUMBER ;
7025: l_strm_refund_id NUMBER;
7026: l_tai_id NUMBER ;
7027:
7028: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
7029: select ID
7030: from OKL_STRM_TYPE_TL
7031: where NAME = ls_stm_code
7032: AND LANGUAGE = 'US';

Line 7107: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');

7103: -- GET STream ID
7104: l_refund_amount := -(x_refund_amount) ; --bug 3923601
7105: BEGIN
7106:
7107: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7108: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7109: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7110: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7111: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');

Line 7108: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;

7104: l_refund_amount := -(x_refund_amount) ; --bug 3923601
7105: BEGIN
7106:
7107: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7108: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7109: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7110: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7111: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7112: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 7109: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

7105: BEGIN
7106:
7107: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7108: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7109: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7110: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7111: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7112: x_return_status := OKC_API.G_RET_STS_ERROR ;
7113: CLOSE C_OKL_STRM_TYPE_V ;

Line 7113: CLOSE C_OKL_STRM_TYPE_V ;

7109: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7110: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7111: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7112: x_return_status := OKC_API.G_RET_STS_ERROR ;
7113: CLOSE C_OKL_STRM_TYPE_V ;
7114: RAISE OKC_API.G_EXCEPTION_ERROR;
7115: END if ;
7116: CLOSE C_OKL_STRM_TYPE_V;*/
7117: -- cursor fetch replaced with the procedure call to get the stream type id,

Line 7116: CLOSE C_OKL_STRM_TYPE_V;*/

7112: x_return_status := OKC_API.G_RET_STS_ERROR ;
7113: CLOSE C_OKL_STRM_TYPE_V ;
7114: RAISE OKC_API.G_EXCEPTION_ERROR;
7115: END if ;
7116: CLOSE C_OKL_STRM_TYPE_V;*/
7117: -- cursor fetch replaced with the procedure call to get the stream type id,
7118: -- changes done for user defined streams, bug 3924300
7119:
7120: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

Line 7138: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');

7134:
7135: END;
7136: BEGIN
7137:
7138: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7139: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7140: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7141: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7142: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');

Line 7139: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;

7135: END;
7136: BEGIN
7137:
7138: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7139: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7140: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7141: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7142: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7143: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 7140: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

7136: BEGIN
7137:
7138: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7139: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7140: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7141: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7142: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7143: x_return_status := OKC_API.G_RET_STS_ERROR ;
7144: CLOSE C_OKL_STRM_TYPE_V ;

Line 7144: CLOSE C_OKL_STRM_TYPE_V ;

7140: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7141: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7142: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7143: x_return_status := OKC_API.G_RET_STS_ERROR ;
7144: CLOSE C_OKL_STRM_TYPE_V ;
7145: RAISE OKC_API.G_EXCEPTION_ERROR;
7146: END if ;
7147: CLOSE C_OKL_STRM_TYPE_V;*/
7148:

Line 7147: CLOSE C_OKL_STRM_TYPE_V;*/

7143: x_return_status := OKC_API.G_RET_STS_ERROR ;
7144: CLOSE C_OKL_STRM_TYPE_V ;
7145: RAISE OKC_API.G_EXCEPTION_ERROR;
7146: END if ;
7147: CLOSE C_OKL_STRM_TYPE_V;*/
7148:
7149: -- call added to get the stream type id,
7150: -- changes done for user defined streams, bug 3924300
7151: