[Home] [Help]
4: ON "APPS"."PAY_BALANCE_FEEDS_F" for each row
5: begin
6: if hr_general.g_data_migrator_mode <> 'Y' then
7: -- certain updates are not allowed !
8: hr_utility.set_location('pay_balance_feeds_aru',1);
9: if :OLD.balance_type_id <> :NEW.balance_type_id
10: or :OLD.input_value_id <> :NEW.input_value_id
11: or :OLD.balance_feed_id <> :NEW.balance_feed_id
12: or :OLD.business_group_id <> :NEW.business_group_id
11: or :OLD.balance_feed_id <> :NEW.balance_feed_id
12: or :OLD.business_group_id <> :NEW.business_group_id
13: or :OLD.legislation_code <> :NEW.legislation_code
14: then
15: hr_utility.set_message(801, 'HR_BAD_UPDATE');
16: hr_utility.raise_error;
17: end if;
18: --
19: -- delete any potentially damaged latest balances
12: or :OLD.business_group_id <> :NEW.business_group_id
13: or :OLD.legislation_code <> :NEW.legislation_code
14: then
15: hr_utility.set_message(801, 'HR_BAD_UPDATE');
16: hr_utility.raise_error;
17: end if;
18: --
19: -- delete any potentially damaged latest balances
20: hr_utility.set_location('pay_balance_feeds_aru',2);
16: hr_utility.raise_error;
17: end if;
18: --
19: -- delete any potentially damaged latest balances
20: hr_utility.set_location('pay_balance_feeds_aru',2);
21: hrassact.trash_latest_balances(:OLD.balance_type_id,
22: :OLD.input_value_id,
23: least(:NEW.effective_end_date,:OLD.effective_end_date));
24: --
21: hrassact.trash_latest_balances(:OLD.balance_type_id,
22: :OLD.input_value_id,
23: least(:NEW.effective_end_date,:OLD.effective_end_date));
24: --
25: hr_utility.set_location('pay_balance_feeds_aru',3);
26: --
27: -- set affected run balances to invalid
28: --
29: pay_balance_pkg.invalidate_run_balances(:OLD.balance_type_id,
29: pay_balance_pkg.invalidate_run_balances(:OLD.balance_type_id,
30: :OLD.input_value_id,
31: least(:NEW.effective_end_date,:OLD.effective_end_date));
32: --
33: hr_utility.set_location('pay_balance_feeds_aru',5);
34: end if;
35: end pay_balance_feeds_aru;
36: