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 52: contract_number okc_k_headers_b.contract_number%TYPE

48:
49: TYPE error_msg_tbl_type is TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
50:
51: TYPE rpt_error_rec_type IS RECORD (
52: contract_number okc_k_headers_b.contract_number%TYPE
53: ,product_name okl_products.name%TYPE
54: ,interest_calc_basis fnd_lookup_values.lookup_code%TYPE
55: ,last_int_calc_date DATE
56: ,error_msg_tbl error_msg_tbl_type);

Line 63: contract_id okc_k_headers_b.id%TYPE

59: g_rpt_error_tbl rpt_error_tbl_type;
60: g_rpt_error_tbl_counter BINARY_INTEGER := 0;
61:
62: TYPE rpt_success_rec_type IS RECORD (
63: contract_id okc_k_headers_b.id%TYPE
64: ,contract_number okc_k_headers_b.contract_number%TYPE
65: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
66: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
67:

Line 64: ,contract_number okc_k_headers_b.contract_number%TYPE

60: g_rpt_error_tbl_counter BINARY_INTEGER := 0;
61:
62: TYPE rpt_success_rec_type IS RECORD (
63: contract_id okc_k_headers_b.id%TYPE
64: ,contract_number okc_k_headers_b.contract_number%TYPE
65: ,days_in_a_month_code okl_k_rate_params.days_in_a_month_code%TYPE
66: ,days_in_a_year_code okl_k_rate_params.days_in_a_year_code%TYPE);
67:
68: TYPE rpt_success_tbl_type IS TABLE OF rpt_success_rec_type INDEX BY BINARY_INTEGER;

Line 682: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

678: l_index NUMBER;
679: l_rec_count NUMBER;
680: l_no_of_days NUMBER;
681: l_counter NUMBER;
682: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
685: l_icb_counter VARCHAR2(30);
686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;

Line 683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;

679: l_rec_count NUMBER;
680: l_no_of_days NUMBER;
681: l_counter NUMBER;
682: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
685: l_icb_counter VARCHAR2(30);
686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
687: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;

Line 684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;

680: l_no_of_days NUMBER;
681: l_counter NUMBER;
682: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
683: l_contract_number1 OKC_K_HEADERS_B.contract_number%TYPE;
684: l_contract_number2 OKC_K_HEADERS_B.contract_number%TYPE;
685: l_icb_counter VARCHAR2(30);
686: l_days_in_a_month_code OKL_K_RATE_PARAMS.days_in_a_month_code%TYPE;
687: l_days_in_a_year_code OKL_K_RATE_PARAMS.days_in_a_year_code%TYPE;
688: l_separator VARCHAR2(1);

Line 708: okc_k_headers_b chr

704: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.principal_balance,0),chr.currency_code) principal_balance,
705: OKL_ACCOUNTING_UTIL.format_amount(NVL(vip.interest_amt,0),chr.currency_code) interest_amt,
706: vip.interest_calc_days
707: FROM okl_var_int_params vip,
708: okc_k_headers_b chr
709: WHERE chr.id = p_contract_id
710: AND vip.khr_id = chr.id
711: AND vip.request_id = g_request_id;
712:

Line 1501: FROM okc_k_headers_b CHR,

1497:
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:

Line 1874: l_currency_code okc_k_headers_b.currency_code%TYPE;

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:
1876: l_interest_rec interest_rec;
1877: lx_interest_rec interest_rec;
1878: ------------------------------------------------------------

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 1932: FROM okc_k_headers_b chr

1928: ,khr.deal_type
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:

Line 2270: l_curr_code okc_k_headers_b.currency_code%TYPE;

2266: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
2267: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
2268: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
2269:
2270: l_curr_code okc_k_headers_b.currency_code%TYPE;
2271: l_ste_amount okl_strm_elements.amount%type;
2272:
2273:
2274: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

Line 2302: FROM okc_k_headers_b chr,

2298: khr.deal_type,
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

Line 2668: FROM okc_k_headers_b CHR

2664: INTO
2665: i_taiv_rec.currency_code
2666: ,i_taiv_rec.org_id
2667: ,i_taiv_rec.set_of_books_id
2668: FROM okc_k_headers_b CHR
2669: ,hr_operating_units hru
2670: WHERE CHR.id = r_contracts_csr.khr_id
2671: AND hru.organization_id = CHR.authoring_org_id;
2672:

Line 5324: FROM okc_k_headers_b

