APPS.EAM_NETWORK_ASSETS_PVT SQL Statements

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

Line: 65

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_NETWORK_ASSOCIATION_ID       IN OUT NOCOPY NUMBER,
  P_ORGANIZATION_ID               NUMBER,
  P_NETWORK_OBJECT_TYPE           NUMBER,
  P_NETWORK_OBJECT_ID             NUMBER,
  P_MAINTENANCE_OBJECT_TYPE       NUMBER,
  P_MAINTENANCE_OBJECT_ID	  NUMBER,
  P_NETWORK_ITEM_ID      NUMBER,
  P_NETWORK_SERIAL_NUMBER VARCHAR2,
  P_INVENTORY_ITEM_ID    NUMBER,
  P_SERIAL_NUMBER 	     VARCHAR2,
  P_START_DATE_ACTIVE             DATE,
  P_END_DATE_ACTIVE               DATE,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_CREATION_DATE                 DATE,
  P_CREATED_BY                    NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  P_ATTRIBUTE_CATEGORY            VARCHAR2,
  P_ATTRIBUTE1                    VARCHAR2,
  P_ATTRIBUTE2                    VARCHAR2,
  P_ATTRIBUTE3                    VARCHAR2,
  P_ATTRIBUTE4                    VARCHAR2,
  P_ATTRIBUTE5                    VARCHAR2,
  P_ATTRIBUTE6                    VARCHAR2,
  P_ATTRIBUTE7                    VARCHAR2,
  P_ATTRIBUTE8                    VARCHAR2,
  P_ATTRIBUTE9                    VARCHAR2,
  P_ATTRIBUTE10                   VARCHAR2,
  P_ATTRIBUTE11                   VARCHAR2,
  P_ATTRIBUTE12                   VARCHAR2,
  P_ATTRIBUTE13                   VARCHAR2,
  P_ATTRIBUTE14                   VARCHAR2,
  P_ATTRIBUTE15                   VARCHAR2,
  P_REQUEST_ID                    NUMBER,
  P_PROGRAM_APPLICATION_ID        NUMBER,
  P_PROGRAM_ID                    NUMBER,
  P_PROGRAM_UPDATE_DATE           DATE,
  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: 116

    CURSOR C IS SELECT rowid FROM MTL_EAM_NETWORK_ASSETS
                 WHERE NETWORK_ASSOCIATION_ID = P_NETWORK_ASSOCIATION_ID;

Line: 122

      SAVEPOINT insert_row;

Line: 139

       INSERT INTO MTL_EAM_NETWORK_ASSETS(
       NETWORK_ASSOCIATION_ID,
       ORGANIZATION_ID,
       NETWORK_OBJECT_TYPE,
       NETWORK_OBJECT_ID,
       MAINTENANCE_OBJECT_TYPE,
       MAINTENANCE_OBJECT_ID,
       NETWORK_ITEM_ID,
       NETWORK_SERIAL_NUMBER,
       INVENTORY_ITEM_ID,
       SERIAL_NUMBER,
       START_DATE_ACTIVE,
       END_DATE_ACTIVE,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_LOGIN,
       ATTRIBUTE_CATEGORY,
       ATTRIBUTE1,
       ATTRIBUTE2,
       ATTRIBUTE3,
       ATTRIBUTE4,
       ATTRIBUTE5,
       ATTRIBUTE6,
       ATTRIBUTE7,
       ATTRIBUTE8,
       ATTRIBUTE9,
       ATTRIBUTE10,
       ATTRIBUTE11,
       ATTRIBUTE12,
       ATTRIBUTE13,
       ATTRIBUTE14,
       ATTRIBUTE15,
       REQUEST_ID,
       PROGRAM_APPLICATION_ID,
       PROGRAM_ID,
       PROGRAM_UPDATE_DATE
       ) VALUES (
       mtl_eam_network_assets_s.nextval,
       P_ORGANIZATION_ID ,
       P_NETWORK_OBJECT_TYPE ,
       P_NETWORK_OBJECT_ID,
       P_MAINTENANCE_OBJECT_TYPE,
       P_MAINTENANCE_OBJECT_ID,
       P_NETWORK_ITEM_ID,
       P_NETWORK_SERIAL_NUMBER,
       P_INVENTORY_ITEM_ID,
       P_SERIAL_NUMBER,
       P_START_DATE_ACTIVE,
       P_END_DATE_ACTIVE,
       P_LAST_UPDATE_DATE,
       P_LAST_UPDATED_BY,
       P_CREATION_DATE,
       P_CREATED_BY,
       P_LAST_UPDATE_LOGIN,
       P_ATTRIBUTE_CATEGORY,
       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_REQUEST_ID,
       P_PROGRAM_APPLICATION_ID,
       P_PROGRAM_ID,
       P_PROGRAM_UPDATE_DATE
       ) returning network_association_id, rowid into P_NETWORK_ASSOCIATION_ID, P_ROWID;

