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_STRM_ELEMENTS_V

Line 2329: FROM OKL_STRM_ELEMENTS_V

2325: AND stm.sty_id = p_sty_id;
2326:
2327: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
2328: SELECT SE_LINE_NUMBER
2329: FROM OKL_STRM_ELEMENTS_V
2330: WHERE stm_id = c_stm_id
2331: ORDER BY SE_LINE_NUMBER DESC;
2332:
2333: CURSOR c_tran_num_csr IS

Line 3213: ,okl_strm_elements_v sel_int_pmt

3209: p_stream_element_date DATE) IS
3210: SELECT nvl(sel_int_pmt.amount, 0) interest
3211: FROM okl_strm_type_v sty_int_pmt
3212: ,okl_streams_v stm_int_pmt
3213: ,okl_strm_elements_v sel_int_pmt
3214: WHERE stm_int_pmt.kle_id = p_line_id
3215: AND stm_int_pmt.id = sel_int_pmt.stm_id
3216: AND sel_int_pmt.stream_element_date = p_stream_element_date
3217: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3227: ,okl_strm_elements_v sel_prin_pmt

3223: p_stream_element_date DATE) IS
3224: SELECT nvl(sel_prin_pmt.amount, 0) principal
3225: FROM okl_strm_type_v sty_prin_pmt
3226: ,okl_streams_v stm_prin_pmt
3227: ,okl_strm_elements_v sel_prin_pmt
3228: WHERE stm_prin_pmt.kle_id = p_line_id
3229: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3230: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3231: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3236: l_interest okl_strm_elements_v.amount%TYPE;

3232: AND stm_prin_pmt.active_yn = 'Y'
3233: AND stm_prin_pmt.say_code = 'CURR'
3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);

Line 3237: l_principal okl_strm_elements_v.amount%TYPE;

3233: AND stm_prin_pmt.say_code = 'CURR'
3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
3241: FETCH stream_element_interest_csr INTO l_interest;

Line 3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;

3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
3241: FETCH stream_element_interest_csr INTO l_interest;
3242: IF stream_element_interest_csr%NOTFOUND THEN

Line 3299: ,okl_strm_elements_v sel_int_pmt

3295: p_stream_element_date DATE) IS
3296: SELECT nvl(sel_int_pmt.amount, 0) interest
3297: FROM okl_strm_type_v sty_int_pmt
3298: ,okl_streams_v stm_int_pmt
3299: ,okl_strm_elements_v sel_int_pmt
3300: WHERE stm_int_pmt.kle_id = p_line_id
3301: AND stm_int_pmt.id = sel_int_pmt.stm_id
3302: AND sel_int_pmt.stream_element_date = p_stream_element_date
3303: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3313: ,okl_strm_elements_v sel_prin_pmt

3309: p_stream_element_date DATE) IS
3310: SELECT nvl(sel_prin_pmt.amount, 0) principal
3311: FROM okl_strm_type_v sty_prin_pmt
3312: ,okl_streams_v stm_prin_pmt
3313: ,okl_strm_elements_v sel_prin_pmt
3314: WHERE stm_prin_pmt.kle_id = p_line_id
3315: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3316: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3317: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3327: ,okl_strm_elements_v sel_int_pmt

3323: p_stream_element_date DATE) IS
3324: SELECT nvl(sel_int_pmt.amount, 0) interest
3325: FROM okl_strm_type_v sty_int_pmt
3326: ,okl_streams_v stm_int_pmt
3327: ,okl_strm_elements_v sel_int_pmt
3328: WHERE stm_int_pmt.khr_id = p_khr_id
3329: AND stm_int_pmt.id = sel_int_pmt.stm_id
3330: AND sel_int_pmt.stream_element_date = p_stream_element_date
3331: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3341: ,okl_strm_elements_v sel_prin_pmt

