APPS.AMS_CUSTOM_SETUP_ATTR_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_SETUP_ATTRIBUTE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CUSTOM_SETUP_ID in NUMBER,
  X_DISPLAY_SEQUENCE_NO in NUMBER,
  X_OBJECT_ATTRIBUTE in VARCHAR2,
  X_ATTR_MANDATORY_FLAG in VARCHAR2,
  X_ATTR_AVAILABLE_FLAG in VARCHAR2,
  X_PARENT_FUNCTION_NAME in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
  X_PARENT_DISPLAY_SEQUENCE in NUMBER,
  X_SHOW_IN_REPORT in VARCHAR2,
  X_SHOW_IN_CUE_CARD in VARCHAR2,
  X_COPY_ALLOWED_FLAG in VARCHAR2,
  X_RELATED_AK_ATTRIBUTE in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ESSENTIAL_SEQ_NUM in NUMBER
)
IS
  CURSOR c IS select ROWID FROM AMS_CUSTOM_SETUP_ATTR
    WHERE SETUP_ATTRIBUTE_ID = X_SETUP_ATTRIBUTE_ID
    ;

Line: 32

  INSERT into AMS_CUSTOM_SETUP_ATTR (
    SETUP_ATTRIBUTE_ID,
    OBJECT_VERSION_NUMBER,
    CUSTOM_SETUP_ID,
    DISPLAY_SEQUENCE_NO,
    OBJECT_ATTRIBUTE,
    ATTR_MANDATORY_FLAG,
    ATTR_AVAILABLE_FLAG,
    PARENT_FUNCTION_NAME,
    FUNCTION_NAME,
    PARENT_SETUP_ATTRIBUTE,
    PARENT_DISPLAY_SEQUENCE,
    SHOW_IN_REPORT,
    SHOW_IN_CUE_CARD,
    COPY_ALLOWED_FLAG,
    RELATED_AK_ATTRIBUTE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ESSENTIAL_SEQ_NUM
  ) values (
    X_SETUP_ATTRIBUTE_ID,
    X_OBJECT_VERSION_NUMBER,
    X_CUSTOM_SETUP_ID,
    X_DISPLAY_SEQUENCE_NO,
    X_OBJECT_ATTRIBUTE,
    X_ATTR_MANDATORY_FLAG,
    X_ATTR_AVAILABLE_FLAG,
    X_PARENT_FUNCTION_NAME ,
    X_FUNCTION_NAME,
    X_PARENT_SETUP_ATTRIBUTE,
    X_PARENT_DISPLAY_SEQUENCE,
    X_SHOW_IN_REPORT ,
    X_SHOW_IN_CUE_CARD ,
    X_COPY_ALLOWED_FLAG,
    X_RELATED_AK_ATTRIBUTE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ESSENTIAL_SEQ_NUM
  );

Line: 85

END INSERT_ROW;

Line: 87

PROCEDURE UPDATE_ROW (
  X_SETUP_ATTRIBUTE_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CUSTOM_SETUP_ID in NUMBER,
  X_DISPLAY_SEQUENCE_NO in NUMBER,
  X_OBJECT_ATTRIBUTE in VARCHAR2,
  X_ATTR_MANDATORY_FLAG in VARCHAR2,
  X_ATTR_AVAILABLE_FLAG in VARCHAR2,
  X_PARENT_FUNCTION_NAME in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
  X_PARENT_DISPLAY_SEQUENCE in NUMBER,
  X_SHOW_IN_REPORT in VARCHAR2,
  X_SHOW_IN_CUE_CARD in VARCHAR2,
  X_COPY_ALLOWED_FLAG in VARCHAR2,
  X_RELATED_AK_ATTRIBUTE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ESSENTIAL_SEQ_NUM in NUMBER
)
IS
BEGIN
  UPDATE AMS_CUSTOM_SETUP_ATTR SET
    OBJECT_VERSION_NUMBER   = X_OBJECT_VERSION_NUMBER,
    DISPLAY_SEQUENCE_NO     = X_DISPLAY_SEQUENCE_NO,
    ATTR_MANDATORY_FLAG     = X_ATTR_MANDATORY_FLAG,
    ATTR_AVAILABLE_FLAG     = X_ATTR_AVAILABLE_FLAG,
    PARENT_FUNCTION_NAME    = X_PARENT_FUNCTION_NAME,
    FUNCTION_NAME           = X_FUNCTION_NAME,
    PARENT_SETUP_ATTRIBUTE  = X_PARENT_SETUP_ATTRIBUTE,
    PARENT_DISPLAY_SEQUENCE = X_PARENT_DISPLAY_SEQUENCE,
    SHOW_IN_REPORT          = X_SHOW_IN_REPORT,
    SHOW_IN_CUE_CARD        = X_SHOW_IN_CUE_CARD,
    COPY_ALLOWED_FLAG       = X_COPY_ALLOWED_FLAG,
    RELATED_AK_ATTRIBUTE    = X_RELATED_AK_ATTRIBUTE,
    LAST_UPDATE_DATE        = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY         = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN       = X_LAST_UPDATE_LOGIN,
    ESSENTIAL_SEQ_NUM       = X_ESSENTIAL_SEQ_NUM
  WHERE OBJECT_ATTRIBUTE  = X_OBJECT_ATTRIBUTE
   AND CUSTOM_SETUP_ID   = X_CUSTOM_SETUP_ID;

