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 OKC_K_HEADERS_B

Line 45: contract_number okc_k_headers_b.contract_number%TYPE

41:
42: TYPE error_msg_tbl_type is TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
43:
44: TYPE rpt_error_rec_type IS RECORD (
45: contract_number okc_k_headers_b.contract_number%TYPE
46: ,product_name okl_products.name%TYPE
47: ,interest_calc_basis fnd_lookup_values.lookup_code%TYPE
48: ,last_int_calc_date DATE
49: ,error_msg_tbl error_msg_tbl_type);

Line 56: contract_id okc_k_headers_b.id%TYPE

52: g_rpt_error_tbl rpt_error_tbl_type;
53: g_rpt_error_tbl_counter BINARY_INTEGER := 0;
54:
55: TYPE rpt_success_rec_type IS RECORD (
56: contract_id okc_k_headers_b.id%TYPE
57: ,contract_number okc_k_headers_b.contract_number%TYPE
58: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
59: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
60:

Line 57: ,contract_number okc_k_headers_b.contract_number%TYPE

53: g_rpt_error_tbl_counter BINARY_INTEGER := 0;
54:
55: TYPE rpt_success_rec_type IS RECORD (
56: contract_id okc_k_headers_b.id%TYPE
57: ,contract_number okc_k_headers_b.contract_number%TYPE
58: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
59: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
60:
61: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;

Line 590: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

586: l_index NUMBER;
587: l_rec_count NUMBER;
588: l_no_of_days NUMBER;
589: l_counter NUMBER;
590: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
593: l_icb_counter VARCHAR2(30);
594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;

Line 591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;

587: l_rec_count NUMBER;
588: l_no_of_days NUMBER;
589: l_counter NUMBER;
590: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
593: l_icb_counter VARCHAR2(30);
594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
595: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;

Line 592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;

588: l_no_of_days NUMBER;
589: l_counter NUMBER;
590: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
591: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
592: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
593: l_icb_counter VARCHAR2(30);
594: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
595: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
596: l_separator VARCHAR2(1);

Line 626: okc_k_headers_b chr,

622: cle.name asset_number,
623: DECODE(NVL(vip.catchup_amt,0),0,' ',OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.catchup_amt,0),chr.currency_code)) catchup_amt,
624: vip.catchup_settlement_code
625: FROM okl_var_int_params vip,
626: okc_k_headers_b chr,
627: okc_k_lines_v cle
628: WHERE chr.id = p_contract_id
629: AND vip.khr_id = chr.id
630: AND vip.request_id = g_request_id

Line 656: okc_k_headers_b chr

652: SUM(NVL(vip.interest_amt,0)) interest_amt,
653: vip.interest_calc_days,
654: chr.currency_code
655: FROM okl_var_int_params vip,
656: okc_k_headers_b chr
657: WHERE vip.khr_id = p_contract_id
658: AND chr.id = vip.khr_id
659: AND vip.request_id = g_request_id
660: GROUP BY vip.interest_calc_start_date, vip.interest_calc_end_date, vip.interest_rate, vip.interest_calc_days, chr.currency_code

Line 2788: FROM okc_k_headers_b

2784: AND stm.sty_id = sty.id
2785: AND (sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL' OR sty.stream_type_purpose = 'DAILY_INTEREST_INTEREST');
2786:
2787: CURSOR c_khr_start_date_csr(cp_khr_id NUMBER) IS SELECT start_date - 1
2788: FROM okc_k_headers_b
2789: WHERE id = cp_khr_id;
2790:
2791: BEGIN
2792: OPEN c_int_calc_date_csr(p_khr_id);

Line 2990: , okc_k_headers_b chr

2986: , ppm.quality_val interest_calculation_basis
2987: , NULL pay_freq
2988: FROM okl_k_rate_params krp
2989: , okl_k_headers khr
2990: , okc_k_headers_b chr
2991: , okl_prod_qlty_val_uv ppm
2992: WHERE krp.rowid = cp_rate_param_rowid
2993: AND krp.khr_id = khr.id
2994: AND khr.id = chr.id

Line 3076: FROM okc_k_headers_b chr,

3072: l_icx_date_format VARCHAR2(240);
3073:
3074: CURSOR c_last_interest_calc_date(p_khr_id NUMBER) IS
3075: SELECT NVL(khr.date_last_interim_interest_cal, chr.start_date) last_interest_calc_date
3076: FROM okc_k_headers_b chr,
3077: okl_k_headers khr
3078: WHERE chr.id = p_khr_id
3079: AND khr.id = chr.id;
3080:

Line 4466: FROM okc_k_headers_b chrb,

4462:
4463: --checks for online rebook
4464: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4465: SELECT 'Y' return_value
4466: FROM okc_k_headers_b chrb,
4467: okc_k_headers_b chrb2,
4468: okl_trx_contracts ktrx
4469: WHERE ktrx.khr_id_old = chrb.id
4470: AND ktrx.tsu_code = 'PROCESSED'

Line 4467: okc_k_headers_b chrb2,

4463: --checks for online rebook
4464: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4465: SELECT 'Y' return_value
4466: FROM okc_k_headers_b chrb,
4467: okc_k_headers_b chrb2,
4468: okl_trx_contracts ktrx
4469: WHERE ktrx.khr_id_old = chrb.id
4470: AND ktrx.tsu_code = 'PROCESSED'
4471: AND ktrx.rbr_code IS NOT NULL

Line 4885: FROM okc_k_headers_b chrb,

4881: --get the id's of Rebook Transactions
4882: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4883: SELECT ktrx.id source_id
4884: ,'OKL_TRX_CONTRACTS' source_table
4885: FROM okc_k_headers_b chrb,
4886: okc_k_headers_b chrb2,
4887: okl_trx_contracts ktrx
4888: WHERE ktrx.khr_id_old = chrb.id
4889: AND ktrx.tsu_code = 'PROCESSED'

Line 4886: okc_k_headers_b chrb2,

4882: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4883: SELECT ktrx.id source_id
4884: ,'OKL_TRX_CONTRACTS' source_table
4885: FROM okc_k_headers_b chrb,
4886: okc_k_headers_b chrb2,
4887: okl_trx_contracts ktrx
4888: WHERE ktrx.khr_id_old = chrb.id
4889: AND ktrx.tsu_code = 'PROCESSED'
4890: AND ktrx.rbr_code IS NOT NULL

Line 6481: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

6477: --Bug# 13026821
6478:
6479: --Bug# 7277007
6480: l_counter NUMBER;
6481: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
6482: l_product_name OKL_PRODUCTS.name%TYPE;
6483:
6484: CURSOR c_var_int_params_csr(p_chr_id IN NUMBER,
6485: p_req_id IN NUMBER) IS

Line 6514: FROM okc_k_headers_b chr,

6510: khr.pdt_id,
6511: --Bug# 7277007
6512: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts, --- Added as part of Bug# 14119181
6513: ppm.name product_name
6514: FROM okc_k_headers_b chr,
6515: okl_k_headers khr,
6516: okc_statuses_b khs,
6517: okl_product_parameters_v ppm,
6518: hz_cust_accounts hca --- Added as part of Bug# 14119181