APPS.AMS_CUSTOM_SETUP_PURPOSE_PKG SQL Statements

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

Line: 28

 PROCEDURE Insert_Row(
           px_setup_purpose_id      IN OUT NOCOPY NUMBER,
           p_custom_setup_id        NUMBER,
           p_last_update_date       DATE,
           p_last_updated_by        NUMBER,
           p_creation_date          DATE,
           p_created_by             NUMBER,
           p_last_update_login      NUMBER,
           p_activity_purpose_code  VARCHAR2,
           p_enabled_flag           VARCHAR2,
           p_def_list_template_id   NUMBER,
           px_object_version_number IN OUT NOCOPY NUMBER)

  IS
    x_rowid    VARCHAR2(30);

Line: 47

    INSERT INTO ams_custom_setup_purpose(
            setup_purpose_id,
            custom_setup_id,
            last_update_date,
            last_updated_by,
            creation_date,
            created_by,
            last_update_login,
            activity_purpose_code,
            enabled_flag,
            def_list_template_id,
            object_version_number
    ) VALUES (
            DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
            DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
            DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
            DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
            DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
            DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
            DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
            DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
            DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
            DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
            DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

Line: 72

 END Insert_Row;

Line: 86

 PROCEDURE Update_Row(
           p_setup_purpose_id      NUMBER,
           p_custom_setup_id       NUMBER,
           p_last_update_date      DATE,
           p_last_updated_by       NUMBER,
           p_last_update_login     NUMBER,
           p_activity_purpose_code VARCHAR2,
           p_enabled_flag          VARCHAR2,
           p_def_list_template_id  NUMBER,
           p_object_version_number IN NUMBER)

  IS
  BEGIN
     Update ams_custom_setup_purpose
     SET
               setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
               custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
               last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
               last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
               last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
               activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
               enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
               def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),
               object_version_number = nvl(p_object_version_number,0) + 1
    WHERE setup_purpose_id = p_setup_purpose_id
    AND   object_version_number = p_object_version_number;

Line: 119

 END Update_Row;

Line: 133

 PROCEDURE Delete_Row(
     p_setup_purpose_id  NUMBER,
     p_object_version_number  NUMBER)
  IS
  BEGIN
    DELETE FROM ams_custom_setup_purpose
     WHERE setup_purpose_id = p_setup_purpose_id
     AND object_version_number = p_object_version_number;

Line: 144

  END Delete_Row ;

Line: 163

         SELECT *
         FROM ams_custom_setup_purpose
         WHERE setup_purpose_id =  p_setup_purpose_id
         AND object_version_number = p_object_version_number
         FOR UPDATE OF setup_purpose_id NOWAIT;

Line: 185

       can be found 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(
  p_setup_purpose_id        NUMBER,
  p_custom_setup_id          NUMBER,
  p_activity_purpose_code    VARCHAR2,
  p_enabled_flag             VARCHAR2,
  p_def_list_template_id     NUMBER,
  p_owner                    VARCHAR2,
  p_custom_mode              VARCHAR2,
  X_LAST_UPDATE_DATE   in DATE)

IS
l_user_id   number := 1;

Line: 218

  select last_updated_by, nvl(object_version_number,1)
  from   ams_custom_setup_purpose
  where  setup_purpose_id =  p_setup_purpose_id;

Line: 223

  select 1
  from   ams_custom_setup_purpose
  where  setup_purpose_id =  p_setup_purpose_id;

Line: 228

   select ams_custom_setup_purpose_s.nextval
   from dual;

Line: 260

    Insert_Row(px_setup_purpose_id  => l_setup_purpose_id,
           p_custom_setup_id        => p_custom_setup_id,
           p_last_update_date       => X_LAST_UPDATE_DATE,
           p_last_updated_by        => l_user_id,
           p_creation_date          => X_LAST_UPDATE_DATE,
           p_created_by             => l_user_id,
           p_last_update_login      => 0,
           p_activity_purpose_code  => p_activity_purpose_code,
           p_enabled_flag           => p_enabled_flag,
           p_def_list_template_id   => p_def_list_template_id,
           px_object_version_number => l_obj_verno);

Line: 281

      Update_Row(
           p_setup_purpose_id       => p_setup_purpose_id,
           p_custom_setup_id        => p_custom_setup_id,
           p_last_update_date       => X_LAST_UPDATE_DATE,
           p_last_updated_by        => l_user_id,
           p_last_update_login      => 0,
           p_activity_purpose_code  => p_activity_purpose_code,
           p_enabled_flag           => p_enabled_flag,
           p_def_list_template_id   => p_def_list_template_id,
           p_object_version_number  => l_obj_verno);