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_STREAMS_UTIL

Line 1138: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1134: BEGIN
1135:
1136:
1137:
1138: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1139: 'INSURANCE_RECEIVABLE',
1140: l_return_status,
1141: l_strm_type_id);
1142:

Line 1183: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1179: END if ;
1180: CLOSE C_OKL_STRM_TYPE_CRE_V;*/
1181:
1182:
1183: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1184: 'INSURANCE_REFUND',
1185: l_return_status,
1186: l_strm_type_id);
1187:

Line 1777: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

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,
1780: l_strm_type_id);
1781: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1803: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1799: IF (ln_premium < l_total_paid) THEN
1800:
1801: -- cursor fetch replaced with the call to get the stream type id
1802: -- changed for use defined streams bug 3924300
1803: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1804: 'INSURANCE_ADJUSTMENT',
1805: l_return_status,
1806: l_strm_type_id);
1807:

Line 1861: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1857: l_to_refund := ln_premium - l_total_paid ;
1858:
1859: -- cursor fetch replaced with the call to get the stream type id
1860: -- changed for user defined sreams, bug 3924300
1861: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1862: 'INSURANCE_PAYABLE',
1863: l_return_status,
1864: l_strm_type_id);
1865:

Line 2037: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2033:
2034: -- cursor fetch replaced with the call to get the stream type id
2035: -- changed for user defined streams, bug 3924300
2036:
2037: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2038: ls_strm_purpose,
2039: l_return_status,
2040: l_recv_strm_id);
2041:

Line 2106: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2102:
2103:
2104: -- cursor fetch replaced with the call to get the stream type id
2105: -- changed for user defined streams, bug 3924300
2106: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2107: ls_strm_purpose,
2108: l_return_status,
2109: l_recv_strm_id);
2110:

Line 2208: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2204:
2205: -- cursor fetch replaced with the call to get the stream type id,
2206: -- changed for user defined streams, Bug 3924300
2207:
2208: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2209: ls_strm_purpose,
2210: l_return_status,
2211: l_recv_strm_id);
2212:

Line 2272: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2268:
2269: -- cursor fetch replaced with the call to get the stream type id,
2270: -- changed for user defined streams, bug 3924300
2271:
2272: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2273: ls_strm_purpose,
2274: l_return_status,
2275: l_recv_strm_id);
2276:

Line 3059: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3055: ln_premium := li_months * l_total_lessor_premium ;
3056:
3057: -- How much have we paid him
3058: -- cursor fetch replaced with the call to get the stream type id
3059: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3060: 'INSURANCE_PAYABLE',
3061: l_return_status,
3062: l_pay_strm_type_id);
3063: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3082: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3078: END IF ;
3079: ln_refund := l_total_paid - ln_premium ;
3080: pn_refund:= ln_refund;
3081: IF (ln_premium < l_total_paid) THEN -- clawback
3082: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3083: 'INSURANCE_ADJUSTMENT',
3084: l_return_status,
3085: l_Adj_strm_type_id);
3086: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3131: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3127:
3128: ELSIF (ln_premium > l_total_paid) THEN
3129: l_tra_id := OKC_API.G_MISS_NUM ;
3130: l_to_refund := ln_premium - l_total_paid ;
3131: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3132: 'INSURANCE_PAYABLE',
3133: l_return_status,
3134: l_PAY_strm_type_id);
3135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3391: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3387: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3388: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3389: RAISE OKC_API.G_EXCEPTION_ERROR;
3390: END IF;
3391: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3392: 'INSURANCE_RECEIVABLE',
3393: l_return_status,
3394: l_strm_type_id);
3395: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3429: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3425: l_multi_gaap_yn, l_reporting_pdt_id;
3426: CLOSE check_csr;
3427: -- MGAAP end 7263041
3428:
3429: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3430: 'INSURANCE_INCOME_ACCRUAL',
3431: l_return_status,
3432: l_strm_type_id);
3433: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3468: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3464: -- MGAAP start 7263041
3465:
3466: IF (l_multi_gaap_yn = 'Y') THEN
3467: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3468: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3469: 'INSURANCE_INCOME_ACCRUAL',
3470: l_return_status,
3471: l_strm_type_id_rep);
3472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3703: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3699:
3700: --Start Bug#5955320
3701: IF (l_adjustment_amount <> 0 ) THEN
3702:
3703: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3704: 'INSURANCE_INCOME_ACCRUAL',
3705: l_return_status,
3706: l_inc_sty_id);
3707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3767: -- MGAAP start 7263041
3768: IF (l_multi_gaap_yn = 'Y') THEN
3769: IF (l_adjustment_amount_rep <> 0) THEN
3770: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3772: 'INSURANCE_INCOME_ACCRUAL',
3773: l_return_status,
3774: l_inc_sty_id_rep);
3775: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4038: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4034: -- MGAAP end 7263041
4035:
4036: -- Expense Adjustment
4037: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
4038: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4039: 'INSURANCE_PAYABLE',
4040: l_return_status,
4041: l_strm_type_id);
4042: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4069: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4065:
4066: IF ((l_total_paid IS NULL ) OR (l_total_paid = OKC_API.G_MISS_NUM )) THEN
4067: l_total_paid := 0;
4068: END IF ;
4069: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4070: 'INSURANCE_EXPENSE_ACCRUAL',
4071: l_return_status,
4072: l_strm_type_id);
4073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4108: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4104: l_adjustment_amount := l_total_paid - l_total_pay_accrued - l_vendor_refund_amount;
4105:
4106: -- MGAAP start 7263041
4107: IF (l_multi_gaap_yn = 'Y') THEN
4108: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4109: 'INSURANCE_EXPENSE_ACCRUAL',
4110: l_return_status,
4111: l_strm_type_id_rep);
4112: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4246: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4242: END IF ;
4243: CLOSE salesP_csr;
4244: --smoduga..Bug 4493213 fix..01-aug-2005..end
4245:
4246: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4247: 'INSURANCE_EXPENSE_ACCRUAL',
4248: l_return_status,
4249: l_strm_type_id);
4250: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4332: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4328:
4329: --Start Bug#5955320
4330: IF (l_adjustment_amount <> 0 ) THEN
4331:
4332: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4333: 'INSURANCE_EXPENSE_ACCRUAL',
4334: l_return_status,
4335: l_inc_sty_id);
4336: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4402: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

