APPS.OE_SO_PLD_TABLE SQL Statements

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

Line: 4

PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
    X_ATTRIBUTE1    VARCHAR2,
    X_ATTRIBUTE10    VARCHAR2,
    X_ATTRIBUTE11    VARCHAR2,
    X_ATTRIBUTE12    VARCHAR2,
    X_ATTRIBUTE13    VARCHAR2,
    X_ATTRIBUTE14    VARCHAR2,
    X_ATTRIBUTE15    VARCHAR2,
    X_ATTRIBUTE2    VARCHAR2,
    X_ATTRIBUTE3    VARCHAR2,
    X_ATTRIBUTE4    VARCHAR2,
    X_ATTRIBUTE5    VARCHAR2,
    X_ATTRIBUTE6    VARCHAR2,
    X_ATTRIBUTE7    VARCHAR2,
    X_ATTRIBUTE8    VARCHAR2,
    X_ATTRIBUTE9    VARCHAR2,
    X_AUTOSCHEDULED_FLAG    VARCHAR2,
    X_CONTEXT    VARCHAR2,
    X_CREATED_BY    NUMBER,
    X_CREATION_DATE    DATE,
    X_CUSTOMER_REQUESTED_LOT_FLAG    VARCHAR2,
    X_DELIVERY    NUMBER,
    X_DEMAND_CLASS_CODE    VARCHAR2,
    X_DEMAND_ID    NUMBER,
    X_DETAIL_TYPE_CODE    VARCHAR2,
    X_INVENTORY_LOCATION_ID    NUMBER,
    X_INVENTORY_LOCATION_SEGMENTS    VARCHAR2,
    X_LAST_UPDATED_BY    NUMBER,
    X_LAST_UPDATE_DATE    DATE,
    X_LAST_UPDATE_LOGIN    NUMBER,
    X_LATEST_ACCEPTABLE_DATE    DATE,
    X_LOT_NUMBER    VARCHAR2,
    X_PICKING_LINE_DETAIL_ID    NUMBER,
    X_PICKING_LINE_ID    NUMBER,
    X_PROGRAM_APPLICATION_ID    NUMBER,
    X_PROGRAM_ID    NUMBER,
    X_PROGRAM_UPDATE_DATE    DATE,
    X_RELEASED_FLAG    VARCHAR2,
    X_REQUESTED_QUANTITY    NUMBER,
    X_REQUEST_ID    NUMBER,
    X_RESERVABLE_FLAG    VARCHAR2,
    X_REVISION    VARCHAR2,
    X_SCHEDULE_DATE    DATE,
    X_SCHEDULE_LEVEL    NUMBER,
    X_SCHEDULE_STATUS_CODE    VARCHAR2,
    X_SEGMENT1    VARCHAR2,
    X_SEGMENT10    VARCHAR2,
    X_SEGMENT11    VARCHAR2,
    X_SEGMENT12    VARCHAR2,
    X_SEGMENT13    VARCHAR2,
    X_SEGMENT14    VARCHAR2,
    X_SEGMENT15    VARCHAR2,
    X_SEGMENT16    VARCHAR2,
    X_SEGMENT17    VARCHAR2,
    X_SEGMENT18    VARCHAR2,
    X_SEGMENT19    VARCHAR2,
    X_SEGMENT2    VARCHAR2,
    X_SEGMENT20    VARCHAR2,
    X_SEGMENT3    VARCHAR2,
    X_SEGMENT4    VARCHAR2,
    X_SEGMENT5    VARCHAR2,
    X_SEGMENT6    VARCHAR2,
    X_SEGMENT7    VARCHAR2,
    X_SEGMENT8    VARCHAR2,
    X_SEGMENT9    VARCHAR2,
    X_SERIAL_NUMBER    VARCHAR2,
    X_SHIPPED_QUANTITY    NUMBER,
    X_SUBINVENTORY    VARCHAR2,
    X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
    X_SUPPLY_SOURCE_TYPE    NUMBER,
    X_TRANSACTABLE_FLAG    VARCHAR2,
    X_UPDATE_FLAG    VARCHAR2,
    X_WAREHOUSE_ID    NUMBER,
    X_WIP_COMPLETED_QUANTITY    NUMBER,
    X_WIP_RESERVED_QUANTITY    NUMBER
)IS

