DBA Data[Home] [Help]

APPS.CSE_COST_COLLECTOR dependencies on CSE_IPA_TRANS_PKG

Line 188: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;

184: l_txn_action_id NUMBER ;
185: l_eib_costing_used VARCHAR2(1);
186: l_redeploy_flag VARCHAR2(1);
187:
188: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;
189:
190: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
191: SELECT ho.name
192: FROM hr_all_organization_units ho, hr_all_organization_units hoc

Line 347: cse_ipa_trans_pkg.populate_pa_interface(l_pa_interface_tbl, l_return_status, l_error_message);

343: END LOOP ;
344:
345: IF i > 0 THEN
346: debug('Calling Populate PA Interface..');
347: cse_ipa_trans_pkg.populate_pa_interface(l_pa_interface_tbl, l_return_status, l_error_message);
348: END IF ;
349:
350: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: l_msg_index := 1;

Line 505: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;

501: l_ref_suffix NUMBER;
502: l_sysdate DATE;
503: l_user_id NUMBER;
504: i NUMBER;
505: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
506: l_return_status VARCHAR2(1);
507: l_error_message VARCHAR2(2000);
508: e_next EXCEPTION ;
509: l_api_version NUMBER := 1.0;

Line 637: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);

633: END IF ; ---l_redeploy_flag
634: END LOOP ; --csi_pending_txn_cur
635:
636: IF l_txn_processed AND i > 0 THEN
637: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
638: CSE_IPA_TRANS_PKG.populate_pa_interface(
639: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
640: x_return_status => l_return_status,
641: x_error_message => l_error_message);

Line 638: CSE_IPA_TRANS_PKG.populate_pa_interface(

634: END LOOP ; --csi_pending_txn_cur
635:
636: IF l_txn_processed AND i > 0 THEN
637: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
638: CSE_IPA_TRANS_PKG.populate_pa_interface(
639: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
640: x_return_status => l_return_status,
641: x_error_message => l_error_message);
642:

Line 680: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);

676: COMMIT ;
677: END IF ; ----l_txn_processed.
678: EXCEPTION
679: WHEN e_next THEN
680: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);
681: ROLLBACK TO A ;
682: END ; --csi_txn_cur
683: END LOOP ; --csi_txn_cur
684: EXCEPTION