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 1579: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS

1575: where OINB.IPY_ID = p_ipyv_rec.ID
1576: GROUP BY OINB.IPY_ID;
1577:
1578:
1579: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS
1580: select ID
1581: from OKL_STRM_TYPE_V
1582: where code = p_stream_type;
1583:

Line 1581: from OKL_STRM_TYPE_V

1577:
1578:
1579: CURSOR C_OKL_STRM_TYPE_V (p_stream_type VARCHAR2)IS
1580: select ID
1581: from OKL_STRM_TYPE_V
1582: where code = p_stream_type;
1583:
1584:
1585: CURSOR c_total_paid(l_stm_type_id NUMBER) IS

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

1762: -- Money should have been paid (System profile)
1763: ln_premium := li_months * l_total_lessor_premium ;
1764: -- How much have we paid him
1765:
1766: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1767: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1768: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1769: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1770: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');

Line 1767: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;

1763: ln_premium := li_months * l_total_lessor_premium ;
1764: -- How much have we paid him
1765:
1766: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1767: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1768: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1769: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1770: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1771: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 1768: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

1764: -- How much have we paid him
1765:
1766: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE PAYABLE');
1767: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
1768: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1769: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1770: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1771: x_return_status := OKC_API.G_RET_STS_ERROR ;
1772: CLOSE C_OKL_STRM_TYPE_V ;

Line 1772: CLOSE C_OKL_STRM_TYPE_V ;

1768: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
1769: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
1770: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE PAYABLE');
1771: x_return_status := OKC_API.G_RET_STS_ERROR ;
1772: CLOSE C_OKL_STRM_TYPE_V ;
1773: RAISE OKC_API.G_EXCEPTION_ERROR;
1774: END if ;
1775: CLOSE C_OKL_STRM_TYPE_V;*/
1776: -- cursor fetch replaced with the call to get the stream type id

Line 1775: CLOSE C_OKL_STRM_TYPE_V;*/

1771: x_return_status := OKC_API.G_RET_STS_ERROR ;
1772: CLOSE C_OKL_STRM_TYPE_V ;
1773: RAISE OKC_API.G_EXCEPTION_ERROR;
1774: END if ;
1775: CLOSE C_OKL_STRM_TYPE_V;*/
1776: -- cursor fetch replaced with the call to get the stream type id
1777: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1778: 'INSURANCE_PAYABLE',
1779: l_return_status,

Line 2788: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

2784: AND STR.STY_ID = c_sty_id
2785: AND STRE.DATE_BILLED IS NOT NULL
2786: AND STR.KHR_ID = c_contract_id
2787: AND STR.KLE_ID = c_contract_line_id;
2788: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
2789: SELECT ID
2790: FROM OKL_STRM_TYPE_TL
2791: WHERE NAME = ls_stm_code
2792: AND LANGUAGE = 'US';

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

2791: WHERE NAME = ls_stm_code
2792: AND LANGUAGE = 'US';
2793: BEGIN
2794: l_ipyv_rec := p_ipyv_rec;
2795: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2796: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2797: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2798: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2799: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');

Line 2796: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;

2792: AND LANGUAGE = 'US';
2793: BEGIN
2794: l_ipyv_rec := p_ipyv_rec;
2795: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2796: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2797: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2798: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2799: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2800: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 2797: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

2793: BEGIN
2794: l_ipyv_rec := p_ipyv_rec;
2795: OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
2796: FETCH C_OKL_STRM_TYPE_V INTO l_stm_type_rcvbl_id;
2797: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2798: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2799: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2800: x_return_status := OKC_API.G_RET_STS_ERROR ;
2801: CLOSE C_OKL_STRM_TYPE_V ;

Line 2801: CLOSE C_OKL_STRM_TYPE_V ;

2797: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
2798: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
2799: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
2800: x_return_status := OKC_API.G_RET_STS_ERROR ;
2801: CLOSE C_OKL_STRM_TYPE_V ;
2802: RAISE OKC_API.G_EXCEPTION_ERROR;
2803: END IF ;
2804: CLOSE C_OKL_STRM_TYPE_V;
2805: -- get total amount received from customer