CURSOR C IS SELECT rowid FROM so_picking_line_details
WHERE PICKING_LINE_DETAIL_ID = X_PICKING_LINE_DETAIL_ID;

Line: 85

     INSERT INTO so_picking_line_details(
        ATTRIBUTE1,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        AUTOSCHEDULED_FLAG,
        CONTEXT,
        CREATED_BY,
        CREATION_DATE,
        CUSTOMER_REQUESTED_LOT_FLAG,
        DELIVERY,
        DEMAND_CLASS_CODE,
        DEMAND_ID,
        DETAIL_TYPE_CODE,
        INVENTORY_LOCATION_ID,
        INVENTORY_LOCATION_SEGMENTS,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        LATEST_ACCEPTABLE_DATE,
        LOT_NUMBER,
        PICKING_LINE_DETAIL_ID,
        PICKING_LINE_ID,
        PROGRAM_APPLICATION_ID,
        PROGRAM_ID,
        PROGRAM_UPDATE_DATE,
        RELEASED_FLAG,
        REQUESTED_QUANTITY,
        REQUEST_ID,
        RESERVABLE_FLAG,
        REVISION,
        SCHEDULE_DATE,
        SCHEDULE_LEVEL,
        SCHEDULE_STATUS_CODE,
        SEGMENT1,
        SEGMENT10,
        SEGMENT11,
        SEGMENT12,
        SEGMENT13,
        SEGMENT14,
        SEGMENT15,
        SEGMENT16,
        SEGMENT17,
        SEGMENT18,
        SEGMENT19,
        SEGMENT2,
        SEGMENT20,
        SEGMENT3,
        SEGMENT4,
        SEGMENT5,
        SEGMENT6,
        SEGMENT7,
        SEGMENT8,
        SEGMENT9,
        SERIAL_NUMBER,
        SHIPPED_QUANTITY,
        SUBINVENTORY,
        SUPPLY_SOURCE_HEADER_ID,
        SUPPLY_SOURCE_TYPE,
        TRANSACTABLE_FLAG,
        UPDATE_FLAG,
        WAREHOUSE_ID,
        WIP_COMPLETED_QUANTITY,
        WIP_RESERVED_QUANTITY
        ) VALUES (
        X_ATTRIBUTE1,
        X_ATTRIBUTE10,
        X_ATTRIBUTE11,
        X_ATTRIBUTE12,
        X_ATTRIBUTE13,
        X_ATTRIBUTE14,
        X_ATTRIBUTE15,
        X_ATTRIBUTE2,
        X_ATTRIBUTE3,
        X_ATTRIBUTE4,
        X_ATTRIBUTE5,
        X_ATTRIBUTE6,
        X_ATTRIBUTE7,
        X_ATTRIBUTE8,
        X_ATTRIBUTE9,
        X_AUTOSCHEDULED_FLAG,
        X_CONTEXT,
        X_CREATED_BY,
        X_CREATION_DATE,
        X_CUSTOMER_REQUESTED_LOT_FLAG,
        X_DELIVERY,
        X_DEMAND_CLASS_CODE,
        X_DEMAND_ID,
        X_DETAIL_TYPE_CODE,
        X_INVENTORY_LOCATION_ID,
        X_INVENTORY_LOCATION_SEGMENTS,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATE_LOGIN,
        X_LATEST_ACCEPTABLE_DATE,
        X_LOT_NUMBER,
        X_PICKING_LINE_DETAIL_ID,
        X_PICKING_LINE_ID,
        X_PROGRAM_APPLICATION_ID,
        X_PROGRAM_ID,
        X_PROGRAM_UPDATE_DATE,
        X_RELEASED_FLAG,
        X_REQUESTED_QUANTITY,
        X_REQUEST_ID,
        X_RESERVABLE_FLAG,
        X_REVISION,
        X_SCHEDULE_DATE,
        X_SCHEDULE_LEVEL,
        X_SCHEDULE_STATUS_CODE,
        X_SEGMENT1,
        X_SEGMENT10,
        X_SEGMENT11,
        X_SEGMENT12,
        X_SEGMENT13,
        X_SEGMENT14,
        X_SEGMENT15,
        X_SEGMENT16,
        X_SEGMENT17,
        X_SEGMENT18,
        X_SEGMENT19,
        X_SEGMENT2,
        X_SEGMENT20,
        X_SEGMENT3,
        X_SEGMENT4,
        X_SEGMENT5,
        X_SEGMENT6,
        X_SEGMENT7,
        X_SEGMENT8,
        X_SEGMENT9,
        X_SERIAL_NUMBER,
        X_SHIPPED_QUANTITY,
        X_SUBINVENTORY,
        X_SUPPLY_SOURCE_HEADER_ID,
        X_SUPPLY_SOURCE_TYPE,
        X_TRANSACTABLE_FLAG,
        X_UPDATE_FLAG,
        X_WAREHOUSE_ID,
        X_WIP_COMPLETED_QUANTITY,
        X_WIP_RESERVED_QUANTITY
    );

