328: END LOOP;
329: CLOSE l_profiles_ins_csr;
330:
331:
332: -- set the program update date in jtm_con_request_data to sysdate
333: UPDATE jtm_con_request_data
334: SET last_run_date = sysdate,
335: last_update_date = SYSDATE
336: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
329: CLOSE l_profiles_ins_csr;
330:
331:
332: -- set the program update date in jtm_con_request_data to sysdate
333: UPDATE jtm_con_request_data
334: SET last_run_date = sysdate,
335: last_update_date = SYSDATE
336: WHERE package_name = 'CSM_PROFILE_EVENT_PKG'
337: AND procedure_name = 'REFRESH_ACC';