APPS.PO_REQ_LINES_SV1 SQL Statements

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

Line: 58

       select so that if the buyer id is not valid and does not
       exist in po_buyers_val_v we we assign null */

      begin
        SELECT full_name
        INTO   x_buyer
        FROM   po_buyers_val_v
        WHERE  employee_id = x_buyer_id;

Line: 416

	SELECT nvl(max(line_num), 0)
	INTO   x_max_line_num
	FROM   po_requisition_lines
	WHERE  requisition_header_id = x_header_id;

Line: 433

  PROCEDURE NAME:	update_modified_by_agent_flag

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

PROCEDURE update_modified_by_agent_flag(x_req_line_id    IN  NUMBER,
					x_agent_id	 IN  NUMBER)
IS

x_progress  VARCHAR2(3) := NULL;

Line: 448

   UPDATE po_requisition_lines
   SET    modified_by_agent_flag = 'Y',
          reqs_in_pool_flag      = NULL,
 	  purchasing_agent_id    = x_agent_id,
	  last_update_date       = SYSDATE,
          last_updated_by        = FND_GLOBAL.USER_ID,
          last_update_login      = FND_GLOBAL.LOGIN_ID
   WHERE  requisition_line_id    = x_req_line_id;

Line: 461

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

Line: 464

END update_modified_by_agent_flag;

Line: 529

     SELECT primary_unit_of_measure
     INTO   x_primary_uom
     FROM   mtl_system_items
     WHERE  inventory_item_id = x_item_id
     AND    organization_id   = x_organization_id;