Line: 244

END Insert_Row;

Line: 273

    X_LAST_UPDATED_BY    NUMBER,
    X_LAST_UPDATE_DATE    DATE,
    X_LAST_UPDATE_LOGIN    NUMBER,
    X_LATEST_ACCEPTABLE_DATE    DATE,
    X_LOT_NUMBER    VARCHAR2,
    X_PICKING_LINE_DETAIL_ID    NUMBER,
    X_PICKING_LINE_ID    NUMBER,
    X_PROGRAM_APPLICATION_ID    NUMBER,
    X_PROGRAM_ID    NUMBER,
    X_PROGRAM_UPDATE_DATE    DATE,
    X_RELEASED_FLAG    VARCHAR2,
    X_REQUESTED_QUANTITY    NUMBER,
    X_REQUEST_ID    NUMBER,
    X_RESERVABLE_FLAG    VARCHAR2,
    X_REVISION    VARCHAR2,
    X_SCHEDULE_DATE    DATE,
    X_SCHEDULE_LEVEL    NUMBER,
    X_SCHEDULE_STATUS_CODE    VARCHAR2,
    X_SEGMENT1    VARCHAR2,
    X_SEGMENT10    VARCHAR2,
    X_SEGMENT11    VARCHAR2,
    X_SEGMENT12    VARCHAR2,
    X_SEGMENT13    VARCHAR2,
    X_SEGMENT14    VARCHAR2,
    X_SEGMENT15    VARCHAR2,
    X_SEGMENT16    VARCHAR2,
    X_SEGMENT17    VARCHAR2,
    X_SEGMENT18    VARCHAR2,
    X_SEGMENT19    VARCHAR2,
    X_SEGMENT2    VARCHAR2,
    X_SEGMENT20    VARCHAR2,
    X_SEGMENT3    VARCHAR2,
    X_SEGMENT4    VARCHAR2,
    X_SEGMENT5    VARCHAR2,
    X_SEGMENT6    VARCHAR2,
    X_SEGMENT7    VARCHAR2,
    X_SEGMENT8    VARCHAR2,
    X_SEGMENT9    VARCHAR2,
    X_SERIAL_NUMBER    VARCHAR2,
    X_SHIPPED_QUANTITY    NUMBER,
    X_SUBINVENTORY    VARCHAR2,
    X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
    X_SUPPLY_SOURCE_TYPE    NUMBER,
    X_TRANSACTABLE_FLAG    VARCHAR2,
    X_UPDATE_FLAG    VARCHAR2,
    X_WAREHOUSE_ID    NUMBER,
    X_WIP_COMPLETED_QUANTITY    NUMBER,
    X_WIP_RESERVED_QUANTITY    NUMBER,
    Result OUT VARCHAR2)IS

CURSOR C IS SELECT * FROM so_picking_line_details
WHERE rowid = X_rowid
FOR UPDATE NOWAIT;

Line: 329

record_deleted exception;

Line: 341

	    raise record_deleted;

