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_SEEDED_FUNCTIONS_PVT dependencies on OKL_STREAMS_UTIL

Line 195: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

191: -- cursor fetch replaced with the streams util call, change
192: -- done for user defined streams impacts, bug 3924300
193: -- begin changes for bug 3924300
194:
195: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
196: 'INSURANCE_RECEIVABLE',
197: l_return_status,
198: l_stm_type_id);
199: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3424: -- OKL_STREAMS_UTIL.get_dependent_stream_type(

3420:
3421: -- SGIYER
3422: -- UDS Impact
3423: -- Bug 5055714.
3424: -- OKL_STREAMS_UTIL.get_dependent_stream_type(
3425: -- p_khr_id => p_khr_id,
3426: -- p_primary_sty_purpose => 'RENT',
3427: -- p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
3428: -- x_return_status => l_return_status,

Line 3581: OKL_STREAMS_UTIL.get_primary_stream_type(

3577: END IF;
3578:
3579: -- SGIYER
3580: -- UDS Impact
3581: OKL_STREAMS_UTIL.get_primary_stream_type(
3582: p_khr_id => p_khr_id,
3583: p_primary_sty_purpose => 'RENT',
3584: x_return_status => l_return_status,
3585: x_primary_sty_id => l_sty_id);

Line 3727: OKL_STREAMS_UTIL.get_primary_stream_type(

3723: END IF;
3724:
3725: -- SGIYER
3726: -- UDS Impact
3727: OKL_STREAMS_UTIL.get_primary_stream_type(
3728: p_khr_id => p_khr_id,
3729: p_primary_sty_purpose => 'RENT',
3730: x_return_status => l_return_status,
3731: x_primary_sty_id => l_rent_sty_id);

Line 3742: OKL_STREAMS_UTIL.get_dependent_stream_type(

3738: END IF;
3739:
3740: -- SGIYER
3741: -- UDS Impact
3742: OKL_STREAMS_UTIL.get_dependent_stream_type(
3743: p_khr_id => p_khr_id,
3744: p_primary_sty_purpose => 'RENT',
3745: p_dependent_sty_purpose => 'LEASE_INCOME',
3746: x_return_status => l_return_status,

Line 3938: OKL_STREAMS_UTIL.get_dependent_stream_type(

3934: END IF;
3935:
3936: -- Bug 4053623.
3937: -- Modifying error handling.
3938: OKL_STREAMS_UTIL.get_dependent_stream_type(
3939: p_khr_id => p_khr_id,
3940: p_primary_sty_purpose => 'SUBSIDY',
3941: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
3942: x_return_status => l_return_status,

Line 4112: OKL_STREAMS_UTIL.get_dependent_stream_type(

4108: p_msg_name => 'OKL_REV_LPV_CNTRCT_NUM_ERROR');
4109: RAISE OKL_API.G_EXCEPTION_ERROR;
4110: END IF;
4111:
4112: OKL_STREAMS_UTIL.get_dependent_stream_type(
4113: p_khr_id => p_khr_id,
4114: p_primary_sty_purpose => 'RENT',
4115: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
4116: x_return_status => l_return_status,

Line 4951: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

4947: BEGIN
4948: --PAGARG 31-Dec-2004 Bug# 4097591 Start
4949: --UDS impact. Obtain stream type id and pass it to cursor
4950:
4951: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
4952: 'RENT',
4953: l_return_status,
4954: l_stream_type_id);
4955:

Line 5260: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,

5256: p_contract_id => p_contract_id,
5257: x_rep_product_id => lx_rep_product_id);
5258:
5259:
5260: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
5261: p_product_id => lx_rep_product_id,
5262: p_primary_sty_purpose => 'RENT',
5263: p_dependent_sty_purpose => 'LEASE_INCOME',
5264: x_return_status => l_return_status,

Line 5271: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,

5267: -- sechawla 05-dec-07 6671849 : END
5268:
5269: --PAGARG 31-Dec-2004 Bug# 4097591 Start
5270: --UDS impact. Obtain stream type id and pass it to cursor
5271: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
5272: p_primary_sty_purpose => 'RENT',
5273: p_dependent_sty_purpose => 'LEASE_INCOME',
5274: x_return_status => l_return_status,
5275: x_dependent_sty_id => l_stream_type_id);

Line 8943: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

8939: END IF;
8940:
8941: --PAGARG 19-Nov-2004 Bug# 4012614
8942: --UDS impact. Obtain stream type id and pass it to cursor
8943: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
8944: 'RENT',
8945: l_return_status,
8946: l_sty_id);
8947:

Line 8967: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

8963: CLOSE l_unbill_stream_csr;
8964: END IF;
8965:
8966: --06-Dec-2004 PAGARG Bug# 3948473 Pass investor agreement id to obtain stream id
8967: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
8968: 'INVESTOR_RENT_DISB_BASIS',
8969: l_return_status,
8970: l_sty_id);
8971:

Line 9116: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9112: -- Calculate result
9113: -- ****************
9114: --PAGARG 19-Nov-2004 Bug# 4012614
9115: --UDS impact. Obtain stream type id and pass it to cursor
9116: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9117: 'RESIDUAL_VALUE',
9118: l_return_status,
9119: l_sty_id);
9120:

Line 9367: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9363: END IF;
9364:
9365: --PAGARG 19-Nov-2004 Bug# 4012614
9366: --UDS impact. Obtain stream type id and pass it to cursor
9367: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9368: 'PRINCIPAL_PAYMENT',
9369: l_return_status,
9370: l_sty_id);
9371:

Line 9392: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9388: END IF;
9389:
9390: --PAGARG 19-Nov-2004 Bug# 4012614
9391: --UDS impact. Obtain stream type id and pass it to cursor
9392: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9393: 'INTEREST_PAYMENT',
9394: l_return_status,
9395: l_sty_id);
9396:

Line 9417: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9413: END IF;
9414:
9415: --PAGARG 19-Nov-2004 Bug# 4012614
9416: --UDS impact. Obtain stream type id and pass it to cursor
9417: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9418: 'UNSCHEDULED_PRINCIPAL_PAYMENT',
9419: l_return_status,
9420: l_sty_id);
9421:

