Tuesday 20 December 2016

Steps to Create VendorsSites

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;
                                    

No comments :