Wrong number or types of arguments in call to 'UPDATE_VENDOR_CONTACT_PUBLIC'
Database Version: Version 19.21.0.0.0; Release: 12.2.10
Greetings Good people. I'm encountering the error mentioned when attempting to invoke the ap_vendor_pub_pkg.update_vendor_contact_public API. Provided below is the relevant code. I would greatly appreciate your assistance with this matter.
SET SERVEROUTPUT ON;
DECLARE
p_vendor_id NUMBER := 8340;
p_contact_id NUMBER := 30042211;
p_contact_name VARCHAR2(100) := 'John Doe';
p_email VARCHAR2(100) := 'john.doe@example.com';
p_phone VARCHAR2(20) := '1234567890';
p_alt_phone VARCHAR2(20):='230002222';
p_fax VARCHAR2(20) := '1005';
p_vendor_site_id NUMBER := 6056375; -- Provide the vendor site ID
x_return_status VARCHAR2(1);
x_msg_count NUMBER;