Line 9444: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

9440: --Calculate Total Unbilled Interest Amount
9441: l_unbill_loan_amount := l_unbill_principal_amount+l_unbill_interest_amount+l_unbill_ppd_amount;
9442:
9443: --06-Dec-2004 PAGARG Bug# 3948473 Pass investor agreement id to obtain stream id
9444: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
9445: 'INVESTOR_PRINCIPAL_DISB_BASIS',
9446: l_return_status,
9447: l_sty_id);
9448:

Line 9467: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

9463: FETCH l_undisb_rent_stream_csr INTO l_undisb_principal_amount;
9464: CLOSE l_undisb_rent_stream_csr;
9465: END IF;
9466:
9467: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
9468: 'INVESTOR_INTEREST_DISB_BASIS',
9469: l_return_status,
9470: l_sty_id);
9471:

Line 9490: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

9486: FETCH l_undisb_rent_stream_csr INTO l_undisb_interest_amount;
9487: CLOSE l_undisb_rent_stream_csr;
9488: END IF;
9489:
9490: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
9491: 'INVESTOR_PPD_DISB_BASIS',
9492: l_return_status,
9493: l_sty_id);
9494:

Line 10097: okl_streams_util.get_dependent_stream_type(

10093:
10094: IF (r_subsidy_line.date_terminated IS NOT NULL) THEN
10095:
10096: /* Bug 6353756 Get dependent stream type from r_subsidy_line.sty_id */
10097: okl_streams_util.get_dependent_stream_type(
10098: p_khr_id => r_subsidy_line.chr_id,
10099: p_primary_sty_id => r_subsidy_line.sty_id,
10100: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
10101: x_return_status => l_return_status,

Line 11813: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

11809: BEGIN
11810: --PAGARG 31-Dec-2004 Bug# 4097591 Start
11811: --UDS impact. Obtain stream type id and pass it to cursor
11812:
11813: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
11814: 'RENT',
11815: l_return_status,
11816: l_stream_type_id);
11817:

Line 12171: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,

12167: x_msg_data => l_msg_data,
12168: p_contract_id => p_contract_id,
12169: x_rep_product_id => lx_rep_product_id);
12170:
12171: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
12172: p_product_id => lx_rep_product_id,
12173: p_primary_sty_purpose => 'RENT',
12174: p_dependent_sty_purpose => 'LEASE_INCOME',
12175: x_return_status => l_return_status,

Line 12188: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,

12184: ELSE
12185: -- sechawla 05-dec-07 6671849 -- START
12186: --PAGARG 31-Dec-2004 Bug# 4097591 Start
12187: --UDS impact. Obtain stream type id and pass it to cursor
12188: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
12189: p_primary_sty_purpose => 'RENT',
12190: p_dependent_sty_purpose => 'LEASE_INCOME',
12191: x_return_status => l_return_status,
12192: x_dependent_sty_id => l_stream_type_id);

Line 12538: OKL_STREAMS_UTIL.get_dependent_stream_type(

12534: AND lalevl.rgd_code = 'LALEVL'
12535: AND lalevl.id = laslh.rgp_id
12536: AND laslh.rule_information_category = 'LASLH';
12537:
12538: OKL_STREAMS_UTIL.get_dependent_stream_type(
12539: p_khr_id => p_contract_id,
12540: p_primary_sty_id => l_fee_payment_id,
12541: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
12542: x_return_status => l_return_status,