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.

[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_STREAMS_UTIL

Line 194: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

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

Line 3888: -- OKL_STREAMS_UTIL.get_dependent_stream_type(

3884:
3885: -- SGIYER
3886: -- UDS Impact
3887: -- Bug 5055714.
3888: -- OKL_STREAMS_UTIL.get_dependent_stream_type(
3889: -- p_khr_id => p_khr_id,
3890: -- p_primary_sty_purpose => 'RENT',
3891: -- p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
3892: -- x_return_status => l_return_status,

Line 4052: OKL_STREAMS_UTIL.get_primary_stream_type(

4048: END IF;
4049:
4050: -- SGIYER
4051: -- UDS Impact
4052: OKL_STREAMS_UTIL.get_primary_stream_type(
4053: p_khr_id => p_khr_id,
4054: p_primary_sty_purpose => 'RENT',
4055: x_return_status => l_return_status,
4056: x_primary_sty_id => l_sty_id);

Line 4272: OKL_STREAMS_UTIL.get_primary_stream_type(

4268: END IF;
4269:
4270: -- SGIYER
4271: -- UDS Impact
4272: OKL_STREAMS_UTIL.get_primary_stream_type(
4273: p_khr_id => p_khr_id,
4274: p_primary_sty_purpose => 'RENT',
4275: x_return_status => l_return_status,
4276: x_primary_sty_id => l_rent_sty_id);

Line 4287: OKL_STREAMS_UTIL.get_dependent_stream_type(

4283: END IF;
4284:
4285: -- SGIYER
4286: -- UDS Impact
4287: OKL_STREAMS_UTIL.get_dependent_stream_type(
4288: p_khr_id => p_khr_id,
4289: p_primary_sty_purpose => 'RENT',
4290: p_dependent_sty_purpose => 'LEASE_INCOME',
4291: x_return_status => l_return_status,

Line 4501: OKL_STREAMS_UTIL.get_dependent_stream_type(

4497: END IF;
4498:
4499: -- Bug 4053623.
4500: -- Modifying error handling.
4501: OKL_STREAMS_UTIL.get_dependent_stream_type(
4502: p_khr_id => p_khr_id,
4503: p_primary_sty_purpose => 'SUBSIDY',
4504: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
4505: x_return_status => l_return_status,

Line 4699: OKL_STREAMS_UTIL.get_dependent_stream_type(

4695: END IF;
4696:
4697: --sechawla 21-sep-09 8830506
4698: IF l_rep_type = 'PRIMARY' THEN
4699: OKL_STREAMS_UTIL.get_dependent_stream_type(
4700: p_khr_id => p_khr_id,
4701: p_primary_sty_purpose => 'RENT',
4702: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
4703: x_return_status => l_return_status,

Line 4706: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

4702: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
4703: x_return_status => l_return_status,
4704: x_dependent_sty_id => l_sty_id);
4705: ELSIF l_rep_type = 'SECONDARY' THEN
4706: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
4707: p_khr_id => p_khr_id,
4708: p_primary_sty_purpose => 'RENT',
4709: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
4710: x_return_status => l_return_status,

Line 5549: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

5545: BEGIN
5546: --PAGARG 31-Dec-2004 Bug# 4097591 Start
5547: --UDS impact. Obtain stream type id and pass it to cursor
5548:
5549: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
5550: 'RENT',
5551: l_return_status,
5552: l_stream_type_id);
5553:

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

5854: p_contract_id => p_contract_id,
5855: x_rep_product_id => lx_rep_product_id);
5856:
5857:
5858: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
5859: p_product_id => lx_rep_product_id,
5860: p_primary_sty_purpose => 'RENT',
5861: p_dependent_sty_purpose => 'LEASE_INCOME',
5862: x_return_status => l_return_status,

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

5865: -- sechawla 05-dec-07 6671849 : END
5866:
5867: --PAGARG 31-Dec-2004 Bug# 4097591 Start
5868: --UDS impact. Obtain stream type id and pass it to cursor
5869: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
5870: p_primary_sty_purpose => 'RENT',
5871: p_dependent_sty_purpose => 'LEASE_INCOME',
5872: x_return_status => l_return_status,
5873: x_dependent_sty_id => l_stream_type_id);

Line 9795: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9791: END IF;
9792:
9793: --PAGARG 19-Nov-2004 Bug# 4012614
9794: --UDS impact. Obtain stream type id and pass it to cursor
9795: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9796: 'RENT',
9797: l_return_status,
9798: l_sty_id);
9799:

Line 9819: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

9815: CLOSE l_unbill_stream_csr;
9816: END IF;
9817:
9818: --06-Dec-2004 PAGARG Bug# 3948473 Pass investor agreement id to obtain stream id
9819: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
9820: 'INVESTOR_RENT_DISB_BASIS',
9821: l_return_status,
9822: l_sty_id);
9823:

Line 9968: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

9964: -- Calculate result
9965: -- ****************
9966: --PAGARG 19-Nov-2004 Bug# 4012614
9967: --UDS impact. Obtain stream type id and pass it to cursor
9968: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
9969: 'RESIDUAL_VALUE',
9970: l_return_status,
9971: l_sty_id);
9972:

Line 10219: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,

10215: END IF;
10216:
10217: --PAGARG 19-Nov-2004 Bug# 4012614
10218: --UDS impact. Obtain stream type id and pass it to cursor
10219: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,
10220: 'RENT',
10221: 'PRINCIPAL_PAYMENT',
10222: l_return_status,
10223: l_sty_id);

Line 10245: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,

10241: END IF;
10242:
10243: --PAGARG 19-Nov-2004 Bug# 4012614
10244: --UDS impact. Obtain stream type id and pass it to cursor
10245: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,
10246: 'RENT',
10247: 'INTEREST_PAYMENT',
10248: l_return_status,
10249: l_sty_id);

Line 10271: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,

10267: END IF;
10268:
10269: --PAGARG 19-Nov-2004 Bug# 4012614
10270: --UDS impact. Obtain stream type id and pass it to cursor
10271: OKL_STREAMS_UTIL.get_dependent_stream_type(p_contract_id,
10272: 'RENT',
10273: 'UNSCHEDULED_PRINCIPAL_PAYMENT',
10274: l_return_status,
10275: l_sty_id);

Line 10300: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

10296: l_unbill_loan_amount := l_unbill_principal_amount+l_unbill_interest_amount+l_unbill_ppd_amount;
10297:
10298: IF l_inv_agr_id IS NOT NULL THEN
10299: --06-Dec-2004 PAGARG Bug# 3948473 Pass investor agreement id to obtain stream id
10300: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
10301: 'INVESTOR_PRINCIPAL_DISB_BASIS',
10302: l_return_status,
10303: l_sty_id);
10304:

Line 10323: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

10319: FETCH l_undisb_rent_stream_csr INTO l_undisb_principal_amount;
10320: CLOSE l_undisb_rent_stream_csr;
10321: END IF;
10322:
10323: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
10324: 'INVESTOR_INTEREST_DISB_BASIS',
10325: l_return_status,
10326: l_sty_id);
10327:

