eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_ASSET_ATTR_PVT SQL Statements

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

Line: 72


PROCEDURE INSERT_ROW(
  P_API_VERSION                  IN NUMBER,
  P_INIT_MSG_LIST                IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT                       IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL             IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                    IN OUT NOCOPY VARCHAR2,
  P_ASSOCIATION_ID                  NUMBER,
  P_APPLICATION_ID                  NUMBER,
  P_DESCRIPTIVE_FLEXFIELD_NAME      VARCHAR2,
  P_INVENTORY_ITEM_ID               NUMBER,
  P_SERIAL_NUMBER                   VARCHAR2,
  P_ORGANIZATION_ID                 NUMBER,
  P_ATTRIBUTE_CATEGORY              VARCHAR2,
  P_C_ATTRIBUTE1                    VARCHAR2,
  P_C_ATTRIBUTE2                    VARCHAR2,
  P_C_ATTRIBUTE3                    VARCHAR2,
  P_C_ATTRIBUTE4                    VARCHAR2,
  P_C_ATTRIBUTE5                    VARCHAR2,
  P_C_ATTRIBUTE6                    VARCHAR2,
  P_C_ATTRIBUTE7                    VARCHAR2,
  P_C_ATTRIBUTE8                    VARCHAR2,
  P_C_ATTRIBUTE9                    VARCHAR2,
  P_C_ATTRIBUTE10                   VARCHAR2,
  P_C_ATTRIBUTE11                   VARCHAR2,
  P_C_ATTRIBUTE12                   VARCHAR2,
  P_C_ATTRIBUTE13                   VARCHAR2,
  P_C_ATTRIBUTE14                   VARCHAR2,
  P_C_ATTRIBUTE15                   VARCHAR2,
  P_C_ATTRIBUTE16                   VARCHAR2,
  P_C_ATTRIBUTE17                   VARCHAR2,
  P_C_ATTRIBUTE18                   VARCHAR2,
  P_C_ATTRIBUTE19                   VARCHAR2,
  P_C_ATTRIBUTE20                   VARCHAR2,
  P_D_ATTRIBUTE1                    DATE,
  P_D_ATTRIBUTE2                    DATE,
  P_D_ATTRIBUTE3                    DATE,
  P_D_ATTRIBUTE4                    DATE,
  P_D_ATTRIBUTE5                    DATE,
  P_D_ATTRIBUTE6                    DATE,
  P_D_ATTRIBUTE7                    DATE,
  P_D_ATTRIBUTE8                    DATE,
  P_D_ATTRIBUTE9                    DATE,
  P_D_ATTRIBUTE10                   DATE,
  P_N_ATTRIBUTE1                    NUMBER,
  P_N_ATTRIBUTE2                    NUMBER,
  P_N_ATTRIBUTE3                    NUMBER,
  P_N_ATTRIBUTE4                    NUMBER,
  P_N_ATTRIBUTE5                    NUMBER,
  P_N_ATTRIBUTE6                    NUMBER,
  P_N_ATTRIBUTE7                    NUMBER,
  P_N_ATTRIBUTE8                    NUMBER,
  P_N_ATTRIBUTE9                    NUMBER,
  P_N_ATTRIBUTE10                   NUMBER,
  P_REQUEST_ID                      NUMBER ,
  P_PROGRAM_APPLICATION_ID          NUMBER ,
  P_PROGRAM_ID                      NUMBER ,
  P_PROGRAM_UPDATE_DATE             DATE ,
  P_MAINTENANCE_OBJECT_TYPE         NUMBER,
  P_MAINTENANCE_OBJECT_ID           NUMBER,
  P_CREATION_ORGANIZATION_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,
  X_RETURN_STATUS               OUT NOCOPY VARCHAR2,
  X_MSG_COUNT                   OUT NOCOPY NUMBER,
  X_MSG_DATA                    OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'insert_row';

Line: 147


    CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ATTR_VALUES
                 WHERE attribute_category = p_attribute_category
                   AND maintenance_object_type = P_maintenance_object_type
                   AND maintenance_object_id = P_maintenance_object_id
                   ;

Line: 174


   	select serial_number,inventory_item_id
   	into l_serial_number,l_inventory_item_id
   	from csi_item_instances
   	where instance_id = p_maintenance_object_id;

Line: 183


INSERT INTO MTL_EAM_ASSET_ATTR_VALUES(
      association_id,
      application_id,
      descriptive_flexfield_name,
      inventory_item_id,
      serial_number,
      organization_id,
      attribute_category,
      c_attribute1,
      c_attribute2,
      c_attribute3,
      c_attribute4,
      c_attribute5,
      c_attribute6,
      c_attribute7,
      c_attribute8,
      c_attribute9,
      c_attribute10,
      c_attribute11,
      c_attribute12,
      c_attribute13,
      c_attribute14,
      c_attribute15,
      c_attribute16,
      c_attribute17,
      c_attribute18,
      c_attribute19,
      c_attribute20,
      d_attribute1,
      d_attribute2,
      d_attribute3,
      d_attribute4,
      d_attribute5,
      d_attribute6,
      d_attribute7,
      d_attribute8,
      d_attribute9,
      d_attribute10,
      n_attribute1,
      n_attribute2,
      n_attribute3,
      n_attribute4,
      n_attribute5,
      n_attribute6,
      n_attribute7,
      n_attribute8,
      n_attribute9,
      n_attribute10,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      maintenance_object_id,
      maintenance_object_type,
      creation_organization_id
           ) values (
      p_association_id,
      p_application_id,
      p_descriptive_flexfield_name,
      l_inventory_item_id,
      l_serial_number,
      p_organization_id,
      p_attribute_category,
      p_c_attribute1,
      p_c_attribute2,
      p_c_attribute3,
      p_c_attribute4,
      p_c_attribute5,
      p_c_attribute6,
      p_c_attribute7,
      p_c_attribute8,
      p_c_attribute9,
      p_c_attribute10,
      p_c_attribute11,
      p_c_attribute12,
      p_c_attribute13,
      p_c_attribute14,
      p_c_attribute15,
      p_c_attribute16,
      p_c_attribute17,
      p_c_attribute18,
      p_c_attribute19,
      p_c_attribute20,
      p_d_attribute1,
      p_d_attribute2,
      p_d_attribute3,
      p_d_attribute4,
      p_d_attribute5,
      p_d_attribute6,
      p_d_attribute7,
      p_d_attribute8,
      p_d_attribute9,
      p_d_attribute10,
      p_n_attribute1,
      p_n_attribute2,
      p_n_attribute3,
      p_n_attribute4,
      p_n_attribute5,
      p_n_attribute6,
      p_n_attribute7,
      p_n_attribute8,
      p_n_attribute9,
      p_n_attribute10,
      p_last_update_date,
      p_last_updated_by,
      p_creation_date,
      p_created_by,
      p_last_update_login,
      p_request_id,
      p_program_application_id,
      p_program_id,
      p_program_update_date,
      p_maintenance_object_id,
      p_maintenance_object_type,
      p_creation_organization_id
      );

Line: 313


    eam_text_util.process_asset_update_event
    (
      p_event         => 'UPDATE'
     ,p_instance_id   => p_maintenance_object_id
     ,p_commit        => p_commit
    );

Line: 349


  END Insert_Row;

Line: 409


  P_PROGRAM_UPDATE_DATE             DATE  ,
  P_MAINTENANCE_OBJECT_TYPE         NUMBER,
  P_MAINTENANCE_OBJECT_ID           NUMBER,
  X_RETURN_STATUS               OUT NOCOPY VARCHAR2,
  X_MSG_COUNT                   OUT NOCOPY NUMBER,
  X_MSG_DATA                    OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'lock_row';

Line: 421


        SELECT *
        FROM   MTL_EAM_ASSET_ATTR_VALUES
        WHERE  rowid = P_Rowid
        FOR UPDATE of ATTRIBUTE_CATEGORY NOWAIT;

Line: 451


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

Line: 594


       AND (   (Recinfo.PROGRAM_UPDATE_DATE = P_PROGRAM_UPDATE_DATE)
            OR (    (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
                AND (P_PROGRAM_UPDATE_DATE IS NULL)))
       AND (   (Recinfo.MAINTENANCE_OBJECT_TYPE = P_MAINTENANCE_OBJECT_TYPE)
            OR (    (Recinfo.MAINTENANCE_OBJECT_TYPE IS NULL)
                AND (P_MAINTENANCE_OBJECT_TYPE IS NULL)))
       AND (   (Recinfo.MAINTENANCE_OBJECT_ID = P_MAINTENANCE_OBJECT_ID)
            OR (    (Recinfo.MAINTENANCE_OBJECT_ID IS NULL)
                AND (P_MAINTENANCE_OBJECT_ID IS NULL)))
      ) then
      return;

Line: 641


PROCEDURE UPDATE_ROW(
  P_API_VERSION                  IN NUMBER,
  P_INIT_MSG_LIST                IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT                       IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL             IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                    IN OUT NOCOPY VARCHAR2,
  P_C_ATTRIBUTE1                    VARCHAR2,
  P_C_ATTRIBUTE2                    VARCHAR2,
  P_C_ATTRIBUTE3                    VARCHAR2,
  P_C_ATTRIBUTE4                    VARCHAR2,
  P_C_ATTRIBUTE5                    VARCHAR2,
  P_C_ATTRIBUTE6                    VARCHAR2,
  P_C_ATTRIBUTE7                    VARCHAR2,
  P_C_ATTRIBUTE8                    VARCHAR2,
  P_C_ATTRIBUTE9                    VARCHAR2,
  P_C_ATTRIBUTE10                   VARCHAR2,
  P_C_ATTRIBUTE11                   VARCHAR2,
  P_C_ATTRIBUTE12                   VARCHAR2,
  P_C_ATTRIBUTE13                   VARCHAR2,
  P_C_ATTRIBUTE14                   VARCHAR2,
  P_C_ATTRIBUTE15                   VARCHAR2,
  P_C_ATTRIBUTE16                   VARCHAR2,
  P_C_ATTRIBUTE17                   VARCHAR2,
  P_C_ATTRIBUTE18                   VARCHAR2,
  P_C_ATTRIBUTE19                   VARCHAR2,
  P_C_ATTRIBUTE20                   VARCHAR2,
  P_D_ATTRIBUTE1                    DATE,
  P_D_ATTRIBUTE2                    DATE,
  P_D_ATTRIBUTE3                    DATE,
  P_D_ATTRIBUTE4                    DATE,
  P_D_ATTRIBUTE5                    DATE,
  P_D_ATTRIBUTE6                    DATE,
  P_D_ATTRIBUTE7                    DATE,
  P_D_ATTRIBUTE8                    DATE,
  P_D_ATTRIBUTE9                    DATE,
  P_D_ATTRIBUTE10                   DATE,
  P_N_ATTRIBUTE1                    NUMBER,
  P_N_ATTRIBUTE2                    NUMBER,
  P_N_ATTRIBUTE3                    NUMBER,
  P_N_ATTRIBUTE4                    NUMBER,
  P_N_ATTRIBUTE5                    NUMBER,
  P_N_ATTRIBUTE6                    NUMBER,
  P_N_ATTRIBUTE7                    NUMBER,
  P_N_ATTRIBUTE8                    NUMBER,
  P_N_ATTRIBUTE9                    NUMBER,
  P_N_ATTRIBUTE10                   NUMBER,
  P_REQUEST_ID                      NUMBER  ,
  P_PROGRAM_APPLICATION_ID          NUMBER  ,
  P_PROGRAM_ID                      NUMBER  ,
  P_PROGRAM_UPDATE_DATE             DATE  ,
  P_MAINTENANCE_OBJECT_TYPE         NUMBER,
  P_MAINTENANCE_OBJECT_ID           NUMBER,
  P_LAST_UPDATE_DATE                DATE,
  P_LAST_UPDATED_BY                 NUMBER,
  P_LAST_UPDATE_LOGIN               NUMBER,
  /* Bug 3371507 */
  P_FROM_PUBLIC_API               VARCHAR2 DEFAULT 'Y',
  X_RETURN_STATUS               OUT NOCOPY VARCHAR2,
  X_MSG_COUNT                   OUT NOCOPY NUMBER,
  X_MSG_DATA                    OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'update_row';

Line: 724


UPDATE MTL_EAM_ASSET_ATTR_VALUES
set
      c_attribute1           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE1, DECODE(p_c_attribute1,NULL,c_attribute1,FND_API.G_MISS_CHAR,NULL,p_c_attribute1)),
      c_attribute2           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE2, DECODE(p_c_attribute2,NULL,c_attribute2,FND_API.G_MISS_CHAR,NULL,p_c_attribute2)),
      c_attribute3           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE3, DECODE(p_c_attribute3,NULL,c_attribute3,FND_API.G_MISS_CHAR,NULL,p_c_attribute3)),
      c_attribute4           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE4, DECODE(p_c_attribute4,NULL,c_attribute4,FND_API.G_MISS_CHAR,NULL,p_c_attribute4)),
      c_attribute5           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE5, DECODE(p_c_attribute5,NULL,c_attribute5,FND_API.G_MISS_CHAR,NULL,p_c_attribute5)),
      c_attribute6           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE6, DECODE(p_c_attribute6,NULL,c_attribute6,FND_API.G_MISS_CHAR,NULL,p_c_attribute6)),
      c_attribute7           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE7, DECODE(p_c_attribute7,NULL,c_attribute7,FND_API.G_MISS_CHAR,NULL,p_c_attribute7)),
      c_attribute8           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE8, DECODE(p_c_attribute8,NULL,c_attribute8,FND_API.G_MISS_CHAR,NULL,p_c_attribute8)),
      c_attribute9           = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE9, DECODE(p_c_attribute9,NULL,c_attribute9,FND_API.G_MISS_CHAR,NULL,p_c_attribute9)),
      c_attribute10          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE10, DECODE(p_c_attribute10,NULL,c_attribute10,FND_API.G_MISS_CHAR,NULL,p_c_attribute10)),
      c_attribute11          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE11, DECODE(p_c_attribute11,NULL,c_attribute11,FND_API.G_MISS_CHAR,NULL,p_c_attribute11)),
      c_attribute12          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE12, DECODE(p_c_attribute12,NULL,c_attribute12,FND_API.G_MISS_CHAR,NULL,p_c_attribute12)),
      c_attribute13          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE13, DECODE(p_c_attribute13,NULL,c_attribute13,FND_API.G_MISS_CHAR,NULL,p_c_attribute13)),
      c_attribute14          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE14, DECODE(p_c_attribute14,NULL,c_attribute14,FND_API.G_MISS_CHAR,NULL,p_c_attribute14)),
      c_attribute15          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE15, DECODE(p_c_attribute15,NULL,c_attribute15,FND_API.G_MISS_CHAR,NULL,p_c_attribute15)),
      c_attribute16          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE16, DECODE(p_c_attribute16,NULL,c_attribute16,FND_API.G_MISS_CHAR,NULL,p_c_attribute16)),
      c_attribute17          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE17, DECODE(p_c_attribute17,NULL,c_attribute17,FND_API.G_MISS_CHAR,NULL,p_c_attribute17)),
      c_attribute18          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE18, DECODE(p_c_attribute18,NULL,c_attribute18,FND_API.G_MISS_CHAR,NULL,p_c_attribute18)),
      c_attribute19          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE19, DECODE(p_c_attribute19,NULL,c_attribute19,FND_API.G_MISS_CHAR,NULL,p_c_attribute19)),
      c_attribute20          = decode(P_FROM_PUBLIC_API, 'N', P_C_ATTRIBUTE20, DECODE(p_c_attribute20,NULL,c_attribute20,FND_API.G_MISS_CHAR,NULL,p_c_attribute20)),
      d_attribute1           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE1, DECODE(p_d_attribute1,NULL,d_attribute1,FND_API.G_MISS_DATE,NULL,p_d_attribute1)),
      d_attribute2           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE2, DECODE(p_d_attribute2,NULL,d_attribute2,FND_API.G_MISS_DATE,NULL,p_d_attribute2)),
      d_attribute3           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE3, DECODE(p_d_attribute3,NULL,d_attribute3,FND_API.G_MISS_DATE,NULL,p_d_attribute3)),
      d_attribute4           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE4, DECODE(p_d_attribute4,NULL,d_attribute4,FND_API.G_MISS_DATE,NULL,p_d_attribute4)),
      d_attribute5           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE5, DECODE(p_d_attribute5,NULL,d_attribute5,FND_API.G_MISS_DATE,NULL,p_d_attribute5)),
      d_attribute6           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE6, DECODE(p_d_attribute6,NULL,d_attribute6,FND_API.G_MISS_DATE,NULL,p_d_attribute6)),
      d_attribute7           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE7, DECODE(p_d_attribute7,NULL,d_attribute7,FND_API.G_MISS_DATE,NULL,p_d_attribute7)),
      d_attribute8           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE8, DECODE(p_d_attribute8,NULL,d_attribute8,FND_API.G_MISS_DATE,NULL,p_d_attribute8)),
      d_attribute9           = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE9, DECODE(p_d_attribute9,NULL,d_attribute9,FND_API.G_MISS_DATE,NULL,p_d_attribute9)),
      d_attribute10          = decode(P_FROM_PUBLIC_API, 'N', P_D_ATTRIBUTE10, DECODE(p_d_attribute10,NULL,d_attribute10,FND_API.G_MISS_DATE,NULL,p_d_attribute10)),
      n_attribute1           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE1, DECODE(p_n_attribute1,NULL,n_attribute1,FND_API.G_MISS_NUM,NULL,p_n_attribute1)),
      n_attribute2           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE2, DECODE(p_n_attribute2,NULL,n_attribute2,FND_API.G_MISS_NUM,NULL,p_n_attribute2)),
      n_attribute3           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE3, DECODE(p_n_attribute3,NULL,n_attribute3,FND_API.G_MISS_NUM,NULL,p_n_attribute3)),
      n_attribute4           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE4, DECODE(p_n_attribute4,NULL,n_attribute4,FND_API.G_MISS_NUM,NULL,p_n_attribute4)),
      n_attribute5           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE5, DECODE(p_n_attribute5,NULL,n_attribute5,FND_API.G_MISS_NUM,NULL,p_n_attribute5)),
      n_attribute6           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE6, DECODE(p_n_attribute6,NULL,n_attribute6,FND_API.G_MISS_NUM,NULL,p_n_attribute6)),
      n_attribute7           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE7, DECODE(p_n_attribute7,NULL,n_attribute7,FND_API.G_MISS_NUM,NULL,p_n_attribute7)),
      n_attribute8           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE8, DECODE(p_n_attribute8,NULL,n_attribute8,FND_API.G_MISS_NUM,NULL,p_n_attribute8)),
      n_attribute9           = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE9, DECODE(p_n_attribute9,NULL,n_attribute9,FND_API.G_MISS_NUM,NULL,p_n_attribute9)),
      n_attribute10          = decode(P_FROM_PUBLIC_API, 'N', P_N_ATTRIBUTE10, DECODE(p_n_attribute10,NULL,n_attribute10,FND_API.G_MISS_NUM,NULL,p_n_attribute10)),
      last_update_date       = p_last_update_date,
      last_updated_by        = p_last_updated_by,
      last_update_login      = p_last_update_login,
      request_id             = p_request_id,
      program_application_id = p_program_application_id,
      program_id             = p_program_id,
      program_update_date    = p_program_update_date,
      maintenance_object_type= p_maintenance_object_type,
      maintenance_object_id  = p_maintenance_object_id
    where rowid = p_rowid;

