EBS Customizations (MOSC)

MOSC Banner

How to update ap_supplier_sites_all.payment_method_lookup_code using ap_vendor_pub_pkg.update_vendor

edited Jul 14, 2017 5:00AM in EBS Customizations (MOSC) 2 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center