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.15 2007/12/28 00:54:13 rsripada 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 254: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'

250:
251: -- set the program update date in jtm_con_request_data to sysdate
252: UPDATE jtm_con_request_data
253: SET last_run_date = l_run_date
254: WHERE package_name = 'CSM_LOOKUP_EVENT_PKG'
255: AND procedure_name = 'REFRESH_ACC';
256:
257: COMMIT;
258:

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

256:
257: COMMIT;
258:
259: p_status := 'FINE';
260: p_message := 'CSM_LOOKUP_EVENT_PKG.Refresh_Acc Executed successfully';
261:
262: EXCEPTION
263: WHEN others THEN
264: l_sqlerrno := to_char(SQLCODE);

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

263: WHEN others THEN
264: l_sqlerrno := to_char(SQLCODE);
265: l_sqlerrmsg := substr(SQLERRM, 1,2000);
266: p_status := 'Error';
267: p_message := 'Error in CSM_LOOKUP_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;
268: fnd_file.put_line(fnd_file.log, p_message);
269: END Refresh_Acc;
270: END CSM_LOOKUP_EVENT_PKG;

Line 270: END CSM_LOOKUP_EVENT_PKG;

266: p_status := 'Error';
267: p_message := 'Error in CSM_LOOKUP_EVENT_PKG.Refresh_Acc : ' || l_sqlerrno || ':' || l_sqlerrmsg;
268: fnd_file.put_line(fnd_file.log, p_message);
269: END Refresh_Acc;
270: END CSM_LOOKUP_EVENT_PKG;