APPS.AHL_SCHEDULE_MATERIALS_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
 X_SCHEDULED_MATERIAL_ID  IN  NUMBER,
 X_OBJECT_VERSION_NUMBER  IN NUMBER,
 X_LAST_UPDATE_DATE       IN DATE,
 X_LAST_UPDATED_BY        IN NUMBER,
 X_CREATION_DATE          IN DATE,
 X_CREATED_BY             IN NUMBER,
 X_LAST_UPDATE_LOGIN      IN NUMBER,
 X_INVENTORY_ITEM_ID      IN NUMBER,
 X_SCHEDULE_DESIGNATOR    IN VARCHAR2,
 X_VISIT_ID               IN NUMBER,
 X_VISIT_START_DATE       IN DATE,
 X_VISIT_TASK_ID          IN NUMBER,
 X_ORGANIZATION_ID        IN NUMBER,
 X_SCHEDULED_DATE         IN DATE,
 X_REQUEST_ID             IN NUMBER,
 X_REQUESTED_DATE         IN DATE,
 X_SCHEDULED_QUANTITY     IN NUMBER,
 X_PROCESS_STATUS         IN NUMBER,
 X_ERROR_MESSAGE          IN VARCHAR2,
 X_TRANSACTION_ID         IN NUMBER,
 X_UOM                    IN VARCHAR2,
 X_RT_OPER_MATERIAL_ID    IN NUMBER,
 X_OPERATION_CODE         IN VARCHAR2,
 X_OPERATION_SEQUENCE     IN NUMBER,
 X_ITEM_GROUP_ID          IN NUMBER,
 X_REQUESTED_QUANTITY     IN NUMBER,
 X_PROGRAM_ID             IN NUMBER,
 X_PROGRAM_UPDATE_DATE    IN DATE,
 X_LAST_UPDATED_DATE      IN DATE,
 X_WORKORDER_OPERATION_ID IN NUMBER,
 X_POSITION_PATH_ID       IN NUMBER,
 X_RELATIONSHIP_ID        IN NUMBER,
 X_UNIT_EFFECTIVITY_ID    IN NUMBER,
 X_MR_ROUTE_ID            IN NUMBER,
 X_MATERIAL_REQUEST_TYPE  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_SCHEDULE_MATERIALS(
    SCHEDULED_MATERIAL_ID,
    OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    INVENTORY_ITEM_ID,
    SCHEDULE_DESIGNATOR,
    VISIT_ID,
    VISIT_START_DATE,
    VISIT_TASK_ID,
    ORGANIZATION_ID,
    SCHEDULED_DATE,
    REQUEST_ID,
    REQUESTED_DATE,
    SCHEDULED_QUANTITY,
    PROCESS_STATUS,
    ERROR_MESSAGE,
    TRANSACTION_ID,
    UOM,
    RT_OPER_MATERIAL_ID,
    OPERATION_CODE,
    OPERATION_SEQUENCE,
    ITEM_GROUP_ID,
    REQUESTED_QUANTITY,
    PROGRAM_ID,
    PROGRAM_UPDATE_DATE,
    LAST_UPDATED_DATE,
    WORKORDER_OPERATION_ID,
    POSITION_PATH_ID,
    RELATIONSHIP_ID,
    UNIT_EFFECTIVITY_ID,
    MR_ROUTE_ID,
    MATERIAL_REQUEST_TYPE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15
)
VALUES
(
    AHL_SCHEDULE_MATERIALS_S.NEXTVAL,
    X_OBJECT_VERSION_NUMBER,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_INVENTORY_ITEM_ID,
    X_SCHEDULE_DESIGNATOR,
    X_VISIT_ID,
    X_VISIT_START_DATE,
    X_VISIT_TASK_ID,
    X_ORGANIZATION_ID,
    X_SCHEDULED_DATE,
    X_REQUEST_ID,
    X_REQUESTED_DATE,
    X_SCHEDULED_QUANTITY,
    X_PROCESS_STATUS,
    X_ERROR_MESSAGE,
    X_TRANSACTION_ID,
    X_UOM,
    X_RT_OPER_MATERIAL_ID,
    X_OPERATION_CODE,
    X_OPERATION_SEQUENCE,
    X_ITEM_GROUP_ID,
    X_REQUESTED_QUANTITY,
    X_PROGRAM_ID,
    X_PROGRAM_UPDATE_DATE,
    X_LAST_UPDATED_DATE,
    X_WORKORDER_OPERATION_ID,
    X_POSITION_PATH_ID,
    X_RELATIONSHIP_ID,
    X_UNIT_EFFECTIVITY_ID,
    X_MR_ROUTE_ID,
    X_MATERIAL_REQUEST_TYPE,
    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
 );

Line: 167

END INSERT_ROW;

Line: 169