Line: 404

        ((Recinfo.LAST_UPDATED_BY <> X_LAST_UPDATED_BY)
          AND NOT (Recinfo.LAST_UPDATED_BY is NULL AND X_LAST_UPDATED_BY is NULL)) OR
        ((Recinfo.LAST_UPDATE_DATE <> X_LAST_UPDATE_DATE)
          AND NOT (Recinfo.LAST_UPDATE_DATE is NULL AND X_LAST_UPDATE_DATE is NULL)) OR
        ((Recinfo.LAST_UPDATE_LOGIN <> X_LAST_UPDATE_LOGIN)
          AND NOT (Recinfo.LAST_UPDATE_LOGIN is NULL AND X_LAST_UPDATE_LOGIN is NULL)) OR
        ((Recinfo.LATEST_ACCEPTABLE_DATE <> X_LATEST_ACCEPTABLE_DATE)
          AND NOT (Recinfo.LATEST_ACCEPTABLE_DATE is NULL AND X_LATEST_ACCEPTABLE_DATE is NULL)) OR
        ((Recinfo.LOT_NUMBER <> X_LOT_NUMBER)
          AND NOT (Recinfo.LOT_NUMBER is NULL AND X_LOT_NUMBER is NULL)) OR
        ((Recinfo.PICKING_LINE_DETAIL_ID <> X_PICKING_LINE_DETAIL_ID)
          AND NOT (Recinfo.PICKING_LINE_DETAIL_ID is NULL AND X_PICKING_LINE_DETAIL_ID is NULL)) OR
        ((Recinfo.PICKING_LINE_ID <> X_PICKING_LINE_ID)
          AND NOT (Recinfo.PICKING_LINE_ID is NULL AND X_PICKING_LINE_ID is NULL)) OR
        ((Recinfo.PROGRAM_APPLICATION_ID <> X_PROGRAM_APPLICATION_ID)
          AND NOT (Recinfo.PROGRAM_APPLICATION_ID is NULL AND X_PROGRAM_APPLICATION_ID is NULL)) OR
        ((Recinfo.PROGRAM_ID <> X_PROGRAM_ID)
          AND NOT (Recinfo.PROGRAM_ID is NULL AND X_PROGRAM_ID is NULL)) OR
        ((Recinfo.PROGRAM_UPDATE_DATE <> X_PROGRAM_UPDATE_DATE)
          AND NOT (Recinfo.PROGRAM_UPDATE_DATE is NULL AND X_PROGRAM_UPDATE_DATE is NULL)) OR
        ((Recinfo.RELEASED_FLAG <> X_RELEASED_FLAG)
          AND NOT (Recinfo.RELEASED_FLAG is NULL AND X_RELEASED_FLAG is NULL)) OR
        ((Recinfo.REQUESTED_QUANTITY <> X_REQUESTED_QUANTITY)
          AND NOT (Recinfo.REQUESTED_QUANTITY is NULL AND X_REQUESTED_QUANTITY is NULL)) OR
        ((Recinfo.REQUEST_ID <> X_REQUEST_ID)
          AND NOT (Recinfo.REQUEST_ID is NULL AND X_REQUEST_ID is NULL)) OR
        ((Recinfo.RESERVABLE_FLAG <> X_RESERVABLE_FLAG)
          AND NOT (Recinfo.RESERVABLE_FLAG is NULL AND X_RESERVABLE_FLAG is NULL))
    ) then
        raise record_changed;

Line: 502

        ((Recinfo.UPDATE_FLAG <> X_UPDATE_FLAG)
          AND NOT (Recinfo.UPDATE_FLAG is NULL AND X_UPDATE_FLAG is NULL)) OR
        ((Recinfo.WAREHOUSE_ID <> X_WAREHOUSE_ID)
          AND NOT (Recinfo.WAREHOUSE_ID is NULL AND X_WAREHOUSE_ID is NULL)) OR
        ((Recinfo.WIP_COMPLETED_QUANTITY <> X_WIP_COMPLETED_QUANTITY)
          AND NOT (Recinfo.WIP_COMPLETED_QUANTITY is NULL AND X_WIP_COMPLETED_QUANTITY is NULL)) OR
        ((Recinfo.WIP_RESERVED_QUANTITY <> X_WIP_RESERVED_QUANTITY)
          AND NOT (Recinfo.WIP_RESERVED_QUANTITY is NULL AND X_WIP_RESERVED_QUANTITY is NULL))
    ) then
        raise record_changed;

Line: 518

    when record_deleted then
        Result := 'RECORD_DELETED';

