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 1141: ,okl_strm_elements_v sel_int_pmt

1137: p_stream_element_date DATE) IS
1138: SELECT nvl(sel_int_pmt.amount, 0) interest
1139: FROM okl_strm_type_v sty_int_pmt
1140: ,okl_streams_v stm_int_pmt
1141: ,okl_strm_elements_v sel_int_pmt
1142: WHERE stm_int_pmt.kle_id = p_line_id
1143: AND stm_int_pmt.id = sel_int_pmt.stm_id
1144: AND sel_int_pmt.stream_element_date = p_stream_element_date
1145: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 1155: ,okl_strm_elements_v sel_prin_pmt

1151: p_stream_element_date DATE) IS
1152: SELECT nvl(sel_prin_pmt.amount, 0) principal
1153: FROM okl_strm_type_v sty_prin_pmt
1154: ,okl_streams_v stm_prin_pmt
1155: ,okl_strm_elements_v sel_prin_pmt
1156: WHERE stm_prin_pmt.kle_id = p_line_id
1157: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1158: AND sel_prin_pmt.stream_element_date = p_stream_element_date
1159: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 1164: l_interest okl_strm_elements_v.amount%TYPE;

1160: AND stm_prin_pmt.active_yn = 'Y'
1161: AND stm_prin_pmt.say_code = 'CURR'
1162: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1163:
1164: l_interest okl_strm_elements_v.amount%TYPE;
1165: l_principal okl_strm_elements_v.amount%TYPE;
1166: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1167: BEGIN
1168: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);

Line 1165: l_principal okl_strm_elements_v.amount%TYPE;

1161: AND stm_prin_pmt.say_code = 'CURR'
1162: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1163:
1164: l_interest okl_strm_elements_v.amount%TYPE;
1165: l_principal okl_strm_elements_v.amount%TYPE;
1166: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1167: BEGIN
1168: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
1169: FETCH stream_element_interest_csr INTO l_interest;

Line 1166: l_prorated_principal okl_strm_elements_v.amount%TYPE;

1162: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1163:
1164: l_interest okl_strm_elements_v.amount%TYPE;
1165: l_principal okl_strm_elements_v.amount%TYPE;
1166: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1167: BEGIN
1168: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
1169: FETCH stream_element_interest_csr INTO l_interest;
1170: IF stream_element_interest_csr%NOTFOUND THEN

Line 1227: ,okl_strm_elements_v sel_int_pmt

1223: p_stream_element_date DATE) IS
1224: SELECT nvl(sel_int_pmt.amount, 0) interest
1225: FROM okl_strm_type_v sty_int_pmt
1226: ,okl_streams_v stm_int_pmt
1227: ,okl_strm_elements_v sel_int_pmt
1228: WHERE stm_int_pmt.kle_id = p_line_id
1229: AND stm_int_pmt.id = sel_int_pmt.stm_id
1230: AND sel_int_pmt.stream_element_date = p_stream_element_date
1231: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 1241: ,okl_strm_elements_v sel_prin_pmt

1237: p_stream_element_date DATE) IS
1238: SELECT nvl(sel_prin_pmt.amount, 0) principal
1239: FROM okl_strm_type_v sty_prin_pmt
1240: ,okl_streams_v stm_prin_pmt
1241: ,okl_strm_elements_v sel_prin_pmt
1242: WHERE stm_prin_pmt.kle_id = p_line_id
1243: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1244: AND sel_prin_pmt.stream_element_date = p_stream_element_date
1245: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 1255: ,okl_strm_elements_v sel_int_pmt

1251: p_stream_element_date DATE) IS
1252: SELECT nvl(sel_int_pmt.amount, 0) interest
1253: FROM okl_strm_type_v sty_int_pmt
1254: ,okl_streams_v stm_int_pmt
1255: ,okl_strm_elements_v sel_int_pmt
1256: WHERE stm_int_pmt.khr_id = p_khr_id
1257: AND stm_int_pmt.id = sel_int_pmt.stm_id
1258: AND sel_int_pmt.stream_element_date = p_stream_element_date
1259: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 1269: ,okl_strm_elements_v sel_prin_pmt

