AP Supplier API

ap_po_vendors_apis_pkg.insert_new_vendor

(p_vendor_name => v_vendor.vendor_name,

p_vendor_type_lookup_code => l_lookup_code,

p_taxpayer_id => NULL,

p_tax_registration_id => NULL,

p_women_owned_flag => NULL,

p_small_business_flag => NULL,

p_minority_group_lookup_code => NULL,

p_supplier_number => v_vendor.vendor_no,

x_vendor_id,

x_status,

x_exception_msg);

ap_po_vendors_apis_pkg.insert_new_vendor_site

(p_vendor_site_code => v_vendor_site.vendor_site_code,

p_vendor_id => l_vendor_id,

p_org_id => l_org_id,

p_address_line1 => v_vendor_site.address_line1,

p_address_line2 => v_vendor_site.address_line2,

p_address_line3 => v_vendor_site.address_line3,

p_address_line4 => v_vendor_site.address_line4,

p_city => v_vendor_site.city,

p_state => v_vendor_site.state,

p_zip => v_vendor_site.zip,

p_province => NULL,

p_county => v_vendor_site.county,

p_country => v_vendor_site.country,

p_area_code => v_vendor_site.area_code,

p_phone => v_vendor_site.phone,

p_fax_area_code => v_vendor_site.fax_area_code,

p_fax => v_vendor_site.fax,

p_email_address => NULL,

p_purchasing_site_flag => v_vendor_site.purchasing_site_flag,

p_pay_site_flag => NULL,

p_rfq_only_site_flag => NULL,

x_vendor_site_id,

x_status,

x_exception_msg);

ap_po_vendors_apis_pkg.insert_new_vendor_contact

(p_vendor_site_id => l_vendor_site_id,

p_first_name => v_vendor_site_contact.FIRST_NAME,

p_last_name => v_vendor_site_contact.LAST_NAME,

p_middle_name => v_vendor_site_contact.MIDDLE_NAME,

p_prefix => v_vendor_site_contact.PREFIX,

p_title => v_vendor_site_contact.TITLE,

p_mail_stop => v_vendor_site_contact.MAIL_STOP,

p_area_code => v_vendor_site_contact.CONTACT_AREA_CODE,

p_phone => v_vendor_site_contact.CONTACT_PHONE,

p_alt_area_code => NULL,

p_alt_phone => NULL,

p_fax_area_code => NULL,

p_fax => NULL,

p_email_address => NULL,

p_url => NULL,

x_vendor_contact_id,

x_status,

x_exception_msg);

/