APPS.CSM_LOOKUP_EVENT_PKG dependencies on CSM_LOOKUP_EVENT_PKG

Line 1: PACKAGE BODY CSM_LOOKUP_EVENT_PKG AS

1: PACKAGE BODY CSM_LOOKUP_EVENT_PKG AS
2: /* $Header: csmelkub.pls 120.17.12020000.2 2013/04/09 10:55:44 saradhak ship $ */
3:
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 45: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'

41: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
42: IS
43: SELECT nvl(last_run_date, (sysdate - 365*50))
44: FROM jtm_con_request_data
45: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'
46: AND procedure_name = 'REFRESH_ACC';
47:
48: -- inserts cursor
49: CURSOR l_lookups_ins_csr(p_last_upd_date date)

Line 265: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'

261:
262: -- set the program update date in jtm_con_request_data to sysdate
263: UPDATE jtm_con_request_data
264: SET last_run_date = l_run_date
265: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'
266: AND procedure_name = 'REFRESH_ACC';
267:
268: COMMIT;
269:

Line 271: p_message := 'CSM_LOOKUP_EVENT_PKG.Refresh_Acc Executed successfully';

267:
268: COMMIT;
269:
270: p_status := 'FINE';
271: p_message := 'CSM_LOOKUP_EVENT_PKG.Refresh_Acc Executed successfully';
272:
273: EXCEPTION
274: WHEN others THEN
275: l_sqlerrno := to_char(SQLCODE);

Line 278: p_message := 'Error in CSM_LOOKUP_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;

274: WHEN others THEN
275: l_sqlerrno := to_char(SQLCODE);
276: l_sqlerrmsg := substr(SQLERRM, 1,2000);
277: p_status := 'Error';
278: p_message := 'Error in CSM_LOOKUP_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;
279: fnd_file.put_line(fnd_file.log, p_message);
280: END Refresh_Acc;
281: END CSM_LOOKUP_EVENT_PKG;

Line 281: END CSM_LOOKUP_EVENT_PKG;

277: p_status := 'Error';
278: p_message := 'Error in CSM_LOOKUP_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;
279: fnd_file.put_line(fnd_file.log, p_message);
280: END Refresh_Acc;
281: END CSM_LOOKUP_EVENT_PKG;