1 PACKAGE POS_VENDOR_PUB_PKG AS
2 /* $Header: POSVNDRS.pls 120.11.12010000.2 2008/10/04 11:16:01 sthoppan ship $ */
3
4 PROCEDURE Create_Vendor
5 ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
6 x_return_status OUT NOCOPY VARCHAR2,
7 x_msg_count OUT NOCOPY NUMBER,
8 x_msg_data OUT NOCOPY VARCHAR2,
9 x_vendor_id OUT NOCOPY NUMBER,
10 x_party_id OUT NOCOPY NUMBER
11 );
12
13 -- Notes: This API will not update any TCA tables. It updates vendor info only.
14 -- This is because the procedure calls the corresponding procedure in
15 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
16 PROCEDURE Update_Vendor
17 ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23 -- Notes:
24 -- p_mode: Indicates whether the calling code is in insert or update mode.
25 -- (I, U)
26 --
27 -- p_party_valid: Indicates how valid the calling program's party_id was
28 -- (V, N, F) Valid, Null or False
29
30 PROCEDURE Validate_Vendor
31 ( p_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
32 p_mode IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 x_party_valid OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE Create_Vendor_Site
40 ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 x_vendor_site_id OUT NOCOPY NUMBER,
45 x_party_site_id OUT NOCOPY NUMBER,
46 x_location_id OUT NOCOPY NUMBER
47 );
48
49 -- Notes: This API will not update any TCA records.
50 -- It will only update vendor site info.
51 -- This is because the procedure calls the corresponding procedure in
52 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
53 --
54 PROCEDURE Update_Vendor_Site
55 ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 -- Notes:
62 -- p_mode: Indicates whether the calling code is in insert or update mode.
63 -- (I, U)
64 --
65 -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
66 -- (V, N, F) Valid, Null or False
67
68 PROCEDURE Validate_Vendor_Site
69 ( p_vendor_site_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
70 p_mode IN VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 x_party_site_valid OUT NOCOPY VARCHAR2,
75 x_location_valid OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE Create_Vendor_Contact
79 ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 x_vendor_contact_id OUT NOCOPY NUMBER,
84 x_per_party_id OUT NOCOPY NUMBER,
85 x_rel_party_id OUT NOCOPY NUMBER,
86 x_rel_id OUT NOCOPY NUMBER,
87 x_org_contact_id OUT NOCOPY NUMBER,
88 x_party_site_id OUT NOCOPY NUMBER
89 );
90
91 PROCEDURE Create_Vendor
92 (
93 p_vendor_id IN NUMBER DEFAULT NULL,
94 p_segment1 IN VARCHAR2 DEFAULT NULL,
95 p_vendor_name IN VARCHAR2 DEFAULT NULL,
96 p_vendor_name_alt IN VARCHAR2 DEFAULT NULL,
97 p_summary_flag IN VARCHAR2 DEFAULT NULL,
98 p_enabled_flag IN VARCHAR2 DEFAULT NULL,
99 p_segment2 IN VARCHAR2 DEFAULT NULL,
100 p_segment3 IN VARCHAR2 DEFAULT NULL,
101 p_segment4 IN VARCHAR2 DEFAULT NULL,
102 p_segment5 IN VARCHAR2 DEFAULT NULL,
103 p_employee_id IN NUMBER DEFAULT NULL,
104 p_vendor_type_lookup_code IN VARCHAR2 DEFAULT NULL,
105 p_customer_num IN VARCHAR2 DEFAULT NULL,
106 p_one_time_flag IN VARCHAR2 DEFAULT NULL,
107 p_parent_vendor_id IN NUMBER DEFAULT NULL,
108 p_min_order_amount IN NUMBER DEFAULT NULL,
109 p_terms_id IN NUMBER DEFAULT NULL,
110 p_set_of_books_id IN NUMBER DEFAULT NULL,
111 p_always_take_disc_flag IN VARCHAR2 DEFAULT NULL,
112 p_pay_date_basis_lookup_code IN VARCHAR2 DEFAULT NULL,
113 p_pay_group_lookup_code IN VARCHAR2 DEFAULT NULL,
114 p_payment_priority IN NUMBER DEFAULT NULL,
115 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
116 p_payment_currency_code IN VARCHAR2 DEFAULT NULL,
117 p_invoice_amount_limit IN NUMBER DEFAULT NULL,
118 p_hold_all_payments_flag IN VARCHAR2 DEFAULT NULL,
119 p_hold_future_payments_flag IN VARCHAR2 DEFAULT NULL,
120 p_hold_reason IN VARCHAR2 DEFAULT NULL,
121 p_type_1099 IN VARCHAR2 DEFAULT NULL,
122 p_withhold_status_lookup_code IN VARCHAR2 DEFAULT NULL,
123 p_withholding_start_date IN DATE DEFAULT NULL,
124 p_org_type_lookup_code IN VARCHAR2 DEFAULT NULL,
125 p_start_date_active IN DATE DEFAULT NULL,
126 p_end_date_active IN DATE DEFAULT NULL,
127 p_minority_group_lookup_code IN VARCHAR2 DEFAULT NULL,
128 p_women_owned_flag IN VARCHAR2 DEFAULT NULL,
129 p_small_business_flag IN VARCHAR2 DEFAULT NULL,
130 p_hold_flag IN VARCHAR2 DEFAULT NULL,
131 p_purchasing_hold_reason IN VARCHAR2 DEFAULT NULL,
132 p_hold_by IN NUMBER DEFAULT NULL,
133 p_hold_date IN DATE DEFAULT NULL,
134 p_terms_date_basis IN VARCHAR2 DEFAULT NULL,
135 p_inspection_required_flag IN VARCHAR2 DEFAULT NULL,
136 p_receipt_required_flag IN VARCHAR2 DEFAULT NULL,
137 p_qty_rcv_tolerance IN NUMBER DEFAULT NULL,
138 p_qty_rcv_exception_code IN VARCHAR2 DEFAULT NULL,
139 p_enforce_ship_to_loc_code IN VARCHAR2 DEFAULT NULL,
140 p_days_early_receipt_allowed IN NUMBER DEFAULT NULL,
141 p_days_late_receipt_allowed IN NUMBER DEFAULT NULL,
142 p_receipt_days_exception_code IN VARCHAR2 DEFAULT NULL,
143 p_receiving_routing_id IN NUMBER DEFAULT NULL,
144 p_allow_substi_receipts_flag IN VARCHAR2 DEFAULT NULL,
145 p_allow_unorder_receipts_flag IN VARCHAR2 DEFAULT NULL,
146 p_hold_unmatched_invoices_flag IN VARCHAR2 DEFAULT NULL,
147 p_tax_verification_date IN DATE DEFAULT NULL,
148 p_name_control IN VARCHAR2 DEFAULT NULL,
149 p_state_reportable_flag IN VARCHAR2 DEFAULT NULL,
150 p_federal_reportable_flag IN VARCHAR2 DEFAULT NULL,
151 p_attribute_category IN VARCHAR2 DEFAULT NULL,
152 p_attribute1 IN VARCHAR2 DEFAULT NULL,
153 p_attribute2 IN VARCHAR2 DEFAULT NULL,
154 p_attribute3 IN VARCHAR2 DEFAULT NULL,
155 p_attribute4 IN VARCHAR2 DEFAULT NULL,
156 p_attribute5 IN VARCHAR2 DEFAULT NULL,
157 p_attribute6 IN VARCHAR2 DEFAULT NULL,
158 p_attribute7 IN VARCHAR2 DEFAULT NULL,
159 p_attribute8 IN VARCHAR2 DEFAULT NULL,
160 p_attribute9 IN VARCHAR2 DEFAULT NULL,
161 p_attribute10 IN VARCHAR2 DEFAULT NULL,
162 p_attribute11 IN VARCHAR2 DEFAULT NULL,
163 p_attribute12 IN VARCHAR2 DEFAULT NULL,
164 p_attribute13 IN VARCHAR2 DEFAULT NULL,
165 p_attribute14 IN VARCHAR2 DEFAULT NULL,
166 p_attribute15 IN VARCHAR2 DEFAULT NULL,
167 p_auto_calculate_interest_flag IN VARCHAR2 DEFAULT NULL,
168 p_validation_number IN NUMBER DEFAULT NULL,
169 p_exclude_freight_from_discnt IN VARCHAR2 DEFAULT NULL,
170 p_tax_reporting_name IN VARCHAR2 DEFAULT NULL,
171 p_check_digits IN VARCHAR2 DEFAULT NULL,
172 p_allow_awt_flag IN VARCHAR2 DEFAULT NULL,
173 p_awt_group_id IN NUMBER DEFAULT NULL,
174 p_pay_awt_group_id IN NUMBER DEFAULT NULL,
175 p_awt_group_name IN VARCHAR2 DEFAULT NULL,
176 p_pay_awt_group_name IN VARCHAR2 DEFAULT NULL,
177 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
178 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
179 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
180 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
181 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
182 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
183 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
184 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
185 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
186 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
187 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
188 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
189 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
190 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
191 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
192 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
193 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
194 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
195 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
196 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
197 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
198 p_bank_charge_bearer IN VARCHAR2 DEFAULT NULL,
199 p_bank_branch_type IN VARCHAR2 DEFAULT NULL,
200 p_match_option IN VARCHAR2 DEFAULT NULL,
201 p_create_debit_memo_flag IN VARCHAR2 DEFAULT NULL,
202 p_party_id IN NUMBER DEFAULT NULL,
203 p_parent_party_id IN NUMBER DEFAULT NULL,
204 p_jgzz_fiscal_code IN VARCHAR2 DEFAULT NULL,
205 p_sic_code IN VARCHAR2 DEFAULT NULL,
206 p_tax_reference IN VARCHAR2 DEFAULT NULL,
207 p_inventory_organization_id IN NUMBER DEFAULT NULL,
208 p_terms_name IN VARCHAR2 DEFAULT NULL,
209 p_default_terms_id IN NUMBER DEFAULT NULL,
210 p_ni_number IN VARCHAR2 DEFAULT NULL,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_error_msg OUT NOCOPY VARCHAR2,
213 x_vendor_id OUT NOCOPY NUMBER,
214 x_party_id OUT NOCOPY NUMBER
215 );
216
217 -- Notes: This API will not update any TCA tables. It updates vendor info only.
218 -- This is because the procedure calls the corresponding procedure in
219 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
220 PROCEDURE Update_Vendor
221 (
222 p_vendor_id IN NUMBER ,
223 p_segment1 IN VARCHAR2 ,
224 p_vendor_name IN VARCHAR2 ,
225 p_vendor_name_alt IN VARCHAR2 ,
226 p_summary_flag IN VARCHAR2 ,
227 p_enabled_flag IN VARCHAR2 ,
228 p_segment2 IN VARCHAR2 ,
229 p_segment3 IN VARCHAR2 ,
230 p_segment4 IN VARCHAR2 ,
231 p_segment5 IN VARCHAR2 ,
232 p_employee_id IN NUMBER ,
233 p_vendor_type_lookup_code IN VARCHAR2 ,
234 p_customer_num IN VARCHAR2 ,
235 p_one_time_flag IN VARCHAR2 ,
236 p_parent_vendor_id IN NUMBER ,
237 p_min_order_amount IN NUMBER ,
238 p_terms_id IN NUMBER ,
239 p_set_of_books_id IN NUMBER ,
240 p_always_take_disc_flag IN VARCHAR2 ,
241 p_pay_date_basis_lookup_code IN VARCHAR2 ,
242 p_pay_group_lookup_code IN VARCHAR2 ,
243 p_payment_priority IN NUMBER ,
244 p_invoice_currency_code IN VARCHAR2 ,
245 p_payment_currency_code IN VARCHAR2 ,
246 p_invoice_amount_limit IN NUMBER ,
247 p_hold_all_payments_flag IN VARCHAR2 ,
248 p_hold_future_payments_flag IN VARCHAR2 ,
249 p_hold_reason IN VARCHAR2 ,
250 p_type_1099 IN VARCHAR2 ,
251 p_withhold_status_lookup_code IN VARCHAR2 ,
252 p_withholding_start_date IN DATE ,
253 p_org_type_lookup_code IN VARCHAR2 ,
254 p_start_date_active IN DATE ,
255 p_end_date_active IN DATE ,
256 p_minority_group_lookup_code IN VARCHAR2 ,
257 p_women_owned_flag IN VARCHAR2 ,
258 p_small_business_flag IN VARCHAR2 ,
259 p_hold_flag IN VARCHAR2 ,
260 p_purchasing_hold_reason IN VARCHAR2 ,
261 p_hold_by IN NUMBER ,
262 p_hold_date IN DATE ,
263 p_terms_date_basis IN VARCHAR2 ,
264 p_inspection_required_flag IN VARCHAR2 ,
265 p_receipt_required_flag IN VARCHAR2 ,
266 p_qty_rcv_tolerance IN NUMBER ,
267 p_qty_rcv_exception_code IN VARCHAR2 ,
268 p_enforce_ship_to_loc_code IN VARCHAR2 ,
269 p_days_early_receipt_allowed IN NUMBER ,
270 p_days_late_receipt_allowed IN NUMBER ,
271 p_receipt_days_exception_code IN VARCHAR2 ,
272 p_receiving_routing_id IN NUMBER ,
273 p_allow_substi_receipts_flag IN VARCHAR2 ,
274 p_allow_unorder_receipts_flag IN VARCHAR2 ,
275 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
276 p_tax_verification_date IN DATE ,
277 p_name_control IN VARCHAR2 ,
278 p_state_reportable_flag IN VARCHAR2 ,
279 p_federal_reportable_flag IN VARCHAR2 ,
280 p_attribute_category IN VARCHAR2 ,
281 p_attribute1 IN VARCHAR2 ,
282 p_attribute2 IN VARCHAR2 ,
283 p_attribute3 IN VARCHAR2 ,
284 p_attribute4 IN VARCHAR2 ,
285 p_attribute5 IN VARCHAR2 ,
286 p_attribute6 IN VARCHAR2 ,
287 p_attribute7 IN VARCHAR2 ,
288 p_attribute8 IN VARCHAR2 ,
289 p_attribute9 IN VARCHAR2 ,
290 p_attribute10 IN VARCHAR2 ,
291 p_attribute11 IN VARCHAR2 ,
292 p_attribute12 IN VARCHAR2 ,
293 p_attribute13 IN VARCHAR2 ,
294 p_attribute14 IN VARCHAR2 ,
295 p_attribute15 IN VARCHAR2 ,
296 p_auto_calculate_interest_flag IN VARCHAR2 ,
297 p_validation_number IN NUMBER ,
298 p_exclude_freight_from_discnt IN VARCHAR2 ,
299 p_tax_reporting_name IN VARCHAR2 ,
300 p_check_digits IN VARCHAR2 ,
301 p_allow_awt_flag IN VARCHAR2 ,
302 p_awt_group_id IN NUMBER ,
303 p_pay_awt_group_id IN NUMBER ,
304 p_awt_group_name IN VARCHAR2 ,
305 p_pay_awt_group_name IN VARCHAR2 ,
306 p_global_attribute1 IN VARCHAR2 ,
307 p_global_attribute2 IN VARCHAR2 ,
308 p_global_attribute3 IN VARCHAR2 ,
309 p_global_attribute4 IN VARCHAR2 ,
310 p_global_attribute5 IN VARCHAR2 ,
311 p_global_attribute6 IN VARCHAR2 ,
312 p_global_attribute7 IN VARCHAR2 ,
313 p_global_attribute8 IN VARCHAR2 ,
317 p_global_attribute12 IN VARCHAR2 ,
314 p_global_attribute9 IN VARCHAR2 ,
315 p_global_attribute10 IN VARCHAR2 ,
316 p_global_attribute11 IN VARCHAR2 ,
318 p_global_attribute13 IN VARCHAR2 ,
319 p_global_attribute14 IN VARCHAR2 ,
320 p_global_attribute15 IN VARCHAR2 ,
321 p_global_attribute16 IN VARCHAR2 ,
322 p_global_attribute17 IN VARCHAR2 ,
323 p_global_attribute18 IN VARCHAR2 ,
324 p_global_attribute19 IN VARCHAR2 ,
325 p_global_attribute20 IN VARCHAR2 ,
326 p_global_attribute_category IN VARCHAR2 ,
327 p_bank_charge_bearer IN VARCHAR2 ,
328 p_bank_branch_type IN VARCHAR2 ,
329 p_match_option IN VARCHAR2 ,
330 p_create_debit_memo_flag IN VARCHAR2 ,
331 p_party_id IN NUMBER ,
332 p_parent_party_id IN NUMBER ,
333 p_jgzz_fiscal_code IN VARCHAR2 ,
334 p_sic_code IN VARCHAR2 ,
335 p_tax_reference IN VARCHAR2 ,
336 p_inventory_organization_id IN NUMBER ,
337 p_terms_name IN VARCHAR2 ,
338 p_default_terms_id IN NUMBER ,
339 p_ni_number IN VARCHAR2 ,
340 p_last_update_date IN DATE DEFAULT NULL,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_error_msg OUT NOCOPY VARCHAR2
343 );
344
345 -- Notes:
346 -- p_mode: Indicates whether the calling code is in insert or update mode.
347 -- (I, U)
348 --
349 -- p_party_valid: Indicates how valid the calling program's party_id was
350 -- (V, N, F) Valid, Null or False
351
352 PROCEDURE Validate_Vendor
353 (
354 p_vendor_id IN NUMBER ,
355 p_segment1 IN VARCHAR2 ,
356 p_vendor_name IN VARCHAR2 ,
357 p_vendor_name_alt IN VARCHAR2 ,
358 p_summary_flag IN VARCHAR2 ,
359 p_enabled_flag IN VARCHAR2 ,
360 p_segment2 IN VARCHAR2 ,
361 p_segment3 IN VARCHAR2 ,
362 p_segment4 IN VARCHAR2 ,
363 p_segment5 IN VARCHAR2 ,
364 p_employee_id IN NUMBER ,
365 p_vendor_type_lookup_code IN VARCHAR2 ,
366 p_customer_num IN VARCHAR2 ,
367 p_one_time_flag IN VARCHAR2 ,
368 p_parent_vendor_id IN NUMBER ,
369 p_min_order_amount IN NUMBER ,
370 p_terms_id IN NUMBER ,
371 p_set_of_books_id IN NUMBER ,
372 p_always_take_disc_flag IN VARCHAR2 ,
373 p_pay_date_basis_lookup_code IN VARCHAR2 ,
374 p_pay_group_lookup_code IN VARCHAR2 ,
375 p_payment_priority IN NUMBER ,
376 p_invoice_currency_code IN VARCHAR2 ,
377 p_payment_currency_code IN VARCHAR2 ,
378 p_invoice_amount_limit IN NUMBER ,
379 p_hold_all_payments_flag IN VARCHAR2 ,
380 p_hold_future_payments_flag IN VARCHAR2 ,
381 p_hold_reason IN VARCHAR2 ,
382 p_type_1099 IN VARCHAR2 ,
383 p_withhold_status_lookup_code IN VARCHAR2 ,
384 p_withholding_start_date IN DATE ,
385 p_org_type_lookup_code IN VARCHAR2 ,
386 p_start_date_active IN DATE ,
387 p_end_date_active IN DATE ,
388 p_minority_group_lookup_code IN VARCHAR2 ,
389 p_women_owned_flag IN VARCHAR2 ,
390 p_small_business_flag IN VARCHAR2 ,
391 p_hold_flag IN VARCHAR2 ,
392 p_purchasing_hold_reason IN VARCHAR2 ,
393 p_hold_by IN NUMBER ,
394 p_hold_date IN DATE ,
395 p_terms_date_basis IN VARCHAR2 ,
396 p_inspection_required_flag IN VARCHAR2 ,
397 p_receipt_required_flag IN VARCHAR2 ,
398 p_qty_rcv_tolerance IN NUMBER ,
399 p_qty_rcv_exception_code IN VARCHAR2 ,
400 p_enforce_ship_to_loc_code IN VARCHAR2 ,
401 p_days_early_receipt_allowed IN NUMBER ,
402 p_days_late_receipt_allowed IN NUMBER ,
403 p_receipt_days_exception_code IN VARCHAR2 ,
404 p_receiving_routing_id IN NUMBER ,
405 p_allow_substi_receipts_flag IN VARCHAR2 ,
406 p_allow_unorder_receipts_flag IN VARCHAR2 ,
407 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
408 p_tax_verification_date IN DATE ,
409 p_name_control IN VARCHAR2 ,
410 p_state_reportable_flag IN VARCHAR2 ,
411 p_federal_reportable_flag IN VARCHAR2 ,
412 p_attribute_category IN VARCHAR2 ,
413 p_attribute1 IN VARCHAR2 ,
414 p_attribute2 IN VARCHAR2 ,
415 p_attribute3 IN VARCHAR2 ,
416 p_attribute4 IN VARCHAR2 ,
417 p_attribute5 IN VARCHAR2 ,
418 p_attribute6 IN VARCHAR2 ,
419 p_attribute7 IN VARCHAR2 ,
420 p_attribute8 IN VARCHAR2 ,
421 p_attribute9 IN VARCHAR2 ,
425 p_attribute13 IN VARCHAR2 ,
422 p_attribute10 IN VARCHAR2 ,
423 p_attribute11 IN VARCHAR2 ,
424 p_attribute12 IN VARCHAR2 ,
426 p_attribute14 IN VARCHAR2 ,
427 p_attribute15 IN VARCHAR2 ,
428 p_auto_calculate_interest_flag IN VARCHAR2 ,
429 p_validation_number IN NUMBER ,
430 p_exclude_freight_from_discnt IN VARCHAR2 ,
431 p_tax_reporting_name IN VARCHAR2 ,
432 p_check_digits IN VARCHAR2 ,
433 p_allow_awt_flag IN VARCHAR2 ,
434 p_awt_group_id IN NUMBER ,
435 p_pay_awt_group_id IN NUMBER ,
436 p_awt_group_name IN VARCHAR2 ,
437 p_pay_awt_group_name IN VARCHAR2 ,
438 p_global_attribute1 IN VARCHAR2 ,
439 p_global_attribute2 IN VARCHAR2 ,
440 p_global_attribute3 IN VARCHAR2 ,
441 p_global_attribute4 IN VARCHAR2 ,
442 p_global_attribute5 IN VARCHAR2 ,
443 p_global_attribute6 IN VARCHAR2 ,
444 p_global_attribute7 IN VARCHAR2 ,
445 p_global_attribute8 IN VARCHAR2 ,
446 p_global_attribute9 IN VARCHAR2 ,
447 p_global_attribute10 IN VARCHAR2 ,
448 p_global_attribute11 IN VARCHAR2 ,
449 p_global_attribute12 IN VARCHAR2 ,
450 p_global_attribute13 IN VARCHAR2 ,
451 p_global_attribute14 IN VARCHAR2 ,
452 p_global_attribute15 IN VARCHAR2 ,
453 p_global_attribute16 IN VARCHAR2 ,
454 p_global_attribute17 IN VARCHAR2 ,
455 p_global_attribute18 IN VARCHAR2 ,
456 p_global_attribute19 IN VARCHAR2 ,
457 p_global_attribute20 IN VARCHAR2 ,
458 p_global_attribute_category IN VARCHAR2 ,
459 p_bank_charge_bearer IN VARCHAR2 ,
460 p_bank_branch_type IN VARCHAR2 ,
461 p_match_option IN VARCHAR2 ,
462 p_create_debit_memo_flag IN VARCHAR2 ,
463 p_party_id IN NUMBER ,
464 p_parent_party_id IN NUMBER ,
465 p_jgzz_fiscal_code IN VARCHAR2 ,
466 p_sic_code IN VARCHAR2 ,
467 p_tax_reference IN VARCHAR2 ,
468 p_inventory_organization_id IN NUMBER ,
469 p_terms_name IN VARCHAR2 ,
470 p_default_terms_id IN NUMBER ,
471 p_ni_number IN VARCHAR2 ,
472 p_mode IN VARCHAR2,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_error_msg OUT NOCOPY VARCHAR2,
475 x_party_valid OUT NOCOPY VARCHAR2
476 );
477
478 PROCEDURE Create_Vendor_Site
479 (
480 p_area_code IN VARCHAR2 DEFAULT NULL,
481 p_phone IN VARCHAR2 DEFAULT NULL,
482 p_customer_num IN VARCHAR2 DEFAULT NULL,
483 p_ship_to_location_id IN NUMBER DEFAULT NULL,
484 p_bill_to_location_id IN NUMBER DEFAULT NULL,
485 p_ship_via_lookup_code IN VARCHAR2 DEFAULT NULL,
486 p_freight_terms_lookup_code IN VARCHAR2 DEFAULT NULL,
487 p_fob_lookup_code IN VARCHAR2 DEFAULT NULL,
488 p_inactive_date IN DATE DEFAULT NULL,
489 p_fax IN VARCHAR2 DEFAULT NULL,
490 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
491 p_telex IN VARCHAR2 DEFAULT NULL,
492 p_terms_date_basis IN VARCHAR2 DEFAULT NULL,
493 p_distribution_set_id IN NUMBER DEFAULT NULL,
494 p_accts_pay_code_combo_id IN NUMBER DEFAULT NULL,
495 p_prepay_code_combination_id IN NUMBER DEFAULT NULL,
496 p_pay_group_lookup_code IN VARCHAR2 DEFAULT NULL,
497 p_payment_priority IN NUMBER DEFAULT NULL,
498 p_terms_id IN NUMBER DEFAULT NULL,
499 p_invoice_amount_limit IN NUMBER DEFAULT NULL,
500 p_pay_date_basis_lookup_code IN VARCHAR2 DEFAULT NULL,
501 p_always_take_disc_flag IN VARCHAR2 DEFAULT NULL,
502 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
503 p_payment_currency_code IN VARCHAR2 DEFAULT NULL,
504 p_vendor_site_id IN NUMBER DEFAULT NULL,
505 p_last_update_date IN DATE DEFAULT NULL,
506 p_last_updated_by IN NUMBER DEFAULT NULL,
507 p_vendor_id IN NUMBER DEFAULT NULL,
508 p_vendor_site_code IN VARCHAR2 DEFAULT NULL,
509 p_vendor_site_code_alt IN VARCHAR2 DEFAULT NULL,
510 p_purchasing_site_flag IN VARCHAR2 DEFAULT NULL,
511 p_rfq_only_site_flag IN VARCHAR2 DEFAULT NULL,
512 p_pay_site_flag IN VARCHAR2 DEFAULT NULL,
513 p_attention_ar_flag IN VARCHAR2 DEFAULT NULL,
514 p_hold_all_payments_flag IN VARCHAR2 DEFAULT NULL,
515 p_hold_future_payments_flag IN VARCHAR2 DEFAULT NULL,
516 p_hold_reason IN VARCHAR2 DEFAULT NULL,
517 p_hold_unmatched_invoices_flag IN VARCHAR2 DEFAULT NULL,
518 p_tax_reporting_site_flag IN VARCHAR2 DEFAULT NULL,
519 p_attribute_category IN VARCHAR2 DEFAULT NULL,
520 p_attribute1 IN VARCHAR2 DEFAULT NULL,
524 p_attribute5 IN VARCHAR2 DEFAULT NULL,
521 p_attribute2 IN VARCHAR2 DEFAULT NULL,
522 p_attribute3 IN VARCHAR2 DEFAULT NULL,
523 p_attribute4 IN VARCHAR2 DEFAULT NULL,
525 p_attribute6 IN VARCHAR2 DEFAULT NULL,
526 p_attribute7 IN VARCHAR2 DEFAULT NULL,
527 p_attribute8 IN VARCHAR2 DEFAULT NULL,
528 p_attribute9 IN VARCHAR2 DEFAULT NULL,
529 p_attribute10 IN VARCHAR2 DEFAULT NULL,
530 p_attribute11 IN VARCHAR2 DEFAULT NULL,
531 p_attribute12 IN VARCHAR2 DEFAULT NULL,
532 p_attribute13 IN VARCHAR2 DEFAULT NULL,
533 p_attribute14 IN VARCHAR2 DEFAULT NULL,
534 p_attribute15 IN VARCHAR2 DEFAULT NULL,
535 p_validation_number IN NUMBER DEFAULT NULL,
536 p_exclude_freight_from_discnt IN VARCHAR2 DEFAULT NULL,
537 p_bank_charge_bearer IN VARCHAR2 DEFAULT NULL,
538 p_org_id IN NUMBER DEFAULT NULL,
539 p_check_digits IN VARCHAR2 DEFAULT NULL,
540 p_allow_awt_flag IN VARCHAR2 DEFAULT NULL,
541 p_awt_group_id IN NUMBER DEFAULT NULL,
542 p_pay_awt_group_id IN NUMBER DEFAULT NULL,
543 p_default_pay_site_id IN NUMBER DEFAULT NULL,
544 p_pay_on_code IN VARCHAR2 DEFAULT NULL,
545 p_pay_on_receipt_summary_code IN VARCHAR2 DEFAULT NULL,
546 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
547 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
548 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
549 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
550 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
551 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
552 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
553 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
554 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
555 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
556 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
557 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
558 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
559 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
560 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
561 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
562 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
563 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
564 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
565 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
566 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
567 p_tp_header_id IN NUMBER DEFAULT NULL,
568 p_edi_id_number IN VARCHAR2 DEFAULT NULL,
569 p_ece_tp_location_code IN VARCHAR2 DEFAULT NULL,
570 p_pcard_site_flag IN VARCHAR2 DEFAULT NULL,
571 p_match_option IN VARCHAR2 DEFAULT NULL,
572 p_country_of_origin_code IN VARCHAR2 DEFAULT NULL,
573 p_future_dated_payment_ccid IN NUMBER DEFAULT NULL,
574 p_create_debit_memo_flag IN VARCHAR2 DEFAULT NULL,
575 p_supplier_notif_method IN VARCHAR2 DEFAULT NULL,
576 p_email_address IN VARCHAR2 DEFAULT NULL,
577 p_primary_pay_site_flag IN VARCHAR2 DEFAULT NULL,
578 p_shipping_control IN VARCHAR2 DEFAULT NULL,
579 p_selling_company_identifier IN VARCHAR2 DEFAULT NULL,
580 p_gapless_inv_num_flag IN VARCHAR2 DEFAULT NULL,
581 p_location_id IN NUMBER DEFAULT NULL,
582 p_party_site_id IN NUMBER DEFAULT NULL,
583 p_org_name IN VARCHAR2 DEFAULT NULL,
584 p_duns_number IN VARCHAR2 DEFAULT NULL,
585 p_address_style IN VARCHAR2 DEFAULT NULL,
586 p_language IN VARCHAR2 DEFAULT NULL,
587 p_province IN VARCHAR2 DEFAULT NULL,
588 p_country IN VARCHAR2 DEFAULT NULL,
589 p_address_line1 IN VARCHAR2 ,
590 p_address_line2 IN VARCHAR2 DEFAULT NULL,
591 p_address_line3 IN VARCHAR2 DEFAULT NULL,
592 p_address_line4 IN VARCHAR2 DEFAULT NULL,
593 p_address_lines_alt IN VARCHAR2 DEFAULT NULL,
594 p_county IN VARCHAR2 DEFAULT NULL,
595 p_city IN VARCHAR2 DEFAULT NULL,
596 p_state IN VARCHAR2 DEFAULT NULL,
597 p_zip IN VARCHAR2 DEFAULT NULL,
598 p_terms_name IN VARCHAR2 DEFAULT NULL,
599 p_default_terms_id IN NUMBER DEFAULT NULL,
600 p_awt_group_name IN VARCHAR2 DEFAULT NULL,
601 p_pay_awt_group_name IN VARCHAR2 DEFAULT NULL,
602 p_distribution_set_name IN VARCHAR2 DEFAULT NULL,
603 p_ship_to_location_code IN VARCHAR2 DEFAULT NULL,
604 p_bill_to_location_code IN VARCHAR2 DEFAULT NULL,
605 p_default_dist_set_id IN NUMBER DEFAULT NULL,
606 p_default_ship_to_loc_id IN NUMBER DEFAULT NULL,
607 p_default_bill_to_loc_id IN NUMBER DEFAULT NULL,
608 p_tolerance_id IN NUMBER DEFAULT NULL,
612 x_return_status OUT NOCOPY VARCHAR2,
609 p_tolerance_name IN VARCHAR2 DEFAULT NULL,
610 p_retainage_rate IN NUMBER DEFAULT NULL,
611 p_service_tolerance_id IN NUMBER DEFAULT NULL,
613 x_error_msg OUT NOCOPY VARCHAR2,
614 x_vendor_site_id OUT NOCOPY NUMBER,
615 x_party_site_id OUT NOCOPY NUMBER,
616 x_location_id OUT NOCOPY NUMBER
617 );
618
619 -- Notes: This API will not update any TCA records.
620 -- It will only update vendor site info.
621 -- This is because the procedure calls the corresponding procedure in
622 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
623 --
624 PROCEDURE Update_Vendor_Site
625 (
626 p_area_code IN VARCHAR2 ,
627 p_phone IN VARCHAR2 ,
628 p_customer_num IN VARCHAR2 ,
629 p_ship_to_location_id IN NUMBER ,
630 p_bill_to_location_id IN NUMBER ,
631 p_ship_via_lookup_code IN VARCHAR2 ,
632 p_freight_terms_lookup_code IN VARCHAR2 ,
633 p_fob_lookup_code IN VARCHAR2 ,
634 p_inactive_date IN DATE ,
635 p_fax IN VARCHAR2 ,
636 p_fax_area_code IN VARCHAR2 ,
637 p_telex IN VARCHAR2 ,
638 p_terms_date_basis IN VARCHAR2 ,
639 p_distribution_set_id IN NUMBER ,
640 p_accts_pay_code_combo_id IN NUMBER ,
641 p_prepay_code_combination_id IN NUMBER ,
642 p_pay_group_lookup_code IN VARCHAR2 ,
643 p_payment_priority IN NUMBER ,
644 p_terms_id IN NUMBER ,
645 p_invoice_amount_limit IN NUMBER ,
646 p_pay_date_basis_lookup_code IN VARCHAR2 ,
647 p_always_take_disc_flag IN VARCHAR2 ,
648 p_invoice_currency_code IN VARCHAR2 ,
649 p_payment_currency_code IN VARCHAR2 ,
650 p_vendor_site_id IN NUMBER ,
651 p_last_update_date IN DATE ,
652 p_last_updated_by IN NUMBER ,
653 p_vendor_id IN NUMBER ,
654 p_vendor_site_code IN VARCHAR2 ,
655 p_vendor_site_code_alt IN VARCHAR2 ,
656 p_purchasing_site_flag IN VARCHAR2 ,
657 p_rfq_only_site_flag IN VARCHAR2 ,
658 p_pay_site_flag IN VARCHAR2 ,
659 p_attention_ar_flag IN VARCHAR2 ,
660 p_hold_all_payments_flag IN VARCHAR2 ,
661 p_hold_future_payments_flag IN VARCHAR2 ,
662 p_hold_reason IN VARCHAR2 ,
663 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
664 p_tax_reporting_site_flag IN VARCHAR2 ,
665 p_attribute_category IN VARCHAR2 ,
666 p_attribute1 IN VARCHAR2 ,
667 p_attribute2 IN VARCHAR2 ,
668 p_attribute3 IN VARCHAR2 ,
669 p_attribute4 IN VARCHAR2 ,
670 p_attribute5 IN VARCHAR2 ,
671 p_attribute6 IN VARCHAR2 ,
672 p_attribute7 IN VARCHAR2 ,
673 p_attribute8 IN VARCHAR2 ,
674 p_attribute9 IN VARCHAR2 ,
675 p_attribute10 IN VARCHAR2 ,
676 p_attribute11 IN VARCHAR2 ,
677 p_attribute12 IN VARCHAR2 ,
678 p_attribute13 IN VARCHAR2 ,
679 p_attribute14 IN VARCHAR2 ,
680 p_attribute15 IN VARCHAR2 ,
681 p_validation_number IN NUMBER ,
682 p_exclude_freight_from_discnt IN VARCHAR2 ,
683 p_bank_charge_bearer IN VARCHAR2 ,
684 p_org_id IN NUMBER ,
685 p_check_digits IN VARCHAR2 ,
686 p_allow_awt_flag IN VARCHAR2 ,
687 p_awt_group_id IN NUMBER ,
688 p_pay_awt_group_id IN NUMBER ,
689 p_default_pay_site_id IN NUMBER ,
690 p_pay_on_code IN VARCHAR2 ,
691 p_pay_on_receipt_summary_code IN VARCHAR2 ,
692 p_global_attribute_category IN VARCHAR2 ,
693 p_global_attribute1 IN VARCHAR2 ,
694 p_global_attribute2 IN VARCHAR2 ,
695 p_global_attribute3 IN VARCHAR2 ,
696 p_global_attribute4 IN VARCHAR2 ,
697 p_global_attribute5 IN VARCHAR2 ,
698 p_global_attribute6 IN VARCHAR2 ,
699 p_global_attribute7 IN VARCHAR2 ,
700 p_global_attribute8 IN VARCHAR2 ,
701 p_global_attribute9 IN VARCHAR2 ,
702 p_global_attribute10 IN VARCHAR2 ,
703 p_global_attribute11 IN VARCHAR2 ,
704 p_global_attribute12 IN VARCHAR2 ,
705 p_global_attribute13 IN VARCHAR2 ,
706 p_global_attribute14 IN VARCHAR2 ,
707 p_global_attribute15 IN VARCHAR2 ,
708 p_global_attribute16 IN VARCHAR2 ,
709 p_global_attribute17 IN VARCHAR2 ,
710 p_global_attribute18 IN VARCHAR2 ,
711 p_global_attribute19 IN VARCHAR2 ,
712 p_global_attribute20 IN VARCHAR2 ,
713 p_tp_header_id IN NUMBER ,
714 p_edi_id_number IN VARCHAR2 ,
715 p_ece_tp_location_code IN VARCHAR2 ,
716 p_pcard_site_flag IN VARCHAR2 ,
720 p_create_debit_memo_flag IN VARCHAR2 ,
717 p_match_option IN VARCHAR2 ,
718 p_country_of_origin_code IN VARCHAR2 ,
719 p_future_dated_payment_ccid IN NUMBER ,
721 p_supplier_notif_method IN VARCHAR2 ,
722 p_email_address IN VARCHAR2 ,
723 p_primary_pay_site_flag IN VARCHAR2 ,
724 p_shipping_control IN VARCHAR2 ,
725 p_selling_company_identifier IN VARCHAR2 ,
726 p_gapless_inv_num_flag IN VARCHAR2 ,
727 p_location_id IN NUMBER ,
728 p_party_site_id IN NUMBER ,
729 p_org_name IN VARCHAR2 ,
730 p_duns_number IN VARCHAR2 ,
731 p_address_style IN VARCHAR2 ,
732 p_language IN VARCHAR2 ,
733 p_province IN VARCHAR2 ,
734 p_country IN VARCHAR2 ,
735 p_address_line1 IN VARCHAR2 ,
736 p_address_line2 IN VARCHAR2 ,
737 p_address_line3 IN VARCHAR2 ,
738 p_address_line4 IN VARCHAR2 ,
739 p_address_lines_alt IN VARCHAR2 ,
740 p_county IN VARCHAR2 ,
741 p_city IN VARCHAR2 ,
742 p_state IN VARCHAR2 ,
743 p_zip IN VARCHAR2 ,
744 p_terms_name IN VARCHAR2 ,
745 p_default_terms_id IN NUMBER ,
746 p_awt_group_name IN VARCHAR2 ,
747 p_pay_awt_group_name IN VARCHAR2 ,
748 p_distribution_set_name IN VARCHAR2 ,
749 p_ship_to_location_code IN VARCHAR2 ,
750 p_bill_to_location_code IN VARCHAR2 ,
751 p_default_dist_set_id IN NUMBER ,
752 p_default_ship_to_loc_id IN NUMBER ,
753 p_default_bill_to_loc_id IN NUMBER ,
754 p_tolerance_id IN NUMBER ,
755 p_tolerance_name IN VARCHAR2 ,
756 p_retainage_rate IN NUMBER ,
757 p_service_tolerance_id IN NUMBER ,
758 p_ship_network_loc_id IN NUMBER ,
759 x_return_status OUT NOCOPY VARCHAR2,
760 x_error_msg OUT NOCOPY VARCHAR2
761 );
762
763 -- Notes:
764 -- p_mode: Indicates whether the calling code is in insert or update mode.
765 -- (I, U)
766 --
767 -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
768 -- (V, N, F) Valid, Null or False
769
770 PROCEDURE Validate_Vendor_Site
771 (
772 p_area_code IN VARCHAR2 ,
773 p_phone IN VARCHAR2 ,
774 p_customer_num IN VARCHAR2 ,
775 p_ship_to_location_id IN NUMBER ,
776 p_bill_to_location_id IN NUMBER ,
777 p_ship_via_lookup_code IN VARCHAR2 ,
778 p_freight_terms_lookup_code IN VARCHAR2 ,
779 p_fob_lookup_code IN VARCHAR2 ,
780 p_inactive_date IN DATE ,
781 p_fax IN VARCHAR2 ,
782 p_fax_area_code IN VARCHAR2 ,
783 p_telex IN VARCHAR2 ,
784 p_terms_date_basis IN VARCHAR2 ,
785 p_distribution_set_id IN NUMBER ,
786 p_accts_pay_code_combo_id IN NUMBER ,
787 p_prepay_code_combination_id IN NUMBER ,
788 p_pay_group_lookup_code IN VARCHAR2 ,
789 p_payment_priority IN NUMBER ,
790 p_terms_id IN NUMBER ,
791 p_invoice_amount_limit IN NUMBER ,
792 p_pay_date_basis_lookup_code IN VARCHAR2 ,
793 p_always_take_disc_flag IN VARCHAR2 ,
794 p_invoice_currency_code IN VARCHAR2 ,
795 p_payment_currency_code IN VARCHAR2 ,
796 p_vendor_site_id IN NUMBER ,
797 p_last_update_date IN DATE ,
798 p_last_updated_by IN NUMBER ,
799 p_vendor_id IN NUMBER ,
800 p_vendor_site_code IN VARCHAR2 ,
801 p_vendor_site_code_alt IN VARCHAR2 ,
802 p_purchasing_site_flag IN VARCHAR2 ,
803 p_rfq_only_site_flag IN VARCHAR2 ,
804 p_pay_site_flag IN VARCHAR2 ,
805 p_attention_ar_flag IN VARCHAR2 ,
806 p_hold_all_payments_flag IN VARCHAR2 ,
807 p_hold_future_payments_flag IN VARCHAR2 ,
808 p_hold_reason IN VARCHAR2 ,
809 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
810 p_tax_reporting_site_flag IN VARCHAR2 ,
811 p_attribute_category IN VARCHAR2 ,
812 p_attribute1 IN VARCHAR2 ,
813 p_attribute2 IN VARCHAR2 ,
814 p_attribute3 IN VARCHAR2 ,
815 p_attribute4 IN VARCHAR2 ,
816 p_attribute5 IN VARCHAR2 ,
817 p_attribute6 IN VARCHAR2 ,
818 p_attribute7 IN VARCHAR2 ,
819 p_attribute8 IN VARCHAR2 ,
820 p_attribute9 IN VARCHAR2 ,
821 p_attribute10 IN VARCHAR2 ,
822 p_attribute11 IN VARCHAR2 ,
823 p_attribute12 IN VARCHAR2 ,
824 p_attribute13 IN VARCHAR2 ,
825 p_attribute14 IN VARCHAR2 ,
826 p_attribute15 IN VARCHAR2 ,
827 p_validation_number IN NUMBER ,
828 p_exclude_freight_from_discnt IN VARCHAR2 ,
829 p_bank_charge_bearer IN VARCHAR2 ,
830 p_org_id IN NUMBER ,
831 p_check_digits IN VARCHAR2 ,
832 p_allow_awt_flag IN VARCHAR2 ,
833 p_awt_group_id IN NUMBER ,
834 p_pay_awt_group_id IN NUMBER ,
835 p_default_pay_site_id IN NUMBER ,
836 p_pay_on_code IN VARCHAR2 ,
837 p_pay_on_receipt_summary_code IN VARCHAR2 ,
838 p_global_attribute_category IN VARCHAR2 ,
839 p_global_attribute1 IN VARCHAR2 ,
840 p_global_attribute2 IN VARCHAR2 ,
841 p_global_attribute3 IN VARCHAR2 ,
842 p_global_attribute4 IN VARCHAR2 ,
843 p_global_attribute5 IN VARCHAR2 ,
844 p_global_attribute6 IN VARCHAR2 ,
845 p_global_attribute7 IN VARCHAR2 ,
846 p_global_attribute8 IN VARCHAR2 ,
847 p_global_attribute9 IN VARCHAR2 ,
848 p_global_attribute10 IN VARCHAR2 ,
849 p_global_attribute11 IN VARCHAR2 ,
850 p_global_attribute12 IN VARCHAR2 ,
851 p_global_attribute13 IN VARCHAR2 ,
852 p_global_attribute14 IN VARCHAR2 ,
853 p_global_attribute15 IN VARCHAR2 ,
854 p_global_attribute16 IN VARCHAR2 ,
855 p_global_attribute17 IN VARCHAR2 ,
856 p_global_attribute18 IN VARCHAR2 ,
857 p_global_attribute19 IN VARCHAR2 ,
858 p_global_attribute20 IN VARCHAR2 ,
859 p_tp_header_id IN NUMBER ,
860 p_edi_id_number IN VARCHAR2 ,
861 p_ece_tp_location_code IN VARCHAR2 ,
862 p_pcard_site_flag IN VARCHAR2 ,
863 p_match_option IN VARCHAR2 ,
864 p_country_of_origin_code IN VARCHAR2 ,
865 p_future_dated_payment_ccid IN NUMBER ,
869 p_primary_pay_site_flag IN VARCHAR2 ,
866 p_create_debit_memo_flag IN VARCHAR2 ,
867 p_supplier_notif_method IN VARCHAR2 ,
868 p_email_address IN VARCHAR2 ,
870 p_shipping_control IN VARCHAR2 ,
871 p_selling_company_identifier IN VARCHAR2 ,
872 p_gapless_inv_num_flag IN VARCHAR2 ,
873 p_location_id IN NUMBER ,
874 p_party_site_id IN NUMBER ,
875 p_org_name IN VARCHAR2 ,
876 p_duns_number IN VARCHAR2 ,
877 p_address_style IN VARCHAR2 ,
878 p_language IN VARCHAR2 ,
879 p_province IN VARCHAR2 ,
880 p_country IN VARCHAR2 ,
881 p_address_line1 IN VARCHAR2 ,
882 p_address_line2 IN VARCHAR2 ,
883 p_address_line3 IN VARCHAR2 ,
884 p_address_line4 IN VARCHAR2 ,
885 p_address_lines_alt IN VARCHAR2 ,
886 p_county IN VARCHAR2 ,
887 p_city IN VARCHAR2 ,
888 p_state IN VARCHAR2 ,
889 p_zip IN VARCHAR2 ,
890 p_terms_name IN VARCHAR2 ,
891 p_default_terms_id IN NUMBER ,
892 p_awt_group_name IN VARCHAR2 ,
893 p_pay_awt_group_name IN VARCHAR2 ,
894 p_distribution_set_name IN VARCHAR2 ,
895 p_ship_to_location_code IN VARCHAR2 ,
896 p_bill_to_location_code IN VARCHAR2 ,
897 p_default_dist_set_id IN NUMBER ,
898 p_default_ship_to_loc_id IN NUMBER ,
899 p_default_bill_to_loc_id IN NUMBER ,
900 p_tolerance_id IN NUMBER ,
901 p_tolerance_name IN VARCHAR2 ,
902 p_retainage_rate IN NUMBER ,
903 p_mode IN VARCHAR2,
904 x_return_status OUT NOCOPY VARCHAR2,
905 x_error_msg OUT NOCOPY VARCHAR2,
906 x_party_site_valid OUT NOCOPY VARCHAR2,
907 x_location_valid OUT NOCOPY VARCHAR2
908 );
909
910 END POS_VENDOR_PUB_PKG;
[Home] [Help]