293:
294: CURSOR l_last_run_date_csr
295: IS
296: SELECT nvl(last_run_date, (sysdate - 365*50))
297: FROM jtm_con_request_data
298: WHERE package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
299: AND procedure_name = 'REFRESH_INSTANCES_ACC';
300:
301: -- get expired instances
810: END IF;
811: END LOOP;
812:
813:
814: -- set the program update date in jtm_con_request_data to sysdate
815: UPDATE jtm_con_request_data
816: SET last_run_date = l_current_run_date
817: WHERE product_code = 'CSM'
818: AND package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
811: END LOOP;
812:
813:
814: -- set the program update date in jtm_con_request_data to sysdate
815: UPDATE jtm_con_request_data
816: SET last_run_date = l_current_run_date
817: WHERE product_code = 'CSM'
818: AND package_name = 'CSM_ITEM_INSTANCE_EVENT_PKG'
819: AND procedure_name = 'REFRESH_INSTANCES_ACC';