Line 2804: CLOSE C_OKL_STRM_TYPE_V;

2800: x_return_status := OKC_API.G_RET_STS_ERROR ;
2801: CLOSE C_OKL_STRM_TYPE_V ;
2802: RAISE OKC_API.G_EXCEPTION_ERROR;
2803: END IF ;
2804: CLOSE C_OKL_STRM_TYPE_V;
2805: -- get total amount received from customer
2806: OPEN c_total_amount_paid(l_stm_type_rcvbl_id,l_ipyv_rec.KHR_ID,l_ipyv_rec.KLE_ID) ;
2807: FETCH c_total_amount_paid INTO l_no_of_rec;
2808: IF(c_total_amount_paid%NOTFOUND) THEN

Line 5984: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

5980: AND language = cp_language;
5981:
5982:
5983:
5984: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
5985: select ID
5986: from OKL_STRM_TYPE_TL
5987: where NAME = ls_stm_code
5988: AND LANGUAGE = 'US';

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

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

Line 6460: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;

6456: RAISE OKC_API.G_EXCEPTION_ERROR;
6457: END IF;
6458: */
6459: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');
6460: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6461: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6462: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6463: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6464: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 6461: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

6457: END IF;
6458: */
6459: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE INCOME');
6460: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6461: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6462: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6463: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6464: x_return_status := OKC_API.G_RET_STS_ERROR ;
6465: CLOSE C_OKL_STRM_TYPE_V ;

Line 6465: CLOSE C_OKL_STRM_TYPE_V ;

6461: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6462: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6463: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE INCOME');
6464: x_return_status := OKC_API.G_RET_STS_ERROR ;
6465: CLOSE C_OKL_STRM_TYPE_V ;
6466: RAISE OKC_API.G_EXCEPTION_ERROR;
6467: END if ;
6468: CLOSE C_OKL_STRM_TYPE_V;*/
6469:

Line 6468: CLOSE C_OKL_STRM_TYPE_V;*/

6464: x_return_status := OKC_API.G_RET_STS_ERROR ;
6465: CLOSE C_OKL_STRM_TYPE_V ;
6466: RAISE OKC_API.G_EXCEPTION_ERROR;
6467: END if ;
6468: CLOSE C_OKL_STRM_TYPE_V;*/
6469:
6470: /* Bug#5955320
6471: -- cursor fetch replaced with the call to get the stream type id
6472: -- changes done for user defined streams, bug 3924300

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

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

Line 6691: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;

6687: RAISE OKC_API.G_EXCEPTION_ERROR;
6688: END IF;
6689: */
6690: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');
6691: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6692: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6693: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6694: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6695: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 6692: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

6688: END IF;
6689: */
6690: /* OPEN C_OKL_STRM_TYPE_V('INSURANCE EXPENSE');
6691: FETCH C_OKL_STRM_TYPE_V INTO l_inc_sty_id;
6692: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6693: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6694: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6695: x_return_status := OKC_API.G_RET_STS_ERROR ;
6696: CLOSE C_OKL_STRM_TYPE_V ;

Line 6696: CLOSE C_OKL_STRM_TYPE_V ;

6692: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
6693: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
6694: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE EXPENSE');
6695: x_return_status := OKC_API.G_RET_STS_ERROR ;
6696: CLOSE C_OKL_STRM_TYPE_V ;
6697: RAISE OKC_API.G_EXCEPTION_ERROR;
6698: END if ;
6699: CLOSE C_OKL_STRM_TYPE_V;*/
6700:

Line 6699: CLOSE C_OKL_STRM_TYPE_V;*/

