APPS.CSM_CSI_ITEM_ATTR_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_CSI_ITEM_ATTR';
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_CSI_ITEM_ATTR_EVENT_PKG'
47: AND procedure_name = 'REFRESH_ACC';
48:
49: -- process inserts

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

145: ,P_USER_ID => r_csi_iea_values_ins_rec.user_id
146: );
147: END LOOP;
148:
149: -- set the program update date in jtm_con_request_data to sysdate
150: UPDATE jtm_con_request_data
151: SET last_run_date = l_run_date
152: WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'
153: AND procedure_name = 'REFRESH_ACC';

Line 150: UPDATE jtm_con_request_data

146: );
147: END LOOP;
148:
149: -- set the program update date in jtm_con_request_data to sysdate
150: UPDATE jtm_con_request_data
151: SET last_run_date = l_run_date
152: WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'
153: AND procedure_name = 'REFRESH_ACC';
154: