[Home] [Help]
458: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
459: FROM OKL_TRX_CONTRACTS trx,
460: OKL_TRX_TYPES_V try,
461: OKL_TXL_CNTRCT_LNS txl,
462: OKL_STRM_TYPE_V sty
463: WHERE trx.khr_id = p_khr_id
464: AND trx.try_id = try.id
465: AND try.name = 'Accrual'
466: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1631:
1632: TYPE selv_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1633: l_selv_tbl selv_tbl_type;
1634:
1635: TYPE sty_tbl_typ is TABLE OF OKL_STRM_TYPE_V.ID%TYPE INDEX BY BINARY_INTEGER;
1636: l_sty_tbl sty_tbl_typ;
1637:
1638: l_record_exists VARCHAR2(1);
1639: l_count NUMBER;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2349: l_accrual_strm_tbl stream_tbl_type;
2350: l_non_accrual_strm_tbl stream_tbl_type;
2351: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;
2352: l_counter1 NUMBER := 1;
2353: l_counter2 NUMBER := 1;
2354: l_rule_result VARCHAR2(1);
2355: l_sob_name VARCHAR2(2000);
2934:
2935: -- local collections
2936: TYPE accelerate_ref_cursor IS REF CURSOR;
2937: TYPE stream_rec IS RECORD
2938: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2939: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2940: amount NUMBER,
2941: kle_id OKL_STREAMS.kle_ID%TYPE
2942: ,stm_id OKL_STREAMS.ID%TYPE ); -- 9001154
6133: l_billing_type VARCHAR2(2000) := NULL;
6134: -- moved l_total from outer block to inner block for bug# 2648718
6135: l_total NUMBER := 0;
6136: l_rule_result VARCHAR2(1);
6137: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
6138: l_stream_tbl stream_tbl_type;
6139: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
6140: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6155: l_factoring_flag VARCHAR2(2000);
6156: l_trx_exists VARCHAR2(1) := '?';
6157: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
6158: l_rev_rec_method VARCHAR2(2000);
6159: l_rev_rec_basis OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE;
6160: l_last_accrual_date DATE;
6161:
6162: -- Commenting for Bug 4659467
6163: -- Cursor to select the interest rule i.e. whether fixed interest or variable interest
6230: -- cursor to check for accrual trx for a given period for variable rate contracts
6231: -- 12/5/05. Bug 4862620. Check for trx with variable interest income only
6232: CURSOR check_variable_trx(p_khr_id NUMBER, p_date DATE) IS
6233: SELECT 'Y'
6234: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty
6235: WHERE trx.khr_id = p_khr_id
6236: AND trx.try_id = try.id
6237: AND try.name = 'Accrual'
6238: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
6251: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
6252: FROM OKL_TRX_CONTRACTS trx,
6253: OKL_TRX_TYPES_V try,
6254: OKL_TXL_CNTRCT_LNS txl,
6255: OKL_STRM_TYPE_V sty
6256: WHERE trx.khr_id = p_khr_id
6257: AND trx.try_id = try.id
6258: AND try.name = 'Accrual'
6259: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
6265: AND trx.representation_type = 'PRIMARY';
6266:
6267: CURSOR get_rev_rec_basis_csr (p_sty_id NUMBER) IS
6268: SELECT accrual_yn
6269: FROM OKL_STRM_TYPE_V
6270: WHERE id = p_sty_id;
6271:
6272: l_last_status_csr_v last_status_csr%ROWTYPE;
6273:
6282:
6283: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
6284: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
6285: l_tcnv_tbl_cnt NUMBER;
6286: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
6287: -- MGAAP end 7263041
6288:
6289: -- bug 7577628
6290: cursor get_sec_rep_method is