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 1157: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1153: BEGIN
1154:
1155:
1156:
1157: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1158: 'INSURANCE_RECEIVABLE',
1159: l_return_status,
1160: l_strm_type_id);
1161:

Line 1202: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1198: END if ;
1199: CLOSE C_OKL_STRM_TYPE_CRE_V;*/
1200:
1201:
1202: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1203: 'INSURANCE_REFUND',
1204: l_return_status,
1205: l_strm_type_id);
1206:

Line 1796: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

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

Line 1822: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1818: IF (ln_premium < l_total_paid) THEN
1819:
1820: -- cursor fetch replaced with the call to get the stream type id
1821: -- changed for use defined streams bug 3924300
1822: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1823: 'INSURANCE_ADJUSTMENT',
1824: l_return_status,
1825: l_strm_type_id);
1826:

Line 1880: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

1876: l_to_refund := ln_premium - l_total_paid ;
1877:
1878: -- cursor fetch replaced with the call to get the stream type id
1879: -- changed for user defined sreams, bug 3924300
1880: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
1881: 'INSURANCE_PAYABLE',
1882: l_return_status,
1883: l_strm_type_id);
1884:

Line 2056: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2052:
2053: -- cursor fetch replaced with the call to get the stream type id
2054: -- changed for user defined streams, bug 3924300
2055:
2056: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2057: ls_strm_purpose,
2058: l_return_status,
2059: l_recv_strm_id);
2060:

Line 2125: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2121:
2122:
2123: -- cursor fetch replaced with the call to get the stream type id
2124: -- changed for user defined streams, bug 3924300
2125: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2126: ls_strm_purpose,
2127: l_return_status,
2128: l_recv_strm_id);
2129:

Line 2227: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2223:
2224: -- cursor fetch replaced with the call to get the stream type id,
2225: -- changed for user defined streams, Bug 3924300
2226:
2227: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2228: ls_strm_purpose,
2229: l_return_status,
2230: l_recv_strm_id);
2231:

Line 2291: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

2287:
2288: -- cursor fetch replaced with the call to get the stream type id,
2289: -- changed for user defined streams, bug 3924300
2290:
2291: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
2292: ls_strm_purpose,
2293: l_return_status,
2294: l_recv_strm_id);
2295:

Line 3078: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3074: ln_premium := li_months * l_total_lessor_premium ;
3075:
3076: -- How much have we paid him
3077: -- cursor fetch replaced with the call to get the stream type id
3078: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3079: 'INSURANCE_PAYABLE',
3080: l_return_status,
3081: l_pay_strm_type_id);
3082: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3101: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3097: END IF ;
3098: ln_refund := l_total_paid - ln_premium ;
3099: pn_refund:= ln_refund;
3100: IF (ln_premium < l_total_paid) THEN -- clawback
3101: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3102: 'INSURANCE_ADJUSTMENT',
3103: l_return_status,
3104: l_Adj_strm_type_id);
3105: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3150: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,

3146:
3147: ELSIF (ln_premium > l_total_paid) THEN
3148: l_tra_id := OKC_API.G_MISS_NUM ;
3149: l_to_refund := ln_premium - l_total_paid ;
3150: OKL_STREAMS_UTIL.get_primary_stream_type(p_ipyv_rec.khr_id,
3151: 'INSURANCE_PAYABLE',
3152: l_return_status,
3153: l_PAY_strm_type_id);
3154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3413: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3411: RAISE OKC_API.G_EXCEPTION_ERROR;
3412: END IF;
3413: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3414: 'INSURANCE_RECEIVABLE',
3415: l_return_status,
3416: l_strm_type_id);
3417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3451: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3447: l_multi_gaap_yn, l_reporting_pdt_id;
3448: CLOSE check_csr;
3449: -- MGAAP end 7263041
3450:
3451: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3452: 'INSURANCE_INCOME_ACCRUAL',
3453: l_return_status,
3454: l_strm_type_id);
3455: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3490: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3486: -- MGAAP start 7263041
3487:
3488: IF (l_multi_gaap_yn = 'Y') THEN
3489: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3490: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3491: 'INSURANCE_INCOME_ACCRUAL',
3492: l_return_status,
3493: l_strm_type_id_rep);
3494: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3725: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

3721:
3722: --Start Bug#5955320
3723: IF (l_adjustment_amount <> 0 ) THEN
3724:
3725: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
3726: 'INSURANCE_INCOME_ACCRUAL',
3727: l_return_status,
3728: l_inc_sty_id);
3729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

