APPS.PO_LINE_LOCATIONS_PKG_S3 SQL Statements

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

Line: 33

  SELECT  1
  INTO    dummy
  FROM    DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_line_locations
		     WHERE  po_release_id = X_po_release_id
                     AND    shipment_type = X_shipment_type
                     AND    shipment_num  = X_shipment_num
		     AND    ((X_rowid is null) or
                             (X_rowid <> rowid)));

Line: 51

  SELECT  1
  INTO    dummy
  FROM    DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_line_locations
                     WHERE  po_line_id      = X_po_line_id
                     AND    shipment_type in ('STANDARD','PLANNED')
                     AND    shipment_num    = X_shipment_num
                     AND   ((X_rowid IS NULL)
                            OR (X_rowid <> rowid)));

Line: 68

  SELECT  1
  INTO    dummy
  FROM    DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_line_locations
                     WHERE  po_line_id      = X_po_line_id
                     AND    shipment_type   = X_shipment_type
                     AND    shipment_num    = X_shipment_num
                     AND   ((X_rowid IS NULL)
                            OR (X_rowid <> rowid)));

Line: 83

   SELECT  1
   INTO    dummy
   FROM    DUAL
   WHERE  not exists (SELECT 1
		      FROM   po_line_locations
                      WHERE  po_line_id      = X_po_line_id
                      AND    shipment_type   = 'PRICE BREAK'
                      AND    shipment_num    = X_shipment_num
                      AND   ((X_rowid          <> rowid)
                      OR     (X_rowid IS NULL)));

Line: 121

  SELECT  1
  INTO    dummy
  FROM    DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_line_locations
                     WHERE  po_line_id      = X_po_line_id
                     AND    shipment_type   = X_shipment_type
                     AND    shipment_num    = X_shipment_num);

Line: 160

           SELECT nvl(max(shipment_num),0)
           INTO   X_max_shipment_num
           FROM   po_line_locations
           WHERE  po_line_id   = X_po_line_id
           AND    shipment_type IN ('STANDARD','PLANNED');

Line: 167

           SELECT nvl(max(shipment_num),0)
           INTO   X_max_shipment_num
           FROM   po_line_locations
           WHERE  po_line_id    = X_po_line_id
           AND    shipment_type = X_shipment_type;

Line: 174

           SELECT nvl(max(shipment_num),0)
           INTO   X_max_shipment_num
           FROM   po_line_locations
           WHERE  po_line_id    = X_po_line_id
           AND    shipment_type = 'PRICE BREAK';

Line: 183

	   SELECT nvl(max(shipment_num),0)
           INTO   X_max_shipment_num
           FROM   po_line_locations
           WHERE  po_release_id   = X_po_release_id ;

Line: 200

**  PROCEDURE NAME : select_summary()
**=======================================================*/


 function   select_summary(X_po_release_id IN number)
             return number is

  X_rel_total  number;

Line: 219

         select nvl(sum((nvl(quantity,0)-nvl(quantity_cancelled,0))*nvl(price_override,0)),0)
         into   X_rel_total
         from   po_line_locations
         where  po_release_id = X_po_release_id;

Line: 232

end select_summary;