{"id":786,"date":"2013-07-19T13:50:30","date_gmt":"2013-07-19T05:50:30","guid":{"rendered":"http:\/\/j178.mtgbb.com\/?p=786"},"modified":"2013-07-19T13:52:25","modified_gmt":"2013-07-19T05:52:25","slug":"ap-supplier-api","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=786","title":{"rendered":"AP Supplier API"},"content":{"rendered":"<p>\u8cc7\u6599\u4f86\u6e90: <a title=\"\u9019\u88e1\" href=\"http:\/\/www.oracleerp4u.com\/2010\/07\/r11i-vendor-load-thru-api.html\" target=\"_blank\">\u9019\u88e1<\/a><\/p>\n<pre lang=\"oracle8\">\r\nap_po_vendors_apis_pkg.insert_new_vendor(p_vendor_name                => v_vendor.vendor_name,\r\n                                         p_vendor_type_lookup_code    => l_lookup_code,\r\n                                         p_taxpayer_id                => NULL,\r\n                                         p_tax_registration_id        => NULL,\r\n                                         p_women_owned_flag           => NULL,\r\n                                         p_small_business_flag        => NULL,\r\n                                         p_minority_group_lookup_code => NULL,\r\n                                         p_supplier_number            => v_vendor.vendor_no,\r\n                                         x_vendor_id,\r\n                                         x_status,\r\n                                         x_exception_msg);\r\n\r\nap_po_vendors_apis_pkg.insert_new_vendor_site(p_vendor_site_code     => v_vendor_site.vendor_site_code,\r\n                                              p_vendor_id            => l_vendor_id,\r\n                                              p_org_id               => l_org_id,\r\n                                              p_address_line1        => v_vendor_site.address_line1,\r\n                                              p_address_line2        => v_vendor_site.address_line2,\r\n                                              p_address_line3        => v_vendor_site.address_line3,\r\n                                              p_address_line4        => v_vendor_site.address_line4,\r\n                                              p_city                 => v_vendor_site.city,\r\n                                              p_state                => v_vendor_site.state,\r\n                                              p_zip                  => v_vendor_site.zip,\r\n                                              p_province             => NULL,\r\n                                              p_county               => v_vendor_site.county,\r\n                                              p_country              => v_vendor_site.country,\r\n                                              p_area_code            => v_vendor_site.area_code,\r\n                                              p_phone                => v_vendor_site.phone,\r\n                                              p_fax_area_code        => v_vendor_site.fax_area_code,\r\n                                              p_fax                  => v_vendor_site.fax,\r\n                                              p_email_address        => NULL,\r\n                                              p_purchasing_site_flag => v_vendor_site.purchasing_site_flag,\r\n                                              p_pay_site_flag        => NULL,\r\n                                              p_rfq_only_site_flag   => NULL,\r\n                                              x_vendor_site_id,\r\n                                              x_status,\r\n                                              x_exception_msg);\r\n\r\nap_po_vendors_apis_pkg.insert_new_vendor_contact(p_vendor_site_id    => l_vendor_site_id,\r\n                                                 p_first_name        => v_vendor_site_contact.first_name,\r\n                                                 p_last_name         => v_vendor_site_contact.last_name,\r\n                                                 p_middle_name       => v_vendor_site_contact.middle_name,\r\n                                                 p_prefix            => v_vendor_site_contact.prefix,\r\n                                                 p_title             => v_vendor_site_contact.title,\r\n                                                 p_mail_stop         => v_vendor_site_contact.mail_stop,\r\n                                                 p_area_code         => v_vendor_site_contact.contact_area_code,\r\n                                                 p_phone             => v_vendor_site_contact.contact_phone,\r\n                                                 p_alt_area_code     => NULL,\r\n                                                 p_alt_phone         => NULL,\r\n                                                 p_fax_area_code     => NULL,\r\n                                                 p_fax               => NULL,\r\n                                                 p_email_address     => NULL,\r\n                                                 p_url               => NULL,\r\n                                                 x_vendor_contact_id,\r\n                                                 x_status,\r\n                                                 x_exception_msg);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8cc7\u6599\u4f86\u6e90: \u9019\u88e1 ap_po_vendors_apis_pkg.insert_new_vendor(p_ven &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[57],"class_list":["post-786","post","type-post","status-publish","format-standard","hentry","category-oracle-erp","tag-oracle-erp"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=786"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/786\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}