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_VARIABLE_INTEREST_PVT dependencies on OKL_K_HEADERS

Line 16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE

12:
13: SUBTYPE vir_tbl_type IS OKL_VIR_PVT.vir_tbl_type;
14:
15: TYPE vrc_rec_type IS RECORD (
16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE
18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE
19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE
20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE

Line 17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE

13: SUBTYPE vir_tbl_type IS OKL_VIR_PVT.vir_tbl_type;
14:
15: TYPE vrc_rec_type IS RECORD (
16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE
18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE
19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE
20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE
21: ,DAYS_IN_A_MONTH_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_MONTH_CODE%TYPE

Line 18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE

14:
15: TYPE vrc_rec_type IS RECORD (
16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE
18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE
19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE
20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE
21: ,DAYS_IN_A_MONTH_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_MONTH_CODE%TYPE
22: ,DAYS_IN_A_YEAR_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_YEAR_CODE%TYPE

Line 19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE

15: TYPE vrc_rec_type IS RECORD (
16: CONTRACT_NUMBER OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
17: ,CONTRACT_ID OKL_K_HEADERS_FULL_V.ID%TYPE
18: ,START_DATE OKL_K_HEADERS_FULL_V.START_DATE%TYPE
19: ,END_DATE OKL_K_HEADERS_FULL_V.END_DATE%TYPE
20: ,INTEREST_CALCULATION_BASIS OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE
21: ,DAYS_IN_A_MONTH_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_MONTH_CODE%TYPE
22: ,DAYS_IN_A_YEAR_CODE OKL_K_RATE_PARAMS.DAYS_IN_A_YEAR_CODE%TYPE
23: ,RATE_CHANGE_VALUE OKL_K_RATE_PARAMS.RATE_CHANGE_VALUE%TYPE

Line 357: FROM okl_k_headers_full_v

353: end_date,
354: currency_code,
355: pdt_id,
356: authoring_org_id
357: FROM okl_k_headers_full_v
358: WHERE id = p_contract_id;
359:
360: Cursor interest_params_csr (p_contract_id NUMBER) IS
361: SELECT interest_basis_code,

Line 1502: okl_k_headers khr

1498:
1499: CURSOR c_khr_type (p_khr_id NUMBER) IS
1500: SELECT khr.deal_type deal_type
1501: FROM okc_k_headers_b CHR,
1502: okl_k_headers khr
1503: WHERE khr.id = CHR.id
1504: AND khr.id = p_khr_id;
1505:
1506: c_khr_type_rec c_khr_type%ROWTYPE;

Line 1871: l_deal_type okl_k_headers.deal_type%TYPE;

1867: l_year_days VARCHAR2(20) := '0';
1868: l_contract_start_date DATE;
1869: l_contract_end_date DATE;
1870: l_interest_amount NUMBER;
1871: l_deal_type okl_k_headers.deal_type%TYPE;
1872: l_last_interim_int_cal_date DATE;
1873: l_due_date DATE;
1874: l_currency_code okc_k_headers_b.currency_code%TYPE;
1875:

Line 1915: okl_k_headers khr, okc_k_headers_b chr

1911:
1912: CURSOR c_calc_start_date (c_contract_id NUMBER)IS
1913: select min(sel.stream_element_date)
1914: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty,
1915: okl_k_headers khr, okc_k_headers_b chr
1916: WHERE stm.khr_id = c_contract_id
1917: AND stm.active_yn = 'Y'
1918: AND stm.say_code = 'CURR'
1919: AND sty.id = stm.sty_id

Line 1933: ,okl_k_headers khr

1929: ,khr.date_last_interim_interest_cal
1930: ,chr.end_date
1931: ,chr.currency_code
1932: FROM okc_k_headers_b chr
1933: ,okl_k_headers khr
1934: WHERE chr.id = c_contract_id
1935: AND khr.id = chr.id;
1936:
1937: CURSOR c_last_int_rate(c_contract_id NUMBER)IS

Line 2303: okl_k_headers khr,

2299: khr.date_last_interim_interest_cal,
2300: chr.contract_number,
2301: chr.start_date start_date
2302: FROM okc_k_headers_b chr,
2303: okl_k_headers khr,
2304: okc_statuses_b khs,
2305: okc_rules_b rules,
2306: okc_rule_groups_b rgp
2307: WHERE CHR.CONTRACT_NUMBER = NVL(l_contract_number,CHR.CONTRACT_NUMBER)

Line 2340: FROM okl_k_headers_full_v khr,

2336:
2337: --get next reamort date for a contract
2338: CURSOR l_next_reamort_date_csr(cp_khr_id IN NUMBER) IS
2339: SELECT add_months(NVL(date_last_interim_interest_cal, start_date), decode(pay_freq, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, 1)) next_reamort_date
2340: FROM okl_k_headers_full_v khr,
2341: (Select distinct rgp.dnz_chr_id khr_id
2342: ,sll.object1_id1 Pay_freq
2343: from okc_rules_b sll,
2344: okc_rules_b slh,

Line 3091: UPDATE okl_k_headers khr

3087:
3088:
3089: FND_FILE.PUT_LINE (FND_FILE.LOG, '===============================================================================');
3090:
3091: UPDATE okl_k_headers khr
3092: SET khr.date_last_interim_interest_cal = l_due_date
3093: where khr.id = r_contracts_csr.khr_id;
3094:
3095: l_last_interest_cal_date := l_due_date;

Line 3168: FROM okl_k_headers_full_v khr

3164:
3165: --Derive print lead days from receivables setup
3166: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
3167: SELECT term.printing_lead_days
3168: FROM okl_k_headers_full_v khr
3169: ,hz_customer_profiles cp
3170: ,ra_terms term
3171: WHERE khr.id = p_khr_id
3172: AND khr.bill_to_site_use_id = cp.site_use_id

Line 3466: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

3462: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3463: l_receipt_tbl receipt_tbl_type;
3464: l_rcpt_tbl_count NUMBER := 0;
3465: l_rcpt_tbl_index NUMBER := 0;
3466: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
3467: l_prev_rcpt_date DATE;
3468: l_current_rcpt_date DATE;
3469: l_total_rcpt_prin_amt NUMBER;
3470: l_current_rcpt_prin_amt NUMBER;

Line 3485: FROM okl_k_headers_full_v

3481: AND parameter_type_code = 'ACTUAL';
3482:
3483: Cursor contract_csr (p_contract_id NUMBER) IS
3484: SELECT start_date, currency_code
3485: FROM okl_k_headers_full_v
3486: WHERE khr_id = p_contract_id;
3487:
3488: Cursor sch_asset_prin_bal_stream_csr (p_contract_id NUMBER,
3489: p_line_id NUMBER,

Line 3527: FROM okl_k_headers khr,

3523:
3524: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3525: SELECT ppm.revenue_recognition_method,
3526: ppm.interest_calculation_basis
3527: FROM okl_k_headers khr,
3528: okl_product_parameters_v ppm
3529: WHERE khr.pdt_id = ppm.id
3530: AND khr.id = p_contract_id;
3531:

Line 3868: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

3864: l_principal_balance NUMBER;
3865: l_counter NUMBER := 0;
3866: l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
3867: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
3868: l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
3869: l_current_txn_date DATE;
3870:
3871: Cursor contract_csr (p_contract_id NUMBER) IS
3872: SELECT start_date, currency_code

Line 3873: FROM okl_k_headers_full_v

3869: l_current_txn_date DATE;
3870:
3871: Cursor contract_csr (p_contract_id NUMBER) IS
3872: SELECT start_date, currency_code
3873: FROM okl_k_headers_full_v
3874: WHERE khr_id = p_contract_id;
3875:
3876: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3877: SELECT ppm.revenue_recognition_method,

Line 3879: FROM okl_k_headers khr,

3875:
3876: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
3877: SELECT ppm.revenue_recognition_method,
3878: ppm.interest_calculation_basis
3879: FROM okl_k_headers khr,
3880: okl_product_parameters_v ppm
3881: WHERE khr.pdt_id = ppm.id
3882: AND khr.id = p_contract_id;
3883:

Line 4211: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

4207: l_receipt_tbl receipt_tbl_type;
4208: lx_receipt_tbl receipt_tbl_type;
4209: l_rcpt_tbl_count NUMBER := 0;
4210: l_rcpt_tbl_index NUMBER := 0;
4211: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
4212: l_prev_rcpt_date DATE;
4213: l_current_rcpt_date DATE;
4214: l_total_rcpt_prin_amt NUMBER;
4215: l_current_rcpt_prin_amt NUMBER;

Line 4232: FROM okl_k_headers_full_v

4228: AND parameter_type_code = 'ACTUAL';
4229:
4230: Cursor contract_csr (p_contract_id NUMBER) IS
4231: SELECT start_date, currency_code
4232: FROM okl_k_headers_full_v
4233: WHERE id = p_contract_id;
4234: */
4235: Cursor sch_asset_prin_balance_csr (p_contract_id NUMBER,
4236: p_line_id NUMBER,

Line 4796: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;

4792: l_start_date DATE;
4793: l_principal_balance NUMBER;
4794: l_counter NUMBER := 0;
4795: l_counter_tmp NUMBER := 0;
4796: -- l_currency_code OKL_K_HEADERS_FULL_V.currency_code%TYPE;
4797: -- l_revenue_recognition OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
4798: l_current_txn_date DATE;
4799: prin_date_range_rloan_failed EXCEPTION;
4800: l_receipt_tbl receipt_tbl_type;

Line 4809: FROM okl_k_headers_full_v

4805:
4806: /*
4807: Cursor contract_csr (p_contract_id NUMBER) IS
4808: SELECT start_date, currency_code
4809: FROM okl_k_headers_full_v
4810: WHERE id = p_contract_id;
4811:
4812: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
4813: SELECT ppm.revenue_recognition_method

Line 4814: FROM okl_k_headers khr,

4810: WHERE id = p_contract_id;
4811:
4812: Cursor revenue_recognition_csr (p_contract_id NUMBER) IS
4813: SELECT ppm.revenue_recognition_method
4814: FROM okl_k_headers khr,
4815: okl_product_parameters_v ppm
4816: WHERE khr.pdt_id = ppm.id
4817: AND khr.id = p_contract_id;
4818: */

Line 5211: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

5207:
5208: l_api_name CONSTANT VARCHAR2(30) := 'PRIN_DATE_RANGE_VAR_RATE_CTR';
5209: l_api_version CONSTANT NUMBER := 1.0;
5210: r_principal_balance_tbl principal_balance_tbl_typ ;
5211: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5212: prin_date_range_failed EXCEPTION;
5213:
5214:
5215: Cursor contract_csr (p_contract_id NUMBER) IS

Line 5217: FROM okl_k_headers_full_v

5213:
5214:
5215: Cursor contract_csr (p_contract_id NUMBER) IS
5216: SELECT deal_type
5217: FROM okl_k_headers_full_v
5218: WHERE id = p_contract_id;
5219:
5220:
5221: BEGIN

Line 5405: , okl_k_headers khr

5401: , chr.id khr_id
5402: , ppm.quality_val interest_calculation_basis
5403: , NULL pay_freq
5404: FROM okl_k_rate_params krp
5405: , okl_k_headers khr
5406: , okc_k_headers_b chr
5407: , okl_prod_qlty_val_uv ppm
5408: WHERE krp.rowid = cp_rate_param_rowid
5409: AND krp.khr_id = khr.id

Line 6731: FROM OKL_K_HEADERS

6727: ATTRIBUTE12,
6728: ATTRIBUTE13,
6729: ATTRIBUTE14,
6730: ATTRIBUTE15
6731: FROM OKL_K_HEADERS
6732: WHERE ID = p_khr_id ;
6733: -- Bug 5964482 dpsingh for AE signature Uptake end
6734: l_legal_entity_id NUMBER;
6735: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 8977: FROM okl_k_headers_full_v

8973:
8974: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
8975: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
8976: ,currency_code
8977: FROM okl_k_headers_full_v
8978: WHERE id = p_chr_id;
8979:
8980: CURSOR c_freq_cur(p_contract_id NUMBER) IS
8981: select object1_id1 from okc_rules_b

Line 9614: UPDATE okl_k_headers khr

9610:
9611: print_debug('Khr id : ' || p_chr_id || ' Frequency : ' || l_frequency);
9612: print_debug('Before updating date_last_interim_interest_cal');
9613: if(l_frequency = 'M') THEN
9614: UPDATE okl_k_headers khr
9615: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,1)
9616: where khr.id = p_chr_id;
9617: elsif(l_frequency = 'Q') THEN
9618: UPDATE okl_k_headers khr

Line 9618: UPDATE okl_k_headers khr

9614: UPDATE okl_k_headers khr
9615: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,1)
9616: where khr.id = p_chr_id;
9617: elsif(l_frequency = 'Q') THEN
9618: UPDATE okl_k_headers khr
9619: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,3)
9620: where khr.id = p_chr_id;
9621: elsif(l_frequency = 'S') THEN
9622: UPDATE okl_k_headers khr

Line 9622: UPDATE okl_k_headers khr

9618: UPDATE okl_k_headers khr
9619: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,3)
9620: where khr.id = p_chr_id;
9621: elsif(l_frequency = 'S') THEN
9622: UPDATE okl_k_headers khr
9623: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,6)
9624: where khr.id = p_chr_id;
9625: elsif(l_frequency = 'A') THEN
9626: UPDATE okl_k_headers khr

Line 9626: UPDATE okl_k_headers khr

9622: UPDATE okl_k_headers khr
9623: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,6)
9624: where khr.id = p_chr_id;
9625: elsif(l_frequency = 'A') THEN
9626: UPDATE okl_k_headers khr
9627: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,12)
9628: where khr.id = p_chr_id;
9629: end if;
9630: print_debug('After updating date_last_interim_interest_cal');