PROCEDURE UPDATE_ROW (
 X_SCHEDULED_MATERIAL_ID  IN  NUMBER,
 X_OBJECT_VERSION_NUMBER  IN NUMBER,
 X_LAST_UPDATE_DATE       IN DATE,
 X_LAST_UPDATED_BY        IN NUMBER,
 --X_CREATION_DATE          IN DATE,
 --X_CREATED_BY             IN NUMBER,
 X_LAST_UPDATE_LOGIN      IN NUMBER,
 X_INVENTORY_ITEM_ID      IN NUMBER,
 X_SCHEDULE_DESIGNATOR    IN VARCHAR2,
 X_VISIT_ID               IN NUMBER,
 X_VISIT_START_DATE       IN DATE,
 X_VISIT_TASK_ID          IN NUMBER,
 X_ORGANIZATION_ID        IN NUMBER,
 X_SCHEDULED_DATE         IN DATE,
 X_REQUEST_ID             IN NUMBER,
 X_REQUESTED_DATE         IN DATE,
 X_SCHEDULED_QUANTITY     IN NUMBER,
 X_PROCESS_STATUS         IN NUMBER,
 X_ERROR_MESSAGE          IN VARCHAR2,
 X_TRANSACTION_ID         IN NUMBER,
 X_UOM                    IN VARCHAR2,
 X_RT_OPER_MATERIAL_ID    IN NUMBER,
 X_OPERATION_CODE         IN VARCHAR2,
 X_OPERATION_SEQUENCE     IN NUMBER,
 X_ITEM_GROUP_ID          IN NUMBER,
 X_REQUESTED_QUANTITY     IN NUMBER,
 X_PROGRAM_ID             IN NUMBER,
 X_PROGRAM_UPDATE_DATE    IN DATE,
 X_LAST_UPDATED_DATE      IN DATE,
 X_WORKORDER_OPERATION_ID IN NUMBER,
 X_POSITION_PATH_ID       IN NUMBER,
 X_RELATIONSHIP_ID        IN NUMBER,
 X_UNIT_EFFECTIVITY_ID    IN NUMBER,
 X_MR_ROUTE_ID            IN NUMBER,
 X_MATERIAL_REQUEST_TYPE  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_SCHEDULE_MATERIALS SET
     SCHEDULED_MATERIAL_ID        = X_SCHEDULED_MATERIAL_ID,
     OBJECT_VERSION_NUMBER        = X_OBJECT_VERSION_NUMBER + 1,
     LAST_UPDATE_DATE             = X_LAST_UPDATE_DATE,
     LAST_UPDATED_BY              = X_LAST_UPDATED_BY,
     --CREATION_DATE              = X_CREATION_DATE,
     --CREATED_BY                 = X_CREATED_BY,
     LAST_UPDATE_LOGIN            = X_LAST_UPDATE_LOGIN,
     INVENTORY_ITEM_ID            = X_INVENTORY_ITEM_ID,
     SCHEDULE_DESIGNATOR          = X_SCHEDULE_DESIGNATOR,
     VISIT_ID                     = X_VISIT_ID,
     VISIT_START_DATE             = X_VISIT_START_DATE,
     VISIT_TASK_ID                = X_VISIT_TASK_ID,
     ORGANIZATION_ID              = X_ORGANIZATION_ID,
     SCHEDULED_DATE               = X_SCHEDULED_DATE,
     REQUEST_ID                   = X_REQUEST_ID,
     REQUESTED_DATE               = X_REQUESTED_DATE,
     SCHEDULED_QUANTITY           = X_SCHEDULED_QUANTITY,
     PROCESS_STATUS               = X_PROCESS_STATUS,
     ERROR_MESSAGE                = X_ERROR_MESSAGE,
     TRANSACTION_ID               = X_TRANSACTION_ID,
     UOM                          = X_UOM,
     RT_OPER_MATERIAL_ID          = X_RT_OPER_MATERIAL_ID,
     OPERATION_CODE               = X_OPERATION_CODE,
     OPERATION_SEQUENCE           = X_OPERATION_SEQUENCE,
     ITEM_GROUP_ID                = X_ITEM_GROUP_ID,
     REQUESTED_QUANTITY           = X_REQUESTED_QUANTITY,
     PROGRAM_ID                   = X_PROGRAM_ID,
     PROGRAM_UPDATE_DATE          = X_PROGRAM_UPDATE_DATE,
     LAST_UPDATED_DATE            = X_LAST_UPDATED_DATE,
     WORKORDER_OPERATION_ID       = X_WORKORDER_OPERATION_ID,
     POSITION_PATH_ID             = X_POSITION_PATH_ID,
     RELATIONSHIP_ID              = X_RELATIONSHIP_ID,
     UNIT_EFFECTIVITY_ID          = X_UNIT_EFFECTIVITY_ID,
     MR_ROUTE_ID                  = X_MR_ROUTE_ID,
     MATERIAL_REQUEST_TYPE        = X_MATERIAL_REQUEST_TYPE,
     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 SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID
  AND   OBJECT_VERSION_NUMBER=X_OBJECT_VERSION_NUMBER;

Line: 282

END UPDATE_ROW;

Line: 284

PROCEDURE DELETE_ROW (
  X_SCHEDULED_MATERIAL_ID IN NUMBER
) IS
BEGIN
  DELETE AHL_SCHEDULE_MATERIALS
  WHERE SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID;

Line: 295

END DELETE_ROW;