[Home] [Help]
PACKAGE BODY: APPS.HZ_CUST_ACCOUNT_V2PUB_JW
Source
1 package body hz_cust_account_v2pub_jw as
2 /* $Header: ARH2CAJB.pls 120.9 2011/12/22 17:39:35 rgokavar ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_cust_account_1(p_init_msg_list VARCHAR2
23 , p_create_profile_amt VARCHAR2
24 , x_cust_account_id out nocopy NUMBER
25 , x_account_number out nocopy VARCHAR2
26 , x_party_id out nocopy NUMBER
27 , x_party_number out nocopy VARCHAR2
28 , x_profile_id out nocopy NUMBER
29 , x_return_status out nocopy VARCHAR2
30 , x_msg_count out nocopy NUMBER
31 , x_msg_data out nocopy VARCHAR2
32 , p1_a0 NUMBER := null
33 , p1_a1 VARCHAR2 := null
34 , p1_a2 VARCHAR2 := null
35 , p1_a3 VARCHAR2 := null
36 , p1_a4 VARCHAR2 := null
37 , p1_a5 VARCHAR2 := null
38 , p1_a6 VARCHAR2 := null
39 , p1_a7 VARCHAR2 := null
40 , p1_a8 VARCHAR2 := null
41 , p1_a9 VARCHAR2 := null
42 , p1_a10 VARCHAR2 := null
43 , p1_a11 VARCHAR2 := null
44 , p1_a12 VARCHAR2 := null
45 , p1_a13 VARCHAR2 := null
46 , p1_a14 VARCHAR2 := null
47 , p1_a15 VARCHAR2 := null
48 , p1_a16 VARCHAR2 := null
49 , p1_a17 VARCHAR2 := null
50 , p1_a18 VARCHAR2 := null
51 , p1_a19 VARCHAR2 := null
52 , p1_a20 VARCHAR2 := null
53 , p1_a21 VARCHAR2 := null
54 , p1_a22 VARCHAR2 := null
55 , p1_a23 VARCHAR2 := null
56 , p1_a24 VARCHAR2 := null
57 , p1_a25 VARCHAR2 := null
58 , p1_a26 VARCHAR2 := null
59 , p1_a27 VARCHAR2 := null
60 , p1_a28 VARCHAR2 := null
61 , p1_a29 VARCHAR2 := null
62 , p1_a30 VARCHAR2 := null
63 , p1_a31 VARCHAR2 := null
64 , p1_a32 VARCHAR2 := null
65 , p1_a33 VARCHAR2 := null
66 , p1_a34 VARCHAR2 := null
67 , p1_a35 VARCHAR2 := null
68 , p1_a36 VARCHAR2 := null
69 , p1_a37 VARCHAR2 := null
70 , p1_a38 VARCHAR2 := null
71 , p1_a39 VARCHAR2 := null
72 , p1_a40 VARCHAR2 := null
73 , p1_a41 VARCHAR2 := null
74 , p1_a42 VARCHAR2 := null
75 , p1_a43 VARCHAR2 := null
76 , p1_a44 VARCHAR2 := null
77 , p1_a45 VARCHAR2 := null
78 , p1_a46 VARCHAR2 := null
79 , p1_a47 VARCHAR2 := null
80 , p1_a48 VARCHAR2 := null
81 , p1_a49 NUMBER := null
82 , p1_a50 VARCHAR2 := null
83 , p1_a51 NUMBER := null
84 , p1_a52 NUMBER := null
85 , p1_a53 VARCHAR2 := null
86 , p1_a54 VARCHAR2 := null
87 , p1_a55 VARCHAR2 := null
88 , p1_a56 VARCHAR2 := null
89 , p1_a57 VARCHAR2 := null
90 , p1_a58 NUMBER := null
91 , p1_a59 VARCHAR2 := null
92 , p1_a60 VARCHAR2 := null
93 , p1_a61 VARCHAR2 := null
94 , p1_a62 NUMBER := null
95 , p1_a63 NUMBER := null
96 , p1_a64 VARCHAR2 := null
97 , p1_a65 NUMBER := null
98 , p1_a66 DATE := null
99 , p1_a67 DATE := null
100 , p1_a68 DATE := null
101 , p1_a69 VARCHAR2 := null
102 , p1_a70 DATE := null
103 , p1_a71 VARCHAR2 := null
104 , p1_a72 VARCHAR2 := null
105 , p1_a73 VARCHAR2 := null
106 , p1_a74 VARCHAR2 := null
107 , p1_a75 VARCHAR2 := null
108 , p1_a76 VARCHAR2 := null
109 , p1_a77 VARCHAR2 := null
110 , p1_a78 DATE := null
111 , p1_a79 VARCHAR2 := null
112 , p1_a80 VARCHAR2 := null
113 , p1_a81 NUMBER := null
114 , p1_a82 NUMBER := null
115 , p1_a83 VARCHAR2 := null
116 , p1_a84 NUMBER := null
117 , p1_a85 NUMBER := null
118 , p1_a86 NUMBER := null
119 , p1_a87 NUMBER := null
120 , p1_a88 VARCHAR2 := null
121 , p1_a89 VARCHAR2 := null
122 , p1_a90 VARCHAR2 := null
123 , p1_a91 VARCHAR2 := null
124 , p1_a92 VARCHAR2 := null
125 , p1_a93 VARCHAR2 := null
126 , p1_a94 DATE := null
127 , p1_a95 VARCHAR2 := null
128 , p1_a96 VARCHAR2 := null
129 , p1_a97 NUMBER := null
130 , p1_a98 NUMBER := null
131 , p1_a99 VARCHAR2 := null
132 , p1_a100 NUMBER := NULL
133 , p1_a101 VARCHAR2 := null
134 , p1_a102 VARCHAR2 := null
135 , p1_a103 VARCHAR2 := null
136 , p1_a104 VARCHAR2 := null
137 , p2_a0 VARCHAR2 := null
138 , p2_a1 VARCHAR2 := null
139 , p2_a2 VARCHAR2 := null
140 , p2_a3 VARCHAR2 := null
141 , p2_a4 VARCHAR2 := null
142 , p2_a5 VARCHAR2 := null
143 , p2_a6 VARCHAR2 := null
144 , p2_a7 VARCHAR2 := null
145 , p2_a8 VARCHAR2 := null
146 , p2_a9 VARCHAR2 := null
147 , p2_a10 VARCHAR2 := null
148 , p2_a11 VARCHAR2 := null
149 , p2_a12 VARCHAR2 := null
150 , p2_a13 VARCHAR2 := null
151 , p2_a14 VARCHAR2 := null
152 , p2_a15 VARCHAR2 := null
153 , p2_a16 VARCHAR2 := null
154 , p2_a17 VARCHAR2 := null
155 , p2_a18 VARCHAR2 := null
156 , p2_a19 VARCHAR2 := null
157 , p2_a20 VARCHAR2 := null
158 , p2_a21 VARCHAR2 := null
159 , p2_a22 DATE := null
160 , p2_a23 VARCHAR2 := null
161 , p2_a24 DATE := null
162 , p2_a25 VARCHAR2 := null
163 , p2_a26 VARCHAR2 := null
164 , p2_a27 VARCHAR2 := null
165 , p2_a28 VARCHAR2 := null
166 , p2_a29 DATE := null
167 , p2_a30 NUMBER := null
168 , p2_a31 VARCHAR2 := null
169 , p2_a32 NUMBER := null
170 , p2_a33 NUMBER := null
171 , p2_a34 VARCHAR2 := null
172 , p2_a35 VARCHAR2 := null
173 , p2_a36 VARCHAR2 := null
174 , p2_a37 VARCHAR2 := null
175 , p2_a38 VARCHAR2 := null
176 , p2_a39 VARCHAR2 := null
177 , p2_a40 VARCHAR2 := null
178 , p2_a41 VARCHAR2 := null
179 , p2_a42 VARCHAR2 := null
180 , p2_a43 VARCHAR2 := null
181 , p2_a44 VARCHAR2 := null
182 , p2_a45 VARCHAR2 := null
183 , p2_a46 VARCHAR2 := null
184 , p2_a47 VARCHAR2 := null
185 , p2_a48 VARCHAR2 := null
186 , p2_a49 VARCHAR2 := null
187 , p2_a50 VARCHAR2 := null
188 , p2_a51 VARCHAR2 := null
189 , p2_a52 VARCHAR2 := null
190 , p2_a53 VARCHAR2 := null
191 , p2_a54 VARCHAR2 := null
192 , p2_a55 VARCHAR2 := null
193 , p2_a56 VARCHAR2 := null
194 , p2_a57 VARCHAR2 := null
195 , p2_a58 VARCHAR2 := null
196 , p2_a59 VARCHAR2 := null
197 , p2_a60 NUMBER := null
198 , p2_a61 VARCHAR2 := null
199 , p2_a62 NUMBER := null
200 , p2_a63 VARCHAR2 := null
201 , p2_a64 VARCHAR2 := null
202 , p2_a65 VARCHAR2 := null
203 , p2_a66 VARCHAR2 := null
204 , p2_a67 VARCHAR2 := null
205 , p2_a68 VARCHAR2 := null
206 , p2_a69 VARCHAR2 := null
207 , p2_a70 VARCHAR2 := null
208 , p2_a71 VARCHAR2 := null
209 , p2_a72 VARCHAR2 := null
210 , p2_a73 VARCHAR2 := null
211 , p2_a74 VARCHAR2 := null
212 , p2_a75 VARCHAR2 := null
213 , p2_a76 VARCHAR2 := null
214 , p2_a77 VARCHAR2 := null
215 , p2_a78 VARCHAR2 := null
216 , p2_a79 VARCHAR2 := null
217 , p2_a80 VARCHAR2 := null
218 , p2_a81 VARCHAR2 := null
219 , p2_a82 VARCHAR2 := null
220 , p2_a83 VARCHAR2 := null
221 , p2_a84 VARCHAR2 := null
222 , p2_a85 VARCHAR2 := null
223 , p2_a86 VARCHAR2 := null
224 , p2_a87 VARCHAR2 := null
225 , p2_a88 VARCHAR2 := null
226 , p2_a89 VARCHAR2 := null
227 , p2_a90 VARCHAR2 := null
228 , p2_a91 VARCHAR2 := null
229 , p2_a92 VARCHAR2 := null
230 , p2_a93 VARCHAR2 := null
231 , p2_a94 VARCHAR2 := null
232 , p3_a0 NUMBER := null
233 , p3_a1 NUMBER := null
234 , p3_a2 VARCHAR2 := null
235 , p3_a3 NUMBER := null
236 , p3_a4 NUMBER := null
237 , p3_a5 VARCHAR2 := null
238 , p3_a6 DATE := null
239 , p3_a7 NUMBER := null
240 , p3_a8 VARCHAR2 := null
241 , p3_a9 VARCHAR2 := null
242 , p3_a10 VARCHAR2 := null
243 , p3_a11 VARCHAR2 := null
244 , p3_a12 VARCHAR2 := null
245 , p3_a13 VARCHAR2 := null
246 , p3_a14 NUMBER := null
247 , p3_a15 NUMBER := null
248 , p3_a16 VARCHAR2 := null
249 , p3_a17 VARCHAR2 := null
250 , p3_a18 NUMBER := null
251 , p3_a19 VARCHAR2 := null
252 , p3_a20 NUMBER := null
253 , p3_a21 NUMBER := null
254 , p3_a22 NUMBER := null
255 , p3_a23 NUMBER := null
256 , p3_a24 NUMBER := null
257 , p3_a25 VARCHAR2 := null
258 , p3_a26 NUMBER := null
259 , p3_a27 NUMBER := null
260 , p3_a28 VARCHAR2 := null
261 , p3_a29 VARCHAR2 := null
262 , p3_a30 VARCHAR2 := null
263 , p3_a31 VARCHAR2 := null
264 , p3_a32 VARCHAR2 := null
265 , p3_a33 VARCHAR2 := null
266 , p3_a34 VARCHAR2 := null
267 , p3_a35 VARCHAR2 := null
268 , p3_a36 VARCHAR2 := null
269 , p3_a37 VARCHAR2 := null
270 , p3_a38 VARCHAR2 := null
271 , p3_a39 VARCHAR2 := null
272 , p3_a40 VARCHAR2 := null
273 , p3_a41 VARCHAR2 := null
274 , p3_a42 VARCHAR2 := null
275 , p3_a43 VARCHAR2 := null
276 , p3_a44 VARCHAR2 := null
277 , p3_a45 VARCHAR2 := null
278 , p3_a46 VARCHAR2 := null
279 , p3_a47 NUMBER := null
280 , p3_a48 NUMBER := null
281 , p3_a49 VARCHAR2 := null
282 , p3_a50 VARCHAR2 := null
283 , p3_a51 VARCHAR2 := null
284 , p3_a52 VARCHAR2 := null
285 , p3_a53 VARCHAR2 := null
286 , p3_a54 VARCHAR2 := null
287 , p3_a55 VARCHAR2 := null
288 , p3_a56 VARCHAR2 := null
289 , p3_a57 VARCHAR2 := null
290 , p3_a58 VARCHAR2 := null
291 , p3_a59 VARCHAR2 := null
292 , p3_a60 VARCHAR2 := null
293 , p3_a61 VARCHAR2 := null
294 , p3_a62 VARCHAR2 := null
295 , p3_a63 VARCHAR2 := null
296 , p3_a64 VARCHAR2 := null
297 , p3_a65 VARCHAR2 := null
298 , p3_a66 VARCHAR2 := null
299 , p3_a67 VARCHAR2 := null
300 , p3_a68 VARCHAR2 := null
301 , p3_a69 VARCHAR2 := null
302 , p3_a70 VARCHAR2 := null
303 , p3_a71 VARCHAR2 := null
304 , p3_a72 VARCHAR2 := null
305 , p3_a73 VARCHAR2 := null
306 , p3_a74 VARCHAR2 := null
307 , p3_a75 VARCHAR2 := null
308 , p3_a76 VARCHAR2 := null
309 , p3_a77 VARCHAR2 := null
310 , p3_a78 VARCHAR2 := null
311 , p3_a79 VARCHAR2 := null
312 , p3_a80 VARCHAR2 := null
313 , p3_a81 VARCHAR2 := null
314 , p3_a82 VARCHAR2 := null
315 , p3_a83 VARCHAR2 := null
316 , p3_a84 VARCHAR2 := null
317 , p3_a85 VARCHAR2 := null
318 , p3_a86 VARCHAR2 := null
319 , p3_a87 VARCHAR2 := null
320 , p3_a88 NUMBER := null
321 , p3_a89 VARCHAR2 := null
322 , p3_a90 VARCHAR2 := null
323 , p3_a91 NUMBER := null
324 , p3_a92 VARCHAR2 := null
325 , p3_a93 DATE := null
326 , p3_a94 NUMBER := null
327 , p3_a95 VARCHAR2 := null
328 , p3_a96 VARCHAR2 := null
329 , p3_a97 VARCHAR2 := null
330 , p3_a98 VARCHAR2 := null
331 , p3_a99 VARCHAR2 := null
332 , p3_a100 VARCHAR2 := null
333 , p3_a101 NUMBER := null
334 , p3_a102 VARCHAR2 := null
335 , p3_a103 VARCHAR2 := null
336 , p3_a104 NUMBER := null
337 , p3_a105 VARCHAR2 := null
338 , p3_a106 DATE := null
339 )
340 as
341 ddp_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type;
342 ddp_person_rec hz_party_v2pub.person_rec_type;
343 ddp_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type;
344 ddindx binary_integer; indx binary_integer;
345 begin
346
347 -- copy data to the local IN or IN-OUT args, if any
348
349 ddp_cust_account_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
350 ddp_cust_account_rec.account_number := p1_a1;
351 ddp_cust_account_rec.attribute_category := p1_a2;
352 ddp_cust_account_rec.attribute1 := p1_a3;
353 ddp_cust_account_rec.attribute2 := p1_a4;
354 ddp_cust_account_rec.attribute3 := p1_a5;
355 ddp_cust_account_rec.attribute4 := p1_a6;
356 ddp_cust_account_rec.attribute5 := p1_a7;
357 ddp_cust_account_rec.attribute6 := p1_a8;
358 ddp_cust_account_rec.attribute7 := p1_a9;
359 ddp_cust_account_rec.attribute8 := p1_a10;
360 ddp_cust_account_rec.attribute9 := p1_a11;
361 ddp_cust_account_rec.attribute10 := p1_a12;
362 ddp_cust_account_rec.attribute11 := p1_a13;
363 ddp_cust_account_rec.attribute12 := p1_a14;
364 ddp_cust_account_rec.attribute13 := p1_a15;
365 ddp_cust_account_rec.attribute14 := p1_a16;
366 ddp_cust_account_rec.attribute15 := p1_a17;
367 ddp_cust_account_rec.attribute16 := p1_a18;
368 ddp_cust_account_rec.attribute17 := p1_a19;
369 ddp_cust_account_rec.attribute18 := p1_a20;
370 ddp_cust_account_rec.attribute19 := p1_a21;
371 ddp_cust_account_rec.attribute20 := p1_a22;
372 ddp_cust_account_rec.global_attribute_category := p1_a23;
373 ddp_cust_account_rec.global_attribute1 := p1_a24;
374 ddp_cust_account_rec.global_attribute2 := p1_a25;
375 ddp_cust_account_rec.global_attribute3 := p1_a26;
376 ddp_cust_account_rec.global_attribute4 := p1_a27;
377 ddp_cust_account_rec.global_attribute5 := p1_a28;
378 ddp_cust_account_rec.global_attribute6 := p1_a29;
379 ddp_cust_account_rec.global_attribute7 := p1_a30;
380 ddp_cust_account_rec.global_attribute8 := p1_a31;
381 ddp_cust_account_rec.global_attribute9 := p1_a32;
382 ddp_cust_account_rec.global_attribute10 := p1_a33;
383 ddp_cust_account_rec.global_attribute11 := p1_a34;
384 ddp_cust_account_rec.global_attribute12 := p1_a35;
385 ddp_cust_account_rec.global_attribute13 := p1_a36;
386 ddp_cust_account_rec.global_attribute14 := p1_a37;
387 ddp_cust_account_rec.global_attribute15 := p1_a38;
388 ddp_cust_account_rec.global_attribute16 := p1_a39;
389 ddp_cust_account_rec.global_attribute17 := p1_a40;
390 ddp_cust_account_rec.global_attribute18 := p1_a41;
391 ddp_cust_account_rec.global_attribute19 := p1_a42;
392 ddp_cust_account_rec.global_attribute20 := p1_a43;
393 ddp_cust_account_rec.orig_system_reference := p1_a44;
394 ddp_cust_account_rec.orig_system := p1_a45;
398 ddp_cust_account_rec.primary_salesrep_id := rosetta_g_miss_num_map(p1_a49);
395 ddp_cust_account_rec.status := p1_a46;
396 ddp_cust_account_rec.customer_type := p1_a47;
397 ddp_cust_account_rec.customer_class_code := p1_a48;
399 ddp_cust_account_rec.sales_channel_code := p1_a50;
400 ddp_cust_account_rec.order_type_id := rosetta_g_miss_num_map(p1_a51);
401 ddp_cust_account_rec.price_list_id := rosetta_g_miss_num_map(p1_a52);
402 ddp_cust_account_rec.tax_code := p1_a53;
403 ddp_cust_account_rec.fob_point := p1_a54;
404 ddp_cust_account_rec.freight_term := p1_a55;
405 ddp_cust_account_rec.ship_partial := p1_a56;
406 ddp_cust_account_rec.ship_via := p1_a57;
407 ddp_cust_account_rec.warehouse_id := rosetta_g_miss_num_map(p1_a58);
408 ddp_cust_account_rec.tax_header_level_flag := p1_a59;
409 ddp_cust_account_rec.tax_rounding_rule := p1_a60;
410 ddp_cust_account_rec.coterminate_day_month := p1_a61;
411 ddp_cust_account_rec.primary_specialist_id := rosetta_g_miss_num_map(p1_a62);
412 ddp_cust_account_rec.secondary_specialist_id := rosetta_g_miss_num_map(p1_a63);
413 ddp_cust_account_rec.account_liable_flag := p1_a64;
414 ddp_cust_account_rec.current_balance := rosetta_g_miss_num_map(p1_a65);
415 ddp_cust_account_rec.account_established_date := rosetta_g_miss_date_in_map(p1_a66);
416 ddp_cust_account_rec.account_termination_date := rosetta_g_miss_date_in_map(p1_a67);
417 ddp_cust_account_rec.account_activation_date := rosetta_g_miss_date_in_map(p1_a68);
418 ddp_cust_account_rec.department := p1_a69;
419 ddp_cust_account_rec.held_bill_expiration_date := rosetta_g_miss_date_in_map(p1_a70);
420 ddp_cust_account_rec.hold_bill_flag := p1_a71;
421 ddp_cust_account_rec.realtime_rate_flag := p1_a72;
422 ddp_cust_account_rec.acct_life_cycle_status := p1_a73;
423 ddp_cust_account_rec.account_name := p1_a74;
424 ddp_cust_account_rec.deposit_refund_method := p1_a75;
425 ddp_cust_account_rec.dormant_account_flag := p1_a76;
426 ddp_cust_account_rec.npa_number := p1_a77;
427 ddp_cust_account_rec.suspension_date := rosetta_g_miss_date_in_map(p1_a78);
428 ddp_cust_account_rec.source_code := p1_a79;
429 ddp_cust_account_rec.comments := p1_a80;
430 ddp_cust_account_rec.dates_negative_tolerance := rosetta_g_miss_num_map(p1_a81);
431 ddp_cust_account_rec.dates_positive_tolerance := rosetta_g_miss_num_map(p1_a82);
432 ddp_cust_account_rec.date_type_preference := p1_a83;
433 ddp_cust_account_rec.over_shipment_tolerance := rosetta_g_miss_num_map(p1_a84);
434 ddp_cust_account_rec.under_shipment_tolerance := rosetta_g_miss_num_map(p1_a85);
435 ddp_cust_account_rec.over_return_tolerance := rosetta_g_miss_num_map(p1_a86);
436 ddp_cust_account_rec.under_return_tolerance := rosetta_g_miss_num_map(p1_a87);
437 ddp_cust_account_rec.item_cross_ref_pref := p1_a88;
438 ddp_cust_account_rec.ship_sets_include_lines_flag := p1_a89;
439 ddp_cust_account_rec.arrivalsets_include_lines_flag := p1_a90;
440 ddp_cust_account_rec.sched_date_push_flag := p1_a91;
441 ddp_cust_account_rec.invoice_quantity_rule := p1_a92;
442 ddp_cust_account_rec.pricing_event := p1_a93;
443 ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);
444 ddp_cust_account_rec.autopay_flag := p1_a95;
445 ddp_cust_account_rec.notify_flag := p1_a96;
446 ddp_cust_account_rec.last_batch_id := rosetta_g_miss_num_map(p1_a97);
447 ddp_cust_account_rec.selling_party_id := rosetta_g_miss_num_map(p1_a98);
448 ddp_cust_account_rec.created_by_module := p1_a99;
449 ddp_cust_account_rec.application_id := rosetta_g_miss_num_map(p1_a100);
450 ddp_cust_account_rec.federal_entity_type := p1_a101;
451 ddp_cust_account_rec.trading_partner_agency_id := p1_a102;
452 ddp_cust_account_rec.duns_extension := p1_a103;
453 ddp_cust_account_rec.advance_payment_indicator := p1_a104;
454 ddp_person_rec.person_pre_name_adjunct := p2_a0;
455 ddp_person_rec.person_first_name := p2_a1;
456 ddp_person_rec.person_middle_name := p2_a2;
457 ddp_person_rec.person_last_name := p2_a3;
458 ddp_person_rec.person_name_suffix := p2_a4;
459 ddp_person_rec.person_title := p2_a5;
460 ddp_person_rec.person_academic_title := p2_a6;
461 ddp_person_rec.person_previous_last_name := p2_a7;
462 ddp_person_rec.person_initials := p2_a8;
463 ddp_person_rec.known_as := p2_a9;
464 ddp_person_rec.known_as2 := p2_a10;
465 ddp_person_rec.known_as3 := p2_a11;
466 ddp_person_rec.known_as4 := p2_a12;
467 ddp_person_rec.known_as5 := p2_a13;
468 ddp_person_rec.person_name_phonetic := p2_a14;
469 ddp_person_rec.person_first_name_phonetic := p2_a15;
470 ddp_person_rec.person_last_name_phonetic := p2_a16;
471 ddp_person_rec.middle_name_phonetic := p2_a17;
472 ddp_person_rec.tax_reference := p2_a18;
473 ddp_person_rec.jgzz_fiscal_code := p2_a19;
474 ddp_person_rec.person_iden_type := p2_a20;
475 ddp_person_rec.person_identifier := p2_a21;
476 ddp_person_rec.date_of_birth := rosetta_g_miss_date_in_map(p2_a22);
477 ddp_person_rec.place_of_birth := p2_a23;
478 ddp_person_rec.date_of_death := rosetta_g_miss_date_in_map(p2_a24);
479 ddp_person_rec.deceased_flag := p2_a25;
480 ddp_person_rec.gender := p2_a26;
481 ddp_person_rec.declared_ethnicity := p2_a27;
482 ddp_person_rec.marital_status := p2_a28;
483 ddp_person_rec.marital_status_effective_date := rosetta_g_miss_date_in_map(p2_a29);
484 ddp_person_rec.personal_income := rosetta_g_miss_num_map(p2_a30);
488 ddp_person_rec.rent_own_ind := p2_a34;
485 ddp_person_rec.head_of_household_flag := p2_a31;
486 ddp_person_rec.household_income := rosetta_g_miss_num_map(p2_a32);
487 ddp_person_rec.household_size := rosetta_g_miss_num_map(p2_a33);
489 ddp_person_rec.last_known_gps := p2_a35;
490 ddp_person_rec.content_source_type := p2_a36;
491 ddp_person_rec.internal_flag := p2_a37;
492 ddp_person_rec.attribute_category := p2_a38;
493 ddp_person_rec.attribute1 := p2_a39;
494 ddp_person_rec.attribute2 := p2_a40;
495 ddp_person_rec.attribute3 := p2_a41;
496 ddp_person_rec.attribute4 := p2_a42;
497 ddp_person_rec.attribute5 := p2_a43;
498 ddp_person_rec.attribute6 := p2_a44;
499 ddp_person_rec.attribute7 := p2_a45;
500 ddp_person_rec.attribute8 := p2_a46;
501 ddp_person_rec.attribute9 := p2_a47;
502 ddp_person_rec.attribute10 := p2_a48;
503 ddp_person_rec.attribute11 := p2_a49;
504 ddp_person_rec.attribute12 := p2_a50;
505 ddp_person_rec.attribute13 := p2_a51;
506 ddp_person_rec.attribute14 := p2_a52;
507 ddp_person_rec.attribute15 := p2_a53;
508 ddp_person_rec.attribute16 := p2_a54;
509 ddp_person_rec.attribute17 := p2_a55;
510 ddp_person_rec.attribute18 := p2_a56;
511 ddp_person_rec.attribute19 := p2_a57;
512 ddp_person_rec.attribute20 := p2_a58;
513 ddp_person_rec.created_by_module := p2_a59;
514 ddp_person_rec.application_id := rosetta_g_miss_num_map(p2_a60);
515 ddp_person_rec.actual_content_source := p2_a61;
516 ddp_person_rec.party_rec.party_id := rosetta_g_miss_num_map(p2_a62);
517 ddp_person_rec.party_rec.party_number := p2_a63;
518 ddp_person_rec.party_rec.validated_flag := p2_a64;
519 ddp_person_rec.party_rec.orig_system_reference := p2_a65;
520 ddp_person_rec.party_rec.orig_system := p2_a66;
521 ddp_person_rec.party_rec.status := p2_a67;
522 ddp_person_rec.party_rec.category_code := p2_a68;
523 ddp_person_rec.party_rec.salutation := p2_a69;
524 ddp_person_rec.party_rec.attribute_category := p2_a70;
525 ddp_person_rec.party_rec.attribute1 := p2_a71;
526 ddp_person_rec.party_rec.attribute2 := p2_a72;
527 ddp_person_rec.party_rec.attribute3 := p2_a73;
528 ddp_person_rec.party_rec.attribute4 := p2_a74;
529 ddp_person_rec.party_rec.attribute5 := p2_a75;
530 ddp_person_rec.party_rec.attribute6 := p2_a76;
531 ddp_person_rec.party_rec.attribute7 := p2_a77;
532 ddp_person_rec.party_rec.attribute8 := p2_a78;
533 ddp_person_rec.party_rec.attribute9 := p2_a79;
534 ddp_person_rec.party_rec.attribute10 := p2_a80;
535 ddp_person_rec.party_rec.attribute11 := p2_a81;
536 ddp_person_rec.party_rec.attribute12 := p2_a82;
537 ddp_person_rec.party_rec.attribute13 := p2_a83;
538 ddp_person_rec.party_rec.attribute14 := p2_a84;
539 ddp_person_rec.party_rec.attribute15 := p2_a85;
540 ddp_person_rec.party_rec.attribute16 := p2_a86;
541 ddp_person_rec.party_rec.attribute17 := p2_a87;
542 ddp_person_rec.party_rec.attribute18 := p2_a88;
543 ddp_person_rec.party_rec.attribute19 := p2_a89;
544 ddp_person_rec.party_rec.attribute20 := p2_a90;
545 ddp_person_rec.party_rec.attribute21 := p2_a91;
546 ddp_person_rec.party_rec.attribute22 := p2_a92;
547 ddp_person_rec.party_rec.attribute23 := p2_a93;
548 ddp_person_rec.party_rec.attribute24 := p2_a94;
549
550 ddp_customer_profile_rec.cust_account_profile_id := rosetta_g_miss_num_map(p3_a0);
551 ddp_customer_profile_rec.cust_account_id := rosetta_g_miss_num_map(p3_a1);
552 ddp_customer_profile_rec.status := p3_a2;
553 ddp_customer_profile_rec.collector_id := rosetta_g_miss_num_map(p3_a3);
554 ddp_customer_profile_rec.credit_analyst_id := rosetta_g_miss_num_map(p3_a4);
555 ddp_customer_profile_rec.credit_checking := p3_a5;
556 ddp_customer_profile_rec.next_credit_review_date := rosetta_g_miss_date_in_map(p3_a6);
557 ddp_customer_profile_rec.tolerance := rosetta_g_miss_num_map(p3_a7);
558 ddp_customer_profile_rec.discount_terms := p3_a8;
559 ddp_customer_profile_rec.dunning_letters := p3_a9;
560 ddp_customer_profile_rec.interest_charges := p3_a10;
561 ddp_customer_profile_rec.send_statements := p3_a11;
562 ddp_customer_profile_rec.credit_balance_statements := p3_a12;
563 ddp_customer_profile_rec.credit_hold := p3_a13;
564 ddp_customer_profile_rec.profile_class_id := rosetta_g_miss_num_map(p3_a14);
565 ddp_customer_profile_rec.site_use_id := rosetta_g_miss_num_map(p3_a15);
566 ddp_customer_profile_rec.credit_rating := p3_a16;
567 ddp_customer_profile_rec.risk_code := p3_a17;
568 ddp_customer_profile_rec.standard_terms := rosetta_g_miss_num_map(p3_a18);
569 ddp_customer_profile_rec.override_terms := p3_a19;
570 ddp_customer_profile_rec.dunning_letter_set_id := rosetta_g_miss_num_map(p3_a20);
571 ddp_customer_profile_rec.interest_period_days := rosetta_g_miss_num_map(p3_a21);
572 ddp_customer_profile_rec.payment_grace_days := rosetta_g_miss_num_map(p3_a22);
573 ddp_customer_profile_rec.discount_grace_days := rosetta_g_miss_num_map(p3_a23);
574 ddp_customer_profile_rec.statement_cycle_id := rosetta_g_miss_num_map(p3_a24);
575 ddp_customer_profile_rec.account_status := p3_a25;
576 ddp_customer_profile_rec.percent_collectable := rosetta_g_miss_num_map(p3_a26);
577 ddp_customer_profile_rec.autocash_hierarchy_id := rosetta_g_miss_num_map(p3_a27);
578 ddp_customer_profile_rec.attribute_category := p3_a28;
579 ddp_customer_profile_rec.attribute1 := p3_a29;
580 ddp_customer_profile_rec.attribute2 := p3_a30;
581 ddp_customer_profile_rec.attribute3 := p3_a31;
585 ddp_customer_profile_rec.attribute7 := p3_a35;
582 ddp_customer_profile_rec.attribute4 := p3_a32;
583 ddp_customer_profile_rec.attribute5 := p3_a33;
584 ddp_customer_profile_rec.attribute6 := p3_a34;
586 ddp_customer_profile_rec.attribute8 := p3_a36;
587 ddp_customer_profile_rec.attribute9 := p3_a37;
588 ddp_customer_profile_rec.attribute10 := p3_a38;
589 ddp_customer_profile_rec.attribute11 := p3_a39;
590 ddp_customer_profile_rec.attribute12 := p3_a40;
591 ddp_customer_profile_rec.attribute13 := p3_a41;
592 ddp_customer_profile_rec.attribute14 := p3_a42;
593 ddp_customer_profile_rec.attribute15 := p3_a43;
594 ddp_customer_profile_rec.auto_rec_incl_disputed_flag := p3_a44;
595 ddp_customer_profile_rec.tax_printing_option := p3_a45;
596 ddp_customer_profile_rec.charge_on_finance_charge_flag := p3_a46;
597 ddp_customer_profile_rec.grouping_rule_id := rosetta_g_miss_num_map(p3_a47);
598 ddp_customer_profile_rec.clearing_days := rosetta_g_miss_num_map(p3_a48);
599 ddp_customer_profile_rec.jgzz_attribute_category := p3_a49;
600 ddp_customer_profile_rec.jgzz_attribute1 := p3_a50;
601 ddp_customer_profile_rec.jgzz_attribute2 := p3_a51;
602 ddp_customer_profile_rec.jgzz_attribute3 := p3_a52;
603 ddp_customer_profile_rec.jgzz_attribute4 := p3_a53;
604 ddp_customer_profile_rec.jgzz_attribute5 := p3_a54;
605 ddp_customer_profile_rec.jgzz_attribute6 := p3_a55;
606 ddp_customer_profile_rec.jgzz_attribute7 := p3_a56;
607 ddp_customer_profile_rec.jgzz_attribute8 := p3_a57;
608 ddp_customer_profile_rec.jgzz_attribute9 := p3_a58;
609 ddp_customer_profile_rec.jgzz_attribute10 := p3_a59;
610 ddp_customer_profile_rec.jgzz_attribute11 := p3_a60;
611 ddp_customer_profile_rec.jgzz_attribute12 := p3_a61;
612 ddp_customer_profile_rec.jgzz_attribute13 := p3_a62;
613 ddp_customer_profile_rec.jgzz_attribute14 := p3_a63;
614 ddp_customer_profile_rec.jgzz_attribute15 := p3_a64;
615 ddp_customer_profile_rec.global_attribute1 := p3_a65;
616 ddp_customer_profile_rec.global_attribute2 := p3_a66;
617 ddp_customer_profile_rec.global_attribute3 := p3_a67;
618 ddp_customer_profile_rec.global_attribute4 := p3_a68;
619 ddp_customer_profile_rec.global_attribute5 := p3_a69;
620 ddp_customer_profile_rec.global_attribute6 := p3_a70;
621 ddp_customer_profile_rec.global_attribute7 := p3_a71;
622 ddp_customer_profile_rec.global_attribute8 := p3_a72;
623 ddp_customer_profile_rec.global_attribute9 := p3_a73;
624 ddp_customer_profile_rec.global_attribute10 := p3_a74;
625 ddp_customer_profile_rec.global_attribute11 := p3_a75;
626 ddp_customer_profile_rec.global_attribute12 := p3_a76;
627 ddp_customer_profile_rec.global_attribute13 := p3_a77;
628 ddp_customer_profile_rec.global_attribute14 := p3_a78;
629 ddp_customer_profile_rec.global_attribute15 := p3_a79;
630 ddp_customer_profile_rec.global_attribute16 := p3_a80;
631 ddp_customer_profile_rec.global_attribute17 := p3_a81;
632 ddp_customer_profile_rec.global_attribute18 := p3_a82;
633 ddp_customer_profile_rec.global_attribute19 := p3_a83;
634 ddp_customer_profile_rec.global_attribute20 := p3_a84;
635 ddp_customer_profile_rec.global_attribute_category := p3_a85;
636 ddp_customer_profile_rec.cons_inv_flag := p3_a86;
637 ddp_customer_profile_rec.cons_inv_type := p3_a87;
638 ddp_customer_profile_rec.autocash_hierarchy_id_for_adr := rosetta_g_miss_num_map(p3_a88);
639 ddp_customer_profile_rec.lockbox_matching_option := p3_a89;
640 ddp_customer_profile_rec.created_by_module := p3_a90;
641 ddp_customer_profile_rec.application_id := rosetta_g_miss_num_map(p3_a91);
642 ddp_customer_profile_rec.review_cycle := p3_a92;
643 ddp_customer_profile_rec.last_credit_review_date := rosetta_g_miss_date_in_map(p3_a93);
644 ddp_customer_profile_rec.party_id := rosetta_g_miss_num_map(p3_a94);
645 ddp_customer_profile_rec.credit_classification := p3_a95;
646 ddp_customer_profile_rec.cons_bill_level := p3_a96;
647 ddp_customer_profile_rec.late_charge_calculation_trx := p3_a97;
648 ddp_customer_profile_rec.credit_items_flag := p3_a98;
649 ddp_customer_profile_rec.disputed_transactions_flag := p3_a99;
650 ddp_customer_profile_rec.late_charge_type := p3_a100;
651 ddp_customer_profile_rec.late_charge_term_id := rosetta_g_miss_num_map(p3_a101);
652 ddp_customer_profile_rec.interest_calculation_period := p3_a102;
653 ddp_customer_profile_rec.hold_charged_invoices_flag := p3_a103;
654 ddp_customer_profile_rec.message_text_id := rosetta_g_miss_num_map(p3_a104);
655 ddp_customer_profile_rec.multiple_interest_rates_flag := p3_a105;
656 ddp_customer_profile_rec.charge_begin_date := rosetta_g_miss_date_in_map(p3_a106);
657
658
659
660
661
662
663
664
665
666
667 -- here's the delegated call to the old PL/SQL routine
668 hz_cust_account_v2pub.create_cust_account(p_init_msg_list,
669 ddp_cust_account_rec,
670 ddp_person_rec,
671 ddp_customer_profile_rec,
672 p_create_profile_amt,
673 x_cust_account_id,
674 x_account_number,
675 x_party_id,
676 x_party_number,
677 x_profile_id,
678 x_return_status,
679 x_msg_count,
680 x_msg_data);
681
682 -- copy data back from the local OUT or IN-OUT args, if any
683
684
685
686
687
688
689
690
691
692
693
694
695 end;
696
697 procedure create_cust_account_2(p_init_msg_list VARCHAR2
698 , p_create_profile_amt VARCHAR2
702 , x_party_number out nocopy VARCHAR2
699 , x_cust_account_id out nocopy NUMBER
700 , x_account_number out nocopy VARCHAR2
701 , x_party_id out nocopy NUMBER
703 , x_profile_id out nocopy NUMBER
704 , x_return_status out nocopy VARCHAR2
705 , x_msg_count out nocopy NUMBER
706 , x_msg_data out nocopy VARCHAR2
707 , p1_a0 NUMBER := null
708 , p1_a1 VARCHAR2 := null
709 , p1_a2 VARCHAR2 := null
710 , p1_a3 VARCHAR2 := null
711 , p1_a4 VARCHAR2 := null
712 , p1_a5 VARCHAR2 := null
713 , p1_a6 VARCHAR2 := null
714 , p1_a7 VARCHAR2 := null
715 , p1_a8 VARCHAR2 := null
716 , p1_a9 VARCHAR2 := null
717 , p1_a10 VARCHAR2 := null
718 , p1_a11 VARCHAR2 := null
719 , p1_a12 VARCHAR2 := null
720 , p1_a13 VARCHAR2 := null
721 , p1_a14 VARCHAR2 := null
722 , p1_a15 VARCHAR2 := null
723 , p1_a16 VARCHAR2 := null
724 , p1_a17 VARCHAR2 := null
725 , p1_a18 VARCHAR2 := null
726 , p1_a19 VARCHAR2 := null
727 , p1_a20 VARCHAR2 := null
728 , p1_a21 VARCHAR2 := null
729 , p1_a22 VARCHAR2 := null
730 , p1_a23 VARCHAR2 := null
731 , p1_a24 VARCHAR2 := null
732 , p1_a25 VARCHAR2 := null
733 , p1_a26 VARCHAR2 := null
734 , p1_a27 VARCHAR2 := null
735 , p1_a28 VARCHAR2 := null
736 , p1_a29 VARCHAR2 := null
737 , p1_a30 VARCHAR2 := null
738 , p1_a31 VARCHAR2 := null
739 , p1_a32 VARCHAR2 := null
740 , p1_a33 VARCHAR2 := null
741 , p1_a34 VARCHAR2 := null
742 , p1_a35 VARCHAR2 := null
743 , p1_a36 VARCHAR2 := null
744 , p1_a37 VARCHAR2 := null
745 , p1_a38 VARCHAR2 := null
746 , p1_a39 VARCHAR2 := null
747 , p1_a40 VARCHAR2 := null
748 , p1_a41 VARCHAR2 := null
749 , p1_a42 VARCHAR2 := null
750 , p1_a43 VARCHAR2 := null
751 , p1_a44 VARCHAR2 := null
752 , p1_a45 VARCHAR2 := null
753 , p1_a46 VARCHAR2 := null
754 , p1_a47 VARCHAR2 := null
755 , p1_a48 VARCHAR2 := null
756 , p1_a49 NUMBER := null
757 , p1_a50 VARCHAR2 := null
758 , p1_a51 NUMBER := null
759 , p1_a52 NUMBER := null
760 , p1_a53 VARCHAR2 := null
761 , p1_a54 VARCHAR2 := null
762 , p1_a55 VARCHAR2 := null
763 , p1_a56 VARCHAR2 := null
764 , p1_a57 VARCHAR2 := null
765 , p1_a58 NUMBER := null
766 , p1_a59 VARCHAR2 := null
767 , p1_a60 VARCHAR2 := null
768 , p1_a61 VARCHAR2 := null
769 , p1_a62 NUMBER := null
770 , p1_a63 NUMBER := null
771 , p1_a64 VARCHAR2 := null
772 , p1_a65 NUMBER := null
773 , p1_a66 DATE := null
774 , p1_a67 DATE := null
775 , p1_a68 DATE := null
776 , p1_a69 VARCHAR2 := null
777 , p1_a70 DATE := null
778 , p1_a71 VARCHAR2 := null
779 , p1_a72 VARCHAR2 := null
780 , p1_a73 VARCHAR2 := null
781 , p1_a74 VARCHAR2 := null
782 , p1_a75 VARCHAR2 := null
783 , p1_a76 VARCHAR2 := null
784 , p1_a77 VARCHAR2 := null
785 , p1_a78 DATE := null
786 , p1_a79 VARCHAR2 := null
787 , p1_a80 VARCHAR2 := null
788 , p1_a81 NUMBER := null
789 , p1_a82 NUMBER := null
790 , p1_a83 VARCHAR2 := null
791 , p1_a84 NUMBER := null
792 , p1_a85 NUMBER := null
793 , p1_a86 NUMBER := null
794 , p1_a87 NUMBER := null
795 , p1_a88 VARCHAR2 := null
796 , p1_a89 VARCHAR2 := null
797 , p1_a90 VARCHAR2 := null
798 , p1_a91 VARCHAR2 := null
799 , p1_a92 VARCHAR2 := null
800 , p1_a93 VARCHAR2 := null
801 , p1_a94 DATE := null
802 , p1_a95 VARCHAR2 := null
803 , p1_a96 VARCHAR2 := null
804 , p1_a97 NUMBER := null
805 , p1_a98 NUMBER := null
806 , p1_a99 VARCHAR2 := null
807 , p1_a100 NUMBER := NULL
808 , p1_a101 VARCHAR2 := null
809 , p1_a102 VARCHAR2 := null
810 , p1_a103 VARCHAR2 := null
811 , p1_a104 VARCHAR2 := null
812 , p2_a0 VARCHAR2 := null
813 , p2_a1 VARCHAR2 := null
814 , p2_a2 VARCHAR2 := null
815 , p2_a3 VARCHAR2 := null
816 , p2_a4 VARCHAR2 := null
817 , p2_a5 VARCHAR2 := null
818 , p2_a6 VARCHAR2 := null
819 , p2_a7 VARCHAR2 := null
820 , p2_a8 NUMBER := null
821 , p2_a9 NUMBER := null
822 , p2_a10 VARCHAR2 := null
823 , p2_a11 VARCHAR2 := null
824 , p2_a12 VARCHAR2 := null
825 , p2_a13 VARCHAR2 := null
826 , p2_a14 VARCHAR2 := null
827 , p2_a15 VARCHAR2 := null
828 , p2_a16 VARCHAR2 := null
829 , p2_a17 VARCHAR2 := null
830 , p2_a18 VARCHAR2 := null
831 , p2_a19 VARCHAR2 := null
832 , p2_a20 VARCHAR2 := null
833 , p2_a21 VARCHAR2 := null
834 , p2_a22 VARCHAR2 := null
835 , p2_a23 VARCHAR2 := null
836 , p2_a24 VARCHAR2 := null
837 , p2_a25 VARCHAR2 := null
838 , p2_a26 NUMBER := null
839 , p2_a27 DATE := null
840 , p2_a28 VARCHAR2 := null
841 , p2_a29 NUMBER := null
842 , p2_a30 VARCHAR2 := null
843 , p2_a31 VARCHAR2 := null
844 , p2_a32 VARCHAR2 := null
845 , p2_a33 VARCHAR2 := null
849 , p2_a37 VARCHAR2 := null
846 , p2_a34 VARCHAR2 := null
847 , p2_a35 VARCHAR2 := null
848 , p2_a36 VARCHAR2 := null
850 , p2_a38 VARCHAR2 := null
851 , p2_a39 DATE := null
852 , p2_a40 DATE := null
853 , p2_a41 VARCHAR2 := null
854 , p2_a42 VARCHAR2 := null
855 , p2_a43 VARCHAR2 := null
856 , p2_a44 VARCHAR2 := null
857 , p2_a45 VARCHAR2 := null
858 , p2_a46 VARCHAR2 := null
859 , p2_a47 NUMBER := null
860 , p2_a48 NUMBER := null
861 , p2_a49 NUMBER := null
862 , p2_a50 VARCHAR2 := null
863 , p2_a51 VARCHAR2 := null
864 , p2_a52 VARCHAR2 := null
865 , p2_a53 VARCHAR2 := null
866 , p2_a54 VARCHAR2 := null
867 , p2_a55 VARCHAR2 := null
868 , p2_a56 VARCHAR2 := null
869 , p2_a57 VARCHAR2 := null
870 , p2_a58 VARCHAR2 := null
871 , p2_a59 VARCHAR2 := null
872 , p2_a60 VARCHAR2 := null
873 , p2_a61 VARCHAR2 := null
874 , p2_a62 VARCHAR2 := null
875 , p2_a63 VARCHAR2 := null
876 , p2_a64 VARCHAR2 := null
877 , p2_a65 VARCHAR2 := null
878 , p2_a66 VARCHAR2 := null
879 , p2_a67 VARCHAR2 := null
880 , p2_a68 NUMBER := null
881 , p2_a69 VARCHAR2 := null
882 , p2_a70 VARCHAR2 := null
883 , p2_a71 VARCHAR2 := null
884 , p2_a72 VARCHAR2 := null
885 , p2_a73 VARCHAR2 := null
886 , p2_a74 VARCHAR2 := null
887 , p2_a75 VARCHAR2 := null
888 , p2_a76 VARCHAR2 := null
889 , p2_a77 VARCHAR2 := null
890 , p2_a78 NUMBER := null
891 , p2_a79 NUMBER := null
892 , p2_a80 NUMBER := null
893 , p2_a81 NUMBER := null
894 , p2_a82 NUMBER := null
895 , p2_a83 NUMBER := null
896 , p2_a84 NUMBER := null
897 , p2_a85 DATE := null
898 , p2_a86 VARCHAR2 := null
899 , p2_a87 VARCHAR2 := null
900 , p2_a88 VARCHAR2 := null
901 , p2_a89 VARCHAR2 := null
902 , p2_a90 VARCHAR2 := null
903 , p2_a91 VARCHAR2 := null
904 , p2_a92 VARCHAR2 := null
905 , p2_a93 VARCHAR2 := null
906 , p2_a94 VARCHAR2 := null
907 , p2_a95 NUMBER := null
908 , p2_a96 NUMBER := null
909 , p2_a97 NUMBER := null
910 , p2_a98 DATE := null
911 , p2_a99 VARCHAR2 := null
912 , p2_a100 VARCHAR2 := null
913 , p2_a101 VARCHAR2 := null
914 , p2_a102 VARCHAR2 := null
915 , p2_a103 VARCHAR2 := null
916 , p2_a104 VARCHAR2 := null
917 , p2_a105 VARCHAR2 := null
918 , p2_a106 VARCHAR2 := null
919 , p2_a107 VARCHAR2 := null
920 , p2_a108 NUMBER := null
921 , p2_a109 VARCHAR2 := null
922 , p2_a110 NUMBER := null
923 , p2_a111 VARCHAR2 := null
924 , p2_a112 VARCHAR2 := null
925 , p2_a113 VARCHAR2 := null
926 , p2_a114 VARCHAR2 := null
927 , p2_a115 VARCHAR2 := null
928 , p2_a116 VARCHAR2 := null
929 , p2_a117 VARCHAR2 := null
930 , p2_a118 VARCHAR2 := null
931 , p2_a119 VARCHAR2 := null
932 , p2_a120 VARCHAR2 := null
933 , p2_a121 VARCHAR2 := null
934 , p2_a122 VARCHAR2 := null
935 , p2_a123 VARCHAR2 := null
936 , p2_a124 VARCHAR2 := null
937 , p2_a125 VARCHAR2 := null
938 , p2_a126 VARCHAR2 := null
939 , p2_a127 VARCHAR2 := null
940 , p2_a128 VARCHAR2 := null
941 , p2_a129 VARCHAR2 := null
942 , p2_a130 VARCHAR2 := null
943 , p2_a131 VARCHAR2 := null
944 , p2_a132 VARCHAR2 := null
945 , p2_a133 VARCHAR2 := null
946 , p2_a134 VARCHAR2 := null
947 , p2_a135 NUMBER := null
948 , p2_a136 VARCHAR2 := null
949 , p2_a137 VARCHAR2 := null
950 , p2_a138 VARCHAR2 := null
951 , p2_a139 NUMBER := null
952 , p2_a140 VARCHAR2 := null
953 , p2_a141 VARCHAR2 := null
954 , p2_a142 VARCHAR2 := null
955 , p2_a143 VARCHAR2 := null
956 , p2_a144 VARCHAR2 := null
957 , p2_a145 VARCHAR2 := null
958 , p2_a146 VARCHAR2 := null
959 , p2_a147 VARCHAR2 := null
960 , p2_a148 VARCHAR2 := null
961 , p2_a149 VARCHAR2 := null
962 , p2_a150 VARCHAR2 := null
963 , p2_a151 VARCHAR2 := null
964 , p2_a152 VARCHAR2 := null
965 , p2_a153 VARCHAR2 := null
966 , p2_a154 VARCHAR2 := null
967 , p2_a155 VARCHAR2 := null
968 , p2_a156 VARCHAR2 := null
969 , p2_a157 VARCHAR2 := null
970 , p2_a158 VARCHAR2 := null
971 , p2_a159 VARCHAR2 := null
972 , p2_a160 VARCHAR2 := null
973 , p2_a161 VARCHAR2 := null
974 , p2_a162 VARCHAR2 := null
975 , p2_a163 VARCHAR2 := null
976 , p2_a164 VARCHAR2 := null
977 , p2_a165 VARCHAR2 := null
978 , p2_a166 VARCHAR2 := null
979 , p2_a167 VARCHAR2 := null
980 , p2_a168 VARCHAR2 := null
981 , p2_a169 VARCHAR2 := null
982 , p2_a170 VARCHAR2 := null
983 , p2_a171 VARCHAR2 := null
984 , p3_a0 NUMBER := null
985 , p3_a1 NUMBER := null
986 , p3_a2 VARCHAR2 := null
987 , p3_a3 NUMBER := null
988 , p3_a4 NUMBER := null
989 , p3_a5 VARCHAR2 := null
990 , p3_a6 DATE := null
994 , p3_a10 VARCHAR2 := null
991 , p3_a7 NUMBER := null
992 , p3_a8 VARCHAR2 := null
993 , p3_a9 VARCHAR2 := null
995 , p3_a11 VARCHAR2 := null
996 , p3_a12 VARCHAR2 := null
997 , p3_a13 VARCHAR2 := null
998 , p3_a14 NUMBER := null
999 , p3_a15 NUMBER := null
1000 , p3_a16 VARCHAR2 := null
1001 , p3_a17 VARCHAR2 := null
1002 , p3_a18 NUMBER := null
1003 , p3_a19 VARCHAR2 := null
1004 , p3_a20 NUMBER := null
1005 , p3_a21 NUMBER := null
1006 , p3_a22 NUMBER := null
1007 , p3_a23 NUMBER := null
1008 , p3_a24 NUMBER := null
1009 , p3_a25 VARCHAR2 := null
1010 , p3_a26 NUMBER := null
1011 , p3_a27 NUMBER := null
1012 , p3_a28 VARCHAR2 := null
1013 , p3_a29 VARCHAR2 := null
1014 , p3_a30 VARCHAR2 := null
1015 , p3_a31 VARCHAR2 := null
1016 , p3_a32 VARCHAR2 := null
1017 , p3_a33 VARCHAR2 := null
1018 , p3_a34 VARCHAR2 := null
1019 , p3_a35 VARCHAR2 := null
1020 , p3_a36 VARCHAR2 := null
1021 , p3_a37 VARCHAR2 := null
1022 , p3_a38 VARCHAR2 := null
1023 , p3_a39 VARCHAR2 := null
1024 , p3_a40 VARCHAR2 := null
1025 , p3_a41 VARCHAR2 := null
1026 , p3_a42 VARCHAR2 := null
1027 , p3_a43 VARCHAR2 := null
1028 , p3_a44 VARCHAR2 := null
1029 , p3_a45 VARCHAR2 := null
1030 , p3_a46 VARCHAR2 := null
1031 , p3_a47 NUMBER := null
1032 , p3_a48 NUMBER := null
1033 , p3_a49 VARCHAR2 := null
1034 , p3_a50 VARCHAR2 := null
1035 , p3_a51 VARCHAR2 := null
1036 , p3_a52 VARCHAR2 := null
1037 , p3_a53 VARCHAR2 := null
1038 , p3_a54 VARCHAR2 := null
1039 , p3_a55 VARCHAR2 := null
1040 , p3_a56 VARCHAR2 := null
1041 , p3_a57 VARCHAR2 := null
1042 , p3_a58 VARCHAR2 := null
1043 , p3_a59 VARCHAR2 := null
1044 , p3_a60 VARCHAR2 := null
1045 , p3_a61 VARCHAR2 := null
1046 , p3_a62 VARCHAR2 := null
1047 , p3_a63 VARCHAR2 := null
1048 , p3_a64 VARCHAR2 := null
1049 , p3_a65 VARCHAR2 := null
1050 , p3_a66 VARCHAR2 := null
1051 , p3_a67 VARCHAR2 := null
1052 , p3_a68 VARCHAR2 := null
1053 , p3_a69 VARCHAR2 := null
1054 , p3_a70 VARCHAR2 := null
1055 , p3_a71 VARCHAR2 := null
1056 , p3_a72 VARCHAR2 := null
1057 , p3_a73 VARCHAR2 := null
1058 , p3_a74 VARCHAR2 := null
1059 , p3_a75 VARCHAR2 := null
1060 , p3_a76 VARCHAR2 := null
1061 , p3_a77 VARCHAR2 := null
1062 , p3_a78 VARCHAR2 := null
1063 , p3_a79 VARCHAR2 := null
1064 , p3_a80 VARCHAR2 := null
1065 , p3_a81 VARCHAR2 := null
1066 , p3_a82 VARCHAR2 := null
1067 , p3_a83 VARCHAR2 := null
1068 , p3_a84 VARCHAR2 := null
1069 , p3_a85 VARCHAR2 := null
1070 , p3_a86 VARCHAR2 := null
1071 , p3_a87 VARCHAR2 := null
1072 , p3_a88 NUMBER := null
1073 , p3_a89 VARCHAR2 := null
1074 , p3_a90 VARCHAR2 := null
1075 , p3_a91 NUMBER := null
1076 , p3_a92 VARCHAR2 := null
1077 , p3_a93 DATE := null
1078 , p3_a94 NUMBER := null
1079 , p3_a95 VARCHAR2 := null
1080 , p3_a96 VARCHAR2 := null
1081 , p3_a97 VARCHAR2 := null
1082 , p3_a98 VARCHAR2 := null
1083 , p3_a99 VARCHAR2 := null
1084 , p3_a100 VARCHAR2 := null
1085 , p3_a101 NUMBER := null
1086 , p3_a102 VARCHAR2 := null
1087 , p3_a103 VARCHAR2 := null
1088 , p3_a104 NUMBER := null
1089 , p3_a105 VARCHAR2 := null
1090 , p3_a106 DATE := null
1091 )
1092 as
1093 ddp_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type;
1094 ddp_organization_rec hz_party_v2pub.organization_rec_type;
1095 ddp_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type;
1096 ddindx binary_integer; indx binary_integer;
1097 begin
1098
1099 -- copy data to the local IN or IN-OUT args, if any
1100
1101 ddp_cust_account_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
1102 ddp_cust_account_rec.account_number := p1_a1;
1103 ddp_cust_account_rec.attribute_category := p1_a2;
1104 ddp_cust_account_rec.attribute1 := p1_a3;
1105 ddp_cust_account_rec.attribute2 := p1_a4;
1106 ddp_cust_account_rec.attribute3 := p1_a5;
1107 ddp_cust_account_rec.attribute4 := p1_a6;
1108 ddp_cust_account_rec.attribute5 := p1_a7;
1109 ddp_cust_account_rec.attribute6 := p1_a8;
1110 ddp_cust_account_rec.attribute7 := p1_a9;
1111 ddp_cust_account_rec.attribute8 := p1_a10;
1112 ddp_cust_account_rec.attribute9 := p1_a11;
1113 ddp_cust_account_rec.attribute10 := p1_a12;
1114 ddp_cust_account_rec.attribute11 := p1_a13;
1115 ddp_cust_account_rec.attribute12 := p1_a14;
1116 ddp_cust_account_rec.attribute13 := p1_a15;
1117 ddp_cust_account_rec.attribute14 := p1_a16;
1118 ddp_cust_account_rec.attribute15 := p1_a17;
1119 ddp_cust_account_rec.attribute16 := p1_a18;
1120 ddp_cust_account_rec.attribute17 := p1_a19;
1121 ddp_cust_account_rec.attribute18 := p1_a20;
1122 ddp_cust_account_rec.attribute19 := p1_a21;
1123 ddp_cust_account_rec.attribute20 := p1_a22;
1124 ddp_cust_account_rec.global_attribute_category := p1_a23;
1125 ddp_cust_account_rec.global_attribute1 := p1_a24;
1126 ddp_cust_account_rec.global_attribute2 := p1_a25;
1127 ddp_cust_account_rec.global_attribute3 := p1_a26;
1131 ddp_cust_account_rec.global_attribute7 := p1_a30;
1128 ddp_cust_account_rec.global_attribute4 := p1_a27;
1129 ddp_cust_account_rec.global_attribute5 := p1_a28;
1130 ddp_cust_account_rec.global_attribute6 := p1_a29;
1132 ddp_cust_account_rec.global_attribute8 := p1_a31;
1133 ddp_cust_account_rec.global_attribute9 := p1_a32;
1134 ddp_cust_account_rec.global_attribute10 := p1_a33;
1135 ddp_cust_account_rec.global_attribute11 := p1_a34;
1136 ddp_cust_account_rec.global_attribute12 := p1_a35;
1137 ddp_cust_account_rec.global_attribute13 := p1_a36;
1138 ddp_cust_account_rec.global_attribute14 := p1_a37;
1139 ddp_cust_account_rec.global_attribute15 := p1_a38;
1140 ddp_cust_account_rec.global_attribute16 := p1_a39;
1141 ddp_cust_account_rec.global_attribute17 := p1_a40;
1142 ddp_cust_account_rec.global_attribute18 := p1_a41;
1143 ddp_cust_account_rec.global_attribute19 := p1_a42;
1144 ddp_cust_account_rec.global_attribute20 := p1_a43;
1145 ddp_cust_account_rec.orig_system_reference := p1_a44;
1146 ddp_cust_account_rec.orig_system := p1_a45;
1147 ddp_cust_account_rec.status := p1_a46;
1148 ddp_cust_account_rec.customer_type := p1_a47;
1149 ddp_cust_account_rec.customer_class_code := p1_a48;
1150 ddp_cust_account_rec.primary_salesrep_id := rosetta_g_miss_num_map(p1_a49);
1151 ddp_cust_account_rec.sales_channel_code := p1_a50;
1152 ddp_cust_account_rec.order_type_id := rosetta_g_miss_num_map(p1_a51);
1153 ddp_cust_account_rec.price_list_id := rosetta_g_miss_num_map(p1_a52);
1154 ddp_cust_account_rec.tax_code := p1_a53;
1155 ddp_cust_account_rec.fob_point := p1_a54;
1156 ddp_cust_account_rec.freight_term := p1_a55;
1157 ddp_cust_account_rec.ship_partial := p1_a56;
1158 ddp_cust_account_rec.ship_via := p1_a57;
1159 ddp_cust_account_rec.warehouse_id := rosetta_g_miss_num_map(p1_a58);
1160 ddp_cust_account_rec.tax_header_level_flag := p1_a59;
1161 ddp_cust_account_rec.tax_rounding_rule := p1_a60;
1162 ddp_cust_account_rec.coterminate_day_month := p1_a61;
1163 ddp_cust_account_rec.primary_specialist_id := rosetta_g_miss_num_map(p1_a62);
1164 ddp_cust_account_rec.secondary_specialist_id := rosetta_g_miss_num_map(p1_a63);
1165 ddp_cust_account_rec.account_liable_flag := p1_a64;
1166 ddp_cust_account_rec.current_balance := rosetta_g_miss_num_map(p1_a65);
1167 ddp_cust_account_rec.account_established_date := rosetta_g_miss_date_in_map(p1_a66);
1168 ddp_cust_account_rec.account_termination_date := rosetta_g_miss_date_in_map(p1_a67);
1169 ddp_cust_account_rec.account_activation_date := rosetta_g_miss_date_in_map(p1_a68);
1170 ddp_cust_account_rec.department := p1_a69;
1171 ddp_cust_account_rec.held_bill_expiration_date := rosetta_g_miss_date_in_map(p1_a70);
1172 ddp_cust_account_rec.hold_bill_flag := p1_a71;
1173 ddp_cust_account_rec.realtime_rate_flag := p1_a72;
1174 ddp_cust_account_rec.acct_life_cycle_status := p1_a73;
1175 ddp_cust_account_rec.account_name := p1_a74;
1176 ddp_cust_account_rec.deposit_refund_method := p1_a75;
1177 ddp_cust_account_rec.dormant_account_flag := p1_a76;
1178 ddp_cust_account_rec.npa_number := p1_a77;
1179 ddp_cust_account_rec.suspension_date := rosetta_g_miss_date_in_map(p1_a78);
1180 ddp_cust_account_rec.source_code := p1_a79;
1181 ddp_cust_account_rec.comments := p1_a80;
1182 ddp_cust_account_rec.dates_negative_tolerance := rosetta_g_miss_num_map(p1_a81);
1183 ddp_cust_account_rec.dates_positive_tolerance := rosetta_g_miss_num_map(p1_a82);
1184 ddp_cust_account_rec.date_type_preference := p1_a83;
1185 ddp_cust_account_rec.over_shipment_tolerance := rosetta_g_miss_num_map(p1_a84);
1186 ddp_cust_account_rec.under_shipment_tolerance := rosetta_g_miss_num_map(p1_a85);
1187 ddp_cust_account_rec.over_return_tolerance := rosetta_g_miss_num_map(p1_a86);
1188 ddp_cust_account_rec.under_return_tolerance := rosetta_g_miss_num_map(p1_a87);
1189 ddp_cust_account_rec.item_cross_ref_pref := p1_a88;
1190 ddp_cust_account_rec.ship_sets_include_lines_flag := p1_a89;
1191 ddp_cust_account_rec.arrivalsets_include_lines_flag := p1_a90;
1192 ddp_cust_account_rec.sched_date_push_flag := p1_a91;
1193 ddp_cust_account_rec.invoice_quantity_rule := p1_a92;
1194 ddp_cust_account_rec.pricing_event := p1_a93;
1195 ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);
1196 ddp_cust_account_rec.autopay_flag := p1_a95;
1197 ddp_cust_account_rec.notify_flag := p1_a96;
1198 ddp_cust_account_rec.last_batch_id := rosetta_g_miss_num_map(p1_a97);
1199 ddp_cust_account_rec.selling_party_id := rosetta_g_miss_num_map(p1_a98);
1200 ddp_cust_account_rec.created_by_module := p1_a99;
1201 ddp_cust_account_rec.application_id := rosetta_g_miss_num_map(p1_a100);
1202 ddp_cust_account_rec.federal_entity_type := p1_a101;
1203 ddp_cust_account_rec.trading_partner_agency_id := p1_a102;
1204 ddp_cust_account_rec.duns_extension := p1_a103;
1205 ddp_cust_account_rec.advance_payment_indicator := p1_a104;
1206 ddp_organization_rec.organization_name := p2_a0;
1207 ddp_organization_rec.duns_number_c := p2_a1;
1208 ddp_organization_rec.enquiry_duns := p2_a2;
1209 ddp_organization_rec.ceo_name := p2_a3;
1210 ddp_organization_rec.ceo_title := p2_a4;
1211 ddp_organization_rec.principal_name := p2_a5;
1212 ddp_organization_rec.principal_title := p2_a6;
1213 ddp_organization_rec.legal_status := p2_a7;
1214 ddp_organization_rec.control_yr := rosetta_g_miss_num_map(p2_a8);
1215 ddp_organization_rec.employees_total := rosetta_g_miss_num_map(p2_a9);
1219 ddp_organization_rec.line_of_business := p2_a13;
1216 ddp_organization_rec.hq_branch_ind := p2_a10;
1217 ddp_organization_rec.branch_flag := p2_a11;
1218 ddp_organization_rec.oob_ind := p2_a12;
1220 ddp_organization_rec.cong_dist_code := p2_a14;
1221 ddp_organization_rec.sic_code := p2_a15;
1222 ddp_organization_rec.import_ind := p2_a16;
1223 ddp_organization_rec.export_ind := p2_a17;
1224 ddp_organization_rec.labor_surplus_ind := p2_a18;
1225 ddp_organization_rec.debarment_ind := p2_a19;
1226 ddp_organization_rec.minority_owned_ind := p2_a20;
1227 ddp_organization_rec.minority_owned_type := p2_a21;
1228 ddp_organization_rec.woman_owned_ind := p2_a22;
1229 ddp_organization_rec.disadv_8a_ind := p2_a23;
1230 ddp_organization_rec.small_bus_ind := p2_a24;
1231 ddp_organization_rec.rent_own_ind := p2_a25;
1232 ddp_organization_rec.debarments_count := rosetta_g_miss_num_map(p2_a26);
1233 ddp_organization_rec.debarments_date := rosetta_g_miss_date_in_map(p2_a27);
1234 ddp_organization_rec.failure_score := p2_a28;
1235 ddp_organization_rec.failure_score_natnl_percentile := rosetta_g_miss_num_map(p2_a29);
1236 ddp_organization_rec.failure_score_override_code := p2_a30;
1237 ddp_organization_rec.failure_score_commentary := p2_a31;
1238 ddp_organization_rec.global_failure_score := p2_a32;
1239 ddp_organization_rec.db_rating := p2_a33;
1240 ddp_organization_rec.credit_score := p2_a34;
1241 ddp_organization_rec.credit_score_commentary := p2_a35;
1242 ddp_organization_rec.paydex_score := p2_a36;
1243 ddp_organization_rec.paydex_three_months_ago := p2_a37;
1244 ddp_organization_rec.paydex_norm := p2_a38;
1245 ddp_organization_rec.best_time_contact_begin := rosetta_g_miss_date_in_map(p2_a39);
1246 ddp_organization_rec.best_time_contact_end := rosetta_g_miss_date_in_map(p2_a40);
1247 ddp_organization_rec.organization_name_phonetic := p2_a41;
1248 ddp_organization_rec.tax_reference := p2_a42;
1249 ddp_organization_rec.gsa_indicator_flag := p2_a43;
1250 ddp_organization_rec.jgzz_fiscal_code := p2_a44;
1251 ddp_organization_rec.analysis_fy := p2_a45;
1252 ddp_organization_rec.fiscal_yearend_month := p2_a46;
1253 ddp_organization_rec.curr_fy_potential_revenue := rosetta_g_miss_num_map(p2_a47);
1254 ddp_organization_rec.next_fy_potential_revenue := rosetta_g_miss_num_map(p2_a48);
1255 ddp_organization_rec.year_established := rosetta_g_miss_num_map(p2_a49);
1256 ddp_organization_rec.mission_statement := p2_a50;
1257 ddp_organization_rec.organization_type := p2_a51;
1258 ddp_organization_rec.business_scope := p2_a52;
1259 ddp_organization_rec.corporation_class := p2_a53;
1260 ddp_organization_rec.known_as := p2_a54;
1261 ddp_organization_rec.known_as2 := p2_a55;
1262 ddp_organization_rec.known_as3 := p2_a56;
1263 ddp_organization_rec.known_as4 := p2_a57;
1264 ddp_organization_rec.known_as5 := p2_a58;
1265 ddp_organization_rec.local_bus_iden_type := p2_a59;
1266 ddp_organization_rec.local_bus_identifier := p2_a60;
1267 ddp_organization_rec.pref_functional_currency := p2_a61;
1268 ddp_organization_rec.registration_type := p2_a62;
1269 ddp_organization_rec.total_employees_text := p2_a63;
1270 ddp_organization_rec.total_employees_ind := p2_a64;
1271 ddp_organization_rec.total_emp_est_ind := p2_a65;
1272 ddp_organization_rec.total_emp_min_ind := p2_a66;
1273 ddp_organization_rec.parent_sub_ind := p2_a67;
1274 ddp_organization_rec.incorp_year := rosetta_g_miss_num_map(p2_a68);
1275 ddp_organization_rec.sic_code_type := p2_a69;
1276 ddp_organization_rec.public_private_ownership_flag := p2_a70;
1277 ddp_organization_rec.internal_flag := p2_a71;
1278 ddp_organization_rec.local_activity_code_type := p2_a72;
1279 ddp_organization_rec.local_activity_code := p2_a73;
1280 ddp_organization_rec.emp_at_primary_adr := p2_a74;
1281 ddp_organization_rec.emp_at_primary_adr_text := p2_a75;
1282 ddp_organization_rec.emp_at_primary_adr_est_ind := p2_a76;
1283 ddp_organization_rec.emp_at_primary_adr_min_ind := p2_a77;
1284 ddp_organization_rec.high_credit := rosetta_g_miss_num_map(p2_a78);
1285 ddp_organization_rec.avg_high_credit := rosetta_g_miss_num_map(p2_a79);
1286 ddp_organization_rec.total_payments := rosetta_g_miss_num_map(p2_a80);
1287 ddp_organization_rec.credit_score_class := rosetta_g_miss_num_map(p2_a81);
1288 ddp_organization_rec.credit_score_natl_percentile := rosetta_g_miss_num_map(p2_a82);
1289 ddp_organization_rec.credit_score_incd_default := rosetta_g_miss_num_map(p2_a83);
1290 ddp_organization_rec.credit_score_age := rosetta_g_miss_num_map(p2_a84);
1291 ddp_organization_rec.credit_score_date := rosetta_g_miss_date_in_map(p2_a85);
1292 ddp_organization_rec.credit_score_commentary2 := p2_a86;
1293 ddp_organization_rec.credit_score_commentary3 := p2_a87;
1294 ddp_organization_rec.credit_score_commentary4 := p2_a88;
1295 ddp_organization_rec.credit_score_commentary5 := p2_a89;
1296 ddp_organization_rec.credit_score_commentary6 := p2_a90;
1297 ddp_organization_rec.credit_score_commentary7 := p2_a91;
1298 ddp_organization_rec.credit_score_commentary8 := p2_a92;
1299 ddp_organization_rec.credit_score_commentary9 := p2_a93;
1300 ddp_organization_rec.credit_score_commentary10 := p2_a94;
1301 ddp_organization_rec.failure_score_class := rosetta_g_miss_num_map(p2_a95);
1302 ddp_organization_rec.failure_score_incd_default := rosetta_g_miss_num_map(p2_a96);
1303 ddp_organization_rec.failure_score_age := rosetta_g_miss_num_map(p2_a97);
1304 ddp_organization_rec.failure_score_date := rosetta_g_miss_date_in_map(p2_a98);
1308 ddp_organization_rec.failure_score_commentary5 := p2_a102;
1305 ddp_organization_rec.failure_score_commentary2 := p2_a99;
1306 ddp_organization_rec.failure_score_commentary3 := p2_a100;
1307 ddp_organization_rec.failure_score_commentary4 := p2_a101;
1309 ddp_organization_rec.failure_score_commentary6 := p2_a103;
1310 ddp_organization_rec.failure_score_commentary7 := p2_a104;
1311 ddp_organization_rec.failure_score_commentary8 := p2_a105;
1312 ddp_organization_rec.failure_score_commentary9 := p2_a106;
1313 ddp_organization_rec.failure_score_commentary10 := p2_a107;
1314 ddp_organization_rec.maximum_credit_recommendation := rosetta_g_miss_num_map(p2_a108);
1315 ddp_organization_rec.maximum_credit_currency_code := p2_a109;
1316 ddp_organization_rec.displayed_duns_party_id := rosetta_g_miss_num_map(p2_a110);
1317 ddp_organization_rec.content_source_type := p2_a111;
1318 ddp_organization_rec.content_source_number := p2_a112;
1319 ddp_organization_rec.attribute_category := p2_a113;
1320 ddp_organization_rec.attribute1 := p2_a114;
1321 ddp_organization_rec.attribute2 := p2_a115;
1322 ddp_organization_rec.attribute3 := p2_a116;
1323 ddp_organization_rec.attribute4 := p2_a117;
1324 ddp_organization_rec.attribute5 := p2_a118;
1325 ddp_organization_rec.attribute6 := p2_a119;
1326 ddp_organization_rec.attribute7 := p2_a120;
1327 ddp_organization_rec.attribute8 := p2_a121;
1328 ddp_organization_rec.attribute9 := p2_a122;
1329 ddp_organization_rec.attribute10 := p2_a123;
1330 ddp_organization_rec.attribute11 := p2_a124;
1331 ddp_organization_rec.attribute12 := p2_a125;
1332 ddp_organization_rec.attribute13 := p2_a126;
1333 ddp_organization_rec.attribute14 := p2_a127;
1334 ddp_organization_rec.attribute15 := p2_a128;
1335 ddp_organization_rec.attribute16 := p2_a129;
1336 ddp_organization_rec.attribute17 := p2_a130;
1337 ddp_organization_rec.attribute18 := p2_a131;
1338 ddp_organization_rec.attribute19 := p2_a132;
1339 ddp_organization_rec.attribute20 := p2_a133;
1340 ddp_organization_rec.created_by_module := p2_a134;
1341 ddp_organization_rec.application_id := rosetta_g_miss_num_map(p2_a135);
1342 ddp_organization_rec.do_not_confuse_with := p2_a136;
1343 ddp_organization_rec.actual_content_source := p2_a137;
1344 ddp_organization_rec.home_country := p2_a138;
1345 ddp_organization_rec.party_rec.party_id := rosetta_g_miss_num_map(p2_a139);
1346 ddp_organization_rec.party_rec.party_number := p2_a140;
1347 ddp_organization_rec.party_rec.validated_flag := p2_a141;
1348 ddp_organization_rec.party_rec.orig_system_reference := p2_a142;
1349 ddp_organization_rec.party_rec.orig_system := p2_a143;
1350 ddp_organization_rec.party_rec.status := p2_a144;
1351 ddp_organization_rec.party_rec.category_code := p2_a145;
1352 ddp_organization_rec.party_rec.salutation := p2_a146;
1353 ddp_organization_rec.party_rec.attribute_category := p2_a147;
1354 ddp_organization_rec.party_rec.attribute1 := p2_a148;
1355 ddp_organization_rec.party_rec.attribute2 := p2_a149;
1356 ddp_organization_rec.party_rec.attribute3 := p2_a150;
1357 ddp_organization_rec.party_rec.attribute4 := p2_a151;
1358 ddp_organization_rec.party_rec.attribute5 := p2_a152;
1359 ddp_organization_rec.party_rec.attribute6 := p2_a153;
1360 ddp_organization_rec.party_rec.attribute7 := p2_a154;
1361 ddp_organization_rec.party_rec.attribute8 := p2_a155;
1362 ddp_organization_rec.party_rec.attribute9 := p2_a156;
1363 ddp_organization_rec.party_rec.attribute10 := p2_a157;
1364 ddp_organization_rec.party_rec.attribute11 := p2_a158;
1365 ddp_organization_rec.party_rec.attribute12 := p2_a159;
1366 ddp_organization_rec.party_rec.attribute13 := p2_a160;
1367 ddp_organization_rec.party_rec.attribute14 := p2_a161;
1368 ddp_organization_rec.party_rec.attribute15 := p2_a162;
1369 ddp_organization_rec.party_rec.attribute16 := p2_a163;
1370 ddp_organization_rec.party_rec.attribute17 := p2_a164;
1371 ddp_organization_rec.party_rec.attribute18 := p2_a165;
1372 ddp_organization_rec.party_rec.attribute19 := p2_a166;
1373 ddp_organization_rec.party_rec.attribute20 := p2_a167;
1374 ddp_organization_rec.party_rec.attribute21 := p2_a168;
1375 ddp_organization_rec.party_rec.attribute22 := p2_a169;
1376 ddp_organization_rec.party_rec.attribute23 := p2_a170;
1377 ddp_organization_rec.party_rec.attribute24 := p2_a171;
1378
1379 ddp_customer_profile_rec.cust_account_profile_id := rosetta_g_miss_num_map(p3_a0);
1380 ddp_customer_profile_rec.cust_account_id := rosetta_g_miss_num_map(p3_a1);
1381 ddp_customer_profile_rec.status := p3_a2;
1382 ddp_customer_profile_rec.collector_id := rosetta_g_miss_num_map(p3_a3);
1383 ddp_customer_profile_rec.credit_analyst_id := rosetta_g_miss_num_map(p3_a4);
1384 ddp_customer_profile_rec.credit_checking := p3_a5;
1385 ddp_customer_profile_rec.next_credit_review_date := rosetta_g_miss_date_in_map(p3_a6);
1386 ddp_customer_profile_rec.tolerance := rosetta_g_miss_num_map(p3_a7);
1387 ddp_customer_profile_rec.discount_terms := p3_a8;
1388 ddp_customer_profile_rec.dunning_letters := p3_a9;
1389 ddp_customer_profile_rec.interest_charges := p3_a10;
1390 ddp_customer_profile_rec.send_statements := p3_a11;
1391 ddp_customer_profile_rec.credit_balance_statements := p3_a12;
1392 ddp_customer_profile_rec.credit_hold := p3_a13;
1393 ddp_customer_profile_rec.profile_class_id := rosetta_g_miss_num_map(p3_a14);
1394 ddp_customer_profile_rec.site_use_id := rosetta_g_miss_num_map(p3_a15);
1395 ddp_customer_profile_rec.credit_rating := p3_a16;
1396 ddp_customer_profile_rec.risk_code := p3_a17;
1397 ddp_customer_profile_rec.standard_terms := rosetta_g_miss_num_map(p3_a18);
1401 ddp_customer_profile_rec.payment_grace_days := rosetta_g_miss_num_map(p3_a22);
1398 ddp_customer_profile_rec.override_terms := p3_a19;
1399 ddp_customer_profile_rec.dunning_letter_set_id := rosetta_g_miss_num_map(p3_a20);
1400 ddp_customer_profile_rec.interest_period_days := rosetta_g_miss_num_map(p3_a21);
1402 ddp_customer_profile_rec.discount_grace_days := rosetta_g_miss_num_map(p3_a23);
1403 ddp_customer_profile_rec.statement_cycle_id := rosetta_g_miss_num_map(p3_a24);
1404 ddp_customer_profile_rec.account_status := p3_a25;
1405 ddp_customer_profile_rec.percent_collectable := rosetta_g_miss_num_map(p3_a26);
1406 ddp_customer_profile_rec.autocash_hierarchy_id := rosetta_g_miss_num_map(p3_a27);
1407 ddp_customer_profile_rec.attribute_category := p3_a28;
1408 ddp_customer_profile_rec.attribute1 := p3_a29;
1409 ddp_customer_profile_rec.attribute2 := p3_a30;
1410 ddp_customer_profile_rec.attribute3 := p3_a31;
1411 ddp_customer_profile_rec.attribute4 := p3_a32;
1412 ddp_customer_profile_rec.attribute5 := p3_a33;
1413 ddp_customer_profile_rec.attribute6 := p3_a34;
1414 ddp_customer_profile_rec.attribute7 := p3_a35;
1415 ddp_customer_profile_rec.attribute8 := p3_a36;
1416 ddp_customer_profile_rec.attribute9 := p3_a37;
1417 ddp_customer_profile_rec.attribute10 := p3_a38;
1418 ddp_customer_profile_rec.attribute11 := p3_a39;
1419 ddp_customer_profile_rec.attribute12 := p3_a40;
1420 ddp_customer_profile_rec.attribute13 := p3_a41;
1421 ddp_customer_profile_rec.attribute14 := p3_a42;
1422 ddp_customer_profile_rec.attribute15 := p3_a43;
1423 ddp_customer_profile_rec.auto_rec_incl_disputed_flag := p3_a44;
1424 ddp_customer_profile_rec.tax_printing_option := p3_a45;
1425 ddp_customer_profile_rec.charge_on_finance_charge_flag := p3_a46;
1426 ddp_customer_profile_rec.grouping_rule_id := rosetta_g_miss_num_map(p3_a47);
1427 ddp_customer_profile_rec.clearing_days := rosetta_g_miss_num_map(p3_a48);
1428 ddp_customer_profile_rec.jgzz_attribute_category := p3_a49;
1429 ddp_customer_profile_rec.jgzz_attribute1 := p3_a50;
1430 ddp_customer_profile_rec.jgzz_attribute2 := p3_a51;
1431 ddp_customer_profile_rec.jgzz_attribute3 := p3_a52;
1432 ddp_customer_profile_rec.jgzz_attribute4 := p3_a53;
1433 ddp_customer_profile_rec.jgzz_attribute5 := p3_a54;
1434 ddp_customer_profile_rec.jgzz_attribute6 := p3_a55;
1435 ddp_customer_profile_rec.jgzz_attribute7 := p3_a56;
1436 ddp_customer_profile_rec.jgzz_attribute8 := p3_a57;
1437 ddp_customer_profile_rec.jgzz_attribute9 := p3_a58;
1438 ddp_customer_profile_rec.jgzz_attribute10 := p3_a59;
1439 ddp_customer_profile_rec.jgzz_attribute11 := p3_a60;
1440 ddp_customer_profile_rec.jgzz_attribute12 := p3_a61;
1441 ddp_customer_profile_rec.jgzz_attribute13 := p3_a62;
1442 ddp_customer_profile_rec.jgzz_attribute14 := p3_a63;
1443 ddp_customer_profile_rec.jgzz_attribute15 := p3_a64;
1444 ddp_customer_profile_rec.global_attribute1 := p3_a65;
1445 ddp_customer_profile_rec.global_attribute2 := p3_a66;
1446 ddp_customer_profile_rec.global_attribute3 := p3_a67;
1447 ddp_customer_profile_rec.global_attribute4 := p3_a68;
1448 ddp_customer_profile_rec.global_attribute5 := p3_a69;
1449 ddp_customer_profile_rec.global_attribute6 := p3_a70;
1450 ddp_customer_profile_rec.global_attribute7 := p3_a71;
1451 ddp_customer_profile_rec.global_attribute8 := p3_a72;
1452 ddp_customer_profile_rec.global_attribute9 := p3_a73;
1453 ddp_customer_profile_rec.global_attribute10 := p3_a74;
1454 ddp_customer_profile_rec.global_attribute11 := p3_a75;
1455 ddp_customer_profile_rec.global_attribute12 := p3_a76;
1456 ddp_customer_profile_rec.global_attribute13 := p3_a77;
1457 ddp_customer_profile_rec.global_attribute14 := p3_a78;
1458 ddp_customer_profile_rec.global_attribute15 := p3_a79;
1459 ddp_customer_profile_rec.global_attribute16 := p3_a80;
1460 ddp_customer_profile_rec.global_attribute17 := p3_a81;
1461 ddp_customer_profile_rec.global_attribute18 := p3_a82;
1462 ddp_customer_profile_rec.global_attribute19 := p3_a83;
1463 ddp_customer_profile_rec.global_attribute20 := p3_a84;
1464 ddp_customer_profile_rec.global_attribute_category := p3_a85;
1465 ddp_customer_profile_rec.cons_inv_flag := p3_a86;
1466 ddp_customer_profile_rec.cons_inv_type := p3_a87;
1467 ddp_customer_profile_rec.autocash_hierarchy_id_for_adr := rosetta_g_miss_num_map(p3_a88);
1468 ddp_customer_profile_rec.lockbox_matching_option := p3_a89;
1469 ddp_customer_profile_rec.created_by_module := p3_a90;
1470 ddp_customer_profile_rec.application_id := rosetta_g_miss_num_map(p3_a91);
1471 ddp_customer_profile_rec.review_cycle := p3_a92;
1472 ddp_customer_profile_rec.last_credit_review_date := rosetta_g_miss_date_in_map(p3_a93);
1473 ddp_customer_profile_rec.party_id := rosetta_g_miss_num_map(p3_a94);
1474 ddp_customer_profile_rec.credit_classification := p3_a95;
1475 ddp_customer_profile_rec.cons_bill_level := p3_a96;
1476 ddp_customer_profile_rec.late_charge_calculation_trx := p3_a97;
1477 ddp_customer_profile_rec.credit_items_flag := p3_a98;
1478 ddp_customer_profile_rec.disputed_transactions_flag := p3_a99;
1479 ddp_customer_profile_rec.late_charge_type := p3_a100;
1480 ddp_customer_profile_rec.late_charge_term_id := rosetta_g_miss_num_map(p3_a101);
1481 ddp_customer_profile_rec.interest_calculation_period := p3_a102;
1482 ddp_customer_profile_rec.hold_charged_invoices_flag := p3_a103;
1483 ddp_customer_profile_rec.message_text_id := rosetta_g_miss_num_map(p3_a104);
1484 ddp_customer_profile_rec.multiple_interest_rates_flag := p3_a105;
1485 ddp_customer_profile_rec.charge_begin_date := rosetta_g_miss_date_in_map(p3_a106);
1486
1487
1488
1489
1490
1491
1492
1496 -- here's the delegated call to the old PL/SQL routine
1493
1494
1495
1497 hz_cust_account_v2pub.create_cust_account(p_init_msg_list,
1498 ddp_cust_account_rec,
1499 ddp_organization_rec,
1500 ddp_customer_profile_rec,
1501 p_create_profile_amt,
1502 x_cust_account_id,
1503 x_account_number,
1504 x_party_id,
1505 x_party_number,
1506 x_profile_id,
1507 x_return_status,
1508 x_msg_count,
1509 x_msg_data);
1510
1511 -- copy data back from the local OUT or IN-OUT args, if any
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524 end;
1525
1526 procedure update_cust_account_3(p_init_msg_list VARCHAR2
1527 , p_object_version_number in out nocopy NUMBER
1528 , x_return_status out nocopy VARCHAR2
1529 , x_msg_count out nocopy NUMBER
1530 , x_msg_data out nocopy VARCHAR2
1531 , p1_a0 NUMBER := null
1532 , p1_a1 VARCHAR2 := null
1533 , p1_a2 VARCHAR2 := null
1534 , p1_a3 VARCHAR2 := null
1535 , p1_a4 VARCHAR2 := null
1536 , p1_a5 VARCHAR2 := null
1537 , p1_a6 VARCHAR2 := null
1538 , p1_a7 VARCHAR2 := null
1539 , p1_a8 VARCHAR2 := null
1540 , p1_a9 VARCHAR2 := null
1541 , p1_a10 VARCHAR2 := null
1542 , p1_a11 VARCHAR2 := null
1543 , p1_a12 VARCHAR2 := null
1544 , p1_a13 VARCHAR2 := null
1545 , p1_a14 VARCHAR2 := null
1546 , p1_a15 VARCHAR2 := null
1547 , p1_a16 VARCHAR2 := null
1548 , p1_a17 VARCHAR2 := null
1549 , p1_a18 VARCHAR2 := null
1550 , p1_a19 VARCHAR2 := null
1551 , p1_a20 VARCHAR2 := null
1552 , p1_a21 VARCHAR2 := null
1553 , p1_a22 VARCHAR2 := null
1554 , p1_a23 VARCHAR2 := null
1555 , p1_a24 VARCHAR2 := null
1556 , p1_a25 VARCHAR2 := null
1557 , p1_a26 VARCHAR2 := null
1558 , p1_a27 VARCHAR2 := null
1559 , p1_a28 VARCHAR2 := null
1560 , p1_a29 VARCHAR2 := null
1561 , p1_a30 VARCHAR2 := null
1562 , p1_a31 VARCHAR2 := null
1563 , p1_a32 VARCHAR2 := null
1564 , p1_a33 VARCHAR2 := null
1565 , p1_a34 VARCHAR2 := null
1566 , p1_a35 VARCHAR2 := null
1567 , p1_a36 VARCHAR2 := null
1568 , p1_a37 VARCHAR2 := null
1569 , p1_a38 VARCHAR2 := null
1570 , p1_a39 VARCHAR2 := null
1571 , p1_a40 VARCHAR2 := null
1572 , p1_a41 VARCHAR2 := null
1573 , p1_a42 VARCHAR2 := null
1574 , p1_a43 VARCHAR2 := null
1575 , p1_a44 VARCHAR2 := null
1576 , p1_a45 VARCHAR2 := null
1577 , p1_a46 VARCHAR2 := null
1578 , p1_a47 VARCHAR2 := null
1579 , p1_a48 VARCHAR2 := null
1580 , p1_a49 NUMBER := null
1581 , p1_a50 VARCHAR2 := null
1582 , p1_a51 NUMBER := null
1583 , p1_a52 NUMBER := null
1584 , p1_a53 VARCHAR2 := null
1585 , p1_a54 VARCHAR2 := null
1586 , p1_a55 VARCHAR2 := null
1587 , p1_a56 VARCHAR2 := null
1588 , p1_a57 VARCHAR2 := null
1589 , p1_a58 NUMBER := null
1590 , p1_a59 VARCHAR2 := null
1591 , p1_a60 VARCHAR2 := null
1592 , p1_a61 VARCHAR2 := null
1593 , p1_a62 NUMBER := null
1594 , p1_a63 NUMBER := null
1595 , p1_a64 VARCHAR2 := null
1596 , p1_a65 NUMBER := null
1597 , p1_a66 DATE := null
1598 , p1_a67 DATE := null
1599 , p1_a68 DATE := null
1600 , p1_a69 VARCHAR2 := null
1601 , p1_a70 DATE := null
1602 , p1_a71 VARCHAR2 := null
1603 , p1_a72 VARCHAR2 := null
1604 , p1_a73 VARCHAR2 := null
1605 , p1_a74 VARCHAR2 := null
1606 , p1_a75 VARCHAR2 := null
1607 , p1_a76 VARCHAR2 := null
1608 , p1_a77 VARCHAR2 := null
1609 , p1_a78 DATE := null
1610 , p1_a79 VARCHAR2 := null
1611 , p1_a80 VARCHAR2 := null
1612 , p1_a81 NUMBER := null
1613 , p1_a82 NUMBER := null
1614 , p1_a83 VARCHAR2 := null
1615 , p1_a84 NUMBER := null
1616 , p1_a85 NUMBER := null
1617 , p1_a86 NUMBER := null
1618 , p1_a87 NUMBER := null
1619 , p1_a88 VARCHAR2 := null
1620 , p1_a89 VARCHAR2 := null
1621 , p1_a90 VARCHAR2 := null
1622 , p1_a91 VARCHAR2 := null
1623 , p1_a92 VARCHAR2 := null
1624 , p1_a93 VARCHAR2 := null
1625 , p1_a94 DATE := null
1626 , p1_a95 VARCHAR2 := null
1627 , p1_a96 VARCHAR2 := null
1628 , p1_a97 NUMBER := null
1629 , p1_a98 NUMBER := null
1630 , p1_a99 VARCHAR2 := null
1631 , p1_a100 NUMBER := null
1632 , p1_a101 VARCHAR2 := null
1633 , p1_a102 VARCHAR2 := null
1634 , p1_a103 VARCHAR2 := null
1635 , p1_a104 VARCHAR2 := null
1636 )
1637 as
1638 ddp_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type;
1639 ddindx binary_integer; indx binary_integer;
1640 begin
1641
1642 -- copy data to the local IN or IN-OUT args, if any
1643
1644 ddp_cust_account_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
1645 ddp_cust_account_rec.account_number := p1_a1;
1646 ddp_cust_account_rec.attribute_category := p1_a2;
1647 ddp_cust_account_rec.attribute1 := p1_a3;
1648 ddp_cust_account_rec.attribute2 := p1_a4;
1649 ddp_cust_account_rec.attribute3 := p1_a5;
1650 ddp_cust_account_rec.attribute4 := p1_a6;
1651 ddp_cust_account_rec.attribute5 := p1_a7;
1655 ddp_cust_account_rec.attribute9 := p1_a11;
1652 ddp_cust_account_rec.attribute6 := p1_a8;
1653 ddp_cust_account_rec.attribute7 := p1_a9;
1654 ddp_cust_account_rec.attribute8 := p1_a10;
1656 ddp_cust_account_rec.attribute10 := p1_a12;
1657 ddp_cust_account_rec.attribute11 := p1_a13;
1658 ddp_cust_account_rec.attribute12 := p1_a14;
1659 ddp_cust_account_rec.attribute13 := p1_a15;
1660 ddp_cust_account_rec.attribute14 := p1_a16;
1661 ddp_cust_account_rec.attribute15 := p1_a17;
1662 ddp_cust_account_rec.attribute16 := p1_a18;
1663 ddp_cust_account_rec.attribute17 := p1_a19;
1664 ddp_cust_account_rec.attribute18 := p1_a20;
1665 ddp_cust_account_rec.attribute19 := p1_a21;
1666 ddp_cust_account_rec.attribute20 := p1_a22;
1667 ddp_cust_account_rec.global_attribute_category := p1_a23;
1668 ddp_cust_account_rec.global_attribute1 := p1_a24;
1669 ddp_cust_account_rec.global_attribute2 := p1_a25;
1670 ddp_cust_account_rec.global_attribute3 := p1_a26;
1671 ddp_cust_account_rec.global_attribute4 := p1_a27;
1672 ddp_cust_account_rec.global_attribute5 := p1_a28;
1673 ddp_cust_account_rec.global_attribute6 := p1_a29;
1674 ddp_cust_account_rec.global_attribute7 := p1_a30;
1675 ddp_cust_account_rec.global_attribute8 := p1_a31;
1676 ddp_cust_account_rec.global_attribute9 := p1_a32;
1677 ddp_cust_account_rec.global_attribute10 := p1_a33;
1678 ddp_cust_account_rec.global_attribute11 := p1_a34;
1679 ddp_cust_account_rec.global_attribute12 := p1_a35;
1680 ddp_cust_account_rec.global_attribute13 := p1_a36;
1681 ddp_cust_account_rec.global_attribute14 := p1_a37;
1682 ddp_cust_account_rec.global_attribute15 := p1_a38;
1683 ddp_cust_account_rec.global_attribute16 := p1_a39;
1684 ddp_cust_account_rec.global_attribute17 := p1_a40;
1685 ddp_cust_account_rec.global_attribute18 := p1_a41;
1686 ddp_cust_account_rec.global_attribute19 := p1_a42;
1687 ddp_cust_account_rec.global_attribute20 := p1_a43;
1688 ddp_cust_account_rec.orig_system_reference := p1_a44;
1689 ddp_cust_account_rec.orig_system := p1_a45;
1690 ddp_cust_account_rec.status := p1_a46;
1691 ddp_cust_account_rec.customer_type := p1_a47;
1692 ddp_cust_account_rec.customer_class_code := p1_a48;
1693 ddp_cust_account_rec.primary_salesrep_id := rosetta_g_miss_num_map(p1_a49);
1694 ddp_cust_account_rec.sales_channel_code := p1_a50;
1695 ddp_cust_account_rec.order_type_id := rosetta_g_miss_num_map(p1_a51);
1696 ddp_cust_account_rec.price_list_id := rosetta_g_miss_num_map(p1_a52);
1697 ddp_cust_account_rec.tax_code := p1_a53;
1698 ddp_cust_account_rec.fob_point := p1_a54;
1699 ddp_cust_account_rec.freight_term := p1_a55;
1700 ddp_cust_account_rec.ship_partial := p1_a56;
1701 ddp_cust_account_rec.ship_via := p1_a57;
1702 ddp_cust_account_rec.warehouse_id := rosetta_g_miss_num_map(p1_a58);
1703 ddp_cust_account_rec.tax_header_level_flag := p1_a59;
1704 ddp_cust_account_rec.tax_rounding_rule := p1_a60;
1705 ddp_cust_account_rec.coterminate_day_month := p1_a61;
1706 ddp_cust_account_rec.primary_specialist_id := rosetta_g_miss_num_map(p1_a62);
1707 ddp_cust_account_rec.secondary_specialist_id := rosetta_g_miss_num_map(p1_a63);
1708 ddp_cust_account_rec.account_liable_flag := p1_a64;
1709 ddp_cust_account_rec.current_balance := rosetta_g_miss_num_map(p1_a65);
1710 ddp_cust_account_rec.account_established_date := rosetta_g_miss_date_in_map(p1_a66);
1711 ddp_cust_account_rec.account_termination_date := rosetta_g_miss_date_in_map(p1_a67);
1712 ddp_cust_account_rec.account_activation_date := rosetta_g_miss_date_in_map(p1_a68);
1713 ddp_cust_account_rec.department := p1_a69;
1714 ddp_cust_account_rec.held_bill_expiration_date := rosetta_g_miss_date_in_map(p1_a70);
1715 ddp_cust_account_rec.hold_bill_flag := p1_a71;
1716 ddp_cust_account_rec.realtime_rate_flag := p1_a72;
1717 ddp_cust_account_rec.acct_life_cycle_status := p1_a73;
1718 ddp_cust_account_rec.account_name := p1_a74;
1719 ddp_cust_account_rec.deposit_refund_method := p1_a75;
1720 ddp_cust_account_rec.dormant_account_flag := p1_a76;
1721 ddp_cust_account_rec.npa_number := p1_a77;
1722 ddp_cust_account_rec.suspension_date := rosetta_g_miss_date_in_map(p1_a78);
1723 ddp_cust_account_rec.source_code := p1_a79;
1724 ddp_cust_account_rec.comments := p1_a80;
1725 ddp_cust_account_rec.dates_negative_tolerance := rosetta_g_miss_num_map(p1_a81);
1726 ddp_cust_account_rec.dates_positive_tolerance := rosetta_g_miss_num_map(p1_a82);
1727 ddp_cust_account_rec.date_type_preference := p1_a83;
1728 ddp_cust_account_rec.over_shipment_tolerance := rosetta_g_miss_num_map(p1_a84);
1729 ddp_cust_account_rec.under_shipment_tolerance := rosetta_g_miss_num_map(p1_a85);
1730 ddp_cust_account_rec.over_return_tolerance := rosetta_g_miss_num_map(p1_a86);
1731 ddp_cust_account_rec.under_return_tolerance := rosetta_g_miss_num_map(p1_a87);
1732 ddp_cust_account_rec.item_cross_ref_pref := p1_a88;
1733 ddp_cust_account_rec.ship_sets_include_lines_flag := p1_a89;
1734 ddp_cust_account_rec.arrivalsets_include_lines_flag := p1_a90;
1735 ddp_cust_account_rec.sched_date_push_flag := p1_a91;
1736 ddp_cust_account_rec.invoice_quantity_rule := p1_a92;
1737 ddp_cust_account_rec.pricing_event := p1_a93;
1738 ddp_cust_account_rec.status_update_date := rosetta_g_miss_date_in_map(p1_a94);
1739 ddp_cust_account_rec.autopay_flag := p1_a95;
1740 ddp_cust_account_rec.notify_flag := p1_a96;
1741 ddp_cust_account_rec.last_batch_id := rosetta_g_miss_num_map(p1_a97);
1742 ddp_cust_account_rec.selling_party_id := rosetta_g_miss_num_map(p1_a98);
1743 ddp_cust_account_rec.created_by_module := p1_a99;
1747 ddp_cust_account_rec.duns_extension := p1_a103;
1744 ddp_cust_account_rec.application_id := rosetta_g_miss_num_map(p1_a100);
1745 ddp_cust_account_rec.federal_entity_type := p1_a101;
1746 ddp_cust_account_rec.trading_partner_agency_id := p1_a102;
1748 ddp_cust_account_rec.advance_payment_indicator := p1_a104;
1749
1750
1751
1752
1753
1754 -- here's the delegated call to the old PL/SQL routine
1755 hz_cust_account_v2pub.update_cust_account(p_init_msg_list,
1756 ddp_cust_account_rec,
1757 p_object_version_number,
1758 x_return_status,
1759 x_msg_count,
1760 x_msg_data);
1761
1762 -- copy data back from the local OUT or IN-OUT args, if any
1763
1764
1765
1766
1767
1768 end;
1769
1770 procedure get_cust_account_rec_4(p_init_msg_list VARCHAR2
1771 , p_cust_account_id NUMBER
1772 , p2_a0 out nocopy NUMBER
1773 , p2_a1 out nocopy VARCHAR2
1774 , p2_a2 out nocopy VARCHAR2
1775 , p2_a3 out nocopy VARCHAR2
1776 , p2_a4 out nocopy VARCHAR2
1777 , p2_a5 out nocopy VARCHAR2
1778 , p2_a6 out nocopy VARCHAR2
1779 , p2_a7 out nocopy VARCHAR2
1780 , p2_a8 out nocopy VARCHAR2
1781 , p2_a9 out nocopy VARCHAR2
1782 , p2_a10 out nocopy VARCHAR2
1783 , p2_a11 out nocopy VARCHAR2
1784 , p2_a12 out nocopy VARCHAR2
1785 , p2_a13 out nocopy VARCHAR2
1786 , p2_a14 out nocopy VARCHAR2
1787 , p2_a15 out nocopy VARCHAR2
1788 , p2_a16 out nocopy VARCHAR2
1789 , p2_a17 out nocopy VARCHAR2
1790 , p2_a18 out nocopy VARCHAR2
1791 , p2_a19 out nocopy VARCHAR2
1792 , p2_a20 out nocopy VARCHAR2
1793 , p2_a21 out nocopy VARCHAR2
1794 , p2_a22 out nocopy VARCHAR2
1795 , p2_a23 out nocopy VARCHAR2
1796 , p2_a24 out nocopy VARCHAR2
1797 , p2_a25 out nocopy VARCHAR2
1798 , p2_a26 out nocopy VARCHAR2
1799 , p2_a27 out nocopy VARCHAR2
1800 , p2_a28 out nocopy VARCHAR2
1801 , p2_a29 out nocopy VARCHAR2
1802 , p2_a30 out nocopy VARCHAR2
1803 , p2_a31 out nocopy VARCHAR2
1804 , p2_a32 out nocopy VARCHAR2
1805 , p2_a33 out nocopy VARCHAR2
1806 , p2_a34 out nocopy VARCHAR2
1807 , p2_a35 out nocopy VARCHAR2
1808 , p2_a36 out nocopy VARCHAR2
1809 , p2_a37 out nocopy VARCHAR2
1810 , p2_a38 out nocopy VARCHAR2
1811 , p2_a39 out nocopy VARCHAR2
1812 , p2_a40 out nocopy VARCHAR2
1813 , p2_a41 out nocopy VARCHAR2
1814 , p2_a42 out nocopy VARCHAR2
1815 , p2_a43 out nocopy VARCHAR2
1816 , p2_a44 out nocopy VARCHAR2
1817 , p2_a45 out nocopy VARCHAR2
1818 , p2_a46 out nocopy VARCHAR2
1819 , p2_a47 out nocopy VARCHAR2
1820 , p2_a48 out nocopy VARCHAR2
1821 , p2_a49 out nocopy NUMBER
1822 , p2_a50 out nocopy VARCHAR2
1823 , p2_a51 out nocopy NUMBER
1824 , p2_a52 out nocopy NUMBER
1825 , p2_a53 out nocopy VARCHAR2
1826 , p2_a54 out nocopy VARCHAR2
1827 , p2_a55 out nocopy VARCHAR2
1828 , p2_a56 out nocopy VARCHAR2
1829 , p2_a57 out nocopy VARCHAR2
1830 , p2_a58 out nocopy NUMBER
1831 , p2_a59 out nocopy VARCHAR2
1832 , p2_a60 out nocopy VARCHAR2
1833 , p2_a61 out nocopy VARCHAR2
1834 , p2_a62 out nocopy NUMBER
1835 , p2_a63 out nocopy NUMBER
1836 , p2_a64 out nocopy VARCHAR2
1837 , p2_a65 out nocopy NUMBER
1838 , p2_a66 out nocopy DATE
1839 , p2_a67 out nocopy DATE
1840 , p2_a68 out nocopy DATE
1841 , p2_a69 out nocopy VARCHAR2
1842 , p2_a70 out nocopy DATE
1843 , p2_a71 out nocopy VARCHAR2
1844 , p2_a72 out nocopy VARCHAR2
1845 , p2_a73 out nocopy VARCHAR2
1846 , p2_a74 out nocopy VARCHAR2
1847 , p2_a75 out nocopy VARCHAR2
1848 , p2_a76 out nocopy VARCHAR2
1849 , p2_a77 out nocopy VARCHAR2
1850 , p2_a78 out nocopy DATE
1851 , p2_a79 out nocopy VARCHAR2
1852 , p2_a80 out nocopy VARCHAR2
1853 , p2_a81 out nocopy NUMBER
1854 , p2_a82 out nocopy NUMBER
1855 , p2_a83 out nocopy VARCHAR2
1856 , p2_a84 out nocopy NUMBER
1857 , p2_a85 out nocopy NUMBER
1858 , p2_a86 out nocopy NUMBER
1859 , p2_a87 out nocopy NUMBER
1860 , p2_a88 out nocopy VARCHAR2
1861 , p2_a89 out nocopy VARCHAR2
1862 , p2_a90 out nocopy VARCHAR2
1863 , p2_a91 out nocopy VARCHAR2
1864 , p2_a92 out nocopy VARCHAR2
1865 , p2_a93 out nocopy VARCHAR2
1866 , p2_a94 out nocopy DATE
1867 , p2_a95 out nocopy VARCHAR2
1868 , p2_a96 out nocopy VARCHAR2
1869 , p2_a97 out nocopy NUMBER
1870 , p2_a98 out nocopy NUMBER
1871 , p2_a99 out nocopy VARCHAR2
1872 , p2_a100 out nocopy NUMBER
1873 , p3_a0 out nocopy NUMBER
1874 , p3_a1 out nocopy NUMBER
1875 , p3_a2 out nocopy VARCHAR2
1876 , p3_a3 out nocopy NUMBER
1877 , p3_a4 out nocopy NUMBER
1878 , p3_a5 out nocopy VARCHAR2
1879 , p3_a6 out nocopy DATE
1880 , p3_a7 out nocopy NUMBER
1881 , p3_a8 out nocopy VARCHAR2
1882 , p3_a9 out nocopy VARCHAR2
1883 , p3_a10 out nocopy VARCHAR2
1884 , p3_a11 out nocopy VARCHAR2
1885 , p3_a12 out nocopy VARCHAR2
1886 , p3_a13 out nocopy VARCHAR2
1890 , p3_a17 out nocopy VARCHAR2
1887 , p3_a14 out nocopy NUMBER
1888 , p3_a15 out nocopy NUMBER
1889 , p3_a16 out nocopy VARCHAR2
1891 , p3_a18 out nocopy NUMBER
1892 , p3_a19 out nocopy VARCHAR2
1893 , p3_a20 out nocopy NUMBER
1894 , p3_a21 out nocopy NUMBER
1895 , p3_a22 out nocopy NUMBER
1896 , p3_a23 out nocopy NUMBER
1897 , p3_a24 out nocopy NUMBER
1898 , p3_a25 out nocopy VARCHAR2
1899 , p3_a26 out nocopy NUMBER
1900 , p3_a27 out nocopy NUMBER
1901 , p3_a28 out nocopy VARCHAR2
1902 , p3_a29 out nocopy VARCHAR2
1903 , p3_a30 out nocopy VARCHAR2
1904 , p3_a31 out nocopy VARCHAR2
1905 , p3_a32 out nocopy VARCHAR2
1906 , p3_a33 out nocopy VARCHAR2
1907 , p3_a34 out nocopy VARCHAR2
1908 , p3_a35 out nocopy VARCHAR2
1909 , p3_a36 out nocopy VARCHAR2
1910 , p3_a37 out nocopy VARCHAR2
1911 , p3_a38 out nocopy VARCHAR2
1912 , p3_a39 out nocopy VARCHAR2
1913 , p3_a40 out nocopy VARCHAR2
1914 , p3_a41 out nocopy VARCHAR2
1915 , p3_a42 out nocopy VARCHAR2
1916 , p3_a43 out nocopy VARCHAR2
1917 , p3_a44 out nocopy VARCHAR2
1918 , p3_a45 out nocopy VARCHAR2
1919 , p3_a46 out nocopy VARCHAR2
1920 , p3_a47 out nocopy NUMBER
1921 , p3_a48 out nocopy NUMBER
1922 , p3_a49 out nocopy VARCHAR2
1923 , p3_a50 out nocopy VARCHAR2
1924 , p3_a51 out nocopy VARCHAR2
1925 , p3_a52 out nocopy VARCHAR2
1926 , p3_a53 out nocopy VARCHAR2
1927 , p3_a54 out nocopy VARCHAR2
1928 , p3_a55 out nocopy VARCHAR2
1929 , p3_a56 out nocopy VARCHAR2
1930 , p3_a57 out nocopy VARCHAR2
1931 , p3_a58 out nocopy VARCHAR2
1932 , p3_a59 out nocopy VARCHAR2
1933 , p3_a60 out nocopy VARCHAR2
1934 , p3_a61 out nocopy VARCHAR2
1935 , p3_a62 out nocopy VARCHAR2
1936 , p3_a63 out nocopy VARCHAR2
1937 , p3_a64 out nocopy VARCHAR2
1938 , p3_a65 out nocopy VARCHAR2
1939 , p3_a66 out nocopy VARCHAR2
1940 , p3_a67 out nocopy VARCHAR2
1941 , p3_a68 out nocopy VARCHAR2
1942 , p3_a69 out nocopy VARCHAR2
1943 , p3_a70 out nocopy VARCHAR2
1944 , p3_a71 out nocopy VARCHAR2
1945 , p3_a72 out nocopy VARCHAR2
1946 , p3_a73 out nocopy VARCHAR2
1947 , p3_a74 out nocopy VARCHAR2
1948 , p3_a75 out nocopy VARCHAR2
1949 , p3_a76 out nocopy VARCHAR2
1950 , p3_a77 out nocopy VARCHAR2
1951 , p3_a78 out nocopy VARCHAR2
1952 , p3_a79 out nocopy VARCHAR2
1953 , p3_a80 out nocopy VARCHAR2
1954 , p3_a81 out nocopy VARCHAR2
1955 , p3_a82 out nocopy VARCHAR2
1956 , p3_a83 out nocopy VARCHAR2
1957 , p3_a84 out nocopy VARCHAR2
1958 , p3_a85 out nocopy VARCHAR2
1959 , p3_a86 out nocopy VARCHAR2
1960 , p3_a87 out nocopy VARCHAR2
1961 , p3_a88 out nocopy NUMBER
1962 , p3_a89 out nocopy VARCHAR2
1963 , p3_a90 out nocopy VARCHAR2
1964 , p3_a91 out nocopy NUMBER
1965 , p3_a92 out nocopy VARCHAR2
1966 , p3_a93 out nocopy DATE
1967 , p3_a94 out nocopy NUMBER
1968 , p3_a95 out nocopy VARCHAR2
1969 , p3_a96 out nocopy VARCHAR2
1970 , p3_a97 out nocopy VARCHAR2
1971 , p3_a98 out nocopy VARCHAR2
1972 , p3_a99 out nocopy VARCHAR2
1973 , p3_a100 out nocopy VARCHAR2
1974 , p3_a101 out nocopy NUMBER
1975 , p3_a102 out nocopy VARCHAR2
1976 , p3_a103 out nocopy VARCHAR2
1977 , p3_a104 out nocopy NUMBER
1978 , p3_a105 out nocopy VARCHAR2
1979 , p3_a106 out nocopy DATE
1980 , p2_a101 out nocopy VARCHAR2
1981 , p2_a102 out nocopy VARCHAR2
1982 , p2_a103 out nocopy VARCHAR2
1983 , p2_a104 out nocopy VARCHAR2
1984 , x_return_status out nocopy VARCHAR2
1985 , x_msg_count out nocopy NUMBER
1986 , x_msg_data out nocopy VARCHAR2
1987 )
1988 as
1989 ddx_cust_account_rec hz_cust_account_v2pub.cust_account_rec_type;
1990 ddx_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type;
1991 ddindx binary_integer; indx binary_integer;
1992 begin
1993
1994 -- copy data to the local IN or IN-OUT args, if any
1995
1996
1997
1998
1999
2000
2001
2002 -- here's the delegated call to the old PL/SQL routine
2003 hz_cust_account_v2pub.get_cust_account_rec(p_init_msg_list,
2004 p_cust_account_id,
2005 ddx_cust_account_rec,
2006 ddx_customer_profile_rec,
2007 x_return_status,
2008 x_msg_count,
2009 x_msg_data);
2010
2011 -- copy data back from the local OUT or IN-OUT args, if any
2012
2013
2014 p2_a0 := rosetta_g_miss_num_map(ddx_cust_account_rec.cust_account_id);
2015 p2_a1 := ddx_cust_account_rec.account_number;
2016 p2_a2 := ddx_cust_account_rec.attribute_category;
2017 p2_a3 := ddx_cust_account_rec.attribute1;
2018 p2_a4 := ddx_cust_account_rec.attribute2;
2019 p2_a5 := ddx_cust_account_rec.attribute3;
2020 p2_a6 := ddx_cust_account_rec.attribute4;
2021 p2_a7 := ddx_cust_account_rec.attribute5;
2022 p2_a8 := ddx_cust_account_rec.attribute6;
2023 p2_a9 := ddx_cust_account_rec.attribute7;
2024 p2_a10 := ddx_cust_account_rec.attribute8;
2025 p2_a11 := ddx_cust_account_rec.attribute9;
2029 p2_a15 := ddx_cust_account_rec.attribute13;
2026 p2_a12 := ddx_cust_account_rec.attribute10;
2027 p2_a13 := ddx_cust_account_rec.attribute11;
2028 p2_a14 := ddx_cust_account_rec.attribute12;
2030 p2_a16 := ddx_cust_account_rec.attribute14;
2031 p2_a17 := ddx_cust_account_rec.attribute15;
2032 p2_a18 := ddx_cust_account_rec.attribute16;
2033 p2_a19 := ddx_cust_account_rec.attribute17;
2034 p2_a20 := ddx_cust_account_rec.attribute18;
2035 p2_a21 := ddx_cust_account_rec.attribute19;
2036 p2_a22 := ddx_cust_account_rec.attribute20;
2037 p2_a23 := ddx_cust_account_rec.global_attribute_category;
2038 p2_a24 := ddx_cust_account_rec.global_attribute1;
2039 p2_a25 := ddx_cust_account_rec.global_attribute2;
2040 p2_a26 := ddx_cust_account_rec.global_attribute3;
2041 p2_a27 := ddx_cust_account_rec.global_attribute4;
2042 p2_a28 := ddx_cust_account_rec.global_attribute5;
2043 p2_a29 := ddx_cust_account_rec.global_attribute6;
2044 p2_a30 := ddx_cust_account_rec.global_attribute7;
2045 p2_a31 := ddx_cust_account_rec.global_attribute8;
2046 p2_a32 := ddx_cust_account_rec.global_attribute9;
2047 p2_a33 := ddx_cust_account_rec.global_attribute10;
2048 p2_a34 := ddx_cust_account_rec.global_attribute11;
2049 p2_a35 := ddx_cust_account_rec.global_attribute12;
2050 p2_a36 := ddx_cust_account_rec.global_attribute13;
2051 p2_a37 := ddx_cust_account_rec.global_attribute14;
2052 p2_a38 := ddx_cust_account_rec.global_attribute15;
2053 p2_a39 := ddx_cust_account_rec.global_attribute16;
2054 p2_a40 := ddx_cust_account_rec.global_attribute17;
2055 p2_a41 := ddx_cust_account_rec.global_attribute18;
2056 p2_a42 := ddx_cust_account_rec.global_attribute19;
2057 p2_a43 := ddx_cust_account_rec.global_attribute20;
2058 p2_a44 := ddx_cust_account_rec.orig_system_reference;
2059 p2_a45 := ddx_cust_account_rec.orig_system;
2060 p2_a46 := ddx_cust_account_rec.status;
2061 p2_a47 := ddx_cust_account_rec.customer_type;
2062 p2_a48 := ddx_cust_account_rec.customer_class_code;
2063 p2_a49 := rosetta_g_miss_num_map(ddx_cust_account_rec.primary_salesrep_id);
2064 p2_a50 := ddx_cust_account_rec.sales_channel_code;
2065 p2_a51 := rosetta_g_miss_num_map(ddx_cust_account_rec.order_type_id);
2066 p2_a52 := rosetta_g_miss_num_map(ddx_cust_account_rec.price_list_id);
2067 p2_a53 := ddx_cust_account_rec.tax_code;
2068 p2_a54 := ddx_cust_account_rec.fob_point;
2069 p2_a55 := ddx_cust_account_rec.freight_term;
2070 p2_a56 := ddx_cust_account_rec.ship_partial;
2071 p2_a57 := ddx_cust_account_rec.ship_via;
2072 p2_a58 := rosetta_g_miss_num_map(ddx_cust_account_rec.warehouse_id);
2073 p2_a59 := ddx_cust_account_rec.tax_header_level_flag;
2074 p2_a60 := ddx_cust_account_rec.tax_rounding_rule;
2075 p2_a61 := ddx_cust_account_rec.coterminate_day_month;
2076 p2_a62 := rosetta_g_miss_num_map(ddx_cust_account_rec.primary_specialist_id);
2077 p2_a63 := rosetta_g_miss_num_map(ddx_cust_account_rec.secondary_specialist_id);
2078 p2_a64 := ddx_cust_account_rec.account_liable_flag;
2079 p2_a65 := rosetta_g_miss_num_map(ddx_cust_account_rec.current_balance);
2080 p2_a66 := ddx_cust_account_rec.account_established_date;
2081 p2_a67 := ddx_cust_account_rec.account_termination_date;
2082 p2_a68 := ddx_cust_account_rec.account_activation_date;
2083 p2_a69 := ddx_cust_account_rec.department;
2084 p2_a70 := ddx_cust_account_rec.held_bill_expiration_date;
2085 p2_a71 := ddx_cust_account_rec.hold_bill_flag;
2086 p2_a72 := ddx_cust_account_rec.realtime_rate_flag;
2087 p2_a73 := ddx_cust_account_rec.acct_life_cycle_status;
2088 p2_a74 := ddx_cust_account_rec.account_name;
2089 p2_a75 := ddx_cust_account_rec.deposit_refund_method;
2090 p2_a76 := ddx_cust_account_rec.dormant_account_flag;
2091 p2_a77 := ddx_cust_account_rec.npa_number;
2092 p2_a78 := ddx_cust_account_rec.suspension_date;
2093 p2_a79 := ddx_cust_account_rec.source_code;
2094 p2_a80 := ddx_cust_account_rec.comments;
2095 p2_a81 := rosetta_g_miss_num_map(ddx_cust_account_rec.dates_negative_tolerance);
2096 p2_a82 := rosetta_g_miss_num_map(ddx_cust_account_rec.dates_positive_tolerance);
2097 p2_a83 := ddx_cust_account_rec.date_type_preference;
2098 p2_a84 := rosetta_g_miss_num_map(ddx_cust_account_rec.over_shipment_tolerance);
2099 p2_a85 := rosetta_g_miss_num_map(ddx_cust_account_rec.under_shipment_tolerance);
2100 p2_a86 := rosetta_g_miss_num_map(ddx_cust_account_rec.over_return_tolerance);
2101 p2_a87 := rosetta_g_miss_num_map(ddx_cust_account_rec.under_return_tolerance);
2102 p2_a88 := ddx_cust_account_rec.item_cross_ref_pref;
2103 p2_a89 := ddx_cust_account_rec.ship_sets_include_lines_flag;
2104 p2_a90 := ddx_cust_account_rec.arrivalsets_include_lines_flag;
2105 p2_a91 := ddx_cust_account_rec.sched_date_push_flag;
2106 p2_a92 := ddx_cust_account_rec.invoice_quantity_rule;
2107 p2_a93 := ddx_cust_account_rec.pricing_event;
2108 p2_a94 := ddx_cust_account_rec.status_update_date;
2109 p2_a95 := ddx_cust_account_rec.autopay_flag;
2110 p2_a96 := ddx_cust_account_rec.notify_flag;
2111 p2_a97 := rosetta_g_miss_num_map(ddx_cust_account_rec.last_batch_id);
2112 p2_a98 := rosetta_g_miss_num_map(ddx_cust_account_rec.selling_party_id);
2113 p2_a99 := ddx_cust_account_rec.created_by_module;
2114 p2_a100 := rosetta_g_miss_num_map(ddx_cust_account_rec.application_id);
2115 p2_a101 := ddx_cust_account_rec.federal_entity_type;
2116 p2_a102 := ddx_cust_account_rec.trading_partner_agency_id;
2120 p3_a0 := rosetta_g_miss_num_map(ddx_customer_profile_rec.cust_account_profile_id);
2117 p2_a103 := ddx_cust_account_rec.duns_extension;
2118 p2_a104 := ddx_cust_account_rec.advance_payment_indicator;
2119
2121 p3_a1 := rosetta_g_miss_num_map(ddx_customer_profile_rec.cust_account_id);
2122 p3_a2 := ddx_customer_profile_rec.status;
2123 p3_a3 := rosetta_g_miss_num_map(ddx_customer_profile_rec.collector_id);
2124 p3_a4 := rosetta_g_miss_num_map(ddx_customer_profile_rec.credit_analyst_id);
2125 p3_a5 := ddx_customer_profile_rec.credit_checking;
2126 p3_a6 := ddx_customer_profile_rec.next_credit_review_date;
2127 p3_a7 := rosetta_g_miss_num_map(ddx_customer_profile_rec.tolerance);
2128 p3_a8 := ddx_customer_profile_rec.discount_terms;
2129 p3_a9 := ddx_customer_profile_rec.dunning_letters;
2130 p3_a10 := ddx_customer_profile_rec.interest_charges;
2131 p3_a11 := ddx_customer_profile_rec.send_statements;
2132 p3_a12 := ddx_customer_profile_rec.credit_balance_statements;
2133 p3_a13 := ddx_customer_profile_rec.credit_hold;
2134 p3_a14 := rosetta_g_miss_num_map(ddx_customer_profile_rec.profile_class_id);
2135 p3_a15 := rosetta_g_miss_num_map(ddx_customer_profile_rec.site_use_id);
2136 p3_a16 := ddx_customer_profile_rec.credit_rating;
2137 p3_a17 := ddx_customer_profile_rec.risk_code;
2138 p3_a18 := rosetta_g_miss_num_map(ddx_customer_profile_rec.standard_terms);
2139 p3_a19 := ddx_customer_profile_rec.override_terms;
2140 p3_a20 := rosetta_g_miss_num_map(ddx_customer_profile_rec.dunning_letter_set_id);
2141 p3_a21 := rosetta_g_miss_num_map(ddx_customer_profile_rec.interest_period_days);
2142 p3_a22 := rosetta_g_miss_num_map(ddx_customer_profile_rec.payment_grace_days);
2143 p3_a23 := rosetta_g_miss_num_map(ddx_customer_profile_rec.discount_grace_days);
2144 p3_a24 := rosetta_g_miss_num_map(ddx_customer_profile_rec.statement_cycle_id);
2145 p3_a25 := ddx_customer_profile_rec.account_status;
2146 p3_a26 := rosetta_g_miss_num_map(ddx_customer_profile_rec.percent_collectable);
2147 p3_a27 := rosetta_g_miss_num_map(ddx_customer_profile_rec.autocash_hierarchy_id);
2148 p3_a28 := ddx_customer_profile_rec.attribute_category;
2149 p3_a29 := ddx_customer_profile_rec.attribute1;
2150 p3_a30 := ddx_customer_profile_rec.attribute2;
2151 p3_a31 := ddx_customer_profile_rec.attribute3;
2152 p3_a32 := ddx_customer_profile_rec.attribute4;
2153 p3_a33 := ddx_customer_profile_rec.attribute5;
2154 p3_a34 := ddx_customer_profile_rec.attribute6;
2155 p3_a35 := ddx_customer_profile_rec.attribute7;
2156 p3_a36 := ddx_customer_profile_rec.attribute8;
2157 p3_a37 := ddx_customer_profile_rec.attribute9;
2158 p3_a38 := ddx_customer_profile_rec.attribute10;
2159 p3_a39 := ddx_customer_profile_rec.attribute11;
2160 p3_a40 := ddx_customer_profile_rec.attribute12;
2161 p3_a41 := ddx_customer_profile_rec.attribute13;
2162 p3_a42 := ddx_customer_profile_rec.attribute14;
2163 p3_a43 := ddx_customer_profile_rec.attribute15;
2164 p3_a44 := ddx_customer_profile_rec.auto_rec_incl_disputed_flag;
2165 p3_a45 := ddx_customer_profile_rec.tax_printing_option;
2166 p3_a46 := ddx_customer_profile_rec.charge_on_finance_charge_flag;
2167 p3_a47 := rosetta_g_miss_num_map(ddx_customer_profile_rec.grouping_rule_id);
2168 p3_a48 := rosetta_g_miss_num_map(ddx_customer_profile_rec.clearing_days);
2169 p3_a49 := ddx_customer_profile_rec.jgzz_attribute_category;
2170 p3_a50 := ddx_customer_profile_rec.jgzz_attribute1;
2171 p3_a51 := ddx_customer_profile_rec.jgzz_attribute2;
2172 p3_a52 := ddx_customer_profile_rec.jgzz_attribute3;
2173 p3_a53 := ddx_customer_profile_rec.jgzz_attribute4;
2174 p3_a54 := ddx_customer_profile_rec.jgzz_attribute5;
2175 p3_a55 := ddx_customer_profile_rec.jgzz_attribute6;
2176 p3_a56 := ddx_customer_profile_rec.jgzz_attribute7;
2177 p3_a57 := ddx_customer_profile_rec.jgzz_attribute8;
2178 p3_a58 := ddx_customer_profile_rec.jgzz_attribute9;
2179 p3_a59 := ddx_customer_profile_rec.jgzz_attribute10;
2180 p3_a60 := ddx_customer_profile_rec.jgzz_attribute11;
2181 p3_a61 := ddx_customer_profile_rec.jgzz_attribute12;
2182 p3_a62 := ddx_customer_profile_rec.jgzz_attribute13;
2183 p3_a63 := ddx_customer_profile_rec.jgzz_attribute14;
2184 p3_a64 := ddx_customer_profile_rec.jgzz_attribute15;
2185 p3_a65 := ddx_customer_profile_rec.global_attribute1;
2186 p3_a66 := ddx_customer_profile_rec.global_attribute2;
2187 p3_a67 := ddx_customer_profile_rec.global_attribute3;
2188 p3_a68 := ddx_customer_profile_rec.global_attribute4;
2189 p3_a69 := ddx_customer_profile_rec.global_attribute5;
2190 p3_a70 := ddx_customer_profile_rec.global_attribute6;
2191 p3_a71 := ddx_customer_profile_rec.global_attribute7;
2192 p3_a72 := ddx_customer_profile_rec.global_attribute8;
2193 p3_a73 := ddx_customer_profile_rec.global_attribute9;
2194 p3_a74 := ddx_customer_profile_rec.global_attribute10;
2195 p3_a75 := ddx_customer_profile_rec.global_attribute11;
2196 p3_a76 := ddx_customer_profile_rec.global_attribute12;
2197 p3_a77 := ddx_customer_profile_rec.global_attribute13;
2198 p3_a78 := ddx_customer_profile_rec.global_attribute14;
2199 p3_a79 := ddx_customer_profile_rec.global_attribute15;
2200 p3_a80 := ddx_customer_profile_rec.global_attribute16;
2201 p3_a81 := ddx_customer_profile_rec.global_attribute17;
2202 p3_a82 := ddx_customer_profile_rec.global_attribute18;
2203 p3_a83 := ddx_customer_profile_rec.global_attribute19;
2204 p3_a84 := ddx_customer_profile_rec.global_attribute20;
2205 p3_a85 := ddx_customer_profile_rec.global_attribute_category;
2206 p3_a86 := ddx_customer_profile_rec.cons_inv_flag;
2210 p3_a90 := ddx_customer_profile_rec.created_by_module;
2207 p3_a87 := ddx_customer_profile_rec.cons_inv_type;
2208 p3_a88 := rosetta_g_miss_num_map(ddx_customer_profile_rec.autocash_hierarchy_id_for_adr);
2209 p3_a89 := ddx_customer_profile_rec.lockbox_matching_option;
2211 p3_a91 := rosetta_g_miss_num_map(ddx_customer_profile_rec.application_id);
2212 p3_a92 := ddx_customer_profile_rec.review_cycle;
2213 p3_a93 := ddx_customer_profile_rec.last_credit_review_date;
2214 p3_a94 := rosetta_g_miss_num_map(ddx_customer_profile_rec.party_id);
2215 p3_a95 := ddx_customer_profile_rec.credit_classification;
2216 p3_a96 := ddx_customer_profile_rec.cons_bill_level;
2217 p3_a97 := ddx_customer_profile_rec.late_charge_calculation_trx;
2218 p3_a98 := ddx_customer_profile_rec.credit_items_flag;
2219 p3_a99 := ddx_customer_profile_rec.disputed_transactions_flag;
2220 p3_a100 := ddx_customer_profile_rec.late_charge_type;
2221 p3_a101 := rosetta_g_miss_num_map(ddx_customer_profile_rec.late_charge_term_id);
2222 p3_a102 := ddx_customer_profile_rec.interest_calculation_period;
2223 p3_a103 := ddx_customer_profile_rec.hold_charged_invoices_flag;
2224 p3_a104 := rosetta_g_miss_num_map(ddx_customer_profile_rec.message_text_id);
2225 p3_a105 := ddx_customer_profile_rec.multiple_interest_rates_flag;
2226 p3_a106 := ddx_customer_profile_rec.charge_begin_date;
2227
2228
2229
2230 end;
2231
2232 procedure create_cust_acct_relate_5(p_init_msg_list VARCHAR2
2233 , x_return_status out nocopy VARCHAR2
2234 , x_msg_count out nocopy NUMBER
2235 , x_msg_data out nocopy VARCHAR2
2236 , p1_a0 NUMBER := null
2237 , p1_a1 NUMBER := null
2238 , p1_a2 VARCHAR2 := null
2239 , p1_a3 VARCHAR2 := null
2240 , p1_a4 VARCHAR2 := null
2241 , p1_a5 VARCHAR2 := null
2242 , p1_a6 VARCHAR2 := null
2243 , p1_a7 VARCHAR2 := null
2244 , p1_a8 VARCHAR2 := null
2245 , p1_a9 VARCHAR2 := null
2246 , p1_a10 VARCHAR2 := null
2247 , p1_a11 VARCHAR2 := null
2248 , p1_a12 VARCHAR2 := null
2249 , p1_a13 VARCHAR2 := null
2250 , p1_a14 VARCHAR2 := null
2251 , p1_a15 VARCHAR2 := null
2252 , p1_a16 VARCHAR2 := null
2253 , p1_a17 VARCHAR2 := null
2254 , p1_a18 VARCHAR2 := null
2255 , p1_a19 VARCHAR2 := null
2256 , p1_a20 VARCHAR2 := null
2257 , p1_a21 VARCHAR2 := null
2258 , p1_a22 VARCHAR2 := null
2259 , p1_a23 VARCHAR2 := null
2260 , p1_a24 VARCHAR2 := null
2261 , p1_a25 NUMBER := null
2262 , p1_a26 NUMBER := null
2263 , p1_a27 NUMBER := null
2264 )
2265 as
2266 ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;
2267 ddindx binary_integer; indx binary_integer;
2268 begin
2269
2270 -- copy data to the local IN or IN-OUT args, if any
2271
2272 ddp_cust_acct_relate_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
2273 ddp_cust_acct_relate_rec.related_cust_account_id := rosetta_g_miss_num_map(p1_a1);
2274 ddp_cust_acct_relate_rec.relationship_type := p1_a2;
2275 ddp_cust_acct_relate_rec.comments := p1_a3;
2276 ddp_cust_acct_relate_rec.attribute_category := p1_a4;
2277 ddp_cust_acct_relate_rec.attribute1 := p1_a5;
2278 ddp_cust_acct_relate_rec.attribute2 := p1_a6;
2279 ddp_cust_acct_relate_rec.attribute3 := p1_a7;
2280 ddp_cust_acct_relate_rec.attribute4 := p1_a8;
2281 ddp_cust_acct_relate_rec.attribute5 := p1_a9;
2282 ddp_cust_acct_relate_rec.attribute6 := p1_a10;
2283 ddp_cust_acct_relate_rec.attribute7 := p1_a11;
2284 ddp_cust_acct_relate_rec.attribute8 := p1_a12;
2285 ddp_cust_acct_relate_rec.attribute9 := p1_a13;
2286 ddp_cust_acct_relate_rec.attribute10 := p1_a14;
2287 ddp_cust_acct_relate_rec.customer_reciprocal_flag := p1_a15;
2288 ddp_cust_acct_relate_rec.status := p1_a16;
2289 ddp_cust_acct_relate_rec.attribute11 := p1_a17;
2290 ddp_cust_acct_relate_rec.attribute12 := p1_a18;
2291 ddp_cust_acct_relate_rec.attribute13 := p1_a19;
2292 ddp_cust_acct_relate_rec.attribute14 := p1_a20;
2293 ddp_cust_acct_relate_rec.attribute15 := p1_a21;
2294 ddp_cust_acct_relate_rec.bill_to_flag := p1_a22;
2295 ddp_cust_acct_relate_rec.ship_to_flag := p1_a23;
2296 ddp_cust_acct_relate_rec.created_by_module := p1_a24;
2297 ddp_cust_acct_relate_rec.application_id := rosetta_g_miss_num_map(p1_a25);
2298 ddp_cust_acct_relate_rec.org_id := rosetta_g_miss_num_map(p1_a26);
2299 ddp_cust_acct_relate_rec.cust_acct_relate_id := rosetta_g_miss_num_map(p1_a27);
2300
2301
2302
2303
2304 -- here's the delegated call to the old PL/SQL routine
2305 hz_cust_account_v2pub.create_cust_acct_relate(p_init_msg_list,
2306 ddp_cust_acct_relate_rec,
2307 x_return_status,
2308 x_msg_count,
2309 x_msg_data);
2310
2311 -- copy data back from the local OUT or IN-OUT args, if any
2312
2313
2314
2315
2316 end;
2317
2318 procedure create_cust_acct_relate_6(p_init_msg_list VARCHAR2
2319 , x_cust_acct_relate_id out nocopy NUMBER
2320 , x_return_status out nocopy VARCHAR2
2321 , x_msg_count out nocopy NUMBER
2322 , x_msg_data out nocopy VARCHAR2
2323 , p1_a0 NUMBER := null
2324 , p1_a1 NUMBER := null
2325 , p1_a2 VARCHAR2 := null
2326 , p1_a3 VARCHAR2 := null
2327 , p1_a4 VARCHAR2 := null
2328 , p1_a5 VARCHAR2 := null
2329 , p1_a6 VARCHAR2 := null
2330 , p1_a7 VARCHAR2 := null
2331 , p1_a8 VARCHAR2 := null
2335 , p1_a12 VARCHAR2 := null
2332 , p1_a9 VARCHAR2 := null
2333 , p1_a10 VARCHAR2 := null
2334 , p1_a11 VARCHAR2 := null
2336 , p1_a13 VARCHAR2 := null
2337 , p1_a14 VARCHAR2 := null
2338 , p1_a15 VARCHAR2 := null
2339 , p1_a16 VARCHAR2 := null
2340 , p1_a17 VARCHAR2 := null
2341 , p1_a18 VARCHAR2 := null
2342 , p1_a19 VARCHAR2 := null
2343 , p1_a20 VARCHAR2 := null
2344 , p1_a21 VARCHAR2 := null
2345 , p1_a22 VARCHAR2 := null
2346 , p1_a23 VARCHAR2 := null
2347 , p1_a24 VARCHAR2 := null
2348 , p1_a25 NUMBER := null
2349 , p1_a26 NUMBER := null
2350 , p1_a27 NUMBER := null
2351 )
2352 as
2353 ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;
2354 ddindx binary_integer; indx binary_integer;
2355 begin
2356
2357 -- copy data to the local IN or IN-OUT args, if any
2358
2359 ddp_cust_acct_relate_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
2360 ddp_cust_acct_relate_rec.related_cust_account_id := rosetta_g_miss_num_map(p1_a1);
2361 ddp_cust_acct_relate_rec.relationship_type := p1_a2;
2362 ddp_cust_acct_relate_rec.comments := p1_a3;
2363 ddp_cust_acct_relate_rec.attribute_category := p1_a4;
2364 ddp_cust_acct_relate_rec.attribute1 := p1_a5;
2365 ddp_cust_acct_relate_rec.attribute2 := p1_a6;
2366 ddp_cust_acct_relate_rec.attribute3 := p1_a7;
2367 ddp_cust_acct_relate_rec.attribute4 := p1_a8;
2368 ddp_cust_acct_relate_rec.attribute5 := p1_a9;
2369 ddp_cust_acct_relate_rec.attribute6 := p1_a10;
2370 ddp_cust_acct_relate_rec.attribute7 := p1_a11;
2371 ddp_cust_acct_relate_rec.attribute8 := p1_a12;
2372 ddp_cust_acct_relate_rec.attribute9 := p1_a13;
2373 ddp_cust_acct_relate_rec.attribute10 := p1_a14;
2374 ddp_cust_acct_relate_rec.customer_reciprocal_flag := p1_a15;
2375 ddp_cust_acct_relate_rec.status := p1_a16;
2376 ddp_cust_acct_relate_rec.attribute11 := p1_a17;
2377 ddp_cust_acct_relate_rec.attribute12 := p1_a18;
2378 ddp_cust_acct_relate_rec.attribute13 := p1_a19;
2379 ddp_cust_acct_relate_rec.attribute14 := p1_a20;
2380 ddp_cust_acct_relate_rec.attribute15 := p1_a21;
2381 ddp_cust_acct_relate_rec.bill_to_flag := p1_a22;
2382 ddp_cust_acct_relate_rec.ship_to_flag := p1_a23;
2383 ddp_cust_acct_relate_rec.created_by_module := p1_a24;
2384 ddp_cust_acct_relate_rec.application_id := rosetta_g_miss_num_map(p1_a25);
2385 ddp_cust_acct_relate_rec.org_id := rosetta_g_miss_num_map(p1_a26);
2386 ddp_cust_acct_relate_rec.cust_acct_relate_id := rosetta_g_miss_num_map(p1_a27);
2387
2388
2389
2390
2391
2392 -- here's the delegated call to the old PL/SQL routine
2393 hz_cust_account_v2pub.create_cust_acct_relate(p_init_msg_list,
2394 ddp_cust_acct_relate_rec,
2395 x_cust_acct_relate_id,
2396 x_return_status,
2397 x_msg_count,
2398 x_msg_data);
2399
2400 -- copy data back from the local OUT or IN-OUT args, if any
2401
2402
2403
2404
2405
2406 end;
2407
2408 procedure update_cust_acct_relate_7(p_init_msg_list VARCHAR2
2409 , p_object_version_number in out nocopy NUMBER
2410 , x_return_status out nocopy VARCHAR2
2411 , x_msg_count out nocopy NUMBER
2412 , x_msg_data out nocopy VARCHAR2
2413 , p1_a0 NUMBER := null
2414 , p1_a1 NUMBER := null
2415 , p1_a2 VARCHAR2 := null
2416 , p1_a3 VARCHAR2 := null
2417 , p1_a4 VARCHAR2 := null
2418 , p1_a5 VARCHAR2 := null
2419 , p1_a6 VARCHAR2 := null
2420 , p1_a7 VARCHAR2 := null
2421 , p1_a8 VARCHAR2 := null
2422 , p1_a9 VARCHAR2 := null
2423 , p1_a10 VARCHAR2 := null
2424 , p1_a11 VARCHAR2 := null
2425 , p1_a12 VARCHAR2 := null
2426 , p1_a13 VARCHAR2 := null
2427 , p1_a14 VARCHAR2 := null
2428 , p1_a15 VARCHAR2 := null
2429 , p1_a16 VARCHAR2 := null
2430 , p1_a17 VARCHAR2 := null
2431 , p1_a18 VARCHAR2 := null
2432 , p1_a19 VARCHAR2 := null
2433 , p1_a20 VARCHAR2 := null
2434 , p1_a21 VARCHAR2 := null
2435 , p1_a22 VARCHAR2 := null
2436 , p1_a23 VARCHAR2 := null
2437 , p1_a24 VARCHAR2 := null
2438 , p1_a25 NUMBER := null
2439 , p1_a26 NUMBER := null
2440 , p1_a27 NUMBER := null
2441 )
2442 as
2443 ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;
2444 ddindx binary_integer; indx binary_integer;
2445 begin
2446
2447 -- copy data to the local IN or IN-OUT args, if any
2448
2449 ddp_cust_acct_relate_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
2450 ddp_cust_acct_relate_rec.related_cust_account_id := rosetta_g_miss_num_map(p1_a1);
2451 ddp_cust_acct_relate_rec.relationship_type := p1_a2;
2452 ddp_cust_acct_relate_rec.comments := p1_a3;
2453 ddp_cust_acct_relate_rec.attribute_category := p1_a4;
2454 ddp_cust_acct_relate_rec.attribute1 := p1_a5;
2455 ddp_cust_acct_relate_rec.attribute2 := p1_a6;
2456 ddp_cust_acct_relate_rec.attribute3 := p1_a7;
2457 ddp_cust_acct_relate_rec.attribute4 := p1_a8;
2458 ddp_cust_acct_relate_rec.attribute5 := p1_a9;
2459 ddp_cust_acct_relate_rec.attribute6 := p1_a10;
2460 ddp_cust_acct_relate_rec.attribute7 := p1_a11;
2461 ddp_cust_acct_relate_rec.attribute8 := p1_a12;
2462 ddp_cust_acct_relate_rec.attribute9 := p1_a13;
2463 ddp_cust_acct_relate_rec.attribute10 := p1_a14;
2467 ddp_cust_acct_relate_rec.attribute12 := p1_a18;
2464 ddp_cust_acct_relate_rec.customer_reciprocal_flag := p1_a15;
2465 ddp_cust_acct_relate_rec.status := p1_a16;
2466 ddp_cust_acct_relate_rec.attribute11 := p1_a17;
2468 ddp_cust_acct_relate_rec.attribute13 := p1_a19;
2469 ddp_cust_acct_relate_rec.attribute14 := p1_a20;
2470 ddp_cust_acct_relate_rec.attribute15 := p1_a21;
2471 ddp_cust_acct_relate_rec.bill_to_flag := p1_a22;
2472 ddp_cust_acct_relate_rec.ship_to_flag := p1_a23;
2473 ddp_cust_acct_relate_rec.created_by_module := p1_a24;
2474 ddp_cust_acct_relate_rec.application_id := rosetta_g_miss_num_map(p1_a25);
2475 ddp_cust_acct_relate_rec.org_id := rosetta_g_miss_num_map(p1_a26);
2476 ddp_cust_acct_relate_rec.cust_acct_relate_id := rosetta_g_miss_num_map(p1_a27);
2477
2478
2479
2480
2481
2482 -- here's the delegated call to the old PL/SQL routine
2483 hz_cust_account_v2pub.update_cust_acct_relate(p_init_msg_list,
2484 ddp_cust_acct_relate_rec,
2485 p_object_version_number,
2486 x_return_status,
2487 x_msg_count,
2488 x_msg_data);
2489
2490 -- copy data back from the local OUT or IN-OUT args, if any
2491
2492
2493
2494
2495
2496 end;
2497
2498 procedure update_cust_acct_relate_8(p_init_msg_list VARCHAR2
2499 , p_rowid ROWID
2500 , p_object_version_number in out nocopy NUMBER
2501 , x_return_status out nocopy VARCHAR2
2502 , x_msg_count out nocopy NUMBER
2503 , x_msg_data out nocopy VARCHAR2
2504 , p1_a0 NUMBER := null
2505 , p1_a1 NUMBER := null
2506 , p1_a2 VARCHAR2 := null
2507 , p1_a3 VARCHAR2 := null
2508 , p1_a4 VARCHAR2 := null
2509 , p1_a5 VARCHAR2 := null
2510 , p1_a6 VARCHAR2 := null
2511 , p1_a7 VARCHAR2 := null
2512 , p1_a8 VARCHAR2 := null
2513 , p1_a9 VARCHAR2 := null
2514 , p1_a10 VARCHAR2 := null
2515 , p1_a11 VARCHAR2 := null
2516 , p1_a12 VARCHAR2 := null
2517 , p1_a13 VARCHAR2 := null
2518 , p1_a14 VARCHAR2 := null
2519 , p1_a15 VARCHAR2 := null
2520 , p1_a16 VARCHAR2 := null
2521 , p1_a17 VARCHAR2 := null
2522 , p1_a18 VARCHAR2 := null
2523 , p1_a19 VARCHAR2 := null
2524 , p1_a20 VARCHAR2 := null
2525 , p1_a21 VARCHAR2 := null
2526 , p1_a22 VARCHAR2 := null
2527 , p1_a23 VARCHAR2 := null
2528 , p1_a24 VARCHAR2 := null
2529 , p1_a25 NUMBER := null
2530 , p1_a26 NUMBER := null
2531 , p1_a27 NUMBER := null
2532 )
2533 as
2534 ddp_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;
2535 ddindx binary_integer; indx binary_integer;
2536 begin
2537
2538 -- copy data to the local IN or IN-OUT args, if any
2539
2540 ddp_cust_acct_relate_rec.cust_account_id := rosetta_g_miss_num_map(p1_a0);
2541 ddp_cust_acct_relate_rec.related_cust_account_id := rosetta_g_miss_num_map(p1_a1);
2542 ddp_cust_acct_relate_rec.relationship_type := p1_a2;
2543 ddp_cust_acct_relate_rec.comments := p1_a3;
2544 ddp_cust_acct_relate_rec.attribute_category := p1_a4;
2545 ddp_cust_acct_relate_rec.attribute1 := p1_a5;
2546 ddp_cust_acct_relate_rec.attribute2 := p1_a6;
2547 ddp_cust_acct_relate_rec.attribute3 := p1_a7;
2548 ddp_cust_acct_relate_rec.attribute4 := p1_a8;
2549 ddp_cust_acct_relate_rec.attribute5 := p1_a9;
2550 ddp_cust_acct_relate_rec.attribute6 := p1_a10;
2551 ddp_cust_acct_relate_rec.attribute7 := p1_a11;
2552 ddp_cust_acct_relate_rec.attribute8 := p1_a12;
2553 ddp_cust_acct_relate_rec.attribute9 := p1_a13;
2554 ddp_cust_acct_relate_rec.attribute10 := p1_a14;
2555 ddp_cust_acct_relate_rec.customer_reciprocal_flag := p1_a15;
2556 ddp_cust_acct_relate_rec.status := p1_a16;
2557 ddp_cust_acct_relate_rec.attribute11 := p1_a17;
2558 ddp_cust_acct_relate_rec.attribute12 := p1_a18;
2559 ddp_cust_acct_relate_rec.attribute13 := p1_a19;
2560 ddp_cust_acct_relate_rec.attribute14 := p1_a20;
2561 ddp_cust_acct_relate_rec.attribute15 := p1_a21;
2562 ddp_cust_acct_relate_rec.bill_to_flag := p1_a22;
2563 ddp_cust_acct_relate_rec.ship_to_flag := p1_a23;
2564 ddp_cust_acct_relate_rec.created_by_module := p1_a24;
2565 ddp_cust_acct_relate_rec.application_id := rosetta_g_miss_num_map(p1_a25);
2566 ddp_cust_acct_relate_rec.org_id := rosetta_g_miss_num_map(p1_a26);
2567 ddp_cust_acct_relate_rec.cust_acct_relate_id := rosetta_g_miss_num_map(p1_a27);
2568
2569
2570
2571
2572
2573
2574 -- here's the delegated call to the old PL/SQL routine
2575 hz_cust_account_v2pub.update_cust_acct_relate(p_init_msg_list,
2576 ddp_cust_acct_relate_rec,
2577 p_rowid,
2578 p_object_version_number,
2579 x_return_status,
2580 x_msg_count,
2581 x_msg_data);
2582
2583 -- copy data back from the local OUT or IN-OUT args, if any
2584
2585
2586
2587
2588
2589
2590 end;
2591
2592 procedure get_cust_acct_relate_rec_9(p_init_msg_list VARCHAR2
2593 , p_cust_account_id NUMBER
2594 , p_related_cust_account_id NUMBER
2595 , p_cust_acct_relate_id NUMBER
2596 , p_rowid ROWID
2597 , p5_a0 out nocopy NUMBER
2598 , p5_a1 out nocopy NUMBER
2599 , p5_a2 out nocopy VARCHAR2
2603 , p5_a6 out nocopy VARCHAR2
2600 , p5_a3 out nocopy VARCHAR2
2601 , p5_a4 out nocopy VARCHAR2
2602 , p5_a5 out nocopy VARCHAR2
2604 , p5_a7 out nocopy VARCHAR2
2605 , p5_a8 out nocopy VARCHAR2
2606 , p5_a9 out nocopy VARCHAR2
2607 , p5_a10 out nocopy VARCHAR2
2608 , p5_a11 out nocopy VARCHAR2
2609 , p5_a12 out nocopy VARCHAR2
2610 , p5_a13 out nocopy VARCHAR2
2611 , p5_a14 out nocopy VARCHAR2
2612 , p5_a15 out nocopy VARCHAR2
2613 , p5_a16 out nocopy VARCHAR2
2614 , p5_a17 out nocopy VARCHAR2
2615 , p5_a18 out nocopy VARCHAR2
2616 , p5_a19 out nocopy VARCHAR2
2617 , p5_a20 out nocopy VARCHAR2
2618 , p5_a21 out nocopy VARCHAR2
2619 , p5_a22 out nocopy VARCHAR2
2620 , p5_a23 out nocopy VARCHAR2
2621 , p5_a24 out nocopy VARCHAR2
2622 , p5_a25 out nocopy NUMBER
2623 , p5_a26 out nocopy NUMBER
2624 , p5_a27 out nocopy NUMBER
2625 , x_return_status out nocopy VARCHAR2
2626 , x_msg_count out nocopy NUMBER
2627 , x_msg_data out nocopy VARCHAR2
2628 )
2629 as
2630 ddx_cust_acct_relate_rec hz_cust_account_v2pub.cust_acct_relate_rec_type;
2631 ddindx binary_integer; indx binary_integer;
2632 begin
2633
2634 -- copy data to the local IN or IN-OUT args, if any
2635
2636
2637
2638
2639
2640
2641
2642
2643
2644 -- here's the delegated call to the old PL/SQL routine
2645 hz_cust_account_v2pub.get_cust_acct_relate_rec(p_init_msg_list,
2646 p_cust_account_id,
2647 p_related_cust_account_id,
2648 p_cust_acct_relate_id,
2649 p_rowid,
2650 ddx_cust_acct_relate_rec,
2651 x_return_status,
2652 x_msg_count,
2653 x_msg_data);
2654
2655 -- copy data back from the local OUT or IN-OUT args, if any
2656
2657
2658
2659
2660
2661 p5_a0 := rosetta_g_miss_num_map(ddx_cust_acct_relate_rec.cust_account_id);
2662 p5_a1 := rosetta_g_miss_num_map(ddx_cust_acct_relate_rec.related_cust_account_id);
2663 p5_a2 := ddx_cust_acct_relate_rec.relationship_type;
2664 p5_a3 := ddx_cust_acct_relate_rec.comments;
2665 p5_a4 := ddx_cust_acct_relate_rec.attribute_category;
2666 p5_a5 := ddx_cust_acct_relate_rec.attribute1;
2667 p5_a6 := ddx_cust_acct_relate_rec.attribute2;
2668 p5_a7 := ddx_cust_acct_relate_rec.attribute3;
2669 p5_a8 := ddx_cust_acct_relate_rec.attribute4;
2670 p5_a9 := ddx_cust_acct_relate_rec.attribute5;
2671 p5_a10 := ddx_cust_acct_relate_rec.attribute6;
2672 p5_a11 := ddx_cust_acct_relate_rec.attribute7;
2673 p5_a12 := ddx_cust_acct_relate_rec.attribute8;
2674 p5_a13 := ddx_cust_acct_relate_rec.attribute9;
2675 p5_a14 := ddx_cust_acct_relate_rec.attribute10;
2676 p5_a15 := ddx_cust_acct_relate_rec.customer_reciprocal_flag;
2677 p5_a16 := ddx_cust_acct_relate_rec.status;
2678 p5_a17 := ddx_cust_acct_relate_rec.attribute11;
2679 p5_a18 := ddx_cust_acct_relate_rec.attribute12;
2680 p5_a19 := ddx_cust_acct_relate_rec.attribute13;
2681 p5_a20 := ddx_cust_acct_relate_rec.attribute14;
2682 p5_a21 := ddx_cust_acct_relate_rec.attribute15;
2683 p5_a22 := ddx_cust_acct_relate_rec.bill_to_flag;
2684 p5_a23 := ddx_cust_acct_relate_rec.ship_to_flag;
2685 p5_a24 := ddx_cust_acct_relate_rec.created_by_module;
2686 p5_a25 := rosetta_g_miss_num_map(ddx_cust_acct_relate_rec.application_id);
2687 p5_a26 := rosetta_g_miss_num_map(ddx_cust_acct_relate_rec.org_id);
2688 p5_a27 := rosetta_g_miss_num_map(ddx_cust_acct_relate_rec.cust_acct_relate_id);
2689
2690
2691
2692 end;
2693
2694 end hz_cust_account_v2pub_jw;