8: ON "APPS"."PAY_ELEMENT_TYPES_F" for each row
9: --
10: begin
11: if hr_general.g_data_migrator_mode <> 'Y' then
12: hr_utility.set_location ('PAY_ELEMENT_TYPES_T1',1);
13: --
14: if ((:old.indirect_only_flag <> :new.indirect_only_flag or
15: :old.process_in_run_flag <> :new.process_in_run_flag or
16: :old.post_termination_rule <> :new.post_termination_rule) and
15: :old.process_in_run_flag <> :new.process_in_run_flag or
16: :old.post_termination_rule <> :new.post_termination_rule) and
17: pay_element_types_pkg.run_results_exist (:new.element_type_id)) then
18: --
19: hr_utility.set_message (801,'PAY_6909_ELEMENT_NO_UPD_RR');
20: hr_utility.raise_error;
21: --
22: elsif (:old.adjustment_only_flag <> :new.adjustment_only_flag and
23: pay_element_types_pkg.fed_by_indirect_results (:new.element_type_id)) then
16: :old.post_termination_rule <> :new.post_termination_rule) and
17: pay_element_types_pkg.run_results_exist (:new.element_type_id)) then
18: --
19: hr_utility.set_message (801,'PAY_6909_ELEMENT_NO_UPD_RR');
20: hr_utility.raise_error;
21: --
22: elsif (:old.adjustment_only_flag <> :new.adjustment_only_flag and
23: pay_element_types_pkg.fed_by_indirect_results (:new.element_type_id)) then
24: --
21: --
22: elsif (:old.adjustment_only_flag <> :new.adjustment_only_flag and
23: pay_element_types_pkg.fed_by_indirect_results (:new.element_type_id)) then
24: --
25: hr_utility.set_message (801,'PAY_6912_ELEMENT_NO_FRR_UPD');
26: hr_utility.raise_error;
27: --
28: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
29: and pay_element_types_pkg.update_recurring_rules_exist (:new.element_type_id)) then
22: elsif (:old.adjustment_only_flag <> :new.adjustment_only_flag and
23: pay_element_types_pkg.fed_by_indirect_results (:new.element_type_id)) then
24: --
25: hr_utility.set_message (801,'PAY_6912_ELEMENT_NO_FRR_UPD');
26: hr_utility.raise_error;
27: --
28: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
29: and pay_element_types_pkg.update_recurring_rules_exist (:new.element_type_id)) then
30: --
27: --
28: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
29: and pay_element_types_pkg.update_recurring_rules_exist (:new.element_type_id)) then
30: --
31: hr_utility.set_message (801,'HR_6954_PAY_ELE_NO_UPD_REC');
32: hr_utility.raise_error;
33: --
34: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
35: and pay_element_types_pkg.stop_entry_rules_exist (:new.element_type_id)) then
28: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
29: and pay_element_types_pkg.update_recurring_rules_exist (:new.element_type_id)) then
30: --
31: hr_utility.set_message (801,'HR_6954_PAY_ELE_NO_UPD_REC');
32: hr_utility.raise_error;
33: --
34: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
35: and pay_element_types_pkg.stop_entry_rules_exist (:new.element_type_id)) then
36: --
33: --
34: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
35: and pay_element_types_pkg.stop_entry_rules_exist (:new.element_type_id)) then
36: --
37: hr_utility.set_message (801,'PAY_6953_PAY_ELE_NO_STOP_ENTRY');
38: hr_utility.raise_error;
39: --
40: end if;
41: --
34: elsif (:old.multiple_entries_allowed_flag <> :new.multiple_entries_allowed_flag
35: and pay_element_types_pkg.stop_entry_rules_exist (:new.element_type_id)) then
36: --
37: hr_utility.set_message (801,'PAY_6953_PAY_ELE_NO_STOP_ENTRY');
38: hr_utility.raise_error;
39: --
40: end if;
41: --
42: --