首页 > 代码库 > 供应商导入

供应商导入

1. 接口表

接口表    数据表说明
ap_suppliers_intpo_vendors供应商
ap_supplier_sites_intpo_vendor_sites_all供应商地点
ap_sup_site_contact_intpo_vendor_contacts联系人
   

2. e.g

环境信息初始化

nd_global.apps_initialize(user_id => 4760, resp_id => 52050, resp_appl_id => 200);

供应商信息头表必输字段:供应商名称、供应商编号

ap_po_vendors_apis_pkg.insert_new_vendor(p_vendor_name                => ‘Supplier 0001‘,
                                                   p_taxpayer_id                 => NULL,
                                                   p_tax_registration_id        => NULL,
                                                   p_women_owned_flag       => ‘N‘,
                                                   p_small_business_flag        => ‘N‘,
                                                   p_minority_group_lookup_code => NULL,
                                                   p_supplier_number            => ‘V0001‘,
                                                   x_vendor_id                      => x_vendor_id,
                                                   x_status                           => x_status,
                                                   x_exception_msg               => x_exception_msg);

供应商地点表必输字段:地点编码、供应商id、ou组织id、默认国家、可采购标识、可付款标识、rfq_only_site_flag=“N”

ap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code     => ‘S0001‘,
                                                          p_vendor_id            => x_vendor_id,
                                                          p_org_id                => l_org_id,
                                                          p_address_line1        => ‘Address Line1‘,
                                                          p_address_line2        => ‘Address Line2‘,
                                                          p_address_line3        => ‘Address Line3‘,
                                                          p_address_line4        => ‘Address Line4‘,
                                                          p_city                       => NULL,
                                                          p_state                     => NULL,
                                                          p_zip                        => NULL,
                                                          p_province                 => NULL,
                                                          p_county                   => NULL,
                                                          p_country                  => ‘CN‘,
                                                          p_area_code              => NULL,
                                                          p_phone                    => NULL,
                                                          p_fax_area_code        => NULL,
                                                          p_fax                        => NULL,
                                                          p_email_address        => NULL,
                                                          p_purchasing_site_flag => ‘Y‘,
                                                          p_pay_site_flag          => ‘Y‘,
                                                          p_rfq_only_site_flag    => ‘N‘,
                                                          x_vendor_site_id        => x_vendor_site_id,
                                                          x_status                    => x_status,
                                                          x_exception_msg        => x_exception_msg);

供应商联系人必输字段:供应商地点id、联系人姓名

ap_po_vendors_apis_pkg.insert_new_vendor_contact(p_vendor_site_id    => x_vendor_site_id,
                                                             p_last_name         => ‘C001‘,
                                                             p_first_name        => NULL,
                                                             p_middle_name       => NULL,
                                                             p_prefix                => NULL,
                                                             p_title                   => NULL,
                                                             p_mail_stop           => NULL,
                                                             p_area_code          => NULL,
                                                             p_phone                => NULL,
                                                             x_vendor_contact_id => x_vendor_contact_id,
                                                             x_status                 => x_status,
                                                             x_exception_msg     => x_exception_msg);
  IF nvl(x_status, ‘F‘) <> ‘S‘ THEN
    dbms_output.put_line(‘Status ‘ || x_status);
    dbms_output.put_line(‘Message ‘ || x_exception_msg);
    ROLLBACK;
    RETURN;
  END IF;