Line: 781


    eam_text_util.process_asset_update_event
    (
      p_event         => 'UPDATE'
     ,p_instance_id   => p_maintenance_object_id
     ,p_commit        => p_commit
    );

Line: 818


  END Update_Row;

Line: 824


PROCEDURE DELETE_ROW(
  P_API_VERSION                  IN NUMBER,
  P_INIT_MSG_LIST                IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT                       IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL             IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                    IN OUT NOCOPY VARCHAR2,
  X_RETURN_STATUS               OUT NOCOPY VARCHAR2,
  X_MSG_COUNT                   OUT NOCOPY NUMBER,
  X_MSG_DATA                    OUT NOCOPY VARCHAR2
  ) IS
    l_api_name       CONSTANT VARCHAR2(30) := 'delete_row';

Line: 857


       SELECT maintenance_object_id into l_object_id
         FROM mtl_eam_asset_attr_values
        WHERE rowid = p_rowid;

Line: 861


       Delete from mtl_eam_asset_attr_values
        where rowid = p_rowid;

Line: 865


       eam_text_util.process_asset_update_event
       (
         p_event         => 'UPDATE'
        ,p_instance_id   => l_object_id
        ,p_commit        => p_commit
       );

Line: 904


END Delete_Row;

Line: 956


    select instance_id into l_object_id
    from csi_item_instances
    where serial_number = p_serial_number_to
    and inventory_item_id = p_inventory_item_id;

