819: l_status := 'PROCESSED';
820: --
821: END IF;
822: --
823: -- Update the row in hri_adm_mthd_actions to store the
824: -- process information
825: --
826: UPDATE hri_adm_mthd_actions
827: SET status = l_status,
822: --
823: -- Update the row in hri_adm_mthd_actions to store the
824: -- process information
825: --
826: UPDATE hri_adm_mthd_actions
827: SET status = l_status,
828: end_time = sysdate,
829: collect_from_date = p_period_from,
830: collect_to_date = p_period_to,