[Home] [Help]
776: where formula_result_rule_id = p_core_object_id;
777: --
778: cursor csr_spr_core_object_exists(p_core_object_id in number) is
779: select count(0)
780: from pay_status_processing_rules_f
781: where status_processing_rule_id = p_core_object_id;
782: --
783: cursor csr_sir_core_object_exists(p_core_object_id in number) is
784: select count(0)
2487: l_status_processing_rule_id :=
2488: p_spr_core_objects(l_shadow_element_type_id).core_object_id;
2489: else
2490: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2491: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2492: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2493: hr_utility.raise_error;
2494: end if;
2495: -------------------------------------------------------------------
2507: l_input_value_id :=
2508: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2509: else
2510: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2511: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2512: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2513: hr_utility.raise_error;
2514: end if;
2515: end if;
2525: l_element_type_id :=
2526: p_set_core_objects(l_shadow_element_type_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_ELEMENT_TYPES_F');
2531: hr_utility.raise_error;
2532: end if;
2533: elsif p_formula_rules(i).element_name is not null then
3532: cursor csr_status_rules_lock(p_status_processing_rule_id in number) is
3533: select status_processing_rule_id
3534: , rowid
3535: , effective_start_date
3536: from pay_status_processing_rules_f
3537: where status_processing_rule_id = p_status_processing_rule_id
3538: for update of status_processing_rule_id;
3539: --
3540: cursor csr_formula_rules_lock(p_formula_result_rule_id in number) is