Line 10013: FROM okl_k_headers khr,

10009:
10010: /*
10011: Cursor interest_calc_basis_csr (p_contract_id NUMBER) IS
10012: SELECT ppm.interest_calculation_basis
10013: FROM okl_k_headers khr,
10014: okl_product_parameters_v ppm
10015: WHERE khr.pdt_id = ppm.id
10016: AND khr.id = p_contract_id;
10017: */

Line 10209: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;

10205: --l_interest_rec interest_rec;
10206: lx_interest_rec interest_rec;
10207: --i NUMBER:=1;
10208: --j NUMBER:=1;
10209: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
10210: l_msg_index_out NUMBER;
10211: l_term_duration NUMBER;
10212: l_tot_principal_amount NUMBER := 0;
10213: l_frequency okc_rules_b.object1_id1%type;

Line 10262: , okl_k_headers okl

10258: , ppm.quality_val interest_calculation_basis
10259: , okc.authoring_org_id
10260: , round(months_between(okc.end_date, okl.date_last_interim_interest_cal)) remaining_term_in_months
10261: FROM okc_k_headers_b okc
10262: , okl_k_headers okl
10263: , okl_prod_qlty_val_uv ppm
10264: WHERE okc.id = cp_khr_id
10265: AND okl.id = okc.id
10266: AND okl.pdt_id = ppm.pdt_id

