1 PACKAGE POS_VENDOR_PUB_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSVNDRS.pls 120.21.12020000.2 2013/02/09 13:43:50 hvutukur ship $ */
3 /*#
4 * This package provides APIs to create Supplier,
5 * Supplier Site and Supplier Contact records.
6 * @rep:scope public
7 * @rep:product POS
8 * @rep:lifecycle active
9 * @rep:displayname Supplier APIs
10 * @rep:category BUSINESS_ENTITY AP_SUPPLIER
11 */
12
13 --
14 -- Begin Supplier Hub: Data Publication
15 --
16 -- Throughout this package spec, standard annotations are added for
17 -- most public APIs so end users can discover them in Integration
18 -- Repository. Mon Aug 31 09:29:44 PDT 2009 bso R12.1.2
22
19 --
20 -- End Supplier Hub: Data Publication
21 --
23 /*#
24 * This procedure creates a Supplier record in Payables,
25 * TCA (Trading Community Architecture), Banking and Tax tables
26 * with the input supplier information.
27 * If p_vendor_rec.party_id is a valid TCA Party ID then it will be
28 * treated as an existing Party to be enabled as a Supplier.
29 * Otherwise a new TCA Party record will be created.
30 * Upon successful validation this procedure posts the record(s) but
31 * does not perform database commit.
32 * @param p_vendor_rec Supplier info to be created. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_REC_TYPE.
33 * @param x_return_status Standard API return status
34 * @param x_msg_count Standard API message count
35 * @param x_msg_data Standard API message data
36 * @param x_vendor_id The created Supplier Identifier
37 * @param x_party_id The created or existing TCA Party Identifier
38 * @rep:displayname Create Supplier
39 */
40 PROCEDURE Create_Vendor
41 ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 x_vendor_id OUT NOCOPY NUMBER,
46 x_party_id OUT NOCOPY NUMBER
47 );
48
49 -- Notes: This API will not update any TCA tables. It updates vendor info only.
50 -- This is because the procedure calls the corresponding procedure in
51 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
52 /*#
53 * This procedure updates a Supplier record in Payables. Notice
54 * the corresponding TCA Party record will not be updated.
55 * Upon successful validation this procedure updates the record but
56 * does not perform database commit.
57 * @param p_vendor_rec Supplier info to be updated. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_REC_TYPE.
58 * @param x_return_status Standard API return status
59 * @param x_msg_count Standard API message count
60 * @param x_msg_data Standard API message data
61 * @rep:displayname Update Supplier
62 * @rep:scope internal
63 * @rep:lifecycle deprecated
64 */
65 PROCEDURE Update_Vendor
66 ( p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 -- Notes:
73 -- p_mode: Indicates whether the calling code is in insert or update mode.
74 -- (I, U)
75 --
76 -- p_party_valid: Indicates how valid the calling program's party_id was
77 -- (V, N, F) Valid, Null or False
78
79 /*#
80 * This procedure validates a Supplier record in Payables and TCA.
81 * If Supplier record is not valid the reason will be returned in the
82 * standard API output message. In addition the party valid output
83 * indicates whether the TCA Party record is valid or not.
84 * @param p_vendor_rec Supplier info to be validated. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_REC_TYPE.
85 * @param p_mode Indicates the calling mode I = Insert, U = Update
86 * @param x_return_status Standard API return status
87 * @param x_msg_count Standard API message count
88 * @param x_msg_data Standard API message data
89 * @param x_party_valid V = valid TCA Party, F = invalid, N = not found
90 * @rep:displayname Validate Supplier
91 * @rep:scope internal
92 * @rep:lifecycle deprecated
93 */
94 PROCEDURE Validate_Vendor
95 ( p_vendor_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_rec_type,
96 p_mode IN VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_party_valid OUT NOCOPY VARCHAR2
101 );
102
103
104 /*#
105 * This procedure creates a Supplier Site record in Payables and TCA
106 * (Trading Community Architecture) with the input supplier site information.
107 * If p_vendor_site_rec.party_site_id and p_vendor_site_rec.location_id are
108 * valid Party Site ID and Location ID then they will be
109 * treated as an existing Party Site to be enabled as a Supplier Site.
110 * Otherwise a new TCA Party Site record will be created.
111 * Upon successful validation this procedure posts the record(s) but
112 * does not perform database commit.
113 * @param p_vendor_site_rec Supplier Site info to be created. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_SITE_REC_TYPE.
114 * @param x_return_status Standard API return status
115 * @param x_msg_count Standard API message count
116 * @param x_msg_data Standard API message data
117 * @param x_vendor_site_id The created Supplier Site Identifier
118 * @param x_party_site_id The created or existing TCA Party Site Identifier
119 * @param x_location_id The created or existing TCA Location Identifier
120 * @rep:displayname Create Supplier Site
121 */
122 PROCEDURE Create_Vendor_Site
123 ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 x_vendor_site_id OUT NOCOPY NUMBER,
128 x_party_site_id OUT NOCOPY NUMBER,
129 x_location_id OUT NOCOPY NUMBER
130 );
131
132 -- Notes: This API will not update any TCA records.
133 -- It will only update vendor site info.
134 -- This is because the procedure calls the corresponding procedure in
135 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
136 --
137 /*#
138 * This procedure updates a Supplier Site record in Payables. Notice
142 * @param p_vendor_site_rec Supplier Site info to be updated. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_SITE_REC_TYPE.
139 * the corresponding TCA Party Site record will not be updated.
140 * Upon successful validation this procedure updates the record but
141 * does not perform database commit.
143 * @param x_return_status Standard API return status
144 * @param x_msg_count Standard API message count
145 * @param x_msg_data Standard API message data
146 * @rep:displayname Update Supplier Site
147 * @rep:scope internal
148 * @rep:lifecycle deprecated
149 */
150 PROCEDURE Update_Vendor_Site
151 ( p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2
155 );
156
157 -- Notes:
158 -- p_mode: Indicates whether the calling code is in insert or update mode.
159 -- (I, U)
160 --
161 -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
162 -- (V, N, F) Valid, Null or False
163
164 /*#
165 * This procedure validates a Supplier Site record in Payables and TCA.
166 * If Supplier Site record is not valid the reason will be returned in the
167 * standard API output message. In addition the party site valid output
168 * indicates whether the TCA Party Site record is valid or not.
169 * @param p_vendor_site_rec Supplier Site info to be validated. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_SITE_REC_TYPE.
170 * @param p_mode Indicates the calling mode I = Insert, U = Update
171 * @param x_return_status Standard API return status
172 * @param x_msg_count Standard API message count
173 * @param x_msg_data Standard API message data
174 * @param x_party_site_valid V = valid TCA Party Site, F = invalid, N = not found
175 * @param x_location_valid V = valid TCA Location, F = invalid, N = not found
176 * @rep:displayname Validate Supplier Site
177 * @rep:scope internal
178 * @rep:lifecycle deprecated
179 */
180 PROCEDURE Validate_Vendor_Site
181 ( p_vendor_site_rec IN OUT NOCOPY AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
182 p_mode IN VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 x_party_site_valid OUT NOCOPY VARCHAR2,
187 x_location_valid OUT NOCOPY VARCHAR2
188 );
189
190 /*#
191 * This procedure creates a Supplier Site Contact record in Payables and TCA
192 * (Trading Community Architecture) with the input supplier site contact information.
193 * Upon successful validation this procedure posts the record(s) but
194 * does not perform database commit.
195 * @param p_vendor_contact_rec Supplier Site Contact info to be created. For more information, refer to AP_VENDOR_PUB_PKG.R_VENDOR_CONTACT_REC_TYPE.
196 * @param x_return_status Standard API return status
197 * @param x_msg_count Standard API message count
198 * @param x_msg_data Standard API message data
199 * @param x_vendor_contact_id The created Supplier Site Contact Identifier
200 * @param x_per_party_id The created or existing TCA Person Party Identifier
201 * @param x_rel_party_id The created or existing TCA Relationship Party Identifier
202 * @param x_rel_id The created or existing TCA Relationship Identifier
203 * @param x_org_contact_id The created or existing TCA Organization Contact Identifier
204 * @param x_party_site_id The created or existing TCA Party Site Identifier
205 * @rep:displayname Create Supplier Site Contact
206 */
207 PROCEDURE Create_Vendor_Contact
208 ( p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 x_vendor_contact_id OUT NOCOPY NUMBER,
213 x_per_party_id OUT NOCOPY NUMBER,
214 x_rel_party_id OUT NOCOPY NUMBER,
215 x_rel_id OUT NOCOPY NUMBER,
216 x_org_contact_id OUT NOCOPY NUMBER,
217 x_party_site_id OUT NOCOPY NUMBER
218 );
219
220 PROCEDURE Create_Vendor
221 (
222 p_vendor_id IN NUMBER DEFAULT NULL,
223 p_segment1 IN VARCHAR2 DEFAULT NULL,
224 p_vendor_name IN VARCHAR2 DEFAULT NULL,
225 p_vendor_name_alt IN VARCHAR2 DEFAULT NULL,
226 p_summary_flag IN VARCHAR2 DEFAULT NULL,
227 p_enabled_flag IN VARCHAR2 DEFAULT NULL,
228 p_segment2 IN VARCHAR2 DEFAULT NULL,
229 p_segment3 IN VARCHAR2 DEFAULT NULL,
230 p_segment4 IN VARCHAR2 DEFAULT NULL,
231 p_segment5 IN VARCHAR2 DEFAULT NULL,
232 p_employee_id IN NUMBER DEFAULT NULL,
233 p_vendor_type_lookup_code IN VARCHAR2 DEFAULT NULL,
234 p_customer_num IN VARCHAR2 DEFAULT NULL,
235 p_one_time_flag IN VARCHAR2 DEFAULT NULL,
236 p_parent_vendor_id IN NUMBER DEFAULT NULL,
237 p_min_order_amount IN NUMBER DEFAULT NULL,
238 p_terms_id IN NUMBER DEFAULT NULL,
239 p_set_of_books_id IN NUMBER DEFAULT NULL,
240 p_always_take_disc_flag IN VARCHAR2 DEFAULT NULL,
241 p_pay_date_basis_lookup_code IN VARCHAR2 DEFAULT NULL,
242 p_pay_group_lookup_code IN VARCHAR2 DEFAULT NULL,
243 p_payment_priority IN NUMBER DEFAULT NULL,
244 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
245 p_payment_currency_code IN VARCHAR2 DEFAULT NULL,
246 p_invoice_amount_limit IN NUMBER DEFAULT NULL,
250 p_type_1099 IN VARCHAR2 DEFAULT NULL,
247 p_hold_all_payments_flag IN VARCHAR2 DEFAULT NULL,
248 p_hold_future_payments_flag IN VARCHAR2 DEFAULT NULL,
249 p_hold_reason IN VARCHAR2 DEFAULT NULL,
251 p_withhold_status_lookup_code IN VARCHAR2 DEFAULT NULL,
252 p_withholding_start_date IN DATE DEFAULT NULL,
253 p_org_type_lookup_code IN VARCHAR2 DEFAULT NULL,
254 p_start_date_active IN DATE DEFAULT NULL,
255 p_end_date_active IN DATE DEFAULT NULL,
256 p_minority_group_lookup_code IN VARCHAR2 DEFAULT NULL,
257 p_women_owned_flag IN VARCHAR2 DEFAULT NULL,
258 p_small_business_flag IN VARCHAR2 DEFAULT NULL,
259 p_hold_flag IN VARCHAR2 DEFAULT NULL,
260 p_purchasing_hold_reason IN VARCHAR2 DEFAULT NULL,
261 p_hold_by IN NUMBER DEFAULT NULL,
262 p_hold_date IN DATE DEFAULT NULL,
263 p_terms_date_basis IN VARCHAR2 DEFAULT NULL,
264 p_inspection_required_flag IN VARCHAR2 DEFAULT NULL,
265 p_receipt_required_flag IN VARCHAR2 DEFAULT NULL,
266 p_qty_rcv_tolerance IN NUMBER DEFAULT NULL,
267 p_qty_rcv_exception_code IN VARCHAR2 DEFAULT NULL,
268 p_enforce_ship_to_loc_code IN VARCHAR2 DEFAULT NULL,
269 p_days_early_receipt_allowed IN NUMBER DEFAULT NULL,
270 p_days_late_receipt_allowed IN NUMBER DEFAULT NULL,
271 p_receipt_days_exception_code IN VARCHAR2 DEFAULT NULL,
272 p_receiving_routing_id IN NUMBER DEFAULT NULL,
273 p_allow_substi_receipts_flag IN VARCHAR2 DEFAULT NULL,
274 p_allow_unorder_receipts_flag IN VARCHAR2 DEFAULT NULL,
275 p_hold_unmatched_invoices_flag IN VARCHAR2 DEFAULT NULL,
276 p_tax_verification_date IN DATE DEFAULT NULL,
277 p_name_control IN VARCHAR2 DEFAULT NULL,
278 p_state_reportable_flag IN VARCHAR2 DEFAULT NULL,
279 p_federal_reportable_flag IN VARCHAR2 DEFAULT NULL,
280 p_attribute_category IN VARCHAR2 DEFAULT NULL,
281 p_attribute1 IN VARCHAR2 DEFAULT NULL,
282 p_attribute2 IN VARCHAR2 DEFAULT NULL,
283 p_attribute3 IN VARCHAR2 DEFAULT NULL,
284 p_attribute4 IN VARCHAR2 DEFAULT NULL,
285 p_attribute5 IN VARCHAR2 DEFAULT NULL,
286 p_attribute6 IN VARCHAR2 DEFAULT NULL,
287 p_attribute7 IN VARCHAR2 DEFAULT NULL,
288 p_attribute8 IN VARCHAR2 DEFAULT NULL,
289 p_attribute9 IN VARCHAR2 DEFAULT NULL,
290 p_attribute10 IN VARCHAR2 DEFAULT NULL,
291 p_attribute11 IN VARCHAR2 DEFAULT NULL,
292 p_attribute12 IN VARCHAR2 DEFAULT NULL,
293 p_attribute13 IN VARCHAR2 DEFAULT NULL,
294 p_attribute14 IN VARCHAR2 DEFAULT NULL,
295 p_attribute15 IN VARCHAR2 DEFAULT NULL,
296 p_auto_calculate_interest_flag IN VARCHAR2 DEFAULT NULL,
297 p_validation_number IN NUMBER DEFAULT NULL,
298 p_exclude_freight_from_discnt IN VARCHAR2 DEFAULT NULL,
299 p_tax_reporting_name IN VARCHAR2 DEFAULT NULL,
300 p_check_digits IN VARCHAR2 DEFAULT NULL,
301 p_allow_awt_flag IN VARCHAR2 DEFAULT NULL,
302 p_awt_group_id IN NUMBER DEFAULT NULL,
303 p_pay_awt_group_id IN NUMBER DEFAULT NULL,
304 p_awt_group_name IN VARCHAR2 DEFAULT NULL,
305 p_pay_awt_group_name IN VARCHAR2 DEFAULT NULL,
306 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
307 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
308 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
309 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
310 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
311 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
312 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
313 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
314 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
315 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
316 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
317 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
318 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
319 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
320 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
321 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
322 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
323 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
324 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
325 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
326 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
327 p_bank_charge_bearer IN VARCHAR2 DEFAULT NULL,
328 p_bank_branch_type IN VARCHAR2 DEFAULT NULL,
329 p_match_option IN VARCHAR2 DEFAULT NULL,
330 p_create_debit_memo_flag IN VARCHAR2 DEFAULT NULL,
331 p_party_id IN NUMBER DEFAULT NULL,
332 p_parent_party_id IN NUMBER DEFAULT NULL,
333 p_jgzz_fiscal_code IN VARCHAR2 DEFAULT NULL,
334 p_sic_code IN VARCHAR2 DEFAULT NULL,
335 p_tax_reference IN VARCHAR2 DEFAULT NULL,
336 p_inventory_organization_id IN NUMBER DEFAULT NULL,
337 p_terms_name IN VARCHAR2 DEFAULT NULL,
338 p_default_terms_id IN NUMBER DEFAULT NULL,
342 x_vendor_id OUT NOCOPY NUMBER,
339 p_ni_number IN VARCHAR2 DEFAULT NULL,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_error_msg OUT NOCOPY VARCHAR2,
343 x_party_id OUT NOCOPY NUMBER
344 );
345
346 -- Notes: This API will not update any TCA tables. It updates vendor info only.
347 -- This is because the procedure calls the corresponding procedure in
348 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
349 PROCEDURE Update_Vendor
350 (
351 p_vendor_id IN NUMBER ,
352 p_segment1 IN VARCHAR2 ,
353 p_vendor_name IN VARCHAR2 ,
354 p_vendor_name_alt IN VARCHAR2 ,
355 p_summary_flag IN VARCHAR2 ,
356 p_enabled_flag IN VARCHAR2 ,
357 p_segment2 IN VARCHAR2 ,
358 p_segment3 IN VARCHAR2 ,
359 p_segment4 IN VARCHAR2 ,
360 p_segment5 IN VARCHAR2 ,
361 p_employee_id IN NUMBER ,
362 p_vendor_type_lookup_code IN VARCHAR2 ,
363 p_customer_num IN VARCHAR2 ,
364 p_one_time_flag IN VARCHAR2 ,
365 p_parent_vendor_id IN NUMBER ,
366 p_min_order_amount IN NUMBER ,
367 p_terms_id IN NUMBER ,
368 p_set_of_books_id IN NUMBER ,
369 p_always_take_disc_flag IN VARCHAR2 ,
370 p_pay_date_basis_lookup_code IN VARCHAR2 ,
371 p_pay_group_lookup_code IN VARCHAR2 ,
372 p_payment_priority IN NUMBER ,
373 p_invoice_currency_code IN VARCHAR2 ,
374 p_payment_currency_code IN VARCHAR2 ,
375 p_invoice_amount_limit IN NUMBER ,
376 p_hold_all_payments_flag IN VARCHAR2 ,
377 p_hold_future_payments_flag IN VARCHAR2 ,
378 p_hold_reason IN VARCHAR2 ,
379 p_type_1099 IN VARCHAR2 ,
380 p_withhold_status_lookup_code IN VARCHAR2 ,
381 p_withholding_start_date IN DATE ,
382 p_org_type_lookup_code IN VARCHAR2 ,
383 p_start_date_active IN DATE ,
384 p_end_date_active IN DATE ,
385 p_minority_group_lookup_code IN VARCHAR2 ,
386 p_women_owned_flag IN VARCHAR2 ,
387 p_small_business_flag IN VARCHAR2 ,
388 p_hold_flag IN VARCHAR2 ,
389 p_purchasing_hold_reason IN VARCHAR2 ,
390 p_hold_by IN NUMBER ,
391 p_hold_date IN DATE ,
392 p_terms_date_basis IN VARCHAR2 ,
393 p_inspection_required_flag IN VARCHAR2 ,
394 p_receipt_required_flag IN VARCHAR2 ,
395 p_qty_rcv_tolerance IN NUMBER ,
396 p_qty_rcv_exception_code IN VARCHAR2 ,
397 p_enforce_ship_to_loc_code IN VARCHAR2 ,
398 p_days_early_receipt_allowed IN NUMBER ,
399 p_days_late_receipt_allowed IN NUMBER ,
400 p_receipt_days_exception_code IN VARCHAR2 ,
401 p_receiving_routing_id IN NUMBER ,
402 p_allow_substi_receipts_flag IN VARCHAR2 ,
403 p_allow_unorder_receipts_flag IN VARCHAR2 ,
404 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
405 p_tax_verification_date IN DATE ,
406 p_name_control IN VARCHAR2 ,
407 p_state_reportable_flag IN VARCHAR2 ,
408 p_federal_reportable_flag IN VARCHAR2 ,
409 p_attribute_category IN VARCHAR2 ,
410 p_attribute1 IN VARCHAR2 ,
411 p_attribute2 IN VARCHAR2 ,
412 p_attribute3 IN VARCHAR2 ,
413 p_attribute4 IN VARCHAR2 ,
414 p_attribute5 IN VARCHAR2 ,
415 p_attribute6 IN VARCHAR2 ,
416 p_attribute7 IN VARCHAR2 ,
417 p_attribute8 IN VARCHAR2 ,
418 p_attribute9 IN VARCHAR2 ,
419 p_attribute10 IN VARCHAR2 ,
420 p_attribute11 IN VARCHAR2 ,
421 p_attribute12 IN VARCHAR2 ,
422 p_attribute13 IN VARCHAR2 ,
423 p_attribute14 IN VARCHAR2 ,
424 p_attribute15 IN VARCHAR2 ,
425 p_auto_calculate_interest_flag IN VARCHAR2 ,
426 p_validation_number IN NUMBER ,
427 p_exclude_freight_from_discnt IN VARCHAR2 ,
428 p_tax_reporting_name IN VARCHAR2 ,
429 p_check_digits IN VARCHAR2 ,
430 p_allow_awt_flag IN VARCHAR2 ,
431 p_awt_group_id IN NUMBER ,
432 p_pay_awt_group_id IN NUMBER ,
433 p_awt_group_name IN VARCHAR2 ,
434 p_pay_awt_group_name IN VARCHAR2 ,
435 p_global_attribute1 IN VARCHAR2 ,
436 p_global_attribute2 IN VARCHAR2 ,
437 p_global_attribute3 IN VARCHAR2 ,
438 p_global_attribute4 IN VARCHAR2 ,
439 p_global_attribute5 IN VARCHAR2 ,
440 p_global_attribute6 IN VARCHAR2 ,
441 p_global_attribute7 IN VARCHAR2 ,
442 p_global_attribute8 IN VARCHAR2 ,
443 p_global_attribute9 IN VARCHAR2 ,
444 p_global_attribute10 IN VARCHAR2 ,
445 p_global_attribute11 IN VARCHAR2 ,
446 p_global_attribute12 IN VARCHAR2 ,
447 p_global_attribute13 IN VARCHAR2 ,
451 p_global_attribute17 IN VARCHAR2 ,
448 p_global_attribute14 IN VARCHAR2 ,
449 p_global_attribute15 IN VARCHAR2 ,
450 p_global_attribute16 IN VARCHAR2 ,
452 p_global_attribute18 IN VARCHAR2 ,
453 p_global_attribute19 IN VARCHAR2 ,
454 p_global_attribute20 IN VARCHAR2 ,
455 p_global_attribute_category IN VARCHAR2 ,
456 p_bank_charge_bearer IN VARCHAR2 ,
457 p_bank_branch_type IN VARCHAR2 ,
458 p_match_option IN VARCHAR2 ,
459 p_create_debit_memo_flag IN VARCHAR2 ,
460 p_party_id IN NUMBER ,
461 p_parent_party_id IN NUMBER ,
462 p_jgzz_fiscal_code IN VARCHAR2 ,
463 p_sic_code IN VARCHAR2 ,
464 p_tax_reference IN VARCHAR2 ,
465 p_inventory_organization_id IN NUMBER ,
466 p_terms_name IN VARCHAR2 ,
467 p_default_terms_id IN NUMBER ,
468 p_ni_number IN VARCHAR2 ,
469 p_last_update_date IN DATE DEFAULT NULL,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_error_msg OUT NOCOPY VARCHAR2
472 );
473
474 -- Notes:
475 -- p_mode: Indicates whether the calling code is in insert or update mode.
476 -- (I, U)
477 --
478 -- p_party_valid: Indicates how valid the calling program's party_id was
479 -- (V, N, F) Valid, Null or False
480
481 PROCEDURE Validate_Vendor
482 (
483 p_vendor_id IN NUMBER ,
484 p_segment1 IN VARCHAR2 ,
485 p_vendor_name IN VARCHAR2 ,
486 p_vendor_name_alt IN VARCHAR2 ,
487 p_summary_flag IN VARCHAR2 ,
488 p_enabled_flag IN VARCHAR2 ,
489 p_segment2 IN VARCHAR2 ,
490 p_segment3 IN VARCHAR2 ,
491 p_segment4 IN VARCHAR2 ,
492 p_segment5 IN VARCHAR2 ,
493 p_employee_id IN NUMBER ,
494 p_vendor_type_lookup_code IN VARCHAR2 ,
495 p_customer_num IN VARCHAR2 ,
496 p_one_time_flag IN VARCHAR2 ,
497 p_parent_vendor_id IN NUMBER ,
498 p_min_order_amount IN NUMBER ,
499 p_terms_id IN NUMBER ,
500 p_set_of_books_id IN NUMBER ,
501 p_always_take_disc_flag IN VARCHAR2 ,
502 p_pay_date_basis_lookup_code IN VARCHAR2 ,
503 p_pay_group_lookup_code IN VARCHAR2 ,
504 p_payment_priority IN NUMBER ,
505 p_invoice_currency_code IN VARCHAR2 ,
506 p_payment_currency_code IN VARCHAR2 ,
507 p_invoice_amount_limit IN NUMBER ,
508 p_hold_all_payments_flag IN VARCHAR2 ,
509 p_hold_future_payments_flag IN VARCHAR2 ,
510 p_hold_reason IN VARCHAR2 ,
511 p_type_1099 IN VARCHAR2 ,
512 p_withhold_status_lookup_code IN VARCHAR2 ,
513 p_withholding_start_date IN DATE ,
514 p_org_type_lookup_code IN VARCHAR2 ,
515 p_start_date_active IN DATE ,
516 p_end_date_active IN DATE ,
517 p_minority_group_lookup_code IN VARCHAR2 ,
518 p_women_owned_flag IN VARCHAR2 ,
519 p_small_business_flag IN VARCHAR2 ,
520 p_hold_flag IN VARCHAR2 ,
521 p_purchasing_hold_reason IN VARCHAR2 ,
522 p_hold_by IN NUMBER ,
523 p_hold_date IN DATE ,
524 p_terms_date_basis IN VARCHAR2 ,
525 p_inspection_required_flag IN VARCHAR2 ,
526 p_receipt_required_flag IN VARCHAR2 ,
527 p_qty_rcv_tolerance IN NUMBER ,
528 p_qty_rcv_exception_code IN VARCHAR2 ,
529 p_enforce_ship_to_loc_code IN VARCHAR2 ,
530 p_days_early_receipt_allowed IN NUMBER ,
531 p_days_late_receipt_allowed IN NUMBER ,
532 p_receipt_days_exception_code IN VARCHAR2 ,
533 p_receiving_routing_id IN NUMBER ,
534 p_allow_substi_receipts_flag IN VARCHAR2 ,
535 p_allow_unorder_receipts_flag IN VARCHAR2 ,
536 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
537 p_tax_verification_date IN DATE ,
538 p_name_control IN VARCHAR2 ,
539 p_state_reportable_flag IN VARCHAR2 ,
540 p_federal_reportable_flag IN VARCHAR2 ,
541 p_attribute_category IN VARCHAR2 ,
542 p_attribute1 IN VARCHAR2 ,
543 p_attribute2 IN VARCHAR2 ,
544 p_attribute3 IN VARCHAR2 ,
545 p_attribute4 IN VARCHAR2 ,
546 p_attribute5 IN VARCHAR2 ,
547 p_attribute6 IN VARCHAR2 ,
548 p_attribute7 IN VARCHAR2 ,
549 p_attribute8 IN VARCHAR2 ,
550 p_attribute9 IN VARCHAR2 ,
551 p_attribute10 IN VARCHAR2 ,
552 p_attribute11 IN VARCHAR2 ,
553 p_attribute12 IN VARCHAR2 ,
554 p_attribute13 IN VARCHAR2 ,
555 p_attribute14 IN VARCHAR2 ,
556 p_attribute15 IN VARCHAR2 ,
557 p_auto_calculate_interest_flag IN VARCHAR2 ,
558 p_validation_number IN NUMBER ,
559 p_exclude_freight_from_discnt IN VARCHAR2 ,
560 p_tax_reporting_name IN VARCHAR2 ,
561 p_check_digits IN VARCHAR2 ,
562 p_allow_awt_flag IN VARCHAR2 ,
563 p_awt_group_id IN NUMBER ,
564 p_pay_awt_group_id IN NUMBER ,
565 p_awt_group_name IN VARCHAR2 ,
566 p_pay_awt_group_name IN VARCHAR2 ,
567 p_global_attribute1 IN VARCHAR2 ,
568 p_global_attribute2 IN VARCHAR2 ,
569 p_global_attribute3 IN VARCHAR2 ,
570 p_global_attribute4 IN VARCHAR2 ,
571 p_global_attribute5 IN VARCHAR2 ,
572 p_global_attribute6 IN VARCHAR2 ,
573 p_global_attribute7 IN VARCHAR2 ,
574 p_global_attribute8 IN VARCHAR2 ,
575 p_global_attribute9 IN VARCHAR2 ,
576 p_global_attribute10 IN VARCHAR2 ,
577 p_global_attribute11 IN VARCHAR2 ,
578 p_global_attribute12 IN VARCHAR2 ,
579 p_global_attribute13 IN VARCHAR2 ,
580 p_global_attribute14 IN VARCHAR2 ,
581 p_global_attribute15 IN VARCHAR2 ,
582 p_global_attribute16 IN VARCHAR2 ,
583 p_global_attribute17 IN VARCHAR2 ,
584 p_global_attribute18 IN VARCHAR2 ,
585 p_global_attribute19 IN VARCHAR2 ,
586 p_global_attribute20 IN VARCHAR2 ,
587 p_global_attribute_category IN VARCHAR2 ,
588 p_bank_charge_bearer IN VARCHAR2 ,
589 p_bank_branch_type IN VARCHAR2 ,
590 p_match_option IN VARCHAR2 ,
591 p_create_debit_memo_flag IN VARCHAR2 ,
592 p_party_id IN NUMBER ,
593 p_parent_party_id IN NUMBER ,
594 p_jgzz_fiscal_code IN VARCHAR2 ,
595 p_sic_code IN VARCHAR2 ,
596 p_tax_reference IN VARCHAR2 ,
597 p_inventory_organization_id IN NUMBER ,
598 p_terms_name IN VARCHAR2 ,
599 p_default_terms_id IN NUMBER ,
600 p_ni_number IN VARCHAR2 ,
601 p_mode IN VARCHAR2,
602 x_return_status OUT NOCOPY VARCHAR2,
603 x_error_msg OUT NOCOPY VARCHAR2,
604 x_party_valid OUT NOCOPY VARCHAR2
605 );
606
607 PROCEDURE Create_Vendor_Site
608 (
609 p_area_code IN VARCHAR2 DEFAULT NULL,
610 p_phone IN VARCHAR2 DEFAULT NULL,
611 p_customer_num IN VARCHAR2 DEFAULT NULL,
612 p_ship_to_location_id IN NUMBER DEFAULT NULL,
613 p_bill_to_location_id IN NUMBER DEFAULT NULL,
614 p_ship_via_lookup_code IN VARCHAR2 DEFAULT NULL,
615 p_freight_terms_lookup_code IN VARCHAR2 DEFAULT NULL,
616 p_fob_lookup_code IN VARCHAR2 DEFAULT NULL,
617 p_inactive_date IN DATE DEFAULT NULL,
618 p_fax IN VARCHAR2 DEFAULT NULL,
619 p_fax_area_code IN VARCHAR2 DEFAULT NULL,
620 p_telex IN VARCHAR2 DEFAULT NULL,
621 p_terms_date_basis IN VARCHAR2 DEFAULT NULL,
622 p_distribution_set_id IN NUMBER DEFAULT NULL,
623 p_accts_pay_code_combo_id IN NUMBER DEFAULT NULL,
624 p_prepay_code_combination_id IN NUMBER DEFAULT NULL,
625 p_pay_group_lookup_code IN VARCHAR2 DEFAULT NULL,
626 p_payment_method_lookup_code IN VARCHAR2 DEFAULT NULL,
627 p_payment_priority IN NUMBER DEFAULT NULL,
628 p_terms_id IN NUMBER DEFAULT NULL,
629 p_invoice_amount_limit IN NUMBER DEFAULT NULL,
630 p_pay_date_basis_lookup_code IN VARCHAR2 DEFAULT NULL,
631 p_always_take_disc_flag IN VARCHAR2 DEFAULT NULL,
632 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
633 p_payment_currency_code IN VARCHAR2 DEFAULT NULL,
634 p_vendor_site_id IN NUMBER DEFAULT NULL,
635 p_last_update_date IN DATE DEFAULT NULL,
636 p_last_updated_by IN NUMBER DEFAULT NULL,
637 p_vendor_id IN NUMBER DEFAULT NULL,
638 p_vendor_site_code IN VARCHAR2 DEFAULT NULL,
639 p_vendor_site_code_alt IN VARCHAR2 DEFAULT NULL,
640 p_purchasing_site_flag IN VARCHAR2 DEFAULT NULL,
641 p_rfq_only_site_flag IN VARCHAR2 DEFAULT NULL,
642 p_pay_site_flag IN VARCHAR2 DEFAULT NULL,
643 p_attention_ar_flag IN VARCHAR2 DEFAULT NULL,
644 p_hold_all_payments_flag IN VARCHAR2 DEFAULT NULL,
648 p_tax_reporting_site_flag IN VARCHAR2 DEFAULT NULL,
645 p_hold_future_payments_flag IN VARCHAR2 DEFAULT NULL,
646 p_hold_reason IN VARCHAR2 DEFAULT NULL,
647 p_hold_unmatched_invoices_flag IN VARCHAR2 DEFAULT NULL,
649 p_attribute_category IN VARCHAR2 DEFAULT NULL,
650 p_attribute1 IN VARCHAR2 DEFAULT NULL,
651 p_attribute2 IN VARCHAR2 DEFAULT NULL,
652 p_attribute3 IN VARCHAR2 DEFAULT NULL,
653 p_attribute4 IN VARCHAR2 DEFAULT NULL,
654 p_attribute5 IN VARCHAR2 DEFAULT NULL,
655 p_attribute6 IN VARCHAR2 DEFAULT NULL,
656 p_attribute7 IN VARCHAR2 DEFAULT NULL,
657 p_attribute8 IN VARCHAR2 DEFAULT NULL,
658 p_attribute9 IN VARCHAR2 DEFAULT NULL,
659 p_attribute10 IN VARCHAR2 DEFAULT NULL,
660 p_attribute11 IN VARCHAR2 DEFAULT NULL,
661 p_attribute12 IN VARCHAR2 DEFAULT NULL,
662 p_attribute13 IN VARCHAR2 DEFAULT NULL,
663 p_attribute14 IN VARCHAR2 DEFAULT NULL,
664 p_attribute15 IN VARCHAR2 DEFAULT NULL,
665 p_validation_number IN NUMBER DEFAULT NULL,
666 p_exclude_freight_from_discnt IN VARCHAR2 DEFAULT NULL,
667 p_bank_charge_bearer IN VARCHAR2 DEFAULT NULL,
668 p_org_id IN NUMBER DEFAULT NULL,
669 p_check_digits IN VARCHAR2 DEFAULT NULL,
670 p_allow_awt_flag IN VARCHAR2 DEFAULT NULL,
671 p_awt_group_id IN NUMBER DEFAULT NULL,
672 p_pay_awt_group_id IN NUMBER DEFAULT NULL,
673 p_default_pay_site_id IN NUMBER DEFAULT NULL,
674 p_pay_on_code IN VARCHAR2 DEFAULT NULL,
675 p_pay_on_receipt_summary_code IN VARCHAR2 DEFAULT NULL,
676 p_global_attribute_category IN VARCHAR2 DEFAULT NULL,
677 p_global_attribute1 IN VARCHAR2 DEFAULT NULL,
678 p_global_attribute2 IN VARCHAR2 DEFAULT NULL,
679 p_global_attribute3 IN VARCHAR2 DEFAULT NULL,
680 p_global_attribute4 IN VARCHAR2 DEFAULT NULL,
681 p_global_attribute5 IN VARCHAR2 DEFAULT NULL,
682 p_global_attribute6 IN VARCHAR2 DEFAULT NULL,
683 p_global_attribute7 IN VARCHAR2 DEFAULT NULL,
684 p_global_attribute8 IN VARCHAR2 DEFAULT NULL,
685 p_global_attribute9 IN VARCHAR2 DEFAULT NULL,
686 p_global_attribute10 IN VARCHAR2 DEFAULT NULL,
687 p_global_attribute11 IN VARCHAR2 DEFAULT NULL,
688 p_global_attribute12 IN VARCHAR2 DEFAULT NULL,
689 p_global_attribute13 IN VARCHAR2 DEFAULT NULL,
690 p_global_attribute14 IN VARCHAR2 DEFAULT NULL,
691 p_global_attribute15 IN VARCHAR2 DEFAULT NULL,
692 p_global_attribute16 IN VARCHAR2 DEFAULT NULL,
693 p_global_attribute17 IN VARCHAR2 DEFAULT NULL,
694 p_global_attribute18 IN VARCHAR2 DEFAULT NULL,
695 p_global_attribute19 IN VARCHAR2 DEFAULT NULL,
696 p_global_attribute20 IN VARCHAR2 DEFAULT NULL,
697 p_tp_header_id IN NUMBER DEFAULT NULL,
698 p_edi_id_number IN VARCHAR2 DEFAULT NULL,
699 p_ece_tp_location_code IN VARCHAR2 DEFAULT NULL,
700 p_pcard_site_flag IN VARCHAR2 DEFAULT NULL,
701 p_match_option IN VARCHAR2 DEFAULT NULL,
702 p_country_of_origin_code IN VARCHAR2 DEFAULT NULL,
703 p_future_dated_payment_ccid IN NUMBER DEFAULT NULL,
704 p_create_debit_memo_flag IN VARCHAR2 DEFAULT NULL,
705 p_supplier_notif_method IN VARCHAR2 DEFAULT NULL,
706 p_email_address IN VARCHAR2 DEFAULT NULL,
707 p_primary_pay_site_flag IN VARCHAR2 DEFAULT NULL,
708 p_shipping_control IN VARCHAR2 DEFAULT NULL,
709 p_selling_company_identifier IN VARCHAR2 DEFAULT NULL,
710 p_gapless_inv_num_flag IN VARCHAR2 DEFAULT NULL,
711 p_location_id IN NUMBER DEFAULT NULL,
712 p_party_site_id IN NUMBER DEFAULT NULL,
713 p_org_name IN VARCHAR2 DEFAULT NULL,
714 p_duns_number IN VARCHAR2 DEFAULT NULL,
715 p_address_style IN VARCHAR2 DEFAULT NULL,
716 p_language IN VARCHAR2 DEFAULT NULL,
717 p_province IN VARCHAR2 DEFAULT NULL,
718 p_country IN VARCHAR2 DEFAULT NULL,
719 p_address_line1 IN VARCHAR2 ,
720 p_address_line2 IN VARCHAR2 DEFAULT NULL,
721 p_address_line3 IN VARCHAR2 DEFAULT NULL,
722 p_address_line4 IN VARCHAR2 DEFAULT NULL,
723 p_address_lines_alt IN VARCHAR2 DEFAULT NULL,
724 p_county IN VARCHAR2 DEFAULT NULL,
725 p_city IN VARCHAR2 DEFAULT NULL,
726 p_state IN VARCHAR2 DEFAULT NULL,
727 p_zip IN VARCHAR2 DEFAULT NULL,
728 p_terms_name IN VARCHAR2 DEFAULT NULL,
729 p_default_terms_id IN NUMBER DEFAULT NULL,
730 p_awt_group_name IN VARCHAR2 DEFAULT NULL,
731 p_pay_awt_group_name IN VARCHAR2 DEFAULT NULL,
732 p_distribution_set_name IN VARCHAR2 DEFAULT NULL,
733 p_ship_to_location_code IN VARCHAR2 DEFAULT NULL,
734 p_bill_to_location_code IN VARCHAR2 DEFAULT NULL,
735 p_default_dist_set_id IN NUMBER DEFAULT NULL,
736 p_default_ship_to_loc_id IN NUMBER DEFAULT NULL,
737 p_default_bill_to_loc_id IN NUMBER DEFAULT NULL,
741 p_service_tolerance_id IN NUMBER DEFAULT NULL,
738 p_tolerance_id IN NUMBER DEFAULT NULL,
739 p_tolerance_name IN VARCHAR2 DEFAULT NULL,
740 p_retainage_rate IN NUMBER DEFAULT NULL,
742 x_return_status OUT NOCOPY VARCHAR2,
743 x_error_msg OUT NOCOPY VARCHAR2,
744 x_vendor_site_id OUT NOCOPY NUMBER,
745 x_party_site_id OUT NOCOPY NUMBER,
746 x_location_id OUT NOCOPY NUMBER
747 );
748
749 -- Notes: This API will not update any TCA records.
750 -- It will only update vendor site info.
751 -- This is because the procedure calls the corresponding procedure in
752 -- AP_VENDOR_PUB_PKG which does not update TCA tables.
753 --
754 PROCEDURE Update_Vendor_Site
755 (
756 p_area_code IN VARCHAR2 ,
757 p_phone IN VARCHAR2 ,
758 p_customer_num IN VARCHAR2 ,
759 p_ship_to_location_id IN NUMBER ,
760 p_bill_to_location_id IN NUMBER ,
761 p_ship_via_lookup_code IN VARCHAR2 ,
762 p_freight_terms_lookup_code IN VARCHAR2 ,
763 p_fob_lookup_code IN VARCHAR2 ,
764 p_inactive_date IN DATE ,
765 p_fax IN VARCHAR2 ,
766 p_fax_area_code IN VARCHAR2 ,
767 p_telex IN VARCHAR2 ,
768 p_terms_date_basis IN VARCHAR2 ,
769 p_distribution_set_id IN NUMBER ,
770 p_accts_pay_code_combo_id IN NUMBER ,
771 p_prepay_code_combination_id IN NUMBER ,
772 p_pay_group_lookup_code IN VARCHAR2 ,
773 p_payment_priority IN NUMBER ,
774 p_terms_id IN NUMBER ,
775 p_invoice_amount_limit IN NUMBER ,
776 p_pay_date_basis_lookup_code IN VARCHAR2 ,
777 p_always_take_disc_flag IN VARCHAR2 ,
778 p_invoice_currency_code IN VARCHAR2 ,
779 p_payment_currency_code IN VARCHAR2 ,
780 p_vendor_site_id IN NUMBER ,
781 p_last_update_date IN DATE ,
782 p_last_updated_by IN NUMBER ,
783 p_vendor_id IN NUMBER ,
784 p_vendor_site_code IN VARCHAR2 ,
785 p_vendor_site_code_alt IN VARCHAR2 ,
786 p_purchasing_site_flag IN VARCHAR2 ,
787 p_rfq_only_site_flag IN VARCHAR2 ,
788 p_pay_site_flag IN VARCHAR2 ,
789 p_attention_ar_flag IN VARCHAR2 ,
790 p_hold_all_payments_flag IN VARCHAR2 ,
791 p_hold_future_payments_flag IN VARCHAR2 ,
792 p_hold_reason IN VARCHAR2 ,
793 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
794 p_tax_reporting_site_flag IN VARCHAR2 ,
795 p_attribute_category IN VARCHAR2 ,
796 p_attribute1 IN VARCHAR2 ,
797 p_attribute2 IN VARCHAR2 ,
798 p_attribute3 IN VARCHAR2 ,
799 p_attribute4 IN VARCHAR2 ,
800 p_attribute5 IN VARCHAR2 ,
801 p_attribute6 IN VARCHAR2 ,
802 p_attribute7 IN VARCHAR2 ,
803 p_attribute8 IN VARCHAR2 ,
804 p_attribute9 IN VARCHAR2 ,
805 p_attribute10 IN VARCHAR2 ,
806 p_attribute11 IN VARCHAR2 ,
807 p_attribute12 IN VARCHAR2 ,
808 p_attribute13 IN VARCHAR2 ,
809 p_attribute14 IN VARCHAR2 ,
810 p_attribute15 IN VARCHAR2 ,
811 p_validation_number IN NUMBER ,
812 p_exclude_freight_from_discnt IN VARCHAR2 ,
813 p_bank_charge_bearer IN VARCHAR2 ,
814 p_org_id IN NUMBER ,
815 p_check_digits IN VARCHAR2 ,
816 p_allow_awt_flag IN VARCHAR2 ,
817 p_awt_group_id IN NUMBER ,
818 p_pay_awt_group_id IN NUMBER ,
819 p_default_pay_site_id IN NUMBER ,
820 p_pay_on_code IN VARCHAR2 ,
821 p_pay_on_receipt_summary_code IN VARCHAR2 ,
822 p_global_attribute_category IN VARCHAR2 ,
823 p_global_attribute1 IN VARCHAR2 ,
824 p_global_attribute2 IN VARCHAR2 ,
825 p_global_attribute3 IN VARCHAR2 ,
826 p_global_attribute4 IN VARCHAR2 ,
827 p_global_attribute5 IN VARCHAR2 ,
828 p_global_attribute6 IN VARCHAR2 ,
829 p_global_attribute7 IN VARCHAR2 ,
830 p_global_attribute8 IN VARCHAR2 ,
831 p_global_attribute9 IN VARCHAR2 ,
832 p_global_attribute10 IN VARCHAR2 ,
833 p_global_attribute11 IN VARCHAR2 ,
834 p_global_attribute12 IN VARCHAR2 ,
835 p_global_attribute13 IN VARCHAR2 ,
836 p_global_attribute14 IN VARCHAR2 ,
837 p_global_attribute15 IN VARCHAR2 ,
838 p_global_attribute16 IN VARCHAR2 ,
839 p_global_attribute17 IN VARCHAR2 ,
840 p_global_attribute18 IN VARCHAR2 ,
841 p_global_attribute19 IN VARCHAR2 ,
842 p_global_attribute20 IN VARCHAR2 ,
843 p_tp_header_id IN NUMBER ,
844 p_edi_id_number IN VARCHAR2 ,
845 p_ece_tp_location_code IN VARCHAR2 ,
846 p_pcard_site_flag IN VARCHAR2 ,
847 p_match_option IN VARCHAR2 ,
851 p_supplier_notif_method IN VARCHAR2 ,
848 p_country_of_origin_code IN VARCHAR2 ,
849 p_future_dated_payment_ccid IN NUMBER ,
850 p_create_debit_memo_flag IN VARCHAR2 ,
852 p_email_address IN VARCHAR2 ,
853 p_primary_pay_site_flag IN VARCHAR2 ,
854 p_shipping_control IN VARCHAR2 ,
855 p_selling_company_identifier IN VARCHAR2 ,
856 p_gapless_inv_num_flag IN VARCHAR2 ,
857 p_location_id IN NUMBER ,
858 p_party_site_id IN NUMBER ,
859 p_org_name IN VARCHAR2 ,
860 p_duns_number IN VARCHAR2 ,
861 p_address_style IN VARCHAR2 ,
862 p_language IN VARCHAR2 ,
863 p_province IN VARCHAR2 ,
864 p_country IN VARCHAR2 ,
865 p_address_line1 IN VARCHAR2 ,
866 p_address_line2 IN VARCHAR2 ,
867 p_address_line3 IN VARCHAR2 ,
868 p_address_line4 IN VARCHAR2 ,
869 p_address_lines_alt IN VARCHAR2 ,
870 p_county IN VARCHAR2 ,
871 p_city IN VARCHAR2 ,
872 p_state IN VARCHAR2 ,
873 p_zip IN VARCHAR2 ,
874 p_terms_name IN VARCHAR2 ,
875 p_default_terms_id IN NUMBER ,
876 p_awt_group_name IN VARCHAR2 ,
877 p_pay_awt_group_name IN VARCHAR2 ,
878 p_distribution_set_name IN VARCHAR2 ,
879 p_ship_to_location_code IN VARCHAR2 ,
880 p_bill_to_location_code IN VARCHAR2 ,
881 p_default_dist_set_id IN NUMBER ,
882 p_default_ship_to_loc_id IN NUMBER ,
883 p_default_bill_to_loc_id IN NUMBER ,
884 p_tolerance_id IN NUMBER ,
885 p_tolerance_name IN VARCHAR2 ,
886 p_retainage_rate IN NUMBER ,
887 p_service_tolerance_id IN NUMBER ,
888 p_ship_network_loc_id IN NUMBER ,
889 p_cage_code IN VARCHAR2,
890 p_legal_business_name IN VARCHAR2,
891 p_doing_business_as IN VARCHAR2,
892 p_division_name IN VARCHAR2,
893 p_small_bus_code IN VARCHAR2,
894 p_ccr_comments IN VARCHAR2,
895 p_dbr_st_date IN DATE,
896 p_dbr_ed_date IN DATE,
897 x_return_status OUT NOCOPY VARCHAR2,
898 x_error_msg OUT NOCOPY VARCHAR2
899 );
900
901 -- Notes:
902 -- p_mode: Indicates whether the calling code is in insert or update mode.
903 -- (I, U)
904 --
905 -- x_party_site_valid: Indicates how valid the calling program's party_site_id was
906 -- (V, N, F) Valid, Null or False
907
908 PROCEDURE Validate_Vendor_Site
909 (
910 p_area_code IN VARCHAR2 ,
911 p_phone IN VARCHAR2 ,
912 p_customer_num IN VARCHAR2 ,
913 p_ship_to_location_id IN NUMBER ,
914 p_bill_to_location_id IN NUMBER ,
915 p_ship_via_lookup_code IN VARCHAR2 ,
916 p_freight_terms_lookup_code IN VARCHAR2 ,
917 p_fob_lookup_code IN VARCHAR2 ,
918 p_inactive_date IN DATE ,
919 p_fax IN VARCHAR2 ,
920 p_fax_area_code IN VARCHAR2 ,
921 p_telex IN VARCHAR2 ,
922 p_terms_date_basis IN VARCHAR2 ,
923 p_distribution_set_id IN NUMBER ,
924 p_accts_pay_code_combo_id IN NUMBER ,
925 p_prepay_code_combination_id IN NUMBER ,
926 p_pay_group_lookup_code IN VARCHAR2 ,
927 p_payment_priority IN NUMBER ,
928 p_terms_id IN NUMBER ,
929 p_invoice_amount_limit IN NUMBER ,
930 p_pay_date_basis_lookup_code IN VARCHAR2 ,
931 p_always_take_disc_flag IN VARCHAR2 ,
932 p_invoice_currency_code IN VARCHAR2 ,
933 p_payment_currency_code IN VARCHAR2 ,
934 p_vendor_site_id IN NUMBER ,
935 p_last_update_date IN DATE ,
936 p_last_updated_by IN NUMBER ,
937 p_vendor_id IN NUMBER ,
938 p_vendor_site_code IN VARCHAR2 ,
939 p_vendor_site_code_alt IN VARCHAR2 ,
940 p_purchasing_site_flag IN VARCHAR2 ,
941 p_rfq_only_site_flag IN VARCHAR2 ,
942 p_pay_site_flag IN VARCHAR2 ,
943 p_attention_ar_flag IN VARCHAR2 ,
944 p_hold_all_payments_flag IN VARCHAR2 ,
945 p_hold_future_payments_flag IN VARCHAR2 ,
946 p_hold_reason IN VARCHAR2 ,
947 p_hold_unmatched_invoices_flag IN VARCHAR2 ,
948 p_tax_reporting_site_flag IN VARCHAR2 ,
949 p_attribute_category IN VARCHAR2 ,
950 p_attribute1 IN VARCHAR2 ,
951 p_attribute2 IN VARCHAR2 ,
952 p_attribute3 IN VARCHAR2 ,
953 p_attribute4 IN VARCHAR2 ,
954 p_attribute5 IN VARCHAR2 ,
955 p_attribute6 IN VARCHAR2 ,
956 p_attribute7 IN VARCHAR2 ,
957 p_attribute8 IN VARCHAR2 ,
958 p_attribute9 IN VARCHAR2 ,
959 p_attribute10 IN VARCHAR2 ,
960 p_attribute11 IN VARCHAR2 ,
964 p_attribute15 IN VARCHAR2 ,
961 p_attribute12 IN VARCHAR2 ,
962 p_attribute13 IN VARCHAR2 ,
963 p_attribute14 IN VARCHAR2 ,
965 p_validation_number IN NUMBER ,
966 p_exclude_freight_from_discnt IN VARCHAR2 ,
967 p_bank_charge_bearer IN VARCHAR2 ,
968 p_org_id IN NUMBER ,
969 p_check_digits IN VARCHAR2 ,
970 p_allow_awt_flag IN VARCHAR2 ,
971 p_awt_group_id IN NUMBER ,
972 p_pay_awt_group_id IN NUMBER ,
973 p_default_pay_site_id IN NUMBER ,
974 p_pay_on_code IN VARCHAR2 ,
975 p_pay_on_receipt_summary_code IN VARCHAR2 ,
976 p_global_attribute_category IN VARCHAR2 ,
977 p_global_attribute1 IN VARCHAR2 ,
978 p_global_attribute2 IN VARCHAR2 ,
979 p_global_attribute3 IN VARCHAR2 ,
980 p_global_attribute4 IN VARCHAR2 ,
981 p_global_attribute5 IN VARCHAR2 ,
982 p_global_attribute6 IN VARCHAR2 ,
983 p_global_attribute7 IN VARCHAR2 ,
984 p_global_attribute8 IN VARCHAR2 ,
985 p_global_attribute9 IN VARCHAR2 ,
986 p_global_attribute10 IN VARCHAR2 ,
987 p_global_attribute11 IN VARCHAR2 ,
988 p_global_attribute12 IN VARCHAR2 ,
989 p_global_attribute13 IN VARCHAR2 ,
990 p_global_attribute14 IN VARCHAR2 ,
991 p_global_attribute15 IN VARCHAR2 ,
992 p_global_attribute16 IN VARCHAR2 ,
993 p_global_attribute17 IN VARCHAR2 ,
994 p_global_attribute18 IN VARCHAR2 ,
995 p_global_attribute19 IN VARCHAR2 ,
996 p_global_attribute20 IN VARCHAR2 ,
997 p_tp_header_id IN NUMBER ,
998 p_edi_id_number IN VARCHAR2 ,
999 p_ece_tp_location_code IN VARCHAR2 ,
1000 p_pcard_site_flag IN VARCHAR2 ,
1001 p_match_option IN VARCHAR2 ,
1002 p_country_of_origin_code IN VARCHAR2 ,
1003 p_future_dated_payment_ccid IN NUMBER ,
1004 p_create_debit_memo_flag IN VARCHAR2 ,
1005 p_supplier_notif_method IN VARCHAR2 ,
1006 p_email_address IN VARCHAR2 ,
1007 p_primary_pay_site_flag IN VARCHAR2 ,
1008 p_shipping_control IN VARCHAR2 ,
1009 p_selling_company_identifier IN VARCHAR2 ,
1010 p_gapless_inv_num_flag IN VARCHAR2 ,
1011 p_location_id IN NUMBER ,
1012 p_party_site_id IN NUMBER ,
1013 p_org_name IN VARCHAR2 ,
1014 p_duns_number IN VARCHAR2 ,
1015 p_address_style IN VARCHAR2 ,
1016 p_language IN VARCHAR2 ,
1017 p_province IN VARCHAR2 ,
1018 p_country IN VARCHAR2 ,
1019 p_address_line1 IN VARCHAR2 ,
1020 p_address_line2 IN VARCHAR2 ,
1021 p_address_line3 IN VARCHAR2 ,
1022 p_address_line4 IN VARCHAR2 ,
1023 p_address_lines_alt IN VARCHAR2 ,
1024 p_county IN VARCHAR2 ,
1025 p_city IN VARCHAR2 ,
1026 p_state IN VARCHAR2 ,
1027 p_zip IN VARCHAR2 ,
1028 p_terms_name IN VARCHAR2 ,
1029 p_default_terms_id IN NUMBER ,
1030 p_awt_group_name IN VARCHAR2 ,
1031 p_pay_awt_group_name IN VARCHAR2 ,
1032 p_distribution_set_name IN VARCHAR2 ,
1033 p_ship_to_location_code IN VARCHAR2 ,
1034 p_bill_to_location_code IN VARCHAR2 ,
1035 p_default_dist_set_id IN NUMBER ,
1036 p_default_ship_to_loc_id IN NUMBER ,
1037 p_default_bill_to_loc_id IN NUMBER ,
1038 p_tolerance_id IN NUMBER ,
1039 p_tolerance_name IN VARCHAR2 ,
1040 p_retainage_rate IN NUMBER ,
1041 p_mode IN VARCHAR2,
1042 p_cage_code IN VARCHAR2,
1043 p_legal_business_name IN VARCHAR2,
1044 p_doing_business_as IN VARCHAR2,
1045 p_division_name IN VARCHAR2,
1046 p_small_bus_code IN VARCHAR2,
1047 p_ccr_comments IN VARCHAR2,
1048 p_dbr_st_date IN DATE,
1049 p_dbr_ed_date IN DATE,
1050 x_return_status OUT NOCOPY VARCHAR2,
1051 x_error_msg OUT NOCOPY VARCHAR2,
1052 x_party_site_valid OUT NOCOPY VARCHAR2,
1053 x_location_valid OUT NOCOPY VARCHAR2
1054 );
1055
1056
1057
1058 --
1059 -- Begin Supplier Hub: Data Publication
1060 --
1061 -- This version of EGO's UDA Process User Attributes Data API is
1062 -- almost identical to the original version in ego_user_attrs_data_pub
1063 -- with the exception of hardcoding the object name HZ_PARTIES which
1064 -- is the only object name expected when accessing UDA for Supplier
1065 -- related entities.
1066 --
1067 -- Another minor difference is the following optional parameters. In the
1068 -- original EGO API they are defined as having DEFAULT fnd_api.g_false.
1069 -- This can be finessed as memory is allocated for each even if
1070 -- user skips them. Now changed to DEFAULT NULL, retaining the same
1071 -- default semantics by NVL in the body. This is done according to
1072 -- current performance coding standard.
1073 --
1077 -- p_log_errors IN VARCHAR2 DEFAULT NULL,
1074 -- p_init_error_handler IN VARCHAR2 DEFAULT NULL,
1075 -- p_write_to_concurrent_log IN VARCHAR2 DEFAULT NULL,
1076 -- p_init_fnd_msg_list IN VARCHAR2 DEFAULT NULL,
1078 -- p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT NULL,
1079 -- p_commit IN VARCHAR2 DEFAULT NULL,
1080 --
1081 -- Mon Aug 31 09:26:11 PDT 2009 bso
1082 --
1083 /*#
1084 * Create, update or delete User-Defined Attribute data for Supplier.
1085 * This is a straight-forward wrapper of the same procedure in
1086 * EGO_USER_ATTRS_DATA_PUB package. Please refer to that package for
1087 * more information.
1088 *
1089 * @param p_api_version Current version is 1.0
1090 * @param p_attributes_row_table Contains row-level data and metadata
1091 * about each attribute group being processed. See EGO_USER_ATTR_ROW_OBJ
1092 * in EGO_USER_ATTRS_DATA_PUB package for more information.
1093 * @param p_attributes_data_table Contains data and metadata about each
1094 * attribute being processed. See EGO_USER_ATTR_DATA_OBJ
1095 * in EGO_USER_ATTRS_DATA_PUB package for more information.
1096 * @param p_pk_column_name_value_pairs Contains the Primary Key column
1097 * names and values that identify the specific object instance to which
1098 * this data applies.
1099 * See EGO_COL_NAME_VALUE_PAIR_OBJ
1100 * in EGO_USER_ATTRS_DATA_PUB package for more information.
1101 * @param p_class_code_name_value_pairs Contains the Classification Code(s)
1102 * for the specific object instance to which this data applies.
1103 * See EGO_COL_NAME_VALUE_PAIR_OBJ
1104 * in EGO_USER_ATTRS_DATA_PUB package for more information.
1105 * @param p_user_privileges_on_object Contains the list of privileges
1106 * granted to the current user on the specific object instance identified
1107 * by p_pk_column_name_value_pairs.
1108 * See EGO_USER_ATTRS_DATA_PUB package for more information.
1109 * @param p_entity_id Used in error reporting. See ERROR_HANDLER package
1110 * for details.
1111 * @param p_entity_index Used in error reporting. See ERROR_HANDLER package
1112 * for details.
1113 * @param p_entity_code Used in error reporting. See ERROR_HANDLER package
1114 * for details.
1115 * @param p_debug_level Used in debugging. Valid values range from 0 (no
1116 * debugging) to 3 (full debugging). The debug file is created in the
1117 * first directory in the list returned by the following query:
1118 * SELECT VALUE FROM V$PARAMETER WHERE NAME = 'utl_file_dir';
1119 * @param p_init_error_handler Indicates whether to initialize ERROR_HANDLER
1120 * message stack (and open debug session, if applicable).
1121 * Default value NULL means FND_API.G_FALSE.
1122 * @param p_write_to_concurrent_log Indicates whether to log ERROR_HANDLER
1123 * messages to concurrent log (only applicable when called from concurrent
1124 * program and when p_log_errors is passed as FND_API.G_TRUE).
1125 * Default value NULL means FND_API.G_FALSE.
1126 * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
1127 * message stack.
1128 * Default value NULL means FND_API.G_FALSE.
1129 * @param p_log_errors Indicates whether to write ERROR_HANDLER message
1130 * stack to MTL_INTERFACE_ERRORS, the concurrent log (if applicable),
1131 * and the debug file (if applicable); if FND_API.G_FALSE is passed,
1132 * messages will still be added to ERROR_HANDLER's message stack, but
1133 * the message stack will not be written to any destination.
1134 * Default value NULL means FND_API.G_FALSE.
1135 * @param p_add_errors_to_fnd_stack Indicates whether messages written
1136 * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB
1137 * message stack.
1138 * Default value NULL means FND_API.G_FALSE.
1139 * @param p_commit Indicates whether to commit work for all attribute
1140 * group rows that are processed successfully; if FND_API.G_FALSE is
1141 * passed, the API will not commit any work.
1142 * Default value NULL means FND_API.G_FALSE.
1143 * @param x_failed_row_id_list Returns a comma-delimited list of
1144 * ROW_IDENTIFIERs (the field in EGO_USER_ATTR_ROW_OBJ, which is
1145 * discussed above) indicating attribute group rows that failed
1146 * in processing. An error will be logged for each failed row.
1147 * @param x_return_status Returns one of three values indicating the
1148 * most serious error encountered during processing:
1149 * FND_API.G_RET_STS_SUCCESS if no errors occurred,
1150 * FND_API.G_RET_STS_ERROR if at least one row encountered an error, and
1151 * FND_API.G_RET_STS_UNEXP_ERROR if at least one row encountered an
1152 * unexpected error.
1153 * @param x_errorcode Reserved for future use.
1154 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
1155 * message stack upon completion of processing.
1156 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
1157 * message stack upon completion of processing, this parameter contains
1158 * that message.
1159 * @rep:displayname Process User-Defined Attributes Data
1160 */
1161 PROCEDURE Process_User_Attrs_Data (
1162 p_api_version IN NUMBER,
1163 p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE,
1164 p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE,
1165 p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
1166 p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
1167 p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL,
1168 p_entity_id IN NUMBER DEFAULT NULL,
1169 p_entity_index IN NUMBER DEFAULT NULL,
1170 p_entity_code IN VARCHAR2 DEFAULT NULL,
1171 p_debug_level IN NUMBER DEFAULT 0,
1172 p_init_error_handler IN VARCHAR2 DEFAULT NULL,
1173 p_write_to_concurrent_log IN VARCHAR2 DEFAULT NULL,
1177 p_commit IN VARCHAR2 DEFAULT NULL,
1174 p_init_fnd_msg_list IN VARCHAR2 DEFAULT NULL,
1175 p_log_errors IN VARCHAR2 DEFAULT NULL,
1176 p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT NULL,
1178 x_failed_row_id_list OUT NOCOPY VARCHAR2,
1179 x_return_status OUT NOCOPY VARCHAR2,
1180 x_errorcode OUT NOCOPY NUMBER,
1181 x_msg_count OUT NOCOPY NUMBER,
1182 x_msg_data OUT NOCOPY VARCHAR2
1183 );
1184
1185
1186 --
1187 -- This version of EGO's UDA Get User Attributes Data API is
1188 -- almost identical to the original version in ego_user_attrs_data_pub
1189 -- with the exception of hardcoding the object name HZ_PARTIES which
1190 -- is the only object name expected when accessing UDA for Supplier
1191 -- related entities.
1192 --
1193 -- Another minor difference is the following optional parameters. In the
1194 -- original EGO API they are defined as having DEFAULT fnd_api.g_false.
1195 -- This can be finessed as memory is allocated for each even if
1196 -- user skips them. Now changed to DEFAULT NULL, retaining the same
1197 -- default semantics by NVL in the body. This is done according to
1198 -- current performance coding standard.
1199 --
1200 -- p_init_error_handler IN VARCHAR2 DEFAULT NULL,
1201 -- p_init_fnd_msg_list IN VARCHAR2 DEFAULT NULL,
1202 -- p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT NULL,
1203 --
1204 -- Tue Sep 1 09:51:26 PDT 2009 bso R12.1.2
1205 --
1206 /*#
1207 * Retrieves requested User-Defined Attribute data for one Supplier instance.
1208 * Parameters provide identifying data and metadata for an object instance,
1209 * as well as an EGO_ATTR_GROUP_REQUEST_TABLE specifying
1210 * the data to fetch. The procedure fetches the requested data from the
1211 * database (transforming internal values to display values as necessary)
1212 * and returns it in the form of two tables: an EGO_USER_ATTR_ROW_TABLE and
1213 * a corresponding EGO_USER_ATTR_DATA_TABLE.
1214 * For more information about EGO table data types and parameters
1215 * refer to the EGO_USER_ATTRS_DATA_PUB package.
1216 *
1217 * @param p_api_version Current version is 1.0
1218 * @param p_pk_column_name_value_pairs Contains the Primary Key column
1219 * names and values that identify the specific object instance to which
1220 * this data applies.
1221 * @param p_attr_group_request_table Contains a list of elements, each
1222 * of which identifies an attribute group whose data to retrieve.
1223 * @param p_user_privileges_on_object Contains the list of privileges
1224 * granted to the current user on the specific object instance identified
1225 * by p_pk_column_name_value_pairs.
1226 * @param p_entity_id Used in error reporting. See ERROR_HANDLER package
1227 * for details.
1228 * @param p_entity_index Used in error reporting. See ERROR_HANDLER package
1229 * for details.
1230 * @param p_entity_code Used in error reporting. See ERROR_HANDLER package
1231 * for details.
1232 * @param p_debug_level Used in debugging. Valid values range from 0 (no
1233 * debugging) to 3 (full debugging). The debug file is created in the
1234 * first directory in the list returned by the following query:
1235 * SELECT VALUE FROM V$PARAMETER WHERE NAME = 'utl_file_dir';
1236 * @param p_init_error_handler Indicates whether to initialize ERROR_HANDLER
1237 * message stack (and open debug session, if applicable)
1238 * Default value NULL means FND_API.G_FALSE.
1239 * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
1240 * message stack.
1241 * Default value NULL means FND_API.G_FALSE.
1242 * @param p_add_errors_to_fnd_stack Indicates whether messages written
1243 * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB
1244 * message stack.
1245 * Default value NULL means FND_API.G_FALSE.
1246 * @param x_attributes_row_table Contains row-level data and metadata
1247 * about each attribute group whose data is being returned.
1248 * @param x_attributes_data_table Contains data and metadata about each
1249 * attribute whose data is being returned.
1250 * @param x_return_status Returns one of three values indicating the
1251 * most serious error encountered during processing:
1252 * FND_API.G_RET_STS_SUCCESS if no errors occurred,
1253 * FND_API.G_RET_STS_ERROR if at least one error occurred, and
1254 * FND_API.G_RET_STS_UNEXP_ERROR if at least one unexpected error occurred.
1255 * @param x_errorcode Reserved for future use.
1256 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
1257 * message stack upon completion of processing.
1258 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
1259 * message stack upon completion of processing, this parameter contains
1260 * that message.
1261 * @rep:displayname Get User-Defined Attributes Data
1262 */
1263 PROCEDURE Get_User_Attrs_Data (
1264 p_api_version IN NUMBER,
1265 p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY,
1266 p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE,
1267 p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL,
1268 p_entity_id IN VARCHAR2 DEFAULT NULL,
1269 p_entity_index IN NUMBER DEFAULT NULL,
1270 p_entity_code IN VARCHAR2 DEFAULT NULL,
1271 p_debug_level IN NUMBER DEFAULT 0,
1272 p_init_error_handler IN VARCHAR2 DEFAULT NULL,
1273 p_init_fnd_msg_list IN VARCHAR2 DEFAULT NULL,
1274 p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT NULL,
1275 x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE,
1276 x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE,
1277 x_return_status OUT NOCOPY VARCHAR2,
1278 x_errorcode OUT NOCOPY NUMBER,
1279 x_msg_count OUT NOCOPY NUMBER,
1280 x_msg_data OUT NOCOPY VARCHAR2
1281 );
1282
1283 --
1284 -- End Supplier Hub: Data Publication
1285 --
1286
1287
1288 END POS_VENDOR_PUB_PKG;