[Home] [Help]
PACKAGE: APPS.POS_HZ_CONTACT_POINT_PKG
Source
1 PACKAGE pos_hz_contact_point_pkg AUTHID CURRENT_USER AS
2 /*$Header: POSHZCPS.pls 120.4 2012/01/24 13:24:10 ramkandu ship $ */
3
4 -- update if exists, create otherwise
5 PROCEDURE update_party_phone
6 ( p_party_id IN NUMBER
7 , p_country_code IN VARCHAR2
8 , p_area_code IN VARCHAR2
9 , p_number IN VARCHAR2
10 , p_extension IN VARCHAR2
11 --Start Bug 6620664
12 , p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
13 --End Bug 6620664
14 , x_return_status OUT NOCOPY VARCHAR2
15 , x_msg_count OUT nocopy VARCHAR2
16 , x_msg_data OUT NOCOPY VARCHAR2
17 );
18
19 -- update if exists, create otherwise
20 PROCEDURE update_party_fax
21 ( p_party_id IN NUMBER
22 , p_country_code IN VARCHAR2
23 , p_area_code IN VARCHAR2
24 , p_number IN VARCHAR2
25 , p_extension IN VARCHAR2
26 --Start Bug 6620664
27 , p_fax_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
28 --End Bug 6620664
29 , x_return_status OUT NOCOPY VARCHAR2
30 , x_msg_count OUT nocopy VARCHAR2
31 , x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 -- update if exists, create otherwise
35 PROCEDURE update_party_email
36 ( p_party_id IN NUMBER
37 , p_email IN VARCHAR2
38 --Start Bug 6620664
39 , p_email_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
40 --End Bug 6620664
41 , x_return_status OUT NOCOPY VARCHAR2
42 , x_msg_count OUT nocopy VARCHAR2
43 , x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 -- update if exists, create otherwise
47 PROCEDURE update_party_site_phone
48 ( p_party_site_id IN NUMBER
49 , p_country_code IN VARCHAR2
50 , p_area_code IN VARCHAR2
51 , p_number IN VARCHAR2
52 , p_extension IN VARCHAR2
53 , x_return_status OUT NOCOPY VARCHAR2
54 , x_msg_count OUT nocopy VARCHAR2
55 , x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 -- update if exists, create otherwise
59 PROCEDURE update_party_site_fax
60 ( p_party_site_id IN NUMBER
61 , p_country_code IN VARCHAR2
62 , p_area_code IN VARCHAR2
63 , p_number IN VARCHAR2
64 , p_extension IN VARCHAR2
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT nocopy VARCHAR2
67 , x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 -- update if exists, create otherwise
71 PROCEDURE update_party_site_email
72 ( p_party_site_id IN NUMBER
73 , p_email IN VARCHAR2
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT nocopy VARCHAR2
76 , x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 /*Added methods update_party_alt_phone, update_party_url
80 for Bug 9316284*/
81 -- update if exists, create otherwise
82 PROCEDURE update_party_alt_phone
83 ( p_party_id IN NUMBER
84 , p_country_code IN VARCHAR2
85 , p_area_code IN VARCHAR2
86 , p_number IN VARCHAR2
87 , p_extension IN VARCHAR2
88 , p_phone_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
89 , x_return_status OUT NOCOPY VARCHAR2
90 , x_msg_count OUT nocopy VARCHAR2
91 , x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 -- update if exists, create otherwise
95 PROCEDURE update_party_url
96 ( p_party_id IN NUMBER
97 , p_url IN VARCHAR2
98 , p_url_object_version_number IN NUMBER DEFAULT fnd_api.G_NULL_NUM
99 , x_return_status OUT NOCOPY VARCHAR2
100 , x_msg_count OUT nocopy VARCHAR2
101 , x_msg_data OUT NOCOPY VARCHAR2
102 );
103 END pos_hz_contact_point_pkg;