APPS.CSM_CURRENCY_EVENT_PKG dependencies on CSM_CURRENCY_EVENT_PKG

Line 1: PACKAGE BODY CSM_CURRENCY_EVENT_PKG AS

1: PACKAGE BODY CSM_CURRENCY_EVENT_PKG AS
2: /* $Header: csmecurb.pls 120.1 2005/07/22 09:29:28 trajasek noship $ */
3:
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 37: WHERE package_name = 'CSM_CURRENCY_EVENT_PKG'

33: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
34: IS
35: SELECT nvl(last_run_date, (sysdate - 365*50))
36: FROM jtm_con_request_data
37: WHERE package_name = 'CSM_CURRENCY_EVENT_PKG'
38: AND procedure_name = 'REFRESH_ACC';
39:
40:
41: CURSOR l_deletes_csr(p_last_upd_date date)

Line 224: WHERE package_name = 'CSM_CURRENCY_EVENT_PKG'

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

Line 230: p_message := 'CSM_CURRENCY_EVENT_PKG.REFRESH_ACC Executed successfully';

226:
227: commit;
228:
229: p_status := 'FINE';
230: p_message := 'CSM_CURRENCY_EVENT_PKG.REFRESH_ACC Executed successfully';
231:
232: EXCEPTION
233: WHEN others THEN
234: l_sqlerrno := to_char(SQLCODE);

Line 237: p_message := 'Error in CSM_CURRENCY_EVENT_PKG.REFRESH_ACC :' ||l_sqlerrno || ':' ||l_sqlerrmsg;

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

Line 385: END CSM_CURRENCY_EVENT_PKG;

381:
382: END refresh_acc;
383: */
384:
385: END CSM_CURRENCY_EVENT_PKG;