APPS.OE_SO_PLN_SERVER SQL Statements

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

Line: 119

  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;

Line: 151

        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;

Line: 210

    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;

Line: 244

record_deleted exception;

Line: 254

		raise record_deleted;

Line: 326

        ((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;

Line: 355

        ((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;

Line: 396

    when record_deleted then
		Result := 'RECORD_DELETED';

Line: 400

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;

Line: 524

      OE_MSG.Internal_Exception('OE_SO_PLN_SERVER.Update_Row',NULL,NULL);

Line: 526

END Update_Row;

Line: 532

  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));