1 PACKAGE CSP_SHIP_TO_ADDRESS_PVT AUTHID CURRENT_USER AS
2 /*$Header: cspvstas.pls 120.0 2005/05/25 11:24:00 appldev noship $*/
3 --Start of comments
4 --
5 -- API name : CSP_SHIP_TO_ADDRESS_PVT
6 -- Type : Private
7 -- Purpose : Add an inventory location.
8 -- Modify an inventory location.
9 -- Create site location, inventory location, party, party site, party site use, customer account,
10 -- customer profile, customer account site, customer account site use, location association
11 -- for a ship to address (customer address, engineer address, or a special ship to address).
12 -- It will create records in related tables so Order Entry can pick up the right ship to address and
13 -- customer at the later time.
14 -- Modification History
15 -- Person Date Comments
16 -- --------- ----------- ------------------------------------------
17 -- iouyang 01-May-2001 New
18 --
19
20
21 -- Create locations, party, party site, party site use, customer, customer account site,
22 -- customer account site use, ... OE can utilize these records later for Spares Orders.
23 -- All calls should go through ship_to_address_handler. It will create/modify inventory location
24 -- (ship to address) and create/modify customer profile, party site, site locationa, and site uses.
25
26 -- The address information passed in must be validated before passing in. It will not create
27 -- an inventory location if the address is not valid. Required fields are varied depends on
28 -- the country. The country field is used to check if there is a address passed in.
29
30 g_rs_cust_relation_id number;
31 g_inv_loc_id number;
32
33 PROCEDURE ship_to_address_handler
34 (p_task_assignment_id IN NUMBER
35 ,p_resource_type IN VARCHAR2
36 ,p_resource_id IN NUMBER
37 ,p_customer_id OUT NOCOPY NUMBER
38 ,p_location_id IN OUT NOCOPY NUMBER
39 ,p_style IN VARCHAR2
40 ,p_address_line_1 IN VARCHAR2
41 ,p_address_line_2 IN VARCHAR2
42 ,p_address_line_3 IN VARCHAR2
43 ,p_country IN VARCHAR2
44 ,p_postal_code IN VARCHAR2
45 ,p_region_1 IN VARCHAR2
46 ,p_region_2 IN VARCHAR2
47 ,p_region_3 IN VARCHAR2
48 ,p_town_or_city IN VARCHAR2
49 ,p_tax_name IN VARCHAR2
50 ,p_telephone_number_1 IN VARCHAR2
51 ,p_telephone_number_2 IN VARCHAR2
52 ,p_telephone_number_3 IN VARCHAR2
53 ,p_loc_information13 IN VARCHAR2
54 ,p_loc_information14 IN VARCHAR2
55 ,p_loc_information15 IN VARCHAR2
56 ,p_loc_information16 IN VARCHAR2
57 ,p_loc_information17 IN VARCHAR2
58 ,p_loc_information18 IN VARCHAR2
59 ,p_loc_information19 IN VARCHAR2
60 ,p_loc_information20 IN VARCHAR2
61 ,p_timezone IN VARCHAR2
62 ,p_primary_flag IN VARCHAR2
63 ,p_status IN VARCHAR2
64 ,p_object_version_number IN OUT NOCOPY NUMBER
65 ,p_api_version_number IN NUMBER
66 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
67 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
68 ,p_attribute_category IN VARCHAR2
69 ,p_attribute1 IN VARCHAR2
70 ,p_attribute2 IN VARCHAR2
71 ,p_attribute3 IN VARCHAR2
72 ,p_attribute4 IN VARCHAR2
73 ,p_attribute5 IN VARCHAR2
74 ,p_attribute6 IN VARCHAR2
75 ,p_attribute7 IN VARCHAR2
76 ,p_attribute8 IN VARCHAR2
77 ,p_attribute9 IN VARCHAR2
78 ,p_attribute10 IN VARCHAR2
79 ,p_attribute11 IN VARCHAR2
80 ,p_attribute12 IN VARCHAR2
81 ,p_attribute13 IN VARCHAR2
82 ,p_attribute14 IN VARCHAR2
83 ,p_attribute15 IN VARCHAR2
84 ,p_attribute16 IN VARCHAR2
85 ,p_attribute17 IN VARCHAR2
86 ,p_attribute18 IN VARCHAR2
87 ,p_attribute19 IN VARCHAR2
88 ,p_attribute20 IN VARCHAR2
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94
95 -- Create a new inventory location as a ship to address.
96 PROCEDURE do_create_ship_to_location
97 (p_location_id OUT NOCOPY NUMBER
98 ,p_style IN VARCHAR2
99 ,p_address_line_1 IN VARCHAR2
100 ,p_address_line_2 IN VARCHAR2
101 ,p_address_line_3 IN VARCHAR2
102 ,p_country IN VARCHAR2
103 ,p_postal_code IN VARCHAR2
104 ,p_region_1 IN VARCHAR2
105 ,p_region_2 IN VARCHAR2
106 ,p_region_3 IN VARCHAR2
107 ,p_town_or_city IN VARCHAR2
108 ,p_tax_name IN VARCHAR2
109 ,p_telephone_number_1 IN VARCHAR2
110 ,p_telephone_number_2 IN VARCHAR2
111 ,p_telephone_number_3 IN VARCHAR2
112 ,p_loc_information13 IN VARCHAR2
113 ,p_loc_information14 IN VARCHAR2
114 ,p_loc_information15 IN VARCHAR2
115 ,p_loc_information16 IN VARCHAR2
116 ,p_loc_information17 IN VARCHAR2
117 ,p_loc_information18 IN VARCHAR2
118 ,p_loc_information19 IN VARCHAR2
119 ,p_loc_information20 IN VARCHAR2
120 ,p_attribute_category IN VARCHAR2
121 ,p_attribute1 IN VARCHAR2
122 ,p_attribute2 IN VARCHAR2
123 ,p_attribute3 IN VARCHAR2
124 ,p_attribute4 IN VARCHAR2
125 ,p_attribute5 IN VARCHAR2
126 ,p_attribute6 IN VARCHAR2
127 ,p_attribute7 IN VARCHAR2
128 ,p_attribute8 IN VARCHAR2
129 ,p_attribute9 IN VARCHAR2
130 ,p_attribute10 IN VARCHAR2
131 ,p_attribute11 IN VARCHAR2
132 ,p_attribute12 IN VARCHAR2
133 ,p_attribute13 IN VARCHAR2
134 ,p_attribute14 IN VARCHAR2
135 ,p_attribute15 IN VARCHAR2
136 ,p_attribute16 IN VARCHAR2
137 ,p_attribute17 IN VARCHAR2
138 ,p_attribute18 IN VARCHAR2
139 ,p_attribute19 IN VARCHAR2
140 ,p_attribute20 IN VARCHAR2
141 ,p_object_version_number OUT NOCOPY NUMBER
142 ,x_return_status OUT NOCOPY VARCHAR2
143 ,x_msg_count OUT NOCOPY NUMBER
144 ,x_msg_data OUT NOCOPY VARCHAR2
145 );
146
147
148 -- Update an existing inventory location.
149 PROCEDURE do_update_ship_to_location
150 (p_location_id IN NUMBER
151 ,p_style IN VARCHAR2
152 ,p_address_line_1 IN VARCHAR2
153 ,p_address_line_2 IN VARCHAR2
154 ,p_address_line_3 IN VARCHAR2
155 ,p_country IN VARCHAR2
156 ,p_postal_code IN VARCHAR2
157 ,p_region_1 IN VARCHAR2
158 ,p_region_2 IN VARCHAR2
159 ,p_region_3 IN VARCHAR2
160 ,p_town_or_city IN VARCHAR2
161 ,p_tax_name IN VARCHAR2
162 ,p_telephone_number_1 IN VARCHAR2
163 ,p_telephone_number_2 IN VARCHAR2
164 ,p_telephone_number_3 IN VARCHAR2
165 ,p_loc_information13 IN VARCHAR2
166 ,p_loc_information14 IN VARCHAR2
167 ,p_loc_information15 IN VARCHAR2
168 ,p_loc_information16 IN VARCHAR2
169 ,p_loc_information17 IN VARCHAR2
170 ,p_loc_information18 IN VARCHAR2
171 ,p_loc_information19 IN VARCHAR2
172 ,p_loc_information20 IN VARCHAR2
173 ,p_attribute_category IN VARCHAR2
174 ,p_attribute1 IN VARCHAR2
175 ,p_attribute2 IN VARCHAR2
176 ,p_attribute3 IN VARCHAR2
177 ,p_attribute4 IN VARCHAR2
178 ,p_attribute5 IN VARCHAR2
179 ,p_attribute6 IN VARCHAR2
180 ,p_attribute7 IN VARCHAR2
181 ,p_attribute8 IN VARCHAR2
182 ,p_attribute9 IN VARCHAR2
183 ,p_attribute10 IN VARCHAR2
184 ,p_attribute11 IN VARCHAR2
185 ,p_attribute12 IN VARCHAR2
186 ,p_attribute13 IN VARCHAR2
187 ,p_attribute14 IN VARCHAR2
188 ,p_attribute15 IN VARCHAR2
189 ,p_attribute16 IN VARCHAR2
190 ,p_attribute17 IN VARCHAR2
191 ,p_attribute18 IN VARCHAR2
192 ,p_attribute19 IN VARCHAR2
193 ,p_attribute20 IN VARCHAR2
194 ,p_object_version_number IN OUT NOCOPY NUMBER
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 ,x_msg_data OUT NOCOPY VARCHAR2
198 );
199
200
201 -- Create rsource and customer relationship
202 PROCEDURE do_rs_cust_relations
203 (p_resource_type IN VARCHAR2
204 ,p_resource_id IN NUMBER
205 ,p_customer_id IN NUMBER
206 );
207
208
209
210 -- Create site use and link it to an inventory location.
211 PROCEDURE do_create_site_use
212 (p_customer_id IN NUMBER
213 ,p_party_id IN NUMBER
214 ,p_address_id IN NUMBER
215 ,p_location_id IN NUMBER
216 ,p_inv_location_id IN NUMBER
217 ,p_primary_flag IN VARCHAR2
218 ,p_status IN VARCHAR2
219 ,x_return_status OUT NOCOPY VARCHAR2
220 ,x_msg_count OUT NOCOPY NUMBER
221 ,x_msg_data OUT NOCOPY VARCHAR2
222 );
223
224
225 -- Update site use.
226 PROCEDURE do_update_site_use
227 (p_site_use_id IN NUMBER
228 ,p_primary_flag IN VARCHAR2
229 ,p_status IN VARCHAR2
230 ,p_customer_id IN NUMBER
231 ,p_inv_location_id IN NUMBER
232 ,x_return_status OUT NOCOPY VARCHAR2
233 ,x_msg_count OUT NOCOPY NUMBER
234 ,x_msg_data OUT NOCOPY VARCHAR2 );
235
236
237 -- This procedure will create a new inventory location and link the
238 -- site use id passed in to the new inventory location.
239 -- Before calling this proceudre, make sure the site_use is not linked to
240 -- any inventory location yet.
241 --
242 PROCEDURE site_to_invloc_linkage
243 (p_customer_id IN NUMBER
244 ,p_address_id IN NUMBER
245 ,p_site_use_id IN NUMBER
246 ,p_location_id OUT NOCOPY NUMBER
247 ,p_style IN VARCHAR2
248 ,p_address_line_1 IN VARCHAR2
249 ,p_address_line_2 IN VARCHAR2
250 ,p_address_line_3 IN VARCHAR2
251 ,p_country IN VARCHAR2
252 ,p_postal_code IN VARCHAR2
253 ,p_region_1 IN VARCHAR2
254 ,p_region_2 IN VARCHAR2
255 ,p_region_3 IN VARCHAR2
256 ,p_town_or_city IN VARCHAR2
257 ,p_tax_name IN VARCHAR2
258 ,p_telephone_number_1 IN VARCHAR2
259 ,p_telephone_number_2 IN VARCHAR2
260 ,p_telephone_number_3 IN VARCHAR2
261 ,p_loc_information13 IN VARCHAR2
262 ,p_loc_information14 IN VARCHAR2
263 ,p_loc_information15 IN VARCHAR2
264 ,p_loc_information16 IN VARCHAR2
265 ,p_loc_information17 IN VARCHAR2
266 ,p_loc_information18 IN VARCHAR2
267 ,p_loc_information19 IN VARCHAR2
268 ,p_loc_information20 IN VARCHAR2
269 ,p_api_version_number IN NUMBER
270 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271 ,p_attribute_category IN VARCHAR2
272 ,p_attribute1 IN VARCHAR2
273 ,p_attribute2 IN VARCHAR2
274 ,p_attribute3 IN VARCHAR2
275 ,p_attribute4 IN VARCHAR2
276 ,p_attribute5 IN VARCHAR2
277 ,p_attribute6 IN VARCHAR2
278 ,p_attribute7 IN VARCHAR2
279 ,p_attribute8 IN VARCHAR2
280 ,p_attribute9 IN VARCHAR2
281 ,p_attribute10 IN VARCHAR2
282 ,p_attribute11 IN VARCHAR2
283 ,p_attribute12 IN VARCHAR2
284 ,p_attribute13 IN VARCHAR2
285 ,p_attribute14 IN VARCHAR2
286 ,p_attribute15 IN VARCHAR2
287 ,p_attribute16 IN VARCHAR2
288 ,p_attribute17 IN VARCHAR2
289 ,p_attribute18 IN VARCHAR2
290 ,p_attribute19 IN VARCHAR2
291 ,p_attribute20 IN VARCHAR2
292 ,x_return_status OUT NOCOPY VARCHAR2
293 ,x_msg_count OUT NOCOPY NUMBER
294 ,x_msg_data OUT NOCOPY VARCHAR2
295 );
296 PROCEDURE call_internal_hook (
297 p_package_name IN VARCHAR2,
298 p_api_name IN VARCHAR2,
299 p_processing_type IN VARCHAR2,
300 x_return_status OUT NOCOPY VARCHAR2
301 );
302
303 PROCEDURE cust_inv_loc_link
304 ( p_api_version IN NUMBER
305 ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
306 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
307 ,px_location_id IN OUT NOCOPY NUMBER
308 ,p_party_site_id IN NUMBER
309 ,p_cust_account_id IN NUMBER
310 ,p_customer_id IN NUMBER
311 ,p_attribute_category IN VARCHAR2
312 ,p_attribute1 IN VARCHAR2
313 ,p_attribute2 IN VARCHAR2
314 ,p_attribute3 IN VARCHAR2
315 ,p_attribute4 IN VARCHAR2
316 ,p_attribute5 IN VARCHAR2
317 ,p_attribute6 IN VARCHAR2
318 ,p_attribute7 IN VARCHAR2
319 ,p_attribute8 IN VARCHAR2
320 ,p_attribute9 IN VARCHAR2
321 ,p_attribute10 IN VARCHAR2
322 ,p_attribute11 IN VARCHAR2
323 ,p_attribute12 IN VARCHAR2
324 ,p_attribute13 IN VARCHAR2
325 ,p_attribute14 IN VARCHAR2
326 ,p_attribute15 IN VARCHAR2
327 ,p_attribute16 IN VARCHAR2
328 ,p_attribute17 IN VARCHAR2
329 ,p_attribute18 IN VARCHAR2
330 ,p_attribute19 IN VARCHAR2
331 ,p_attribute20 IN VARCHAR2
332 ,x_return_status OUT NOCOPY VARCHAR2
333 ,x_msg_count OUT NOCOPY NUMBER
334 ,x_msg_data OUT NOCOPY VARCHAR2
335 );
336
337 END CSP_SHIP_TO_ADDRESS_PVT;