DBA Data[Home] [Help]

APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_OBJECT_DEPENDENCIES

Line 24: | data in fem_object_dependencies

20: | 22-FEB-07 RFlippo added generate_condition_summary
21: | 16-MAR-07 RFlippo modified generate_condition_summary to store
22: | attr data type in the gt table
23: | 20-MAR-07 RFlippo modfied refresh_maprule_from_snapshot to handle
24: | data in fem_object_dependencies
25: | 27-MAR-07 RFlippo fixed issues with cr_new_ver_from_defaults; added
26: | get_default_definition
27: | 29-MAR-07 RFlippo added insert into fem_alloc_br_objects when create
28: | new default rule

Line 761: /* Refresh the data in fem_object_dependencies with the new dependency data

757: SET display_name = v_snap_objdef_name, description = v_snap_objdef_desc,
758: effective_start_date = v_snap_start_date, effective_end_date = v_snap_end_date
759: WHERE object_definition_id = p_map_rule_obj_def_id;
760:
761: /* Refresh the data in fem_object_dependencies with the new dependency data
762: for the rule. */
763:
764: DELETE FROM fem_object_dependencies
765: WHERE object_definition_id = p_map_rule_obj_def_id;

Line 764: DELETE FROM fem_object_dependencies

760:
761: /* Refresh the data in fem_object_dependencies with the new dependency data
762: for the rule. */
763:
764: DELETE FROM fem_object_dependencies
765: WHERE object_definition_id = p_map_rule_obj_def_id;
766:
767: FOR subobj IN c1 (p_map_rule_obj_def_id) LOOP
768: INSERT INTO fem_object_dependencies

Line 768: INSERT INTO fem_object_dependencies

764: DELETE FROM fem_object_dependencies
765: WHERE object_definition_id = p_map_rule_obj_def_id;
766:
767: FOR subobj IN c1 (p_map_rule_obj_def_id) LOOP
768: INSERT INTO fem_object_dependencies
769: (OBJECT_DEFINITION_ID
770: ,REQUIRED_OBJECT_ID
771: ,CREATED_BY
772: ,CREATION_DATE