Line: 524

PROCEDURE Update_Row(X_Rowid VARCHAR2,
    X_ATTRIBUTE1    VARCHAR2,
    X_ATTRIBUTE10    VARCHAR2,
    X_ATTRIBUTE11    VARCHAR2,
    X_ATTRIBUTE12    VARCHAR2,
    X_ATTRIBUTE13    VARCHAR2,
    X_ATTRIBUTE14    VARCHAR2,
    X_ATTRIBUTE15    VARCHAR2,
    X_ATTRIBUTE2    VARCHAR2,
    X_ATTRIBUTE3    VARCHAR2,
    X_ATTRIBUTE4    VARCHAR2,
    X_ATTRIBUTE5    VARCHAR2,
    X_ATTRIBUTE6    VARCHAR2,
    X_ATTRIBUTE7    VARCHAR2,
    X_ATTRIBUTE8    VARCHAR2,
    X_ATTRIBUTE9    VARCHAR2,
    X_AUTOSCHEDULED_FLAG    VARCHAR2,
    X_CONTEXT    VARCHAR2,
    X_CREATED_BY    NUMBER,
    X_CREATION_DATE    DATE,
    X_CUSTOMER_REQUESTED_LOT_FLAG    VARCHAR2,
    X_DELIVERY    NUMBER,
    X_DEMAND_CLASS_CODE    VARCHAR2,
    X_DEMAND_ID    NUMBER,
    X_DETAIL_TYPE_CODE    VARCHAR2,
    X_INVENTORY_LOCATION_ID    NUMBER,
    X_INVENTORY_LOCATION_SEGMENTS    VARCHAR2,
    X_LAST_UPDATED_BY    NUMBER,
    X_LAST_UPDATE_DATE    DATE,
    X_LAST_UPDATE_LOGIN    NUMBER,
    X_LATEST_ACCEPTABLE_DATE    DATE,
    X_LOT_NUMBER    VARCHAR2,
    X_PICKING_LINE_DETAIL_ID    NUMBER,
    X_PICKING_LINE_ID    NUMBER,
    X_PROGRAM_APPLICATION_ID    NUMBER,
    X_PROGRAM_ID    NUMBER,
    X_PROGRAM_UPDATE_DATE    DATE,
    X_RELEASED_FLAG    VARCHAR2,
    X_REQUESTED_QUANTITY    NUMBER,
    X_REQUEST_ID    NUMBER,
    X_RESERVABLE_FLAG    VARCHAR2,
    X_REVISION    VARCHAR2,
    X_SCHEDULE_DATE    DATE,
    X_SCHEDULE_LEVEL    NUMBER,
    X_SCHEDULE_STATUS_CODE    VARCHAR2,
    X_SEGMENT1    VARCHAR2,
    X_SEGMENT10    VARCHAR2,
    X_SEGMENT11    VARCHAR2,
    X_SEGMENT12    VARCHAR2,
    X_SEGMENT13    VARCHAR2,
    X_SEGMENT14    VARCHAR2,
    X_SEGMENT15    VARCHAR2,
    X_SEGMENT16    VARCHAR2,
    X_SEGMENT17    VARCHAR2,
    X_SEGMENT18    VARCHAR2,
    X_SEGMENT19    VARCHAR2,
    X_SEGMENT2    VARCHAR2,
    X_SEGMENT20    VARCHAR2,
    X_SEGMENT3    VARCHAR2,
    X_SEGMENT4    VARCHAR2,
    X_SEGMENT5    VARCHAR2,
    X_SEGMENT6    VARCHAR2,
    X_SEGMENT7    VARCHAR2,
    X_SEGMENT8    VARCHAR2,
    X_SEGMENT9    VARCHAR2,
    X_SERIAL_NUMBER    VARCHAR2,
    X_SHIPPED_QUANTITY    NUMBER,
    X_SUBINVENTORY    VARCHAR2,
    X_SUPPLY_SOURCE_HEADER_ID    NUMBER,
    X_SUPPLY_SOURCE_TYPE    NUMBER,
    X_TRANSACTABLE_FLAG    VARCHAR2,
    X_UPDATE_FLAG    VARCHAR2,
    X_WAREHOUSE_ID    NUMBER,
    X_WIP_COMPLETED_QUANTITY    NUMBER,
    X_WIP_RESERVED_QUANTITY    NUMBER
)IS

