APPS.PFT_BR_PROFIT_AGG_PVT SQL Statements

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

Line: 25

PROCEDURE DeleteAggRuleRec(
  p_obj_def_id          IN          NUMBER
);

Line: 92

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

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

Line: 102

  DeleteAggRuleRec(
    p_obj_def_id  =>  p_obj_def_id
  );

Line: 112

END DeleteObjectDefinition;

Line: 146

  INSERT INTO PFT_PPROF_AGG_RULES (
     pprof_agg_obj_def_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
    ,col_tmplt_obj_id
    ,condition_obj_id
    ,hierarchy_obj_id
    ,dimension_grp_id_from
    ,dimension_grp_id_to
  ) SELECT
     p_target_obj_def_id
    ,NVL(p_created_by,created_by)
    ,NVL(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,SYSDATE
    ,FND_GLOBAL.login_id
    ,object_version_number
    ,col_tmplt_obj_id
    ,condition_obj_id
    ,hierarchy_obj_id
    ,dimension_grp_id_from
    ,dimension_grp_id_to
  FROM pft_pprof_agg_rules
  WHERE pprof_agg_obj_def_id = p_source_obj_def_id;

Line: 190

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

  DELETE FROM PFT_PPROF_AGG_RULES
  WHERE PPROF_AGG_OBJ_DEF_ID = p_obj_def_id;

Line: 200

END DeleteAggRuleRec;