首页 > 代码库 > 供应商导入
供应商导入
1. 接口表
接口表 | 数据表 | 说明 |
ap_suppliers_int | po_vendors | 供应商 |
ap_supplier_sites_int | po_vendor_sites_all | 供应商地点 |
ap_sup_site_contact_int | po_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;