APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on CSM_BUS_PROCESS_TXNS_EVENT_PKG

Line 1: PACKAGE BODY CSM_BUS_PROCESS_TXNS_EVENT_PKG AS

1: PACKAGE BODY CSM_BUS_PROCESS_TXNS_EVENT_PKG AS
2: /* $Header: csmebptb.pls 120.1 2005/07/22 08:34:50 trajasek noship $ */
3:
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 39: WHERE package_name = 'CSM_BUS_PROCESS_TXNS_EVENT_PKG'

35: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
36: IS
37: SELECT nvl(last_run_date, (sysdate - 365*50) )
38: FROM jtm_con_request_data
39: WHERE package_name = 'CSM_BUS_PROCESS_TXNS_EVENT_PKG'
40: AND procedure_name = 'REFRESH_ACC';
41:
42: CURSOR l_deletes_cur
43: IS

Line 226: WHERE package_name = 'CSM_BUS_PROCESS_TXNS_EVENT_PKG'

222:
223: -- set the program update date in asg_pub_item to sysdate
224: UPDATE jtm_con_request_data
225: SET last_run_date = l_run_date
226: WHERE package_name = 'CSM_BUS_PROCESS_TXNS_EVENT_PKG'
227: AND procedure_name = 'REFRESH_ACC';
228:
229: commit;
230:

Line 232: p_message := 'CSM_BUS_PROCESS_TXNS_EVENT_PKG.Refresh_Acc Executed successfully';

228:
229: commit;
230:
231: p_status := 'FINE';
232: p_message := 'CSM_BUS_PROCESS_TXNS_EVENT_PKG.Refresh_Acc Executed successfully';
233:
234: EXCEPTION
235: WHEN others THEN
236: l_sqlerrno := to_char(SQLCODE);

Line 239: p_message := 'Error in CSM_BUS_PROCESS_TXNS_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;

235: WHEN others THEN
236: l_sqlerrno := to_char(SQLCODE);
237: l_sqlerrmsg := substr(SQLERRM, 1,2000);
238: p_status := 'ERROR';
239: p_message := 'Error in CSM_BUS_PROCESS_TXNS_EVENT_PKG.Refresh_Acc :' || l_sqlerrno || ':' || l_sqlerrmsg;
240: fnd_file.put_line(fnd_file.log, p_message);
241: ROLLBACK;
242: END Refresh_Acc;
243:

Line 244: END CSM_BUS_PROCESS_TXNS_EVENT_PKG;

240: fnd_file.put_line(fnd_file.log, p_message);
241: ROLLBACK;
242: END Refresh_Acc;
243:
244: END CSM_BUS_PROCESS_TXNS_EVENT_PKG;