1 PACKAGE pos_supplier_address_pkg AUTHID CURRENT_USER AS
2 /* $Header: POSSAS.pls 120.4.12010000.3 2009/11/06 12:46:57 suyjoshi ship $ */
3
4 PROCEDURE create_supplier_address
5 (p_vendor_id IN NUMBER,
6 p_vendor_party_id IN NUMBER,
7 p_party_site_name IN VARCHAR2,
8 p_address_line1 IN VARCHAR2,
9 p_address_line2 IN VARCHAR2,
10 p_address_line3 IN VARCHAR2,
11 p_address_line4 IN VARCHAR2,
12 p_country IN VARCHAR2,
13 p_city IN VARCHAR2,
14 p_state IN VARCHAR2,
15 p_province IN VARCHAR2,
16 p_postal_code IN VARCHAR2,
17 p_county IN VARCHAR2,
18 p_rfq_flag IN VARCHAR2,
19 p_pur_flag IN VARCHAR2,
20 p_pay_flag IN VARCHAR2,
21 p_primary_pay_flag IN VARCHAR2,
22 p_phone_area_code IN VARCHAR2,
23 p_phone_number IN VARCHAR2,
24 p_phone_extension IN VARCHAR2,
25 p_fax_area_code IN VARCHAR2,
26 p_fax_number IN VARCHAR2,
27 p_email_address IN VARCHAR2,
28 x_return_status OUT nocopy VARCHAR2,
29 x_msg_count OUT nocopy NUMBER,
30 x_msg_data OUT nocopy VARCHAR2,
31 x_party_site_id OUT nocopy NUMBER
32 );
33
34 PROCEDURE update_supplier_address
35 (p_vendor_id IN NUMBER,
36 p_vendor_party_id IN NUMBER,
37 p_party_site_id IN NUMBER,
38 p_party_site_name IN VARCHAR2,
39 p_address_line1 IN VARCHAR2,
40 p_address_line2 IN VARCHAR2,
41 p_address_line3 IN VARCHAR2,
42 p_address_line4 IN VARCHAR2,
43 p_country IN VARCHAR2,
44 p_city IN VARCHAR2,
45 p_state IN VARCHAR2,
46 p_province IN VARCHAR2,
47 p_postal_code IN VARCHAR2,
48 p_county IN VARCHAR2,
49 p_rfq_flag IN VARCHAR2,
50 p_pur_flag IN VARCHAR2,
51 p_pay_flag IN VARCHAR2,
52 p_primary_pay_flag IN VARCHAR2,
53 p_phone_area_code IN VARCHAR2,
54 p_phone_number IN VARCHAR2,
55 p_phone_extension IN VARCHAR2,
56 p_fax_area_code IN VARCHAR2,
57 p_fax_number IN VARCHAR2,
58 p_email_address IN VARCHAR2,
59 x_return_status OUT nocopy VARCHAR2,
60 x_msg_count OUT nocopy NUMBER,
61 x_msg_data OUT nocopy VARCHAR2
62 );
63
64 PROCEDURE unassign_address_to_contact
65 (p_contact_party_id IN NUMBER,
66 p_org_party_site_id IN NUMBER,
67 p_vendor_id IN NUMBER,
68 x_return_status OUT nocopy VARCHAR2,
69 x_msg_count OUT nocopy NUMBER,
70 x_msg_data OUT nocopy VARCHAR2
71 );
72
73 -- code added for bug 8237063
74 /* updating address details to ap_supplier_contacts
75 when only the contact related data is changed and the
76 address assignments are not added or deleted */
77 PROCEDURE update_address_to_contact
78 (p_contact_party_id IN NUMBER,
79 p_org_party_site_id IN NUMBER,
80 p_vendor_id IN NUMBER,
81 x_return_status OUT nocopy VARCHAR2,
82 x_msg_count OUT nocopy NUMBER,
83 x_msg_data OUT nocopy VARCHAR2
84 );
85 -- code added for bug 8237063
86
87 PROCEDURE assign_address_to_contact
88 (p_contact_party_id IN NUMBER,
89 p_org_party_site_id IN NUMBER,
90 p_vendor_id IN NUMBER,
91 x_attribute_category IN VARCHAR2 default null,
92 x_attribute1 IN VARCHAR2 default null,
93 x_attribute2 IN VARCHAR2 default null,
94 x_attribute3 IN VARCHAR2 default null,
95 x_attribute4 IN VARCHAR2 default null,
96 x_attribute5 IN VARCHAR2 default null,
97 x_attribute6 IN VARCHAR2 default null,
98 x_attribute7 IN VARCHAR2 default null,
99 x_attribute8 IN VARCHAR2 default null,
100 x_attribute9 IN VARCHAR2 default null,
101 x_attribute10 IN VARCHAR2 default null,
102 x_attribute11 IN VARCHAR2 default null,
103 x_attribute12 IN VARCHAR2 default null,
104 x_attribute13 IN VARCHAR2 default null,
105 x_attribute14 IN VARCHAR2 default null,
106 x_attribute15 IN VARCHAR2 default null,
107 x_return_status OUT nocopy VARCHAR2,
108 x_msg_count OUT nocopy NUMBER,
109 x_msg_data OUT nocopy VARCHAR2
110 );
111
112 /* Bug 6599374 Start */
113
114 PROCEDURE update_address_assignment_dff
115 (x_contact_party_id IN NUMBER,
116 x_org_party_site_id IN NUMBER,
117 x_vendor_id IN NUMBER,
118 x_attribute_category IN VARCHAR2 default null,
119 x_attribute1 IN VARCHAR2 default null,
120 x_attribute2 IN VARCHAR2 default null,
121 x_attribute3 IN VARCHAR2 default null,
122 x_attribute4 IN VARCHAR2 default null,
123 x_attribute5 IN VARCHAR2 default null,
124 x_attribute6 IN VARCHAR2 default null,
125 x_attribute7 IN VARCHAR2 default null,
126 x_attribute8 IN VARCHAR2 default null,
127 x_attribute9 IN VARCHAR2 default null,
128 x_attribute10 IN VARCHAR2 default null,
129 x_attribute11 IN VARCHAR2 default null,
130 x_attribute12 IN VARCHAR2 default null,
131 x_attribute13 IN VARCHAR2 default null,
132 x_attribute14 IN VARCHAR2 default null,
133 x_attribute15 IN VARCHAR2 default null,
134 x_return_status OUT nocopy VARCHAR2,
135 x_msg_count OUT nocopy NUMBER,
136 x_msg_data OUT nocopy VARCHAR2
137 );
138
139 /* Bug 6599374 End */
140 -- This procedure is used by the new supplier UI in r12
141 -- to update details such as site use flags, phone,
142 -- fax, email, notes for a supplier address
143 PROCEDURE buyer_update_address_details
144 (p_party_site_id IN NUMBER,
145 p_rfqFlag IN VARCHAR2,
146 p_purFlag IN VARCHAR2,
147 p_payFlag IN VARCHAR2,
148 p_primaryPayFlag IN VARCHAR2,
149 p_note IN VARCHAR2,
150 p_phone_area_code IN VARCHAR2 DEFAULT NULL,
151 p_phone IN VARCHAR2 DEFAULT NULL,
152 p_phone_contact_id IN NUMBER DEFAULT NULL,
153 p_phone_obj_ver_num IN NUMBER DEFAULT NULL,
154 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
155 p_fax IN VARCHAR2 DEFAULT NULL,
156 p_fax_contact_id IN NUMBER DEFAULT NULL,
157 p_fax_obj_ver_num IN NUMBER DEFAULT NULL,
158 p_email IN VARCHAR2 DEFAULT NULL,
159 p_email_contact_id IN NUMBER DEFAULT NULL,
160 p_email_obj_ver_num IN NUMBER DEFAULT NULL,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 END pos_supplier_address_pkg;