DECLARE
lv_vendor_site_rec AP_VENDOR_PUB_PKG.R_VENDOR_SITE_REC_TYPE;
lv_return_status VARCHAR2(10);
lv_msg_count NUMBER;
lv_msg_data VARCHAR2(1000);
lv_vendor_site_id NUMBER;
lv_party_site_id NUMBER;
lv_location_id NUMBER;
BEGIN
fnd_global.apps_initialize(user_id => 1318,resp_id => 50544,resp_appl_id => 200);
lv_vendor_site_rec.vendor_id :=42173;
lv_vendor_site_rec.org_id :=204;
lv_vendor_site_rec.address_line1 := 'FGDGHF';
lv_vendor_site_rec.country :='US';
lv_vendor_site_rec.vendor_site_code :='AMSITE';
--lv_vendor_site_rec.city := 'VIJ';
--lv_vendor_site_rec.state := 'AP';
--lv_vendor_site_rec.zip := 78965;
--lv_vendor_site_rec.country_of_origin_code :='US';
--lv_vendor_site_rec.country :='US';
--lv_vendor_site_rec.org_name :='Vision Operations'; -- operating unit name
AP_VENDOR_PUB_PKG .CREATE_VENDOR_SITE ( p_api_version => 1,
p_vendor_site_rec => lv_vendor_site_rec,
x_return_status => lv_return_status,
x_msg_count => lv_msg_count,
x_msg_data => lv_msg_data,
x_vendor_site_id => lv_vendor_site_id,
x_party_site_id => lv_party_site_id,
x_location_id => lv_location_id
);
COMMIT;
END;
Oracle Application and Cloud HCM
Tuesday, 20 December 2016
Steps to Create VendorsSites
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment