APPS.PO_WFDS_PUB SQL Statements

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

Line: 44

   if (l_event_reason = 'DELETE') then
      return; /* we don't want to do anything in case of delete */

Line: 66

   select vendor_name
     into l_vendor_name
     from po_vendors
    where vendor_id = l_vendor_id;

Line: 71

   select language, fax, vendor_site_code,
          ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || CITY || ' ' || STATE || ' ' || ' ' || ZIP || ' ' || COUNTRY  site_address
     into l_language, l_fax, l_site_code, l_site_address
     from po_vendor_sites_all
    where vendor_site_id = l_vendor_site_id;

Line: 85

   wf_event.AddParameterToList(p_name =>'UPDATEONLY',  p_value =>'TRUE', p_parameterlist=>l_parameter_list);

Line: 93

   l_parameter_list.DELETE;

Line: 107

   wf_event.AddParameterToList(p_name =>'UPDATEONLY', p_value =>'TRUE', p_parameterlist => l_parameter_list);

Line: 115

   l_parameter_list.DELETE;

Line: 122

         l_parameter_list.DELETE;