3337: p_stream_element_date DATE) IS
3338: SELECT nvl(sel_prin_pmt.amount, 0) principal
3339: FROM okl_strm_type_v sty_prin_pmt
3340: ,okl_streams_v stm_prin_pmt
3341: ,okl_strm_elements_v sel_prin_pmt
3342: WHERE stm_prin_pmt.khr_id = p_khr_id
3343: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3344: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3345: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3350: l_interest okl_strm_elements_v.amount%TYPE;

3346: AND stm_prin_pmt.active_yn = 'Y'
3347: AND stm_prin_pmt.say_code = 'CURR'
3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN

Line 3351: l_principal okl_strm_elements_v.amount%TYPE;

3347: AND stm_prin_pmt.say_code = 'CURR'
3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN
3355: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);

Line 3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;

3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN
3355: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);
3356: FETCH strm_elem_int_line_csr INTO l_interest;

Line 3582: okl_strm_elements_v sel_ln_pmt

3578: ar_payment_schedules_all aps,
3579: ar_receivable_applications_all raa,
3580: ar_cash_receipts_all cra,
3581: okl_strm_type_v sty_ln_pmt,
3582: okl_strm_elements_v sel_ln_pmt
3583: WHERE lsm.receivables_invoice_id > 0
3584: AND lsm.lln_id = lln.id
3585: AND lln.cnr_id = cnr.id
3586: AND cnr.trx_status_code = 'PROCESSED'

Line 6684: FROM OKL_STRM_ELEMENTS_V

6680: FROM dual;
6681:
6682: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
6683: SELECT SE_LINE_NUMBER
6684: FROM OKL_STRM_ELEMENTS_V
6685: WHERE stm_id = c_stm_id
6686: ORDER BY SE_LINE_NUMBER DESC;
6687:
6688:

Line 7808: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

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);
7811:
7812: --checks if newly created Principal Catchup stream elements exist

Line 7826: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

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);
7829:
7830: --checks if newly created Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT exist

Line 8086: , 'OKL_STRM_ELEMENTS_V' source_table

8082:
8083: --get the id's of Daily Interest - Principal stream elements
8084: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8085: SELECT sel.id source_id
8086: , 'OKL_STRM_ELEMENTS_V' source_table
8087: FROM okl_streams stm,
8088: okl_strm_type_b sty,
8089: okl_strm_elements sel
8090: WHERE stm.khr_id = cp_khr_id

Line 8098: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

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);
8101:
8102: --get the id's of Principal Catchup stream elements

Line 8105: , 'OKL_STRM_ELEMENTS_V' source_table

8101:
8102: --get the id's of Principal Catchup stream elements
8103: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8104: SELECT sel.id source_id
8105: , 'OKL_STRM_ELEMENTS_V' source_table
8106: FROM okl_streams stm,
8107: okl_strm_type_b sty,
8108: okl_strm_elements sel
8109: WHERE stm.khr_id = cp_khr_id

Line 8117: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

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);
8120:
8121: --get the id's of Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT

Line 9716: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

9712:
9713: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DAILY_INTEREST_STREAMS';
9714: l_api_version CONSTANT NUMBER := 1.0;
9715: l_invoice_id NUMBER;
9716: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
9717: i_vir_tbl vir_tbl_type;
9718: r_vir_tbl vir_tbl_type;
9719: Create_Daily_Int_Str_failed EXCEPTION;
9720: l_asset_cost NUMBER;

Line 11240: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

11236: l_interest_paid NUMBER := 0;
11237: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11238: i_vir_tbl vir_tbl_type;
11239: r_vir_tbl vir_tbl_type;
11240: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11241:
11242: CURSOR loan_payment_amount_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11243: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11244: FROM okl_strm_type_v sty_prin_pmt,

Line 11246: okl_strm_elements_v sel_prin_pmt

11242: CURSOR loan_payment_amount_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11243: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11244: FROM okl_strm_type_v sty_prin_pmt,
11245: okl_streams_v stm_prin_pmt,
11246: okl_strm_elements_v sel_prin_pmt
11247: WHERE stm_prin_pmt.khr_id = p_khr_id
11248: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11249: AND sel_prin_pmt.stream_element_date <= p_due_date
11250: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11259: okl_strm_elements_v sel_prin_pmt