Line: 963


  insert into mtl_eam_asset_attr_values
  (
    association_id,
    application_id,
    descriptive_flexfield_name,
    inventory_item_id,
    serial_number,
    organization_id,
    attribute_category,
    c_attribute1,
    c_attribute2,
    c_attribute3,
    c_attribute4,
    c_attribute5,
    c_attribute6,
    c_attribute7,
    c_attribute8,
    c_attribute9,
    c_attribute10,
    c_attribute11,
    c_attribute12,
    c_attribute13,
    c_attribute14,
    c_attribute15,
    c_attribute16,
    c_attribute17,
    c_attribute18,
    c_attribute19,
    c_attribute20,
    d_attribute1,
    d_attribute2,
    d_attribute3,
    d_attribute4,
    d_attribute5,
    d_attribute6,
    d_attribute7,
    d_attribute8,
    d_attribute9,
    d_attribute10,
    n_attribute1,
    n_attribute2,
    n_attribute3,
    n_attribute4,
    n_attribute5,
    n_attribute6,
    n_attribute7,
    n_attribute8,
    n_attribute9,
    n_attribute10,
    last_update_date,
    last_updated_by,
    creation_date,
    created_by,
    last_update_login,
    program_id,
    program_update_date,
    program_application_id,
    request_id,
    maintenance_object_id,
    maintenance_object_type,
    creation_organization_id
  )
  select
    association_id,
    application_id,
    descriptive_flexfield_name,
    p_inventory_item_id,
    p_serial_number_to,
    p_organization_id,
    attribute_category,
    c_attribute1,
    c_attribute2,
    c_attribute3,
    c_attribute4,
    c_attribute5,
    c_attribute6,
    c_attribute7,
    c_attribute8,
    c_attribute9,
    c_attribute10,
    c_attribute11,
    c_attribute12,
    c_attribute13,
    c_attribute14,
    c_attribute15,
    c_attribute16,
    c_attribute17,
    c_attribute18,
    c_attribute19,
    c_attribute20,
    d_attribute1,
    d_attribute2,
    d_attribute3,
    d_attribute4,
    d_attribute5,
    d_attribute6,
    d_attribute7,
    d_attribute8,
    d_attribute9,
    d_attribute10,
    n_attribute1,
    n_attribute2,
    n_attribute3,
    n_attribute4,
    n_attribute5,
    n_attribute6,
    n_attribute7,
    n_attribute8,
    n_attribute9,
    n_attribute10,
    sysdate,--last_update_date,
    last_updated_by,
    sysdate,--creation_date,
    created_by,
    last_update_login,
    program_id,
    program_update_date,
    program_application_id,
    request_id,
    l_object_id,
    maintenance_object_type,
    organization_id
  from mtl_eam_asset_attr_values
  where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
  and   inventory_item_id = p_inventory_item_id
  and   serial_number = p_serial_number_from
  and   attribute_category not in (
                                    select attribute_category
                                    from mtl_eam_asset_attr_values
                                    where descriptive_flexfield_name = 'MTL_EAM_ASSET_ATTR_VALUES'
                                    and   inventory_item_id = p_inventory_item_id
                                    and   serial_number = p_serial_number_to
                                    );

Line: 1099


    eam_text_util.process_asset_update_event
    (
      p_event         => 'UPDATE'
     ,p_instance_id   => l_object_id
     ,p_commit        => p_commit
    );