Update Supplier Contacts using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR_CONTACT_PUBLIC

Hi Team,

We are using the API AP_VENDOR_PUB_PKG.UPDATE_VENDOR_CONTACT_PUBLIC to Update the Supplier Contacts in our r12 Instance the version is R12.1.3.

Here we are facing an issue not with the API but with the Data as we are having a Driving Cursor on AP_SUPPLIER_CONTACTS table that will fetch the data based on the Vendor_Site_Id.

But for various records what we are finding that there is no records present in the AP_SUPPLIER_CONTACTS table bit those data are visible from Front End Application.

So now for such records our driving cursor is not able to return rows so kindly suggest what needs to be done here if we still wants to use the API AP_VENDOR_PUB_PKG.UPDATE_VENDOR_CONTACT_PUBLIC how can we tweak our driving cursor logic.