Line 10346: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,

10342: FETCH l_undisb_rent_stream_csr INTO l_undisb_interest_amount;
10343: CLOSE l_undisb_rent_stream_csr;
10344: END IF;
10345:
10346: OKL_STREAMS_UTIL.get_primary_stream_type(l_inv_agr_id,
10347: 'INVESTOR_PPD_DISB_BASIS',
10348: l_return_status,
10349: l_sty_id);
10350:

Line 10954: okl_streams_util.get_dependent_stream_type(

10950:
10951: IF (r_subsidy_line.date_terminated IS NOT NULL) THEN
10952:
10953: /* Bug 6353756 Get dependent stream type from r_subsidy_line.sty_id */
10954: okl_streams_util.get_dependent_stream_type(
10955: p_khr_id => r_subsidy_line.chr_id,
10956: p_primary_sty_id => r_subsidy_line.sty_id,
10957: p_dependent_sty_purpose => 'SUBSIDY_INCOME',
10958: x_return_status => l_return_status,

Line 12960: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,

12956: BEGIN
12957: --PAGARG 31-Dec-2004 Bug# 4097591 Start
12958: --UDS impact. Obtain stream type id and pass it to cursor
12959:
12960: OKL_STREAMS_UTIL.get_primary_stream_type(p_contract_id,
12961: 'RENT',
12962: l_return_status,
12963: l_stream_type_id);
12964:

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

13373: x_msg_data => l_msg_data,
13374: p_contract_id => p_contract_id,
13375: x_rep_product_id => lx_rep_product_id);
13376:
13377: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
13378: p_product_id => lx_rep_product_id,
13379: p_primary_sty_purpose => 'RENT',
13380: p_dependent_sty_purpose => 'LEASE_INCOME',
13381: x_return_status => l_return_status,

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

13390: ELSE
13391: -- sechawla 05-dec-07 6671849 -- START
13392: --PAGARG 31-Dec-2004 Bug# 4097591 Start
13393: --UDS impact. Obtain stream type id and pass it to cursor
13394: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => p_contract_id,
13395: p_primary_sty_purpose => 'RENT',
13396: p_dependent_sty_purpose => 'LEASE_INCOME',
13397: x_return_status => l_return_status,
13398: x_dependent_sty_id => l_stream_type_id);

Line 13770: OKL_STREAMS_UTIL.get_dependent_stream_type(

13766: AND lalevl.rgd_code = 'LALEVL'
13767: AND lalevl.id = laslh.rgp_id
13768: AND laslh.rule_information_category = 'LASLH';
13769:
13770: OKL_STREAMS_UTIL.get_dependent_stream_type(
13771: p_khr_id => p_contract_id,
13772: p_primary_sty_id => l_fee_payment_id,
13773: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
13774: x_return_status => l_return_status,