APPS.OE_LIN SQL Statements

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

Line: 66

       SELECT NULL INTO L_Dummy
       FROM SO_DisCOUNTS
       WHERE PRICE_LisT_ID = NVL(X_PRICE_LIST_ID,X_Order_PRICE_LIST_ID)
/* Bug 524620 - do not check manual discount condition unless seling price
                is being changed, in which case X_Check_Multiple_Adj_Flag is
                passed as 'Y'.   */
/*     AND NVL(AUTOMATIC_DisCOUNT_FLAG,'N') = 'N' AND ROWNUM = 1;     */

Line: 77

         SELECT NULL INTO L_Dummy
                FROM SO_ORDER_TYPES
                WHERE ORDER_TYPE_ID = X_Order_ORDER_TYPE_ID
                AND ((ENFORCE_LINE_PRICES_FLAG = 'Y'
                AND X_Discounting_Privilage = 'UNLIMITED')
                OR ENFORCE_LINE_PRICES_FLAG = 'N') AND ROWNUM = 1;

Line: 85

              SELECT NULL INTO L_Dummy
                FROM   SO_PRICE_ADJUSTMENTS
                WHERE  HEADER_ID = X_HEADER_ID
                AND    LINE_ID   = X_LINE_ID
                AND    NVL( AUTOMATIC_FLAG, 'N' ) = 'N'
                HAVING COUNT(*) > 1;

Line: 205

             SELECT NULL INTO dummy FROM
	            	SO_PRICE_ADJUSTMENTS
                        WHERE   HEADER_ID = P_HEADER_ID
                        AND     LINE_ID = P_LINE_ID
                        AND     AUTOMATIC_FLAG = 'N';

Line: 211

             UPDATE  SO_PRICE_ADJUSTMENTS
                     SET     PERCENT =
                                        P_MANUAL_DisCOUNT_PERCENT
                                ,       DisCOUNT_ID =
                                        P_MANUAL_DisCOUNT_ID
                                ,       LAST_UPDATE_DATE =
                                        SYSDATE
                                ,       LAST_UPDATED_BY =
                                        P_USER_ID
                                ,       LAST_UPDATE_LOGIN =
                                        P_LOGIN_ID
                                WHERE   HEADER_ID = P_HEADER_ID
                                AND     LINE_ID = P_LINE_ID
                                AND     AUTOMATIC_FLAG = 'N';

Line: 231

               INSERT INTO SO_PRICE_ADJUSTMENTS
                                (      PRICE_ADJUSTMENT_ID
                                ,      CREATION_DATE
                                ,      CREATED_BY
                                ,      LAST_UPDATE_DATE
                                ,      LAST_UPDATED_BY
                                ,      LAST_UPDATE_LOGIN
                                ,      HEADER_ID
                                ,      LINE_ID
                                ,      DisCOUNT_ID
                                ,      DisCOUNT_LINE_ID
                                ,      AUTOMATIC_FLAG
                                ,      PERCENT)
                                VALUES
                                (      SO_PRICE_ADJUSTMENTS_S.NEXTVAL
                                ,      SYSDATE
                                ,      P_USER_ID
                                ,      SYSDATE
                                ,      P_USER_ID
                                ,      P_LOGIN_ID
                                ,      P_HEADER_ID
                                ,      P_LINE_ID
                                ,      P_MANUAL_DisCOUNT_ID
                                ,      P_MANUAL_DisCOUNT_LINE_ID
                                ,      'N'
                                ,      P_MANUAL_DisCOUNT_PERCENT);

Line: 262

                        DELETE FROM SO_PRICE_ADJUSTMENTS
                                     WHERE  HEADER_ID = P_HEADER_ID
                                     AND    LINE_ID = P_LINE_ID
                                     AND    AUTOMATIC_FLAG = 'N';

Line: 301

        SELECT NVL( SUM( NVL( PERCENT, 0 ) ), 0 )
        INTO   Lin_Obj_Adjustment_Total
        FROM   SO_PRICE_ADJUSTMENTS
        WHERE  HEADER_ID = Order_Header_Id
        AND (( Lin_Obj_Apply_Order_Adjs_Flag = 'Y'
        AND    LINE_ID is NULL )
        OR   ( LINE_ID = Lin_Obj_Line_Id
        AND    AUTOMATIC_FLAG = NVL(P_Automatic_Flag,AUTOMATIC_FLAG)));