Line: 133

END UPDATE_ROW;

Line: 135

PROCEDURE DELETE_ROW (
  X_SETUP_ATTRIBUTE_ID in NUMBER
)
IS
BEGIN
  DELETE FROM AMS_CUSTOM_SETUP_ATTR
  WHERE SETUP_ATTRIBUTE_ID = X_SETUP_ATTRIBUTE_ID;

Line: 146

END DELETE_ROW;

Line: 152

      by comparing last updated by value to be
          SEED/DATAMERGE(1), or
          INITIAL SETUP/ORACLE (2), or
          SYSTEM ADMINISTRATOR (0).or
    2) modify the whole data when custom_mode is 'FORCE'
    3) if the data in db is modified by customer, which can be found by
      by comparing last updated by value to be not of 0,1,2, then
        in that case modify only the user unexposed data with last updated by as 3 to
        distinguish that data is updated by patch.
*/

PROCEDURE  LOAD_ROW(
  X_SETUP_ATTRIBUTE_ID in NUMBER,
  X_CUSTOM_SETUP_ID in NUMBER,
  X_DISPLAY_SEQUENCE_NO in NUMBER,
  X_OBJECT_ATTRIBUTE in VARCHAR2,
  X_ATTR_MANDATORY_FLAG in VARCHAR2,
  X_ATTR_AVAILABLE_FLAG in VARCHAR2,
  X_PARENT_FUNCTION_NAME in VARCHAR2,
  X_FUNCTION_NAME in VARCHAR2,
  X_PARENT_SETUP_ATTRIBUTE in VARCHAR2,
  X_PARENT_DISPLAY_SEQUENCE in NUMBER,
  X_SHOW_IN_REPORT in VARCHAR2,
  X_SHOW_IN_CUE_CARD in VARCHAR2,
  X_COPY_ALLOWED_FLAG in VARCHAR2,
  X_RELATED_AK_ATTRIBUTE in VARCHAR2,
  X_ESSENTIAL_SEQ_NUM in NUMBER,
  X_OWNER in VARCHAR2,
  x_custom_mode  IN VARCHAR2,
  X_LAST_UPDATE_DATE   in DATE
)
IS

l_user_id   number := 1;

Line: 197

  select last_updated_by, nvl(object_version_number,1)
   FROM  AMS_CUSTOM_SETUP_ATTR
  WHERE  OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
    AND  CUSTOM_SETUP_ID  = X_CUSTOM_SETUP_ID;

Line: 203

  select 1
  FROM   AMS_CUSTOM_SETUP_ATTR
  WHERE  OBJECT_ATTRIBUTE = X_OBJECT_ATTRIBUTE
    AND  CUSTOM_SETUP_ID  = X_CUSTOM_SETUP_ID;

Line: 209

   select AMS_CUSTOM_SETUP_ATTR_S.NEXTVAL
   FROM DUAL;

Line: 213

   SELECT COUNT(*)
   FROM AMS_CUSTOM_SETUP_ATTR
   WHERE setup_attribute_id = attr_id;

