DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_TRNS_ACC_DSTRS

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