1 PACKAGE hz_acct_create_pkg AUTHID CURRENT_USER as
2 /* $Header: ARHACTFS.pls 120.2 2005/06/16 21:08:15 jhuang ship $ */
3 PROCEDURE insert_row(
4 c_cust_account_id IN OUT NOCOPY NUMBER ,
5 c_party_id IN OUT NOCOPY NUMBER,
6 c_account_number IN OUT NOCOPY VARCHAR2,
7 c_Attribute_Category IN VARCHAR2,
8 c_Attribute1 IN VARCHAR2,
9 c_Attribute2 IN VARCHAR2,
10 c_Attribute3 IN VARCHAR2,
11 c_Attribute4 IN VARCHAR2,
12 c_Attribute5 IN VARCHAR2,
13 c_Attribute6 IN VARCHAR2,
14 c_attribute7 IN VARCHAR2,
15 c_Attribute8 IN VARCHAR2,
16 c_Attribute9 IN VARCHAR2,
17 c_Attribute10 IN VARCHAR2,
18 c_Attribute11 IN VARCHAR2,
19 c_Attribute12 IN VARCHAR2,
20 c_Attribute13 IN VARCHAR2,
21 c_Attribute14 IN VARCHAR2,
22 c_Attribute15 IN VARCHAR2,
23 c_Attribute16 IN VARCHAR2,
24 c_Attribute17 IN VARCHAR2,
25 c_Attribute18 IN VARCHAR2,
26 c_Attribute19 IN VARCHAR2,
27 c_Attribute20 IN VARCHAR2,
28 c_global_attribute_category IN VARCHAR2,
29 c_global_attribute1 IN VARCHAR2,
30 c_global_attribute2 IN VARCHAR2,
31 c_global_attribute3 IN VARCHAR2,
32 c_global_attribute4 IN VARCHAR2,
33 c_global_attribute5 IN VARCHAR2,
34 c_global_attribute6 IN VARCHAR2,
35 c_global_attribute7 IN VARCHAR2,
36 c_global_attribute8 IN VARCHAR2,
37 c_global_attribute9 IN VARCHAR2,
38 c_global_attribute10 IN VARCHAR2,
39 c_global_attribute11 IN VARCHAR2,
40 c_global_attribute12 IN VARCHAR2,
41 c_global_attribute13 IN VARCHAR2,
42 c_global_attribute14 IN VARCHAR2,
43 c_global_attribute15 IN VARCHAR2,
44 c_global_attribute16 IN VARCHAR2,
45 c_global_attribute17 IN VARCHAR2,
46 c_global_attribute18 IN VARCHAR2,
47 c_global_attribute19 IN VARCHAR2,
48 c_global_attribute20 IN VARCHAR2,
49 c_orig_system_reference IN VARCHAR2,
50 c_status IN VARCHAR2,
51 c_customer_type IN VARCHAR2,
52 c_customer_class_code IN VARCHAR2,
53 c_primary_salesrep_id IN NUMBER ,
54 c_sales_channel_code IN VARCHAR2,
55 c_order_type_id IN NUMBER,
56 c_price_list_id IN NUMBER ,
57 c_category_code IN VARCHAR2,
58 c_reference_use_flag IN VARCHAR2,
59 c_tax_code IN VARCHAR2,
60 c_third_party_flag IN VARCHAR2,
61 c_competitor_flag IN VARCHAR2,
62 c_fob_point IN VARCHAR2,
63 c_tax_header_level_flag IN VARCHAR2,
64 c_tax_rounding_rule IN VARCHAR2,
65 c_account_name IN VARCHAR2,
66 c_freight_term IN VARCHAR2,
67 c_ship_partial IN VARCHAR2,
68 c_ship_via IN VARCHAR2,
69 c_warehouse_id IN NUMBER,
70 c_payment_term_id IN NUMBER ,
71 c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
72 c_DATES_POSITIVE_TOLERANCE IN NUMBER,
73 c_DATE_TYPE_PREFERENCE IN VARCHAR2,
74 c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
75 c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
76 c_ITEM_CROSS_REF_PREF IN VARCHAR2,
77 c_OVER_RETURN_TOLERANCE IN NUMBER,
78 c_UNDER_RETURN_TOLERANCE IN NUMBER,
79 c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
80 c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
81 c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
82 c_INVOICE_QUANTITY_RULE IN VARCHAR2,
83 t_party_id IN NUMBER ,
84 t_party_number IN OUT NOCOPY VARCHAR2,
85 t_customer_key IN VARCHAR2,
86 t_Attribute_Category IN VARCHAR2,
87 t_Attribute1 IN VARCHAR2,
88 t_Attribute2 IN VARCHAR2,
89 t_Attribute3 IN VARCHAR2,
90 t_Attribute4 IN VARCHAR2,
91 t_Attribute5 IN VARCHAR2,
92 t_Attribute6 IN VARCHAR2,
93 t_Attribute7 IN VARCHAR2,
94 t_Attribute8 IN VARCHAR2,
95 t_Attribute9 IN VARCHAR2,
96 t_Attribute10 IN VARCHAR2,
97 t_Attribute11 IN VARCHAR2,
98 t_Attribute12 IN VARCHAR2,
99 t_Attribute13 IN VARCHAR2,
100 t_Attribute14 IN VARCHAR2,
101 t_Attribute15 IN VARCHAR2,
102 t_Attribute16 IN VARCHAR2,
103 t_Attribute17 IN VARCHAR2,
104 t_Attribute18 IN VARCHAR2,
105 t_Attribute19 IN VARCHAR2,
106 t_Attribute20 IN VARCHAR2,
107 t_global_attribute_category IN VARCHAR2,
108 t_global_attribute1 IN VARCHAR2,
109 t_global_attribute2 IN VARCHAR2,
110 t_global_attribute3 IN VARCHAR2,
111 t_global_attribute4 IN VARCHAR2,
112 t_global_attribute5 IN VARCHAR2,
113 t_global_attribute6 IN VARCHAR2,
114 t_global_attribute7 IN VARCHAR2,
115 t_global_attribute8 IN VARCHAR2,
116 t_global_attribute9 IN VARCHAR2,
117 t_global_attribute10 IN VARCHAR2,
118 t_global_attribute11 IN VARCHAR2,
119 t_global_attribute12 IN VARCHAR2,
120 t_global_attribute13 IN VARCHAR2,
121 t_global_attribute14 IN VARCHAR2,
122 t_global_attribute15 IN VARCHAR2,
123 t_global_attribute16 IN VARCHAR2,
124 t_global_attribute17 IN VARCHAR2,
125 t_global_attribute18 IN VARCHAR2,
126 t_global_attribute19 IN VARCHAR2,
127 t_global_attribute20 IN VARCHAR2,
128 o_party_name IN VARCHAR2,
129 o_sic_code IN VARCHAR2,
130 o_sic_code_type IN VARCHAR2,
131 o_analysis_fy IN VARCHAR2,
132 o_fiscal_yearend_month IN VARCHAR2,
133 o_num_of_employees IN NUMBER ,
134 o_curr_fy_potential_revenue IN NUMBER ,
135 o_next_fy_potential_revenue IN NUMBER ,
136 o_tax_reference IN VARCHAR2,
137 o_year_established IN NUMBER ,
138 o_gsa_indicator_flag IN VARCHAR2,
139 o_mission_statement IN VARCHAR2,
140 o_duns_number IN NUMBER,
141 o_tax_name IN VARCHAR2,
142 o_organization_type IN VARCHAR2,
143 o_taxpayer_id IN VARCHAR2,
144 o_party_name_phonetic IN VARCHAR2,
145 p_cust_account_profile_id IN NUMBER ,
146 p_cust_account_id IN NUMBER ,
147 p_status IN VARCHAR2,
148 p_collector_id IN NUMBER ,
149 p_credit_analyst_id IN NUMBER ,
150 p_credit_checking IN VARCHAR2,
151 p_next_credit_review_date DATE ,
152 p_tolerance IN NUMBER,
153 p_discount_terms IN VARCHAR2,
154 p_dunning_letters IN VARCHAR2,
155 p_interest_charges IN VARCHAR2,
156 p_send_statements IN VARCHAR2,
157 p_credit_balance_statements IN VARCHAR2,
158 p_credit_hold IN VARCHAR2,
159 p_profile_class_id IN NUMBER ,
160 p_site_use_id IN NUMBER ,
161 p_credit_rating IN VARCHAR2,
162 p_risk_code IN VARCHAR2,
163 p_standard_terms IN NUMBER ,
164 p_override_terms IN VARCHAR2,
165 p_dunning_letter_set_id IN NUMBER,
166 p_interest_period_days IN NUMBER,
167 p_payment_grace_days IN NUMBER,
168 p_discount_grace_days IN NUMBER,
169 p_statement_cycle_id IN NUMBER ,
170 p_account_status IN VARCHAR2,
171 p_percent_collectable IN NUMBER ,
172 p_autocash_hierarchy_id IN NUMBER,
173 p_Attribute_Category IN VARCHAR2,
174 p_Attribute1 IN VARCHAR2,
175 p_Attribute2 IN VARCHAR2,
176 p_Attribute3 IN VARCHAR2,
177 p_Attribute4 IN VARCHAR2,
178 p_Attribute5 IN VARCHAR2,
179 p_Attribute6 IN VARCHAR2,
180 p_Attribute7 IN VARCHAR2,
181 p_Attribute8 IN VARCHAR2,
182 p_Attribute9 IN VARCHAR2,
183 p_Attribute10 IN VARCHAR2,
184 p_Attribute11 IN VARCHAR2,
185 p_Attribute12 IN VARCHAR2,
186 p_Attribute13 IN VARCHAR2,
187 p_Attribute14 IN VARCHAR2,
188 p_Attribute15 IN VARCHAR2,
189 p_auto_rec_incl_disputed_flag IN VARCHAR2,
190 p_tax_printing_option IN VARCHAR2,
191 p_charge_on_fin_charge_flag IN VARCHAR2,
192 p_grouping_rule_id IN NUMBER ,
193 p_clearing_days IN NUMBER,
194 p_jgzz_attribute_category IN VARCHAR2,
195 p_jgzz_attribute1 IN VARCHAR2,
196 p_jgzz_attribute2 IN VARCHAR2,
197 p_jgzz_attribute3 IN VARCHAR2,
198 p_jgzz_attribute4 IN VARCHAR2,
199 p_jgzz_attribute5 IN VARCHAR2,
200 p_jgzz_attribute6 IN VARCHAR2,
201 p_jgzz_attribute7 IN VARCHAR2,
202 p_jgzz_attribute8 IN VARCHAR2,
203 p_jgzz_attribute9 IN VARCHAR2,
204 p_jgzz_attribute10 IN VARCHAR2,
205 p_jgzz_attribute11 IN VARCHAR2,
206 p_jgzz_attribute12 IN VARCHAR2,
207 p_jgzz_attribute13 IN VARCHAR2,
208 p_jgzz_attribute14 IN VARCHAR2,
209 p_jgzz_attribute15 IN VARCHAR2,
210 p_global_attribute_category IN VARCHAR2,
211 p_global_attribute1 IN VARCHAR2,
212 p_global_attribute2 IN VARCHAR2,
213 p_global_attribute3 IN VARCHAR2,
214 p_global_attribute4 IN VARCHAR2,
215 p_global_attribute5 IN VARCHAR2,
216 p_global_attribute6 IN VARCHAR2,
217 p_global_attribute7 IN VARCHAR2,
218 p_global_attribute8 IN VARCHAR2,
219 p_global_attribute9 IN VARCHAR2,
220 p_global_attribute10 IN VARCHAR2,
221 p_global_attribute11 IN VARCHAR2,
222 p_global_attribute12 IN VARCHAR2,
223 p_global_attribute13 IN VARCHAR2,
224 p_global_attribute14 IN VARCHAR2,
225 p_global_attribute15 IN VARCHAR2,
226 p_global_attribute16 IN VARCHAR2,
227 p_global_attribute17 IN VARCHAR2,
228 p_global_attribute18 IN VARCHAR2,
229 p_global_attribute19 IN VARCHAR2,
230 p_global_attribute20 IN VARCHAR2,
231 p_cons_inv_flag IN VARCHAR2,
232 p_cons_inv_type IN VARCHAR2,
233 p_autocash_hier_id_for_adr IN NUMBER ,
234 p_lockbox_matching_option IN VARCHAR2,
235 --{2310474
236 p_party_id IN NUMBER DEFAULT NULL,
237 p_review_cycle IN VARCHAR2 DEFAULT NULL,
238 p_credit_classification IN VARCHAR2 DEFAULT NULL,
239 p_last_credit_review_date IN DATE DEFAULT NULL,
240 --}
241 o_organization_profile_id in out NOCOPY number,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY varchar2,
247
244 x_return_status OUT NOCOPY VARCHAR2,
245 o_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
246 );
248
249
250 PROCEDURE insert_person_row(
251 c_cust_account_id IN OUT NOCOPY NUMBER ,
252 c_party_id IN OUT NOCOPY NUMBER,
253 c_account_number IN OUT NOCOPY VARCHAR2,
254 c_Attribute_Category IN VARCHAR2,
255 c_Attribute1 IN VARCHAR2,
256 c_Attribute2 IN VARCHAR2,
257 c_Attribute3 IN VARCHAR2,
258 c_Attribute4 IN VARCHAR2,
259 c_Attribute5 IN VARCHAR2,
260 c_Attribute6 IN VARCHAR2,
261 c_Attribute7 IN VARCHAR2,
262 c_Attribute8 IN VARCHAR2,
263 c_Attribute9 IN VARCHAR2,
264 c_Attribute10 IN VARCHAR2,
265 c_Attribute11 IN VARCHAR2,
266 c_Attribute12 IN VARCHAR2,
267 c_Attribute13 IN VARCHAR2,
268 c_Attribute14 IN VARCHAR2,
269 c_Attribute15 IN VARCHAR2,
270 c_Attribute16 IN VARCHAR2,
271 c_Attribute17 IN VARCHAR2,
272 c_Attribute18 IN VARCHAR2,
273 c_Attribute19 IN VARCHAR2,
274 c_Attribute20 IN VARCHAR2,
275 c_global_attribute_category IN VARCHAR2,
276 c_global_attribute1 IN VARCHAR2,
277 c_global_attribute2 IN VARCHAR2,
278 c_global_attribute3 IN VARCHAR2,
279 c_global_attribute4 IN VARCHAR2,
280 c_global_attribute5 IN VARCHAR2,
281 c_global_attribute6 IN VARCHAR2,
282 c_global_attribute7 IN VARCHAR2,
283 c_global_attribute8 IN VARCHAR2,
284 c_global_attribute9 IN VARCHAR2,
285 c_global_attribute10 IN VARCHAR2,
286 c_global_attribute11 IN VARCHAR2,
287 c_global_attribute12 IN VARCHAR2,
288 c_global_attribute13 IN VARCHAR2,
289 c_global_attribute14 IN VARCHAR2,
290 c_global_attribute15 IN VARCHAR2,
291 c_global_attribute16 IN VARCHAR2,
292 c_global_attribute17 IN VARCHAR2,
293 c_global_attribute18 IN VARCHAR2,
294 c_global_attribute19 IN VARCHAR2,
295 c_global_attribute20 IN VARCHAR2,
296 c_orig_system_reference IN VARCHAR2,
297 c_status IN VARCHAR2,
298 c_customer_type IN VARCHAR2,
299 c_customer_class_code IN VARCHAR2,
300 c_primary_salesrep_id IN NUMBER ,
301 c_sales_channel_code IN VARCHAR2,
302 c_order_type_id IN NUMBER,
303 c_price_list_id IN NUMBER ,
304 c_category_code IN VARCHAR2,
305 c_reference_use_flag IN VARCHAR2,
306 c_tax_code IN VARCHAR2,
307 c_third_party_flag IN VARCHAR2,
308 c_competitor_flag IN VARCHAR2,
309 c_fob_point IN VARCHAR2,
310 c_tax_header_level_flag IN VARCHAR2,
311 c_tax_rounding_rule IN VARCHAR2,
312 c_account_name IN VARCHAR2,
313 c_freight_term IN VARCHAR2,
314 c_ship_partial IN VARCHAR2,
315 c_ship_via IN VARCHAR2,
316 c_warehouse_id IN NUMBER,
317 c_payment_term_id IN NUMBER ,
318 c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
319 c_DATES_POSITIVE_TOLERANCE IN NUMBER,
320 c_DATE_TYPE_PREFERENCE IN VARCHAR2,
321 c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
322 c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
323 c_ITEM_CROSS_REF_PREF IN VARCHAR2,
324 c_OVER_RETURN_TOLERANCE IN NUMBER,
328 c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
325 c_UNDER_RETURN_TOLERANCE IN NUMBER,
326 c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
327 c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
329 c_INVOICE_QUANTITY_RULE IN VARCHAR2,
330 t_party_id IN NUMBER ,
331 t_party_number IN OUT NOCOPY VARCHAR2,
332 t_customer_key IN VARCHAR2,
333 t_Attribute_Category IN VARCHAR2,
334 t_Attribute1 IN VARCHAR2,
335 t_Attribute2 IN VARCHAR2,
336 t_Attribute3 IN VARCHAR2,
337 t_Attribute4 IN VARCHAR2,
338 t_Attribute5 IN VARCHAR2,
339 t_Attribute6 IN VARCHAR2,
340 t_Attribute7 IN VARCHAR2,
341 t_Attribute8 IN VARCHAR2,
342 t_Attribute9 IN VARCHAR2,
343 t_Attribute10 IN VARCHAR2,
344 t_Attribute11 IN VARCHAR2,
345 t_Attribute12 IN VARCHAR2,
346 t_Attribute13 IN VARCHAR2,
347 t_Attribute14 IN VARCHAR2,
348 t_Attribute15 IN VARCHAR2,
349 t_Attribute16 IN VARCHAR2,
350 t_Attribute17 IN VARCHAR2,
351 t_Attribute18 IN VARCHAR2,
352 t_Attribute19 IN VARCHAR2,
353 t_Attribute20 IN VARCHAR2,
354 t_global_attribute_category IN VARCHAR2,
355 t_global_attribute1 IN VARCHAR2,
356 t_global_attribute2 IN VARCHAR2,
357 t_global_attribute3 IN VARCHAR2,
358 t_global_attribute4 IN VARCHAR2,
359 t_global_attribute5 IN VARCHAR2,
360 t_global_attribute6 IN VARCHAR2,
361 t_global_attribute7 IN VARCHAR2,
362 t_global_attribute8 IN VARCHAR2,
363 t_global_attribute9 IN VARCHAR2,
364 t_global_attribute10 IN VARCHAR2,
365 t_global_attribute11 IN VARCHAR2,
366 t_global_attribute12 IN VARCHAR2,
367 t_global_attribute13 IN VARCHAR2,
368 t_global_attribute14 IN VARCHAR2,
369 t_global_attribute15 IN VARCHAR2,
370 t_global_attribute16 IN VARCHAR2,
371 t_global_attribute17 IN VARCHAR2,
372 t_global_attribute18 IN VARCHAR2,
373 t_global_attribute19 IN VARCHAR2,
374 t_global_attribute20 IN VARCHAR2,
375 o_pre_name_adjunct IN VARCHAR2,
376 o_first_name IN VARCHAR2,
377 o_middle_name IN VARCHAR2,
378 o_last_name IN VARCHAR2,
379 o_name_suffix IN VARCHAR2 ,
380 o_tax_reference IN VARCHAR2,
381 o_taxpayer_id IN VARCHAR2,
382 o_party_name_phonetic IN VARCHAR2,
383 p_cust_account_profile_id IN NUMBER ,
384 p_cust_account_id IN NUMBER ,
385 p_status IN VARCHAR2,
386 p_collector_id IN NUMBER ,
387 p_credit_analyst_id IN NUMBER ,
388 p_credit_checking IN VARCHAR2,
389 p_next_credit_review_date DATE ,
390 p_tolerance IN NUMBER,
391 p_discount_terms IN VARCHAR2,
392 p_dunning_letters IN VARCHAR2,
393 p_interest_charges IN VARCHAR2,
394 p_send_statements IN VARCHAR2,
395 p_credit_balance_statements IN VARCHAR2,
396 p_credit_hold IN VARCHAR2,
397 p_profile_class_id IN NUMBER ,
398 p_site_use_id IN NUMBER ,
399 p_credit_rating IN VARCHAR2,
400 p_risk_code IN VARCHAR2,
401 p_standard_terms IN NUMBER ,
402 p_override_terms IN VARCHAR2,
406 p_discount_grace_days IN NUMBER,
403 p_dunning_letter_set_id IN NUMBER,
404 p_interest_period_days IN NUMBER,
405 p_payment_grace_days IN NUMBER,
407 p_statement_cycle_id IN NUMBER ,
408 p_account_status IN VARCHAR2,
409 p_percent_collectable IN NUMBER ,
410 p_autocash_hierarchy_id IN NUMBER,
411 p_Attribute_Category IN VARCHAR2,
412 p_Attribute1 IN VARCHAR2,
413 p_Attribute2 IN VARCHAR2,
414 p_Attribute3 IN VARCHAR2,
415 p_Attribute4 IN VARCHAR2,
416 p_Attribute5 IN VARCHAR2,
417 p_Attribute6 IN VARCHAR2,
418 p_Attribute7 IN VARCHAR2,
419 p_Attribute8 IN VARCHAR2,
420 p_Attribute9 IN VARCHAR2,
421 p_Attribute10 IN VARCHAR2,
422 p_Attribute11 IN VARCHAR2,
423 p_Attribute12 IN VARCHAR2,
424 p_Attribute13 IN VARCHAR2,
425 p_Attribute14 IN VARCHAR2,
426 p_Attribute15 IN VARCHAR2,
427 p_auto_rec_incl_disputed_flag IN VARCHAR2,
428 p_tax_printing_option IN VARCHAR2,
429 p_charge_on_fin_charge_flag IN VARCHAR2,
430 p_grouping_rule_id IN NUMBER ,
431 p_clearing_days IN NUMBER,
432 p_jgzz_attribute_category IN VARCHAR2,
433 p_jgzz_attribute1 IN VARCHAR2,
434 p_jgzz_attribute2 IN VARCHAR2,
435 p_jgzz_attribute3 IN VARCHAR2,
436 p_jgzz_attribute4 IN VARCHAR2,
437 p_jgzz_attribute5 IN VARCHAR2,
438 p_jgzz_attribute6 IN VARCHAR2,
439 p_jgzz_attribute7 IN VARCHAR2,
440 p_jgzz_attribute8 IN VARCHAR2,
441 p_jgzz_attribute9 IN VARCHAR2,
442 p_jgzz_attribute10 IN VARCHAR2,
443 p_jgzz_attribute11 IN VARCHAR2,
444 p_jgzz_attribute12 IN VARCHAR2,
445 p_jgzz_attribute13 IN VARCHAR2,
446 p_jgzz_attribute14 IN VARCHAR2,
447 p_jgzz_attribute15 IN VARCHAR2,
448 p_global_attribute_category IN VARCHAR2,
449 p_global_attribute1 IN VARCHAR2,
450 p_global_attribute2 IN VARCHAR2,
451 p_global_attribute3 IN VARCHAR2,
452 p_global_attribute4 IN VARCHAR2,
453 p_global_attribute5 IN VARCHAR2,
454 p_global_attribute6 IN VARCHAR2,
455 p_global_attribute7 IN VARCHAR2,
456 p_global_attribute8 IN VARCHAR2,
457 p_global_attribute9 IN VARCHAR2,
458 p_global_attribute10 IN VARCHAR2,
459 p_global_attribute11 IN VARCHAR2,
460 p_global_attribute12 IN VARCHAR2,
461 p_global_attribute13 IN VARCHAR2,
462 p_global_attribute14 IN VARCHAR2,
463 p_global_attribute15 IN VARCHAR2,
464 p_global_attribute16 IN VARCHAR2,
465 p_global_attribute17 IN VARCHAR2,
466 p_global_attribute18 IN VARCHAR2,
467 p_global_attribute19 IN VARCHAR2,
468 p_global_attribute20 IN VARCHAR2,
469 p_cons_inv_flag IN VARCHAR2,
470 p_cons_inv_type IN VARCHAR2,
471 p_autocash_hier_id_for_adr IN NUMBER ,
472 p_lockbox_matching_option IN VARCHAR2,
473 --{2310474
474 p_party_id IN NUMBER DEFAULT NULL,
475 p_review_cycle IN VARCHAR2 DEFAULT NULL,
476 p_credit_classification IN VARCHAR2 DEFAULT NULL,
477 p_last_credit_review_date IN DATE DEFAULT NULL,
478 --}
479 o_person_profile_id in out NOCOPY number,
480 x_msg_count OUT NOCOPY NUMBER,
484
481 x_msg_data OUT NOCOPY varchar2,
482 x_return_status OUT NOCOPY VARCHAR2);
483
485 PROCEDURE update_row(
486 c_cust_account_id IN OUT NOCOPY NUMBER ,
487 c_party_id IN NUMBER,
488 c_account_number IN VARCHAR2,
489 c_Attribute_Category IN VARCHAR2,
490 c_Attribute1 IN VARCHAR2,
491 c_Attribute2 IN VARCHAR2,
492 c_Attribute3 IN VARCHAR2,
493 c_Attribute4 IN VARCHAR2,
494 c_Attribute5 IN VARCHAR2,
495 c_Attribute6 IN VARCHAR2,
496 c_Attribute7 IN VARCHAR2,
497 c_Attribute8 IN VARCHAR2,
498 c_Attribute9 IN VARCHAR2,
499 c_Attribute10 IN VARCHAR2,
500 c_Attribute11 IN VARCHAR2,
501 c_Attribute12 IN VARCHAR2,
502 c_Attribute13 IN VARCHAR2,
503 c_Attribute14 IN VARCHAR2,
504 c_Attribute15 IN VARCHAR2,
505 c_Attribute16 IN VARCHAR2,
506 c_Attribute17 IN VARCHAR2,
507 c_Attribute18 IN VARCHAR2,
508 c_Attribute19 IN VARCHAR2,
509 c_Attribute20 IN VARCHAR2,
510 c_global_attribute_category IN VARCHAR2,
511 c_global_attribute1 IN VARCHAR2,
512 c_global_attribute2 IN VARCHAR2,
513 c_global_attribute3 IN VARCHAR2,
514 c_global_attribute4 IN VARCHAR2,
515 c_global_attribute5 IN VARCHAR2,
516 c_global_attribute6 IN VARCHAR2,
517 c_global_attribute7 IN VARCHAR2,
518 c_global_attribute8 IN VARCHAR2,
519 c_global_attribute9 IN VARCHAR2,
520 c_global_attribute10 IN VARCHAR2,
521 c_global_attribute11 IN VARCHAR2,
522 c_global_attribute12 IN VARCHAR2,
523 c_global_attribute13 IN VARCHAR2,
524 c_global_attribute14 IN VARCHAR2,
525 c_global_attribute15 IN VARCHAR2,
526 c_global_attribute16 IN VARCHAR2,
527 c_global_attribute17 IN VARCHAR2,
528 c_global_attribute18 IN VARCHAR2,
529 c_global_attribute19 IN VARCHAR2,
530 c_global_attribute20 IN VARCHAR2,
531 c_orig_system_reference IN VARCHAR2,
532 c_status IN VARCHAR2,
533 c_customer_type IN VARCHAR2,
534 c_customer_class_code IN VARCHAR2,
535 c_primary_salesrep_id IN NUMBER ,
536 c_sales_channel_code IN VARCHAR2,
537 c_order_type_id IN NUMBER,
538 c_price_list_id IN NUMBER ,
539 c_category_code IN VARCHAR2,
540 c_reference_use_flag IN VARCHAR2,
541 c_tax_code IN VARCHAR2,
542 c_third_party_flag IN VARCHAR2,
543 c_competitor_flag IN VARCHAR2,
544 c_fob_point IN VARCHAR2,
545 c_tax_header_level_flag IN VARCHAR2,
549 c_ship_partial IN VARCHAR2,
546 c_tax_rounding_rule IN VARCHAR2,
547 c_account_name IN VARCHAR2,
548 c_freight_term IN VARCHAR2,
550 c_ship_via IN VARCHAR2,
551 c_warehouse_id IN NUMBER,
552 c_payment_term_id IN NUMBER ,
553 c_analysis_fy IN VARCHAR2,
554 c_fiscal_yearend_month IN VARCHAR2,
555 c_employees_total IN NUMBER,
556 c_cr_fy_potential_revenue IN NUMBER,
557 c_next_fy_potential_revenue IN NUMBER,
558 c_tax_reference IN VARCHAR2,
559 c_year_established IN NUMBER,
560 c_gsa_indicator_flag IN VARCHAR2,
561 c_jgzz_fiscal_code IN VARCHAR2,
562 c_do_not_mail_flag IN VARCHAR2,
563 c_mission_statement IN VARCHAR2,
564 c_org_name_phonetic IN VARCHAR2,
565 c_url IN VARCHAR2,
566 c_person_suffix IN VARCHAR2,
567 c_first_name IN VARCHAR2,
568 c_middle_name IN VARCHAR2,
569 c_last_name IN VARCHAR2,
570 c_person_prefix IN VARCHAR2,
571 c_sic_code IN VARCHAR2,
572 c_sic_code_type IN VARCHAR2,
573 c_duns_number IN NUMBER,
574 c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
575 c_DATES_POSITIVE_TOLERANCE IN NUMBER,
576 c_DATE_TYPE_PREFERENCE IN VARCHAR2,
577 c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
578 c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
579 c_ITEM_CROSS_REF_PREF IN VARCHAR2,
580 c_OVER_RETURN_TOLERANCE IN NUMBER,
581 c_UNDER_RETURN_TOLERANCE IN NUMBER,
582 c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
583 c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
584 c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
585 c_INVOICE_QUANTITY_RULE IN VARCHAR2,
586 c_account_alias IN VARCHAR2 DEFAULT NULL,
587 p_cust_account_profile_id IN NUMBER ,
588 p_cust_account_id IN NUMBER ,
589 p_status IN VARCHAR2,
590 p_collector_id IN NUMBER ,
591 p_credit_analyst_id IN NUMBER ,
592 p_credit_checking IN VARCHAR2,
593 p_next_credit_review_date DATE ,
594 p_tolerance IN NUMBER,
595 p_discount_terms IN VARCHAR2,
596 p_dunning_letters IN VARCHAR2,
597 p_interest_charges IN VARCHAR2,
598 p_send_statements IN VARCHAR2,
599 p_credit_balance_statements IN VARCHAR2,
600 p_credit_hold IN VARCHAR2,
601 p_profile_class_id IN NUMBER ,
602 p_site_use_id IN NUMBER ,
603 p_credit_rating IN VARCHAR2,
604 p_risk_code IN VARCHAR2,
605 p_standard_terms IN NUMBER ,
606 p_override_terms IN VARCHAR2,
607 p_dunning_letter_set_id IN NUMBER,
608 p_interest_period_days IN NUMBER,
609 p_payment_grace_days IN NUMBER,
610 p_discount_grace_days IN NUMBER,
611 p_statement_cycle_id IN NUMBER ,
612 p_account_status IN VARCHAR2,
613 p_percent_collectable IN NUMBER ,
614 p_autocash_hierarchy_id IN NUMBER,
615 p_Attribute_Category IN VARCHAR2,
616 p_Attribute1 IN VARCHAR2,
617 p_Attribute2 IN VARCHAR2,
618 p_Attribute3 IN VARCHAR2,
619 p_Attribute4 IN VARCHAR2,
620 p_Attribute5 IN VARCHAR2,
621 p_Attribute6 IN VARCHAR2,
622 p_Attribute7 IN VARCHAR2,
623 p_Attribute8 IN VARCHAR2,
624 p_Attribute9 IN VARCHAR2,
628 p_Attribute13 IN VARCHAR2,
625 p_Attribute10 IN VARCHAR2,
626 p_Attribute11 IN VARCHAR2,
627 p_Attribute12 IN VARCHAR2,
629 p_Attribute14 IN VARCHAR2,
630 p_Attribute15 IN VARCHAR2,
631 p_auto_rec_incl_disputed_flag IN VARCHAR2,
632 p_tax_printing_option IN VARCHAR2,
633 p_charge_on_fin_charge_flag IN VARCHAR2,
634 p_grouping_rule_id IN NUMBER ,
635 p_clearing_days IN NUMBER,
636 p_jgzz_attribute_category IN VARCHAR2,
637 p_jgzz_attribute1 IN VARCHAR2,
638 p_jgzz_attribute2 IN VARCHAR2,
639 p_jgzz_attribute3 IN VARCHAR2,
640 p_jgzz_attribute4 IN VARCHAR2,
641 p_jgzz_attribute5 IN VARCHAR2,
642 p_jgzz_attribute6 IN VARCHAR2,
643 p_jgzz_attribute7 IN VARCHAR2,
644 p_jgzz_attribute8 IN VARCHAR2,
645 p_jgzz_attribute9 IN VARCHAR2,
646 p_jgzz_attribute10 IN VARCHAR2,
647 p_jgzz_attribute11 IN VARCHAR2,
648 p_jgzz_attribute12 IN VARCHAR2,
649 p_jgzz_attribute13 IN VARCHAR2,
650 p_jgzz_attribute14 IN VARCHAR2,
651 p_jgzz_attribute15 IN VARCHAR2,
652 p_global_attribute_category IN VARCHAR2,
653 p_global_attribute1 IN VARCHAR2,
654 p_global_attribute2 IN VARCHAR2,
655 p_global_attribute3 IN VARCHAR2,
656 p_global_attribute4 IN VARCHAR2,
657 p_global_attribute5 IN VARCHAR2,
658 p_global_attribute6 IN VARCHAR2,
659 p_global_attribute7 IN VARCHAR2,
660 p_global_attribute8 IN VARCHAR2,
661 p_global_attribute9 IN VARCHAR2,
662 p_global_attribute10 IN VARCHAR2,
663 p_global_attribute11 IN VARCHAR2,
664 p_global_attribute12 IN VARCHAR2,
665 p_global_attribute13 IN VARCHAR2,
666 p_global_attribute14 IN VARCHAR2,
667 p_global_attribute15 IN VARCHAR2,
668 p_global_attribute16 IN VARCHAR2,
669 p_global_attribute17 IN VARCHAR2,
670 p_global_attribute18 IN VARCHAR2,
671 p_global_attribute19 IN VARCHAR2,
672 p_global_attribute20 IN VARCHAR2,
673 p_cons_inv_flag IN VARCHAR2,
674 p_cons_inv_type IN VARCHAR2,
675 p_autocash_hier_id_for_adr IN NUMBER ,
676 p_lockbox_matching_option IN VARCHAR2,
677 --{2310474
678 p_party_id IN NUMBER DEFAULT NULL,
679 p_review_cycle IN VARCHAR2 DEFAULT NULL,
680 p_credit_classification IN VARCHAR2 DEFAULT NULL,
681 p_last_credit_review_date IN DATE DEFAULT NULL,
682 --}
683 a_last_update_date IN OUT NOCOPY DATE,
684 p_last_update_date IN OUT NOCOPY DATE,
685 x_cr_last_update_date IN OUT NOCOPY DATE,
686 x_pt_last_update_date IN OUT NOCOPY DATE,
687 x_cp_last_update_date IN OUT NOCOPY DATE,
688 x_op_last_update_date IN OUT NOCOPY DATE,
689 x_pp_last_update_date IN OUT NOCOPY DATE,
690 x_account_type IN VARCHAR,
691 o_organization_profile_id in out NOCOPY number,
692 o_person_profile_id in out NOCOPY number,
693 x_msg_count OUT NOCOPY NUMBER,
694 x_msg_data OUT NOCOPY varchar2,
695 x_return_status OUT NOCOPY VARCHAR2,
696 c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
697 x_cust_acct_object_version IN NUMBER DEFAULT -1,
698 x_cust_prof_object_version IN NUMBER DEFAULT -1,
699 x_party_object_version IN NUMBER DEFAULT -1);
700
701 --
702 -- Overload method for V2 uptake with the bug 1736839
703 --
704 PROCEDURE update_row(
705 c_cust_account_id IN OUT NOCOPY NUMBER ,
706 c_party_id IN NUMBER,
707 c_account_number IN VARCHAR2,
708 c_Attribute_Category IN VARCHAR2,
712 c_Attribute4 IN VARCHAR2,
709 c_Attribute1 IN VARCHAR2,
710 c_Attribute2 IN VARCHAR2,
711 c_Attribute3 IN VARCHAR2,
713 c_Attribute5 IN VARCHAR2,
714 c_Attribute6 IN VARCHAR2,
715 c_Attribute7 IN VARCHAR2,
716 c_Attribute8 IN VARCHAR2,
717 c_Attribute9 IN VARCHAR2,
718 c_Attribute10 IN VARCHAR2,
719 c_Attribute11 IN VARCHAR2,
720 c_Attribute12 IN VARCHAR2,
721 c_Attribute13 IN VARCHAR2,
722 c_Attribute14 IN VARCHAR2,
723 c_Attribute15 IN VARCHAR2,
724 c_Attribute16 IN VARCHAR2,
725 c_Attribute17 IN VARCHAR2,
726 c_Attribute18 IN VARCHAR2,
727 c_Attribute19 IN VARCHAR2,
728 c_Attribute20 IN VARCHAR2,
729 c_global_attribute_category IN VARCHAR2,
730 c_global_attribute1 IN VARCHAR2,
731 c_global_attribute2 IN VARCHAR2,
732 c_global_attribute3 IN VARCHAR2,
733 c_global_attribute4 IN VARCHAR2,
734 c_global_attribute5 IN VARCHAR2,
735 c_global_attribute6 IN VARCHAR2,
736 c_global_attribute7 IN VARCHAR2,
737 c_global_attribute8 IN VARCHAR2,
738 c_global_attribute9 IN VARCHAR2,
739 c_global_attribute10 IN VARCHAR2,
740 c_global_attribute11 IN VARCHAR2,
741 c_global_attribute12 IN VARCHAR2,
742 c_global_attribute13 IN VARCHAR2,
743 c_global_attribute14 IN VARCHAR2,
744 c_global_attribute15 IN VARCHAR2,
745 c_global_attribute16 IN VARCHAR2,
746 c_global_attribute17 IN VARCHAR2,
747 c_global_attribute18 IN VARCHAR2,
748 c_global_attribute19 IN VARCHAR2,
749 c_global_attribute20 IN VARCHAR2,
750 c_orig_system_reference IN VARCHAR2,
751 c_status IN VARCHAR2,
752 c_customer_type IN VARCHAR2,
753 c_customer_class_code IN VARCHAR2,
754 c_primary_salesrep_id IN NUMBER ,
755 c_sales_channel_code IN VARCHAR2,
756 c_order_type_id IN NUMBER,
757 c_price_list_id IN NUMBER ,
758 c_category_code IN VARCHAR2,
759 c_reference_use_flag IN VARCHAR2,
760 c_tax_code IN VARCHAR2,
761 c_third_party_flag IN VARCHAR2,
762 c_competitor_flag IN VARCHAR2,
763 c_fob_point IN VARCHAR2,
764 c_tax_header_level_flag IN VARCHAR2,
765 c_tax_rounding_rule IN VARCHAR2,
766 c_account_name IN VARCHAR2,
767 c_freight_term IN VARCHAR2,
768 c_ship_partial IN VARCHAR2,
769 c_ship_via IN VARCHAR2,
770 c_warehouse_id IN NUMBER,
771 c_payment_term_id IN NUMBER ,
772 c_analysis_fy IN VARCHAR2,
773 c_fiscal_yearend_month IN VARCHAR2,
774 c_employees_total IN NUMBER,
775 c_cr_fy_potential_revenue IN NUMBER,
776 c_next_fy_potential_revenue IN NUMBER,
777 c_tax_reference IN VARCHAR2,
778 c_year_established IN NUMBER,
779 c_gsa_indicator_flag IN VARCHAR2,
780 c_jgzz_fiscal_code IN VARCHAR2,
781 c_do_not_mail_flag IN VARCHAR2,
782 c_mission_statement IN VARCHAR2,
783 c_org_name_phonetic IN VARCHAR2,
784 c_url IN VARCHAR2,
785 c_person_suffix IN VARCHAR2,
786 c_first_name IN VARCHAR2,
787 c_middle_name IN VARCHAR2,
788 c_last_name IN VARCHAR2,
789 c_person_prefix IN VARCHAR2,
790 c_sic_code IN VARCHAR2,
791 c_sic_code_type IN VARCHAR2,
795 c_DATE_TYPE_PREFERENCE IN VARCHAR2,
792 c_duns_number IN NUMBER,
793 c_DATES_NEGATIVE_TOLERANCE IN NUMBER,
794 c_DATES_POSITIVE_TOLERANCE IN NUMBER,
796 c_OVER_SHIPMENT_TOLERANCE IN NUMBER,
797 c_UNDER_SHIPMENT_TOLERANCE IN NUMBER,
798 c_ITEM_CROSS_REF_PREF IN VARCHAR2,
799 c_OVER_RETURN_TOLERANCE IN NUMBER,
800 c_UNDER_RETURN_TOLERANCE IN NUMBER,
801 c_SHIP_SETS_INCLUDE_LINES_FLAG IN VARCHAR2,
802 c_ARRIVALSETS_INCL_LINES_FLAG IN VARCHAR2,
803 c_SCHED_DATE_PUSH_FLAG IN VARCHAR2,
804 c_INVOICE_QUANTITY_RULE IN VARCHAR2,
805 c_account_alias IN VARCHAR2 DEFAULT NULL,
806 p_cust_account_profile_id IN NUMBER ,
807 p_cust_account_id IN NUMBER ,
808 p_status IN VARCHAR2,
809 p_collector_id IN NUMBER ,
810 p_credit_analyst_id IN NUMBER ,
811 p_credit_checking IN VARCHAR2,
812 p_next_credit_review_date DATE ,
813 p_tolerance IN NUMBER,
814 p_discount_terms IN VARCHAR2,
815 p_dunning_letters IN VARCHAR2,
816 p_interest_charges IN VARCHAR2,
817 p_send_statements IN VARCHAR2,
818 p_credit_balance_statements IN VARCHAR2,
819 p_credit_hold IN VARCHAR2,
820 p_profile_class_id IN NUMBER ,
821 p_site_use_id IN NUMBER ,
822 p_credit_rating IN VARCHAR2,
823 p_risk_code IN VARCHAR2,
824 p_standard_terms IN NUMBER ,
825 p_override_terms IN VARCHAR2,
826 p_dunning_letter_set_id IN NUMBER,
827 p_interest_period_days IN NUMBER,
828 p_payment_grace_days IN NUMBER,
829 p_discount_grace_days IN NUMBER,
830 p_statement_cycle_id IN NUMBER ,
831 p_account_status IN VARCHAR2,
832 p_percent_collectable IN NUMBER ,
833 p_autocash_hierarchy_id IN NUMBER,
834 p_Attribute_Category IN VARCHAR2,
835 p_Attribute1 IN VARCHAR2,
836 p_Attribute2 IN VARCHAR2,
837 p_Attribute3 IN VARCHAR2,
838 p_Attribute4 IN VARCHAR2,
839 p_Attribute5 IN VARCHAR2,
840 p_Attribute6 IN VARCHAR2,
841 p_Attribute7 IN VARCHAR2,
842 p_Attribute8 IN VARCHAR2,
843 p_Attribute9 IN VARCHAR2,
844 p_Attribute10 IN VARCHAR2,
845 p_Attribute11 IN VARCHAR2,
846 p_Attribute12 IN VARCHAR2,
847 p_Attribute13 IN VARCHAR2,
848 p_Attribute14 IN VARCHAR2,
849 p_Attribute15 IN VARCHAR2,
850 p_auto_rec_incl_disputed_flag IN VARCHAR2,
851 p_tax_printing_option IN VARCHAR2,
852 p_charge_on_fin_charge_flag IN VARCHAR2,
853 p_grouping_rule_id IN NUMBER ,
854 p_clearing_days IN NUMBER,
855 p_jgzz_attribute_category IN VARCHAR2,
856 p_jgzz_attribute1 IN VARCHAR2,
857 p_jgzz_attribute2 IN VARCHAR2,
858 p_jgzz_attribute3 IN VARCHAR2,
859 p_jgzz_attribute4 IN VARCHAR2,
860 p_jgzz_attribute5 IN VARCHAR2,
861 p_jgzz_attribute6 IN VARCHAR2,
862 p_jgzz_attribute7 IN VARCHAR2,
863 p_jgzz_attribute8 IN VARCHAR2,
864 p_jgzz_attribute9 IN VARCHAR2,
865 p_jgzz_attribute10 IN VARCHAR2,
866 p_jgzz_attribute11 IN VARCHAR2,
867 p_jgzz_attribute12 IN VARCHAR2,
868 p_jgzz_attribute13 IN VARCHAR2,
869 p_jgzz_attribute14 IN VARCHAR2,
870 p_jgzz_attribute15 IN VARCHAR2,
871 p_global_attribute_category IN VARCHAR2,
872 p_global_attribute1 IN VARCHAR2,
873 p_global_attribute2 IN VARCHAR2,
874 p_global_attribute3 IN VARCHAR2,
878 p_global_attribute7 IN VARCHAR2,
875 p_global_attribute4 IN VARCHAR2,
876 p_global_attribute5 IN VARCHAR2,
877 p_global_attribute6 IN VARCHAR2,
879 p_global_attribute8 IN VARCHAR2,
880 p_global_attribute9 IN VARCHAR2,
881 p_global_attribute10 IN VARCHAR2,
882 p_global_attribute11 IN VARCHAR2,
883 p_global_attribute12 IN VARCHAR2,
884 p_global_attribute13 IN VARCHAR2,
885 p_global_attribute14 IN VARCHAR2,
886 p_global_attribute15 IN VARCHAR2,
887 p_global_attribute16 IN VARCHAR2,
888 p_global_attribute17 IN VARCHAR2,
889 p_global_attribute18 IN VARCHAR2,
890 p_global_attribute19 IN VARCHAR2,
891 p_global_attribute20 IN VARCHAR2,
892 p_cons_inv_flag IN VARCHAR2,
893 p_cons_inv_type IN VARCHAR2,
894 p_autocash_hier_id_for_adr IN NUMBER ,
895 p_lockbox_matching_option IN VARCHAR2,
896 --{2310474
897 p_party_id IN NUMBER DEFAULT NULL,
898 p_review_cycle IN VARCHAR2 DEFAULT NULL,
899 p_credit_classification IN VARCHAR2 DEFAULT NULL,
900 p_last_credit_review_date IN DATE DEFAULT NULL,
901 --}
902 a_last_update_date IN OUT NOCOPY DATE,
903 a_object_version IN OUT NOCOPY NUMBER,
904 p_last_update_date IN OUT NOCOPY DATE,
905 x_cr_last_update_date IN OUT NOCOPY DATE,
906 x_pt_last_update_date IN OUT NOCOPY DATE,
907 x_cp_last_update_date IN OUT NOCOPY DATE,
908 x_op_last_update_date IN OUT NOCOPY DATE,
909 x_pp_last_update_date IN OUT NOCOPY DATE,
910 x_account_type IN VARCHAR,
911 o_organization_profile_id in out NOCOPY number,
912 o_person_profile_id in out NOCOPY number,
913 x_msg_count OUT NOCOPY NUMBER,
914 x_msg_data OUT NOCOPY varchar2,
915 x_return_status OUT NOCOPY VARCHAR2,
916 c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
917 x_cust_acct_object_version IN NUMBER DEFAULT -1,
918 x_cust_prof_object_version IN NUMBER DEFAULT -1,
919 x_party_object_version IN NUMBER DEFAULT -1);
920
921 procedure check_unique_party_number(p_rowid in varchar2,
922 p_party_number in varchar2
923 );
924
925 end hz_acct_create_pkg;
|
|
|