Thursday 15 August 2013

Standard API for Supplier Contacts (R11 i)

declare
l_vendor_contact_id number;
l_first_name varchar2(30);
l_last_name varchar2(30);
l_status varchar2(3);
l_exception_msg varchar2(300);
l_middle_name varchar2(30);
l_prefix varchar2(30);
l_title varchar2(3);
l_mail_stop varchar2(3);
l_area_code varchar2(3);
l_phone varchar2(3);
begin
l_vendor_contact_id := 419926;
l_first_name := 'Anil';
l_last_name := 'Kumar';
AP_PO_VENDORS_APIS_PKG.update_vendor_contact
(
p_vendor_contact_id => l_vendor_contact_id,
p_first_name => l_first_name,
p_last_name => l_last_name,
p_middle_name => l_middle_name,
p_prefix => l_prefix ,
p_title => l_title,
p_mail_stop => l_mail_stop,
p_area_code => l_area_code,
p_phone => l_phone,
p_alt_area_code => NULL,
p_alt_phone => NULL,
p_fax_area_code => NULL,
p_fax => NULL,
p_email_address => 'anilmca02@gmail.com',
p_url => NULL,
x_status => l_status,
x_exception_msg => l_exception_msg
);
dbms_output.PUT_LINE('l_status is '||l_status);
commit;
end;

Using the same API we can update vendors,Sites also.

No comments:

Post a Comment