[Home] [Help]
120: -- PROCEDURE
121: -- DeleteObjectDetails
122: --
123: -- DESCRIPTION
124: -- Deletes the object extension data from fem_alloc_br_objects
125: -- for mapping rules.
126: --
127: -- IN
128: -- p_obj_id - Object ID.
421: -- DeleteHelperRecs
422: --
423: -- DESCRIPTION
424: -- Deletes a Mapping Rule Object data performing deletes on records
425: -- in the FEM_ALLOC_BR_OBJECTS table. Also cleans up the associated
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
524: -- PROCEDURE
525: -- DeleteBrObjectRec
526: --
527: -- DESCRIPTION
528: -- Deletes the record in FEM_ALLOC_BR_OBJECTS for the map rule object
529: --
530: -- IN
531: -- p_obj_id - Object ID.
532: --
537: --------------------------------------------------------------------------------
538: IS
539: BEGIN
540:
541: delete from fem_alloc_br_objects
542: where map_rule_object_id = p_obj_id;
543:
544: END DeleteBrObjectRec;
545:
708: -- CopyBrObjectRec
709: --
710: -- DESCRIPTION
711: -- Creates a new Mapping Rule object by copying the record in the
712: -- FEM_ALLOC_BR_OBJECTS table.
713: --
714: -- IN
715: -- p_source_obj_id - Source Object ID.
716: -- p_target_obj_id - Target Object ID.
727: --------------------------------------------------------------------------------
728: IS
729: BEGIN
730:
731: insert into fem_alloc_br_objects (
732: MAP_RULE_OBJECT_ID
733: ,MAP_RULE_TYPE_CODE
734: ,OBJECT_VERSION_NUMBER
735: ,CREATION_DATE
745: ,nvl(p_created_by,created_by)
746: ,FND_GLOBAL.user_id
747: ,sysdate
748: ,FND_GLOBAL.login_id
749: from fem_alloc_br_objects
750: where map_rule_object_id = p_source_obj_id;
751:
752: END CopyBrObjectRec;
753: