[Home] [Help]
779: where formula_result_rule_id = p_core_object_id;
780: --
781: cursor csr_spr_core_object_exists(p_core_object_id in number) is
782: select count(0)
783: from pay_status_processing_rules_f
784: where status_processing_rule_id = p_core_object_id;
785: --
786: cursor csr_sir_core_object_exists(p_core_object_id in number) is
787: select count(0)
2505: l_status_processing_rule_id :=
2506: p_spr_core_objects(l_shadow_element_type_id).core_object_id;
2507: else
2508: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2509: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2510: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2511: hr_utility.raise_error;
2512: end if;
2513: -------------------------------------------------------------------
2525: l_input_value_id :=
2526: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2527: else
2528: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2529: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2530: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2531: hr_utility.raise_error;
2532: end if;
2533: end if;
2543: l_element_type_id :=
2544: p_set_core_objects(l_shadow_element_type_id).core_object_id;
2545: else
2546: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2547: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2548: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2549: hr_utility.raise_error;
2550: end if;
2551: elsif p_formula_rules(i).element_name is not null then
3550: cursor csr_status_rules_lock(p_status_processing_rule_id in number) is
3551: select status_processing_rule_id
3552: , rowid
3553: , effective_start_date
3554: from pay_status_processing_rules_f
3555: where status_processing_rule_id = p_status_processing_rule_id
3556: for update of status_processing_rule_id;
3557: --
3558: cursor csr_formula_rules_lock(p_formula_result_rule_id in number) is