Line 10288: FROM OKC_K_HEADERS_B K, OKL_K_HEADERS KHR

10284:
10285: CURSOR c_periods_cur(p_contract_id NUMBER, p_period_date DATE) IS
10286: SELECT (KHR.TERM_DURATION - round(months_between(nvl(p_period_date,K.START_DATE), K.START_DATE))) MTH,
10287: KHR.TERM_DURATION term_duration
10288: FROM OKC_K_HEADERS_B K, OKL_K_HEADERS KHR
10289: WHERE K.id = p_contract_id
10290: and K.id = KHR.id;
10291:
10292: CURSOR c_freq_cur(p_contract_id NUMBER) IS

Line 10306: FROM okl_k_headers_full_v

10302: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);
10303:
10304: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
10305: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
10306: FROM okl_k_headers_full_v
10307: WHERE id = p_contract_id;
10308: -- End by prasjain bug# 6142095
10309: --start | 19-May-08 cklee fixed Bug 7043360 |
10310: l_line_id_buf okl_k_lines.id%type := -1;

Line 11070: UPDATE okl_k_headers khr

11066: -- proper rate for Jan, Feb, and Mar as well. So system always need to update l_reamort_date to refect the proper rate
11067: -- month by month.
11068: --end | 30-Apr-08 cklee fixed Bug 6994233 |
11069: if(l_frequency = 'M') THEN
11070: UPDATE okl_k_headers khr
11071: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,1)
11072: where khr.id = p_khr_id;
11073: elsif(l_frequency = 'Q') THEN
11074: UPDATE okl_k_headers khr