5320: AND stm.sty_id = sty.id
5321: AND (sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL' OR sty.stream_type_purpose = 'DAILY_INTEREST_INTEREST');
5322:
5323: CURSOR c_khr_start_date_csr(cp_khr_id NUMBER) IS SELECT start_date - 1
5324: FROM okc_k_headers_b
5325: WHERE id = cp_khr_id;
5326:
5327: BEGIN
5328: OPEN c_int_calc_date_csr(p_khr_id);

Line 5406: , okc_k_headers_b chr

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
5410: AND khr.id = chr.id

Line 6709: FROM OKC_K_HEADERS_B

6705:
6706: --Added by dpsingh for LE Uptake
6707: CURSOR get_contract_number(p_khr_id NUMBER) IS
6708: SELECT CONTRACT_NUMBER
6709: FROM OKC_K_HEADERS_B
6710: WHERE ID = p_khr_id ;
6711:
6712: --Added by dpsingh for LE Uptake
6713: -- Bug 5964482 dpsingh for AE signature Uptake start

Line 6735: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

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;
6736:
6737: BEGIN
6738: print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
6739: print_debug(' p_contract_id : '|| p_contract_id );

Line 7775: FROM okc_k_headers_b chrb,

7771:
7772: --checks for online rebook
7773: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
7774: SELECT 'Y' return_value
7775: FROM okc_k_headers_b chrb,
7776: okc_k_headers_b chrb2,
7777: okl_trx_contracts ktrx
7778: WHERE ktrx.khr_id_old = chrb.id
7779: AND ktrx.tsu_code = 'PROCESSED'

Line 7776: okc_k_headers_b chrb2,

7772: --checks for online rebook
7773: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
7774: SELECT 'Y' return_value
7775: FROM okc_k_headers_b chrb,
7776: okc_k_headers_b chrb2,
7777: okl_trx_contracts ktrx
7778: WHERE ktrx.khr_id_old = chrb.id
7779: AND ktrx.tsu_code = 'PROCESSED'
7780: AND ktrx.rbr_code IS NOT NULL

Line 8064: FROM okc_k_headers_b chrb,

8060: --get the id's of Rebook Transactions
8061: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
8062: SELECT ktrx.id source_id
8063: ,'OKL_TRX_CONTRACTS' source_table
8064: FROM okc_k_headers_b chrb,
8065: okc_k_headers_b chrb2,
8066: okl_trx_contracts ktrx
8067: WHERE ktrx.khr_id_old = chrb.id
8068: AND ktrx.tsu_code = 'PROCESSED'

Line 8065: okc_k_headers_b chrb2,

8061: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
8062: SELECT ktrx.id source_id
8063: ,'OKL_TRX_CONTRACTS' source_table
8064: FROM okc_k_headers_b chrb,
8065: okc_k_headers_b chrb2,
8066: okl_trx_contracts ktrx
8067: WHERE ktrx.khr_id_old = chrb.id
8068: AND ktrx.tsu_code = 'PROCESSED'
8069: AND ktrx.rbr_code IS NOT NULL

Line 9012: l_currency_code okc_k_headers_b.currency_code%type;

9008: l_stub_start_date DATE;
9009: l_stub_days NUMBER;
9010: l_stub_amount NUMBER;
9011: l_ret_val VARCHAR2(1);
9012: l_currency_code okc_k_headers_b.currency_code%type;
9013:
9014: --get the line id for the repriced rent from supertrump
9015: FUNCTION get_kle_id(p_trx_number IN NUMBER,
9016: p_index_number IN NUMBER,

Line 10224: l_contract_number okc_k_headers_b.contract_number%type;

10220: l_adder_months NUMBER := 0;
10221: l_interest_rate_tbl interest_rate_tbl_type;
10222: l_interest_rate_tbl_count NUMBER;
10223: l_interest_rate_tbl_index NUMBER;
10224: l_contract_number okc_k_headers_b.contract_number%type;
10225: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
10226: l_total_lending NUMBER;
10227:
10228: l_rent_date_start DATE;

Line 10261: FROM okc_k_headers_b okc

10257: , okl.deal_type deal_type
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

Line 10274: okc_k_headers_b khr

10270: SELECT max(sel.stream_element_date)
10271: FROM okl_strm_elements sel,
10272: okl_streams stm,
10273: okl_strm_type_b sty,
10274: okc_k_headers_b khr
10275: WHERE stm.khr_id = p_contract_id
10276: AND stm.active_yn = 'Y'
10277: AND stm.say_code = 'CURR'
10278: AND sty.id = stm.sty_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 11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,

11882:
11883: Cursor asset_billed_streams_csr (p_contract_id NUMBER, p_from_date DATE, p_to_date DATE) IS
11884: SELECT chrb.id contract_id, cleb.id kle_id,
11885: selb.stream_element_date, selb.amount amount
11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
11887: okc_line_styles_b lseb, okl_strm_type_b styb,
11888: okl_strm_elements selb, okl_streams stmb
11889: WHERE cleb.dnz_chr_id = chrb.id
11890: AND cleb.chr_id = chrb.id

Line 12620: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

12616: l_calculate_from_khr_start VARCHAR2(10) := 'Y';
12617:
12618: --Bug# 7277007
12619: l_counter NUMBER;
12620: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
12621: l_product_name OKL_PRODUCTS.name%TYPE;
12622:
12623: CURSOR c_var_int_params_csr(p_chr_id IN NUMBER,
12624: p_req_id IN NUMBER) IS

Line 12652: FROM okc_k_headers_b chr,

12648: chr.authoring_org_id,
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)