1 PACKAGE oe_oe_inline_address AS
2 /* $Header: OEXFINLS.pls 120.0.12010000.1 2008/07/25 07:48:13 appldev ship $ */
3
4 FUNCTION find_lookup_meaning(in_lookup_type in varchar2,
5 in_lookup_code in varchar2
6 ) return varchar2;
7 PROCEDURE Create_contact
8 ( p_contact_last_name in varchar2,
9 p_contact_first_name in varchar2,
10 p_contact_title in varchar2,
11 p_email in varchar2,
12 p_area_code in varchar2,
13 p_phone_number in varchar2,
14 p_extension in varchar2,
15 p_acct_id in number,
16 p_party_id in number,
17 x_return_status OUT NOCOPY VARCHAR2,
18
19 x_msg_count OUT NOCOPY NUMBER,
20
21 x_msg_data OUT NOCOPY VARCHAR2,
22
23 x_contact_id out nocopy number,
24
25 x_contact_name out nocopy varchar2,
26
27 c_Attribute_Category IN VARCHAR2,
28 c_Attribute1 IN VARCHAR2,
29 c_Attribute2 IN VARCHAR2,
30 c_Attribute3 IN VARCHAR2,
31 c_Attribute4 IN VARCHAR2,
32 c_Attribute5 IN VARCHAR2,
33 c_Attribute6 IN VARCHAR2,
34 c_Attribute7 IN VARCHAR2,
35 c_Attribute8 IN VARCHAR2,
36 c_Attribute9 IN VARCHAR2,
37 c_Attribute10 IN VARCHAR2,
38 c_Attribute11 IN VARCHAR2,
39 c_Attribute12 IN VARCHAR2,
40 c_Attribute13 IN VARCHAR2,
41 c_Attribute14 IN VARCHAR2,
42 c_Attribute15 IN VARCHAR2,
43 c_Attribute16 IN VARCHAR2,
44 c_Attribute17 IN VARCHAR2,
45 c_Attribute18 IN VARCHAR2,
46 c_Attribute19 IN VARCHAR2,
47 c_Attribute20 IN VARCHAR2,
48 c_Attribute21 IN VARCHAR2,
49 c_Attribute22 IN VARCHAR2,
50 c_Attribute23 IN VARCHAR2,
51 c_Attribute24 IN VARCHAR2,
52 c_Attribute25 IN VARCHAR2,
53 c2_Attribute_Category IN VARCHAR2,
54 c2_Attribute1 IN VARCHAR2,
55 c2_Attribute2 IN VARCHAR2,
56 c2_Attribute3 IN VARCHAR2,
57 c2_Attribute4 IN VARCHAR2,
58 c2_Attribute5 IN VARCHAR2,
59 c2_Attribute6 IN VARCHAR2,
60 c2_Attribute7 IN VARCHAR2,
61 c2_Attribute8 IN VARCHAR2,
62 c2_Attribute9 IN VARCHAR2,
63 c2_Attribute10 IN VARCHAR2,
64 c2_Attribute11 IN VARCHAR2,
65 c2_Attribute12 IN VARCHAR2,
66 c2_Attribute13 IN VARCHAR2,
67 c2_Attribute14 IN VARCHAR2,
68 c2_Attribute15 IN VARCHAR2,
69 c2_Attribute16 IN VARCHAR2,
70 c2_Attribute17 IN VARCHAR2,
71 c2_Attribute18 IN VARCHAR2,
72 c2_Attribute19 IN VARCHAR2,
73 c2_Attribute20 IN VARCHAR2,
74 in_phone_country_Code in varchar2 default null
75 );
76
77
78 PROCEDURE Create_acct_contact
79 (
80 p_acct_id in number,
81 p_contact_party_id in number,
82 x_return_status OUT NOCOPY VARCHAR2,
83
84 x_msg_count OUT NOCOPY NUMBER,
85
86 x_msg_data OUT NOCOPY VARCHAR2,
87
88 x_contact_id out nocopy number,
89
90 c_Attribute_Category IN VARCHAR2,
91 c_Attribute1 IN VARCHAR2,
92 c_Attribute2 IN VARCHAR2,
93 c_Attribute3 IN VARCHAR2,
94 c_Attribute4 IN VARCHAR2,
95 c_Attribute5 IN VARCHAR2,
96 c_Attribute6 IN VARCHAR2,
97 c_Attribute7 IN VARCHAR2,
98 c_Attribute8 IN VARCHAR2,
99 c_Attribute9 IN VARCHAR2,
100 c_Attribute10 IN VARCHAR2,
101 c_Attribute11 IN VARCHAR2,
102 c_Attribute12 IN VARCHAR2,
103 c_Attribute13 IN VARCHAR2,
104 c_Attribute14 IN VARCHAR2,
105 c_Attribute15 IN VARCHAR2,
106 c_Attribute16 IN VARCHAR2,
107 c_Attribute17 IN VARCHAR2,
108 c_Attribute18 IN VARCHAR2,
109 c_Attribute19 IN VARCHAR2,
110 c_Attribute20 IN VARCHAR2,
111 c_Attribute21 IN VARCHAR2,
112 c_Attribute22 IN VARCHAR2,
113 c_Attribute23 IN VARCHAR2,
114 c_Attribute24 IN VARCHAR2,
115 c_Attribute25 IN VARCHAR2,
116 c2_Attribute_Category IN VARCHAR2,
117 c2_Attribute1 IN VARCHAR2,
118 c2_Attribute2 IN VARCHAR2,
119 c2_Attribute3 IN VARCHAR2,
120 c2_Attribute4 IN VARCHAR2,
121 c2_Attribute5 IN VARCHAR2,
122 c2_Attribute6 IN VARCHAR2,
123 c2_Attribute7 IN VARCHAR2,
124 c2_Attribute8 IN VARCHAR2,
125 c2_Attribute9 IN VARCHAR2,
126 c2_Attribute10 IN VARCHAR2,
127 c2_Attribute11 IN VARCHAR2,
128 c2_Attribute12 IN VARCHAR2,
129 c2_Attribute13 IN VARCHAR2,
130 c2_Attribute14 IN VARCHAR2,
131 c2_Attribute15 IN VARCHAR2,
132 c2_Attribute16 IN VARCHAR2,
133 c2_Attribute17 IN VARCHAR2,
134 c2_Attribute18 IN VARCHAR2,
135 c2_Attribute19 IN VARCHAR2,
136 c2_Attribute20 IN VARCHAR2,
137 in_created_by_module in varchar2 default null
138 );
139
140 PROCEDURE create_contact_point(
141 in_contact_point_type in varchar2,
142 in_owner_table_id in number,
143 in_email in varchar2,
144 in_phone_area_code in varchar2,
145 in_phone_number in varchar2,
146 in_phone_extension in varchar2,
147 x_return_status OUT NOCOPY VARCHAR2,
148
149 x_msg_count OUT NOCOPY NUMBER,
150
151 x_msg_data OUT NOCOPY VARCHAR2,
152
153 c_Attribute_Category IN VARCHAR2 default null,
154 c_Attribute1 IN VARCHAR2 default null,
155 c_Attribute2 IN VARCHAR2 default null,
156 c_Attribute3 IN VARCHAR2 default null,
157 c_Attribute4 IN VARCHAR2 default null,
158 c_Attribute5 IN VARCHAR2 default null,
159 c_Attribute6 IN VARCHAR2 default null,
160 c_Attribute7 IN VARCHAR2 default null,
161 c_Attribute8 IN VARCHAR2 default null,
162 c_Attribute9 IN VARCHAR2 default null,
163 c_Attribute10 IN VARCHAR2 default null,
164 c_Attribute11 IN VARCHAR2 default null,
165 c_Attribute12 IN VARCHAR2 default null,
166 c_Attribute13 IN VARCHAR2 default null,
167 c_Attribute14 IN VARCHAR2 default null,
168 c_Attribute15 IN VARCHAR2 default null,
169 c_Attribute16 IN VARCHAR2 default null,
170 c_Attribute17 IN VARCHAR2 default null,
171 c_Attribute18 IN VARCHAR2 default null,
172 c_Attribute19 IN VARCHAR2 default null,
173 c_Attribute20 IN VARCHAR2 default null,
174 in_phone_country_Code in varchar2 default null
175 );
176
177
178
179 PROCEDURE Create_Location
180 (
181 p_country IN Varchar2,
182 p_address1 IN Varchar2,
183 p_address2 IN Varchar2,
184 p_address3 IN Varchar2,
185 p_address4 IN Varchar2,
186 p_city IN Varchar2,
187 p_postal_code IN Varchar2,
188 p_state IN Varchar2,
189 p_province IN varchar2,
190 p_county IN Varchar2,
191 p_address_style IN Varchar2,
192 p_address_line_phonetic IN Varchar2,
193 c_Attribute_Category IN VARCHAR2,
194 c_Attribute1 IN VARCHAR2,
195 c_Attribute2 IN VARCHAR2,
196 c_Attribute3 IN VARCHAR2,
197 c_Attribute4 IN VARCHAR2,
198 c_Attribute5 IN VARCHAR2,
199 c_Attribute6 IN VARCHAR2,
200 c_Attribute7 IN VARCHAR2,
201 c_Attribute8 IN VARCHAR2,
202 c_Attribute9 IN VARCHAR2,
203 c_Attribute10 IN VARCHAR2,
204 c_Attribute11 IN VARCHAR2,
205 c_Attribute12 IN VARCHAR2,
206 c_Attribute13 IN VARCHAR2,
207 c_Attribute14 IN VARCHAR2,
208 c_Attribute15 IN VARCHAR2,
209 c_Attribute16 IN VARCHAR2,
210 c_Attribute17 IN VARCHAR2,
211 c_Attribute18 IN VARCHAR2,
212 c_Attribute19 IN VARCHAR2,
213 c_Attribute20 IN VARCHAR2,
214 c_global_Attribute_Category IN VARCHAR2,
215 c_global_Attribute1 IN VARCHAR2,
216 c_global_Attribute2 IN VARCHAR2,
217 c_global_Attribute3 IN VARCHAR2,
218 c_global_Attribute4 IN VARCHAR2,
219 c_global_Attribute5 IN VARCHAR2,
220 c_global_Attribute6 IN VARCHAR2,
221 c_global_Attribute7 IN VARCHAR2,
222 c_global_Attribute8 IN VARCHAR2,
223 c_global_Attribute9 IN VARCHAR2,
224 c_global_Attribute10 IN VARCHAR2,
225 c_global_Attribute11 IN VARCHAR2,
226 c_global_Attribute12 IN VARCHAR2,
227 c_global_Attribute13 IN VARCHAR2,
228 c_global_Attribute14 IN VARCHAR2,
229 c_global_Attribute15 IN VARCHAR2,
230 c_global_Attribute16 IN VARCHAR2,
231 c_global_Attribute17 IN VARCHAR2,
232 c_global_Attribute18 IN VARCHAR2,
233 c_global_Attribute19 IN VARCHAR2,
234 c_global_Attribute20 IN VARCHAR2,
235 x_location_id OUT NOCOPY NUMBER,
236
237 x_return_status OUT NOCOPY VARCHAR2,
238
239 x_msg_count OUT NOCOPY NUMBER,
240
241 x_msg_data OUT NOCOPY VARCHAR2
242
243
244 );
245
246 PROCEDURE Create_Party_Site
247 (
248 p_party_id IN Number,
249 p_location_id IN Number,
250 p_party_site_number IN VARCHAR2,
251 x_party_site_id OUT NOCOPY NUMBER,
252
253 x_party_site_number OUT NOCOPY VARCHAR2,
254
255 x_return_status OUT NOCOPY VARCHAR2,
256
257 x_msg_count OUT NOCOPY NUMBER,
258
259 x_msg_data OUT NOCOPY VARCHAR2
260
261 );
262
263 PROCEDURE Create_Account_Site
264 (
265 p_cust_account_id IN NUMBER,
266 p_party_site_id IN NUMBER,
267 c_Attribute_Category IN VARCHAR2,
268 c_Attribute1 IN VARCHAR2,
269 c_Attribute2 IN VARCHAR2,
270 c_Attribute3 IN VARCHAR2,
271 c_Attribute4 IN VARCHAR2,
272 c_Attribute5 IN VARCHAR2,
273 c_Attribute6 IN VARCHAR2,
274 c_Attribute7 IN VARCHAR2,
275 c_Attribute8 IN VARCHAR2,
276 c_Attribute9 IN VARCHAR2,
277 c_Attribute10 IN VARCHAR2,
278 c_Attribute11 IN VARCHAR2,
279 c_Attribute12 IN VARCHAR2,
280 c_Attribute13 IN VARCHAR2,
281 c_Attribute14 IN VARCHAR2,
282 c_Attribute15 IN VARCHAR2,
283 c_Attribute16 IN VARCHAR2,
284 c_Attribute17 IN VARCHAR2,
285 c_Attribute18 IN VARCHAR2,
286 c_Attribute19 IN VARCHAR2,
287 c_Attribute20 IN VARCHAR2,
288 x_customer_site_id OUT NOCOPY NUMBER,
289
290 x_return_status OUT NOCOPY VARCHAR2,
291
292 x_msg_count OUT NOCOPY NUMBER,
293
294 x_msg_data OUT NOCOPY VARCHAR2,
295
296 in_created_by_module in varchar2 default null
297 );
298
299
300 PROCEDURE Create_Acct_Site_Uses
301 (
302 p_cust_acct_site_id IN NUMBER,
303 p_location IN Varchar2,
304 p_site_use_code IN Varchar2,
305 x_site_use_id OUT NOCOPY NUMBER,
306
307 x_return_status OUT NOCOPY VARCHAR2,
308
309 x_msg_count OUT NOCOPY NUMBER,
310
311 x_msg_data OUT NOCOPY VARCHAR2,
312
313 c_Attribute_Category IN VARCHAR2,
314 c_Attribute1 IN VARCHAR2,
315 c_Attribute2 IN VARCHAR2,
316 c_Attribute3 IN VARCHAR2,
317 c_Attribute4 IN VARCHAR2,
318 c_Attribute5 IN VARCHAR2,
319 c_Attribute6 IN VARCHAR2,
320 c_Attribute7 IN VARCHAR2,
321 c_Attribute8 IN VARCHAR2,
322 c_Attribute9 IN VARCHAR2,
323 c_Attribute10 IN VARCHAR2,
324 c_Attribute11 IN VARCHAR2,
325 c_Attribute12 IN VARCHAR2,
326 c_Attribute13 IN VARCHAR2,
327 c_Attribute14 IN VARCHAR2,
328 c_Attribute15 IN VARCHAR2,
329 c_Attribute16 IN VARCHAR2,
330 c_Attribute17 IN VARCHAR2,
331 c_Attribute18 IN VARCHAR2,
335 c_Attribute22 IN VARCHAR2,
332 c_Attribute19 IN VARCHAR2,
333 c_Attribute20 IN VARCHAR2,
334 c_Attribute21 IN VARCHAR2,
336 c_Attribute23 IN VARCHAR2,
337 c_Attribute24 IN VARCHAR2,
338 c_Attribute25 IN VARCHAR2,
339 in_created_by_module in varchar2 default null,
340 in_primary_flag in varchar2 default null
341 );
342
343 PROCEDURE Create_Account
344 (
345 p_party_number IN Varchar2,
346 p_organization_name IN Varchar2,
347 p_alternate_name IN Varchar2,
348 p_tax_reference IN Varchar2,
349 p_taxpayer_id IN Varchar2,
350 p_party_id IN Number,
351 p_first_name IN Varchar2,
352 p_last_name IN Varchar2,
353 p_middle_name IN Varchar2,
354 p_name_suffix IN Varchar2,
355 p_title IN Varchar2,
356 p_party_type IN Varchar2,
357 p_email IN Varchar2,
358 c_Attribute_Category IN VARCHAR2,
359 c_Attribute1 IN VARCHAR2,
360 c_Attribute2 IN VARCHAR2,
361 c_Attribute3 IN VARCHAR2,
362 c_Attribute4 IN VARCHAR2,
363 c_Attribute5 IN VARCHAR2,
364 c_Attribute6 IN VARCHAR2,
365 c_Attribute7 IN VARCHAR2,
366 c_Attribute8 IN VARCHAR2,
367 c_Attribute9 IN VARCHAR2,
368 c_Attribute10 IN VARCHAR2,
369 c_Attribute11 IN VARCHAR2,
370 c_Attribute12 IN VARCHAR2,
371 c_Attribute13 IN VARCHAR2,
372 c_Attribute14 IN VARCHAR2,
373 c_Attribute15 IN VARCHAR2,
374 c_Attribute16 IN VARCHAR2,
375 c_Attribute17 IN VARCHAR2,
376 c_Attribute18 IN VARCHAR2,
377 c_Attribute19 IN VARCHAR2,
378 c_Attribute20 IN VARCHAR2,
379 c_global_Attribute_Category IN VARCHAR2,
380 c_global_Attribute1 IN VARCHAR2,
381 c_global_Attribute2 IN VARCHAR2,
382 c_global_Attribute3 IN VARCHAR2,
383 c_global_Attribute4 IN VARCHAR2,
384 c_global_Attribute5 IN VARCHAR2,
385 c_global_Attribute6 IN VARCHAR2,
386 c_global_Attribute7 IN VARCHAR2,
387 c_global_Attribute8 IN VARCHAR2,
388 c_global_Attribute9 IN VARCHAR2,
389 c_global_Attribute10 IN VARCHAR2,
390 c_global_Attribute11 IN VARCHAR2,
391 c_global_Attribute12 IN VARCHAR2,
392 c_global_Attribute13 IN VARCHAR2,
393 c_global_Attribute14 IN VARCHAR2,
394 c_global_Attribute15 IN VARCHAR2,
395 c_global_Attribute16 IN VARCHAR2,
396 c_global_Attribute17 IN VARCHAR2,
397 c_global_Attribute18 IN VARCHAR2,
398 c_global_Attribute19 IN VARCHAR2,
399 c_global_Attribute20 IN VARCHAR2,
400 x_party_id OUT NOCOPY Number,
401
402 x_party_number OUT NOCOPY Varchar2,
403
404 x_cust_Account_id OUT NOCOPY NUMBER,
405
406 x_cust_account_number IN OUT NOCOPY /* file.sql.39 change */ varchar2,
407 x_return_status OUT NOCOPY VARCHAR2,
408
409 x_msg_count OUT NOCOPY NUMBER,
410
411 x_msg_data OUT NOCOPY VARCHAR2,
412
413 in_created_by_module in varchar2 default null
414 );
415
416
417 PROCEDURE Create_Party_relationship(
418 p_object_party_id IN Number,
419 p_subject_party_id IN Number,
420 p_reciprocal_flag IN Varchar2,
421 x_party_relationship_id OUT NOCOPY Number,
422
423 x_return_status OUT NOCOPY VARCHAR2,
424
425 x_msg_count OUT NOCOPY NUMBER,
426
427 x_msg_data OUT NOCOPY VARCHAR2
428
429 );
430
431 PROCEDURE Create_Cust_relationship(
432 p_cust_acct_id IN Number,
433 p_related_cust_acct_id IN Number,
434 p_reciprocal_flag IN Varchar2,
435 x_return_status OUT NOCOPY VARCHAR2,
436
437 x_msg_count OUT NOCOPY NUMBER,
438
439 x_msg_data OUT NOCOPY VARCHAR2
440
444
441 );
442
443 PROCEDURE Commit_Changes;
445 PROCEDURE Rollback_Changes;
446
447 PROCEDURE Create_Person
448 (
449 p_first_name IN NUMBER,
450 p_party_number IN OUT NOCOPY /* file.sql.39 change */ Varchar2,
451 x_party_id OUT NOCOPY NUMBER,
452
453 x_profile_id OUT NOCOPY NUMBER,
454
455 x_return_status OUT NOCOPY VARCHAR2,
456
457 x_msg_count OUT NOCOPY NUMBER,
458
459 x_msg_data OUT NOCOPY VARCHAR2
460
461 );
462
463 PROCEDURE Create_Organization
464 (
465 p_organization_name IN NUMBER,
466 p_party_number IN OUT NOCOPY /* file.sql.39 change */ Varchar2,
467 x_party_id OUT NOCOPY NUMBER,
468
469 x_profile_id OUT NOCOPY NUMBER,
470
471 x_return_status OUT NOCOPY VARCHAR2,
472
473 x_msg_count OUT NOCOPY NUMBER,
474
475 x_msg_data OUT NOCOPY VARCHAR2
476
477 );
478
479
480 PROCEDURE Create_role_resp
481 (
482 p_cust_acct_role_id IN NUMBER,
483 p_usage_type IN VARCHAR2,
484 x_return_status OUT NOCOPY VARCHAR2,
485
486 x_msg_count OUT NOCOPY NUMBER,
487
488 x_msg_data OUT NOCOPY VARCHAR2,
489
490 x_responsibility_id OUT NOCOPY NUMBER
491
492 );
493
494
495 PROCEDURE add_customer_startup(
496 out_auto_site_numbering out NOCOPY /* file.sql.39 change */ varchar2,
497 out_auto_location_numbering out NOCOPY /* file.sql.39 change */ varchar2,
498 out_auto_cust_numbering out NOCOPY /* file.sql.39 change */ varchar2,
499 out_email_required out NOCOPY /* file.sql.39 change */ varchar2,
500 out_auto_party_numbering out NOCOPY /* file.sql.39 change */ varchar2,
501 out_default_country_code out NOCOPY /* file.sql.39 change */ varchar2,
502 out_default_country out NOCOPY /* file.sql.39 change */ varchar2,
503 out_address_style out NOCOPY /* file.sql.39 change */ varchar2
504 );
505
506
507
508 PROCEDURE Add_Customer(
509 in_cust_account_id in number,
510 in_cust_type in varchar2,
511 in_party_number in varchar2,
512 in_cust_name in varchar2,
513 in_cust_first_name in varchar2,
514 in_cust_middle_name in varchar2,
515 in_cust_last_name in varchar2,
516 in_cust_title in varchar2,
517 in_Cust_Number in varchar2,
518 in_cust_email in varchar2,
519 in_cust_country_code in varchar2,
520 in_cust_phone_number in varchar2,
521 in_cust_phone_ext in varchar2,
522 in_addr_location in varchar2,
523 in_addr_country_Code in varchar2,
524 in_addr_line1 in varchar2,
525 in_addr_line2 in varchar2,
526 in_addr_line3 in varchar2,
527 in_addr_city in varchar2,
528 in_addr_state in varchar2,
529 in_addr_zip in varchar2,
530 in_ship_usage in varchar2,
531 in_bill_usage in varchar2,
532 in_deliver_usage in varchar2,
533 in_sold_usage in varchar2,
534 in_cont_first_name in varchar2,
535 in_cont_last_name in varchar2,
536 in_cont_title in varchar2,
537 in_cont_email in varchar2,
538 in_cont_country_Code in varchar2,
539 in_cont_phone_number in varchar2,
540 in_cont_phone_ext in varchar2,
541 out_cust_name out nocopy varchar2,
542 out_cust_number out nocopy varchar2,
543 out_cust_id out nocopy number,
544 out_party_number out nocopy varchar2,
545 out_ship_to_site_use_id out NOCOPY /* file.sql.39 change */ varchar2,
546 out_bill_to_site_use_id out NOCOPY /* file.sql.39 change */ varchar2,
547 out_deliver_to_site_use_id out NOCOPY /* file.sql.39 change */ varchar2,
548 out_sold_to_site_use_id out NOCOPY /* file.sql.39 change */ varchar2,
549 out_ship_to_location out nocopy varchar2,
550 out_bill_to_location out nocopy varchar2,
551 out_deliver_to_location out nocopy varchar2,
552 out_sold_to_location out nocopy varchar2,
553 out_cont_id out nocopy number,
554 out_cont_name out nocopy varchar2,
555 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
556 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2,
557 x_msg_count out NOCOPY /* file.sql.39 change */ number,
558 in_county in varchar2,
559 in_party_site_number in varchar2
560 );
561
562
563 END oe_oe_inline_address;