3790: -- MGAAP start 7263041
3791: IF (l_multi_gaap_yn = 'Y') THEN
3792: IF (l_adjustment_amount_rep <> 0) THEN
3793: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3795: 'INSURANCE_INCOME_ACCRUAL',
3796: l_return_status,
3797: l_inc_sty_id_rep);
3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 4066: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4062: -- MGAAP end 7263041
4063:
4064: -- Expense Adjustment
4065: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
4066: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4067: 'INSURANCE_PAYABLE',
4068: l_return_status,
4069: l_strm_type_id);
4070: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4097: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4093:
4094: IF ((l_total_paid IS NULL ) OR (l_total_paid = OKC_API.G_MISS_NUM )) THEN
4095: l_total_paid := 0;
4096: END IF ;
4097: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4098: 'INSURANCE_EXPENSE_ACCRUAL',
4099: l_return_status,
4100: l_strm_type_id);
4101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4136: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4132: l_adjustment_amount := l_total_paid - l_total_pay_accrued - l_vendor_refund_amount;
4133:
4134: -- MGAAP start 7263041
4135: IF (l_multi_gaap_yn = 'Y') THEN
4136: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4137: 'INSURANCE_EXPENSE_ACCRUAL',
4138: l_return_status,
4139: l_strm_type_id_rep);
4140: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4274: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4270: END IF ;
4271: CLOSE salesP_csr;
4272: --smoduga..Bug 4493213 fix..01-aug-2005..end
4273:
4274: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4275: 'INSURANCE_EXPENSE_ACCRUAL',
4276: l_return_status,
4277: l_strm_type_id);
4278: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4360: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4356:
4357: --Start Bug#5955320
4358: IF (l_adjustment_amount <> 0 ) THEN
4359:
4360: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4361: 'INSURANCE_EXPENSE_ACCRUAL',
4362: l_return_status,
4363: l_inc_sty_id);
4364: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4431: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,

4427:
4428: IF (l_multi_gaap_yn = 'Y') THEN
4429: IF (l_adjustment_amount_rep <> 0 ) THEN
4430:
4431: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
4432: 'INSURANCE_EXPENSE_ACCRUAL',
4433: l_return_status,
4434: l_inc_sty_id_rep);
4435: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

Line 4794: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4790: CLOSE okl_trx_types;
4791:
4792: --Added by kthiruva on 17-Oct-2005
4793: --Bug 4667686 - Start of Changes
4794: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4795: 'INSURANCE_RECEIVABLE',
4796: l_return_status,
4797: l_strm_rcvbl_id);
4798: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4811: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

4807:
4808: IF l_cust_refund_amount > 0 THEN -- [a]
4809: --negate refund amount
4810: l_pro_refund_amount := -(l_cust_refund_amount);
4811: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
4812: 'INSURANCE_REFUND',
4813: l_return_status,
4814: l_strm_refund_id);
4815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6110: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6106: -- Start Fix for 3845998
6107: -- Checking for profile OKL:Maximum number of months allowed after payment for refund
6108:
6109: -- procedure call added for insurance user defined streams, bug 3924300
6110: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6111: 'INSURANCE_RECEIVABLE',
6112: l_return_status,
6113: l_strm_type_id);
6114:

Line 6283: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6279:
6280: -- procedure call added to get the stream type id, user defined streams
6281: -- bug 3924300
6282:
6283: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6284: 'INSURANCE_INCOME_ACCRUAL',
6285: l_return_status,
6286: l_strm_type_id);
6287:

Line 6466: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

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
6466: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6467: 'INSURANCE_INCOME_ACCRUAL',
6468: l_return_status,
6469: l_inc_sty_id);
6470:

Line 6571: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6567: -- Sum of Disbursed Payable(1) - Sum of payable debit(sign)(2) - Sum of accrued insurance (3)
6568:
6569: -- call added to get the stream type id, changes done for user defined streams
6570: -- bug 3924300
6571: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6572: 'INSURANCE_PAYABLE',
6573: l_return_status,
6574: l_strm_type_id);
6575:

Line 6600: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

6596:
6597: /* Bug#5955320
6598: -- call added to get the stream type id, changes done for user defined streams
6599: -- bug 3924300
6600: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6601: 'INSURANCE_EXPENSE_ACCRUAL',
6602: l_return_status,
6603: l_strm_type_id);
6604:

Line 6698: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,

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
6697:
6698: OKL_STREAMS_UTIL.get_primary_stream_type(l_ipyv_rec.khr_id,
6699: 'INSURANCE_EXPENSE_ACCRUAL',
6700: l_return_status,
6701: l_inc_sty_id);
6702:

Line 7120: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

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,
7121: 'INSURANCE_RECEIVABLE',
7122: l_return_status,
7123: l_strm_type_id);
7124:

Line 7152: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

7148:
7149: -- call added to get the stream type id,
7150: -- changes done for user defined streams, bug 3924300
7151:
7152: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
7153: 'INSURANCE_REFUND',
7154: l_return_status,
7155: l_strm_refund_id);
7156: