APPS.MTL_STATUS_ATTRIB_VAL_PKG SQL Statements

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

Line: 12

        SELECT *
        FROM   MTL_STATUS_ATTRIBUTE_VALUES
        WHERE  rowid = X_Rowid
        FOR UPDATE of Inventory_Item_Status_Code NOWAIT;

Line: 24

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 39

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Inventory_Item_Status_Code     VARCHAR2,
                       X_Status_Code_Ndb                NUMBER,
                       X_Attribute_Name                 VARCHAR2,
                       X_Attribute_Value                VARCHAR2,
                       X_Old_Attribute_Value            VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER

  ) IS
  BEGIN

    IF ((X_Attribute_Value <> X_Old_Attribute_Value) AND
        (X_STATUS_CODE_NDB = 1))  THEN
        INVUPDAT.UPDATE_ATTRIBUTES( X_Attribute_Name,
                                    X_Attribute_Value,
                                    X_Inventory_Item_Status_Code);

Line: 59

    UPDATE MTL_STATUS_ATTRIBUTE_VALUES
    SET
       inventory_item_status_code      =     X_Inventory_Item_Status_Code,
       attribute_name                  =     X_Attribute_Name,
       attribute_value                 =     X_Attribute_Value,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By,
       last_update_login               =     X_Last_Update_Login
    WHERE rowid = X_Rowid;

Line: 72

  END Update_Row;

Line: 75

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM MTL_STATUS_ATTRIBUTE_VALUES
    WHERE rowid = X_Rowid;

Line: 83

  END Delete_Row;

Line: 98

   insert into mtl_status_attribute_values
  ( inventory_item_status_code,
    attribute_name,
    attribute_value,
    last_update_date,
    last_updated_by,
    creation_date,
    created_by,
    last_update_login)
  select status_code,
        attr.attribute_name,
        'N',
        sysdate,
        userid,
        sysdate,
        userid,
        logid
 from   mtl_item_attributes attr
 where  attr.STATUS_CONTROL_CODE is not NULL;