APPS.FEM_COL_POP_TMPL_PVT SQL Statements

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

Line: 25

PROCEDURE DeleteColPopTmpltRec(
  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

  DeleteColPopTmpltRec(
    p_obj_def_id          => p_obj_def_id
  );

Line: 112

END DeleteObjectDefinition;

Line: 147

  l_last_updated_by 	 NUMBER;

Line: 148

  l_last_update_login 	 NUMBER;

Line: 153

  l_last_updated_by   := FND_GLOBAL.USER_ID;

Line: 154

  l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 156

  INSERT INTO FEM_COL_POPULATION_TMPLT_VL(
   COL_POP_TEMPLT_OBJ_DEF_ID
  ,TARGET_TABLE_NAME
  ,TARGET_COLUMN_NAME
  ,DATA_POPULATION_METHOD_CODE
  ,SOURCE_TABLE_NAME
  ,SOURCE_COLUMN_NAME
  ,DIMENSION_ID
  ,ATTRIBUTE_ID
  ,ATTRIBUTE_VERSION_ID
  ,AGGREGATION_METHOD
  ,CONSTANT_NUMERIC_VALUE
  ,CONSTANT_ALPHANUMERIC_VALUE
  ,CONSTANT_DATE_VALUE
  ,CREATED_BY
  ,CREATION_DATE
  ,LAST_UPDATED_BY
  ,LAST_UPDATE_DATE
  ,LAST_UPDATE_LOGIN
  ,OBJECT_VERSION_NUMBER
  ,SYSTEM_RESERVED_FLAG
  ,ENG_PROC_PARAM
  ,PARAMETER_FLAG
  ,DESCRIPTION
 ) SELECT
   p_target_obj_def_id
  ,TARGET_TABLE_NAME
  ,TARGET_COLUMN_NAME
  ,DATA_POPULATION_METHOD_CODE
  ,SOURCE_TABLE_NAME
  ,SOURCE_COLUMN_NAME
  ,DIMENSION_ID
  ,ATTRIBUTE_ID
  ,ATTRIBUTE_VERSION_ID
  ,AGGREGATION_METHOD
  ,CONSTANT_NUMERIC_VALUE
  ,CONSTANT_ALPHANUMERIC_VALUE
  ,CONSTANT_DATE_VALUE
  ,NVL(p_created_by,created_by)
  ,NVL(p_creation_date,creation_date)
  ,FND_GLOBAL.user_id
  ,SYSDATE
  ,FND_GLOBAL.login_id
  ,OBJECT_VERSION_NUMBER
  ,SYSTEM_RESERVED_FLAG
  ,ENG_PROC_PARAM
  ,PARAMETER_FLAG
  ,DESCRIPTION
FROM FEM_COL_POPULATION_TMPLT_VL
WHERE COL_POP_TEMPLT_OBJ_DEF_ID = p_source_obj_def_id;

Line: 222

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


  DELETE FROM FEM_COL_POPULATION_TMPLT_VL
  WHERE COL_POP_TEMPLT_OBJ_DEF_ID = p_obj_def_id;

Line: 233

END DeleteColPopTmpltRec;