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.

[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 461: OKL_TXL_CNTRCT_LNS txl,

457: CURSOR check_actual_trx(p_khr_id NUMBER) IS
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'

Line 1600: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

1596: l_api_version CONSTANT NUMBER := 1.0;
1597: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1598: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1599: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1600: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1601: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1602: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1603: --START: change by nikshah, for SLA Uptake Bug 5705866
1604: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

Line 1601: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

1597: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1598: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1599: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1600: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1601: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1602: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1603: --START: change by nikshah, for SLA Uptake Bug 5705866
1604: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1605: --END: change by nikshah, for SLA Uptake Bug 5705866

Line 3581: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';

3577: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3578: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3579: l_api_version CONSTANT NUMBER := 1.0;
3580: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3581: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3582: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3583: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3584: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3585: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';

Line 3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

3584: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3585: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3586: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3587: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

Line 3618: FROM OKL_TXL_CNTRCT_LNS

3614: -- Cursor to select transaction lines for reversal (for source id)
3615: -- Modifying below cursor for Bug# 2455956
3616: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
3617: SELECT id
3618: FROM OKL_TXL_CNTRCT_LNS
3619: WHERE tcn_id = p_tcn_id;
3620:
3621: -- Cursor to populate stream table with amounts and sty_id for creating memo Revenue
3622: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS

Line 3624: FROM OKL_TXL_CNTRCT_LNS

3620:
3621: -- Cursor to populate stream table with amounts and sty_id for creating memo Revenue
3622: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS
3623: SELECT sty_id, amount, kle_id
3624: FROM OKL_TXL_CNTRCT_LNS
3625: WHERE tcn_id = p_tcn_id;
3626:
3627: BEGIN
3628: -- Set save point

Line 3939: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

3935: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3936: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3937: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3938: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3939: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3940: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3941: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3942: l_contract_number VARCHAR2(2000);
3943: l_tcn_type VARCHAR2(2000) := p_tcn_type;

Line 3969: FROM OKL_TXL_CNTRCT_LNS

3965:
3966: -- Cursor to select transaction lines for reversal (for source id)
3967: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
3968: SELECT id
3969: FROM OKL_TXL_CNTRCT_LNS
3970: WHERE tcn_id = p_tcn_id;
3971:
3972: BEGIN
3973: -- Set save point

Line 4170: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';

4166: -- local variables
4167: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ALL_ACCRUALS';
4168: l_api_version CONSTANT NUMBER := 1.0;
4169: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4170: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4171: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4172: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4173: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4174: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';

Line 4176: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

4172: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4173: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4174: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4175: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4176: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4177: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4178: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4179: l_count NUMBER := 1;
4180: l_count2 NUMBER := 1;

Line 4201: FROM OKL_TXL_CNTRCT_LNS

4197:
4198: -- Cursor to select transaction lines for reversal (for source id)
4199: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
4200: SELECT id
4201: FROM OKL_TXL_CNTRCT_LNS
4202: WHERE tcn_id = p_tcn_id;
4203:
4204: BEGIN
4205: -- Set save point

Line 4398: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';

4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4397: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4398: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4399: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4400: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4401: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4402: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';

Line 4405: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

4401: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4402: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4403: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4404: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4405: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4406: l_api_name VARCHAR2(20) := 'CATCHUP_ACCRUALS';
4407: l_api_version CONSTANT NUMBER := 1.0;
4408: l_accrual_rec accrual_rec_type;
4409: l_stream_tbl stream_tbl_type;

Line 4427: FROM OKL_TXL_CNTRCT_LNS

4423:
4424: -- Cursor to select transaction lines for accrual catchup
4425: CURSOR catchup_txl_csr(p_tcn_id NUMBER) IS
4426: SELECT id
4427: FROM OKL_TXL_CNTRCT_LNS
4428: WHERE tcn_id = p_tcn_id;
4429:
4430: -- Cursor to populate stream table with amounts ad sty_id for creating memo Revenue
4431: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS

Line 4433: FROM OKL_TXL_CNTRCT_LNS

4429:
4430: -- Cursor to populate stream table with amounts ad sty_id for creating memo Revenue
4431: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS
4432: SELECT sty_id, amount, kle_id
4433: FROM OKL_TXL_CNTRCT_LNS
4434: WHERE tcn_id = p_tcn_id;
4435:
4436: BEGIN
4437: WRITE_TO_LOG('Inside the CATCHUP_ACCRUALS call');

Line 4768: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

4764: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4765: l_api_name VARCHAR2(30) := 'CREATE_ACCR_LINE_FORMULA';
4766: l_api_version CONSTANT NUMBER := 1.0;
4767: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4768: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4769: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4770: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

Line 4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

4767: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4768: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4769: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4770: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

Line 5386: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

5382: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
5383: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
5384: l_api_version CONSTANT NUMBER := 1.0;
5385: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
5386: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
5387: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5388: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

Line 5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

5385: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
5386: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
5387: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5388: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

Line 6234: FROM OKL_TRX_CONTRACTS trx, OKL_TRX_TYPES_V try, OKL_TXL_CNTRCT_LNS txl, OKL_STRM_TYPE_V sty

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

Line 6254: OKL_TXL_CNTRCT_LNS txl,

6250: CURSOR check_actual_trx(p_khr_id NUMBER) IS
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'