1 PACKAGE POS_SUPP_CONTACT_PKG AUTHID CURRENT_USER AS
2 /*$Header: POSCONTS.pls 120.10 2011/11/19 11:35:10 ramkandu ship $ */
3 /* As Part Of Bug 7938942 Added A New Parameter p_person_party_obversion_num */
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 p_department IN VARCHAR2 DEFAULT NULL,
23 p_alt_contact_name IN VARCHAR2 DEFAULT NULL,
24 p_alt_area_code IN VARCHAR2 DEFAULT NULL,
25 p_alt_phone_number IN VARCHAR2 DEFAULT NULL,
26 p_url IN VARCHAR2 DEFAULT NULL
27 );
28
29 /* As Part Of Bug 7027825 Added A New Parameter p_person_party_obversion_num */
30 /* As Part Of Bug 7938942 Added A New Parameter p_person_party_obversion_num */
31 PROCEDURE update_supplier_contact
32 (p_contact_party_id IN NUMBER,
33 p_vendor_party_id IN NUMBER,
34 p_first_name IN VARCHAR2 DEFAULT NULL,
35 p_last_name IN VARCHAR2 DEFAULT NULL,
36 p_middle_name IN VARCHAR2 DEFAULT NULL,
37 p_contact_title IN VARCHAR2 DEFAULT NULL,
38 p_job_title IN VARCHAR2 DEFAULT NULL,
39 p_phone_area_code IN VARCHAR2 DEFAULT NULL,
40 p_phone_number IN VARCHAR2 DEFAULT NULL,
41 p_phone_extension IN VARCHAR2 DEFAULT NULL,
42 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
43 p_fax_number IN VARCHAR2 DEFAULT NULL,
44 p_email_address IN VARCHAR2 DEFAULT NULL,
45 p_inactive_date IN DATE DEFAULT NULL,
46 --Start Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
47 p_party_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
48 p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
49 p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
50 p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
51 p_rel_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
52 p_cont_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
53 --End Bug 6620664 - Handling Concurrent Updates on ContactDirectory, BusinessClassifications ans Accounting pages
54 p_person_party_obversion_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
55 x_return_status OUT nocopy VARCHAR2,
56 x_msg_count OUT nocopy NUMBER,
57 x_msg_data OUT nocopy VARCHAR2,
58 p_department IN VARCHAR2 DEFAULT NULL,
59 p_alt_contact_name IN VARCHAR2 DEFAULT NULL,
60 p_alt_area_code IN VARCHAR2 DEFAULT NULL,
61 p_alt_phone_number IN VARCHAR2 DEFAULT NULL,
62 p_url IN VARCHAR2 DEFAULT NULL,
63 p_url_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM,
64 p_altphone_obj_version_num IN NUMBER DEFAULT fnd_api.G_NULL_NUM
65 );
66
67 END POS_SUPP_CONTACT_PKG ;