32: l_run_date date;
33: l_sqlerrno varchar2(20);
34: l_sqlerrmsg varchar2(2000);
35: l_mark_dirty boolean;
36: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
37: l_access_id jtm_fnd_lookups_acc.access_id%TYPE;
38: l_tl_omfs_palm_resource_list asg_download.user_list;
39: l_null_resource_list asg_download.user_list;
40: l_single_access_id_list asg_download.access_list;
44:
45: CURSOR l_last_run_date_csr(p_pub_item IN varchar2)
46: IS
47: SELECT nvl(last_run_date, (sysdate - 365*50))
48: FROM jtm_con_request_data
49: WHERE package_name = 'CSM_UOM_EVENT_PKG'
50: AND procedure_name = 'REFRESH_ACC';
51:
52: -- inserts cursor
191: INSERT_CSM_UOM_TL_ACC (l_access_id, r_uom_ins_rec.uom_code , r_uom_ins_rec.language);
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_UOM_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';
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_UOM_EVENT_PKG'
199: AND procedure_name = 'REFRESH_ACC';
200: