DBA Data[Home] [Help]

APPS.CSE_COST_COLLECTOR dependencies on CSE_IPA_TRANS_PKG

Line 175: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;

171: l_txn_action_id NUMBER ;
172: l_eib_costing_used VARCHAR2(1);
173: l_redeploy_flag VARCHAR2(1);
174:
175: l_pa_interface_tbl cse_ipa_trans_pkg.nl_pa_interface_tbl_type ;
176:
177: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
178: SELECT ho.name
179: FROM hr_all_organization_units ho, hr_all_organization_units hoc

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

330: END LOOP ;
331:
332: IF i > 0 THEN
333: debug('Calling Populate PA Interface..');
334: cse_ipa_trans_pkg.populate_pa_interface(l_pa_interface_tbl, l_return_status, l_error_message);
335: END IF ;
336:
337: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
338: l_msg_index := 1;

Line 492: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;

488: l_ref_suffix NUMBER;
489: l_sysdate DATE;
490: l_user_id NUMBER;
491: i NUMBER;
492: l_nl_pa_interface_tbl CSE_IPA_TRANS_PKG.nl_pa_interface_tbl_type;
493: l_return_status VARCHAR2(1);
494: l_error_message VARCHAR2(2000);
495: e_next EXCEPTION ;
496: l_api_version NUMBER := 1.0;

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

620: END IF ; ---l_redeploy_flag
621: END LOOP ; --csi_pending_txn_cur
622:
623: IF l_txn_processed AND i > 0 THEN
624: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
625: CSE_IPA_TRANS_PKG.populate_pa_interface(
626: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
627: x_return_status => l_return_status,
628: x_error_message => l_error_message);

Line 625: CSE_IPA_TRANS_PKG.populate_pa_interface(

621: END LOOP ; --csi_pending_txn_cur
622:
623: IF l_txn_processed AND i > 0 THEN
624: cse_util_pkg.write_log('Calling cse_ipa_trans_pkg.populate_pa_interface, number of recs: '||i);
625: CSE_IPA_TRANS_PKG.populate_pa_interface(
626: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
627: x_return_status => l_return_status,
628: x_error_message => l_error_message);
629:

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

663: COMMIT ;
664: END IF ; ----l_txn_processed.
665: EXCEPTION
666: WHEN e_next THEN
667: cse_util_pkg.write_log('Call to cse_ipa_trans_pkg.populate_pa_interface failed :'||l_error_message);
668: ROLLBACK TO A ;
669: END ; --csi_txn_cur
670: END LOOP ; --csi_txn_cur
671: EXCEPTION