APPS.CSM_MESSAGES_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 22: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

18: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
19: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
20: l_dsql varchar2(2048);
21: l_pub_item varchar2(30) := 'CSF_M_MESSAGES';
22: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
23: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
24: l_mark_dirty boolean;
25: l_tl_omfs_palm_resource_list asg_download.user_list;
26: l_null_resource_list asg_download.user_list;

Line 37: FROM jtm_con_request_data

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

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

191: );
192:
193: END LOOP;
194:
195: -- set the program update date in jtm_con_request_data to sysdate
196: UPDATE jtm_con_request_data
197: SET last_run_date = l_run_date
198: WHERE package_name = 'CSM_MESSAGES_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';

Line 196: UPDATE jtm_con_request_data

192:
193: END LOOP;
194:
195: -- set the program update date in jtm_con_request_data to sysdate
196: UPDATE jtm_con_request_data
197: SET last_run_date = l_run_date
198: WHERE package_name = 'CSM_MESSAGES_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';
200: