APPS.PO_COPYDOC_S2 SQL Statements

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

Line: 48

  price_update_tolerance
  pay_on_code  --  Changed pay_on_code
  {start,end}_date
  note_to_{authorizer,  receiver}
  agent_id
  segment{1-5}
  {start, end}_date_active
  global_attribute{_category, 1-20}
  ******/

  /* FROM_HEADER_ID of a copied document contains the PO_HEADER_ID
     of the original document.  Otherwise it's null.  We only perform
     additional validation if this field is not null.
     do the following two lines first before anything is changed.
  */
     x_po_header_record.from_header_id        := x_po_header_record.po_header_id;

Line: 147

         SELECT pay_on_code
         INTO   tmp_pay_on_code
         FROM   po_vendor_sites_all
         WHERE  vendor_site_id = x_po_header_record.vendor_site_id;

Line: 188

  x_po_header_record.last_updated_by   := fnd_global.user_id;

Line: 189

  x_po_header_record.last_update_date  := SYSDATE;

Line: 190

  x_po_header_record.last_update_login := fnd_global.login_id;

Line: 197

  x_po_header_record.program_update_date    := NULL;

Line: 263

    SELECT po_headers_s.nextval
    INTO   x_po_header_record.po_header_id
    FROM   SYS.DUAL;

Line: 280

         po_copydoc_s6.insert_rfq_vendors(x_po_header_record.po_header_id,
                                         x_po_header_record.vendor_id,
                                         x_po_header_record.vendor_site_id,
                               	         x_po_header_record.vendor_contact_Id);