APPS.PO_REQ_DIST_SV1 SQL Statements

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

Line: 20

   SELECT count(distribution_id)
   INTO   x_num_of_dist
   FROM   po_req_distributions
   WHERE  requisition_line_id = x_requisition_line_id;

Line: 37

     SELECT code_combination_id
     INTO   x_code_combination_id
     FROM   po_req_distributions
     WHERE  requisition_line_id = x_requisition_line_id;

Line: 72

   SELECT count(distribution_id)
   INTO   x_num_of_dist
   FROM   po_req_distributions_all
   WHERE  requisition_line_id = x_requisition_line_id;

Line: 94

     SELECT code_combination_id
     INTO   x_code_combination_id
     FROM   po_req_distributions_all
     WHERE  requisition_line_id = x_requisition_line_id;

Line: 116

  PROCEDURE NAME:       update_dist_quantity()

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


PROCEDURE  update_dist_quantity(x_requisition_line_id NUMBER,
				x_line_quantity	      NUMBER)

IS

x_progress VARCHAR2(3) := NULL;

Line: 133

   SELECT count(distribution_id)
   INTO   x_num_of_dist
   FROM   po_req_distributions
   WHERE  requisition_line_id = x_requisition_line_id
   AND    NOT EXISTS (SELECT 'there are encumbered distributions'
                FROM   po_req_distributions prd2
                WHERE  prd2.requisition_line_id = x_requisition_line_id
                AND    ( nvl(prd2.encumbered_flag, 'N') <> 'N')
               );

Line: 160

     SELECT *
     INTO   Recinfo
     FROM   po_req_distributions
     WHERE  requisition_line_id = x_requisition_line_id
     FOR UPDATE OF req_line_quantity NOWAIT;

Line: 168

     UPDATE po_req_distributions prd
     SET    req_line_quantity = x_line_quantity
     WHERE  prd.requisition_line_id = x_requisition_line_id;

Line: 181

    po_message_s.sql_error('update_dist_quantity', x_progress, sqlcode);

Line: 184

END update_dist_quantity;