The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(SUM ( NVL ( REQUESTED_QUANTITY , 0 ) ), 0)
INTO DB_Res_Qty
FROM SO_PICKING_LINE_DETAILS
WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
AND PICKING_LINE_ID = X_Picking_Line_Id;
SELECT schedule_date
, demand_class_code
, ship_to_site_use_id
, warehouse_id
, ship_to_contact_id
, shipment_priority_code
, ship_method_code
INTO P_Db_Schedule_Date
, P_Db_Demand_Class_Code
, P_Db_Ship_To_Site_Use_Id
, P_Db_Warehouse_Id
, P_Db_Ship_To_Contact_Id
, P_Db_Shipment_Priority_Code
, P_Db_Ship_Method_Code
FROM SO_PICKING_LINES
WHERE rowid = X_Row_Id;
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_LATEST_ACCEPTABLE_DATE DATE,
X_LINE_DETAIL_ID NUMBER,
X_ORDER_LINE_ID NUMBER,
X_ORGANIZATION_ID NUMBER,
X_ORIGINAL_REQUESTED_QUANTITY NUMBER,
X_PICKING_HEADER_ID NUMBER,
X_PICKING_LINE_ID NUMBER,
X_PROGRAM_APPLICATION_ID NUMBER,
X_PROGRAM_ID NUMBER,
X_PROGRAM_UPDATE_DATE DATE,
X_RA_INTERFACE_STATUS VARCHAR2,
X_REQUESTED_QUANTITY NUMBER,
X_REQUEST_ID NUMBER,
X_SCHEDULE_DATE DATE,
X_SEQUENCE_NUMBER NUMBER,
X_SHIPMENT_PRIORITY_CODE VARCHAR2,
X_SHIPPED_QUANTITY NUMBER,
X_SHIP_METHOD_CODE VARCHAR2,
X_SHIP_TO_CONTACT_ID NUMBER,
X_SHIP_TO_SITE_USE_ID NUMBER,
X_UNIT_CODE VARCHAR2,
X_WAREHOUSE_ID NUMBER,
Result OUT VARCHAR2)IS
CURSOR C IS SELECT * FROM so_picking_lines
WHERE rowid = X_rowid
FOR UPDATE NOWAIT;
record_deleted exception;
raise record_deleted;
((Recinfo.LAST_UPDATED_BY <> X_LAST_UPDATED_BY)
AND NOT (Recinfo.LAST_UPDATED_BY is NULL AND X_LAST_UPDATED_BY is NULL)) AND
((Recinfo.LAST_UPDATE_DATE <> X_LAST_UPDATE_DATE)
AND NOT (Recinfo.LAST_UPDATE_DATE is NULL AND X_LAST_UPDATE_DATE is NULL)) AND
((Recinfo.LAST_UPDATE_LOGIN <> X_LAST_UPDATE_LOGIN)
AND NOT (Recinfo.LAST_UPDATE_LOGIN is NULL AND X_LAST_UPDATE_LOGIN is NULL)) AND
((Recinfo.LATEST_ACCEPTABLE_DATE <> X_LATEST_ACCEPTABLE_DATE)
AND NOT (Recinfo.LATEST_ACCEPTABLE_DATE is NULL AND X_LATEST_ACCEPTABLE_DATE is NULL)) AND
((Recinfo.LINE_DETAIL_ID <> X_LINE_DETAIL_ID)
AND NOT (Recinfo.LINE_DETAIL_ID is NULL AND X_LINE_DETAIL_ID is NULL)) AND
((Recinfo.ORDER_LINE_ID <> X_ORDER_LINE_ID)
AND NOT (Recinfo.ORDER_LINE_ID is NULL AND X_ORDER_LINE_ID is NULL)) AND
-- ((Recinfo.ORGANIZATION_ID <> X_ORGANIZATION_ID)
-- AND NOT (Recinfo.ORGANIZATION_ID is NULL AND X_ORGANIZATION_ID is NULL)) AND
((Recinfo.ORIGINAL_REQUESTED_QUANTITY <> X_ORIGINAL_REQUESTED_QUANTITY)
AND NOT (Recinfo.ORIGINAL_REQUESTED_QUANTITY is NULL AND X_ORIGINAL_REQUESTED_QUANTITY is NULL))
) then
raise record_changed;
((Recinfo.PROGRAM_UPDATE_DATE <> X_PROGRAM_UPDATE_DATE)
AND NOT (Recinfo.PROGRAM_UPDATE_DATE is NULL AND X_PROGRAM_UPDATE_DATE is NULL)) AND
((Recinfo.RA_INTERFACE_STATUS <> X_RA_INTERFACE_STATUS)
AND NOT (Recinfo.RA_INTERFACE_STATUS is NULL AND X_RA_INTERFACE_STATUS is NULL)) AND
((Recinfo.REQUESTED_QUANTITY <> X_REQUESTED_QUANTITY)
AND NOT (Recinfo.REQUESTED_QUANTITY is NULL AND X_REQUESTED_QUANTITY is NULL)) AND
((Recinfo.REQUEST_ID <> X_REQUEST_ID)
AND NOT (Recinfo.REQUEST_ID is NULL AND X_REQUEST_ID is NULL)) AND
((Recinfo.SCHEDULE_DATE <> X_SCHEDULE_DATE)
AND NOT (Recinfo.SCHEDULE_DATE is NULL AND X_SCHEDULE_DATE is NULL)) AND
((Recinfo.SEQUENCE_NUMBER <> X_SEQUENCE_NUMBER)
AND NOT (Recinfo.SEQUENCE_NUMBER is NULL AND X_SEQUENCE_NUMBER is NULL)) AND
((Recinfo.SHIPMENT_PRIORITY_CODE <> X_SHIPMENT_PRIORITY_CODE)
AND NOT (Recinfo.SHIPMENT_PRIORITY_CODE is NULL AND X_SHIPMENT_PRIORITY_CODE is NULL)) AND
((Recinfo.SHIPPED_QUANTITY <> X_SHIPPED_QUANTITY)
AND NOT (Recinfo.SHIPPED_QUANTITY is NULL AND X_SHIPPED_QUANTITY is NULL)) AND
((Recinfo.SHIP_METHOD_CODE <> X_SHIP_METHOD_CODE)
AND NOT (Recinfo.SHIP_METHOD_CODE is NULL AND X_SHIP_METHOD_CODE is NULL))
) then
raise record_changed;
when record_deleted then
Result := 'RECORD_DELETED';
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_CANCELLED_QUANTITY NUMBER,
X_COMPONENT_CODE VARCHAR2,
X_COMPONENT_RATIO NUMBER,
X_COMPONENT_SEQUENCE_ID NUMBER,
X_CONFIGURATION_ITEM_FLAG VARCHAR2,
X_CONTEXT VARCHAR2,
X_CREATED_BY NUMBER,
X_CREATION_DATE DATE,
X_DATE_CONFIRMED DATE,
X_DATE_REQUESTED DATE,
X_DEMAND_CLASS_CODE VARCHAR2,
X_INCLUDED_ITEM_FLAG VARCHAR2,
X_INVENTORY_ITEM_ID NUMBER,
X_INVENTORY_STATUS VARCHAR2,
X_INVOICED_QUANTITY NUMBER,
X_LAST_UPDATED_BY NUMBER,
X_LAST_UPDATE_DATE DATE,
X_LAST_UPDATE_LOGIN NUMBER,
X_LATEST_ACCEPTABLE_DATE DATE,
X_LINE_DETAIL_ID NUMBER,
X_ORDER_LINE_ID NUMBER,
X_ORGANIZATION_ID NUMBER,
X_ORIGINAL_REQUESTED_QUANTITY NUMBER,
X_PICKING_HEADER_ID NUMBER,
X_PICKING_LINE_ID NUMBER,
X_PROGRAM_APPLICATION_ID NUMBER,
X_PROGRAM_ID NUMBER,
X_PROGRAM_UPDATE_DATE DATE,
X_RA_INTERFACE_STATUS VARCHAR2,
X_REQUESTED_QUANTITY NUMBER,
X_REQUEST_ID NUMBER,
X_SCHEDULE_DATE DATE,
X_SEQUENCE_NUMBER NUMBER,
X_SHIPMENT_PRIORITY_CODE VARCHAR2,
X_SHIPPED_QUANTITY NUMBER,
X_SHIP_METHOD_CODE VARCHAR2,
X_SHIP_TO_CONTACT_ID NUMBER,
X_SHIP_TO_SITE_USE_ID NUMBER,
X_UNIT_CODE VARCHAR2,
X_WAREHOUSE_ID NUMBER
)IS
BEGIN
UPDATE so_picking_lines
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,
CANCELLED_QUANTITY = X_CANCELLED_QUANTITY,
COMPONENT_CODE = X_COMPONENT_CODE,
COMPONENT_RATIO = X_COMPONENT_RATIO,
COMPONENT_SEQUENCE_ID = X_COMPONENT_SEQUENCE_ID,
CONFIGURATION_ITEM_FLAG = X_CONFIGURATION_ITEM_FLAG,
CONTEXT = X_CONTEXT,
CREATED_BY = X_CREATED_BY,
CREATION_DATE = X_CREATION_DATE,
DATE_CONFIRMED = X_DATE_CONFIRMED,
DATE_REQUESTED = X_DATE_REQUESTED,
DEMAND_CLASS_CODE = X_DEMAND_CLASS_CODE,
INCLUDED_ITEM_FLAG = X_INCLUDED_ITEM_FLAG,
INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
INVENTORY_STATUS = X_INVENTORY_STATUS,
INVOICED_QUANTITY = X_INVOICED_QUANTITY,
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,
LINE_DETAIL_ID = X_LINE_DETAIL_ID,
ORDER_LINE_ID = X_ORDER_LINE_ID,
-- ORGANIZATION_ID = X_ORGANIZATION_ID,
ORIGINAL_REQUESTED_QUANTITY = X_ORIGINAL_REQUESTED_QUANTITY,
PICKING_HEADER_ID = X_PICKING_HEADER_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,
RA_INTERFACE_STATUS = X_RA_INTERFACE_STATUS,
REQUESTED_QUANTITY = X_REQUESTED_QUANTITY,
REQUEST_ID = X_REQUEST_ID,
SCHEDULE_DATE = X_SCHEDULE_DATE,
SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
SHIPMENT_PRIORITY_CODE = X_SHIPMENT_PRIORITY_CODE,
SHIPPED_QUANTITY = X_SHIPPED_QUANTITY,
SHIP_METHOD_CODE = X_SHIP_METHOD_CODE,
SHIP_TO_CONTACT_ID = X_SHIP_TO_CONTACT_ID,
SHIP_TO_SITE_USE_ID = X_SHIP_TO_SITE_USE_ID,
UNIT_CODE = X_UNIT_CODE,
WAREHOUSE_ID = X_WAREHOUSE_ID
WHERE ROWID = X_Rowid;
OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Update_Row',NULL,NULL);
END Update_Row;
SELECT min(1)
INTO complexDetails
FROM so_picking_line_details
WHERE picking_line_id = x_picking_line_id
AND NVL( released_flag, 'N') = 'N'
HAVING COUNT( DISTINCT warehouse_id) > 1
OR COUNT( DISTINCT schedule_date) > 1
OR COUNT( DISTINCT revision) > 1
OR COUNT( DISTINCT lot_number) > 1
OR COUNT( DISTINCT subinventory) > 1
OR COUNT( DISTINCT demand_class_code) > 1
OR ( COUNT( subinventory) > 0
AND COUNT( subinventory) <> COUNT(1))
OR ( COUNT( warehouse_id) > 0
AND COUNT( warehouse_id) <> COUNT(1))
OR ( COUNT( schedule_date) > 0
AND COUNT( schedule_date) <> COUNT(1))
OR ( COUNT( lot_number) > 0
AND COUNT( lot_number) <> COUNT(1))
OR ( COUNT( revision) > 0
AND COUNT( revision) <> COUNT(1))
OR ( COUNT( demand_class_code) > 0
AND COUNT( demand_class_code) <> COUNT(1));