APPS.FEM_BR_RULE_SET_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

PROCEDURE DeleteRuleSetRec(
   p_obj_def_id          IN          NUMBER
);

Line: 35

PROCEDURE DeleteMembersRec(
   p_obj_def_id          IN          NUMBER
);

Line: 108

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          IN          NUMBER
)
--------------------------------------------------------------------------------
IS

  G_API_NAME    CONSTANT VARCHAR2(30)   := 'DeleteObjectDefinition';

Line: 118

  DeleteRuleSetRec(
     p_obj_def_id  =>  p_obj_def_id
  );

Line: 122

  DeleteMembersRec(
     p_obj_def_id  =>  p_obj_def_id
  );

Line: 132

END DeleteObjectDefinition;

Line: 167

  INSERT INTO FEM_RULE_SETS (
    RULE_SET_OBJ_DEF_ID
    ,RULE_SET_OBJECT_TYPE_CODE
    ,OBJECT_VERSION_NUMBER
    ,CREATION_DATE
    ,CREATED_BY
    ,LAST_UPDATE_DATE
    ,LAST_UPDATED_BY
    ,LAST_UPDATE_LOGIN
  ) SELECT
    p_target_obj_def_id
    ,RULE_SET_OBJECT_TYPE_CODE
    ,OBJECT_VERSION_NUMBER
    ,NVL(p_creation_date,creation_date)
    ,NVL(p_created_by,created_by)
    ,SYSDATE
    ,FND_GLOBAL.user_id
    ,FND_GLOBAL.login_id
  FROM FEM_RULE_SETS
  WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;

Line: 216

  INSERT INTO FEM_RULE_SET_MEMBERS (
    RULE_SET_OBJ_DEF_ID
    ,CHILD_OBJ_ID
    ,CHILD_EXECUTION_SEQUENCE
    ,EXECUTE_CHILD_FLAG
    ,OBJECT_VERSION_NUMBER
    ,CREATION_DATE
    ,CREATED_BY
    ,LAST_UPDATE_DATE
    ,LAST_UPDATED_BY
    ,LAST_UPDATE_LOGIN
  ) SELECT
    p_target_obj_def_id
    ,CHILD_OBJ_ID
    ,CHILD_EXECUTION_SEQUENCE
    ,EXECUTE_CHILD_FLAG
    ,OBJECT_VERSION_NUMBER
    ,NVL(p_creation_date,creation_date)
    ,NVL(p_created_by,created_by)
    ,SYSDATE
    ,FND_GLOBAL.user_id
    ,FND_GLOBAL.login_id
  FROM FEM_RULE_SET_MEMBERS
  WHERE RULE_SET_OBJ_DEF_ID = p_source_obj_def_id;

Line: 255

PROCEDURE DeleteRuleSetRec(
  p_obj_def_id IN NUMBER
)
--------------------------------------------------------------------------------
IS
BEGIN

  DELETE FROM FEM_RULE_SETS
  WHERE RULE_SET_OBJ_DEF_ID = p_obj_def_id;

Line: 265

END DeleteRuleSetRec;

Line: 280

PROCEDURE DeleteMembersRec(
  p_obj_def_id IN NUMBER
)
--------------------------------------------------------------------------------
IS
BEGIN

  DELETE FROM FEM_RULE_SET_MEMBERS
  WHERE RULE_SET_OBJ_DEF_ID = p_obj_def_id;

Line: 290

END DeleteMembersRec;