294:
295: CURSOR l_last_run_date_csr
296: IS
297: SELECT nvl(last_run_date, (sysdate - 365*50))
298: FROM jtm_con_request_data
299: WHERE package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
300: AND procedure_name = 'REFRESH_INSTANCES_ACC';
301:
302: -- get expired instances
753: END LOOP;
754: CLOSE l_itemrelationships_ins_csr;
755:
756:
757: -- set the program update date in jtm_con_request_data to sysdate
758: UPDATE jtm_con_request_data
759: SET last_run_date = l_current_run_date
760: WHERE product_code = 'CSM'
761: AND package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
754: CLOSE l_itemrelationships_ins_csr;
755:
756:
757: -- set the program update date in jtm_con_request_data to sysdate
758: UPDATE jtm_con_request_data
759: SET last_run_date = l_current_run_date
760: WHERE product_code = 'CSM'
761: AND package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
762: AND procedure_name = 'REFRESH_INSTANCES_ACC';