APPS.PO_LINES_SV2 SQL Statements

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

Line: 19

        SELECT nvl(max(line_num),0)
        INTO   X_max_line_num
        FROM   po_lines
        WHERE  po_header_id = X_po_header_id;

Line: 37

  PROCEDURE NAME:	update_line()
			Moved to PO_LINES_SV11
			ecso 3/19/97 for globalization

 ===========================================================================*/

/*RETROACTIVE FPI START */
Procedure retroactive_change(p_po_line_id IN number) IS
X_progress                VARCHAR2(3)  := '';

Line: 50

        update po_lines
        set retroactive_date = sysdate,
	    last_update_date = sysdate,
            last_updated_by = x_user_id
        where po_line_id = p_po_line_id;

Line: 96

  UPDATE po_line_locations
  SET    retroactive_date = SYSDATE,
         last_update_date = SYSDATE,
         last_updated_by = l_user_id
  WHERE  line_location_id = p_line_location_id;