DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_TRNS_ACC_DSTRS

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