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_TYPE_V

Line 122: okl_strm_type_v styp,

118: sll.rule_information13 rate,
119: rgp.cle_id cle_id
120: from okc_rules_b sll,
121: okc_rules_b slh,
122: okl_strm_type_v styp,
123: okc_rule_groups_b rgp
124: where to_number(sll.object2_id1) = slh.id
125: and sll.rule_information_category = 'LASLL'
126: and sll.dnz_chr_id = rgp.dnz_chr_id

Line 163: okl_strm_type_v styp,

159: sll.rule_information7 stub_days,
160: sll.rule_information8 stub_amount
161: from okc_rules_b sll,
162: okc_rules_b slh,
163: okl_strm_type_v styp,
164: okc_rule_groups_b rgp
165: where to_number(sll.object2_id1) = slh.id
166: and sll.rule_information_category = 'LASLL'
167: and sll.dnz_chr_id = rgp.dnz_chr_id

Line 2263: l_sty_id okl_strm_type_v.id%TYPE;

2259: ------------------------------------------------------------
2260: -- Declare local variables used in the program
2261: ------------------------------------------------------------
2262:
2263: l_sty_id okl_strm_type_v.id%TYPE;
2264:
2265: l_khr_id okl_trx_ar_invoices_v.khr_id%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;

Line 3211: FROM okl_strm_type_v sty_int_pmt