Line 11074: UPDATE okl_k_headers khr

11070: UPDATE okl_k_headers khr
11071: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,1)
11072: where khr.id = p_khr_id;
11073: elsif(l_frequency = 'Q') THEN
11074: UPDATE okl_k_headers khr
11075: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,3)
11076: where khr.id = p_khr_id;
11077: elsif(l_frequency = 'S') THEN
11078: UPDATE okl_k_headers khr

Line 11078: UPDATE okl_k_headers khr

11074: UPDATE okl_k_headers khr
11075: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,3)
11076: where khr.id = p_khr_id;
11077: elsif(l_frequency = 'S') THEN
11078: UPDATE okl_k_headers khr
11079: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,6)
11080: where khr.id = p_khr_id;
11081: elsif(l_frequency = 'A') THEN
11082: UPDATE okl_k_headers khr

Line 11082: UPDATE okl_k_headers khr

11078: UPDATE okl_k_headers khr
11079: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,6)
11080: where khr.id = p_khr_id;
11081: elsif(l_frequency = 'A') THEN
11082: UPDATE okl_k_headers khr
11083: SET khr.date_last_interim_interest_cal = add_months(l_reamort_date,12)
11084: where khr.id = p_khr_id;
11085: end if;
11086: --start | 30-Apr-08 cklee fixed Bug 6994233 |