Line: 492

        SELECT COUNT(*)
        INTO   L_Count
        FROM   SO_LINES
        WHERE  ROWID = Row_Id
        AND    S2 = 4;

Line: 532

        SELECT COUNT(*)
        INTO   L_Count
        FROM   SO_LINES
        WHERE  ROWID = Row_Id
        AND    ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0);

Line: 630

SELECT  NULL INTO L_Dummy
FROM    SO_LINE_DETAILS
WHERE   LINE_ID = P_Lin_Obj_Line_Id
AND     SCHEDULE_STATUS_CODE = 'SUPPLY RESERVED';

Line: 645

        SELECT  NULL INTO L_Dummy
        FROM    SO_LINE_DETAILS
        WHERE   NVL ( CONFIGURATION_ITEM_FLAG , 'N' ) = 'Y'
        AND     LINE_ID = P_Lin_Obj_Line_Id;

Line: 694

               select line_id
               from so_lines
               where service_parent_line_id = x_line_id
               and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0
                           union
               select lin.line_id
               from so_lines serv, so_lines lin
               where serv.service_parent_line_id = lin.line_id
               and nvl(serv.ordered_quantity,0) -
                         nvl(serv.cancelled_quantity,0) > 0
               and lin.parent_line_id = x_line_id;

Line: 706

               select line_id
               from SO_LINE_SERVICE_DETAILS
               where line_id = x_line_id
                           union
               select lin.line_id
               from SO_LINE_SERVICE_DETAILS isd, so_lines lin
               where isd.line_id = lin.line_id
               and lin.parent_line_id = x_line_id;

Line: 734

               select line_id
               from so_lines
               where service_parent_line_id = x_line_id
               and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0;

Line: 740

               select line_id
               from SO_LINE_SERVICE_DETAILS
               where line_id = x_line_id;

Line: 764

 SELECT NULL into L_Dummy
 FROM   SO_LINE_DETAILS
 WHERE  SCHEDULE_STATUS_CODE IS NOT NULL
 AND    LINE_ID IN
      (SELECT LINE_ID
       FROM   SO_LINES
       WHERE  HEADER_ID = P_Header_Id
       AND   (LINE_ID = P_Line_Id
              OR PARENT_LINE_ID = P_Line_Id))
       AND ROWNUM = 1;

Line: 785

	SELECT NULL into L_Dummy
	FROM   SO_LINES
	WHERE  HEADER_ID = P_Header_Id
	AND   (LINE_ID = P_Line_Id
        OR PARENT_LINE_ID = P_Line_Id)
	AND   (S2 NOT IN (8,18)
        OR S5 NOT IN (8,18)
        OR S8 NOT IN (8,18)
        OR S25 NOT IN (8,18)
        OR P_Config_Item_Exists = 'Y'
        OR OPEN_FLAG IS NULL)
	AND ROWNUM = 1;

Line: 818

PROCEDURE Update_Shippable_Flag
(
        P_ATO_Option_Parent_Line            IN  NUMBER,
        P_Return_Status                     OUT VARCHAR2
)

is

L_Dummy NUMBER;

Line: 832

 UPDATE SO_LINE_DETAILS
 SET SHIPPABLE_FLAG = 'N'
 WHERE LINE_ID IN (  SELECT  L.LINE_ID
                    FROM    SO_LINES L
                    WHERE  ( PARENT_LINE_ID = P_ATO_Option_Parent_Line
                            AND ATO_LINE_ID IS NOT NULL)
                    OR     ( PARENT_LINE_ID = P_ATO_Option_Parent_Line
                            AND ATO_LINE_ID IS NULL
                            AND ATO_FLAG = 'Y'
                            AND ITEM_TYPE_CODE = 'MODEL')
                 );

Line: 849

                                'OE_LIN.Update_Shippable_Flag',
                                Operation=>'',
                                Object=>'LINE',
                                Message=>' When Others');

Line: 855

end Update_Shippable_Flag;