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