APPS.EGO_ITEM_STATUSES_PUB SQL Statements

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

Line: 86

    SELECT COUNT (*) INTO l_count
    FROM
      EGO_ITEM_STATUS_V
    WHERE
      ITEM_STATUS_CODE = p_item_status_code;

Line: 97

    MTL_ITEM_STATUS_PKG.INSERT_ROW(
      X_ROWID        => l_rowid,
      X_INVENTORY_ITEM_STATUS_CODE => p_item_status_code,
      X_DISABLE_DATE => p_inactive_date,
      X_ATTRIBUTE_CATEGORY => p_attribute_category,
      X_ATTRIBUTE1   => p_attribute1,
      X_ATTRIBUTE2   => p_attribute2,
      X_ATTRIBUTE3   => p_attribute3,
      X_ATTRIBUTE4   => p_attribute4,
      X_ATTRIBUTE5   => p_attribute5,
      X_ATTRIBUTE6   => p_attribute6,
      X_ATTRIBUTE7   => p_attribute7,
      X_ATTRIBUTE8   => p_attribute8,
      X_ATTRIBUTE9   => p_attribute9,
      X_ATTRIBUTE10  => p_attribute10,
      X_ATTRIBUTE11  => p_attribute11,
      X_ATTRIBUTE12  => p_attribute12,
      X_ATTRIBUTE13  => p_attribute13,
      X_ATTRIBUTE14  => p_attribute14,
      X_ATTRIBUTE15  => p_attribute15,
      X_REQUEST_ID   => NULL,
      X_PROGRAM_APPLICATION_ID => NULL,
      X_PROGRAM_ID   => NULL,
      X_PROGRAM_UPDATE_DATE   => NULL,
      X_INVENTORY_ITEM_STATUS_CODE_T=> p_item_status_code_tl,
      X_DESCRIPTION  => p_description,
      X_CREATION_DATE=> l_Sysdate,
      X_CREATED_BY   => g_current_user_id,
      X_LAST_UPDATE_DATE => l_Sysdate,
      X_LAST_UPDATED_BY => g_current_user_id,
      X_LAST_UPDATE_LOGIN => g_current_user_id);

Line: 130

    INSERT INTO MTL_ITEM_STATUS
    (
        INVENTORY_ITEM_STATUS_CODE
      , INVENTORY_ITEM_STATUS_CODE_TL
      , DESCRIPTION
      , DISABLE_DATE
      , CREATED_BY
      , CREATION_DATE
      , LAST_UPDATED_BY
      , LAST_UPDATE_DATE
      , LAST_UPDATE_LOGIN
      , ATTRIBUTE1
      , ATTRIBUTE2
      , ATTRIBUTE3
      , ATTRIBUTE4
      , ATTRIBUTE5
      , ATTRIBUTE6
      , ATTRIBUTE7
      , ATTRIBUTE8
      , ATTRIBUTE9
      , ATTRIBUTE10
      , ATTRIBUTE11
      , ATTRIBUTE12
      , ATTRIBUTE13
      , ATTRIBUTE14
      , ATTRIBUTE15
      , ATTRIBUTE_CATEGORY
    )
    VALUES
    (
        p_item_status_code
      , p_item_status_code_tl
      , p_description
      , p_inactive_date
      , g_current_user_id
      , l_Sysdate
      , g_current_user_id
      , l_Sysdate
      , g_current_login_id
      , p_attribute1
      , p_attribute2
      , p_attribute3
      , p_attribute4
      , p_attribute5
      , p_attribute6
      , p_attribute7
      , p_attribute8
      , p_attribute9
      , p_attribute10
      , p_attribute11
      , p_attribute12
      , p_attribute13
      , p_attribute14
      ,p_attribute15
      ,p_attribute_category
    );

Line: 264

PROCEDURE Update_Item_Status
(
    p_api_version                 IN   NUMBER
  , p_item_status_code            IN   VARCHAR2
  , p_item_status_code_tl         IN   VARCHAR2
  , p_description                 IN   VARCHAR2
  , p_inactive_date               IN   VARCHAR2
  , p_attribute1                  IN   VARCHAR2
  , p_attribute2                  IN   VARCHAR2
  , p_attribute3                  IN   VARCHAR2
  , p_attribute4                  IN   VARCHAR2
  , p_attribute5                  IN   VARCHAR2
  , p_attribute6                  IN   VARCHAR2
  , p_attribute7                  IN   VARCHAR2
  , p_attribute8                  IN   VARCHAR2
  , p_attribute9                  IN   VARCHAR2
  , p_attribute10                  IN   VARCHAR2
  , p_attribute11                  IN   VARCHAR2
  , p_attribute12                  IN   VARCHAR2
  , p_attribute13                  IN   VARCHAR2
  , p_attribute14                  IN   VARCHAR2
  , p_attribute15                  IN   VARCHAR2
  , p_attribute_category           IN   VARCHAR2
  , p_init_msg_list               IN   VARCHAR2   := fnd_api.g_FALSE
  , p_commit                      IN   VARCHAR2   := fnd_api.g_FALSE
  , x_return_status               OUT  NOCOPY VARCHAR2
  , x_errorcode                   OUT  NOCOPY NUMBER
  , x_msg_count                   OUT  NOCOPY NUMBER
  , x_msg_data                    OUT  NOCOPY VARCHAR2
)
IS

    l_api_name		CONSTANT VARCHAR2(30)	:= 'Update_Item_Status';

Line: 310

    SAVEPOINT   Update_Item_Status_PUB;