6695: x_return_status := OKC_API.G_RET_STS_ERROR ;
6696: CLOSE C_OKL_STRM_TYPE_V ;
6697: RAISE OKC_API.G_EXCEPTION_ERROR;
6698: END if ;
6699: CLOSE C_OKL_STRM_TYPE_V;*/
6700:
6701: /* Bug#5955320
6702: -- cursor fetch to get the stream type id replaced with the call,
6703: -- changed for insurance user defined streams, bug 3924300

Line 7035: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS

7031: l_sty_id NUMBER ;
7032: l_strm_refund_id NUMBER;
7033: l_tai_id NUMBER ;
7034:
7035: CURSOR C_OKL_STRM_TYPE_V(ls_stm_code VARCHAR2) IS
7036: select ID
7037: from OKL_STRM_TYPE_TL
7038: where NAME = ls_stm_code
7039: AND LANGUAGE = 'US';

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

7110: -- GET STream ID
7111: l_refund_amount := -(x_refund_amount) ; --bug 3923601
7112: BEGIN
7113:
7114: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7115: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7116: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7117: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7118: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');

Line 7115: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;

7111: l_refund_amount := -(x_refund_amount) ; --bug 3923601
7112: BEGIN
7113:
7114: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7115: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7116: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7117: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7118: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7119: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 7116: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

7112: BEGIN
7113:
7114: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE RECEIVABLE');
7115: FETCH C_OKL_STRM_TYPE_V INTO l_strm_type_id;
7116: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7117: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7118: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7119: x_return_status := OKC_API.G_RET_STS_ERROR ;
7120: CLOSE C_OKL_STRM_TYPE_V ;

Line 7120: CLOSE C_OKL_STRM_TYPE_V ;

7116: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7117: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7118: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE RECEIVABLE');
7119: x_return_status := OKC_API.G_RET_STS_ERROR ;
7120: CLOSE C_OKL_STRM_TYPE_V ;
7121: RAISE OKC_API.G_EXCEPTION_ERROR;
7122: END if ;
7123: CLOSE C_OKL_STRM_TYPE_V;*/
7124: -- cursor fetch replaced with the procedure call to get the stream type id,

Line 7123: CLOSE C_OKL_STRM_TYPE_V;*/

7119: x_return_status := OKC_API.G_RET_STS_ERROR ;
7120: CLOSE C_OKL_STRM_TYPE_V ;
7121: RAISE OKC_API.G_EXCEPTION_ERROR;
7122: END if ;
7123: CLOSE C_OKL_STRM_TYPE_V;*/
7124: -- cursor fetch replaced with the procedure call to get the stream type id,
7125: -- changes done for user defined streams, bug 3924300
7126:
7127: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

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

7141:
7142: END;
7143: BEGIN
7144:
7145: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7146: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7147: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7148: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7149: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');

Line 7146: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;

7142: END;
7143: BEGIN
7144:
7145: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7146: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7147: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7148: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7149: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7150: x_return_status := OKC_API.G_RET_STS_ERROR ;

Line 7147: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN

7143: BEGIN
7144:
7145: /*OPEN C_OKL_STRM_TYPE_V('INSURANCE REFUND');
7146: FETCH C_OKL_STRM_TYPE_V INTO l_strm_refund_id;
7147: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7148: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7149: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7150: x_return_status := OKC_API.G_RET_STS_ERROR ;
7151: CLOSE C_OKL_STRM_TYPE_V ;

Line 7151: CLOSE C_OKL_STRM_TYPE_V ;

7147: IF(C_OKL_STRM_TYPE_V%NOTFOUND) THEN
7148: Okc_Api.set_message(G_APP_NAME, G_NO_STREAM,
7149: G_COL_NAME_TOKEN,'Stream Type',G_COL_VALUE_TOKEN,'INSURANCE REFUND');
7150: x_return_status := OKC_API.G_RET_STS_ERROR ;
7151: CLOSE C_OKL_STRM_TYPE_V ;
7152: RAISE OKC_API.G_EXCEPTION_ERROR;
7153: END if ;
7154: CLOSE C_OKL_STRM_TYPE_V;*/
7155:

Line 7154: CLOSE C_OKL_STRM_TYPE_V;*/

7150: x_return_status := OKC_API.G_RET_STS_ERROR ;
7151: CLOSE C_OKL_STRM_TYPE_V ;
7152: RAISE OKC_API.G_EXCEPTION_ERROR;
7153: END if ;
7154: CLOSE C_OKL_STRM_TYPE_V;*/
7155:
7156: -- call added to get the stream type id,
7157: -- changes done for user defined streams, bug 3924300
7158: