APPS.PO_HEADERS_SV9 SQL Statements

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

Line: 83

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  quote_vendor_quote_number = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
            AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 92

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  vendor_order_num = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
            AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 116

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  quote_vendor_quote_number = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate));

Line: 124

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  vendor_order_num = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate));

Line: 179

      /* update the original catelog by changing the effective and expiration
         date */

      if x_temp2 = 0 then

      /* Bug#3165053 : When replacing a blanket through PDOI, check that
         no release with the release date greater than the start date
         of the new replaced blanket exists */

      SELECT po_header_id
      INTO   l_po_header_id
      FROM po_headers
      WHERE vendor_id = X_vendor_id
      AND DECODE(X_document_type_code, 'QUOTATION', quote_vendor_quote_number,
          'BLANKET' , vendor_order_num) = X_vendor_doc_num
      AND TRUNC(nvl(X_start_date, sysdate)) >=
          TRUNC(nvl(start_date, sysdate))
      AND TRUNC(nvl(X_end_date, sysdate)) <=
          TRUNC(nvl(end_date, sysdate));

Line: 202

         SELECT 'Y' INTO l_rel_exists
         FROM DUAL
         WHERE EXISTS(
           SELECT 'release exist after the expiration  date'
           FROM   po_releases
           WHERE  release_date > X_start_date
           AND    po_header_id = l_po_header_id);

Line: 241

          SELECT count(1)
          INTO l_po_exists_num
          FROM po_lines_all pl,
               po_headers_all ph
          WHERE pl.from_header_id = l_po_header_id
          AND ph.po_header_id = pl.po_header_id
          AND ph.creation_date >= X_start_date;

Line: 278

	      UPDATE po_headers
	        SET  start_date = nvl(start_date, X_start_date - 1),
	             end_date = X_start_date - 1,
	             last_updated_by = fnd_global.user_id,
	             last_update_date = sysdate
	       WHERE po_header_id = l_po_header_id;

Line: 291

      SELECT po_header_id
      INTO   l_po_header_id
      FROM po_headers
      WHERE vendor_id = X_vendor_id
      AND DECODE(X_document_type_code, 'QUOTATION', quote_vendor_quote_number,
          'BLANKET' , vendor_order_num) = X_vendor_doc_num
      AND TRUNC(nvl(X_start_date, sysdate)) >=
          TRUNC(nvl(start_date, sysdate))
      AND TRUNC(nvl(X_end_date, sysdate)) <=
          TRUNC(nvl(end_date, sysdate))
      AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 305

         SELECT 'Y' INTO l_rel_exists
         FROM DUAL
         WHERE EXISTS(
           SELECT 'release exist after the expiration  date'
           FROM   po_releases
           WHERE  release_date > X_start_date
           AND    po_header_id = l_po_header_id);

Line: 344

          SELECT count(1)
          INTO l_po_exists_num
          FROM po_lines_all pl,
               po_headers_all ph
          WHERE pl.from_header_id = l_po_header_id AND
                ph.po_header_id = pl.po_header_id AND
                ph.creation_date >= X_start_date;

Line: 381

	      UPDATE po_headers
	        SET  start_date = nvl(start_date, X_start_date - 1),
	             end_date = X_start_date - 1,
	             last_updated_by = fnd_global.user_id,
	             last_update_date = sysdate
	       WHERE po_header_id = l_po_header_id;

Line: 471

	    select count(1)
	    into x_temp
	    from po_headers
	    where vendor_id = x_vendor_id
	    and vendor_order_num = x_vendor_doc_num
	    and segment1 = x_document_num;

Line: 480

	    select count(1)
	    into x_temp
	    from po_headers
	    where vendor_id = x_vendor_id
	    and segment1 = x_document_num
	    and decode(x_document_type_code, 'QUOTATION', quote_vendor_quote_number,
	    	'BLANKET', vendor_order_num, NULL) = x_vendor_doc_num
	    AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
	    AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
	    AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 497

	    SELECT count(*)
	    INTO x_temp
	    FROM po_headers
	    WHERE vendor_id = X_vendor_id
	    AND  quote_vendor_quote_number = X_vendor_doc_num
	    AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
	    AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
	    AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 506

	    SELECT count(*)
	    INTO x_temp
	    FROM po_headers
	    WHERE vendor_id = X_vendor_id
	    AND  vendor_order_num = X_vendor_doc_num
	    AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
	    AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
	    AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 516

	    SELECT  count(*)
	    INTO  x_temp
	    FROM  po_headers
	    WHERE vendor_id = x_vendor_id
	    and vendor_order_num = x_vendor_doc_num ;

Line: 533

	    SELECT count(*)
	    INTO x_temp
	    FROM po_headers
	    WHERE vendor_id = X_vendor_id
	    AND  segment1 = x_document_num
	    AND type_lookup_code= x_document_type_code
	    AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
	    AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
	    AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 544

	    SELECT  count(*)
            INTO  x_temp
            FROM  po_headers
            WHERE vendor_id = x_vendor_id
            and   segment1 = x_document_num ;

Line: 694

         PO_DEBUG.put_line ('Valid catalog/blanket exists and can be updated');

Line: 702

      SELECT po_header_id
        INTO X_po_header_id
        FROM po_headers
       WHERE vendor_id = X_vendor_id
         AND decode(x_vendor_doc_num,null,segment1,(DECODE(X_document_type_code,
                    'QUOTATION', quote_vendor_quote_number,
                    'BLANKET' , vendor_order_num)))
             = decode(X_vendor_doc_num,null,x_document_num,X_vendor_doc_num) --cto changes FPH
         AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
         AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
         AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 733

    				p_mode => 'CHECK_UPDATEABLE',
    				x_po_status_rec => x_po_status_rec,
    				x_return_status  => x_return_status);

Line: 739

    		   SELECT  po_header_id,
			   consigned_consumption_flag
    	  	   INTO    x_po_header_id,
			   x_consigned_consumption_flag
    		   FROM    po_headers
      		   WHERE   vendor_order_num = x_vendor_doc_num;

Line: 748

    		   SELECT  po_header_id,
			   consigned_consumption_flag
                   INTO    x_po_header_id,
		           x_consigned_consumption_flag
    		   FROM    po_headers
    		   WHERE   segment1 = x_document_num ;

Line: 801

      update po_headers_interface
      set po_header_id = x_po_header_id
      where interface_header_id = X_interface_header_id;   /* nwang, need this */

Line: 852

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  quote_vendor_quote_number = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
            AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');

Line: 861

            SELECT count(*)
            INTO x_temp
            FROM po_headers
            WHERE vendor_id = X_vendor_id
            AND  vendor_order_num = X_vendor_doc_num
            AND TRUNC(nvl(X_start_date, sysdate)) >= TRUNC(nvl(start_date, sysdate))
            AND TRUNC(nvl(X_end_date, sysdate)) <= TRUNC(nvl(end_date, sysdate))
            AND nvl(closed_code, 'OPEN') not in ('FINALLY CLOSED', 'CANCELLED');