Line: 326

    MTL_ITEM_STATUS_PKG.UPDATE_ROW(
      X_INVENTORY_ITEM_STATUS_CODE => p_item_status_code,
      X_DISABLE_DATE => p_inactive_date,
      X_ATTRIBUTE_CATEGORY => p_attribute_category,
      X_ATTRIBUTE1   => p_attribute1,
      X_ATTRIBUTE2   => p_attribute2,
      X_ATTRIBUTE3   => p_attribute3,
      X_ATTRIBUTE4   => p_attribute4,
      X_ATTRIBUTE5   => p_attribute5,
      X_ATTRIBUTE6   => p_attribute6,
      X_ATTRIBUTE7   => p_attribute7,
      X_ATTRIBUTE8   => p_attribute8,
      X_ATTRIBUTE9   => p_attribute9,
      X_ATTRIBUTE10  => p_attribute10,
      X_ATTRIBUTE11  => p_attribute11,
      X_ATTRIBUTE12  => p_attribute12,
      X_ATTRIBUTE13  => p_attribute13,
      X_ATTRIBUTE14  => p_attribute14,
      X_ATTRIBUTE15  => p_attribute15,
      X_REQUEST_ID   => NULL,
      X_PROGRAM_APPLICATION_ID => NULL,
      X_PROGRAM_ID   => NULL,
      X_PROGRAM_UPDATE_DATE   => NULL,
      X_INVENTORY_ITEM_STATUS_CODE_T=> p_item_status_code_tl,
      X_DESCRIPTION  => p_description,
      X_LAST_UPDATE_DATE => l_Sysdate,
      X_LAST_UPDATED_BY => g_current_user_id,
      X_LAST_UPDATE_LOGIN => g_current_user_id);

Line: 356

    UPDATE MTL_ITEM_STATUS
    SET
          DESCRIPTION           = p_description
        , DISABLE_DATE          = p_inactive_date
        , LAST_UPDATED_BY       = g_current_user_id
        , LAST_UPDATE_DATE      = l_Sysdate
        , LAST_UPDATE_LOGIN     = g_current_login_id
        , ATTRIBUTE1            = p_attribute1
        , ATTRIBUTE2            = p_attribute2
        , ATTRIBUTE3            = p_attribute3
        , ATTRIBUTE4            = p_attribute4
        , ATTRIBUTE5            = p_attribute5
        , ATTRIBUTE6            = p_attribute6
        , ATTRIBUTE7            = p_attribute7
        , ATTRIBUTE8            = p_attribute8
        , ATTRIBUTE9            = p_attribute9
        , ATTRIBUTE10            = p_attribute10
        , ATTRIBUTE11            = p_attribute11
        , ATTRIBUTE12            = p_attribute12
        , ATTRIBUTE13            = p_attribute13
        , ATTRIBUTE14            = p_attribute14
        , ATTRIBUTE15            = p_attribute15
        , ATTRIBUTE_CATEGORY     = p_attribute_category
    WHERE
    INVENTORY_ITEM_STATUS_CODE = p_item_status_code;

Line: 411

         ROLLBACK TO Update_Item_Status_PUB;

Line: 427

END Update_Item_Status;

Line: 478

    SELECT COUNT (*) INTO l_count
    FROM
      MTL_STATUS_ATTRIBUTE_VALUES
    WHERE
      INVENTORY_ITEM_STATUS_CODE = p_item_status_code
      AND ATTRIBUTE_NAME = p_attribute_name;

Line: 490

    INSERT INTO MTL_STATUS_ATTRIBUTE_VALUES
    (
        INVENTORY_ITEM_STATUS_CODE
      , ATTRIBUTE_NAME
      , ATTRIBUTE_VALUE
      , CREATED_BY
      , CREATION_DATE
      , LAST_UPDATED_BY
      , LAST_UPDATE_DATE
      , LAST_UPDATE_LOGIN
    )
    VALUES
    (
        p_item_status_code
      , p_attribute_name
      , p_attribute_value
      , g_current_user_id
      , l_Sysdate
      , g_current_user_id
      , l_Sysdate
      , g_current_login_id
    );

Line: 589

PROCEDURE Update_Item_Status_Attr_Values
(
    p_api_version                 IN   NUMBER
  , p_item_status_code            IN   VARCHAR2
  , p_attribute_name              IN   VARCHAR2
  , p_attribute_value             IN   VARCHAR2
  , p_init_msg_list               IN   VARCHAR2   := fnd_api.g_FALSE
  , p_commit                      IN   VARCHAR2   := fnd_api.g_FALSE
  , x_return_status               OUT  NOCOPY VARCHAR2
  , x_errorcode                   OUT  NOCOPY NUMBER
  , x_msg_count                   OUT  NOCOPY NUMBER
  , x_msg_data                    OUT  NOCOPY VARCHAR2
) IS

    l_api_name		CONSTANT VARCHAR2(30)	:= 'Update_Item_Status_Attr_Values';

Line: 617

    SAVEPOINT   Update_Item_Stat_Attr_Vals_Pub;

Line: 634

    UPDATE MTL_STATUS_ATTRIBUTE_VALUES
    SET
          ATTRIBUTE_VALUE       = p_attribute_value
        , LAST_UPDATED_BY       = g_current_user_id
        , LAST_UPDATE_DATE      = l_Sysdate
        , LAST_UPDATE_LOGIN     = g_current_login_id
    WHERE
      INVENTORY_ITEM_STATUS_CODE = p_item_status_code
      AND ATTRIBUTE_NAME = p_attribute_name;

Line: 673

         ROLLBACK TO Update_Item_Stat_Attr_Vals_Pub;

Line: 689

END Update_Item_Status_Attr_Values;