[Home] [Help]
411: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
412: FROM OKL_TRX_CONTRACTS trx,
413: OKL_TRX_TYPES_V try,
414: OKL_TXL_CNTRCT_LNS txl,
415: OKL_STRM_TYPE_V sty
416: WHERE trx.khr_id = p_khr_id
417: AND trx.try_id = try.id
418: AND try.name = 'Accrual'
419: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1521:
1522: TYPE selv_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1523: l_selv_tbl selv_tbl_type;
1524:
1525: TYPE sty_tbl_typ is TABLE OF OKL_STRM_TYPE_V.ID%TYPE INDEX BY BINARY_INTEGER;
1526: l_sty_tbl sty_tbl_typ;
1527:
1528: l_record_exists VARCHAR2(1);
1529: l_count NUMBER;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2231: l_accrual_strm_tbl stream_tbl_type;
2232: l_non_accrual_strm_tbl stream_tbl_type;
2233: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;
2234: l_counter1 NUMBER := 1;
2235: l_counter2 NUMBER := 1;
2236: l_rule_result VARCHAR2(1);
2237: l_sob_name VARCHAR2(2000);
2759:
2760: -- local collections
2761: TYPE accelerate_ref_cursor IS REF CURSOR;
2762: TYPE stream_rec IS RECORD
2763: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2764: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2765: amount NUMBER,
2766: kle_id OKL_STREAMS.kle_ID%TYPE);
2767:
5254: l_billing_type VARCHAR2(2000) := NULL;
5255: -- moved l_total from outer block to inner block for bug# 2648718
5256: l_total NUMBER := 0;
5257: l_rule_result VARCHAR2(1);
5258: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
5259: l_stream_tbl stream_tbl_type;
5260: l_stream_tbl_rep stream_tbl_type; -- MGAAP 7263041
5261: l_tcnv_rec Okl_Trx_Contracts_Pub.tcnv_rec_type;
5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5276: l_factoring_flag VARCHAR2(2000);
5277: l_trx_exists VARCHAR2(1) := '?';
5278: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
5279: l_rev_rec_method VARCHAR2(2000);
5280: l_rev_rec_basis OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE;
5281: l_last_accrual_date DATE;
5282:
5283: -- Commenting for Bug 4659467
5284: -- Cursor to select the interest rule i.e. whether fixed interest or variable interest
5351: -- cursor to check for accrual trx for a given period for variable rate contracts
5352: -- 12/5/05. Bug 4862620. Check for trx with variable interest income only
5353: CURSOR check_variable_trx(p_khr_id NUMBER, p_date DATE) IS
5354: SELECT 'Y'
5355: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty
5356: WHERE trx.khr_id = p_khr_id
5357: AND trx.try_id = try.id
5358: AND try.name = 'Accrual'
5359: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5371: SELECT TRUNC(MAX(trx.date_transaction_occurred)) last_accrual_date
5372: FROM OKL_TRX_CONTRACTS trx,
5373: OKL_TRX_TYPES_V try,
5374: OKL_TXL_CNTRCT_LNS txl,
5375: OKL_STRM_TYPE_V sty
5376: WHERE trx.khr_id = p_khr_id
5377: AND trx.try_id = try.id
5378: AND try.name = 'Accrual'
5379: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5385: AND trx.representation_type = 'PRIMARY';
5386:
5387: CURSOR get_rev_rec_basis_csr (p_sty_id NUMBER) IS
5388: SELECT accrual_yn
5389: FROM OKL_STRM_TYPE_V
5390: WHERE id = p_sty_id;
5391:
5392: l_last_status_csr_v last_status_csr%ROWTYPE;
5393:
5402:
5403: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
5404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
5405: l_tcnv_tbl_cnt NUMBER;
5406: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
5407: -- MGAAP end 7263041
5408:
5409: -- bug 7577628
5410: cursor get_sec_rep_method is