1 PACKAGE POS_SUPP_CONTACT_PKG AS
2 /*$Header: POSCONTS.pls 120.5.12010000.2 2008/08/02 14:55:22 sthoppan ship $ */
3
4 PROCEDURE create_supplier_contact
5 (p_vendor_party_id IN NUMBER,
6 p_first_name IN VARCHAR2,
7 p_last_name IN VARCHAR2,
8 p_middle_name IN VARCHAR2 DEFAULT NULL,
9 p_contact_title IN VARCHAR2 DEFAULT NULL,
10 p_job_title IN VARCHAR2 DEFAULT NULL,
11 p_phone_area_code IN VARCHAR2 DEFAULT NULL,
12 p_phone_number IN VARCHAR2 DEFAULT NULL,
13 p_phone_extension IN VARCHAR2 DEFAULT NULL,
14 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
15 p_fax_number IN VARCHAR2 DEFAULT NULL,
16 p_email_address IN VARCHAR2 DEFAULT NULL,
17 p_inactive_date IN DATE DEFAULT NULL,
18 x_return_status OUT nocopy VARCHAR2,
19 x_msg_count OUT nocopy NUMBER,
20 x_msg_data OUT nocopy VARCHAR2,
21 x_person_party_id OUT nocopy NUMBER
22 );
23
24 /* As Part Of Bug 7027825 Added A New Parameter p_person_party_obversion_num */
25
26 PROCEDURE update_supplier_contact
27 (p_contact_party_id IN NUMBER,
28 p_vendor_party_id IN NUMBER,
29 p_first_name IN VARCHAR2 DEFAULT NULL,
30 p_last_name IN VARCHAR2 DEFAULT NULL,
31 p_middle_name IN VARCHAR2 DEFAULT NULL,
32 p_contact_title IN VARCHAR2 DEFAULT NULL,
33 p_job_title IN VARCHAR2 DEFAULT NULL,
34 p_phone_area_code IN VARCHAR2 DEFAULT NULL,
35 p_phone_number IN VARCHAR2 DEFAULT NULL,
36 p_phone_extension IN VARCHAR2 DEFAULT NULL,
37 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
38 p_fax_number IN VARCHAR2 DEFAULT NULL,
39 p_email_address IN VARCHAR2 DEFAULT NULL,
40 p_inactive_date IN DATE DEFAULT NULL,
41 --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
42 p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
43 p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
44 p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
45 p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
46 p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
47 p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
48 --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
49 p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
50 x_return_status OUT nocopy VARCHAR2,
51 x_msg_count OUT nocopy NUMBER,
52 x_msg_data OUT nocopy VARCHAR2
53 );
54
55 END POS_SUPP_CONTACT_PKG ;