Line: 248

    AMS_CUSTOM_SETUP_ATTR_PKG.INSERT_ROW    (
      X_ROWID               => l_row_id,
      X_SETUP_ATTRIBUTE_ID      => l_attr_id,
      X_OBJECT_VERSION_NUMBER   => l_obj_verno,
      X_CUSTOM_SETUP_ID         => X_CUSTOM_SETUP_ID,
      X_DISPLAY_SEQUENCE_NO     => X_DISPLAY_SEQUENCE_NO,
      X_OBJECT_ATTRIBUTE        => X_OBJECT_ATTRIBUTE,
      X_ATTR_MANDATORY_FLAG     => X_ATTR_MANDATORY_FLAG,
      X_ATTR_AVAILABLE_FLAG     => X_ATTR_AVAILABLE_FLAG,
      X_PARENT_FUNCTION_NAME    => X_PARENT_FUNCTION_NAME,
      X_FUNCTION_NAME           => X_FUNCTION_NAME,
      X_PARENT_SETUP_ATTRIBUTE  => X_PARENT_SETUP_ATTRIBUTE,
      X_PARENT_DISPLAY_SEQUENCE => X_PARENT_DISPLAY_SEQUENCE,
      X_SHOW_IN_REPORT          => X_SHOW_IN_REPORT,
      X_SHOW_IN_CUE_CARD        => X_SHOW_IN_CUE_CARD,
      X_COPY_ALLOWED_FLAG       => X_COPY_ALLOWED_FLAG,
      X_RELATED_AK_ATTRIBUTE    => X_RELATED_AK_ATTRIBUTE,
      X_CREATION_DATE           => X_LAST_UPDATE_DATE,
      X_CREATED_BY              => l_user_id,
      X_LAST_UPDATE_DATE        => X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY         => l_user_id,
      X_LAST_UPDATE_LOGIN       => 0,
      X_ESSENTIAL_SEQ_NUM       => X_ESSENTIAL_SEQ_NUM
      );

Line: 280

      AMS_CUSTOM_SETUP_ATTR_PKG.UPDATE_ROW (
        X_SETUP_ATTRIBUTE_ID      =>  X_SETUP_ATTRIBUTE_ID,
        X_OBJECT_VERSION_NUMBER   => l_obj_verno + 1,
        X_CUSTOM_SETUP_ID         => X_CUSTOM_SETUP_ID,
        X_DISPLAY_SEQUENCE_NO     => X_DISPLAY_SEQUENCE_NO,
        X_OBJECT_ATTRIBUTE        => X_OBJECT_ATTRIBUTE,
        X_ATTR_MANDATORY_FLAG     => X_ATTR_MANDATORY_FLAG,
        X_ATTR_AVAILABLE_FLAG     => X_ATTR_AVAILABLE_FLAG,
        X_PARENT_FUNCTION_NAME    => X_PARENT_FUNCTION_NAME,
        X_FUNCTION_NAME           => X_FUNCTION_NAME,
        X_PARENT_SETUP_ATTRIBUTE  => X_PARENT_SETUP_ATTRIBUTE,
        X_PARENT_DISPLAY_SEQUENCE => X_PARENT_DISPLAY_SEQUENCE,
        X_SHOW_IN_REPORT          => X_SHOW_IN_REPORT,
        X_SHOW_IN_CUE_CARD        => X_SHOW_IN_CUE_CARD,
        X_COPY_ALLOWED_FLAG       => X_COPY_ALLOWED_FLAG,
        X_RELATED_AK_ATTRIBUTE    => X_RELATED_AK_ATTRIBUTE,
        X_LAST_UPDATE_DATE        => X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY         => l_user_id,
        X_LAST_UPDATE_LOGIN       => 0,
	X_ESSENTIAL_SEQ_NUM       => X_ESSENTIAL_SEQ_NUM
      );

Line: 302

      UPDATE AMS_CUSTOM_SETUP_ATTR SET
        OBJECT_VERSION_NUMBER = l_obj_verno + 1,
        OBJECT_ATTRIBUTE        = X_OBJECT_ATTRIBUTE,
        PARENT_FUNCTION_NAME    = X_PARENT_FUNCTION_NAME,
        FUNCTION_NAME           = X_FUNCTION_NAME,
        PARENT_SETUP_ATTRIBUTE  = X_PARENT_SETUP_ATTRIBUTE,
        PARENT_DISPLAY_SEQUENCE = X_PARENT_DISPLAY_SEQUENCE,
        SHOW_IN_CUE_CARD        = X_SHOW_IN_CUE_CARD,
        COPY_ALLOWED_FLAG       = X_COPY_ALLOWED_FLAG,
        RELATED_AK_ATTRIBUTE    = X_RELATED_AK_ATTRIBUTE,
        LAST_UPDATE_DATE        = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY         = l_excp_user_id,
        LAST_UPDATE_LOGIN       = 0,
	ESSENTIAL_SEQ_NUM       = X_ESSENTIAL_SEQ_NUM
      WHERE OBJECT_ATTRIBUTE  = X_OBJECT_ATTRIBUTE
        AND CUSTOM_SETUP_ID   = X_CUSTOM_SETUP_ID;