How to update ap_supplier_sites_all.payment_method_lookup_code using ap_vendor_pub_pkg.update_vendor
I am writing a script and I need to update ap_supplier_sites_all.payment_method_lookup_code. The code related to this update is:
l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
l_vendor_site_rec.attribute5 := j.attribute5;
l_vendor_site_rec.vendor_site_id := j.vendor_site_id;
l_vendor_site_rec.last_update_date := j.last_update_date;
l_vendor_site_rec.last_updated_by := j.last_updated_by;
l_vendor_site_rec.payment_method_lookup_code := j.payment_method_lookup_code;
ap_vendor_pub_pkg.update_vendor_site_public(
p_api_version => 1.0,