APPS.CSM_LOOKUP_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 28: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

24: p_message OUT NOCOPY VARCHAR2)
25: IS
26: PRAGMA AUTONOMOUS_TRANSACTION;
27: --variable Declarations
28: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
29: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
30: l_mark_dirty boolean;
31: l_run_date date;
32: l_sqlerrno VARCHAR2(20);

Line 44: FROM jtm_con_request_data

40:
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

Line 251: -- set the program update date in jtm_con_request_data to sysdate

247: );
248:
249: END LOOP;
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';

Line 252: UPDATE jtm_con_request_data

248:
249: END LOOP;
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: