[Home] [Help]
PACKAGE BODY: APPS.HZ_CUST_ACCOUNT_SITE_V2PUB_JW
Source
1 package body hz_cust_account_site_v2pub_jw as
2 /* $Header: ARH2CSJB.pls 120.4 2006/02/24 00:52:27 baianand noship $ */
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_acct_site_1(p_init_msg_list VARCHAR2
23 , x_cust_acct_site_id out nocopy NUMBER
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p1_a0 NUMBER := null
28 , p1_a1 NUMBER := null
29 , p1_a2 NUMBER := null
30 , p1_a3 VARCHAR2 := null
31 , p1_a4 VARCHAR2 := null
32 , p1_a5 VARCHAR2 := null
33 , p1_a6 VARCHAR2 := null
34 , p1_a7 VARCHAR2 := null
35 , p1_a8 VARCHAR2 := null
36 , p1_a9 VARCHAR2 := null
37 , p1_a10 VARCHAR2 := null
38 , p1_a11 VARCHAR2 := null
39 , p1_a12 VARCHAR2 := null
40 , p1_a13 VARCHAR2 := null
41 , p1_a14 VARCHAR2 := null
42 , p1_a15 VARCHAR2 := null
43 , p1_a16 VARCHAR2 := null
44 , p1_a17 VARCHAR2 := null
45 , p1_a18 VARCHAR2 := null
46 , p1_a19 VARCHAR2 := null
47 , p1_a20 VARCHAR2 := null
48 , p1_a21 VARCHAR2 := null
49 , p1_a22 VARCHAR2 := null
50 , p1_a23 VARCHAR2 := null
51 , p1_a24 VARCHAR2 := null
52 , p1_a25 VARCHAR2 := null
53 , p1_a26 VARCHAR2 := null
54 , p1_a27 VARCHAR2 := null
55 , p1_a28 VARCHAR2 := null
56 , p1_a29 VARCHAR2 := null
57 , p1_a30 VARCHAR2 := null
58 , p1_a31 VARCHAR2 := null
59 , p1_a32 VARCHAR2 := null
60 , p1_a33 VARCHAR2 := null
61 , p1_a34 VARCHAR2 := null
62 , p1_a35 VARCHAR2 := null
63 , p1_a36 VARCHAR2 := null
64 , p1_a37 VARCHAR2 := null
65 , p1_a38 VARCHAR2 := null
66 , p1_a39 VARCHAR2 := null
67 , p1_a40 VARCHAR2 := null
68 , p1_a41 VARCHAR2 := null
69 , p1_a42 VARCHAR2 := null
70 , p1_a43 VARCHAR2 := null
71 , p1_a44 VARCHAR2 := null
72 , p1_a45 VARCHAR2 := null
73 , p1_a46 VARCHAR2 := null
74 , p1_a47 VARCHAR2 := null
75 , p1_a48 VARCHAR2 := null
76 , p1_a49 VARCHAR2 := null
77 , p1_a50 VARCHAR2 := null
78 , p1_a51 NUMBER := null
79 , p1_a52 VARCHAR2 := null
80 , p1_a53 NUMBER := null
81 , p1_a54 NUMBER := null
82 , p1_a55 NUMBER := null
83 , p1_a56 VARCHAR2 := null
84 , p1_a57 VARCHAR2 := null
85 , p1_a58 VARCHAR2 := null
86 , p1_a59 NUMBER := null
87 , p1_a60 NUMBER := null
88 )
89 as
90 ddp_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
91 ddindx binary_integer; indx binary_integer;
92 begin
93
94 -- copy data to the local IN or IN-OUT args, if any
95
96 ddp_cust_acct_site_rec.cust_acct_site_id := rosetta_g_miss_num_map(p1_a0);
97 ddp_cust_acct_site_rec.cust_account_id := rosetta_g_miss_num_map(p1_a1);
98 ddp_cust_acct_site_rec.party_site_id := rosetta_g_miss_num_map(p1_a2);
99 ddp_cust_acct_site_rec.attribute_category := p1_a3;
100 ddp_cust_acct_site_rec.attribute1 := p1_a4;
101 ddp_cust_acct_site_rec.attribute2 := p1_a5;
102 ddp_cust_acct_site_rec.attribute3 := p1_a6;
103 ddp_cust_acct_site_rec.attribute4 := p1_a7;
104 ddp_cust_acct_site_rec.attribute5 := p1_a8;
105 ddp_cust_acct_site_rec.attribute6 := p1_a9;
106 ddp_cust_acct_site_rec.attribute7 := p1_a10;
107 ddp_cust_acct_site_rec.attribute8 := p1_a11;
108 ddp_cust_acct_site_rec.attribute9 := p1_a12;
109 ddp_cust_acct_site_rec.attribute10 := p1_a13;
110 ddp_cust_acct_site_rec.attribute11 := p1_a14;
111 ddp_cust_acct_site_rec.attribute12 := p1_a15;
112 ddp_cust_acct_site_rec.attribute13 := p1_a16;
113 ddp_cust_acct_site_rec.attribute14 := p1_a17;
114 ddp_cust_acct_site_rec.attribute15 := p1_a18;
115 ddp_cust_acct_site_rec.attribute16 := p1_a19;
116 ddp_cust_acct_site_rec.attribute17 := p1_a20;
117 ddp_cust_acct_site_rec.attribute18 := p1_a21;
118 ddp_cust_acct_site_rec.attribute19 := p1_a22;
119 ddp_cust_acct_site_rec.attribute20 := p1_a23;
120 ddp_cust_acct_site_rec.global_attribute_category := p1_a24;
121 ddp_cust_acct_site_rec.global_attribute1 := p1_a25;
122 ddp_cust_acct_site_rec.global_attribute2 := p1_a26;
123 ddp_cust_acct_site_rec.global_attribute3 := p1_a27;
124 ddp_cust_acct_site_rec.global_attribute4 := p1_a28;
125 ddp_cust_acct_site_rec.global_attribute5 := p1_a29;
126 ddp_cust_acct_site_rec.global_attribute6 := p1_a30;
127 ddp_cust_acct_site_rec.global_attribute7 := p1_a31;
128 ddp_cust_acct_site_rec.global_attribute8 := p1_a32;
129 ddp_cust_acct_site_rec.global_attribute9 := p1_a33;
130 ddp_cust_acct_site_rec.global_attribute10 := p1_a34;
131 ddp_cust_acct_site_rec.global_attribute11 := p1_a35;
132 ddp_cust_acct_site_rec.global_attribute12 := p1_a36;
133 ddp_cust_acct_site_rec.global_attribute13 := p1_a37;
134 ddp_cust_acct_site_rec.global_attribute14 := p1_a38;
135 ddp_cust_acct_site_rec.global_attribute15 := p1_a39;
136 ddp_cust_acct_site_rec.global_attribute16 := p1_a40;
137 ddp_cust_acct_site_rec.global_attribute17 := p1_a41;
138 ddp_cust_acct_site_rec.global_attribute18 := p1_a42;
139 ddp_cust_acct_site_rec.global_attribute19 := p1_a43;
140 ddp_cust_acct_site_rec.global_attribute20 := p1_a44;
141 ddp_cust_acct_site_rec.orig_system_reference := p1_a45;
142 ddp_cust_acct_site_rec.orig_system := p1_a46;
143 ddp_cust_acct_site_rec.status := p1_a47;
144 ddp_cust_acct_site_rec.customer_category_code := p1_a48;
145 ddp_cust_acct_site_rec.language := p1_a49;
146 ddp_cust_acct_site_rec.key_account_flag := p1_a50;
147 ddp_cust_acct_site_rec.tp_header_id := rosetta_g_miss_num_map(p1_a51);
148 ddp_cust_acct_site_rec.ece_tp_location_code := p1_a52;
149 ddp_cust_acct_site_rec.primary_specialist_id := rosetta_g_miss_num_map(p1_a53);
150 ddp_cust_acct_site_rec.secondary_specialist_id := rosetta_g_miss_num_map(p1_a54);
151 ddp_cust_acct_site_rec.territory_id := rosetta_g_miss_num_map(p1_a55);
152 ddp_cust_acct_site_rec.territory := p1_a56;
153 ddp_cust_acct_site_rec.translated_customer_name := p1_a57;
154 ddp_cust_acct_site_rec.created_by_module := p1_a58;
155 ddp_cust_acct_site_rec.application_id := rosetta_g_miss_num_map(p1_a59);
156 ddp_cust_acct_site_rec.org_id := rosetta_g_miss_num_map(p1_a60);
157
158
159
160
161
162 -- here's the delegated call to the old PL/SQL routine
163 hz_cust_account_site_v2pub.create_cust_acct_site(p_init_msg_list,
164 ddp_cust_acct_site_rec,
165 x_cust_acct_site_id,
166 x_return_status,
167 x_msg_count,
168 x_msg_data);
169
170 -- copy data back from the local OUT or IN-OUT args, if any
171
172
173
174
175
176 end;
177
178 procedure update_cust_acct_site_2(p_init_msg_list VARCHAR2
179 , p_object_version_number in out nocopy NUMBER
180 , x_return_status out nocopy VARCHAR2
181 , x_msg_count out nocopy NUMBER
182 , x_msg_data out nocopy VARCHAR2
183 , p1_a0 NUMBER := null
184 , p1_a1 NUMBER := null
185 , p1_a2 NUMBER := null
186 , p1_a3 VARCHAR2 := null
187 , p1_a4 VARCHAR2 := null
188 , p1_a5 VARCHAR2 := null
189 , p1_a6 VARCHAR2 := null
190 , p1_a7 VARCHAR2 := null
191 , p1_a8 VARCHAR2 := null
192 , p1_a9 VARCHAR2 := null
193 , p1_a10 VARCHAR2 := null
194 , p1_a11 VARCHAR2 := null
195 , p1_a12 VARCHAR2 := null
196 , p1_a13 VARCHAR2 := null
197 , p1_a14 VARCHAR2 := null
198 , p1_a15 VARCHAR2 := null
199 , p1_a16 VARCHAR2 := null
200 , p1_a17 VARCHAR2 := null
201 , p1_a18 VARCHAR2 := null
202 , p1_a19 VARCHAR2 := null
203 , p1_a20 VARCHAR2 := null
204 , p1_a21 VARCHAR2 := null
205 , p1_a22 VARCHAR2 := null
206 , p1_a23 VARCHAR2 := null
207 , p1_a24 VARCHAR2 := null
208 , p1_a25 VARCHAR2 := null
209 , p1_a26 VARCHAR2 := null
210 , p1_a27 VARCHAR2 := null
211 , p1_a28 VARCHAR2 := null
212 , p1_a29 VARCHAR2 := null
213 , p1_a30 VARCHAR2 := null
214 , p1_a31 VARCHAR2 := null
215 , p1_a32 VARCHAR2 := null
216 , p1_a33 VARCHAR2 := null
217 , p1_a34 VARCHAR2 := null
218 , p1_a35 VARCHAR2 := null
219 , p1_a36 VARCHAR2 := null
220 , p1_a37 VARCHAR2 := null
221 , p1_a38 VARCHAR2 := null
222 , p1_a39 VARCHAR2 := null
223 , p1_a40 VARCHAR2 := null
224 , p1_a41 VARCHAR2 := null
225 , p1_a42 VARCHAR2 := null
226 , p1_a43 VARCHAR2 := null
227 , p1_a44 VARCHAR2 := null
228 , p1_a45 VARCHAR2 := null
229 , p1_a46 VARCHAR2 := null
230 , p1_a47 VARCHAR2 := null
231 , p1_a48 VARCHAR2 := null
232 , p1_a49 VARCHAR2 := null
233 , p1_a50 VARCHAR2 := null
234 , p1_a51 NUMBER := null
235 , p1_a52 VARCHAR2 := null
236 , p1_a53 NUMBER := null
237 , p1_a54 NUMBER := null
238 , p1_a55 NUMBER := null
239 , p1_a56 VARCHAR2 := null
240 , p1_a57 VARCHAR2 := null
241 , p1_a58 VARCHAR2 := null
242 , p1_a59 NUMBER := null
243 , p1_a60 NUMBER := null
244 )
245 as
246 ddp_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
247 ddindx binary_integer; indx binary_integer;
248 begin
249
250 -- copy data to the local IN or IN-OUT args, if any
251
252 ddp_cust_acct_site_rec.cust_acct_site_id := rosetta_g_miss_num_map(p1_a0);
253 ddp_cust_acct_site_rec.cust_account_id := rosetta_g_miss_num_map(p1_a1);
254 ddp_cust_acct_site_rec.party_site_id := rosetta_g_miss_num_map(p1_a2);
255 ddp_cust_acct_site_rec.attribute_category := p1_a3;
256 ddp_cust_acct_site_rec.attribute1 := p1_a4;
257 ddp_cust_acct_site_rec.attribute2 := p1_a5;
258 ddp_cust_acct_site_rec.attribute3 := p1_a6;
259 ddp_cust_acct_site_rec.attribute4 := p1_a7;
260 ddp_cust_acct_site_rec.attribute5 := p1_a8;
261 ddp_cust_acct_site_rec.attribute6 := p1_a9;
262 ddp_cust_acct_site_rec.attribute7 := p1_a10;
263 ddp_cust_acct_site_rec.attribute8 := p1_a11;
264 ddp_cust_acct_site_rec.attribute9 := p1_a12;
265 ddp_cust_acct_site_rec.attribute10 := p1_a13;
266 ddp_cust_acct_site_rec.attribute11 := p1_a14;
267 ddp_cust_acct_site_rec.attribute12 := p1_a15;
268 ddp_cust_acct_site_rec.attribute13 := p1_a16;
269 ddp_cust_acct_site_rec.attribute14 := p1_a17;
270 ddp_cust_acct_site_rec.attribute15 := p1_a18;
271 ddp_cust_acct_site_rec.attribute16 := p1_a19;
272 ddp_cust_acct_site_rec.attribute17 := p1_a20;
273 ddp_cust_acct_site_rec.attribute18 := p1_a21;
274 ddp_cust_acct_site_rec.attribute19 := p1_a22;
275 ddp_cust_acct_site_rec.attribute20 := p1_a23;
276 ddp_cust_acct_site_rec.global_attribute_category := p1_a24;
277 ddp_cust_acct_site_rec.global_attribute1 := p1_a25;
278 ddp_cust_acct_site_rec.global_attribute2 := p1_a26;
279 ddp_cust_acct_site_rec.global_attribute3 := p1_a27;
280 ddp_cust_acct_site_rec.global_attribute4 := p1_a28;
281 ddp_cust_acct_site_rec.global_attribute5 := p1_a29;
282 ddp_cust_acct_site_rec.global_attribute6 := p1_a30;
283 ddp_cust_acct_site_rec.global_attribute7 := p1_a31;
284 ddp_cust_acct_site_rec.global_attribute8 := p1_a32;
285 ddp_cust_acct_site_rec.global_attribute9 := p1_a33;
286 ddp_cust_acct_site_rec.global_attribute10 := p1_a34;
287 ddp_cust_acct_site_rec.global_attribute11 := p1_a35;
288 ddp_cust_acct_site_rec.global_attribute12 := p1_a36;
289 ddp_cust_acct_site_rec.global_attribute13 := p1_a37;
290 ddp_cust_acct_site_rec.global_attribute14 := p1_a38;
291 ddp_cust_acct_site_rec.global_attribute15 := p1_a39;
292 ddp_cust_acct_site_rec.global_attribute16 := p1_a40;
293 ddp_cust_acct_site_rec.global_attribute17 := p1_a41;
294 ddp_cust_acct_site_rec.global_attribute18 := p1_a42;
295 ddp_cust_acct_site_rec.global_attribute19 := p1_a43;
296 ddp_cust_acct_site_rec.global_attribute20 := p1_a44;
297 ddp_cust_acct_site_rec.orig_system_reference := p1_a45;
298 ddp_cust_acct_site_rec.orig_system := p1_a46;
299 ddp_cust_acct_site_rec.status := p1_a47;
300 ddp_cust_acct_site_rec.customer_category_code := p1_a48;
301 ddp_cust_acct_site_rec.language := p1_a49;
302 ddp_cust_acct_site_rec.key_account_flag := p1_a50;
303 ddp_cust_acct_site_rec.tp_header_id := rosetta_g_miss_num_map(p1_a51);
304 ddp_cust_acct_site_rec.ece_tp_location_code := p1_a52;
305 ddp_cust_acct_site_rec.primary_specialist_id := rosetta_g_miss_num_map(p1_a53);
306 ddp_cust_acct_site_rec.secondary_specialist_id := rosetta_g_miss_num_map(p1_a54);
307 ddp_cust_acct_site_rec.territory_id := rosetta_g_miss_num_map(p1_a55);
308 ddp_cust_acct_site_rec.territory := p1_a56;
309 ddp_cust_acct_site_rec.translated_customer_name := p1_a57;
310 ddp_cust_acct_site_rec.created_by_module := p1_a58;
311 ddp_cust_acct_site_rec.application_id := rosetta_g_miss_num_map(p1_a59);
312 ddp_cust_acct_site_rec.org_id := rosetta_g_miss_num_map(p1_a60);
313
314
315
316
317
318 -- here's the delegated call to the old PL/SQL routine
319 hz_cust_account_site_v2pub.update_cust_acct_site(p_init_msg_list,
320 ddp_cust_acct_site_rec,
321 p_object_version_number,
322 x_return_status,
323 x_msg_count,
324 x_msg_data);
325
326 -- copy data back from the local OUT or IN-OUT args, if any
327
328
329
330
331
332 end;
333
334 procedure get_cust_acct_site_rec_3(p_init_msg_list VARCHAR2
335 , p_cust_acct_site_id NUMBER
336 , p2_a0 out nocopy NUMBER
337 , p2_a1 out nocopy NUMBER
338 , p2_a2 out nocopy NUMBER
339 , p2_a3 out nocopy VARCHAR2
340 , p2_a4 out nocopy VARCHAR2
341 , p2_a5 out nocopy VARCHAR2
342 , p2_a6 out nocopy VARCHAR2
343 , p2_a7 out nocopy VARCHAR2
344 , p2_a8 out nocopy VARCHAR2
345 , p2_a9 out nocopy VARCHAR2
346 , p2_a10 out nocopy VARCHAR2
347 , p2_a11 out nocopy VARCHAR2
348 , p2_a12 out nocopy VARCHAR2
349 , p2_a13 out nocopy VARCHAR2
353 , p2_a17 out nocopy VARCHAR2
350 , p2_a14 out nocopy VARCHAR2
351 , p2_a15 out nocopy VARCHAR2
352 , p2_a16 out nocopy VARCHAR2
354 , p2_a18 out nocopy VARCHAR2
355 , p2_a19 out nocopy VARCHAR2
356 , p2_a20 out nocopy VARCHAR2
357 , p2_a21 out nocopy VARCHAR2
358 , p2_a22 out nocopy VARCHAR2
359 , p2_a23 out nocopy VARCHAR2
360 , p2_a24 out nocopy VARCHAR2
361 , p2_a25 out nocopy VARCHAR2
362 , p2_a26 out nocopy VARCHAR2
363 , p2_a27 out nocopy VARCHAR2
364 , p2_a28 out nocopy VARCHAR2
365 , p2_a29 out nocopy VARCHAR2
366 , p2_a30 out nocopy VARCHAR2
367 , p2_a31 out nocopy VARCHAR2
368 , p2_a32 out nocopy VARCHAR2
369 , p2_a33 out nocopy VARCHAR2
370 , p2_a34 out nocopy VARCHAR2
371 , p2_a35 out nocopy VARCHAR2
372 , p2_a36 out nocopy VARCHAR2
373 , p2_a37 out nocopy VARCHAR2
374 , p2_a38 out nocopy VARCHAR2
375 , p2_a39 out nocopy VARCHAR2
376 , p2_a40 out nocopy VARCHAR2
377 , p2_a41 out nocopy VARCHAR2
378 , p2_a42 out nocopy VARCHAR2
379 , p2_a43 out nocopy VARCHAR2
380 , p2_a44 out nocopy VARCHAR2
381 , p2_a45 out nocopy VARCHAR2
382 , p2_a46 out nocopy VARCHAR2
383 , p2_a47 out nocopy VARCHAR2
384 , p2_a48 out nocopy VARCHAR2
385 , p2_a49 out nocopy VARCHAR2
386 , p2_a50 out nocopy VARCHAR2
387 , p2_a51 out nocopy NUMBER
388 , p2_a52 out nocopy VARCHAR2
389 , p2_a53 out nocopy NUMBER
390 , p2_a54 out nocopy NUMBER
391 , p2_a55 out nocopy NUMBER
392 , p2_a56 out nocopy VARCHAR2
393 , p2_a57 out nocopy VARCHAR2
394 , p2_a58 out nocopy VARCHAR2
395 , p2_a59 out nocopy NUMBER
396 , p2_a60 out nocopy NUMBER
397 , x_return_status out nocopy VARCHAR2
398 , x_msg_count out nocopy NUMBER
399 , x_msg_data out nocopy VARCHAR2
400 )
401 as
402 ddx_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
403 ddindx binary_integer; indx binary_integer;
404 begin
405
406 -- copy data to the local IN or IN-OUT args, if any
407
408
409
410
411
412
413 -- here's the delegated call to the old PL/SQL routine
414 hz_cust_account_site_v2pub.get_cust_acct_site_rec(p_init_msg_list,
415 p_cust_acct_site_id,
416 ddx_cust_acct_site_rec,
417 x_return_status,
418 x_msg_count,
419 x_msg_data);
420
421 -- copy data back from the local OUT or IN-OUT args, if any
422
423
424 p2_a0 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.cust_acct_site_id);
425 p2_a1 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.cust_account_id);
426 p2_a2 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.party_site_id);
427 p2_a3 := ddx_cust_acct_site_rec.attribute_category;
428 p2_a4 := ddx_cust_acct_site_rec.attribute1;
429 p2_a5 := ddx_cust_acct_site_rec.attribute2;
430 p2_a6 := ddx_cust_acct_site_rec.attribute3;
431 p2_a7 := ddx_cust_acct_site_rec.attribute4;
432 p2_a8 := ddx_cust_acct_site_rec.attribute5;
433 p2_a9 := ddx_cust_acct_site_rec.attribute6;
434 p2_a10 := ddx_cust_acct_site_rec.attribute7;
435 p2_a11 := ddx_cust_acct_site_rec.attribute8;
436 p2_a12 := ddx_cust_acct_site_rec.attribute9;
437 p2_a13 := ddx_cust_acct_site_rec.attribute10;
438 p2_a14 := ddx_cust_acct_site_rec.attribute11;
439 p2_a15 := ddx_cust_acct_site_rec.attribute12;
440 p2_a16 := ddx_cust_acct_site_rec.attribute13;
441 p2_a17 := ddx_cust_acct_site_rec.attribute14;
442 p2_a18 := ddx_cust_acct_site_rec.attribute15;
443 p2_a19 := ddx_cust_acct_site_rec.attribute16;
444 p2_a20 := ddx_cust_acct_site_rec.attribute17;
445 p2_a21 := ddx_cust_acct_site_rec.attribute18;
446 p2_a22 := ddx_cust_acct_site_rec.attribute19;
447 p2_a23 := ddx_cust_acct_site_rec.attribute20;
448 p2_a24 := ddx_cust_acct_site_rec.global_attribute_category;
449 p2_a25 := ddx_cust_acct_site_rec.global_attribute1;
450 p2_a26 := ddx_cust_acct_site_rec.global_attribute2;
451 p2_a27 := ddx_cust_acct_site_rec.global_attribute3;
452 p2_a28 := ddx_cust_acct_site_rec.global_attribute4;
453 p2_a29 := ddx_cust_acct_site_rec.global_attribute5;
454 p2_a30 := ddx_cust_acct_site_rec.global_attribute6;
455 p2_a31 := ddx_cust_acct_site_rec.global_attribute7;
456 p2_a32 := ddx_cust_acct_site_rec.global_attribute8;
457 p2_a33 := ddx_cust_acct_site_rec.global_attribute9;
458 p2_a34 := ddx_cust_acct_site_rec.global_attribute10;
459 p2_a35 := ddx_cust_acct_site_rec.global_attribute11;
460 p2_a36 := ddx_cust_acct_site_rec.global_attribute12;
461 p2_a37 := ddx_cust_acct_site_rec.global_attribute13;
462 p2_a38 := ddx_cust_acct_site_rec.global_attribute14;
463 p2_a39 := ddx_cust_acct_site_rec.global_attribute15;
464 p2_a40 := ddx_cust_acct_site_rec.global_attribute16;
465 p2_a41 := ddx_cust_acct_site_rec.global_attribute17;
466 p2_a42 := ddx_cust_acct_site_rec.global_attribute18;
467 p2_a43 := ddx_cust_acct_site_rec.global_attribute19;
468 p2_a44 := ddx_cust_acct_site_rec.global_attribute20;
469 p2_a45 := ddx_cust_acct_site_rec.orig_system_reference;
470 p2_a46 := ddx_cust_acct_site_rec.orig_system;
471 p2_a47 := ddx_cust_acct_site_rec.status;
472 p2_a48 := ddx_cust_acct_site_rec.customer_category_code;
473 p2_a49 := ddx_cust_acct_site_rec.language;
477 p2_a53 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.primary_specialist_id);
474 p2_a50 := ddx_cust_acct_site_rec.key_account_flag;
475 p2_a51 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.tp_header_id);
476 p2_a52 := ddx_cust_acct_site_rec.ece_tp_location_code;
478 p2_a54 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.secondary_specialist_id);
479 p2_a55 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.territory_id);
480 p2_a56 := ddx_cust_acct_site_rec.territory;
481 p2_a57 := ddx_cust_acct_site_rec.translated_customer_name;
482 p2_a58 := ddx_cust_acct_site_rec.created_by_module;
483 p2_a59 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.application_id);
484 p2_a60 := rosetta_g_miss_num_map(ddx_cust_acct_site_rec.org_id);
485
486
487
488 end;
489
490 procedure create_cust_site_use_4(p_init_msg_list VARCHAR2
491 , p_create_profile VARCHAR2
492 , p_create_profile_amt VARCHAR2
493 , x_site_use_id out nocopy NUMBER
494 , x_return_status out nocopy VARCHAR2
495 , x_msg_count out nocopy NUMBER
496 , x_msg_data out nocopy VARCHAR2
497 , p1_a0 NUMBER := null
498 , p1_a1 NUMBER := null
499 , p1_a2 VARCHAR2 := null
500 , p1_a3 VARCHAR2 := null
501 , p1_a4 VARCHAR2 := null
502 , p1_a5 VARCHAR2 := null
503 , p1_a6 NUMBER := null
504 , p1_a7 NUMBER := null
505 , p1_a8 VARCHAR2 := null
506 , p1_a9 VARCHAR2 := null
507 , p1_a10 VARCHAR2 := null
508 , p1_a11 NUMBER := null
509 , p1_a12 VARCHAR2 := null
510 , p1_a13 VARCHAR2 := null
511 , p1_a14 VARCHAR2 := null
512 , p1_a15 VARCHAR2 := null
513 , p1_a16 NUMBER := null
514 , p1_a17 NUMBER := null
515 , p1_a18 VARCHAR2 := null
516 , p1_a19 NUMBER := null
517 , p1_a20 NUMBER := null
518 , p1_a21 VARCHAR2 := null
519 , p1_a22 VARCHAR2 := null
520 , p1_a23 VARCHAR2 := null
521 , p1_a24 VARCHAR2 := null
522 , p1_a25 VARCHAR2 := null
523 , p1_a26 VARCHAR2 := null
524 , p1_a27 VARCHAR2 := null
525 , p1_a28 VARCHAR2 := null
526 , p1_a29 VARCHAR2 := null
527 , p1_a30 VARCHAR2 := null
528 , p1_a31 VARCHAR2 := null
529 , p1_a32 VARCHAR2 := null
530 , p1_a33 NUMBER := null
531 , p1_a34 VARCHAR2 := null
532 , p1_a35 VARCHAR2 := null
533 , p1_a36 VARCHAR2 := null
534 , p1_a37 VARCHAR2 := null
535 , p1_a38 VARCHAR2 := null
536 , p1_a39 VARCHAR2 := null
537 , p1_a40 VARCHAR2 := null
538 , p1_a41 VARCHAR2 := null
539 , p1_a42 VARCHAR2 := null
540 , p1_a43 VARCHAR2 := null
541 , p1_a44 VARCHAR2 := null
542 , p1_a45 VARCHAR2 := null
543 , p1_a46 VARCHAR2 := null
544 , p1_a47 VARCHAR2 := null
545 , p1_a48 VARCHAR2 := null
546 , p1_a49 VARCHAR2 := null
547 , p1_a50 VARCHAR2 := null
548 , p1_a51 VARCHAR2 := null
549 , p1_a52 VARCHAR2 := null
550 , p1_a53 VARCHAR2 := null
551 , p1_a54 VARCHAR2 := null
552 , p1_a55 VARCHAR2 := null
553 , p1_a56 VARCHAR2 := null
554 , p1_a57 VARCHAR2 := null
555 , p1_a58 VARCHAR2 := null
556 , p1_a59 VARCHAR2 := null
557 , p1_a60 VARCHAR2 := null
558 , p1_a61 VARCHAR2 := null
559 , p1_a62 VARCHAR2 := null
560 , p1_a63 VARCHAR2 := null
561 , p1_a64 VARCHAR2 := null
562 , p1_a65 VARCHAR2 := null
563 , p1_a66 VARCHAR2 := null
564 , p1_a67 VARCHAR2 := null
565 , p1_a68 VARCHAR2 := null
566 , p1_a69 VARCHAR2 := null
567 , p1_a70 VARCHAR2 := null
568 , p1_a71 VARCHAR2 := null
569 , p1_a72 VARCHAR2 := null
570 , p1_a73 VARCHAR2 := null
571 , p1_a74 NUMBER := null
572 , p1_a75 NUMBER := null
573 , p1_a76 NUMBER := null
574 , p1_a77 NUMBER := null
575 , p1_a78 VARCHAR2 := null
576 , p1_a79 NUMBER := null
577 , p1_a80 NUMBER := null
578 , p1_a81 VARCHAR2 := null
579 , p1_a82 NUMBER := null
580 , p1_a83 NUMBER := null
581 , p1_a84 VARCHAR2 := null
582 , p1_a85 VARCHAR2 := null
583 , p1_a86 VARCHAR2 := null
584 , p1_a87 VARCHAR2 := null
585 , p1_a88 VARCHAR2 := null
586 , p1_a89 NUMBER := null
587 , p1_a90 NUMBER := null
588 , p1_a91 NUMBER := null
589 , p1_a92 NUMBER := null
590 , p1_a93 NUMBER := null
591 , p1_a94 NUMBER := null
592 , p1_a95 NUMBER := null
593 , p1_a96 NUMBER := null
594 , p1_a97 NUMBER := null
595 , p1_a98 NUMBER := null
596 , p1_a99 VARCHAR2 := null
597 , p1_a100 VARCHAR2 := null
598 , p1_a101 NUMBER := null
599 , p1_a102 NUMBER := null
600 , p2_a0 NUMBER := null
601 , p2_a1 NUMBER := null
602 , p2_a2 VARCHAR2 := null
603 , p2_a3 NUMBER := null
604 , p2_a4 NUMBER := null
605 , p2_a5 VARCHAR2 := null
606 , p2_a6 DATE := null
607 , p2_a7 NUMBER := null
608 , p2_a8 VARCHAR2 := null
609 , p2_a9 VARCHAR2 := null
610 , p2_a10 VARCHAR2 := null
611 , p2_a11 VARCHAR2 := null
612 , p2_a12 VARCHAR2 := null
613 , p2_a13 VARCHAR2 := null
614 , p2_a14 NUMBER := null
615 , p2_a15 NUMBER := null
616 , p2_a16 VARCHAR2 := null
617 , p2_a17 VARCHAR2 := null
618 , p2_a18 NUMBER := null
622 , p2_a22 NUMBER := null
619 , p2_a19 VARCHAR2 := null
620 , p2_a20 NUMBER := null
621 , p2_a21 NUMBER := null
623 , p2_a23 NUMBER := null
624 , p2_a24 NUMBER := null
625 , p2_a25 VARCHAR2 := null
626 , p2_a26 NUMBER := null
627 , p2_a27 NUMBER := null
628 , p2_a28 VARCHAR2 := null
629 , p2_a29 VARCHAR2 := null
630 , p2_a30 VARCHAR2 := null
631 , p2_a31 VARCHAR2 := null
632 , p2_a32 VARCHAR2 := null
633 , p2_a33 VARCHAR2 := null
634 , p2_a34 VARCHAR2 := null
635 , p2_a35 VARCHAR2 := null
636 , p2_a36 VARCHAR2 := null
637 , p2_a37 VARCHAR2 := null
638 , p2_a38 VARCHAR2 := null
639 , p2_a39 VARCHAR2 := null
640 , p2_a40 VARCHAR2 := null
641 , p2_a41 VARCHAR2 := null
642 , p2_a42 VARCHAR2 := null
643 , p2_a43 VARCHAR2 := null
644 , p2_a44 VARCHAR2 := null
645 , p2_a45 VARCHAR2 := null
646 , p2_a46 VARCHAR2 := null
647 , p2_a47 NUMBER := null
648 , p2_a48 NUMBER := null
649 , p2_a49 VARCHAR2 := null
650 , p2_a50 VARCHAR2 := null
651 , p2_a51 VARCHAR2 := null
652 , p2_a52 VARCHAR2 := null
653 , p2_a53 VARCHAR2 := null
654 , p2_a54 VARCHAR2 := null
655 , p2_a55 VARCHAR2 := null
656 , p2_a56 VARCHAR2 := null
657 , p2_a57 VARCHAR2 := null
658 , p2_a58 VARCHAR2 := null
659 , p2_a59 VARCHAR2 := null
660 , p2_a60 VARCHAR2 := null
661 , p2_a61 VARCHAR2 := null
662 , p2_a62 VARCHAR2 := null
663 , p2_a63 VARCHAR2 := null
664 , p2_a64 VARCHAR2 := null
665 , p2_a65 VARCHAR2 := null
666 , p2_a66 VARCHAR2 := null
667 , p2_a67 VARCHAR2 := null
668 , p2_a68 VARCHAR2 := null
669 , p2_a69 VARCHAR2 := null
670 , p2_a70 VARCHAR2 := null
671 , p2_a71 VARCHAR2 := null
672 , p2_a72 VARCHAR2 := null
673 , p2_a73 VARCHAR2 := null
674 , p2_a74 VARCHAR2 := null
675 , p2_a75 VARCHAR2 := null
676 , p2_a76 VARCHAR2 := null
677 , p2_a77 VARCHAR2 := null
678 , p2_a78 VARCHAR2 := null
679 , p2_a79 VARCHAR2 := null
680 , p2_a80 VARCHAR2 := null
681 , p2_a81 VARCHAR2 := null
682 , p2_a82 VARCHAR2 := null
683 , p2_a83 VARCHAR2 := null
684 , p2_a84 VARCHAR2 := null
685 , p2_a85 VARCHAR2 := null
686 , p2_a86 VARCHAR2 := null
687 , p2_a87 VARCHAR2 := null
688 , p2_a88 NUMBER := null
689 , p2_a89 VARCHAR2 := null
690 , p2_a90 VARCHAR2 := null
691 , p2_a91 NUMBER := null
692 , p2_a92 VARCHAR2 := null
693 , p2_a93 DATE := null
694 , p2_a94 NUMBER := null
695 , p2_a95 VARCHAR2 := null
696 , p2_a96 VARCHAR2 := null
697 , p2_a97 VARCHAR2 := null
698 , p2_a98 VARCHAR2 := null
699 , p2_a99 VARCHAR2 := null
700 , p2_a100 VARCHAR2 := null
701 , p2_a101 NUMBER := null
702 , p2_a102 VARCHAR2 := null
703 , p2_a103 VARCHAR2 := null
704 , p2_a104 NUMBER := null
705 , p2_a105 VARCHAR2 := null
706 , p2_a106 DATE := null
707 )
708 as
709 ddp_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type;
710 ddp_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type;
711 ddindx binary_integer; indx binary_integer;
712 begin
713
714 -- copy data to the local IN or IN-OUT args, if any
715
716 ddp_cust_site_use_rec.site_use_id := rosetta_g_miss_num_map(p1_a0);
717 ddp_cust_site_use_rec.cust_acct_site_id := rosetta_g_miss_num_map(p1_a1);
718 ddp_cust_site_use_rec.site_use_code := p1_a2;
719 ddp_cust_site_use_rec.primary_flag := p1_a3;
720 ddp_cust_site_use_rec.status := p1_a4;
721 ddp_cust_site_use_rec.location := p1_a5;
722 ddp_cust_site_use_rec.contact_id := rosetta_g_miss_num_map(p1_a6);
723 ddp_cust_site_use_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p1_a7);
724 ddp_cust_site_use_rec.orig_system_reference := p1_a8;
725 ddp_cust_site_use_rec.orig_system := p1_a9;
726 ddp_cust_site_use_rec.sic_code := p1_a10;
727 ddp_cust_site_use_rec.payment_term_id := rosetta_g_miss_num_map(p1_a11);
728 ddp_cust_site_use_rec.gsa_indicator := p1_a12;
729 ddp_cust_site_use_rec.ship_partial := p1_a13;
730 ddp_cust_site_use_rec.ship_via := p1_a14;
731 ddp_cust_site_use_rec.fob_point := p1_a15;
732 ddp_cust_site_use_rec.order_type_id := rosetta_g_miss_num_map(p1_a16);
733 ddp_cust_site_use_rec.price_list_id := rosetta_g_miss_num_map(p1_a17);
734 ddp_cust_site_use_rec.freight_term := p1_a18;
735 ddp_cust_site_use_rec.warehouse_id := rosetta_g_miss_num_map(p1_a19);
736 ddp_cust_site_use_rec.territory_id := rosetta_g_miss_num_map(p1_a20);
737 ddp_cust_site_use_rec.attribute_category := p1_a21;
738 ddp_cust_site_use_rec.attribute1 := p1_a22;
739 ddp_cust_site_use_rec.attribute2 := p1_a23;
740 ddp_cust_site_use_rec.attribute3 := p1_a24;
741 ddp_cust_site_use_rec.attribute4 := p1_a25;
742 ddp_cust_site_use_rec.attribute5 := p1_a26;
743 ddp_cust_site_use_rec.attribute6 := p1_a27;
744 ddp_cust_site_use_rec.attribute7 := p1_a28;
745 ddp_cust_site_use_rec.attribute8 := p1_a29;
746 ddp_cust_site_use_rec.attribute9 := p1_a30;
747 ddp_cust_site_use_rec.attribute10 := p1_a31;
748 ddp_cust_site_use_rec.tax_reference := p1_a32;
749 ddp_cust_site_use_rec.sort_priority := rosetta_g_miss_num_map(p1_a33);
750 ddp_cust_site_use_rec.tax_code := p1_a34;
751 ddp_cust_site_use_rec.attribute11 := p1_a35;
755 ddp_cust_site_use_rec.attribute15 := p1_a39;
752 ddp_cust_site_use_rec.attribute12 := p1_a36;
753 ddp_cust_site_use_rec.attribute13 := p1_a37;
754 ddp_cust_site_use_rec.attribute14 := p1_a38;
756 ddp_cust_site_use_rec.attribute16 := p1_a40;
757 ddp_cust_site_use_rec.attribute17 := p1_a41;
758 ddp_cust_site_use_rec.attribute18 := p1_a42;
759 ddp_cust_site_use_rec.attribute19 := p1_a43;
760 ddp_cust_site_use_rec.attribute20 := p1_a44;
761 ddp_cust_site_use_rec.attribute21 := p1_a45;
762 ddp_cust_site_use_rec.attribute22 := p1_a46;
763 ddp_cust_site_use_rec.attribute23 := p1_a47;
764 ddp_cust_site_use_rec.attribute24 := p1_a48;
765 ddp_cust_site_use_rec.attribute25 := p1_a49;
766 ddp_cust_site_use_rec.demand_class_code := p1_a50;
767 ddp_cust_site_use_rec.tax_header_level_flag := p1_a51;
768 ddp_cust_site_use_rec.tax_rounding_rule := p1_a52;
769 ddp_cust_site_use_rec.global_attribute1 := p1_a53;
770 ddp_cust_site_use_rec.global_attribute2 := p1_a54;
771 ddp_cust_site_use_rec.global_attribute3 := p1_a55;
772 ddp_cust_site_use_rec.global_attribute4 := p1_a56;
773 ddp_cust_site_use_rec.global_attribute5 := p1_a57;
774 ddp_cust_site_use_rec.global_attribute6 := p1_a58;
775 ddp_cust_site_use_rec.global_attribute7 := p1_a59;
776 ddp_cust_site_use_rec.global_attribute8 := p1_a60;
777 ddp_cust_site_use_rec.global_attribute9 := p1_a61;
778 ddp_cust_site_use_rec.global_attribute10 := p1_a62;
779 ddp_cust_site_use_rec.global_attribute11 := p1_a63;
780 ddp_cust_site_use_rec.global_attribute12 := p1_a64;
781 ddp_cust_site_use_rec.global_attribute13 := p1_a65;
782 ddp_cust_site_use_rec.global_attribute14 := p1_a66;
783 ddp_cust_site_use_rec.global_attribute15 := p1_a67;
784 ddp_cust_site_use_rec.global_attribute16 := p1_a68;
785 ddp_cust_site_use_rec.global_attribute17 := p1_a69;
786 ddp_cust_site_use_rec.global_attribute18 := p1_a70;
787 ddp_cust_site_use_rec.global_attribute19 := p1_a71;
788 ddp_cust_site_use_rec.global_attribute20 := p1_a72;
789 ddp_cust_site_use_rec.global_attribute_category := p1_a73;
790 ddp_cust_site_use_rec.primary_salesrep_id := rosetta_g_miss_num_map(p1_a74);
791 ddp_cust_site_use_rec.finchrg_receivables_trx_id := rosetta_g_miss_num_map(p1_a75);
792 ddp_cust_site_use_rec.dates_negative_tolerance := rosetta_g_miss_num_map(p1_a76);
793 ddp_cust_site_use_rec.dates_positive_tolerance := rosetta_g_miss_num_map(p1_a77);
794 ddp_cust_site_use_rec.date_type_preference := p1_a78;
795 ddp_cust_site_use_rec.over_shipment_tolerance := rosetta_g_miss_num_map(p1_a79);
796 ddp_cust_site_use_rec.under_shipment_tolerance := rosetta_g_miss_num_map(p1_a80);
797 ddp_cust_site_use_rec.item_cross_ref_pref := p1_a81;
798 ddp_cust_site_use_rec.over_return_tolerance := rosetta_g_miss_num_map(p1_a82);
799 ddp_cust_site_use_rec.under_return_tolerance := rosetta_g_miss_num_map(p1_a83);
800 ddp_cust_site_use_rec.ship_sets_include_lines_flag := p1_a84;
801 ddp_cust_site_use_rec.arrivalsets_include_lines_flag := p1_a85;
802 ddp_cust_site_use_rec.sched_date_push_flag := p1_a86;
803 ddp_cust_site_use_rec.invoice_quantity_rule := p1_a87;
804 ddp_cust_site_use_rec.pricing_event := p1_a88;
805 ddp_cust_site_use_rec.gl_id_rec := rosetta_g_miss_num_map(p1_a89);
806 ddp_cust_site_use_rec.gl_id_rev := rosetta_g_miss_num_map(p1_a90);
807 ddp_cust_site_use_rec.gl_id_tax := rosetta_g_miss_num_map(p1_a91);
808 ddp_cust_site_use_rec.gl_id_freight := rosetta_g_miss_num_map(p1_a92);
809 ddp_cust_site_use_rec.gl_id_clearing := rosetta_g_miss_num_map(p1_a93);
810 ddp_cust_site_use_rec.gl_id_unbilled := rosetta_g_miss_num_map(p1_a94);
811 ddp_cust_site_use_rec.gl_id_unearned := rosetta_g_miss_num_map(p1_a95);
812 ddp_cust_site_use_rec.gl_id_unpaid_rec := rosetta_g_miss_num_map(p1_a96);
813 ddp_cust_site_use_rec.gl_id_remittance := rosetta_g_miss_num_map(p1_a97);
814 ddp_cust_site_use_rec.gl_id_factor := rosetta_g_miss_num_map(p1_a98);
815 ddp_cust_site_use_rec.tax_classification := p1_a99;
816 ddp_cust_site_use_rec.created_by_module := p1_a100;
817 ddp_cust_site_use_rec.application_id := rosetta_g_miss_num_map(p1_a101);
818 ddp_cust_site_use_rec.org_id := rosetta_g_miss_num_map(p1_a102);
819
820 ddp_customer_profile_rec.cust_account_profile_id := rosetta_g_miss_num_map(p2_a0);
821 ddp_customer_profile_rec.cust_account_id := rosetta_g_miss_num_map(p2_a1);
822 ddp_customer_profile_rec.status := p2_a2;
823 ddp_customer_profile_rec.collector_id := rosetta_g_miss_num_map(p2_a3);
824 ddp_customer_profile_rec.credit_analyst_id := rosetta_g_miss_num_map(p2_a4);
825 ddp_customer_profile_rec.credit_checking := p2_a5;
826 ddp_customer_profile_rec.next_credit_review_date := rosetta_g_miss_date_in_map(p2_a6);
827 ddp_customer_profile_rec.tolerance := rosetta_g_miss_num_map(p2_a7);
828 ddp_customer_profile_rec.discount_terms := p2_a8;
829 ddp_customer_profile_rec.dunning_letters := p2_a9;
830 ddp_customer_profile_rec.interest_charges := p2_a10;
831 ddp_customer_profile_rec.send_statements := p2_a11;
832 ddp_customer_profile_rec.credit_balance_statements := p2_a12;
833 ddp_customer_profile_rec.credit_hold := p2_a13;
834 ddp_customer_profile_rec.profile_class_id := rosetta_g_miss_num_map(p2_a14);
835 ddp_customer_profile_rec.site_use_id := rosetta_g_miss_num_map(p2_a15);
836 ddp_customer_profile_rec.credit_rating := p2_a16;
837 ddp_customer_profile_rec.risk_code := p2_a17;
838 ddp_customer_profile_rec.standard_terms := rosetta_g_miss_num_map(p2_a18);
839 ddp_customer_profile_rec.override_terms := p2_a19;
843 ddp_customer_profile_rec.discount_grace_days := rosetta_g_miss_num_map(p2_a23);
840 ddp_customer_profile_rec.dunning_letter_set_id := rosetta_g_miss_num_map(p2_a20);
841 ddp_customer_profile_rec.interest_period_days := rosetta_g_miss_num_map(p2_a21);
842 ddp_customer_profile_rec.payment_grace_days := rosetta_g_miss_num_map(p2_a22);
844 ddp_customer_profile_rec.statement_cycle_id := rosetta_g_miss_num_map(p2_a24);
845 ddp_customer_profile_rec.account_status := p2_a25;
846 ddp_customer_profile_rec.percent_collectable := rosetta_g_miss_num_map(p2_a26);
847 ddp_customer_profile_rec.autocash_hierarchy_id := rosetta_g_miss_num_map(p2_a27);
848 ddp_customer_profile_rec.attribute_category := p2_a28;
849 ddp_customer_profile_rec.attribute1 := p2_a29;
850 ddp_customer_profile_rec.attribute2 := p2_a30;
851 ddp_customer_profile_rec.attribute3 := p2_a31;
852 ddp_customer_profile_rec.attribute4 := p2_a32;
853 ddp_customer_profile_rec.attribute5 := p2_a33;
854 ddp_customer_profile_rec.attribute6 := p2_a34;
855 ddp_customer_profile_rec.attribute7 := p2_a35;
856 ddp_customer_profile_rec.attribute8 := p2_a36;
857 ddp_customer_profile_rec.attribute9 := p2_a37;
858 ddp_customer_profile_rec.attribute10 := p2_a38;
859 ddp_customer_profile_rec.attribute11 := p2_a39;
860 ddp_customer_profile_rec.attribute12 := p2_a40;
861 ddp_customer_profile_rec.attribute13 := p2_a41;
862 ddp_customer_profile_rec.attribute14 := p2_a42;
863 ddp_customer_profile_rec.attribute15 := p2_a43;
864 ddp_customer_profile_rec.auto_rec_incl_disputed_flag := p2_a44;
865 ddp_customer_profile_rec.tax_printing_option := p2_a45;
866 ddp_customer_profile_rec.charge_on_finance_charge_flag := p2_a46;
867 ddp_customer_profile_rec.grouping_rule_id := rosetta_g_miss_num_map(p2_a47);
868 ddp_customer_profile_rec.clearing_days := rosetta_g_miss_num_map(p2_a48);
869 ddp_customer_profile_rec.jgzz_attribute_category := p2_a49;
870 ddp_customer_profile_rec.jgzz_attribute1 := p2_a50;
871 ddp_customer_profile_rec.jgzz_attribute2 := p2_a51;
872 ddp_customer_profile_rec.jgzz_attribute3 := p2_a52;
873 ddp_customer_profile_rec.jgzz_attribute4 := p2_a53;
874 ddp_customer_profile_rec.jgzz_attribute5 := p2_a54;
875 ddp_customer_profile_rec.jgzz_attribute6 := p2_a55;
876 ddp_customer_profile_rec.jgzz_attribute7 := p2_a56;
877 ddp_customer_profile_rec.jgzz_attribute8 := p2_a57;
878 ddp_customer_profile_rec.jgzz_attribute9 := p2_a58;
879 ddp_customer_profile_rec.jgzz_attribute10 := p2_a59;
880 ddp_customer_profile_rec.jgzz_attribute11 := p2_a60;
881 ddp_customer_profile_rec.jgzz_attribute12 := p2_a61;
882 ddp_customer_profile_rec.jgzz_attribute13 := p2_a62;
883 ddp_customer_profile_rec.jgzz_attribute14 := p2_a63;
884 ddp_customer_profile_rec.jgzz_attribute15 := p2_a64;
885 ddp_customer_profile_rec.global_attribute1 := p2_a65;
886 ddp_customer_profile_rec.global_attribute2 := p2_a66;
887 ddp_customer_profile_rec.global_attribute3 := p2_a67;
888 ddp_customer_profile_rec.global_attribute4 := p2_a68;
889 ddp_customer_profile_rec.global_attribute5 := p2_a69;
890 ddp_customer_profile_rec.global_attribute6 := p2_a70;
891 ddp_customer_profile_rec.global_attribute7 := p2_a71;
892 ddp_customer_profile_rec.global_attribute8 := p2_a72;
893 ddp_customer_profile_rec.global_attribute9 := p2_a73;
894 ddp_customer_profile_rec.global_attribute10 := p2_a74;
895 ddp_customer_profile_rec.global_attribute11 := p2_a75;
896 ddp_customer_profile_rec.global_attribute12 := p2_a76;
897 ddp_customer_profile_rec.global_attribute13 := p2_a77;
898 ddp_customer_profile_rec.global_attribute14 := p2_a78;
899 ddp_customer_profile_rec.global_attribute15 := p2_a79;
900 ddp_customer_profile_rec.global_attribute16 := p2_a80;
901 ddp_customer_profile_rec.global_attribute17 := p2_a81;
902 ddp_customer_profile_rec.global_attribute18 := p2_a82;
903 ddp_customer_profile_rec.global_attribute19 := p2_a83;
904 ddp_customer_profile_rec.global_attribute20 := p2_a84;
905 ddp_customer_profile_rec.global_attribute_category := p2_a85;
906 ddp_customer_profile_rec.cons_inv_flag := p2_a86;
907 ddp_customer_profile_rec.cons_inv_type := p2_a87;
908 ddp_customer_profile_rec.autocash_hierarchy_id_for_adr := rosetta_g_miss_num_map(p2_a88);
909 ddp_customer_profile_rec.lockbox_matching_option := p2_a89;
910 ddp_customer_profile_rec.created_by_module := p2_a90;
911 ddp_customer_profile_rec.application_id := rosetta_g_miss_num_map(p2_a91);
912 ddp_customer_profile_rec.review_cycle := p2_a92;
913 ddp_customer_profile_rec.last_credit_review_date := rosetta_g_miss_date_in_map(p2_a93);
914 ddp_customer_profile_rec.party_id := rosetta_g_miss_num_map(p2_a94);
915 ddp_customer_profile_rec.credit_classification := p2_a95;
916 ddp_customer_profile_rec.cons_bill_level := p2_a96;
917 ddp_customer_profile_rec.late_charge_calculation_trx := p2_a97;
918 ddp_customer_profile_rec.credit_items_flag := p2_a98;
919 ddp_customer_profile_rec.disputed_transactions_flag := p2_a99;
920 ddp_customer_profile_rec.late_charge_type := p2_a100;
921 ddp_customer_profile_rec.late_charge_term_id := rosetta_g_miss_num_map(p2_a101);
922 ddp_customer_profile_rec.interest_calculation_period := p2_a102;
923 ddp_customer_profile_rec.hold_charged_invoices_flag := p2_a103;
924 ddp_customer_profile_rec.message_text_id := rosetta_g_miss_num_map(p2_a104);
925 ddp_customer_profile_rec.multiple_interest_rates_flag := p2_a105;
926 ddp_customer_profile_rec.charge_begin_date := rosetta_g_miss_date_in_map(p2_a106);
927
928
929
930
934 -- here's the delegated call to the old PL/SQL routine
931
932
933
935 hz_cust_account_site_v2pub.create_cust_site_use(p_init_msg_list,
936 ddp_cust_site_use_rec,
937 ddp_customer_profile_rec,
938 p_create_profile,
939 p_create_profile_amt,
940 x_site_use_id,
941 x_return_status,
942 x_msg_count,
943 x_msg_data);
944
945 -- copy data back from the local OUT or IN-OUT args, if any
946
947
948
949
950
951
952
953
954 end;
955
956 procedure update_cust_site_use_5(p_init_msg_list VARCHAR2
957 , p_object_version_number in out nocopy NUMBER
958 , x_return_status out nocopy VARCHAR2
959 , x_msg_count out nocopy NUMBER
960 , x_msg_data out nocopy VARCHAR2
961 , p1_a0 NUMBER := null
962 , p1_a1 NUMBER := null
963 , p1_a2 VARCHAR2 := null
964 , p1_a3 VARCHAR2 := null
965 , p1_a4 VARCHAR2 := null
966 , p1_a5 VARCHAR2 := null
967 , p1_a6 NUMBER := null
968 , p1_a7 NUMBER := null
969 , p1_a8 VARCHAR2 := null
970 , p1_a9 VARCHAR2 := null
971 , p1_a10 VARCHAR2 := null
972 , p1_a11 NUMBER := null
973 , p1_a12 VARCHAR2 := null
974 , p1_a13 VARCHAR2 := null
975 , p1_a14 VARCHAR2 := null
976 , p1_a15 VARCHAR2 := null
977 , p1_a16 NUMBER := null
978 , p1_a17 NUMBER := null
979 , p1_a18 VARCHAR2 := null
980 , p1_a19 NUMBER := null
981 , p1_a20 NUMBER := null
982 , p1_a21 VARCHAR2 := null
983 , p1_a22 VARCHAR2 := null
984 , p1_a23 VARCHAR2 := null
985 , p1_a24 VARCHAR2 := null
986 , p1_a25 VARCHAR2 := null
987 , p1_a26 VARCHAR2 := null
988 , p1_a27 VARCHAR2 := null
989 , p1_a28 VARCHAR2 := null
990 , p1_a29 VARCHAR2 := null
991 , p1_a30 VARCHAR2 := null
992 , p1_a31 VARCHAR2 := null
993 , p1_a32 VARCHAR2 := null
994 , p1_a33 NUMBER := null
995 , p1_a34 VARCHAR2 := null
996 , p1_a35 VARCHAR2 := null
997 , p1_a36 VARCHAR2 := null
998 , p1_a37 VARCHAR2 := null
999 , p1_a38 VARCHAR2 := null
1000 , p1_a39 VARCHAR2 := null
1001 , p1_a40 VARCHAR2 := null
1002 , p1_a41 VARCHAR2 := null
1003 , p1_a42 VARCHAR2 := null
1004 , p1_a43 VARCHAR2 := null
1005 , p1_a44 VARCHAR2 := null
1006 , p1_a45 VARCHAR2 := null
1007 , p1_a46 VARCHAR2 := null
1008 , p1_a47 VARCHAR2 := null
1009 , p1_a48 VARCHAR2 := null
1010 , p1_a49 VARCHAR2 := null
1011 , p1_a50 VARCHAR2 := null
1012 , p1_a51 VARCHAR2 := null
1013 , p1_a52 VARCHAR2 := null
1014 , p1_a53 VARCHAR2 := null
1015 , p1_a54 VARCHAR2 := null
1016 , p1_a55 VARCHAR2 := null
1017 , p1_a56 VARCHAR2 := null
1018 , p1_a57 VARCHAR2 := null
1019 , p1_a58 VARCHAR2 := null
1020 , p1_a59 VARCHAR2 := null
1021 , p1_a60 VARCHAR2 := null
1022 , p1_a61 VARCHAR2 := null
1023 , p1_a62 VARCHAR2 := null
1024 , p1_a63 VARCHAR2 := null
1025 , p1_a64 VARCHAR2 := null
1026 , p1_a65 VARCHAR2 := null
1027 , p1_a66 VARCHAR2 := null
1028 , p1_a67 VARCHAR2 := null
1029 , p1_a68 VARCHAR2 := null
1030 , p1_a69 VARCHAR2 := null
1031 , p1_a70 VARCHAR2 := null
1032 , p1_a71 VARCHAR2 := null
1033 , p1_a72 VARCHAR2 := null
1034 , p1_a73 VARCHAR2 := null
1035 , p1_a74 NUMBER := null
1036 , p1_a75 NUMBER := null
1037 , p1_a76 NUMBER := null
1038 , p1_a77 NUMBER := null
1039 , p1_a78 VARCHAR2 := null
1040 , p1_a79 NUMBER := null
1041 , p1_a80 NUMBER := null
1042 , p1_a81 VARCHAR2 := null
1043 , p1_a82 NUMBER := null
1044 , p1_a83 NUMBER := null
1045 , p1_a84 VARCHAR2 := null
1046 , p1_a85 VARCHAR2 := null
1047 , p1_a86 VARCHAR2 := null
1048 , p1_a87 VARCHAR2 := null
1049 , p1_a88 VARCHAR2 := null
1050 , p1_a89 NUMBER := null
1051 , p1_a90 NUMBER := null
1052 , p1_a91 NUMBER := null
1053 , p1_a92 NUMBER := null
1054 , p1_a93 NUMBER := null
1055 , p1_a94 NUMBER := null
1056 , p1_a95 NUMBER := null
1057 , p1_a96 NUMBER := null
1058 , p1_a97 NUMBER := null
1059 , p1_a98 NUMBER := null
1060 , p1_a99 VARCHAR2 := null
1061 , p1_a100 VARCHAR2 := null
1062 , p1_a101 NUMBER := null
1063 , p1_a102 NUMBER := null
1064 )
1065 as
1066 ddp_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type;
1067 ddindx binary_integer; indx binary_integer;
1068 begin
1069
1070 -- copy data to the local IN or IN-OUT args, if any
1071
1072 ddp_cust_site_use_rec.site_use_id := rosetta_g_miss_num_map(p1_a0);
1073 ddp_cust_site_use_rec.cust_acct_site_id := rosetta_g_miss_num_map(p1_a1);
1074 ddp_cust_site_use_rec.site_use_code := p1_a2;
1075 ddp_cust_site_use_rec.primary_flag := p1_a3;
1076 ddp_cust_site_use_rec.status := p1_a4;
1077 ddp_cust_site_use_rec.location := p1_a5;
1078 ddp_cust_site_use_rec.contact_id := rosetta_g_miss_num_map(p1_a6);
1079 ddp_cust_site_use_rec.bill_to_site_use_id := rosetta_g_miss_num_map(p1_a7);
1080 ddp_cust_site_use_rec.orig_system_reference := p1_a8;
1081 ddp_cust_site_use_rec.orig_system := p1_a9;
1082 ddp_cust_site_use_rec.sic_code := p1_a10;
1083 ddp_cust_site_use_rec.payment_term_id := rosetta_g_miss_num_map(p1_a11);
1087 ddp_cust_site_use_rec.fob_point := p1_a15;
1084 ddp_cust_site_use_rec.gsa_indicator := p1_a12;
1085 ddp_cust_site_use_rec.ship_partial := p1_a13;
1086 ddp_cust_site_use_rec.ship_via := p1_a14;
1088 ddp_cust_site_use_rec.order_type_id := rosetta_g_miss_num_map(p1_a16);
1089 ddp_cust_site_use_rec.price_list_id := rosetta_g_miss_num_map(p1_a17);
1090 ddp_cust_site_use_rec.freight_term := p1_a18;
1091 ddp_cust_site_use_rec.warehouse_id := rosetta_g_miss_num_map(p1_a19);
1092 ddp_cust_site_use_rec.territory_id := rosetta_g_miss_num_map(p1_a20);
1093 ddp_cust_site_use_rec.attribute_category := p1_a21;
1094 ddp_cust_site_use_rec.attribute1 := p1_a22;
1095 ddp_cust_site_use_rec.attribute2 := p1_a23;
1096 ddp_cust_site_use_rec.attribute3 := p1_a24;
1097 ddp_cust_site_use_rec.attribute4 := p1_a25;
1098 ddp_cust_site_use_rec.attribute5 := p1_a26;
1099 ddp_cust_site_use_rec.attribute6 := p1_a27;
1100 ddp_cust_site_use_rec.attribute7 := p1_a28;
1101 ddp_cust_site_use_rec.attribute8 := p1_a29;
1102 ddp_cust_site_use_rec.attribute9 := p1_a30;
1103 ddp_cust_site_use_rec.attribute10 := p1_a31;
1104 ddp_cust_site_use_rec.tax_reference := p1_a32;
1105 ddp_cust_site_use_rec.sort_priority := rosetta_g_miss_num_map(p1_a33);
1106 ddp_cust_site_use_rec.tax_code := p1_a34;
1107 ddp_cust_site_use_rec.attribute11 := p1_a35;
1108 ddp_cust_site_use_rec.attribute12 := p1_a36;
1109 ddp_cust_site_use_rec.attribute13 := p1_a37;
1110 ddp_cust_site_use_rec.attribute14 := p1_a38;
1111 ddp_cust_site_use_rec.attribute15 := p1_a39;
1112 ddp_cust_site_use_rec.attribute16 := p1_a40;
1113 ddp_cust_site_use_rec.attribute17 := p1_a41;
1114 ddp_cust_site_use_rec.attribute18 := p1_a42;
1115 ddp_cust_site_use_rec.attribute19 := p1_a43;
1116 ddp_cust_site_use_rec.attribute20 := p1_a44;
1117 ddp_cust_site_use_rec.attribute21 := p1_a45;
1118 ddp_cust_site_use_rec.attribute22 := p1_a46;
1119 ddp_cust_site_use_rec.attribute23 := p1_a47;
1120 ddp_cust_site_use_rec.attribute24 := p1_a48;
1121 ddp_cust_site_use_rec.attribute25 := p1_a49;
1122 ddp_cust_site_use_rec.demand_class_code := p1_a50;
1123 ddp_cust_site_use_rec.tax_header_level_flag := p1_a51;
1124 ddp_cust_site_use_rec.tax_rounding_rule := p1_a52;
1125 ddp_cust_site_use_rec.global_attribute1 := p1_a53;
1126 ddp_cust_site_use_rec.global_attribute2 := p1_a54;
1127 ddp_cust_site_use_rec.global_attribute3 := p1_a55;
1128 ddp_cust_site_use_rec.global_attribute4 := p1_a56;
1129 ddp_cust_site_use_rec.global_attribute5 := p1_a57;
1130 ddp_cust_site_use_rec.global_attribute6 := p1_a58;
1131 ddp_cust_site_use_rec.global_attribute7 := p1_a59;
1132 ddp_cust_site_use_rec.global_attribute8 := p1_a60;
1133 ddp_cust_site_use_rec.global_attribute9 := p1_a61;
1134 ddp_cust_site_use_rec.global_attribute10 := p1_a62;
1135 ddp_cust_site_use_rec.global_attribute11 := p1_a63;
1136 ddp_cust_site_use_rec.global_attribute12 := p1_a64;
1137 ddp_cust_site_use_rec.global_attribute13 := p1_a65;
1138 ddp_cust_site_use_rec.global_attribute14 := p1_a66;
1139 ddp_cust_site_use_rec.global_attribute15 := p1_a67;
1140 ddp_cust_site_use_rec.global_attribute16 := p1_a68;
1141 ddp_cust_site_use_rec.global_attribute17 := p1_a69;
1142 ddp_cust_site_use_rec.global_attribute18 := p1_a70;
1143 ddp_cust_site_use_rec.global_attribute19 := p1_a71;
1144 ddp_cust_site_use_rec.global_attribute20 := p1_a72;
1145 ddp_cust_site_use_rec.global_attribute_category := p1_a73;
1146 ddp_cust_site_use_rec.primary_salesrep_id := rosetta_g_miss_num_map(p1_a74);
1147 ddp_cust_site_use_rec.finchrg_receivables_trx_id := rosetta_g_miss_num_map(p1_a75);
1148 ddp_cust_site_use_rec.dates_negative_tolerance := rosetta_g_miss_num_map(p1_a76);
1149 ddp_cust_site_use_rec.dates_positive_tolerance := rosetta_g_miss_num_map(p1_a77);
1150 ddp_cust_site_use_rec.date_type_preference := p1_a78;
1151 ddp_cust_site_use_rec.over_shipment_tolerance := rosetta_g_miss_num_map(p1_a79);
1152 ddp_cust_site_use_rec.under_shipment_tolerance := rosetta_g_miss_num_map(p1_a80);
1153 ddp_cust_site_use_rec.item_cross_ref_pref := p1_a81;
1154 ddp_cust_site_use_rec.over_return_tolerance := rosetta_g_miss_num_map(p1_a82);
1155 ddp_cust_site_use_rec.under_return_tolerance := rosetta_g_miss_num_map(p1_a83);
1156 ddp_cust_site_use_rec.ship_sets_include_lines_flag := p1_a84;
1157 ddp_cust_site_use_rec.arrivalsets_include_lines_flag := p1_a85;
1158 ddp_cust_site_use_rec.sched_date_push_flag := p1_a86;
1159 ddp_cust_site_use_rec.invoice_quantity_rule := p1_a87;
1160 ddp_cust_site_use_rec.pricing_event := p1_a88;
1161 ddp_cust_site_use_rec.gl_id_rec := rosetta_g_miss_num_map(p1_a89);
1162 ddp_cust_site_use_rec.gl_id_rev := rosetta_g_miss_num_map(p1_a90);
1163 ddp_cust_site_use_rec.gl_id_tax := rosetta_g_miss_num_map(p1_a91);
1164 ddp_cust_site_use_rec.gl_id_freight := rosetta_g_miss_num_map(p1_a92);
1165 ddp_cust_site_use_rec.gl_id_clearing := rosetta_g_miss_num_map(p1_a93);
1166 ddp_cust_site_use_rec.gl_id_unbilled := rosetta_g_miss_num_map(p1_a94);
1167 ddp_cust_site_use_rec.gl_id_unearned := rosetta_g_miss_num_map(p1_a95);
1168 ddp_cust_site_use_rec.gl_id_unpaid_rec := rosetta_g_miss_num_map(p1_a96);
1169 ddp_cust_site_use_rec.gl_id_remittance := rosetta_g_miss_num_map(p1_a97);
1170 ddp_cust_site_use_rec.gl_id_factor := rosetta_g_miss_num_map(p1_a98);
1171 ddp_cust_site_use_rec.tax_classification := p1_a99;
1172 ddp_cust_site_use_rec.created_by_module := p1_a100;
1173 ddp_cust_site_use_rec.application_id := rosetta_g_miss_num_map(p1_a101);
1174 ddp_cust_site_use_rec.org_id := rosetta_g_miss_num_map(p1_a102);
1175
1176
1177
1178
1179
1180 -- here's the delegated call to the old PL/SQL routine
1184 x_return_status,
1181 hz_cust_account_site_v2pub.update_cust_site_use(p_init_msg_list,
1182 ddp_cust_site_use_rec,
1183 p_object_version_number,
1185 x_msg_count,
1186 x_msg_data);
1187
1188 -- copy data back from the local OUT or IN-OUT args, if any
1189
1190
1191
1192
1193
1194 end;
1195
1196 procedure get_cust_site_use_rec_6(p_init_msg_list VARCHAR2
1197 , p_site_use_id NUMBER
1198 , p2_a0 out nocopy NUMBER
1199 , p2_a1 out nocopy NUMBER
1200 , p2_a2 out nocopy VARCHAR2
1201 , p2_a3 out nocopy VARCHAR2
1202 , p2_a4 out nocopy VARCHAR2
1203 , p2_a5 out nocopy VARCHAR2
1204 , p2_a6 out nocopy NUMBER
1205 , p2_a7 out nocopy NUMBER
1206 , p2_a8 out nocopy VARCHAR2
1207 , p2_a9 out nocopy VARCHAR2
1208 , p2_a10 out nocopy VARCHAR2
1209 , p2_a11 out nocopy NUMBER
1210 , p2_a12 out nocopy VARCHAR2
1211 , p2_a13 out nocopy VARCHAR2
1212 , p2_a14 out nocopy VARCHAR2
1213 , p2_a15 out nocopy VARCHAR2
1214 , p2_a16 out nocopy NUMBER
1215 , p2_a17 out nocopy NUMBER
1216 , p2_a18 out nocopy VARCHAR2
1217 , p2_a19 out nocopy NUMBER
1218 , p2_a20 out nocopy NUMBER
1219 , p2_a21 out nocopy VARCHAR2
1220 , p2_a22 out nocopy VARCHAR2
1221 , p2_a23 out nocopy VARCHAR2
1222 , p2_a24 out nocopy VARCHAR2
1223 , p2_a25 out nocopy VARCHAR2
1224 , p2_a26 out nocopy VARCHAR2
1225 , p2_a27 out nocopy VARCHAR2
1226 , p2_a28 out nocopy VARCHAR2
1227 , p2_a29 out nocopy VARCHAR2
1228 , p2_a30 out nocopy VARCHAR2
1229 , p2_a31 out nocopy VARCHAR2
1230 , p2_a32 out nocopy VARCHAR2
1231 , p2_a33 out nocopy NUMBER
1232 , p2_a34 out nocopy VARCHAR2
1233 , p2_a35 out nocopy VARCHAR2
1234 , p2_a36 out nocopy VARCHAR2
1235 , p2_a37 out nocopy VARCHAR2
1236 , p2_a38 out nocopy VARCHAR2
1237 , p2_a39 out nocopy VARCHAR2
1238 , p2_a40 out nocopy VARCHAR2
1239 , p2_a41 out nocopy VARCHAR2
1240 , p2_a42 out nocopy VARCHAR2
1241 , p2_a43 out nocopy VARCHAR2
1242 , p2_a44 out nocopy VARCHAR2
1243 , p2_a45 out nocopy VARCHAR2
1244 , p2_a46 out nocopy VARCHAR2
1245 , p2_a47 out nocopy VARCHAR2
1246 , p2_a48 out nocopy VARCHAR2
1247 , p2_a49 out nocopy VARCHAR2
1248 , p2_a50 out nocopy VARCHAR2
1249 , p2_a51 out nocopy VARCHAR2
1250 , p2_a52 out nocopy VARCHAR2
1251 , p2_a53 out nocopy VARCHAR2
1252 , p2_a54 out nocopy VARCHAR2
1253 , p2_a55 out nocopy VARCHAR2
1254 , p2_a56 out nocopy VARCHAR2
1255 , p2_a57 out nocopy VARCHAR2
1256 , p2_a58 out nocopy VARCHAR2
1257 , p2_a59 out nocopy VARCHAR2
1258 , p2_a60 out nocopy VARCHAR2
1259 , p2_a61 out nocopy VARCHAR2
1260 , p2_a62 out nocopy VARCHAR2
1261 , p2_a63 out nocopy VARCHAR2
1262 , p2_a64 out nocopy VARCHAR2
1263 , p2_a65 out nocopy VARCHAR2
1264 , p2_a66 out nocopy VARCHAR2
1265 , p2_a67 out nocopy VARCHAR2
1266 , p2_a68 out nocopy VARCHAR2
1267 , p2_a69 out nocopy VARCHAR2
1268 , p2_a70 out nocopy VARCHAR2
1269 , p2_a71 out nocopy VARCHAR2
1270 , p2_a72 out nocopy VARCHAR2
1271 , p2_a73 out nocopy VARCHAR2
1272 , p2_a74 out nocopy NUMBER
1273 , p2_a75 out nocopy NUMBER
1274 , p2_a76 out nocopy NUMBER
1275 , p2_a77 out nocopy NUMBER
1276 , p2_a78 out nocopy VARCHAR2
1277 , p2_a79 out nocopy NUMBER
1278 , p2_a80 out nocopy NUMBER
1279 , p2_a81 out nocopy VARCHAR2
1280 , p2_a82 out nocopy NUMBER
1281 , p2_a83 out nocopy NUMBER
1282 , p2_a84 out nocopy VARCHAR2
1283 , p2_a85 out nocopy VARCHAR2
1284 , p2_a86 out nocopy VARCHAR2
1285 , p2_a87 out nocopy VARCHAR2
1286 , p2_a88 out nocopy VARCHAR2
1287 , p2_a89 out nocopy NUMBER
1288 , p2_a90 out nocopy NUMBER
1289 , p2_a91 out nocopy NUMBER
1290 , p2_a92 out nocopy NUMBER
1291 , p2_a93 out nocopy NUMBER
1292 , p2_a94 out nocopy NUMBER
1293 , p2_a95 out nocopy NUMBER
1294 , p2_a96 out nocopy NUMBER
1295 , p2_a97 out nocopy NUMBER
1296 , p2_a98 out nocopy NUMBER
1297 , p2_a99 out nocopy VARCHAR2
1298 , p2_a100 out nocopy VARCHAR2
1299 , p2_a101 out nocopy NUMBER
1300 , p2_a102 out nocopy NUMBER
1301 , p3_a0 out nocopy NUMBER
1302 , p3_a1 out nocopy NUMBER
1303 , p3_a2 out nocopy VARCHAR2
1304 , p3_a3 out nocopy NUMBER
1305 , p3_a4 out nocopy NUMBER
1306 , p3_a5 out nocopy VARCHAR2
1307 , p3_a6 out nocopy DATE
1308 , p3_a7 out nocopy NUMBER
1309 , p3_a8 out nocopy VARCHAR2
1310 , p3_a9 out nocopy VARCHAR2
1311 , p3_a10 out nocopy VARCHAR2
1312 , p3_a11 out nocopy VARCHAR2
1313 , p3_a12 out nocopy VARCHAR2
1314 , p3_a13 out nocopy VARCHAR2
1315 , p3_a14 out nocopy NUMBER
1316 , p3_a15 out nocopy NUMBER
1317 , p3_a16 out nocopy VARCHAR2
1318 , p3_a17 out nocopy VARCHAR2
1319 , p3_a18 out nocopy NUMBER
1320 , p3_a19 out nocopy VARCHAR2
1321 , p3_a20 out nocopy NUMBER
1322 , p3_a21 out nocopy NUMBER
1323 , p3_a22 out nocopy NUMBER
1324 , p3_a23 out nocopy NUMBER
1325 , p3_a24 out nocopy NUMBER
1326 , p3_a25 out nocopy VARCHAR2
1327 , p3_a26 out nocopy NUMBER
1328 , p3_a27 out nocopy NUMBER
1329 , p3_a28 out nocopy VARCHAR2
1330 , p3_a29 out nocopy VARCHAR2
1334 , p3_a33 out nocopy VARCHAR2
1331 , p3_a30 out nocopy VARCHAR2
1332 , p3_a31 out nocopy VARCHAR2
1333 , p3_a32 out nocopy VARCHAR2
1335 , p3_a34 out nocopy VARCHAR2
1336 , p3_a35 out nocopy VARCHAR2
1337 , p3_a36 out nocopy VARCHAR2
1338 , p3_a37 out nocopy VARCHAR2
1339 , p3_a38 out nocopy VARCHAR2
1340 , p3_a39 out nocopy VARCHAR2
1341 , p3_a40 out nocopy VARCHAR2
1342 , p3_a41 out nocopy VARCHAR2
1343 , p3_a42 out nocopy VARCHAR2
1344 , p3_a43 out nocopy VARCHAR2
1345 , p3_a44 out nocopy VARCHAR2
1346 , p3_a45 out nocopy VARCHAR2
1347 , p3_a46 out nocopy VARCHAR2
1348 , p3_a47 out nocopy NUMBER
1349 , p3_a48 out nocopy NUMBER
1350 , p3_a49 out nocopy VARCHAR2
1351 , p3_a50 out nocopy VARCHAR2
1352 , p3_a51 out nocopy VARCHAR2
1353 , p3_a52 out nocopy VARCHAR2
1354 , p3_a53 out nocopy VARCHAR2
1355 , p3_a54 out nocopy VARCHAR2
1356 , p3_a55 out nocopy VARCHAR2
1357 , p3_a56 out nocopy VARCHAR2
1358 , p3_a57 out nocopy VARCHAR2
1359 , p3_a58 out nocopy VARCHAR2
1360 , p3_a59 out nocopy VARCHAR2
1361 , p3_a60 out nocopy VARCHAR2
1362 , p3_a61 out nocopy VARCHAR2
1363 , p3_a62 out nocopy VARCHAR2
1364 , p3_a63 out nocopy VARCHAR2
1365 , p3_a64 out nocopy VARCHAR2
1366 , p3_a65 out nocopy VARCHAR2
1367 , p3_a66 out nocopy VARCHAR2
1368 , p3_a67 out nocopy VARCHAR2
1369 , p3_a68 out nocopy VARCHAR2
1370 , p3_a69 out nocopy VARCHAR2
1371 , p3_a70 out nocopy VARCHAR2
1372 , p3_a71 out nocopy VARCHAR2
1373 , p3_a72 out nocopy VARCHAR2
1374 , p3_a73 out nocopy VARCHAR2
1375 , p3_a74 out nocopy VARCHAR2
1376 , p3_a75 out nocopy VARCHAR2
1377 , p3_a76 out nocopy VARCHAR2
1378 , p3_a77 out nocopy VARCHAR2
1379 , p3_a78 out nocopy VARCHAR2
1380 , p3_a79 out nocopy VARCHAR2
1381 , p3_a80 out nocopy VARCHAR2
1382 , p3_a81 out nocopy VARCHAR2
1383 , p3_a82 out nocopy VARCHAR2
1384 , p3_a83 out nocopy VARCHAR2
1385 , p3_a84 out nocopy VARCHAR2
1386 , p3_a85 out nocopy VARCHAR2
1387 , p3_a86 out nocopy VARCHAR2
1388 , p3_a87 out nocopy VARCHAR2
1389 , p3_a88 out nocopy NUMBER
1390 , p3_a89 out nocopy VARCHAR2
1391 , p3_a90 out nocopy VARCHAR2
1392 , p3_a91 out nocopy NUMBER
1393 , p3_a92 out nocopy VARCHAR2
1394 , p3_a93 out nocopy DATE
1395 , p3_a94 out nocopy NUMBER
1396 , p3_a95 out nocopy VARCHAR2
1397 , p3_a96 out nocopy VARCHAR2
1398 , p3_a97 out nocopy VARCHAR2
1399 , p3_a98 out nocopy VARCHAR2
1400 , p3_a99 out nocopy VARCHAR2
1401 , p3_a100 out nocopy VARCHAR2
1402 , p3_a101 out nocopy NUMBER
1403 , p3_a102 out nocopy VARCHAR2
1404 , p3_a103 out nocopy VARCHAR2
1405 , p3_a104 out nocopy NUMBER
1406 , p3_a105 out nocopy VARCHAR2
1407 , p3_a106 out nocopy DATE
1408 , x_return_status out nocopy VARCHAR2
1409 , x_msg_count out nocopy NUMBER
1410 , x_msg_data out nocopy VARCHAR2
1411 )
1412 as
1413 ddx_cust_site_use_rec hz_cust_account_site_v2pub.cust_site_use_rec_type;
1414 ddx_customer_profile_rec hz_customer_profile_v2pub.customer_profile_rec_type;
1415 ddindx binary_integer; indx binary_integer;
1416 begin
1417
1418 -- copy data to the local IN or IN-OUT args, if any
1419
1420
1421
1422
1423
1424
1425
1426 -- here's the delegated call to the old PL/SQL routine
1427 hz_cust_account_site_v2pub.get_cust_site_use_rec(p_init_msg_list,
1428 p_site_use_id,
1429 ddx_cust_site_use_rec,
1430 ddx_customer_profile_rec,
1431 x_return_status,
1432 x_msg_count,
1433 x_msg_data);
1434
1435 -- copy data back from the local OUT or IN-OUT args, if any
1436
1437
1438 p2_a0 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.site_use_id);
1439 p2_a1 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.cust_acct_site_id);
1440 p2_a2 := ddx_cust_site_use_rec.site_use_code;
1441 p2_a3 := ddx_cust_site_use_rec.primary_flag;
1442 p2_a4 := ddx_cust_site_use_rec.status;
1443 p2_a5 := ddx_cust_site_use_rec.location;
1444 p2_a6 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.contact_id);
1445 p2_a7 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.bill_to_site_use_id);
1446 p2_a8 := ddx_cust_site_use_rec.orig_system_reference;
1447 p2_a9 := ddx_cust_site_use_rec.orig_system;
1448 p2_a10 := ddx_cust_site_use_rec.sic_code;
1449 p2_a11 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.payment_term_id);
1450 p2_a12 := ddx_cust_site_use_rec.gsa_indicator;
1451 p2_a13 := ddx_cust_site_use_rec.ship_partial;
1452 p2_a14 := ddx_cust_site_use_rec.ship_via;
1453 p2_a15 := ddx_cust_site_use_rec.fob_point;
1454 p2_a16 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.order_type_id);
1455 p2_a17 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.price_list_id);
1456 p2_a18 := ddx_cust_site_use_rec.freight_term;
1457 p2_a19 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.warehouse_id);
1458 p2_a20 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.territory_id);
1459 p2_a21 := ddx_cust_site_use_rec.attribute_category;
1460 p2_a22 := ddx_cust_site_use_rec.attribute1;
1461 p2_a23 := ddx_cust_site_use_rec.attribute2;
1462 p2_a24 := ddx_cust_site_use_rec.attribute3;
1463 p2_a25 := ddx_cust_site_use_rec.attribute4;
1467 p2_a29 := ddx_cust_site_use_rec.attribute8;
1464 p2_a26 := ddx_cust_site_use_rec.attribute5;
1465 p2_a27 := ddx_cust_site_use_rec.attribute6;
1466 p2_a28 := ddx_cust_site_use_rec.attribute7;
1468 p2_a30 := ddx_cust_site_use_rec.attribute9;
1469 p2_a31 := ddx_cust_site_use_rec.attribute10;
1470 p2_a32 := ddx_cust_site_use_rec.tax_reference;
1471 p2_a33 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.sort_priority);
1472 p2_a34 := ddx_cust_site_use_rec.tax_code;
1473 p2_a35 := ddx_cust_site_use_rec.attribute11;
1474 p2_a36 := ddx_cust_site_use_rec.attribute12;
1475 p2_a37 := ddx_cust_site_use_rec.attribute13;
1476 p2_a38 := ddx_cust_site_use_rec.attribute14;
1477 p2_a39 := ddx_cust_site_use_rec.attribute15;
1478 p2_a40 := ddx_cust_site_use_rec.attribute16;
1479 p2_a41 := ddx_cust_site_use_rec.attribute17;
1480 p2_a42 := ddx_cust_site_use_rec.attribute18;
1481 p2_a43 := ddx_cust_site_use_rec.attribute19;
1482 p2_a44 := ddx_cust_site_use_rec.attribute20;
1483 p2_a45 := ddx_cust_site_use_rec.attribute21;
1484 p2_a46 := ddx_cust_site_use_rec.attribute22;
1485 p2_a47 := ddx_cust_site_use_rec.attribute23;
1486 p2_a48 := ddx_cust_site_use_rec.attribute24;
1487 p2_a49 := ddx_cust_site_use_rec.attribute25;
1488 p2_a50 := ddx_cust_site_use_rec.demand_class_code;
1489 p2_a51 := ddx_cust_site_use_rec.tax_header_level_flag;
1490 p2_a52 := ddx_cust_site_use_rec.tax_rounding_rule;
1491 p2_a53 := ddx_cust_site_use_rec.global_attribute1;
1492 p2_a54 := ddx_cust_site_use_rec.global_attribute2;
1493 p2_a55 := ddx_cust_site_use_rec.global_attribute3;
1494 p2_a56 := ddx_cust_site_use_rec.global_attribute4;
1495 p2_a57 := ddx_cust_site_use_rec.global_attribute5;
1496 p2_a58 := ddx_cust_site_use_rec.global_attribute6;
1497 p2_a59 := ddx_cust_site_use_rec.global_attribute7;
1498 p2_a60 := ddx_cust_site_use_rec.global_attribute8;
1499 p2_a61 := ddx_cust_site_use_rec.global_attribute9;
1500 p2_a62 := ddx_cust_site_use_rec.global_attribute10;
1501 p2_a63 := ddx_cust_site_use_rec.global_attribute11;
1502 p2_a64 := ddx_cust_site_use_rec.global_attribute12;
1503 p2_a65 := ddx_cust_site_use_rec.global_attribute13;
1504 p2_a66 := ddx_cust_site_use_rec.global_attribute14;
1505 p2_a67 := ddx_cust_site_use_rec.global_attribute15;
1506 p2_a68 := ddx_cust_site_use_rec.global_attribute16;
1507 p2_a69 := ddx_cust_site_use_rec.global_attribute17;
1508 p2_a70 := ddx_cust_site_use_rec.global_attribute18;
1509 p2_a71 := ddx_cust_site_use_rec.global_attribute19;
1510 p2_a72 := ddx_cust_site_use_rec.global_attribute20;
1511 p2_a73 := ddx_cust_site_use_rec.global_attribute_category;
1512 p2_a74 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.primary_salesrep_id);
1513 p2_a75 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.finchrg_receivables_trx_id);
1514 p2_a76 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.dates_negative_tolerance);
1515 p2_a77 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.dates_positive_tolerance);
1516 p2_a78 := ddx_cust_site_use_rec.date_type_preference;
1517 p2_a79 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.over_shipment_tolerance);
1518 p2_a80 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.under_shipment_tolerance);
1519 p2_a81 := ddx_cust_site_use_rec.item_cross_ref_pref;
1520 p2_a82 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.over_return_tolerance);
1521 p2_a83 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.under_return_tolerance);
1522 p2_a84 := ddx_cust_site_use_rec.ship_sets_include_lines_flag;
1523 p2_a85 := ddx_cust_site_use_rec.arrivalsets_include_lines_flag;
1524 p2_a86 := ddx_cust_site_use_rec.sched_date_push_flag;
1525 p2_a87 := ddx_cust_site_use_rec.invoice_quantity_rule;
1526 p2_a88 := ddx_cust_site_use_rec.pricing_event;
1527 p2_a89 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_rec);
1528 p2_a90 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_rev);
1529 p2_a91 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_tax);
1530 p2_a92 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_freight);
1531 p2_a93 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_clearing);
1532 p2_a94 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_unbilled);
1533 p2_a95 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_unearned);
1534 p2_a96 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_unpaid_rec);
1535 p2_a97 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_remittance);
1536 p2_a98 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.gl_id_factor);
1537 p2_a99 := ddx_cust_site_use_rec.tax_classification;
1538 p2_a100 := ddx_cust_site_use_rec.created_by_module;
1539 p2_a101 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.application_id);
1540 p2_a102 := rosetta_g_miss_num_map(ddx_cust_site_use_rec.org_id);
1541
1542 p3_a0 := rosetta_g_miss_num_map(ddx_customer_profile_rec.cust_account_profile_id);
1543 p3_a1 := rosetta_g_miss_num_map(ddx_customer_profile_rec.cust_account_id);
1544 p3_a2 := ddx_customer_profile_rec.status;
1545 p3_a3 := rosetta_g_miss_num_map(ddx_customer_profile_rec.collector_id);
1546 p3_a4 := rosetta_g_miss_num_map(ddx_customer_profile_rec.credit_analyst_id);
1547 p3_a5 := ddx_customer_profile_rec.credit_checking;
1548 p3_a6 := ddx_customer_profile_rec.next_credit_review_date;
1549 p3_a7 := rosetta_g_miss_num_map(ddx_customer_profile_rec.tolerance);
1550 p3_a8 := ddx_customer_profile_rec.discount_terms;
1551 p3_a9 := ddx_customer_profile_rec.dunning_letters;
1552 p3_a10 := ddx_customer_profile_rec.interest_charges;
1553 p3_a11 := ddx_customer_profile_rec.send_statements;
1557 p3_a15 := rosetta_g_miss_num_map(ddx_customer_profile_rec.site_use_id);
1554 p3_a12 := ddx_customer_profile_rec.credit_balance_statements;
1555 p3_a13 := ddx_customer_profile_rec.credit_hold;
1556 p3_a14 := rosetta_g_miss_num_map(ddx_customer_profile_rec.profile_class_id);
1558 p3_a16 := ddx_customer_profile_rec.credit_rating;
1559 p3_a17 := ddx_customer_profile_rec.risk_code;
1560 p3_a18 := rosetta_g_miss_num_map(ddx_customer_profile_rec.standard_terms);
1561 p3_a19 := ddx_customer_profile_rec.override_terms;
1562 p3_a20 := rosetta_g_miss_num_map(ddx_customer_profile_rec.dunning_letter_set_id);
1563 p3_a21 := rosetta_g_miss_num_map(ddx_customer_profile_rec.interest_period_days);
1564 p3_a22 := rosetta_g_miss_num_map(ddx_customer_profile_rec.payment_grace_days);
1565 p3_a23 := rosetta_g_miss_num_map(ddx_customer_profile_rec.discount_grace_days);
1566 p3_a24 := rosetta_g_miss_num_map(ddx_customer_profile_rec.statement_cycle_id);
1567 p3_a25 := ddx_customer_profile_rec.account_status;
1568 p3_a26 := rosetta_g_miss_num_map(ddx_customer_profile_rec.percent_collectable);
1569 p3_a27 := rosetta_g_miss_num_map(ddx_customer_profile_rec.autocash_hierarchy_id);
1570 p3_a28 := ddx_customer_profile_rec.attribute_category;
1571 p3_a29 := ddx_customer_profile_rec.attribute1;
1572 p3_a30 := ddx_customer_profile_rec.attribute2;
1573 p3_a31 := ddx_customer_profile_rec.attribute3;
1574 p3_a32 := ddx_customer_profile_rec.attribute4;
1575 p3_a33 := ddx_customer_profile_rec.attribute5;
1576 p3_a34 := ddx_customer_profile_rec.attribute6;
1577 p3_a35 := ddx_customer_profile_rec.attribute7;
1578 p3_a36 := ddx_customer_profile_rec.attribute8;
1579 p3_a37 := ddx_customer_profile_rec.attribute9;
1580 p3_a38 := ddx_customer_profile_rec.attribute10;
1581 p3_a39 := ddx_customer_profile_rec.attribute11;
1582 p3_a40 := ddx_customer_profile_rec.attribute12;
1583 p3_a41 := ddx_customer_profile_rec.attribute13;
1584 p3_a42 := ddx_customer_profile_rec.attribute14;
1585 p3_a43 := ddx_customer_profile_rec.attribute15;
1586 p3_a44 := ddx_customer_profile_rec.auto_rec_incl_disputed_flag;
1587 p3_a45 := ddx_customer_profile_rec.tax_printing_option;
1588 p3_a46 := ddx_customer_profile_rec.charge_on_finance_charge_flag;
1589 p3_a47 := rosetta_g_miss_num_map(ddx_customer_profile_rec.grouping_rule_id);
1590 p3_a48 := rosetta_g_miss_num_map(ddx_customer_profile_rec.clearing_days);
1591 p3_a49 := ddx_customer_profile_rec.jgzz_attribute_category;
1592 p3_a50 := ddx_customer_profile_rec.jgzz_attribute1;
1593 p3_a51 := ddx_customer_profile_rec.jgzz_attribute2;
1594 p3_a52 := ddx_customer_profile_rec.jgzz_attribute3;
1595 p3_a53 := ddx_customer_profile_rec.jgzz_attribute4;
1596 p3_a54 := ddx_customer_profile_rec.jgzz_attribute5;
1597 p3_a55 := ddx_customer_profile_rec.jgzz_attribute6;
1598 p3_a56 := ddx_customer_profile_rec.jgzz_attribute7;
1599 p3_a57 := ddx_customer_profile_rec.jgzz_attribute8;
1600 p3_a58 := ddx_customer_profile_rec.jgzz_attribute9;
1601 p3_a59 := ddx_customer_profile_rec.jgzz_attribute10;
1602 p3_a60 := ddx_customer_profile_rec.jgzz_attribute11;
1603 p3_a61 := ddx_customer_profile_rec.jgzz_attribute12;
1604 p3_a62 := ddx_customer_profile_rec.jgzz_attribute13;
1605 p3_a63 := ddx_customer_profile_rec.jgzz_attribute14;
1606 p3_a64 := ddx_customer_profile_rec.jgzz_attribute15;
1607 p3_a65 := ddx_customer_profile_rec.global_attribute1;
1608 p3_a66 := ddx_customer_profile_rec.global_attribute2;
1609 p3_a67 := ddx_customer_profile_rec.global_attribute3;
1610 p3_a68 := ddx_customer_profile_rec.global_attribute4;
1611 p3_a69 := ddx_customer_profile_rec.global_attribute5;
1612 p3_a70 := ddx_customer_profile_rec.global_attribute6;
1613 p3_a71 := ddx_customer_profile_rec.global_attribute7;
1614 p3_a72 := ddx_customer_profile_rec.global_attribute8;
1615 p3_a73 := ddx_customer_profile_rec.global_attribute9;
1616 p3_a74 := ddx_customer_profile_rec.global_attribute10;
1617 p3_a75 := ddx_customer_profile_rec.global_attribute11;
1618 p3_a76 := ddx_customer_profile_rec.global_attribute12;
1619 p3_a77 := ddx_customer_profile_rec.global_attribute13;
1620 p3_a78 := ddx_customer_profile_rec.global_attribute14;
1621 p3_a79 := ddx_customer_profile_rec.global_attribute15;
1622 p3_a80 := ddx_customer_profile_rec.global_attribute16;
1623 p3_a81 := ddx_customer_profile_rec.global_attribute17;
1624 p3_a82 := ddx_customer_profile_rec.global_attribute18;
1625 p3_a83 := ddx_customer_profile_rec.global_attribute19;
1626 p3_a84 := ddx_customer_profile_rec.global_attribute20;
1627 p3_a85 := ddx_customer_profile_rec.global_attribute_category;
1628 p3_a86 := ddx_customer_profile_rec.cons_inv_flag;
1629 p3_a87 := ddx_customer_profile_rec.cons_inv_type;
1630 p3_a88 := rosetta_g_miss_num_map(ddx_customer_profile_rec.autocash_hierarchy_id_for_adr);
1631 p3_a89 := ddx_customer_profile_rec.lockbox_matching_option;
1632 p3_a90 := ddx_customer_profile_rec.created_by_module;
1633 p3_a91 := rosetta_g_miss_num_map(ddx_customer_profile_rec.application_id);
1634 p3_a92 := ddx_customer_profile_rec.review_cycle;
1635 p3_a93 := ddx_customer_profile_rec.last_credit_review_date;
1636 p3_a94 := rosetta_g_miss_num_map(ddx_customer_profile_rec.party_id);
1637 p3_a95 := ddx_customer_profile_rec.credit_classification;
1638 p3_a96 := ddx_customer_profile_rec.cons_bill_level;
1639 p3_a97 := ddx_customer_profile_rec.late_charge_calculation_trx;
1640 p3_a98 := ddx_customer_profile_rec.credit_items_flag;
1641 p3_a99 := ddx_customer_profile_rec.disputed_transactions_flag;
1642 p3_a100 := ddx_customer_profile_rec.late_charge_type;
1646 p3_a104 := rosetta_g_miss_num_map(ddx_customer_profile_rec.message_text_id);
1643 p3_a101 := rosetta_g_miss_num_map(ddx_customer_profile_rec.late_charge_term_id);
1644 p3_a102 := ddx_customer_profile_rec.interest_calculation_period;
1645 p3_a103 := ddx_customer_profile_rec.hold_charged_invoices_flag;
1647 p3_a105 := ddx_customer_profile_rec.multiple_interest_rates_flag;
1648 p3_a106 := ddx_customer_profile_rec.charge_begin_date;
1649
1650
1651
1652 end;
1653
1654 end hz_cust_account_site_v2pub_jw;