APPS.FEM_BR_MAPPING_RULE_PVT dependencies on FEM_OBJDEF_HELPER_RULES

Line 430: -- 2) delete each helper obj def and unregister from fem_objdef_helper_rules

426: -- helper rules.
427: -- Logic is as follows:
428: -- 1) For the map rule - get all helper obj defs that are in use for the
429: -- map rule obj def, but not in use for a diff map rule obj def
430: -- 2) delete each helper obj def and unregister from fem_objdef_helper_rules
431: -- table for that map rule obj def+ helper obj def combo
432: -- 3) check if the helper obj def being deleted has any other obj defs for
433: -- the helper object + helper obj type combo. If not, then delete the
434: -- helper object also

Line 453: FROM fem_objdef_helper_rules

449:
450:
451: cursor c_helper_rules (p_rule_def_id IN NUMBER) IS
452: SELECT helper_obj_def_id, helper_object_id, helper_object_type_code
453: FROM fem_objdef_helper_rules
454: WHERE object_definition_id = p_rule_def_id
455: AND helper_obj_def_id NOT IN (select helper_obj_def_id
456: FROM fem_objdef_helper_rules
457: WHERE object_definition_id <> p_rule_def_id);

Line 456: FROM fem_objdef_helper_rules

452: SELECT helper_obj_def_id, helper_object_id, helper_object_type_code
453: FROM fem_objdef_helper_rules
454: WHERE object_definition_id = p_rule_def_id
455: AND helper_obj_def_id NOT IN (select helper_obj_def_id
456: FROM fem_objdef_helper_rules
457: WHERE object_definition_id <> p_rule_def_id);
458:
459:
460:

Line 517: DELETE FROM fem_objdef_helper_rules

513:
514:
515: /* Last step - delete all of the helper rule registrations for the object def
516: being deleted*/
517: DELETE FROM fem_objdef_helper_rules
518: WHERE object_definition_id = p_obj_def_id;
519:
520:
521: END DeleteHelperRecs;