APPS.OE_INVOICE_UTIL SQL Statements

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

Line: 8

PROCEDURE Update_Interco_Invoiced_Flag
(   p_price_adjustment_id  IN  NUMBER
, x_return_status OUT NOCOPY VARCHAR2

) IS
l_Header_Adj_tbl              OE_Order_PUB.Header_Adj_Tbl_Type;

Line: 21

        oe_debug_pub.add(  'ENTERING UPDATE_INTERCO_INVOICED_FLAG' , 1 ) ;

Line: 33

    UPDATE OE_PRICE_ADJUSTMENTS
    SET    INTERCO_INVOICED_FLAG = 'Y'
	     , LOCK_CONTROL = LOCK_CONTROL + 1
    WHERE  PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line: 50

        oe_debug_pub.add(  'EXIT UPDATE_INTERCO_INVOICED_FLAG ( ) PROCEDURE' , 1 ) ;

Line: 59

                        ,   'Update_Interco_Invoiced_flag'
                        );

Line: 62

END Update_Interco_Invoiced_Flag;