APPS.AHL_UF_HEADERS_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
        X_UF_HEADER_ID            IN OUT NOCOPY NUMBER,
        X_OBJECT_VERSION_NUMBER   IN     NUMBER,
        X_CREATED_BY              IN     NUMBER,
        X_CREATION_DATE           IN     DATE,
        X_LAST_UPDATED_BY         IN     NUMBER,
        X_LAST_UPDATE_DATE        IN     DATE,
        X_LAST_UPDATE_LOGIN       IN     NUMBER,
        X_UNIT_CONFIG_HEADER_ID   IN     NUMBER,
        X_PC_NODE_ID              IN     NUMBER,
        X_INVENTORY_ITEM_ID		  IN     NUMBER,
        X_INVENTORY_ORG_ID        IN     NUMBER,
        X_CSI_ITEM_INSTANCE_ID    IN     NUMBER,
        X_USE_UNIT_FLAG           IN     VARCHAR2,
        X_ATTRIBUTE_CATEGORY      IN     VARCHAR2,
        X_ATTRIBUTE1              IN     VARCHAR2,
        X_ATTRIBUTE2              IN     VARCHAR2,
        X_ATTRIBUTE3              IN     VARCHAR2,
        X_ATTRIBUTE4              IN     VARCHAR2,
        X_ATTRIBUTE5              IN     VARCHAR2,
        X_ATTRIBUTE6              IN     VARCHAR2,
        X_ATTRIBUTE7              IN     VARCHAR2,
        X_ATTRIBUTE8              IN     VARCHAR2,
        X_ATTRIBUTE9              IN     VARCHAR2,
        X_ATTRIBUTE10             IN     VARCHAR2,
        X_ATTRIBUTE11             IN     VARCHAR2,
        X_ATTRIBUTE12             IN     VARCHAR2,
        X_ATTRIBUTE13             IN     VARCHAR2,
        X_ATTRIBUTE14             IN     VARCHAR2,
        X_ATTRIBUTE15             IN     VARCHAR2
) IS


BEGIN
  insert into AHL_UF_HEADERS (
    UF_HEADER_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    UNIT_CONFIG_HEADER_ID,
    PC_NODE_ID,
    INVENTORY_ITEM_ID,
    INVENTORY_ORG_ID,
    CSI_ITEM_INSTANCE_ID,
    USE_UNIT_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15
   )  values (
        AHL_UF_HEADERS_S.NEXTVAL,
        X_OBJECT_VERSION_NUMBER,
        X_CREATED_BY,
        X_CREATION_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN,
        X_UNIT_CONFIG_HEADER_ID,
        X_PC_NODE_ID,
        X_INVENTORY_ITEM_ID,
        X_INVENTORY_ORG_ID,
        X_CSI_ITEM_INSTANCE_ID,
        X_USE_UNIT_FLAG,
        X_ATTRIBUTE_CATEGORY,
        X_ATTRIBUTE1,
        X_ATTRIBUTE2,
        X_ATTRIBUTE3,
        X_ATTRIBUTE4,
        X_ATTRIBUTE5,
        X_ATTRIBUTE6,
        X_ATTRIBUTE7,
        X_ATTRIBUTE8,
        X_ATTRIBUTE9,
        X_ATTRIBUTE10,
        X_ATTRIBUTE11,
        X_ATTRIBUTE12,
        X_ATTRIBUTE13,
        X_ATTRIBUTE14,
        X_ATTRIBUTE15

) RETURNING UF_HEADER_ID INTO X_UF_HEADER_ID;

Line: 101

END INSERT_ROW;

Line: 104

PROCEDURE UPDATE_ROW (

        X_UF_HEADER_ID            IN     NUMBER,
        X_OBJECT_VERSION_NUMBER   IN     NUMBER,
        X_LAST_UPDATED_BY         IN     NUMBER,
        X_LAST_UPDATE_DATE        IN     DATE,
        X_LAST_UPDATE_LOGIN       IN     NUMBER,
        X_UNIT_CONFIG_HEADER_ID   IN     NUMBER,
        X_PC_NODE_ID              IN     NUMBER,
        X_INVENTORY_ITEM_ID		  IN     NUMBER,
        X_INVENTORY_ORG_ID        IN     NUMBER,
        X_CSI_ITEM_INSTANCE_ID    IN     NUMBER,
        X_USE_UNIT_FLAG           IN     VARCHAR2,
        X_ATTRIBUTE_CATEGORY      IN     VARCHAR2,
        X_ATTRIBUTE1              IN     VARCHAR2,
        X_ATTRIBUTE2              IN     VARCHAR2,
        X_ATTRIBUTE3              IN     VARCHAR2,
        X_ATTRIBUTE4              IN     VARCHAR2,
        X_ATTRIBUTE5              IN     VARCHAR2,
        X_ATTRIBUTE6              IN     VARCHAR2,
        X_ATTRIBUTE7              IN     VARCHAR2,
        X_ATTRIBUTE8              IN     VARCHAR2,
        X_ATTRIBUTE9              IN     VARCHAR2,
        X_ATTRIBUTE10             IN     VARCHAR2,
        X_ATTRIBUTE11             IN     VARCHAR2,
        X_ATTRIBUTE12             IN     VARCHAR2,
        X_ATTRIBUTE13             IN     VARCHAR2,
        X_ATTRIBUTE14             IN     VARCHAR2,
        X_ATTRIBUTE15             IN     VARCHAR2
) IS


BEGIN
  update AHL_UF_HEADERS set
    UF_HEADER_ID = X_UF_HEADER_ID,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    UNIT_CONFIG_HEADER_ID = X_UNIT_CONFIG_HEADER_ID,
    PC_NODE_ID = X_PC_NODE_ID,
    INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
    INVENTORY_ORG_ID = X_INVENTORY_ORG_ID,
    CSI_ITEM_INSTANCE_ID = X_CSI_ITEM_INSTANCE_ID,
    USE_UNIT_FLAG = X_USE_UNIT_FLAG,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15
  where UF_HEADER_ID = X_UF_HEADER_ID
  and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER - 1;

Line: 172

END UPDATE_ROW;

Line: 174

PROCEDURE DELETE_ROW (
  X_UF_HEADER_ID in NUMBER
) is

BEGIN

  delete from AHL_UF_HEADERS
  where UF_HEADER_ID = X_UF_HEADER_ID;

Line: 187

END DELETE_ROW;