3207:
3208: Cursor stream_element_interest_csr (p_line_id NUMBER,
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

Line 3225: FROM okl_strm_type_v sty_prin_pmt

3221:
3222: Cursor stream_element_principal_csr (p_line_id NUMBER,
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

Line 3297: FROM okl_strm_type_v sty_int_pmt

3293:
3294: Cursor strm_elem_int_line_csr (p_line_id NUMBER,
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

Line 3311: FROM okl_strm_type_v sty_prin_pmt

3307:
3308: Cursor strm_elem_prin_line_csr (p_line_id NUMBER,
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

Line 3325: FROM okl_strm_type_v sty_int_pmt

3321:
3322: Cursor strm_elem_int_hdr_csr (p_khr_id NUMBER,
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

Line 3339: FROM okl_strm_type_v sty_prin_pmt

3335:
3336: Cursor strm_elem_prin_hdr_csr ( p_khr_id NUMBER,
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

Line 3545: ,okl_strm_type_v sty

3541: ,okl_cnsld_ar_hdrs_b cnr
3542: ,ar_payment_schedules_all aps
3543: ,ar_receivable_applications_all raa
3544: ,ar_cash_receipts_all cra
3545: ,okl_strm_type_v sty
3546: WHERE lsm.receivables_invoice_id > 0
3547: AND lsm.lln_id = lln.id
3548: AND lln.cnr_id = cnr.id
3549: AND cnr.trx_status_code = 'PROCESSED'

Line 3581: okl_strm_type_v sty_ln_pmt,

3577: okl_cnsld_ar_hdrs_b cnr,
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

Line 3918: okl_strm_type_v sty

3914: okl_cnsld_ar_hdrs_b cnr,
3915: ar_payment_schedules_all aps,
3916: ar_receivable_applications_all raa,
3917: ar_cash_receipts_all cra,
3918: okl_strm_type_v sty
3919: WHERE lsm.receivables_invoice_id > 0
3920: AND lsm.lln_id = lln.id
3921: AND lln.cnr_id = cnr.id
3922: AND cnr.trx_status_code = 'PROCESSED'

Line 3969: okl_strm_type_v sty

3965: okl_cnsld_ar_hdrs_b cnr,
3966: ar_payment_schedules_all aps,
3967: ar_receivable_applications_all raa,
3968: ar_cash_receipts_all cra,
3969: okl_strm_type_v sty
3970: WHERE lsm.receivables_invoice_id > 0
3971: AND lsm.lln_id = lln.id
3972: AND lln.cnr_id = cnr.id
3973: AND cnr.trx_status_code = 'PROCESSED'

Line 4243: ,okl_strm_type_v sty

4239: SELECT sel.amount
4240: FROM
4241: okl_strm_elements sel
4242: ,okl_streams str
4243: ,okl_strm_type_v sty
4244: WHERE sel.stm_id = str.id
4245: AND str.khr_id = p_contract_id
4246: AND str.kle_id = p_line_id
4247: AND str.say_code = 'CURR'

Line 4259: ,okl_strm_type_v sty

4255: SELECT SUM(amount)
4256: FROM
4257: okl_strm_elements sel
4258: ,okl_streams str
4259: ,okl_strm_type_v sty
4260: WHERE sel.stm_id = str.id
4261: AND str.khr_id = p_contract_id
4262: AND str.say_code = 'CURR'
4263: AND str.active_yn = 'Y'

Line 4352: ,okl_strm_type_v sty

4348: sum(sel.amount) principal_pmt_rcpt_amt
4349: FROM
4350: okl_strm_elements sel
4351: ,okl_streams str
4352: ,okl_strm_type_v sty
4353: WHERE sel.stm_id = str.id
4354: AND str.khr_id = p_contract_id
4355: AND str.kle_id = NVL(p_line_id, str.kle_id)
4356: AND str.say_code = 'CURR'

Line 4374: ,okl_strm_type_v sty

4370: sum(sel.amount) principal_pmt_rcpt_amt
4371: FROM
4372: okl_strm_elements sel
4373: ,okl_streams str
4374: ,okl_strm_type_v sty
4375: WHERE sel.stm_id = str.id
4376: AND str.khr_id = p_contract_id
4377: AND str.kle_id = NVL(p_line_id, str.kle_id)
4378: AND str.say_code = 'CURR'

Line 4850: ,okl_strm_type_v sty

4846: 'R' txn_type
4847: FROM
4848: okl_strm_elements sel
4849: ,okl_streams str
4850: ,okl_strm_type_v sty
4851: WHERE sel.stm_id = str.id
4852: AND str.khr_id = p_contract_id
4853: AND str.say_code = 'CURR'
4854: AND str.active_yn = 'Y'

Line 4892: okl_strm_type_v sty

4888: FROM okl_bpd_tld_ar_lines_v tld,
4889: ar_payment_schedules_all aps,
4890: ar_receivable_applications_all raa,
4891: ar_cash_receipts_all cra,
4892: okl_strm_type_v sty
4893: WHERE tld.trx_status_code = 'PROCESSED'
4894: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
4895: AND tld.customer_trx_id = aps.customer_trx_id
4896: AND raa.applied_customer_trx_id = aps.customer_trx_id

Line 6595: l_sty_id OKL_STRM_TYPE_V.id%TYPE;

6591: l_api_version CONSTANT NUMBER := 1.0;
6592: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
6593: l_msg_count NUMBER;
6594: l_msg_data VARCHAR2(2000);
6595: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6596: l_stream_exists VARCHAR2(1) := '?';
6597: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6598: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
6599: l_selv_rec Okl_Streams_Pub.selv_rec_type;

Line 11237: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

11233: l_scheduled_prin_pmnt_amt NUMBER := 0;
11234: l_invoice_id NUMBER;
11235: l_invoice_amt NUMBER := 0;
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:

Line 11244: FROM okl_strm_type_v sty_prin_pmt,

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,
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

Line 11257: FROM okl_strm_type_v sty_prin_pmt,

11253: AND sty_prin_pmt.stream_type_purpose = p_stream_type_purpose ; -- 'PRINCIPAL_PAYMENT'
11254:
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

Line 11492: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

11488: l_scheduled_prin_pmnt_amt NUMBER := 0;
11489: l_invoice_id NUMBER;
11490: l_invoice_amt NUMBER := 0;
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;

Line 11503: FROM okl_strm_type_v sty_prin_pmt,

11499: var_int_float_failed EXCEPTION;
11500:
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

Line 11517: FROM okl_strm_type_v sty_prin_pmt,

11513:
11514: -- Derive the interest billed for previous billing periods
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

Line 11541: FROM okl_strm_type_v sty,

11537: CURSOR Principal_payment_streams_csr (cp_khr_id NUMBER, cp_kle_id NUMBER, cp_due_date DATE) IS
11538: SELECT sel.id,
11539: sel.stream_element_date,
11540: sel.amount
11541: FROM okl_strm_type_v sty,
11542: okl_streams str,
11543: okl_strm_elements sel
11544: WHERE sel.stm_id = str.id
11545: AND str.khr_id = cp_khr_id

Line 11561: FROM okl_strm_type_v sty_prin_pmt,

11557:
11558:
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

Line 11868: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

11864:
11865: l_api_version CONSTANT NUMBER := 1.0;
11866: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_FLOAT_FACTOR';
11867: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
11868: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11869: l_invoice_amt NUMBER := 0;
11870: l_formula_id OKL_FORMULAE_V.id%TYPE;
11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;

Line 12120: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

12116: l_total_interest_billed NUMBER := 0;
12117: l_principal_adjusted NUMBER := 0;
12118: -- l_catchup_settlement_code OKL_K_RATE_PARAMS.catchup_settlement_code%TYPE;
12119: l_invoice_amt NUMBER := 0;
12120: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
12121: l_invoice_id NUMBER;
12122: l_principal_balance_tbl principal_balance_tbl_typ;
12123: l_total_asset_val NUMBER := 0;
12124: l_principal_balance NUMBER := 0;

Line 12137: FROM okl_strm_type_v sty_prin_pmt,

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

Line 12150: FROM okl_strm_type_v sty_prin_pmt,

12146: AND sty_prin_pmt.stream_type_purpose in ('INTEREST_CATCHUP', 'INTEREST_PAYMENT') ; -- 'PRINCIPAL_PAYMENT'
12147:
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

Line 12163: FROM okl_strm_type_v sty_prin_pmt,

12159: AND sty_prin_pmt.stream_type_purpose in ('INTEREST_CATCHUP', 'INTEREST_PAYMENT') ; -- 'PRINCIPAL_PAYMENT'
12160:
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