1265: p_stream_element_date DATE) IS
1266: SELECT nvl(sel_prin_pmt.amount, 0) principal
1267: FROM okl_strm_type_v sty_prin_pmt
1268: ,okl_streams_v stm_prin_pmt
1269: ,okl_strm_elements_v sel_prin_pmt
1270: WHERE stm_prin_pmt.khr_id = p_khr_id
1271: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
1272: AND sel_prin_pmt.stream_element_date = p_stream_element_date
1273: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 1278: l_interest okl_strm_elements_v.amount%TYPE;

1274: AND stm_prin_pmt.active_yn = 'Y'
1275: AND stm_prin_pmt.say_code = 'CURR'
1276: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1277:
1278: l_interest okl_strm_elements_v.amount%TYPE;
1279: l_principal okl_strm_elements_v.amount%TYPE;
1280: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1281: BEGIN
1282: IF (p_line_id IS NOT NULL) THEN

Line 1279: l_principal okl_strm_elements_v.amount%TYPE;

1275: AND stm_prin_pmt.say_code = 'CURR'
1276: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1277:
1278: l_interest okl_strm_elements_v.amount%TYPE;
1279: l_principal okl_strm_elements_v.amount%TYPE;
1280: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1281: BEGIN
1282: IF (p_line_id IS NOT NULL) THEN
1283: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);

Line 1280: l_prorated_principal okl_strm_elements_v.amount%TYPE;

1276: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
1277:
1278: l_interest okl_strm_elements_v.amount%TYPE;
1279: l_principal okl_strm_elements_v.amount%TYPE;
1280: l_prorated_principal okl_strm_elements_v.amount%TYPE;
1281: BEGIN
1282: IF (p_line_id IS NOT NULL) THEN
1283: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);
1284: FETCH strm_elem_int_line_csr INTO l_interest;

Line 4499: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

4495: AND stm.id = sel.stm_id
4496: AND sel.stream_element_date < cp_from_date
4497: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4498: WHERE vpb.khr_id = stm.khr_id
4499: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
4500: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4501: AND vpb.source_id = sel.id);
4502:
4503: --checks if newly created Principal Catchup stream elements exist

Line 4517: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

4513: AND stm.id = sel.stm_id
4514: AND sel.stream_element_date < cp_from_date
4515: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4516: WHERE vpb.khr_id = stm.khr_id
4517: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
4518: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4519: AND vpb.source_id = sel.id);
4520:
4521: --checks if newly created Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT exist

Line 4907: , 'OKL_STRM_ELEMENTS_V' source_table

4903:
4904: --get the id's of Daily Interest - Principal stream elements
4905: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4906: SELECT sel.id source_id
4907: , 'OKL_STRM_ELEMENTS_V' source_table
4908: FROM okl_streams stm,
4909: okl_strm_type_b sty,
4910: okl_strm_elements sel
4911: WHERE stm.khr_id = cp_khr_id

Line 4919: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

4915: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
4916: AND sel.stream_element_date <= cp_to_date
4917: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4918: WHERE vpb.khr_id = stm.khr_id
4919: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
4920: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4921: AND vpb.source_id = sel.id);
4922:
4923: --get the id's of Principal Catchup stream elements

Line 4926: , 'OKL_STRM_ELEMENTS_V' source_table

4922:
4923: --get the id's of Principal Catchup stream elements
4924: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4925: SELECT sel.id source_id
4926: , 'OKL_STRM_ELEMENTS_V' source_table
4927: FROM okl_streams stm,
4928: okl_strm_type_b sty,
4929: okl_strm_elements sel
4930: WHERE stm.khr_id = cp_khr_id

Line 4938: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

4934: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
4935: AND sel.stream_element_date <= cp_to_date
4936: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4937: WHERE vpb.khr_id = stm.khr_id
4938: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
4939: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4940: AND vpb.source_id = sel.id);
4941:
4942: --get the id's of Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT

Line 5995: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

5991:
5992: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DAILY_INTEREST_STREAMS';
5993: l_api_version CONSTANT NUMBER := 1.0;
5994: l_invoice_id NUMBER;
5995: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
5996: i_vir_tbl vir_tbl_type;
5997: r_vir_tbl vir_tbl_type;
5998: Create_Daily_Int_Str_failed EXCEPTION;
5999: l_asset_cost NUMBER;