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