BEGIN
    UPDATE so_picking_line_details
    SET
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    AUTOSCHEDULED_FLAG = X_AUTOSCHEDULED_FLAG,
    CONTEXT = X_CONTEXT,
    CREATED_BY = X_CREATED_BY,
    CREATION_DATE = X_CREATION_DATE,
    CUSTOMER_REQUESTED_LOT_FLAG = X_CUSTOMER_REQUESTED_LOT_FLAG,
    DELIVERY = X_DELIVERY,
    DEMAND_CLASS_CODE = X_DEMAND_CLASS_CODE,
    DEMAND_ID = X_DEMAND_ID,
    DETAIL_TYPE_CODE = X_DETAIL_TYPE_CODE,
    INVENTORY_LOCATION_ID = X_INVENTORY_LOCATION_ID,
    INVENTORY_LOCATION_SEGMENTS = X_INVENTORY_LOCATION_SEGMENTS,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    LATEST_ACCEPTABLE_DATE = X_LATEST_ACCEPTABLE_DATE,
    LOT_NUMBER = X_LOT_NUMBER,
    PICKING_LINE_DETAIL_ID = X_PICKING_LINE_DETAIL_ID,
    PICKING_LINE_ID = X_PICKING_LINE_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
    RELEASED_FLAG = X_RELEASED_FLAG,
    REQUESTED_QUANTITY = X_REQUESTED_QUANTITY,
    REQUEST_ID = X_REQUEST_ID,
    RESERVABLE_FLAG = X_RESERVABLE_FLAG,
    REVISION = X_REVISION,
    SCHEDULE_DATE = X_SCHEDULE_DATE,
    SCHEDULE_LEVEL = X_SCHEDULE_LEVEL,
    SCHEDULE_STATUS_CODE = X_SCHEDULE_STATUS_CODE,
    SEGMENT1 = X_SEGMENT1,
    SEGMENT10 = X_SEGMENT10,
    SEGMENT11 = X_SEGMENT11,
    SEGMENT12 = X_SEGMENT12,
    SEGMENT13 = X_SEGMENT13,
    SEGMENT14 = X_SEGMENT14,
    SEGMENT15 = X_SEGMENT15,
    SEGMENT16 = X_SEGMENT16,
    SEGMENT17 = X_SEGMENT17,
    SEGMENT18 = X_SEGMENT18,
    SEGMENT19 = X_SEGMENT19,
    SEGMENT2 = X_SEGMENT2,
    SEGMENT20 = X_SEGMENT20,
    SEGMENT3 = X_SEGMENT3,
    SEGMENT4 = X_SEGMENT4,
    SEGMENT5 = X_SEGMENT5,
    SEGMENT6 = X_SEGMENT6,
    SEGMENT7 = X_SEGMENT7,
    SEGMENT8 = X_SEGMENT8,
    SEGMENT9 = X_SEGMENT9,
    SERIAL_NUMBER = X_SERIAL_NUMBER,
    SHIPPED_QUANTITY = X_SHIPPED_QUANTITY,
    SUBINVENTORY = X_SUBINVENTORY,
    SUPPLY_SOURCE_HEADER_ID = X_SUPPLY_SOURCE_HEADER_ID,
    SUPPLY_SOURCE_TYPE = X_SUPPLY_SOURCE_TYPE,
    TRANSACTABLE_FLAG = X_TRANSACTABLE_FLAG,
    UPDATE_FLAG = X_UPDATE_FLAG,
    WAREHOUSE_ID = X_WAREHOUSE_ID,
    WIP_COMPLETED_QUANTITY = X_WIP_COMPLETED_QUANTITY,
    WIP_RESERVED_QUANTITY = X_WIP_RESERVED_QUANTITY
    WHERE ROWID = X_Rowid;

Line: 683

END Update_Row;

Line: 685

PROCEDURE Delete_Row(X_Rowid VARCHAR2)
    IS

BEGIN
    DELETE FROM so_picking_line_details
    WHERE ROWID = X_Rowid;

Line: 695

END Delete_Row;