api to update vendor name in ap_suppliers

api to update vendor name in ap_suppliers

In this post , We will be discuss about the api to update vendor name in ap_suppliers. This is the standard API to update vendor name in ap_suppliers. We can mass update the vendor name in ap_suppliers table. Oracle has given the api to update any supplier information from ap_suppliers table. Here below is the detail about api to update vendor name in ap_suppliers.

api to update vendor name in ap_suppliers

PLSQL Script using api to update vendor name in ap_suppliers

DECLARE

v_vendor_id NUMBER;

v_msg_count NUMBER;

v_message_data VARCHAR2(4000);

v_return_status VARCHAR2(10);

v_vendor_rec AP_VENDOR_PUB_PKG.r_vendor_rec_type;

BEGIN

FND_GLOBAL.apps_initialize(3342,33222,400);

v_vendor_id:= 99999;

v_vendor_rec.vendor_name:='New Supplier Name';

AP_VENDOR_PUB_PKG.UPDATE_VENDOR

(p_api_version ='1.0',

p_init_msg_list =FND_API.G_TRUE ,

p_commit =FND_API.G_TRUE,

p_validation_level =FND_API.G_VALID_LEVEL_FULL,

x_return_status =v_return_status,

x_msg_count =v_msg_count,

x_msg_data =v_message_data,

p_vendor_rec =v_vendor_rec,

p_vendor_id =v_vendor_id

);

FOR I IN 1..l_msg_count

LOOP

v_message_data := SUBSTR(FND_MSG_PUB.GET(p_encoded='T'),1,255);

dbms_output.put_line(v_message_data);

END LOOP ;

end;

api to update vendor name in ap_suppliers