4398:
4399: IF (l_multi_gaap_yn = 'Y') THEN
4400: IF (l_adjustment_amount_rep <> 0 ) THEN
4401:
4402: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
4403: 'INSURANCE_EXPENSE_ACCRUAL',
4404: l_return_status,
4405: l_inc_sty_id_rep);
4406: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4803: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4799: CLOSE okl_trx_types;
4800:
4801: --Added by kthiruva on 17-Oct-2005
4802: --Bug 4667686 - Start of Changes
4803: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4804: 'INSURANCE_RECEIVABLE',
4805: l_return_status,
4806: l_strm_rcvbl_id);
4807: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4820: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4816:
4817: IF l_cust_refund_amount > 0 THEN -- [a]
4818: --negate refund amount
4819: l_pro_refund_amount := -(l_cust_refund_amount);
4820: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4821: 'INSURANCE_REFUND',
4822: l_return_status,
4823: l_strm_refund_id);
4824: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6117: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6113: -- Start Fix for 3845998
6114: -- Checking for profile OKL:Maximum number of months allowed after payment for refund
6115:
6116: -- procedure call added for insurance user defined streams, bug 3924300
6117: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6118: 'INSURANCE_RECEIVABLE',
6119: l_return_status,
6120: l_strm_type_id);
6121:

Line 6290: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6286:
6287: -- procedure call added to get the stream type id, user defined streams
6288: -- bug 3924300
6289:
6290: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6291: 'INSURANCE_INCOME_ACCRUAL',
6292: l_return_status,
6293: l_strm_type_id);
6294:

Line 6473: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

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
6473: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6474: 'INSURANCE_INCOME_ACCRUAL',
6475: l_return_status,
6476: l_inc_sty_id);
6477:

Line 6578: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6574: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
6575:
6576: -- call added to get the stream type id, changes done for user defined streams
6577: -- bug 3924300
6578: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6579: 'INSURANCE_PAYABLE',
6580: l_return_status,
6581: l_strm_type_id);
6582:

Line 6607: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6603:
6604: /* Bug#5955320
6605: -- call added to get the stream type id, changes done for user defined streams
6606: -- bug 3924300
6607: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6608: 'INSURANCE_EXPENSE_ACCRUAL',
6609: l_return_status,
6610: l_strm_type_id);
6611:

Line 6705: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

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
6704:
6705: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6706: 'INSURANCE_EXPENSE_ACCRUAL',
6707: l_return_status,
6708: l_inc_sty_id);
6709:

Line 7127: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

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,
7128: 'INSURANCE_RECEIVABLE',
7129: l_return_status,
7130: l_strm_type_id);
7131:

Line 7159: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7155:
7156: -- call added to get the stream type id,
7157: -- changes done for user defined streams, bug 3924300
7158:
7159: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7160: 'INSURANCE_REFUND',
7161: l_return_status,
7162: l_strm_refund_id);
7163: