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 3331: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

3327: -- local variables
3328: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
3329: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
3330: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
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';

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

3438: -- Check if records were found for reversal
3439: IF l_tcnv_tbl.COUNT > 0 THEN
3440:
3441: WRITE_TO_LOG('Records were identified for reversal');
3442: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
3443: -- Call the Reverse Accounting API
3444: Okl_Reversal_Pub.REVERSE_ENTRIES(
3445: p_api_version => p_api_version,
3446: p_init_msg_list => p_init_msg_list,

Line 3444: Okl_Reversal_Pub.REVERSE_ENTRIES(

3440:
3441: WRITE_TO_LOG('Records were identified for reversal');
3442: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
3443: -- Call the Reverse Accounting API
3444: Okl_Reversal_Pub.REVERSE_ENTRIES(
3445: p_api_version => p_api_version,
3446: p_init_msg_list => p_init_msg_list,
3447: x_return_status => x_return_status,
3448: x_msg_count => x_msg_count,

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

3449: x_msg_data => x_msg_data,
3450: p_source_table => l_source_table,
3451: p_acct_date => p_reverse_rec.accrual_date,
3452: p_source_id_tbl => l_source_id_tbl);
3453: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);
3454: -- store the highest degree of error
3455: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
3456: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3457: -- need to leave

Line 3692: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

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

Line 3801: Okl_Reversal_Pub.REVERSE_ENTRIES(

3797:
3798: -- Check if records were found for reversal
3799: IF l_tcnv_tbl.COUNT > 0 THEN
3800: -- Call the Reverse Accounting API
3801: Okl_Reversal_Pub.REVERSE_ENTRIES(
3802: p_api_version => p_api_version,
3803: p_init_msg_list => p_init_msg_list,
3804: x_return_status => x_return_status,
3805: x_msg_count => x_msg_count,

Line 3929: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

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

Line 4017: Okl_Reversal_Pub.REVERSE_ENTRIES(

4013:
4014: -- Check if records were found for reversal
4015: IF l_tcnv_tbl.COUNT > 0 THEN
4016: -- Call the Reverse Accounting API
4017: Okl_Reversal_Pub.REVERSE_ENTRIES(
4018: p_api_version => p_api_version,
4019: p_init_msg_list => p_init_msg_list,
4020: x_return_status => x_return_status,
4021: x_msg_count => x_msg_count,

Line 4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;

4139: -- local variables
4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

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

4243:
4244: -- Proceed if records are available for processing
4245: IF l_tcnv_tbl.COUNT > 0 THEN
4246: WRITE_TO_LOG('Records were identified for catchup');
4247: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
4248:
4249: -- Call the Reverse Accounting API
4250: Okl_Reversal_Pub.REVERSE_ENTRIES(
4251: p_api_version => p_api_version,

Line 4250: Okl_Reversal_Pub.REVERSE_ENTRIES(

4246: WRITE_TO_LOG('Records were identified for catchup');
4247: WRITE_TO_LOG('Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
4248:
4249: -- Call the Reverse Accounting API
4250: Okl_Reversal_Pub.REVERSE_ENTRIES(
4251: p_api_version => p_api_version,
4252: p_init_msg_list => p_init_msg_list,
4253: x_return_status => x_return_status,
4254: x_msg_count => x_msg_count,

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

4255: x_msg_data => x_msg_data,
4256: p_source_table => l_source_table,
4257: p_acct_date => p_catchup_rec.accrual_date,
4258: p_source_id_tbl => l_source_id_tbl);
4259: WRITE_TO_LOG('Return status after the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||x_return_status);
4260:
4261: -- store the highest degree of error
4262: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4263: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN