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 2596: FROM okl_st_gen_tmpt_sets tst,

2592:
2593: CURSOR c_arrears_option_at_sgt_csr (p_pdt_id NUMBER)
2594: IS
2595: SELECT tst.isg_arrears_pay_dates_option
2596: FROM okl_st_gen_tmpt_sets tst,
2597: okl_ae_tmpt_sets aes,
2598: okl_products pdt
2599: WHERE pdt.id = p_pdt_id
2600: AND aes.id = pdt.aes_id

Line 11174: OKL_ST_GEN_TMPT_SETS gts

11170: FROM
11171: okl_k_headers khr,
11172: okl_products_v pdt,
11173: okl_ae_tmpt_sets_v aes,
11174: OKL_ST_GEN_TMPT_SETS gts
11175: WHERE
11176: khr.pdt_id = pdt.id AND
11177: pdt.aes_id = aes.id AND
11178: aes.gts_id = gts.id AND

Line 11189: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

11185: --End of modification for Bug#3320656 BAKUCHIB Modified
11186: -- Rollover modification by HKPATEL
11187: link_rollover_rec link_rollover_csr%ROWTYPE;
11188: -- Rollover modification ends here
11189: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
11190: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
11191:
11192: -- gboomina Bug 4746368 - Added - Start
11193: -- Condition added to the cursor by kthiruva on 09-Feb-2006

Line 11190: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

11186: -- Rollover modification by HKPATEL
11187: link_rollover_rec link_rollover_csr%ROWTYPE;
11188: -- Rollover modification ends here
11189: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
11190: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
11191:
11192: -- gboomina Bug 4746368 - Added - Start
11193: -- Condition added to the cursor by kthiruva on 09-Feb-2006
11194: --Only disbursement and processing fee details specified in Base Term should be picked

Line 13892: OKL_ST_GEN_TMPT_SETS gts

13888: FROM
13889: okl_k_headers khr,
13890: okl_products_v pdt,
13891: okl_ae_tmpt_sets_v aes,
13892: OKL_ST_GEN_TMPT_SETS gts
13893: WHERE
13894: khr.pdt_id = pdt.id AND
13895: pdt.aes_id = aes.id AND
13896: aes.gts_id = gts.id AND

Line 13899: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

13895: pdt.aes_id = aes.id AND
13896: aes.gts_id = gts.id AND
13897: khr.id = p_chr_id;
13898:
13899: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13900: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13901:
13902: --Added by kthiruva on 13-Sep-2005 for the VR build
13903: --The base rate defined on the contract is captured when the payment type is Principal

Line 13900: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