Line: 235

         ROLLBACK TO insert_row;

Line: 239

         ROLLBACK TO insert_row;

Line: 245

         ROLLBACK TO insert_row;

Line: 254

  END Insert_Row;

Line: 293

    P_PROGRAM_UPDATE_DATE           DATE,
    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: 303

        SELECT *
        FROM   MTL_EAM_NETWORK_ASSETS
        WHERE  rowid = P_Rowid
        FOR UPDATE of NETWORK_ASSOCIATION_ID NOWAIT;

Line: 333

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

Line: 413

       AND (   (Recinfo.PROGRAM_UPDATE_DATE = P_PROGRAM_UPDATE_DATE)
            OR (    (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
                AND (P_PROGRAM_UPDATE_DATE IS NULL)))
      ) then
      return;

Line: 454

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                         VARCHAR2,
  P_NETWORK_ASSOCIATION_ID       NUMBER,
  P_ORGANIZATION_ID               NUMBER,
  P_NETWORK_OBJECT_TYPE           NUMBER,
  P_NETWORK_OBJECT_ID             NUMBER,
  P_MAINTENANCE_OBJECT_TYPE       NUMBER,
  P_MAINTENANCE_OBJECT_ID	  NUMBER,
  P_NETWORK_ITEM_ID      NUMBER,
  P_NETWORK_SERIAL_NUMBER VARCHAR2,
  P_INVENTORY_ITEM_ID    NUMBER,
  P_SERIAL_NUMBER 	     VARCHAR2,
  P_START_DATE_ACTIVE             DATE,
  P_END_DATE_ACTIVE               DATE,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  P_ATTRIBUTE_CATEGORY            VARCHAR2,
  P_ATTRIBUTE1                    VARCHAR2,
  P_ATTRIBUTE2                    VARCHAR2,
  P_ATTRIBUTE3                    VARCHAR2,
  P_ATTRIBUTE4                    VARCHAR2,
  P_ATTRIBUTE5                    VARCHAR2,
  P_ATTRIBUTE6                    VARCHAR2,
  P_ATTRIBUTE7                    VARCHAR2,
  P_ATTRIBUTE8                    VARCHAR2,
  P_ATTRIBUTE9                    VARCHAR2,
  P_ATTRIBUTE10                   VARCHAR2,
  P_ATTRIBUTE11                   VARCHAR2,
  P_ATTRIBUTE12                   VARCHAR2,
  P_ATTRIBUTE13                   VARCHAR2,
  P_ATTRIBUTE14                   VARCHAR2,
  P_ATTRIBUTE15                   VARCHAR2,
  P_REQUEST_ID                    NUMBER,
  P_PROGRAM_APPLICATION_ID        NUMBER,
  P_PROGRAM_ID                    NUMBER,
  P_PROGRAM_UPDATE_DATE           DATE,
  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: 504

      SAVEPOINT update_row;

Line: 521

    UPDATE MTL_EAM_NETWORK_ASSETS
    SET
     ORGANIZATION_ID                 =     P_ORGANIZATION_ID,
     MAINTENANCE_OBJECT_TYPE	     =     P_MAINTENANCE_OBJECT_TYPE,
     MAINTENANCE_OBJECT_ID	         =     P_MAINTENANCE_OBJECT_ID,
     INVENTORY_ITEM_ID               =     P_INVENTORY_ITEM_ID,
     SERIAL_NUMBER                   =     P_SERIAL_NUMBER,
     START_DATE_ACTIVE               =     P_START_DATE_ACTIVE,
     END_DATE_ACTIVE                 =     P_END_DATE_ACTIVE,
     LAST_UPDATE_DATE                =     P_LAST_UPDATE_DATE,
     LAST_UPDATED_BY                 =     P_LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN               =     P_LAST_UPDATE_LOGIN,
     ATTRIBUTE_CATEGORY              =     P_ATTRIBUTE_CATEGORY,
     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,
     REQUEST_ID                      =     P_REQUEST_ID,
     PROGRAM_APPLICATION_ID          =     P_PROGRAM_APPLICATION_ID,
     PROGRAM_ID                      =     P_PROGRAM_ID,
     PROGRAM_UPDATE_DATE             =     P_PROGRAM_UPDATE_DATE
    WHERE ROWID = P_ROWID;

Line: 569

         ROLLBACK TO update_row;

Line: 573

         ROLLBACK TO update_row;

Line: 579

         ROLLBACK TO update_row;

Line: 588

  END Update_Row;