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_REVERSAL_PUB

Line 3577: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

3573: -- local variables
3574: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3575: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3576: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
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';

Line 3688: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');

3684: -- Check if records were found for reversal
3685: IF l_tcnv_tbl.COUNT > 0 THEN
3686:
3687: WRITE_TO_LOG('Records were identified for reversal');
3688: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
3689: -- Call the Reverse Accounting API
3690: Okl_Reversal_Pub.REVERSE_ENTRIES(
3691: p_api_version => p_api_version,
3692: p_init_msg_list => p_init_msg_list,

Line 3690: Okl_Reversal_Pub.REVERSE_ENTRIES(

3686:
3687: WRITE_TO_LOG('Records were identified for reversal');
3688: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
3689: -- Call the Reverse Accounting API
3690: Okl_Reversal_Pub.REVERSE_ENTRIES(
3691: p_api_version => p_api_version,
3692: p_init_msg_list => p_init_msg_list,
3693: x_return_status => x_return_status,
3694: x_msg_count => x_msg_count,

Line 3699: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);

3695: x_msg_data => x_msg_data,
3696: p_source_table => l_source_table,
3697: p_acct_date => p_reverse_rec.accrual_date,
3698: p_source_id_tbl => l_source_id_tbl);
3699: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);
3700: -- store the highest degree of error
3701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3702: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3703: -- need to leave

Line 3938: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

3934: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
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);

Line 4047: Okl_Reversal_Pub.REVERSE_ENTRIES(

4043:
4044: -- Check if records were found for reversal
4045: IF l_tcnv_tbl.COUNT > 0 THEN
4046: -- Call the Reverse Accounting API
4047: Okl_Reversal_Pub.REVERSE_ENTRIES(
4048: p_api_version => p_api_version,
4049: p_init_msg_list => p_init_msg_list,
4050: x_return_status => x_return_status,
4051: x_msg_count => x_msg_count,

Line 4175: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

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

Line 4263: Okl_Reversal_Pub.REVERSE_ENTRIES(

4259:
4260: -- Check if records were found for reversal
4261: IF l_tcnv_tbl.COUNT > 0 THEN
4262: -- Call the Reverse Accounting API
4263: Okl_Reversal_Pub.REVERSE_ENTRIES(
4264: p_api_version => p_api_version,
4265: p_init_msg_list => p_init_msg_list,
4266: x_return_status => x_return_status,
4267: x_msg_count => x_msg_count,

Line 4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

4385: -- local variables
4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

Line 4493: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');

4489:
4490: -- Proceed if records are available for processing
4491: IF l_tcnv_tbl.COUNT > 0 THEN
4492: WRITE_TO_LOG('Records were identified for catchup');
4493: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
4494:
4495: -- Call the Reverse Accounting API
4496: Okl_Reversal_Pub.REVERSE_ENTRIES(
4497: p_api_version => p_api_version,

Line 4496: Okl_Reversal_Pub.REVERSE_ENTRIES(

4492: WRITE_TO_LOG('Records were identified for catchup');
4493: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
4494:
4495: -- Call the Reverse Accounting API
4496: Okl_Reversal_Pub.REVERSE_ENTRIES(
4497: p_api_version => p_api_version,
4498: p_init_msg_list => p_init_msg_list,
4499: x_return_status => x_return_status,
4500: x_msg_count => x_msg_count,

Line 4505: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);

4501: x_msg_data => x_msg_data,
4502: p_source_table => l_source_table,
4503: p_acct_date => p_catchup_rec.accrual_date,
4504: p_source_id_tbl => l_source_id_tbl);
4505: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);
4506:
4507: -- store the highest degree of error
4508: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4509: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN