declare
lv_vendor_contact_rec AP_VENDOR_PUB_PKG.R_VENDOR_CONTACT_REC_TYPE;
lv_return_status VARCHAR2(10);
lv_msg_count NUMBER;
lv_msg_data VARCHAR2(1000);
lv_vendor_id NUMBER;
lv_party_id NUMBER;
lv_vendor_contact_id NUMBER;
lv_per_party_id NUMBER;
lv_rel_party_id NUMBER;
lv_rel_id NUMBER;
lv_org_contact_id NUMBER;
lv_party_site_id NUMBER;
BEGIN
fnd_global.apps_initialize(user_id => 1318,resp_id => 50544,resp_appl_id => 200);
lv_vendor_contact_rec.PERSON_FIRST_NAME := 'MADHU'; --First Name
lv_vendor_contact_rec.PERSON_LAST_NAME := 'DHARE'; --Last Name
lv_vendor_contact_rec.phone := '9739101196'; --Phone Number
--lv_vendor_contact_rec.email_address := cp_contact.contact_email ; --Email Address
--lv_vendor_contact_rec.fax_phone := cp_contact.contact_fax;
lv_vendor_contact_rec.org_id :=204;
lv_vendor_contact_rec.org_party_site_id :=222632;
AP_VENDOR_PUB_PKG.CREATE_VENDOR_CONTACT
( p_api_version => 1,
p_vendor_contact_rec => lv_vendor_contact_rec,
x_return_status => lv_return_status,
x_msg_count => lv_msg_count,
x_msg_data => lv_msg_data,
x_vendor_contact_id => lv_vendor_contact_id,
x_per_party_id => lv_per_party_id,
x_rel_party_id => lv_rel_party_id,
x_rel_id => lv_rel_id,
x_org_contact_id => lv_org_contact_id,
x_party_site_id => lv_party_site_id
);
END;
Oracle Application and Cloud HCM
Tuesday, 20 December 2016
Step Guide to Create Vendors Contact Details
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment