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_VAR_PRINCIPAL_BAL_TXN

Line 7788: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7784: --
7785: AND chrb.id = cp_khr_id
7786: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
7787: AND chrb2.id = ktrx.khr_id_new
7788: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7789: WHERE vpb.khr_id = chrb.id
7790: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
7791: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7792: AND vpb.source_id = ktrx.id);

Line 7806: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7802: AND stm.sty_id = sty.id
7803: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
7804: AND stm.id = sel.stm_id
7805: AND sel.stream_element_date < cp_from_date
7806: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7807: WHERE vpb.khr_id = stm.khr_id
7808: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
7809: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7810: AND vpb.source_id = sel.id);

Line 7824: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7820: AND stm.sty_id = sty.id
7821: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
7822: AND stm.id = sel.stm_id
7823: AND sel.stream_element_date < cp_from_date
7824: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7825: WHERE vpb.khr_id = stm.khr_id
7826: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
7827: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7828: AND vpb.source_id = sel.id);

Line 7860: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7856: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT')
7857: AND to_char(tld.id) = ractrl.interface_line_attribute14
7858: AND tld.til_id_details = til.id
7859: AND til.tai_id = tai.id
7860: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7861: WHERE vpb.khr_id = tld.khr_id
7862: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
7863: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7864: AND vpb.source_id = raa.receivable_application_id)

Line 7893: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7889: AND cnsld.cnsld_ap_inv_id = to_number(ap_inv.reference_key1)
7890: AND okl_inv.funding_type_code = 'BORROWER_PAYMENT'
7891: AND ap_inv.invoice_id = iph.invoice_id
7892: AND iph.check_date < cp_from_date
7893: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7894: WHERE vpb.khr_id = okl_inv_ln.khr_id
7895: AND vpb.source_table = 'AP_INVOICE_PAYMENTS_ALL'
7896: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7897: AND vpb.source_id = iph.invoice_payment_id);

Line 7906: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

7902: SELECT 'Y' return_value
7903: FROM okl_contract_balances ocb
7904: WHERE ocb.khr_id = cp_khr_id
7905: AND ocb.termination_date < cp_from_date
7906: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7907: WHERE vpb.khr_id = ocb.khr_id
7908: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'
7909: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7910: AND vpb.source_id = ocb.id);

Line 8057: l_source_id OKL_VAR_PRINCIPAL_BAL_TXN.source_id%TYPE;

8053:
8054: l_api_name CONSTANT VARCHAR2(30) := 'populate_txns';
8055: l_api_version CONSTANT NUMBER := 1.0;
8056: L_FETCH_SIZE CONSTANT NUMBER := 100;
8057: l_source_id OKL_VAR_PRINCIPAL_BAL_TXN.source_id%TYPE;
8058: l_source_table OKL_VAR_PRINCIPAL_BAL_TXN.source_table%TYPE;
8059:
8060: --get the id's of Rebook Transactions
8061: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS

Line 8058: l_source_table OKL_VAR_PRINCIPAL_BAL_TXN.source_table%TYPE;

8054: l_api_name CONSTANT VARCHAR2(30) := 'populate_txns';
8055: l_api_version CONSTANT NUMBER := 1.0;
8056: L_FETCH_SIZE CONSTANT NUMBER := 100;
8057: l_source_id OKL_VAR_PRINCIPAL_BAL_TXN.source_id%TYPE;
8058: l_source_table OKL_VAR_PRINCIPAL_BAL_TXN.source_table%TYPE;
8059:
8060: --get the id's of Rebook Transactions
8061: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
8062: SELECT ktrx.id source_id

Line 8077: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8073: --
8074: AND chrb.id = cp_khr_id
8075: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
8076: AND chrb2.id = ktrx.khr_id_new
8077: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8078: WHERE vpb.khr_id = chrb.id
8079: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
8080: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8081: AND vpb.source_id = ktrx.id);

Line 8096: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8092: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
8093: AND stm.id = sel.stm_id
8094: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
8095: AND sel.stream_element_date <= cp_to_date
8096: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8097: WHERE vpb.khr_id = stm.khr_id
8098: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
8099: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8100: AND vpb.source_id = sel.id);

Line 8115: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8111: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
8112: AND stm.id = sel.stm_id
8113: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
8114: AND sel.stream_element_date <= cp_to_date
8115: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8116: WHERE vpb.khr_id = stm.khr_id
8117: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
8118: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8119: AND vpb.source_id = sel.id);

Line 8153: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8149: AND sty.stream_type_purpose IN ('PRINCIPAL_PAYMENT', 'UNSCHEDULED_PRINCIPAL_PAYMENT')
8150: AND to_char(tld.id) = ractrl.interface_line_attribute14
8151: AND tld.til_id_details = til.id
8152: AND til.tai_id = tai.id
8153: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8154: WHERE vpb.khr_id = tld.khr_id
8155: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
8156: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8157: AND vpb.source_id = raa.receivable_application_id)

Line 8187: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8183: AND okl_inv.funding_type_code = 'BORROWER_PAYMENT'
8184: AND ap_inv.invoice_id = iph.invoice_id
8185: --AND iph.check_date BETWEEN cp_from_date AND cp_to_date
8186: AND iph.check_date <= cp_to_date
8187: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8188: WHERE vpb.khr_id = okl_inv_ln.khr_id
8189: AND vpb.source_table = 'AP_INVOICE_PAYMENTS_ALL'
8190: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8191: AND vpb.source_id = iph.invoice_payment_id);

Line 8201: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb

8197: , 'OKL_CONTRACT_BALANCES' source_table
8198: FROM okl_contract_balances ocb
8199: WHERE ocb.khr_id = cp_khr_id
8200: AND ocb.termination_date BETWEEN cp_from_date AND cp_to_date
8201: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8202: WHERE vpb.khr_id = ocb.khr_id
8203: AND vpb.source_table = 'OKL_CONTRACT_BALANCES'
8204: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8205: AND vpb.source_id = ocb.id);

Line 8832: INSERT INTO OKL_VAR_PRINCIPAL_BAL_TXN VALUES p_vpb_tbl(l_index);

8828:
8829: IF (p_vpb_tbl.COUNT > 0) THEN
8830: FORALL l_index in p_vpb_tbl.FIRST .. p_vpb_tbl.LAST
8831: save exceptions
8832: INSERT INTO OKL_VAR_PRINCIPAL_BAL_TXN VALUES p_vpb_tbl(l_index);
8833:
8834: print_debug ('Exception count : '|| sql%bulk_exceptions.count);
8835: IF sql%bulk_exceptions.count > 0 then
8836: for i in 1..sql%bulk_exceptions.count loop