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

Line 263: l_id_tbl okl_streams_util.NumberTabTyp;

259: and say_code=p_say_code
260: and nvl(purpose_code,'XXX') = nvl(p_purpose_code,'XXX') ; --sechawla 9-mar-09 MG Impact on IA : added
261:
262:
263: l_id_tbl okl_streams_util.NumberTabTyp;
264: j NUMBER := 0;
265:
266: -- declaration of a parameterized cursor by zrehman on 12-Sep-2006
267: --sechawla 9-mar-09 MG Impact on IA prefixed curosr parameters with cp, to avoid conflict with column names

Line 382: l_rep_id_tbl okl_streams_util.NumberTabTyp;

378: lx_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
379: l_rep_sty_id NUMBER;
380: rep_stream_type_purpose VARCHAR2(30);
381: l_api_version CONSTANT NUMBER := 1.0;
382: l_rep_id_tbl okl_streams_util.NumberTabTyp;
383:
384: BEGIN
385: x_return_status := OKL_API.G_RET_STS_SUCCESS;
386: -- Call start_activity to create savepoint, check compatibility

Line 656: OKL_STREAMS_UTIL.get_primary_stream_type

652: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end --------------
653:
654:
655: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
656: OKL_STREAMS_UTIL.get_primary_stream_type
657: (
658: p_khr_id => l_contracts_csr.khr_id,
659: p_primary_sty_purpose => l_investor_rental_accrual,
660: x_return_status => l_return_status,

Line 690: OKL_STREAMS_UTIL.get_primary_stream_type_rep

686: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
687: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
688: IF lx_rep_product IS NOT NULL THEN
689: IF lx_rep_deal_type = 'LEASEOP' THEN
690: OKL_STREAMS_UTIL.get_primary_stream_type_rep
691: (
692: p_khr_id => l_contracts_csr.khr_id,
693: p_primary_sty_purpose => l_investor_rental_accrual,
694: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 712: OKL_STREAMS_UTIL.get_primary_stream_type_rep

708: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
709: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
710: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon rebook
711: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
712: OKL_STREAMS_UTIL.get_primary_stream_type_rep
713: (
714: p_khr_id => l_contracts_csr.khr_id,
715: p_primary_sty_purpose => l_investor_pre_tax_income,
716: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 739: OKL_STREAMS_UTIL.get_primary_stream_type

735: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end -----
736:
737:
738: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
739: OKL_STREAMS_UTIL.get_primary_stream_type
740: (
741: p_khr_id => l_contracts_csr.khr_id,
742: p_primary_sty_purpose => l_investor_pre_tax_income,
743: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 775: OKL_STREAMS_UTIL.get_primary_stream_type_rep

771: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
772: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
773: IF lx_rep_product IS NOT NULL THEN
774: IF lx_rep_deal_type = 'LEASEOP' THEN
775: OKL_STREAMS_UTIL.get_primary_stream_type_rep
776: (
777: p_khr_id => l_contracts_csr.khr_id,
778: p_primary_sty_purpose => l_investor_rental_accrual,
779: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 797: OKL_STREAMS_UTIL.get_primary_stream_type_rep

793: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
794: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
795: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
796: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
797: OKL_STREAMS_UTIL.get_primary_stream_type_rep
798: (
799: p_khr_id => l_contracts_csr.khr_id,
800: p_primary_sty_purpose => l_investor_pre_tax_income,
801: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 832: OKL_STREAMS_UTIL.get_primary_stream_type

828: Start Changes
829: */
830: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
831: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
832: OKL_STREAMS_UTIL.get_primary_stream_type
833: (
834: p_khr_id => l_contracts_csr.khr_id,
835: p_primary_sty_purpose => l_inv_interest_income_accrual,
836: x_return_status => l_return_status,

Line 1841: OKL_STREAMS_UTIL.get_primary_stream_type

1837: Start Changes
1838: */
1839: --get sty_id for the contract based on deal type
1840: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
1841: OKL_STREAMS_UTIL.get_primary_stream_type
1842: (
1843: p_khr_id => l_contracts_csr.khr_id,
1844: p_primary_sty_purpose => l_investor_rental_accrual,
1845: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of OP lease contract

Line 1887: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1883: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
1884: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
1885: IF lx_rep_product IS NOT NULL THEN
1886: IF lx_rep_deal_type = 'LEASEOP' THEN
1887: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1888: (
1889: p_khr_id => l_contracts_csr.khr_id,
1890: p_primary_sty_purpose => l_investor_rental_accrual,
1891: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 1909: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1905: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
1906: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
1907: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
1908: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
1909: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1910: (
1911: p_khr_id => l_contracts_csr.khr_id,
1912: p_primary_sty_purpose => l_investor_pre_tax_income,
1913: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 1937: OKL_STREAMS_UTIL.get_primary_stream_type

1933:
1934:
1935: --Bug 4228708 - End of ChangesB
1936: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
1937: OKL_STREAMS_UTIL.get_primary_stream_type
1938: (
1939: p_khr_id => l_contracts_csr.khr_id,
1940: p_primary_sty_purpose => l_investor_pre_tax_income,
1941: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 1977: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1973: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
1974: -- IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
1975: IF lx_rep_product IS NOT NULL THEN
1976: IF lx_rep_deal_type = 'LEASEOP' THEN
1977: OKL_STREAMS_UTIL.get_primary_stream_type_rep
1978: (
1979: p_khr_id => l_contracts_csr.khr_id,
1980: p_primary_sty_purpose => l_investor_rental_accrual,
1981: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 1999: OKL_STREAMS_UTIL.get_primary_stream_type_rep

1995: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
1996: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
1997: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
1998: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
1999: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2000: (
2001: p_khr_id => l_contracts_csr.khr_id,
2002: p_primary_sty_purpose => l_investor_pre_tax_income,
2003: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2033: OKL_STREAMS_UTIL.get_primary_stream_type

2029: Start Changes
2030: */
2031: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
2032: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
2033: OKL_STREAMS_UTIL.get_primary_stream_type
2034: (
2035: p_khr_id => l_contracts_csr.khr_id,
2036: p_primary_sty_purpose => l_inv_interest_income_accrual,
2037: x_return_status => l_return_status,

Line 2397: OKL_STREAMS_UTIL.get_primary_stream_type

2393: Start Changes
2394: */
2395: --get sty_id for the contract based on deal type
2396: IF l_contracts_csr.deal_type = 'LEASEOP' THEN -- deal type of primary product of the contract
2397: OKL_STREAMS_UTIL.get_primary_stream_type
2398: (
2399: p_khr_id => l_contracts_csr.khr_id,
2400: p_primary_sty_purpose => l_investor_rental_accrual,
2401: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of OP lease contract

Line 2443: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2439: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
2440: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
2441: IF lx_rep_product IS NOT NULL THEN
2442: IF lx_rep_deal_type = 'LEASEOP' THEN
2443: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2444: (
2445: p_khr_id => l_contracts_csr.khr_id,
2446: p_primary_sty_purpose => l_investor_rental_accrual,
2447: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 2465: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2461: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
2462: --Rental Accrual stream is also generated for the reporting product (if OP Lease), when contract
2463: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
2464: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
2465: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2466: (
2467: p_khr_id => l_contracts_csr.khr_id,
2468: p_primary_sty_purpose => l_investor_pre_tax_income,
2469: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2491: OKL_STREAMS_UTIL.get_primary_stream_type

2487: END IF;
2488: --------------sechawla 09-mar-09 : MG Impact on Investor Agreement end -----
2489:
2490: ELSIF l_contracts_csr.deal_type IN ('LEASEDF', 'LEASEST') THEN -- deal type of primary product of the contract
2491: OKL_STREAMS_UTIL.get_primary_stream_type
2492: (
2493: p_khr_id => l_contracts_csr.khr_id,
2494: p_primary_sty_purpose => l_investor_pre_tax_income,
2495: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of DF/ST lease contract

Line 2532: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2528: ---generate Investor Rental Accrual / Pre Tax Income streams for reporting product
2529: --IF lx_rep_product IS NOT NULL AND l_sec_rep_method = 'AUTOMATED' THEN
2530: IF lx_rep_product IS NOT NULL THEN
2531: IF lx_rep_deal_type = 'LEASEOP' THEN
2532: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2533: (
2534: p_khr_id => l_contracts_csr.khr_id,
2535: p_primary_sty_purpose => l_investor_rental_accrual,
2536: --sechawla : INVESTOR_RENTAL_ACCRUAL is the primary stream type purpose on the SGT of reporing product(OP lease)

Line 2554: OKL_STREAMS_UTIL.get_primary_stream_type_rep

2550: rep_stream_type_purpose := l_rental_accrual; -- Rental Accrual for reporting product
2551: --Rental Accrual stream is generated for the reporting product (if OP Lease), when contract
2552: --is Booked. This stream is used to generate Investor Rental Accrual Stream for reporting product, upon IA activation
2553: ELSIF lx_rep_deal_type IN ('LEASEDF', 'LEASEST') THEN
2554: OKL_STREAMS_UTIL.get_primary_stream_type_rep
2555: (
2556: p_khr_id => l_contracts_csr.khr_id,
2557: p_primary_sty_purpose => l_investor_pre_tax_income,
2558: --INVESTOR_PRE_TAX_INCOME is the primary stream type purpose on the SGT of reporting product (DF/ST)

Line 2589: OKL_STREAMS_UTIL.get_primary_stream_type

2585: Start Changes
2586: */
2587: ---sechawla 09-mar-09 : MG Impact on Investor Agreement : No impacts on Loans
2588: ELSIF l_contracts_csr.deal_type IN ('LOAN', 'LOAN-REVOLVING') THEN
2589: OKL_STREAMS_UTIL.get_primary_stream_type
2590: (
2591: p_khr_id => l_contracts_csr.khr_id,
2592: p_primary_sty_purpose => l_inv_interest_income_accrual,
2593: x_return_status => l_return_status,