13896: aes.gts_id = gts.id AND
13897: khr.id = p_chr_id;
13898:
13899: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
13900: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
13901:
13902: --Added by kthiruva on 13-Sep-2005 for the VR build
13903: --The base rate defined on the contract is captured when the payment type is Principal
13904: CURSOR get_base_rate_csr(p_chr_id IN NUMBER,

Line 15249: OKL_ST_GEN_TMPT_SETS gts

15245: FROM
15246: okl_k_headers khr,
15247: okl_products_v pdt,
15248: okl_ae_tmpt_sets_v aes,
15249: OKL_ST_GEN_TMPT_SETS gts
15250: WHERE
15251: khr.pdt_id = pdt.id AND
15252: pdt.aes_id = aes.id AND
15253: aes.gts_id = gts.id AND

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

15293: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
15294: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
15295: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15296: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
15297: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
15298:
15299: --mansrini : Code for VR build
15300: CURSOR get_day_conv_on_contrct
15301: IS

Line 15320: OKL_ST_GEN_TMPT_SETS gts

15316: FROM
15317: okl_k_headers khr,
15318: okl_products_v pdt,
15319: okl_ae_tmpt_sets_v aes,
15320: OKL_ST_GEN_TMPT_SETS gts
15321: WHERE
15322: khr.pdt_id = pdt.id AND
15323: pdt.aes_id = aes.id AND
15324: aes.gts_id = gts.id AND

Line 15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

15323: pdt.aes_id = aes.id AND
15324: aes.gts_id = gts.id AND
15325: khr.id = p_chr_id;
15326:
15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

Line 15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

15324: aes.gts_id = gts.id AND
15325: khr.id = p_chr_id;
15326:
15327: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
15328: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
15329: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
15330: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
15331: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
15332: l_variable_rate okl_sif_fees.rate%TYPE;

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

17578: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
17579: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
17580: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
17581: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
17582: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
17583:
17584: --mansrini : Code for VR build
17585: CURSOR get_day_conv_on_contrct
17586: IS

Line 17605: OKL_ST_GEN_TMPT_SETS gts

17601: FROM
17602: okl_k_headers khr,
17603: okl_products_v pdt,
17604: okl_ae_tmpt_sets_v aes,
17605: OKL_ST_GEN_TMPT_SETS gts
17606: WHERE
17607: khr.pdt_id = pdt.id AND
17608: pdt.aes_id = aes.id AND
17609: aes.gts_id = gts.id AND

Line 17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

17608: pdt.aes_id = aes.id AND
17609: aes.gts_id = gts.id AND
17610: khr.id = p_chr_id;
17611:
17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;

Line 17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

17609: aes.gts_id = gts.id AND
17610: khr.id = p_chr_id;
17611:
17612: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
17613: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
17614: l_number_periods_remaining okl_sif_fees.number_of_periods%TYPE;
17615: l_number_periods_completed okl_sif_fees.number_of_periods%TYPE;
17616: l_number_periods_completed_cpy okl_sif_fees.number_of_periods%TYPE;
17617: l_variable_rate okl_sif_fees.rate%TYPE;

Line 20125: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%TYPE;

20121: l_sub_override_amt OKL_K_LINES.SUBSIDY_OVERRIDE_AMOUNT%TYPE := 0;
20122: l_down_payment_amt NUMBER; --Added by bkatraga for bug 15942693
20123:
20124: --Added by bkatraga for bug 14822974
20125: l_arrears_pay_dates_option okl_st_gen_tmpt_sets_all.isg_arrears_pay_dates_option%TYPE;
20126: l_adv_arrears okc_rules_b.rule_information10%TYPE;
20127:
20128: CURSOR l_adv_arrears_csr (p_khr_id in NUMBER, p_cle_id in NUMBER) is
20129: select nvl( sll_rulb.rule_information10,'N') advance_or_arrears

Line 20404: OKL_ST_GEN_TMPT_SETS gts

20400: FROM
20401: okl_k_headers khr,
20402: okl_products_v pdt,
20403: okl_ae_tmpt_sets_v aes,
20404: OKL_ST_GEN_TMPT_SETS gts
20405: WHERE
20406: khr.pdt_id = pdt.id AND
20407: pdt.aes_id = aes.id AND
20408: aes.gts_id = gts.id AND

Line 20466: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

20462: l_strm_name_rec strm_name_csr_lease%ROWTYPE;
20463: l_ib_rec ib_csr_lease%ROWTYPE;
20464: l_strmid_rec l_strmid_csr_lease%ROWTYPE;
20465: l_adrconv_rec l_adrconv_csr%ROWTYPE;
20466: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
20467: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
20468:
20469: -- Start fix for bug 6858487
20470: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 20467: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

20463: l_ib_rec ib_csr_lease%ROWTYPE;
20464: l_strmid_rec l_strmid_csr_lease%ROWTYPE;
20465: l_adrconv_rec l_adrconv_csr%ROWTYPE;
20466: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
20467: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
20468:
20469: -- Start fix for bug 6858487
20470: l_orig_chr_id OKC_K_HEADERS_B.ID%TYPE;
20471: l_orig_cle_id OKC_K_LINES_B.ID%TYPE;

Line 23196: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;

23192:
23193:
23194: i NUMBER;
23195: l_strms_rec strms_csr%ROWTYPE;
23196: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
23197:
23198: cursor get_rebook_type is
23199: select nvl(amort_inc_adj_rev_dt_yn, 'N')
23200: from okl_sys_acct_opts;

Line 25089: OKL_ST_GEN_TMPT_SETS gts

25085: FROM
25086: okl_k_headers khr,
25087: okl_products_v pdt,
25088: okl_ae_tmpt_sets_v aes,
25089: OKL_ST_GEN_TMPT_SETS gts
25090: WHERE
25091: khr.pdt_id = pdt.id AND
25092: pdt.aes_id = aes.id AND
25093: aes.gts_id = gts.id AND

Line 25096: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;

25092: pdt.aes_id = aes.id AND
25093: aes.gts_id = gts.id AND
25094: khr.id = p_chr_id;
25095:
25096: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
25097: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
25098:
25099: BEGIN
25100: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 25097: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;

25093: aes.gts_id = gts.id AND
25094: khr.id = p_chr_id;
25095:
25096: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code%type;
25097: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%type;
25098:
25099: BEGIN
25100: x_return_status := OKL_API.G_RET_STS_SUCCESS;
25101: -- Call start_activity to create savepoint, check compatibility