11255: CURSOR scheduled_prin_pmnt_amt_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11256: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11257: FROM okl_strm_type_v sty_prin_pmt,
11258: okl_streams_v stm_prin_pmt,
11259: okl_strm_elements_v sel_prin_pmt
11260: WHERE stm_prin_pmt.khr_id = p_khr_id
11261: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11262: AND sel_prin_pmt.stream_element_date = p_due_date
11263: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

11491: l_interest_paid NUMBER := 0;
11492: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11493: i_vir_tbl vir_tbl_type;
11494: r_vir_tbl vir_tbl_type;
11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11496: l_kle_id OKL_K_LINES.id%TYPE;
11497: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
11498: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
11499: var_int_float_failed EXCEPTION;

Line 11505: okl_strm_elements_v sel_prin_pmt

11501: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11502: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11503: FROM okl_strm_type_v sty_prin_pmt,
11504: okl_streams_v stm_prin_pmt,
11505: okl_strm_elements_v sel_prin_pmt
11506: WHERE stm_prin_pmt.khr_id = cp_khr_id
11507: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11508: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
11509: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11519: okl_strm_elements_v sel_prin_pmt

11515: CURSOR Interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
11516: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11517: FROM okl_strm_type_v sty_prin_pmt,
11518: okl_streams_v stm_prin_pmt,
11519: okl_strm_elements_v sel_prin_pmt
11520: WHERE stm_prin_pmt.khr_id = cp_khr_id
11521: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11522: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
11523: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11563: okl_strm_elements_v sel_prin_pmt

11559: CURSOR scheduled_prin_pmnt_amt_csr (cp_khr_id NUMBER, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11560: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11561: FROM okl_strm_type_v sty_prin_pmt,
11562: okl_streams_v stm_prin_pmt,
11563: okl_strm_elements_v sel_prin_pmt
11564: WHERE stm_prin_pmt.khr_id = cp_khr_id
11565: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11566: AND sel_prin_pmt.stream_element_date = cp_due_date
11567: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;
11873: l_stream_element_date DATE;
11874: l_invoice_id NUMBER;
11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
11876: var_int_float_factor_failed EXCEPTION;
11877:
11878: Cursor formula_name_csr (p_formula_id NUMBER) IS
11879: SELECT fml.name

Line 12132: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

12128: l_asset_line_tbl_count NUMBER := 0;
12129: l_prorated_invoice_amt NUMBER := 0;
12130: i_vir_tbl vir_tbl_type;
12131: r_vir_tbl vir_tbl_type;
12132: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
12133: var_int_catchup_failed EXCEPTION;
12134:
12135: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12136: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt

Line 12139: okl_strm_elements_v sel_prin_pmt

12135: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12136: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12137: FROM okl_strm_type_v sty_prin_pmt,
12138: okl_streams_v stm_prin_pmt,
12139: okl_strm_elements_v sel_prin_pmt
12140: WHERE stm_prin_pmt.khr_id = cp_khr_id
12141: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12142: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
12143: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 12152: okl_strm_elements_v sel_prin_pmt

12148: CURSOR int_pay_amt_end_date_csr (cp_khr_id NUMBER, cp_start_date DATE) IS
12149: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12150: FROM okl_strm_type_v sty_prin_pmt,
12151: okl_streams_v stm_prin_pmt,
12152: okl_strm_elements_v sel_prin_pmt
12153: WHERE stm_prin_pmt.khr_id = cp_khr_id
12154: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12155: AND sel_prin_pmt.stream_element_date >= cp_start_date
12156: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 12165: okl_strm_elements_v sel_prin_pmt

12161: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12162: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12163: FROM okl_strm_type_v sty_prin_pmt,
12164: okl_streams_v stm_prin_pmt,
12165: okl_strm_elements_v sel_prin_pmt
12166: WHERE stm_prin_pmt.khr_id = cp_khr_id
12167: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12168: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
12169: AND stm_prin_pmt.sty_id = sty_prin_pmt.id