APPS.CSM_MTL_PARAMETERS_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 30: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

26: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
27: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
28: l_dsql varchar2(2048);
29: l_pub_item VARCHAR2(30) := 'CSM_MTL_PARAMETERS';
30: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
31: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
32: l_mark_dirty boolean;
33: l_all_omfs_palm_resource_list asg_download.user_list;
34: l_null_resource_list asg_download.user_list;

Line 45: FROM jtm_con_request_data

41:
42: CURSOR l_last_run_date_csr
43: IS
44: SELECT nvl(last_run_date, (sysdate - 365*50))
45: FROM jtm_con_request_data
46: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
47: AND procedure_name = 'REFRESH_ACC';
48:
49: -- inserts cur

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

180: );
181:
182: END LOOP;
183:
184: -- set the program update date in jtm_con_request_data to sysdate
185: UPDATE jtm_con_request_data
186: SET last_run_date = l_run_date
187: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
188: AND procedure_name = 'REFRESH_ACC';

Line 185: UPDATE jtm_con_request_data

181:
182: END LOOP;
183:
184: -- set the program update date in jtm_con_request_data to sysdate
185: UPDATE jtm_con_request_data
186: SET last_run_date = l_run_date
187: WHERE package_name = 'CSM_MTL_PARAMETERS_EVENT_PKG'
188: AND procedure_name = 'REFRESH_ACC';
189: