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_GENERATE_ACCRUALS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 414: OKL_TXL_CNTRCT_LNS txl,

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

Line 1490: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

1486: l_api_version CONSTANT NUMBER := 1.0;
1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1489: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1490: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1491: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1492: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1493: --START: change by nikshah, for SLA Uptake Bug 5705866
1494: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

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

1487: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1488: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1489: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1490: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1491: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1492: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1493: --START: change by nikshah, for SLA Uptake Bug 5705866
1494: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1495: --END: change by nikshah, for SLA Uptake Bug 5705866

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

3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3332: l_api_name VARCHAR2(20) := 'REVERSE_ACCRUALS';
3333: l_api_version CONSTANT NUMBER := 1.0;
3334: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3335: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3336: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3337: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';

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

3338: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

Line 3372: FROM OKL_TXL_CNTRCT_LNS

3368: -- Cursor to select transaction lines for reversal (for source id)
3369: -- Modifying below cursor for Bug# 2455956
3370: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
3371: SELECT id
3372: FROM OKL_TXL_CNTRCT_LNS
3373: WHERE tcn_id = p_tcn_id;
3374:
3375: -- Cursor to populate stream table with amounts and sty_id for creating memo Revenue
3376: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS

Line 3378: FROM OKL_TXL_CNTRCT_LNS

3374:
3375: -- Cursor to populate stream table with amounts and sty_id for creating memo Revenue
3376: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS
3377: SELECT sty_id, amount, kle_id
3378: FROM OKL_TXL_CNTRCT_LNS
3379: WHERE tcn_id = p_tcn_id;
3380:
3381: BEGIN
3382: -- Set save point

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

3689: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3690: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3691: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3693: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3694: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3695: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3696: l_contract_number VARCHAR2(2000);
3697: l_tcn_type VARCHAR2(2000) := p_tcn_type;

Line 3723: FROM OKL_TXL_CNTRCT_LNS

3719:
3720: -- Cursor to select transaction lines for reversal (for source id)
3721: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
3722: SELECT id
3723: FROM OKL_TXL_CNTRCT_LNS
3724: WHERE tcn_id = p_tcn_id;
3725:
3726: BEGIN
3727: -- Set save point

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

3920: -- local variables
3921: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ALL_ACCRUALS';
3922: l_api_version CONSTANT NUMBER := 1.0;
3923: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
3924: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
3925: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';

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

3926: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
3927: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
3928: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
3930: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3931: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3932: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3933: l_count NUMBER := 1;
3934: l_count2 NUMBER := 1;

Line 3955: FROM OKL_TXL_CNTRCT_LNS

3951:
3952: -- Cursor to select transaction lines for reversal (for source id)
3953: CURSOR reverse_txl_csr(p_tcn_id NUMBER) IS
3954: SELECT id
3955: FROM OKL_TXL_CNTRCT_LNS
3956: WHERE tcn_id = p_tcn_id;
3957:
3958: BEGIN
3959: -- Set save point

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

4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4154: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';

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

4155: l_tsu_code_can OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'CANCELED';
4156: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
4157: l_catchup_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'CATCH-UP';
4158: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
4159: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4160: l_api_name VARCHAR2(20) := 'CATCHUP_ACCRUALS';
4161: l_api_version CONSTANT NUMBER := 1.0;
4162: l_accrual_rec accrual_rec_type;
4163: l_stream_tbl stream_tbl_type;

Line 4181: FROM OKL_TXL_CNTRCT_LNS

4177:
4178: -- Cursor to select transaction lines for accrual catchup
4179: CURSOR catchup_txl_csr(p_tcn_id NUMBER) IS
4180: SELECT id
4181: FROM OKL_TXL_CNTRCT_LNS
4182: WHERE tcn_id = p_tcn_id;
4183:
4184: -- Cursor to populate stream table with amounts ad sty_id for creating memo Revenue
4185: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS

Line 4187: FROM OKL_TXL_CNTRCT_LNS

4183:
4184: -- Cursor to populate stream table with amounts ad sty_id for creating memo Revenue
4185: CURSOR stream_tbl_csr (p_tcn_id NUMBER) IS
4186: SELECT sty_id, amount, kle_id
4187: FROM OKL_TXL_CNTRCT_LNS
4188: WHERE tcn_id = p_tcn_id;
4189:
4190: BEGIN
4191: WRITE_TO_LOG('Inside the CATCHUP_ACCRUALS call');

Line 4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;

4517: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4518: l_api_name VARCHAR2(30) := 'CREATE_ACCRUALS_FORMULA';
4519: l_api_version CONSTANT NUMBER := 1.0;
4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

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

4520: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

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

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

Line 5374: OKL_TXL_CNTRCT_LNS txl,

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