APPS.OE_SHP_PROCESS SQL Statements

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

Line: 170

		SELECT NVL(SUM(  ROUND( (NVL( ORDERED_QUANTITY, 0 ) -
                         NVL( CANCELLED_QUANTITY, 0 )) *
                         NVL(SELLING_PRICE, 0 ),
                 P_Order_Currency_Precision))
                 , 0)
		,NVL( SUM( DECODE( SERVICE_PARENT_LINE_ID, P_Lines_LINE_ID,
                 ROUND( (NVL( ORDERED_QUANTITY, 0 ) -
                         NVL( CANCELLED_QUANTITY, 0 ) ) *
                         NVL( SELLING_PRICE, 0 ),
                  P_Order_Currency_Precision), 0 ) ), 0 )
		INTO   P_Shp_Total
		,P_Shp_Service_Total
		FROM   SO_LINES
		WHERE (ROWID = P_Shp_Row_Id
		OR  PARENT_LINE_ID = P_Shp_Line_Id
		OR SERVICE_PARENT_LINE_ID = P_Shp_Line_Id );

Line: 187

                SELECT NVL(SUM(  ROUND( (NVL( ORDERED_QUANTITY, 0 ) -
                         NVL( CANCELLED_QUANTITY, 0 )) *
                         NVL(SELLING_PRICE, 0 ),
                 P_Order_Currency_Precision))
                 , 0)
                ,NVL( SUM( DECODE( SERVICE_PARENT_LINE_ID, P_Lines_LINE_ID,
                 ROUND( (NVL( ORDERED_QUANTITY, 0 ) -
                         NVL( CANCELLED_QUANTITY, 0 ) ) *
                         NVL( SELLING_PRICE, 0 ),
                  P_Order_Currency_Precision), 0 ) ), 0 )
                INTO   P_Shp_Total
                ,P_Shp_Service_Total
                FROM   SO_LINES
                WHERE (ROWID = P_Shp_Row_Id
                OR  SERVICE_PARENT_LINE_ID = P_Shp_Line_Id );

Line: 457

      SELECT NVL(SUM( (NVL( ORDERED_QUANTITY, 0 ) -
                       NVL( CANCELLED_QUANTITY, 0 )) *
                      NVL(SELLING_PRICE, 0 ))
                    , 0)
      INTO   P_Line_Total
      FROM   SO_LINES
         WHERE ( SHIPMENT_SCHEDULE_LINE_ID = P_line_Id
                 OR SERVICE_PARENT_LINE_ID = P_Line_Id );

Line: 499

SELECT NVL( SUM( NVL( ORDERED_QUANTITY, 0 ) -
                      NVL( CANCELLED_QUANTITY, 0 ) ), 0 ),
            COUNT(*)
     INTO   P_Lines_Shipment_Qty_Total,
            P_Lines_Shipment_Lines_Count
     FROM   SO_LINES
     WHERE  SHIPMENT_SCHEDULE_LINE_ID = P_Lines_Line_Id
     AND    PARENT_LINE_ID IS NULL
     AND    SERVICE_PARENT_LINE_ID IS NULL;

Line: 526

PROCEDURE  Update_Line_Type_Code
(
        P_Line_Id               IN NUMBER,
        P_Line_Type_Code        IN VARCHAR2,
        P_Return_Status         OUT VARCHAR2
)
is

begin

  if ( P_Line_Type_Code <> 'REGULAR') then
     UPDATE SO_LINES
     SET LINE_TYPE_CODE = 'REGULAR'
     WHERE  LINE_ID = P_Line_Id;

Line: 541

     UPDATE SO_LINES
     SET LINE_TYPE_CODE = 'PARENT'
     WHERE  LINE_ID = P_Line_Id;

Line: 552

                                'OE_SHP_PROCESS.Update_Line_Type_Code',
                                Operation=>'',
                                Object=>'SHIPMENT',
                                Message=>' When Others');

Line: 557

end Update_Line_Type_Code;

Line: 572

 SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
     INTO P_Total_Shipment_Quantity
     FROM SO_LINES
     WHERE SHIPMENT_SCHEDULE_LINE_ID = P_Ship_Sched_Line_Id
     AND PARENT_LINE_ID IS NULL
     AND SERVICE_PARENT_LINE_ID IS NULL;

Line: 579

 SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
     INTO P_Open_Line_Quantity
     FROM SO_LINES
     WHERE LINE_ID = P_Ship_Sched_Line_Id;

Line: 606

PROCEDURE  Update_Line_Quantity
(
        P_Ship_Sched_Line_Id       IN OUT NUMBER,
        P_Total_Shipment_Quantity  IN OUT NUMBER,
        P_Open_Line_Quantity       IN OUT NUMBER,
        P_Line_Quantity            IN OUT NUMBER,
        P_Return_Status            OUT VARCHAR2
)
is

begin

 SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
     INTO P_Open_Line_Quantity
     FROM SO_LINES
     WHERE LINE_ID = P_Ship_Sched_Line_Id;

Line: 623

 UPDATE SO_LINES
     SET    ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0)
                        + P_Total_Shipment_Quantity
     WHERE  LINE_ID = P_Ship_Sched_Line_Id;

Line: 635

                                'OE_SHP_PROCESS.Update_Line_Quantity',
                                Operation=>'',
                                Object=>'SHIPMENT',
                                Message=>' When Others');

Line: 640

end Update_Line_Quantity;

Line: 642

PROCEDURE  Update_Parent_Option_Quantity
(
		P_Line_Id                  IN NUMBER,
		P_Total_Shipment_Quantity  IN NUMBER,
		P_Ordered_Quantity         IN NUMBER,
		P_Cancelled_Quantity       IN NUMBER,
		P_Return_Status            OUT VARCHAR2
)
is

x boolean;

Line: 656

 UPDATE SO_LINES
 SET    ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0) +
			 (((ORDERED_QUANTITY-NVL(CANCELLED_QUANTITY,0))/
		    (P_Ordered_Quantity-NVL(P_Cancelled_Quantity, 0)))
		 * P_Total_Shipment_Quantity)
	 WHERE  PARENT_LINE_ID  = P_Line_Id;

Line: 670

				'OE_SHP_PROCESS.Update_Parent_Option_Quantity',
				Operation=>'',
				Object=>'SHIPMENT',
				Message=>' When Others');

Line: 675

end Update_Parent_Option_Quantity;