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); |