28: ON "APPS"."PAY_PAYROLL_ACTIONS" for each row
29: WHEN (OLD.action_status <> NEW.action_status) begin
30: if hr_general.g_data_migrator_mode <> 'Y' then
31: --
32: hr_utility.set_location('pay_payroll_actions_bru',10);
33: if (:NEW.action_status <> :OLD.action_status) then
34: --
35: if (:OLD.action_status = 'C' and :NEW.action_status = 'M') then
36: -- doing a Retry operation
33: if (:NEW.action_status <> :OLD.action_status) then
34: --
35: if (:OLD.action_status = 'C' and :NEW.action_status = 'M') then
36: -- doing a Retry operation
37: hr_utility.set_location('pay_payroll_actions_bru',2);
38: --
39: /* hr_ass_actions.rollback_payroll_action(:OLD.payroll_action_id,
40: :OLD.action_type,
41: :OLD.effective_date,
46: or (:NEW.action_status = 'E' and :OLD.action_status <> 'C')) then
47: null;
48: --
49: else
50: hr_utility.set_message(801,'HR_BAD_UPDATE');
51: hr_utility.raise_error;
52: end if;
53: --
54: end if;
47: null;
48: --
49: else
50: hr_utility.set_message(801,'HR_BAD_UPDATE');
51: hr_utility.raise_error;
52: end if;
53: --
54: end if;
55: hr_utility.set_location('pay_payroll_actions_bru',3);
51: hr_utility.raise_error;
52: end if;
53: --
54: end if;
55: hr_utility.set_location('pay_payroll_actions_bru',3);
56: end if;
57: end pay_payroll_actions_bru;
58: