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_LA_STREAM_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 9586: OKL_ST_GEN_TMPT_SETS gts

9582: FROM
9583: okl_k_headers khr,
9584: okl_products_v pdt,
9585: okl_ae_tmpt_sets_v aes,
9586: OKL_ST_GEN_TMPT_SETS gts
9587: WHERE
9588: khr.pdt_id = pdt.id AND
9589: pdt.aes_id = aes.id AND
9590: aes.gts_id = gts.id AND

Line 9601: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

9597: --End of modification for Bug#3320656 BAKUCHIB Modified
9598: -- Rollover modification by HKPATEL
9599: link_rollover_rec link_rollover_csr%ROWTYPE;
9600: -- Rollover modification ends here
9601: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
9602: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
9603:
9604: -- gboomina Bug 4746368 - Added - Start
9605: -- Condition added to the cursor by kthiruva on 09-Feb-2006

Line 9602: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

9598: -- Rollover modification by HKPATEL
9599: link_rollover_rec link_rollover_csr%ROWTYPE;
9600: -- Rollover modification ends here
9601: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
9602: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
9603:
9604: -- gboomina Bug 4746368 - Added - Start
9605: -- Condition added to the cursor by kthiruva on 09-Feb-2006
9606: --Only disbursement and processing fee details specified in Base Term should be picked

Line 11962: OKL_ST_GEN_TMPT_SETS gts

11958: FROM
11959: okl_k_headers khr,
11960: okl_products_v pdt,
11961: okl_ae_tmpt_sets_v aes,
11962: OKL_ST_GEN_TMPT_SETS gts
11963: WHERE
11964: khr.pdt_id = pdt.id AND
11965: pdt.aes_id = aes.id AND
11966: aes.gts_id = gts.id AND

Line 11969: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

11965: pdt.aes_id = aes.id AND
11966: aes.gts_id = gts.id AND
11967: khr.id = p_chr_id;
11968:
11969: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
11970: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
11971:
11972: --Added by kthiruva on 13-Sep-2005 for the VR build
11973: --The base rate defined on the contract is captured when the payment type is Principal

Line 11970: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

11966: aes.gts_id = gts.id AND
11967: khr.id = p_chr_id;
11968:
11969: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
11970: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
11971:
11972: --Added by kthiruva on 13-Sep-2005 for the VR build
11973: --The base rate defined on the contract is captured when the payment type is Principal
11974: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,

Line 13146: OKL_ST_GEN_TMPT_SETS gts

13142: FROM
13143: okl_k_headers khr,
13144: okl_products_v pdt,
13145: okl_ae_tmpt_sets_v aes,
13146: OKL_ST_GEN_TMPT_SETS gts
13147: WHERE
13148: khr.pdt_id = pdt.id AND
13149: pdt.aes_id = aes.id AND
13150: aes.gts_id = gts.id AND

Line 13194: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;

13190: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
13191: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
13192: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
13193: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
13194: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
13195:
13196: --mansrini : Code for VR build
13197: CURSOR get_day_conv_on_contrct
13198: IS

Line 13217: OKL_ST_GEN_TMPT_SETS gts

13213: FROM
13214: okl_k_headers khr,
13215: okl_products_v pdt,
13216: okl_ae_tmpt_sets_v aes,
13217: OKL_ST_GEN_TMPT_SETS gts
13218: WHERE
13219: khr.pdt_id = pdt.id AND
13220: pdt.aes_id = aes.id AND
13221: aes.gts_id = gts.id AND

Line 13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

13220: pdt.aes_id = aes.id AND
13221: aes.gts_id = gts.id AND
13222: khr.id = p_chr_id;
13223:
13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

Line 13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

13221: aes.gts_id = gts.id AND
13222: khr.id = p_chr_id;
13223:
13224: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13225: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13226: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
13227: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
13228: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
13229: l_variable_rate okl_sif_fees.rate%TYPE;

Line 15269: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;

15265: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
15266: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
15267: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15268: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
15269: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
15270:
15271: --mansrini : Code for VR build
15272: CURSOR get_day_conv_on_contrct
15273: IS

Line 15292: OKL_ST_GEN_TMPT_SETS gts

15288: FROM
15289: okl_k_headers khr,
15290: okl_products_v pdt,
15291: okl_ae_tmpt_sets_v aes,
15292: OKL_ST_GEN_TMPT_SETS gts
15293: WHERE
15294: khr.pdt_id = pdt.id AND
15295: pdt.aes_id = aes.id AND
15296: aes.gts_id = gts.id AND

Line 15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

15295: pdt.aes_id = aes.id AND
15296: aes.gts_id = gts.id AND
15297: khr.id = p_chr_id;
15298:
15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

Line 15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

15296: aes.gts_id = gts.id AND
15297: khr.id = p_chr_id;
15298:
15299: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15300: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15301: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15302: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15303: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15304: l_variable_rate okl_sif_fees.rate%TYPE;

Line 17766: OKL_ST_GEN_TMPT_SETS gts

17762: FROM
17763: okl_k_headers khr,
17764: okl_products_v pdt,
17765: okl_ae_tmpt_sets_v aes,
17766: OKL_ST_GEN_TMPT_SETS gts
17767: WHERE
17768: khr.pdt_id = pdt.id AND
17769: pdt.aes_id = aes.id AND
17770: aes.gts_id = gts.id AND

Line 17828: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

17824: l_strm_name_rec strm_name_csr_lease%ROWTYPE;
17825: l_ib_rec ib_csr_lease%ROWTYPE;
17826: l_strmid_rec l_strmid_csr_lease%ROWTYPE;
17827: l_adrconv_rec l_adrconv_csr%ROWTYPE;
17828: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17829: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17830:
17831: -- Start fix for bug 6858487
17832: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 17829: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

17825: l_ib_rec ib_csr_lease%ROWTYPE;
17826: l_strmid_rec l_strmid_csr_lease%ROWTYPE;
17827: l_adrconv_rec l_adrconv_csr%ROWTYPE;
17828: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17829: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17830:
17831: -- Start fix for bug 6858487
17832: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
17833: l_orig_cle_id OKC_K_LINES_B.ID%TYPE;

Line 20388: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;

20384:
20385:
20386: i NUMBER;
20387: l_strms_rec strms_csr%ROWTYPE;
20388: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
20389:
20390: BEGIN
20391: --Added by kthiruva for Debugging
20392: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 22246: OKL_ST_GEN_TMPT_SETS gts

22242: FROM
22243: okl_k_headers khr,
22244: okl_products_v pdt,
22245: okl_ae_tmpt_sets_v aes,
22246: OKL_ST_GEN_TMPT_SETS gts
22247: WHERE
22248: khr.pdt_id = pdt.id AND
22249: pdt.aes_id = aes.id AND
22250: aes.gts_id = gts.id AND

Line 22253: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

22249: pdt.aes_id = aes.id AND
22250: aes.gts_id = gts.id AND
22251: khr.id = p_chr_id;
22252:
22253: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
22254: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
22255:
22256: BEGIN
22257: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 22254: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

22250: aes.gts_id = gts.id AND
22251: khr.id = p_chr_id;
22252:
22253: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
22254: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
22255:
22256: BEGIN
22257: x_return_status := OKL_API.G_RET_STS_SUCCESS;
22258: -- Call start_activity to create savepoint, check compatibility