The following lines contain the word 'select', 'insert', 'update' or 'delete':
update_pop_action_status
This procedure updates the action population then issues a commit.
*/
procedure update_pop_action_status(p_payroll_action_id in number,
p_status in varchar2)
is
begin
--
UPDATE PAY_PAYROLL_ACTIONS PAC
SET PAC.ACTION_POPULATION_STATUS = p_status,
PAC.LAST_UPDATE_DATE = SYSDATE,
PAC.LAST_UPDATED_BY = g_user_id,
PAC.LAST_UPDATE_LOGIN = g_login_id
WHERE PAC.PAYROLL_ACTION_ID = p_payroll_action_id;
end update_pop_action_status;