Line 11999: UPDATE okl_k_headers

11995: RAISE var_int_float_factor_failed;
11996: END IF;
11997: END IF;
11998:
11999: UPDATE okl_k_headers
12000: SET date_last_interim_interest_cal = l_stream_element_date
12001: WHERE id = p_contract_id;
12002:
12003: COMMIT;

Line 12032: from okl_k_headers_full_v khr

12028: select khr.date_last_interim_interest_cal date_last_interim_interest_cal
12029: , NVL(rpm.catchup_start_date, khr.start_date) catchup_start_date
12030: , NVL(rpm.catchup_frequency_code, 'MONTHLY') catchup_frequency_code
12031: , NVL(khr.date_terminated, khr.end_date) end_date
12032: from okl_k_headers_full_v khr
12033: , okl_k_rate_params rpm
12034: where khr.id = rpm.khr_id
12035: and khr.id = cp_khr_id;
12036:

Line 12653: okl_k_headers khr,

12649: khr.pdt_id,
12650: --Bug# 7277007
12651: ppm.name product_name
12652: FROM okc_k_headers_b chr,
12653: okl_k_headers khr,
12654: okc_statuses_b khs,
12655: okl_product_parameters_v ppm
12656: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
12657: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')

Line 12998: UPDATE okl_k_headers khr

12994: END IF;
12995:
12996: FND_FILE.PUT_LINE (FND_FILE.LOG, '===============================================================================');
12997:
12998: UPDATE okl_k_headers khr
12999: SET khr.date_last_interim_interest_cal = l_due_date
13000: WHERE khr.id = G_CONTRACT_ID;
13001:
13002: l_last_interest_cal_date := l_due_date;

Line 13084: UPDATE okl_k_headers khr

13080: END IF;
13081:
13082: print_debug ('Updating contract - id : '|| G_CONTRACT_ID || 'with interest calculation date : '|| l_catchup_date);
13083:
13084: UPDATE okl_k_headers khr
13085: SET khr.date_last_interim_interest_cal = l_catchup_date
13086: where khr.id = G_CONTRACT_ID;
13087:
13088: l_last_interest_cal_date := l_catchup_date;