[Home] [Help]
PACKAGE BODY: APPS.OKL_CAT_PVT_W
Source
1 package body okl_cat_pvt_w as
2 /* $Header: OKLECATB.pls 120.2 2005/10/30 03:19:19 appldev 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 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p2(t out nocopy okl_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_VARCHAR2_TABLE_200
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_VARCHAR2_TABLE_2000
26 , a4 JTF_DATE_TABLE
27 , a5 JTF_DATE_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_VARCHAR2_TABLE_100
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_VARCHAR2_TABLE_500
37 , a15 JTF_VARCHAR2_TABLE_500
38 , a16 JTF_VARCHAR2_TABLE_500
39 , a17 JTF_VARCHAR2_TABLE_500
40 , a18 JTF_VARCHAR2_TABLE_500
41 , a19 JTF_VARCHAR2_TABLE_500
42 , a20 JTF_VARCHAR2_TABLE_500
43 , a21 JTF_VARCHAR2_TABLE_500
44 , a22 JTF_VARCHAR2_TABLE_500
45 , a23 JTF_VARCHAR2_TABLE_500
46 , a24 JTF_VARCHAR2_TABLE_500
47 , a25 JTF_VARCHAR2_TABLE_500
48 , a26 JTF_VARCHAR2_TABLE_500
49 , a27 JTF_VARCHAR2_TABLE_500
50 , a28 JTF_VARCHAR2_TABLE_500
51 , a29 JTF_NUMBER_TABLE
52 , a30 JTF_NUMBER_TABLE
53 , a31 JTF_DATE_TABLE
54 , a32 JTF_NUMBER_TABLE
55 , a33 JTF_DATE_TABLE
56 , a34 JTF_NUMBER_TABLE
57 , a35 JTF_NUMBER_TABLE
58 , a36 JTF_NUMBER_TABLE
59 ) as
60 ddindx binary_integer; indx binary_integer;
61 begin
62 if a0 is not null and a0.count > 0 then
63 if a0.count > 0 then
64 indx := a0.first;
65 ddindx := 1;
66 while true loop
67 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
68 t(ddindx).name := a1(indx);
69 t(ddindx).object_version_number := rosetta_g_miss_num_map(a2(indx));
70 t(ddindx).description := a3(indx);
71 t(ddindx).start_date := rosetta_g_miss_date_in_map(a4(indx));
72 t(ddindx).end_date := rosetta_g_miss_date_in_map(a5(indx));
73 t(ddindx).amount_tolerance_percent := rosetta_g_miss_num_map(a6(indx));
74 t(ddindx).days_past_quote_valid_toleranc := rosetta_g_miss_num_map(a7(indx));
75 t(ddindx).months_to_bill_ahead := rosetta_g_miss_num_map(a8(indx));
76 t(ddindx).under_payment_allocation_code := a9(indx);
77 t(ddindx).over_payment_allocation_code := a10(indx);
78 t(ddindx).receipt_msmtch_allocation_code := a11(indx);
79 t(ddindx).default_rule := a12(indx);
80 t(ddindx).attribute_category := a13(indx);
81 t(ddindx).attribute1 := a14(indx);
82 t(ddindx).attribute2 := a15(indx);
83 t(ddindx).attribute3 := a16(indx);
84 t(ddindx).attribute4 := a17(indx);
85 t(ddindx).attribute5 := a18(indx);
86 t(ddindx).attribute6 := a19(indx);
87 t(ddindx).attribute7 := a20(indx);
88 t(ddindx).attribute8 := a21(indx);
89 t(ddindx).attribute9 := a22(indx);
90 t(ddindx).attribute10 := a23(indx);
91 t(ddindx).attribute11 := a24(indx);
92 t(ddindx).attribute12 := a25(indx);
93 t(ddindx).attribute13 := a26(indx);
94 t(ddindx).attribute14 := a27(indx);
95 t(ddindx).attribute15 := a28(indx);
96 t(ddindx).org_id := rosetta_g_miss_num_map(a29(indx));
97 t(ddindx).created_by := rosetta_g_miss_num_map(a30(indx));
98 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a31(indx));
99 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a32(indx));
100 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a33(indx));
101 t(ddindx).last_update_login := rosetta_g_miss_num_map(a34(indx));
102 t(ddindx).cau_id := rosetta_g_miss_num_map(a35(indx));
103 t(ddindx).num_days_hold_adv_pay := rosetta_g_miss_num_map(a36(indx));
104 ddindx := ddindx+1;
105 if a0.last =indx
106 then exit;
107 end if;
108 indx := a0.next(indx);
109 end loop;
110 end if;
111 end if;
112 end rosetta_table_copy_in_p2;
113 procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114 , a1 out nocopy JTF_VARCHAR2_TABLE_200
115 , a2 out nocopy JTF_NUMBER_TABLE
116 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
117 , a4 out nocopy JTF_DATE_TABLE
118 , a5 out nocopy JTF_DATE_TABLE
119 , a6 out nocopy JTF_NUMBER_TABLE
120 , a7 out nocopy JTF_NUMBER_TABLE
121 , a8 out nocopy JTF_NUMBER_TABLE
122 , a9 out nocopy JTF_VARCHAR2_TABLE_100
123 , a10 out nocopy JTF_VARCHAR2_TABLE_100
124 , a11 out nocopy JTF_VARCHAR2_TABLE_100
125 , a12 out nocopy JTF_VARCHAR2_TABLE_100
126 , a13 out nocopy JTF_VARCHAR2_TABLE_100
127 , a14 out nocopy JTF_VARCHAR2_TABLE_500
128 , a15 out nocopy JTF_VARCHAR2_TABLE_500
129 , a16 out nocopy JTF_VARCHAR2_TABLE_500
130 , a17 out nocopy JTF_VARCHAR2_TABLE_500
131 , a18 out nocopy JTF_VARCHAR2_TABLE_500
132 , a19 out nocopy JTF_VARCHAR2_TABLE_500
133 , a20 out nocopy JTF_VARCHAR2_TABLE_500
134 , a21 out nocopy JTF_VARCHAR2_TABLE_500
135 , a22 out nocopy JTF_VARCHAR2_TABLE_500
136 , a23 out nocopy JTF_VARCHAR2_TABLE_500
137 , a24 out nocopy JTF_VARCHAR2_TABLE_500
138 , a25 out nocopy JTF_VARCHAR2_TABLE_500
139 , a26 out nocopy JTF_VARCHAR2_TABLE_500
140 , a27 out nocopy JTF_VARCHAR2_TABLE_500
141 , a28 out nocopy JTF_VARCHAR2_TABLE_500
142 , a29 out nocopy JTF_NUMBER_TABLE
143 , a30 out nocopy JTF_NUMBER_TABLE
144 , a31 out nocopy JTF_DATE_TABLE
145 , a32 out nocopy JTF_NUMBER_TABLE
146 , a33 out nocopy JTF_DATE_TABLE
147 , a34 out nocopy JTF_NUMBER_TABLE
148 , a35 out nocopy JTF_NUMBER_TABLE
149 , a36 out nocopy JTF_NUMBER_TABLE
150 ) as
151 ddindx binary_integer; indx binary_integer;
152 begin
153 if t is null or t.count = 0 then
154 a0 := JTF_NUMBER_TABLE();
155 a1 := JTF_VARCHAR2_TABLE_200();
156 a2 := JTF_NUMBER_TABLE();
157 a3 := JTF_VARCHAR2_TABLE_2000();
158 a4 := JTF_DATE_TABLE();
159 a5 := JTF_DATE_TABLE();
160 a6 := JTF_NUMBER_TABLE();
161 a7 := JTF_NUMBER_TABLE();
162 a8 := JTF_NUMBER_TABLE();
163 a9 := JTF_VARCHAR2_TABLE_100();
164 a10 := JTF_VARCHAR2_TABLE_100();
165 a11 := JTF_VARCHAR2_TABLE_100();
166 a12 := JTF_VARCHAR2_TABLE_100();
167 a13 := JTF_VARCHAR2_TABLE_100();
168 a14 := JTF_VARCHAR2_TABLE_500();
169 a15 := JTF_VARCHAR2_TABLE_500();
170 a16 := JTF_VARCHAR2_TABLE_500();
171 a17 := JTF_VARCHAR2_TABLE_500();
172 a18 := JTF_VARCHAR2_TABLE_500();
173 a19 := JTF_VARCHAR2_TABLE_500();
174 a20 := JTF_VARCHAR2_TABLE_500();
175 a21 := JTF_VARCHAR2_TABLE_500();
176 a22 := JTF_VARCHAR2_TABLE_500();
177 a23 := JTF_VARCHAR2_TABLE_500();
178 a24 := JTF_VARCHAR2_TABLE_500();
179 a25 := JTF_VARCHAR2_TABLE_500();
180 a26 := JTF_VARCHAR2_TABLE_500();
181 a27 := JTF_VARCHAR2_TABLE_500();
182 a28 := JTF_VARCHAR2_TABLE_500();
183 a29 := JTF_NUMBER_TABLE();
184 a30 := JTF_NUMBER_TABLE();
185 a31 := JTF_DATE_TABLE();
186 a32 := JTF_NUMBER_TABLE();
187 a33 := JTF_DATE_TABLE();
188 a34 := JTF_NUMBER_TABLE();
189 a35 := JTF_NUMBER_TABLE();
190 a36 := JTF_NUMBER_TABLE();
191 else
192 a0 := JTF_NUMBER_TABLE();
193 a1 := JTF_VARCHAR2_TABLE_200();
194 a2 := JTF_NUMBER_TABLE();
195 a3 := JTF_VARCHAR2_TABLE_2000();
196 a4 := JTF_DATE_TABLE();
197 a5 := JTF_DATE_TABLE();
198 a6 := JTF_NUMBER_TABLE();
199 a7 := JTF_NUMBER_TABLE();
200 a8 := JTF_NUMBER_TABLE();
201 a9 := JTF_VARCHAR2_TABLE_100();
202 a10 := JTF_VARCHAR2_TABLE_100();
203 a11 := JTF_VARCHAR2_TABLE_100();
204 a12 := JTF_VARCHAR2_TABLE_100();
205 a13 := JTF_VARCHAR2_TABLE_100();
206 a14 := JTF_VARCHAR2_TABLE_500();
207 a15 := JTF_VARCHAR2_TABLE_500();
208 a16 := JTF_VARCHAR2_TABLE_500();
209 a17 := JTF_VARCHAR2_TABLE_500();
210 a18 := JTF_VARCHAR2_TABLE_500();
211 a19 := JTF_VARCHAR2_TABLE_500();
212 a20 := JTF_VARCHAR2_TABLE_500();
213 a21 := JTF_VARCHAR2_TABLE_500();
214 a22 := JTF_VARCHAR2_TABLE_500();
215 a23 := JTF_VARCHAR2_TABLE_500();
216 a24 := JTF_VARCHAR2_TABLE_500();
217 a25 := JTF_VARCHAR2_TABLE_500();
218 a26 := JTF_VARCHAR2_TABLE_500();
219 a27 := JTF_VARCHAR2_TABLE_500();
220 a28 := JTF_VARCHAR2_TABLE_500();
221 a29 := JTF_NUMBER_TABLE();
222 a30 := JTF_NUMBER_TABLE();
223 a31 := JTF_DATE_TABLE();
224 a32 := JTF_NUMBER_TABLE();
225 a33 := JTF_DATE_TABLE();
226 a34 := JTF_NUMBER_TABLE();
227 a35 := JTF_NUMBER_TABLE();
228 a36 := JTF_NUMBER_TABLE();
229 if t.count > 0 then
230 a0.extend(t.count);
231 a1.extend(t.count);
232 a2.extend(t.count);
233 a3.extend(t.count);
234 a4.extend(t.count);
235 a5.extend(t.count);
236 a6.extend(t.count);
237 a7.extend(t.count);
238 a8.extend(t.count);
239 a9.extend(t.count);
240 a10.extend(t.count);
241 a11.extend(t.count);
242 a12.extend(t.count);
243 a13.extend(t.count);
244 a14.extend(t.count);
245 a15.extend(t.count);
246 a16.extend(t.count);
247 a17.extend(t.count);
248 a18.extend(t.count);
249 a19.extend(t.count);
250 a20.extend(t.count);
251 a21.extend(t.count);
252 a22.extend(t.count);
253 a23.extend(t.count);
254 a24.extend(t.count);
255 a25.extend(t.count);
256 a26.extend(t.count);
257 a27.extend(t.count);
258 a28.extend(t.count);
259 a29.extend(t.count);
260 a30.extend(t.count);
261 a31.extend(t.count);
262 a32.extend(t.count);
263 a33.extend(t.count);
264 a34.extend(t.count);
265 a35.extend(t.count);
266 a36.extend(t.count);
267 ddindx := t.first;
268 indx := 1;
269 while true loop
270 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
271 a1(indx) := t(ddindx).name;
272 a2(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
273 a3(indx) := t(ddindx).description;
274 a4(indx) := t(ddindx).start_date;
275 a5(indx) := t(ddindx).end_date;
276 a6(indx) := rosetta_g_miss_num_map(t(ddindx).amount_tolerance_percent);
277 a7(indx) := rosetta_g_miss_num_map(t(ddindx).days_past_quote_valid_toleranc);
278 a8(indx) := rosetta_g_miss_num_map(t(ddindx).months_to_bill_ahead);
279 a9(indx) := t(ddindx).under_payment_allocation_code;
280 a10(indx) := t(ddindx).over_payment_allocation_code;
281 a11(indx) := t(ddindx).receipt_msmtch_allocation_code;
282 a12(indx) := t(ddindx).default_rule;
283 a13(indx) := t(ddindx).attribute_category;
284 a14(indx) := t(ddindx).attribute1;
285 a15(indx) := t(ddindx).attribute2;
286 a16(indx) := t(ddindx).attribute3;
287 a17(indx) := t(ddindx).attribute4;
288 a18(indx) := t(ddindx).attribute5;
289 a19(indx) := t(ddindx).attribute6;
290 a20(indx) := t(ddindx).attribute7;
291 a21(indx) := t(ddindx).attribute8;
292 a22(indx) := t(ddindx).attribute9;
293 a23(indx) := t(ddindx).attribute10;
294 a24(indx) := t(ddindx).attribute11;
295 a25(indx) := t(ddindx).attribute12;
296 a26(indx) := t(ddindx).attribute13;
297 a27(indx) := t(ddindx).attribute14;
298 a28(indx) := t(ddindx).attribute15;
299 a29(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
300 a30(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
301 a31(indx) := t(ddindx).creation_date;
302 a32(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
303 a33(indx) := t(ddindx).last_update_date;
304 a34(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
305 a35(indx) := rosetta_g_miss_num_map(t(ddindx).cau_id);
306 a36(indx) := rosetta_g_miss_num_map(t(ddindx).num_days_hold_adv_pay);
307 indx := indx+1;
308 if t.last =ddindx
309 then exit;
310 end if;
311 ddindx := t.next(ddindx);
312 end loop;
313 end if;
314 end if;
315 end rosetta_table_copy_out_p2;
316
317 procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
318 , a1 JTF_NUMBER_TABLE
319 , a2 JTF_VARCHAR2_TABLE_200
320 , a3 JTF_VARCHAR2_TABLE_2000
321 , a4 JTF_DATE_TABLE
322 , a5 JTF_DATE_TABLE
323 , a6 JTF_NUMBER_TABLE
324 , a7 JTF_NUMBER_TABLE
325 , a8 JTF_NUMBER_TABLE
326 , a9 JTF_VARCHAR2_TABLE_100
327 , a10 JTF_VARCHAR2_TABLE_100
328 , a11 JTF_VARCHAR2_TABLE_100
329 , a12 JTF_VARCHAR2_TABLE_100
330 , a13 JTF_VARCHAR2_TABLE_100
331 , a14 JTF_VARCHAR2_TABLE_500
332 , a15 JTF_VARCHAR2_TABLE_500
333 , a16 JTF_VARCHAR2_TABLE_500
334 , a17 JTF_VARCHAR2_TABLE_500
335 , a18 JTF_VARCHAR2_TABLE_500
336 , a19 JTF_VARCHAR2_TABLE_500
337 , a20 JTF_VARCHAR2_TABLE_500
338 , a21 JTF_VARCHAR2_TABLE_500
339 , a22 JTF_VARCHAR2_TABLE_500
340 , a23 JTF_VARCHAR2_TABLE_500
341 , a24 JTF_VARCHAR2_TABLE_500
342 , a25 JTF_VARCHAR2_TABLE_500
343 , a26 JTF_VARCHAR2_TABLE_500
344 , a27 JTF_VARCHAR2_TABLE_500
345 , a28 JTF_VARCHAR2_TABLE_500
346 , a29 JTF_NUMBER_TABLE
347 , a30 JTF_NUMBER_TABLE
348 , a31 JTF_DATE_TABLE
349 , a32 JTF_NUMBER_TABLE
350 , a33 JTF_DATE_TABLE
351 , a34 JTF_NUMBER_TABLE
352 , a35 JTF_NUMBER_TABLE
353 , a36 JTF_NUMBER_TABLE
354 ) as
355 ddindx binary_integer; indx binary_integer;
356 begin
357 if a0 is not null and a0.count > 0 then
358 if a0.count > 0 then
359 indx := a0.first;
360 ddindx := 1;
361 while true loop
362 t(ddindx).id := rosetta_g_miss_num_map(a0(indx));
363 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
364 t(ddindx).name := a2(indx);
365 t(ddindx).description := a3(indx);
366 t(ddindx).start_date := rosetta_g_miss_date_in_map(a4(indx));
367 t(ddindx).end_date := rosetta_g_miss_date_in_map(a5(indx));
368 t(ddindx).amount_tolerance_percent := rosetta_g_miss_num_map(a6(indx));
369 t(ddindx).days_past_quote_valid_toleranc := rosetta_g_miss_num_map(a7(indx));
370 t(ddindx).months_to_bill_ahead := rosetta_g_miss_num_map(a8(indx));
371 t(ddindx).under_payment_allocation_code := a9(indx);
372 t(ddindx).over_payment_allocation_code := a10(indx);
373 t(ddindx).receipt_msmtch_allocation_code := a11(indx);
374 t(ddindx).default_rule := a12(indx);
375 t(ddindx).attribute_category := a13(indx);
376 t(ddindx).attribute1 := a14(indx);
377 t(ddindx).attribute2 := a15(indx);
378 t(ddindx).attribute3 := a16(indx);
379 t(ddindx).attribute4 := a17(indx);
380 t(ddindx).attribute5 := a18(indx);
381 t(ddindx).attribute6 := a19(indx);
382 t(ddindx).attribute7 := a20(indx);
383 t(ddindx).attribute8 := a21(indx);
384 t(ddindx).attribute9 := a22(indx);
385 t(ddindx).attribute10 := a23(indx);
386 t(ddindx).attribute11 := a24(indx);
387 t(ddindx).attribute12 := a25(indx);
388 t(ddindx).attribute13 := a26(indx);
389 t(ddindx).attribute14 := a27(indx);
390 t(ddindx).attribute15 := a28(indx);
391 t(ddindx).org_id := rosetta_g_miss_num_map(a29(indx));
392 t(ddindx).created_by := rosetta_g_miss_num_map(a30(indx));
393 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a31(indx));
394 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a32(indx));
395 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a33(indx));
396 t(ddindx).last_update_login := rosetta_g_miss_num_map(a34(indx));
397 t(ddindx).cau_id := rosetta_g_miss_num_map(a35(indx));
398 t(ddindx).num_days_hold_adv_pay := rosetta_g_miss_num_map(a36(indx));
399 ddindx := ddindx+1;
400 if a0.last =indx
401 then exit;
402 end if;
403 indx := a0.next(indx);
404 end loop;
405 end if;
406 end if;
407 end rosetta_table_copy_in_p5;
408 procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
409 , a1 out nocopy JTF_NUMBER_TABLE
410 , a2 out nocopy JTF_VARCHAR2_TABLE_200
411 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
412 , a4 out nocopy JTF_DATE_TABLE
413 , a5 out nocopy JTF_DATE_TABLE
414 , a6 out nocopy JTF_NUMBER_TABLE
415 , a7 out nocopy JTF_NUMBER_TABLE
416 , a8 out nocopy JTF_NUMBER_TABLE
417 , a9 out nocopy JTF_VARCHAR2_TABLE_100
418 , a10 out nocopy JTF_VARCHAR2_TABLE_100
419 , a11 out nocopy JTF_VARCHAR2_TABLE_100
420 , a12 out nocopy JTF_VARCHAR2_TABLE_100
421 , a13 out nocopy JTF_VARCHAR2_TABLE_100
422 , a14 out nocopy JTF_VARCHAR2_TABLE_500
423 , a15 out nocopy JTF_VARCHAR2_TABLE_500
424 , a16 out nocopy JTF_VARCHAR2_TABLE_500
425 , a17 out nocopy JTF_VARCHAR2_TABLE_500
426 , a18 out nocopy JTF_VARCHAR2_TABLE_500
427 , a19 out nocopy JTF_VARCHAR2_TABLE_500
428 , a20 out nocopy JTF_VARCHAR2_TABLE_500
429 , a21 out nocopy JTF_VARCHAR2_TABLE_500
430 , a22 out nocopy JTF_VARCHAR2_TABLE_500
431 , a23 out nocopy JTF_VARCHAR2_TABLE_500
432 , a24 out nocopy JTF_VARCHAR2_TABLE_500
433 , a25 out nocopy JTF_VARCHAR2_TABLE_500
434 , a26 out nocopy JTF_VARCHAR2_TABLE_500
435 , a27 out nocopy JTF_VARCHAR2_TABLE_500
436 , a28 out nocopy JTF_VARCHAR2_TABLE_500
437 , a29 out nocopy JTF_NUMBER_TABLE
438 , a30 out nocopy JTF_NUMBER_TABLE
439 , a31 out nocopy JTF_DATE_TABLE
440 , a32 out nocopy JTF_NUMBER_TABLE
441 , a33 out nocopy JTF_DATE_TABLE
442 , a34 out nocopy JTF_NUMBER_TABLE
443 , a35 out nocopy JTF_NUMBER_TABLE
444 , a36 out nocopy JTF_NUMBER_TABLE
445 ) as
446 ddindx binary_integer; indx binary_integer;
447 begin
448 if t is null or t.count = 0 then
449 a0 := JTF_NUMBER_TABLE();
450 a1 := JTF_NUMBER_TABLE();
451 a2 := JTF_VARCHAR2_TABLE_200();
452 a3 := JTF_VARCHAR2_TABLE_2000();
453 a4 := JTF_DATE_TABLE();
454 a5 := JTF_DATE_TABLE();
455 a6 := JTF_NUMBER_TABLE();
456 a7 := JTF_NUMBER_TABLE();
457 a8 := JTF_NUMBER_TABLE();
458 a9 := JTF_VARCHAR2_TABLE_100();
459 a10 := JTF_VARCHAR2_TABLE_100();
460 a11 := JTF_VARCHAR2_TABLE_100();
461 a12 := JTF_VARCHAR2_TABLE_100();
462 a13 := JTF_VARCHAR2_TABLE_100();
463 a14 := JTF_VARCHAR2_TABLE_500();
464 a15 := JTF_VARCHAR2_TABLE_500();
465 a16 := JTF_VARCHAR2_TABLE_500();
466 a17 := JTF_VARCHAR2_TABLE_500();
467 a18 := JTF_VARCHAR2_TABLE_500();
468 a19 := JTF_VARCHAR2_TABLE_500();
469 a20 := JTF_VARCHAR2_TABLE_500();
470 a21 := JTF_VARCHAR2_TABLE_500();
471 a22 := JTF_VARCHAR2_TABLE_500();
472 a23 := JTF_VARCHAR2_TABLE_500();
473 a24 := JTF_VARCHAR2_TABLE_500();
474 a25 := JTF_VARCHAR2_TABLE_500();
475 a26 := JTF_VARCHAR2_TABLE_500();
476 a27 := JTF_VARCHAR2_TABLE_500();
477 a28 := JTF_VARCHAR2_TABLE_500();
478 a29 := JTF_NUMBER_TABLE();
479 a30 := JTF_NUMBER_TABLE();
480 a31 := JTF_DATE_TABLE();
481 a32 := JTF_NUMBER_TABLE();
482 a33 := JTF_DATE_TABLE();
483 a34 := JTF_NUMBER_TABLE();
484 a35 := JTF_NUMBER_TABLE();
485 a36 := JTF_NUMBER_TABLE();
486 else
487 a0 := JTF_NUMBER_TABLE();
488 a1 := JTF_NUMBER_TABLE();
489 a2 := JTF_VARCHAR2_TABLE_200();
490 a3 := JTF_VARCHAR2_TABLE_2000();
491 a4 := JTF_DATE_TABLE();
492 a5 := JTF_DATE_TABLE();
493 a6 := JTF_NUMBER_TABLE();
494 a7 := JTF_NUMBER_TABLE();
495 a8 := JTF_NUMBER_TABLE();
496 a9 := JTF_VARCHAR2_TABLE_100();
497 a10 := JTF_VARCHAR2_TABLE_100();
498 a11 := JTF_VARCHAR2_TABLE_100();
499 a12 := JTF_VARCHAR2_TABLE_100();
500 a13 := JTF_VARCHAR2_TABLE_100();
501 a14 := JTF_VARCHAR2_TABLE_500();
502 a15 := JTF_VARCHAR2_TABLE_500();
503 a16 := JTF_VARCHAR2_TABLE_500();
504 a17 := JTF_VARCHAR2_TABLE_500();
505 a18 := JTF_VARCHAR2_TABLE_500();
506 a19 := JTF_VARCHAR2_TABLE_500();
507 a20 := JTF_VARCHAR2_TABLE_500();
508 a21 := JTF_VARCHAR2_TABLE_500();
509 a22 := JTF_VARCHAR2_TABLE_500();
510 a23 := JTF_VARCHAR2_TABLE_500();
511 a24 := JTF_VARCHAR2_TABLE_500();
512 a25 := JTF_VARCHAR2_TABLE_500();
513 a26 := JTF_VARCHAR2_TABLE_500();
514 a27 := JTF_VARCHAR2_TABLE_500();
515 a28 := JTF_VARCHAR2_TABLE_500();
516 a29 := JTF_NUMBER_TABLE();
517 a30 := JTF_NUMBER_TABLE();
518 a31 := JTF_DATE_TABLE();
519 a32 := JTF_NUMBER_TABLE();
520 a33 := JTF_DATE_TABLE();
521 a34 := JTF_NUMBER_TABLE();
522 a35 := JTF_NUMBER_TABLE();
523 a36 := JTF_NUMBER_TABLE();
524 if t.count > 0 then
525 a0.extend(t.count);
526 a1.extend(t.count);
527 a2.extend(t.count);
528 a3.extend(t.count);
529 a4.extend(t.count);
530 a5.extend(t.count);
531 a6.extend(t.count);
532 a7.extend(t.count);
533 a8.extend(t.count);
534 a9.extend(t.count);
535 a10.extend(t.count);
536 a11.extend(t.count);
537 a12.extend(t.count);
538 a13.extend(t.count);
539 a14.extend(t.count);
540 a15.extend(t.count);
541 a16.extend(t.count);
542 a17.extend(t.count);
543 a18.extend(t.count);
544 a19.extend(t.count);
545 a20.extend(t.count);
546 a21.extend(t.count);
547 a22.extend(t.count);
548 a23.extend(t.count);
549 a24.extend(t.count);
550 a25.extend(t.count);
551 a26.extend(t.count);
552 a27.extend(t.count);
553 a28.extend(t.count);
554 a29.extend(t.count);
555 a30.extend(t.count);
556 a31.extend(t.count);
557 a32.extend(t.count);
558 a33.extend(t.count);
559 a34.extend(t.count);
560 a35.extend(t.count);
561 a36.extend(t.count);
562 ddindx := t.first;
563 indx := 1;
564 while true loop
565 a0(indx) := rosetta_g_miss_num_map(t(ddindx).id);
566 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
567 a2(indx) := t(ddindx).name;
568 a3(indx) := t(ddindx).description;
569 a4(indx) := t(ddindx).start_date;
570 a5(indx) := t(ddindx).end_date;
571 a6(indx) := rosetta_g_miss_num_map(t(ddindx).amount_tolerance_percent);
572 a7(indx) := rosetta_g_miss_num_map(t(ddindx).days_past_quote_valid_toleranc);
573 a8(indx) := rosetta_g_miss_num_map(t(ddindx).months_to_bill_ahead);
574 a9(indx) := t(ddindx).under_payment_allocation_code;
575 a10(indx) := t(ddindx).over_payment_allocation_code;
576 a11(indx) := t(ddindx).receipt_msmtch_allocation_code;
577 a12(indx) := t(ddindx).default_rule;
578 a13(indx) := t(ddindx).attribute_category;
579 a14(indx) := t(ddindx).attribute1;
580 a15(indx) := t(ddindx).attribute2;
581 a16(indx) := t(ddindx).attribute3;
582 a17(indx) := t(ddindx).attribute4;
583 a18(indx) := t(ddindx).attribute5;
584 a19(indx) := t(ddindx).attribute6;
585 a20(indx) := t(ddindx).attribute7;
586 a21(indx) := t(ddindx).attribute8;
587 a22(indx) := t(ddindx).attribute9;
588 a23(indx) := t(ddindx).attribute10;
589 a24(indx) := t(ddindx).attribute11;
590 a25(indx) := t(ddindx).attribute12;
591 a26(indx) := t(ddindx).attribute13;
592 a27(indx) := t(ddindx).attribute14;
593 a28(indx) := t(ddindx).attribute15;
594 a29(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
595 a30(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
596 a31(indx) := t(ddindx).creation_date;
597 a32(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
598 a33(indx) := t(ddindx).last_update_date;
599 a34(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
600 a35(indx) := rosetta_g_miss_num_map(t(ddindx).cau_id);
601 a36(indx) := rosetta_g_miss_num_map(t(ddindx).num_days_hold_adv_pay);
602 indx := indx+1;
603 if t.last =ddindx
604 then exit;
605 end if;
606 ddindx := t.next(ddindx);
607 end loop;
608 end if;
609 end if;
610 end rosetta_table_copy_out_p5;
611
612 procedure insert_row(p_api_version NUMBER
613 , p_init_msg_list VARCHAR2
614 , x_return_status out nocopy VARCHAR2
615 , x_msg_count out nocopy NUMBER
616 , x_msg_data out nocopy VARCHAR2
617 , p6_a0 out nocopy NUMBER
618 , p6_a1 out nocopy NUMBER
619 , p6_a2 out nocopy VARCHAR2
620 , p6_a3 out nocopy VARCHAR2
621 , p6_a4 out nocopy DATE
622 , p6_a5 out nocopy DATE
623 , p6_a6 out nocopy NUMBER
624 , p6_a7 out nocopy NUMBER
625 , p6_a8 out nocopy NUMBER
626 , p6_a9 out nocopy VARCHAR2
627 , p6_a10 out nocopy VARCHAR2
628 , p6_a11 out nocopy VARCHAR2
629 , p6_a12 out nocopy VARCHAR2
630 , p6_a13 out nocopy VARCHAR2
631 , p6_a14 out nocopy VARCHAR2
632 , p6_a15 out nocopy VARCHAR2
633 , p6_a16 out nocopy VARCHAR2
634 , p6_a17 out nocopy VARCHAR2
635 , p6_a18 out nocopy VARCHAR2
636 , p6_a19 out nocopy VARCHAR2
637 , p6_a20 out nocopy VARCHAR2
638 , p6_a21 out nocopy VARCHAR2
639 , p6_a22 out nocopy VARCHAR2
640 , p6_a23 out nocopy VARCHAR2
641 , p6_a24 out nocopy VARCHAR2
642 , p6_a25 out nocopy VARCHAR2
643 , p6_a26 out nocopy VARCHAR2
644 , p6_a27 out nocopy VARCHAR2
645 , p6_a28 out nocopy VARCHAR2
646 , p6_a29 out nocopy NUMBER
647 , p6_a30 out nocopy NUMBER
648 , p6_a31 out nocopy DATE
649 , p6_a32 out nocopy NUMBER
650 , p6_a33 out nocopy DATE
651 , p6_a34 out nocopy NUMBER
652 , p6_a35 out nocopy NUMBER
653 , p6_a36 out nocopy NUMBER
654 , p5_a0 NUMBER := 0-1962.0724
655 , p5_a1 NUMBER := 0-1962.0724
656 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
657 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
658 , p5_a4 DATE := fnd_api.g_miss_date
659 , p5_a5 DATE := fnd_api.g_miss_date
660 , p5_a6 NUMBER := 0-1962.0724
661 , p5_a7 NUMBER := 0-1962.0724
662 , p5_a8 NUMBER := 0-1962.0724
663 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
664 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
665 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
666 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
667 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
668 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
669 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
670 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
671 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
672 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
673 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
674 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
676 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
677 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
678 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
679 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
680 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
682 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
683 , p5_a29 NUMBER := 0-1962.0724
684 , p5_a30 NUMBER := 0-1962.0724
685 , p5_a31 DATE := fnd_api.g_miss_date
686 , p5_a32 NUMBER := 0-1962.0724
687 , p5_a33 DATE := fnd_api.g_miss_date
688 , p5_a34 NUMBER := 0-1962.0724
689 , p5_a35 NUMBER := 0-1962.0724
690 , p5_a36 NUMBER := 0-1962.0724
691 )
692
693 as
694 ddp_catv_rec okl_cat_pvt.catv_rec_type;
695 ddx_catv_rec okl_cat_pvt.catv_rec_type;
696 ddindx binary_integer; indx binary_integer;
697 begin
698
699 -- copy data to the local IN or IN-OUT args, if any
700
701
702
703
704
705 ddp_catv_rec.id := rosetta_g_miss_num_map(p5_a0);
706 ddp_catv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
707 ddp_catv_rec.name := p5_a2;
708 ddp_catv_rec.description := p5_a3;
709 ddp_catv_rec.start_date := rosetta_g_miss_date_in_map(p5_a4);
710 ddp_catv_rec.end_date := rosetta_g_miss_date_in_map(p5_a5);
711 ddp_catv_rec.amount_tolerance_percent := rosetta_g_miss_num_map(p5_a6);
712 ddp_catv_rec.days_past_quote_valid_toleranc := rosetta_g_miss_num_map(p5_a7);
713 ddp_catv_rec.months_to_bill_ahead := rosetta_g_miss_num_map(p5_a8);
714 ddp_catv_rec.under_payment_allocation_code := p5_a9;
715 ddp_catv_rec.over_payment_allocation_code := p5_a10;
716 ddp_catv_rec.receipt_msmtch_allocation_code := p5_a11;
717 ddp_catv_rec.default_rule := p5_a12;
718 ddp_catv_rec.attribute_category := p5_a13;
719 ddp_catv_rec.attribute1 := p5_a14;
720 ddp_catv_rec.attribute2 := p5_a15;
721 ddp_catv_rec.attribute3 := p5_a16;
722 ddp_catv_rec.attribute4 := p5_a17;
723 ddp_catv_rec.attribute5 := p5_a18;
724 ddp_catv_rec.attribute6 := p5_a19;
725 ddp_catv_rec.attribute7 := p5_a20;
726 ddp_catv_rec.attribute8 := p5_a21;
727 ddp_catv_rec.attribute9 := p5_a22;
728 ddp_catv_rec.attribute10 := p5_a23;
729 ddp_catv_rec.attribute11 := p5_a24;
730 ddp_catv_rec.attribute12 := p5_a25;
731 ddp_catv_rec.attribute13 := p5_a26;
732 ddp_catv_rec.attribute14 := p5_a27;
733 ddp_catv_rec.attribute15 := p5_a28;
734 ddp_catv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
735 ddp_catv_rec.created_by := rosetta_g_miss_num_map(p5_a30);
736 ddp_catv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a31);
737 ddp_catv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a32);
738 ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
739 ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
740 ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
741 ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
742
743
744 -- here's the delegated call to the old PL/SQL routine
745 okl_cat_pvt.insert_row(p_api_version,
746 p_init_msg_list,
747 x_return_status,
748 x_msg_count,
749 x_msg_data,
750 ddp_catv_rec,
751 ddx_catv_rec);
752
753 -- copy data back from the local variables to OUT or IN-OUT args, if any
754
755
756
757
758
759
760 p6_a0 := rosetta_g_miss_num_map(ddx_catv_rec.id);
761 p6_a1 := rosetta_g_miss_num_map(ddx_catv_rec.object_version_number);
762 p6_a2 := ddx_catv_rec.name;
763 p6_a3 := ddx_catv_rec.description;
764 p6_a4 := ddx_catv_rec.start_date;
765 p6_a5 := ddx_catv_rec.end_date;
766 p6_a6 := rosetta_g_miss_num_map(ddx_catv_rec.amount_tolerance_percent);
767 p6_a7 := rosetta_g_miss_num_map(ddx_catv_rec.days_past_quote_valid_toleranc);
768 p6_a8 := rosetta_g_miss_num_map(ddx_catv_rec.months_to_bill_ahead);
769 p6_a9 := ddx_catv_rec.under_payment_allocation_code;
770 p6_a10 := ddx_catv_rec.over_payment_allocation_code;
771 p6_a11 := ddx_catv_rec.receipt_msmtch_allocation_code;
772 p6_a12 := ddx_catv_rec.default_rule;
773 p6_a13 := ddx_catv_rec.attribute_category;
774 p6_a14 := ddx_catv_rec.attribute1;
775 p6_a15 := ddx_catv_rec.attribute2;
776 p6_a16 := ddx_catv_rec.attribute3;
777 p6_a17 := ddx_catv_rec.attribute4;
778 p6_a18 := ddx_catv_rec.attribute5;
779 p6_a19 := ddx_catv_rec.attribute6;
780 p6_a20 := ddx_catv_rec.attribute7;
781 p6_a21 := ddx_catv_rec.attribute8;
782 p6_a22 := ddx_catv_rec.attribute9;
783 p6_a23 := ddx_catv_rec.attribute10;
784 p6_a24 := ddx_catv_rec.attribute11;
785 p6_a25 := ddx_catv_rec.attribute12;
786 p6_a26 := ddx_catv_rec.attribute13;
787 p6_a27 := ddx_catv_rec.attribute14;
788 p6_a28 := ddx_catv_rec.attribute15;
789 p6_a29 := rosetta_g_miss_num_map(ddx_catv_rec.org_id);
790 p6_a30 := rosetta_g_miss_num_map(ddx_catv_rec.created_by);
791 p6_a31 := ddx_catv_rec.creation_date;
792 p6_a32 := rosetta_g_miss_num_map(ddx_catv_rec.last_updated_by);
793 p6_a33 := ddx_catv_rec.last_update_date;
794 p6_a34 := rosetta_g_miss_num_map(ddx_catv_rec.last_update_login);
795 p6_a35 := rosetta_g_miss_num_map(ddx_catv_rec.cau_id);
796 p6_a36 := rosetta_g_miss_num_map(ddx_catv_rec.num_days_hold_adv_pay);
797 end;
798
799 procedure insert_row(p_api_version NUMBER
800 , p_init_msg_list VARCHAR2
801 , x_return_status out nocopy VARCHAR2
802 , x_msg_count out nocopy NUMBER
803 , x_msg_data out nocopy VARCHAR2
804 , p5_a0 JTF_NUMBER_TABLE
805 , p5_a1 JTF_NUMBER_TABLE
806 , p5_a2 JTF_VARCHAR2_TABLE_200
807 , p5_a3 JTF_VARCHAR2_TABLE_2000
808 , p5_a4 JTF_DATE_TABLE
809 , p5_a5 JTF_DATE_TABLE
810 , p5_a6 JTF_NUMBER_TABLE
811 , p5_a7 JTF_NUMBER_TABLE
812 , p5_a8 JTF_NUMBER_TABLE
813 , p5_a9 JTF_VARCHAR2_TABLE_100
814 , p5_a10 JTF_VARCHAR2_TABLE_100
815 , p5_a11 JTF_VARCHAR2_TABLE_100
816 , p5_a12 JTF_VARCHAR2_TABLE_100
817 , p5_a13 JTF_VARCHAR2_TABLE_100
818 , p5_a14 JTF_VARCHAR2_TABLE_500
819 , p5_a15 JTF_VARCHAR2_TABLE_500
820 , p5_a16 JTF_VARCHAR2_TABLE_500
821 , p5_a17 JTF_VARCHAR2_TABLE_500
822 , p5_a18 JTF_VARCHAR2_TABLE_500
823 , p5_a19 JTF_VARCHAR2_TABLE_500
824 , p5_a20 JTF_VARCHAR2_TABLE_500
825 , p5_a21 JTF_VARCHAR2_TABLE_500
826 , p5_a22 JTF_VARCHAR2_TABLE_500
827 , p5_a23 JTF_VARCHAR2_TABLE_500
828 , p5_a24 JTF_VARCHAR2_TABLE_500
829 , p5_a25 JTF_VARCHAR2_TABLE_500
830 , p5_a26 JTF_VARCHAR2_TABLE_500
831 , p5_a27 JTF_VARCHAR2_TABLE_500
832 , p5_a28 JTF_VARCHAR2_TABLE_500
833 , p5_a29 JTF_NUMBER_TABLE
834 , p5_a30 JTF_NUMBER_TABLE
835 , p5_a31 JTF_DATE_TABLE
836 , p5_a32 JTF_NUMBER_TABLE
837 , p5_a33 JTF_DATE_TABLE
838 , p5_a34 JTF_NUMBER_TABLE
839 , p5_a35 JTF_NUMBER_TABLE
840 , p5_a36 JTF_NUMBER_TABLE
841 , p6_a0 out nocopy JTF_NUMBER_TABLE
842 , p6_a1 out nocopy JTF_NUMBER_TABLE
843 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
844 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
845 , p6_a4 out nocopy JTF_DATE_TABLE
846 , p6_a5 out nocopy JTF_DATE_TABLE
847 , p6_a6 out nocopy JTF_NUMBER_TABLE
848 , p6_a7 out nocopy JTF_NUMBER_TABLE
849 , p6_a8 out nocopy JTF_NUMBER_TABLE
850 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
851 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
852 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
853 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
854 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
855 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
856 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
857 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
858 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
859 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
860 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
861 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
862 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
863 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
864 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
865 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
866 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
867 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
868 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
869 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
870 , p6_a29 out nocopy JTF_NUMBER_TABLE
871 , p6_a30 out nocopy JTF_NUMBER_TABLE
872 , p6_a31 out nocopy JTF_DATE_TABLE
873 , p6_a32 out nocopy JTF_NUMBER_TABLE
874 , p6_a33 out nocopy JTF_DATE_TABLE
875 , p6_a34 out nocopy JTF_NUMBER_TABLE
876 , p6_a35 out nocopy JTF_NUMBER_TABLE
877 , p6_a36 out nocopy JTF_NUMBER_TABLE
878 )
879
880 as
881 ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
882 ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
883 ddindx binary_integer; indx binary_integer;
884 begin
885
886 -- copy data to the local IN or IN-OUT args, if any
887
888
889
890
891
892 okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
893 , p5_a1
894 , p5_a2
895 , p5_a3
896 , p5_a4
897 , p5_a5
898 , p5_a6
899 , p5_a7
900 , p5_a8
901 , p5_a9
902 , p5_a10
903 , p5_a11
904 , p5_a12
905 , p5_a13
906 , p5_a14
907 , p5_a15
908 , p5_a16
909 , p5_a17
910 , p5_a18
911 , p5_a19
912 , p5_a20
913 , p5_a21
914 , p5_a22
915 , p5_a23
916 , p5_a24
917 , p5_a25
918 , p5_a26
919 , p5_a27
920 , p5_a28
921 , p5_a29
922 , p5_a30
923 , p5_a31
924 , p5_a32
925 , p5_a33
926 , p5_a34
927 , p5_a35
928 , p5_a36
929 );
930
931
932 -- here's the delegated call to the old PL/SQL routine
933 okl_cat_pvt.insert_row(p_api_version,
934 p_init_msg_list,
935 x_return_status,
936 x_msg_count,
937 x_msg_data,
938 ddp_catv_tbl,
939 ddx_catv_tbl);
940
941 -- copy data back from the local variables to OUT or IN-OUT args, if any
942
943
944
945
946
947
948 okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0
949 , p6_a1
950 , p6_a2
951 , p6_a3
952 , p6_a4
953 , p6_a5
954 , p6_a6
955 , p6_a7
956 , p6_a8
957 , p6_a9
958 , p6_a10
959 , p6_a11
960 , p6_a12
961 , p6_a13
962 , p6_a14
963 , p6_a15
964 , p6_a16
965 , p6_a17
966 , p6_a18
967 , p6_a19
968 , p6_a20
969 , p6_a21
970 , p6_a22
971 , p6_a23
972 , p6_a24
973 , p6_a25
974 , p6_a26
975 , p6_a27
976 , p6_a28
977 , p6_a29
978 , p6_a30
979 , p6_a31
980 , p6_a32
981 , p6_a33
982 , p6_a34
983 , p6_a35
984 , p6_a36
985 );
986 end;
987
988 procedure lock_row(p_api_version NUMBER
989 , p_init_msg_list VARCHAR2
990 , x_return_status out nocopy VARCHAR2
991 , x_msg_count out nocopy NUMBER
992 , x_msg_data out nocopy VARCHAR2
993 , p5_a0 NUMBER := 0-1962.0724
994 , p5_a1 NUMBER := 0-1962.0724
995 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
996 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
997 , p5_a4 DATE := fnd_api.g_miss_date
998 , p5_a5 DATE := fnd_api.g_miss_date
999 , p5_a6 NUMBER := 0-1962.0724
1000 , p5_a7 NUMBER := 0-1962.0724
1001 , p5_a8 NUMBER := 0-1962.0724
1002 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1003 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1004 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1005 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1006 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1007 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1008 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1009 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1010 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1011 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1012 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1013 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1014 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1015 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1016 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1017 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1018 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1019 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1020 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1021 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1022 , p5_a29 NUMBER := 0-1962.0724
1023 , p5_a30 NUMBER := 0-1962.0724
1024 , p5_a31 DATE := fnd_api.g_miss_date
1025 , p5_a32 NUMBER := 0-1962.0724
1026 , p5_a33 DATE := fnd_api.g_miss_date
1027 , p5_a34 NUMBER := 0-1962.0724
1028 , p5_a35 NUMBER := 0-1962.0724
1029 , p5_a36 NUMBER := 0-1962.0724
1030 )
1031
1032 as
1033 ddp_catv_rec okl_cat_pvt.catv_rec_type;
1034 ddindx binary_integer; indx binary_integer;
1035 begin
1036
1037 -- copy data to the local IN or IN-OUT args, if any
1038
1039
1040
1041
1042
1043 ddp_catv_rec.id := rosetta_g_miss_num_map(p5_a0);
1044 ddp_catv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1045 ddp_catv_rec.name := p5_a2;
1046 ddp_catv_rec.description := p5_a3;
1047 ddp_catv_rec.start_date := rosetta_g_miss_date_in_map(p5_a4);
1048 ddp_catv_rec.end_date := rosetta_g_miss_date_in_map(p5_a5);
1049 ddp_catv_rec.amount_tolerance_percent := rosetta_g_miss_num_map(p5_a6);
1050 ddp_catv_rec.days_past_quote_valid_toleranc := rosetta_g_miss_num_map(p5_a7);
1051 ddp_catv_rec.months_to_bill_ahead := rosetta_g_miss_num_map(p5_a8);
1052 ddp_catv_rec.under_payment_allocation_code := p5_a9;
1053 ddp_catv_rec.over_payment_allocation_code := p5_a10;
1054 ddp_catv_rec.receipt_msmtch_allocation_code := p5_a11;
1055 ddp_catv_rec.default_rule := p5_a12;
1056 ddp_catv_rec.attribute_category := p5_a13;
1057 ddp_catv_rec.attribute1 := p5_a14;
1058 ddp_catv_rec.attribute2 := p5_a15;
1059 ddp_catv_rec.attribute3 := p5_a16;
1060 ddp_catv_rec.attribute4 := p5_a17;
1061 ddp_catv_rec.attribute5 := p5_a18;
1062 ddp_catv_rec.attribute6 := p5_a19;
1063 ddp_catv_rec.attribute7 := p5_a20;
1064 ddp_catv_rec.attribute8 := p5_a21;
1065 ddp_catv_rec.attribute9 := p5_a22;
1066 ddp_catv_rec.attribute10 := p5_a23;
1067 ddp_catv_rec.attribute11 := p5_a24;
1068 ddp_catv_rec.attribute12 := p5_a25;
1069 ddp_catv_rec.attribute13 := p5_a26;
1070 ddp_catv_rec.attribute14 := p5_a27;
1071 ddp_catv_rec.attribute15 := p5_a28;
1072 ddp_catv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1073 ddp_catv_rec.created_by := rosetta_g_miss_num_map(p5_a30);
1074 ddp_catv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a31);
1075 ddp_catv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a32);
1076 ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1077 ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1078 ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1079 ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1080
1081 -- here's the delegated call to the old PL/SQL routine
1082 okl_cat_pvt.lock_row(p_api_version,
1083 p_init_msg_list,
1084 x_return_status,
1085 x_msg_count,
1086 x_msg_data,
1087 ddp_catv_rec);
1088
1089 -- copy data back from the local variables to OUT or IN-OUT args, if any
1090
1091
1092
1093
1094
1095 end;
1096
1097 procedure lock_row(p_api_version NUMBER
1098 , p_init_msg_list VARCHAR2
1099 , x_return_status out nocopy VARCHAR2
1100 , x_msg_count out nocopy NUMBER
1101 , x_msg_data out nocopy VARCHAR2
1102 , p5_a0 JTF_NUMBER_TABLE
1103 , p5_a1 JTF_NUMBER_TABLE
1104 , p5_a2 JTF_VARCHAR2_TABLE_200
1105 , p5_a3 JTF_VARCHAR2_TABLE_2000
1106 , p5_a4 JTF_DATE_TABLE
1107 , p5_a5 JTF_DATE_TABLE
1108 , p5_a6 JTF_NUMBER_TABLE
1109 , p5_a7 JTF_NUMBER_TABLE
1110 , p5_a8 JTF_NUMBER_TABLE
1111 , p5_a9 JTF_VARCHAR2_TABLE_100
1112 , p5_a10 JTF_VARCHAR2_TABLE_100
1113 , p5_a11 JTF_VARCHAR2_TABLE_100
1114 , p5_a12 JTF_VARCHAR2_TABLE_100
1115 , p5_a13 JTF_VARCHAR2_TABLE_100
1116 , p5_a14 JTF_VARCHAR2_TABLE_500
1117 , p5_a15 JTF_VARCHAR2_TABLE_500
1118 , p5_a16 JTF_VARCHAR2_TABLE_500
1119 , p5_a17 JTF_VARCHAR2_TABLE_500
1120 , p5_a18 JTF_VARCHAR2_TABLE_500
1121 , p5_a19 JTF_VARCHAR2_TABLE_500
1122 , p5_a20 JTF_VARCHAR2_TABLE_500
1123 , p5_a21 JTF_VARCHAR2_TABLE_500
1124 , p5_a22 JTF_VARCHAR2_TABLE_500
1125 , p5_a23 JTF_VARCHAR2_TABLE_500
1126 , p5_a24 JTF_VARCHAR2_TABLE_500
1127 , p5_a25 JTF_VARCHAR2_TABLE_500
1128 , p5_a26 JTF_VARCHAR2_TABLE_500
1129 , p5_a27 JTF_VARCHAR2_TABLE_500
1130 , p5_a28 JTF_VARCHAR2_TABLE_500
1131 , p5_a29 JTF_NUMBER_TABLE
1132 , p5_a30 JTF_NUMBER_TABLE
1133 , p5_a31 JTF_DATE_TABLE
1134 , p5_a32 JTF_NUMBER_TABLE
1135 , p5_a33 JTF_DATE_TABLE
1136 , p5_a34 JTF_NUMBER_TABLE
1137 , p5_a35 JTF_NUMBER_TABLE
1138 , p5_a36 JTF_NUMBER_TABLE
1139 )
1140
1141 as
1142 ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1143 ddindx binary_integer; indx binary_integer;
1144 begin
1145
1146 -- copy data to the local IN or IN-OUT args, if any
1147
1148
1149
1150
1151
1152 okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1153 , p5_a1
1154 , p5_a2
1155 , p5_a3
1156 , p5_a4
1157 , p5_a5
1158 , p5_a6
1159 , p5_a7
1160 , p5_a8
1161 , p5_a9
1162 , p5_a10
1163 , p5_a11
1164 , p5_a12
1165 , p5_a13
1166 , p5_a14
1167 , p5_a15
1168 , p5_a16
1169 , p5_a17
1170 , p5_a18
1171 , p5_a19
1172 , p5_a20
1173 , p5_a21
1174 , p5_a22
1175 , p5_a23
1176 , p5_a24
1177 , p5_a25
1178 , p5_a26
1179 , p5_a27
1180 , p5_a28
1181 , p5_a29
1182 , p5_a30
1183 , p5_a31
1184 , p5_a32
1185 , p5_a33
1186 , p5_a34
1187 , p5_a35
1188 , p5_a36
1189 );
1190
1191 -- here's the delegated call to the old PL/SQL routine
1192 okl_cat_pvt.lock_row(p_api_version,
1193 p_init_msg_list,
1194 x_return_status,
1195 x_msg_count,
1196 x_msg_data,
1197 ddp_catv_tbl);
1198
1199 -- copy data back from the local variables to OUT or IN-OUT args, if any
1200
1201
1202
1203
1204
1205 end;
1206
1207 procedure update_row(p_api_version NUMBER
1208 , p_init_msg_list VARCHAR2
1209 , x_return_status out nocopy VARCHAR2
1210 , x_msg_count out nocopy NUMBER
1211 , x_msg_data out nocopy VARCHAR2
1212 , p6_a0 out nocopy NUMBER
1213 , p6_a1 out nocopy NUMBER
1214 , p6_a2 out nocopy VARCHAR2
1215 , p6_a3 out nocopy VARCHAR2
1216 , p6_a4 out nocopy DATE
1217 , p6_a5 out nocopy DATE
1218 , p6_a6 out nocopy NUMBER
1219 , p6_a7 out nocopy NUMBER
1220 , p6_a8 out nocopy NUMBER
1221 , p6_a9 out nocopy VARCHAR2
1222 , p6_a10 out nocopy VARCHAR2
1223 , p6_a11 out nocopy VARCHAR2
1224 , p6_a12 out nocopy VARCHAR2
1225 , p6_a13 out nocopy VARCHAR2
1226 , p6_a14 out nocopy VARCHAR2
1227 , p6_a15 out nocopy VARCHAR2
1228 , p6_a16 out nocopy VARCHAR2
1229 , p6_a17 out nocopy VARCHAR2
1230 , p6_a18 out nocopy VARCHAR2
1231 , p6_a19 out nocopy VARCHAR2
1232 , p6_a20 out nocopy VARCHAR2
1233 , p6_a21 out nocopy VARCHAR2
1234 , p6_a22 out nocopy VARCHAR2
1235 , p6_a23 out nocopy VARCHAR2
1236 , p6_a24 out nocopy VARCHAR2
1237 , p6_a25 out nocopy VARCHAR2
1238 , p6_a26 out nocopy VARCHAR2
1239 , p6_a27 out nocopy VARCHAR2
1240 , p6_a28 out nocopy VARCHAR2
1241 , p6_a29 out nocopy NUMBER
1242 , p6_a30 out nocopy NUMBER
1243 , p6_a31 out nocopy DATE
1244 , p6_a32 out nocopy NUMBER
1245 , p6_a33 out nocopy DATE
1246 , p6_a34 out nocopy NUMBER
1247 , p6_a35 out nocopy NUMBER
1248 , p6_a36 out nocopy NUMBER
1249 , p5_a0 NUMBER := 0-1962.0724
1250 , p5_a1 NUMBER := 0-1962.0724
1251 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1252 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1253 , p5_a4 DATE := fnd_api.g_miss_date
1254 , p5_a5 DATE := fnd_api.g_miss_date
1255 , p5_a6 NUMBER := 0-1962.0724
1256 , p5_a7 NUMBER := 0-1962.0724
1257 , p5_a8 NUMBER := 0-1962.0724
1258 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1259 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1260 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1261 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1262 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1263 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1264 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1265 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1266 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1267 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1268 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1269 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1270 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1271 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1272 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1273 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1274 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1275 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1276 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1277 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1278 , p5_a29 NUMBER := 0-1962.0724
1279 , p5_a30 NUMBER := 0-1962.0724
1280 , p5_a31 DATE := fnd_api.g_miss_date
1281 , p5_a32 NUMBER := 0-1962.0724
1282 , p5_a33 DATE := fnd_api.g_miss_date
1283 , p5_a34 NUMBER := 0-1962.0724
1284 , p5_a35 NUMBER := 0-1962.0724
1285 , p5_a36 NUMBER := 0-1962.0724
1286 )
1287
1288 as
1289 ddp_catv_rec okl_cat_pvt.catv_rec_type;
1290 ddx_catv_rec okl_cat_pvt.catv_rec_type;
1291 ddindx binary_integer; indx binary_integer;
1292 begin
1293
1294 -- copy data to the local IN or IN-OUT args, if any
1295
1296
1297
1298
1299
1300 ddp_catv_rec.id := rosetta_g_miss_num_map(p5_a0);
1301 ddp_catv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1302 ddp_catv_rec.name := p5_a2;
1303 ddp_catv_rec.description := p5_a3;
1304 ddp_catv_rec.start_date := rosetta_g_miss_date_in_map(p5_a4);
1305 ddp_catv_rec.end_date := rosetta_g_miss_date_in_map(p5_a5);
1306 ddp_catv_rec.amount_tolerance_percent := rosetta_g_miss_num_map(p5_a6);
1307 ddp_catv_rec.days_past_quote_valid_toleranc := rosetta_g_miss_num_map(p5_a7);
1308 ddp_catv_rec.months_to_bill_ahead := rosetta_g_miss_num_map(p5_a8);
1309 ddp_catv_rec.under_payment_allocation_code := p5_a9;
1310 ddp_catv_rec.over_payment_allocation_code := p5_a10;
1311 ddp_catv_rec.receipt_msmtch_allocation_code := p5_a11;
1312 ddp_catv_rec.default_rule := p5_a12;
1313 ddp_catv_rec.attribute_category := p5_a13;
1314 ddp_catv_rec.attribute1 := p5_a14;
1315 ddp_catv_rec.attribute2 := p5_a15;
1316 ddp_catv_rec.attribute3 := p5_a16;
1317 ddp_catv_rec.attribute4 := p5_a17;
1318 ddp_catv_rec.attribute5 := p5_a18;
1319 ddp_catv_rec.attribute6 := p5_a19;
1320 ddp_catv_rec.attribute7 := p5_a20;
1321 ddp_catv_rec.attribute8 := p5_a21;
1322 ddp_catv_rec.attribute9 := p5_a22;
1323 ddp_catv_rec.attribute10 := p5_a23;
1324 ddp_catv_rec.attribute11 := p5_a24;
1325 ddp_catv_rec.attribute12 := p5_a25;
1326 ddp_catv_rec.attribute13 := p5_a26;
1327 ddp_catv_rec.attribute14 := p5_a27;
1328 ddp_catv_rec.attribute15 := p5_a28;
1329 ddp_catv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1330 ddp_catv_rec.created_by := rosetta_g_miss_num_map(p5_a30);
1331 ddp_catv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a31);
1332 ddp_catv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a32);
1333 ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1334 ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1335 ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1336 ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1337
1338
1339 -- here's the delegated call to the old PL/SQL routine
1340 okl_cat_pvt.update_row(p_api_version,
1341 p_init_msg_list,
1342 x_return_status,
1343 x_msg_count,
1344 x_msg_data,
1345 ddp_catv_rec,
1346 ddx_catv_rec);
1347
1348 -- copy data back from the local variables to OUT or IN-OUT args, if any
1349
1350
1351
1352
1353
1354
1355 p6_a0 := rosetta_g_miss_num_map(ddx_catv_rec.id);
1356 p6_a1 := rosetta_g_miss_num_map(ddx_catv_rec.object_version_number);
1357 p6_a2 := ddx_catv_rec.name;
1358 p6_a3 := ddx_catv_rec.description;
1359 p6_a4 := ddx_catv_rec.start_date;
1360 p6_a5 := ddx_catv_rec.end_date;
1361 p6_a6 := rosetta_g_miss_num_map(ddx_catv_rec.amount_tolerance_percent);
1362 p6_a7 := rosetta_g_miss_num_map(ddx_catv_rec.days_past_quote_valid_toleranc);
1363 p6_a8 := rosetta_g_miss_num_map(ddx_catv_rec.months_to_bill_ahead);
1364 p6_a9 := ddx_catv_rec.under_payment_allocation_code;
1365 p6_a10 := ddx_catv_rec.over_payment_allocation_code;
1366 p6_a11 := ddx_catv_rec.receipt_msmtch_allocation_code;
1367 p6_a12 := ddx_catv_rec.default_rule;
1368 p6_a13 := ddx_catv_rec.attribute_category;
1369 p6_a14 := ddx_catv_rec.attribute1;
1370 p6_a15 := ddx_catv_rec.attribute2;
1371 p6_a16 := ddx_catv_rec.attribute3;
1372 p6_a17 := ddx_catv_rec.attribute4;
1373 p6_a18 := ddx_catv_rec.attribute5;
1374 p6_a19 := ddx_catv_rec.attribute6;
1375 p6_a20 := ddx_catv_rec.attribute7;
1376 p6_a21 := ddx_catv_rec.attribute8;
1377 p6_a22 := ddx_catv_rec.attribute9;
1378 p6_a23 := ddx_catv_rec.attribute10;
1379 p6_a24 := ddx_catv_rec.attribute11;
1380 p6_a25 := ddx_catv_rec.attribute12;
1381 p6_a26 := ddx_catv_rec.attribute13;
1382 p6_a27 := ddx_catv_rec.attribute14;
1383 p6_a28 := ddx_catv_rec.attribute15;
1384 p6_a29 := rosetta_g_miss_num_map(ddx_catv_rec.org_id);
1385 p6_a30 := rosetta_g_miss_num_map(ddx_catv_rec.created_by);
1386 p6_a31 := ddx_catv_rec.creation_date;
1387 p6_a32 := rosetta_g_miss_num_map(ddx_catv_rec.last_updated_by);
1388 p6_a33 := ddx_catv_rec.last_update_date;
1389 p6_a34 := rosetta_g_miss_num_map(ddx_catv_rec.last_update_login);
1390 p6_a35 := rosetta_g_miss_num_map(ddx_catv_rec.cau_id);
1391 p6_a36 := rosetta_g_miss_num_map(ddx_catv_rec.num_days_hold_adv_pay);
1392 end;
1393
1394 procedure update_row(p_api_version NUMBER
1395 , p_init_msg_list VARCHAR2
1396 , x_return_status out nocopy VARCHAR2
1397 , x_msg_count out nocopy NUMBER
1398 , x_msg_data out nocopy VARCHAR2
1399 , p5_a0 JTF_NUMBER_TABLE
1400 , p5_a1 JTF_NUMBER_TABLE
1401 , p5_a2 JTF_VARCHAR2_TABLE_200
1402 , p5_a3 JTF_VARCHAR2_TABLE_2000
1403 , p5_a4 JTF_DATE_TABLE
1404 , p5_a5 JTF_DATE_TABLE
1405 , p5_a6 JTF_NUMBER_TABLE
1406 , p5_a7 JTF_NUMBER_TABLE
1407 , p5_a8 JTF_NUMBER_TABLE
1408 , p5_a9 JTF_VARCHAR2_TABLE_100
1409 , p5_a10 JTF_VARCHAR2_TABLE_100
1410 , p5_a11 JTF_VARCHAR2_TABLE_100
1411 , p5_a12 JTF_VARCHAR2_TABLE_100
1412 , p5_a13 JTF_VARCHAR2_TABLE_100
1413 , p5_a14 JTF_VARCHAR2_TABLE_500
1414 , p5_a15 JTF_VARCHAR2_TABLE_500
1415 , p5_a16 JTF_VARCHAR2_TABLE_500
1416 , p5_a17 JTF_VARCHAR2_TABLE_500
1417 , p5_a18 JTF_VARCHAR2_TABLE_500
1418 , p5_a19 JTF_VARCHAR2_TABLE_500
1419 , p5_a20 JTF_VARCHAR2_TABLE_500
1420 , p5_a21 JTF_VARCHAR2_TABLE_500
1421 , p5_a22 JTF_VARCHAR2_TABLE_500
1422 , p5_a23 JTF_VARCHAR2_TABLE_500
1423 , p5_a24 JTF_VARCHAR2_TABLE_500
1424 , p5_a25 JTF_VARCHAR2_TABLE_500
1425 , p5_a26 JTF_VARCHAR2_TABLE_500
1426 , p5_a27 JTF_VARCHAR2_TABLE_500
1427 , p5_a28 JTF_VARCHAR2_TABLE_500
1428 , p5_a29 JTF_NUMBER_TABLE
1429 , p5_a30 JTF_NUMBER_TABLE
1430 , p5_a31 JTF_DATE_TABLE
1431 , p5_a32 JTF_NUMBER_TABLE
1432 , p5_a33 JTF_DATE_TABLE
1433 , p5_a34 JTF_NUMBER_TABLE
1434 , p5_a35 JTF_NUMBER_TABLE
1435 , p5_a36 JTF_NUMBER_TABLE
1436 , p6_a0 out nocopy JTF_NUMBER_TABLE
1437 , p6_a1 out nocopy JTF_NUMBER_TABLE
1438 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
1439 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
1440 , p6_a4 out nocopy JTF_DATE_TABLE
1441 , p6_a5 out nocopy JTF_DATE_TABLE
1442 , p6_a6 out nocopy JTF_NUMBER_TABLE
1443 , p6_a7 out nocopy JTF_NUMBER_TABLE
1444 , p6_a8 out nocopy JTF_NUMBER_TABLE
1445 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1446 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1447 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1448 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1449 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1450 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1451 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1452 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1453 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1454 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1455 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1456 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1457 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1458 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1459 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1460 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1461 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1462 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1463 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1464 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1465 , p6_a29 out nocopy JTF_NUMBER_TABLE
1466 , p6_a30 out nocopy JTF_NUMBER_TABLE
1467 , p6_a31 out nocopy JTF_DATE_TABLE
1468 , p6_a32 out nocopy JTF_NUMBER_TABLE
1469 , p6_a33 out nocopy JTF_DATE_TABLE
1470 , p6_a34 out nocopy JTF_NUMBER_TABLE
1471 , p6_a35 out nocopy JTF_NUMBER_TABLE
1472 , p6_a36 out nocopy JTF_NUMBER_TABLE
1473 )
1474
1475 as
1476 ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1477 ddx_catv_tbl okl_cat_pvt.catv_tbl_type;
1478 ddindx binary_integer; indx binary_integer;
1479 begin
1480
1481 -- copy data to the local IN or IN-OUT args, if any
1482
1483
1484
1485
1486
1487 okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1488 , p5_a1
1489 , p5_a2
1490 , p5_a3
1491 , p5_a4
1492 , p5_a5
1493 , p5_a6
1494 , p5_a7
1495 , p5_a8
1496 , p5_a9
1497 , p5_a10
1498 , p5_a11
1499 , p5_a12
1500 , p5_a13
1501 , p5_a14
1502 , p5_a15
1503 , p5_a16
1504 , p5_a17
1505 , p5_a18
1506 , p5_a19
1507 , p5_a20
1508 , p5_a21
1509 , p5_a22
1510 , p5_a23
1511 , p5_a24
1512 , p5_a25
1513 , p5_a26
1514 , p5_a27
1515 , p5_a28
1516 , p5_a29
1517 , p5_a30
1518 , p5_a31
1519 , p5_a32
1520 , p5_a33
1521 , p5_a34
1522 , p5_a35
1523 , p5_a36
1524 );
1525
1526
1527 -- here's the delegated call to the old PL/SQL routine
1528 okl_cat_pvt.update_row(p_api_version,
1529 p_init_msg_list,
1530 x_return_status,
1531 x_msg_count,
1532 x_msg_data,
1533 ddp_catv_tbl,
1534 ddx_catv_tbl);
1535
1536 -- copy data back from the local variables to OUT or IN-OUT args, if any
1537
1538
1539
1540
1541
1542
1543 okl_cat_pvt_w.rosetta_table_copy_out_p5(ddx_catv_tbl, p6_a0
1544 , p6_a1
1545 , p6_a2
1546 , p6_a3
1547 , p6_a4
1548 , p6_a5
1549 , p6_a6
1550 , p6_a7
1551 , p6_a8
1552 , p6_a9
1553 , p6_a10
1554 , p6_a11
1555 , p6_a12
1556 , p6_a13
1557 , p6_a14
1558 , p6_a15
1559 , p6_a16
1560 , p6_a17
1561 , p6_a18
1562 , p6_a19
1563 , p6_a20
1564 , p6_a21
1565 , p6_a22
1566 , p6_a23
1567 , p6_a24
1568 , p6_a25
1569 , p6_a26
1570 , p6_a27
1571 , p6_a28
1572 , p6_a29
1573 , p6_a30
1574 , p6_a31
1575 , p6_a32
1576 , p6_a33
1577 , p6_a34
1578 , p6_a35
1579 , p6_a36
1580 );
1581 end;
1582
1583 procedure delete_row(p_api_version NUMBER
1584 , p_init_msg_list VARCHAR2
1585 , x_return_status out nocopy VARCHAR2
1586 , x_msg_count out nocopy NUMBER
1587 , x_msg_data out nocopy VARCHAR2
1588 , p5_a0 NUMBER := 0-1962.0724
1589 , p5_a1 NUMBER := 0-1962.0724
1590 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1592 , p5_a4 DATE := fnd_api.g_miss_date
1593 , p5_a5 DATE := fnd_api.g_miss_date
1594 , p5_a6 NUMBER := 0-1962.0724
1595 , p5_a7 NUMBER := 0-1962.0724
1596 , p5_a8 NUMBER := 0-1962.0724
1597 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1598 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1599 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1600 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1601 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1602 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1604 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1605 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1606 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1607 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1608 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1609 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1610 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1611 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1612 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1613 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1614 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1615 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1616 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1617 , p5_a29 NUMBER := 0-1962.0724
1618 , p5_a30 NUMBER := 0-1962.0724
1619 , p5_a31 DATE := fnd_api.g_miss_date
1620 , p5_a32 NUMBER := 0-1962.0724
1621 , p5_a33 DATE := fnd_api.g_miss_date
1622 , p5_a34 NUMBER := 0-1962.0724
1623 , p5_a35 NUMBER := 0-1962.0724
1624 , p5_a36 NUMBER := 0-1962.0724
1625 )
1626
1627 as
1628 ddp_catv_rec okl_cat_pvt.catv_rec_type;
1629 ddindx binary_integer; indx binary_integer;
1630 begin
1631
1632 -- copy data to the local IN or IN-OUT args, if any
1633
1634
1635
1636
1637
1638 ddp_catv_rec.id := rosetta_g_miss_num_map(p5_a0);
1639 ddp_catv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1640 ddp_catv_rec.name := p5_a2;
1641 ddp_catv_rec.description := p5_a3;
1642 ddp_catv_rec.start_date := rosetta_g_miss_date_in_map(p5_a4);
1643 ddp_catv_rec.end_date := rosetta_g_miss_date_in_map(p5_a5);
1644 ddp_catv_rec.amount_tolerance_percent := rosetta_g_miss_num_map(p5_a6);
1645 ddp_catv_rec.days_past_quote_valid_toleranc := rosetta_g_miss_num_map(p5_a7);
1646 ddp_catv_rec.months_to_bill_ahead := rosetta_g_miss_num_map(p5_a8);
1647 ddp_catv_rec.under_payment_allocation_code := p5_a9;
1648 ddp_catv_rec.over_payment_allocation_code := p5_a10;
1649 ddp_catv_rec.receipt_msmtch_allocation_code := p5_a11;
1650 ddp_catv_rec.default_rule := p5_a12;
1651 ddp_catv_rec.attribute_category := p5_a13;
1652 ddp_catv_rec.attribute1 := p5_a14;
1653 ddp_catv_rec.attribute2 := p5_a15;
1654 ddp_catv_rec.attribute3 := p5_a16;
1655 ddp_catv_rec.attribute4 := p5_a17;
1656 ddp_catv_rec.attribute5 := p5_a18;
1657 ddp_catv_rec.attribute6 := p5_a19;
1658 ddp_catv_rec.attribute7 := p5_a20;
1659 ddp_catv_rec.attribute8 := p5_a21;
1660 ddp_catv_rec.attribute9 := p5_a22;
1661 ddp_catv_rec.attribute10 := p5_a23;
1662 ddp_catv_rec.attribute11 := p5_a24;
1663 ddp_catv_rec.attribute12 := p5_a25;
1664 ddp_catv_rec.attribute13 := p5_a26;
1665 ddp_catv_rec.attribute14 := p5_a27;
1666 ddp_catv_rec.attribute15 := p5_a28;
1667 ddp_catv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1668 ddp_catv_rec.created_by := rosetta_g_miss_num_map(p5_a30);
1669 ddp_catv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a31);
1670 ddp_catv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a32);
1671 ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1672 ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1673 ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1674 ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1675
1676 -- here's the delegated call to the old PL/SQL routine
1677 okl_cat_pvt.delete_row(p_api_version,
1678 p_init_msg_list,
1679 x_return_status,
1680 x_msg_count,
1681 x_msg_data,
1682 ddp_catv_rec);
1683
1684 -- copy data back from the local variables to OUT or IN-OUT args, if any
1685
1686
1687
1688
1689
1690 end;
1691
1692 procedure delete_row(p_api_version NUMBER
1693 , p_init_msg_list VARCHAR2
1694 , x_return_status out nocopy VARCHAR2
1695 , x_msg_count out nocopy NUMBER
1696 , x_msg_data out nocopy VARCHAR2
1697 , p5_a0 JTF_NUMBER_TABLE
1698 , p5_a1 JTF_NUMBER_TABLE
1699 , p5_a2 JTF_VARCHAR2_TABLE_200
1700 , p5_a3 JTF_VARCHAR2_TABLE_2000
1701 , p5_a4 JTF_DATE_TABLE
1702 , p5_a5 JTF_DATE_TABLE
1703 , p5_a6 JTF_NUMBER_TABLE
1704 , p5_a7 JTF_NUMBER_TABLE
1705 , p5_a8 JTF_NUMBER_TABLE
1706 , p5_a9 JTF_VARCHAR2_TABLE_100
1707 , p5_a10 JTF_VARCHAR2_TABLE_100
1708 , p5_a11 JTF_VARCHAR2_TABLE_100
1709 , p5_a12 JTF_VARCHAR2_TABLE_100
1710 , p5_a13 JTF_VARCHAR2_TABLE_100
1711 , p5_a14 JTF_VARCHAR2_TABLE_500
1712 , p5_a15 JTF_VARCHAR2_TABLE_500
1713 , p5_a16 JTF_VARCHAR2_TABLE_500
1714 , p5_a17 JTF_VARCHAR2_TABLE_500
1715 , p5_a18 JTF_VARCHAR2_TABLE_500
1716 , p5_a19 JTF_VARCHAR2_TABLE_500
1717 , p5_a20 JTF_VARCHAR2_TABLE_500
1718 , p5_a21 JTF_VARCHAR2_TABLE_500
1719 , p5_a22 JTF_VARCHAR2_TABLE_500
1720 , p5_a23 JTF_VARCHAR2_TABLE_500
1721 , p5_a24 JTF_VARCHAR2_TABLE_500
1722 , p5_a25 JTF_VARCHAR2_TABLE_500
1723 , p5_a26 JTF_VARCHAR2_TABLE_500
1724 , p5_a27 JTF_VARCHAR2_TABLE_500
1725 , p5_a28 JTF_VARCHAR2_TABLE_500
1726 , p5_a29 JTF_NUMBER_TABLE
1727 , p5_a30 JTF_NUMBER_TABLE
1728 , p5_a31 JTF_DATE_TABLE
1729 , p5_a32 JTF_NUMBER_TABLE
1730 , p5_a33 JTF_DATE_TABLE
1731 , p5_a34 JTF_NUMBER_TABLE
1732 , p5_a35 JTF_NUMBER_TABLE
1733 , p5_a36 JTF_NUMBER_TABLE
1734 )
1735
1736 as
1737 ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1738 ddindx binary_integer; indx binary_integer;
1739 begin
1740
1741 -- copy data to the local IN or IN-OUT args, if any
1742
1743
1744
1745
1746
1747 okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1748 , p5_a1
1749 , p5_a2
1750 , p5_a3
1751 , p5_a4
1752 , p5_a5
1753 , p5_a6
1754 , p5_a7
1755 , p5_a8
1756 , p5_a9
1757 , p5_a10
1758 , p5_a11
1759 , p5_a12
1760 , p5_a13
1761 , p5_a14
1762 , p5_a15
1763 , p5_a16
1764 , p5_a17
1765 , p5_a18
1766 , p5_a19
1767 , p5_a20
1768 , p5_a21
1769 , p5_a22
1770 , p5_a23
1771 , p5_a24
1772 , p5_a25
1773 , p5_a26
1774 , p5_a27
1775 , p5_a28
1776 , p5_a29
1777 , p5_a30
1778 , p5_a31
1779 , p5_a32
1780 , p5_a33
1781 , p5_a34
1782 , p5_a35
1783 , p5_a36
1784 );
1785
1786 -- here's the delegated call to the old PL/SQL routine
1787 okl_cat_pvt.delete_row(p_api_version,
1788 p_init_msg_list,
1789 x_return_status,
1790 x_msg_count,
1791 x_msg_data,
1792 ddp_catv_tbl);
1793
1794 -- copy data back from the local variables to OUT or IN-OUT args, if any
1795
1796
1797
1798
1799
1800 end;
1801
1802 procedure validate_row(p_api_version NUMBER
1803 , p_init_msg_list VARCHAR2
1804 , x_return_status out nocopy VARCHAR2
1805 , x_msg_count out nocopy NUMBER
1806 , x_msg_data out nocopy VARCHAR2
1807 , p5_a0 NUMBER := 0-1962.0724
1808 , p5_a1 NUMBER := 0-1962.0724
1809 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1810 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1811 , p5_a4 DATE := fnd_api.g_miss_date
1812 , p5_a5 DATE := fnd_api.g_miss_date
1813 , p5_a6 NUMBER := 0-1962.0724
1814 , p5_a7 NUMBER := 0-1962.0724
1815 , p5_a8 NUMBER := 0-1962.0724
1816 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1817 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1818 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1819 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1820 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1821 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1822 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1823 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1824 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1825 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1826 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1827 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1828 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1829 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1830 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1831 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1832 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1833 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1834 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1835 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1836 , p5_a29 NUMBER := 0-1962.0724
1837 , p5_a30 NUMBER := 0-1962.0724
1838 , p5_a31 DATE := fnd_api.g_miss_date
1839 , p5_a32 NUMBER := 0-1962.0724
1840 , p5_a33 DATE := fnd_api.g_miss_date
1841 , p5_a34 NUMBER := 0-1962.0724
1842 , p5_a35 NUMBER := 0-1962.0724
1843 , p5_a36 NUMBER := 0-1962.0724
1844 )
1845
1846 as
1847 ddp_catv_rec okl_cat_pvt.catv_rec_type;
1848 ddindx binary_integer; indx binary_integer;
1849 begin
1850
1851 -- copy data to the local IN or IN-OUT args, if any
1852
1853
1854
1855
1856
1857 ddp_catv_rec.id := rosetta_g_miss_num_map(p5_a0);
1858 ddp_catv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1859 ddp_catv_rec.name := p5_a2;
1860 ddp_catv_rec.description := p5_a3;
1861 ddp_catv_rec.start_date := rosetta_g_miss_date_in_map(p5_a4);
1862 ddp_catv_rec.end_date := rosetta_g_miss_date_in_map(p5_a5);
1863 ddp_catv_rec.amount_tolerance_percent := rosetta_g_miss_num_map(p5_a6);
1864 ddp_catv_rec.days_past_quote_valid_toleranc := rosetta_g_miss_num_map(p5_a7);
1865 ddp_catv_rec.months_to_bill_ahead := rosetta_g_miss_num_map(p5_a8);
1866 ddp_catv_rec.under_payment_allocation_code := p5_a9;
1867 ddp_catv_rec.over_payment_allocation_code := p5_a10;
1868 ddp_catv_rec.receipt_msmtch_allocation_code := p5_a11;
1869 ddp_catv_rec.default_rule := p5_a12;
1870 ddp_catv_rec.attribute_category := p5_a13;
1871 ddp_catv_rec.attribute1 := p5_a14;
1872 ddp_catv_rec.attribute2 := p5_a15;
1873 ddp_catv_rec.attribute3 := p5_a16;
1874 ddp_catv_rec.attribute4 := p5_a17;
1875 ddp_catv_rec.attribute5 := p5_a18;
1876 ddp_catv_rec.attribute6 := p5_a19;
1877 ddp_catv_rec.attribute7 := p5_a20;
1878 ddp_catv_rec.attribute8 := p5_a21;
1879 ddp_catv_rec.attribute9 := p5_a22;
1880 ddp_catv_rec.attribute10 := p5_a23;
1881 ddp_catv_rec.attribute11 := p5_a24;
1882 ddp_catv_rec.attribute12 := p5_a25;
1883 ddp_catv_rec.attribute13 := p5_a26;
1884 ddp_catv_rec.attribute14 := p5_a27;
1885 ddp_catv_rec.attribute15 := p5_a28;
1886 ddp_catv_rec.org_id := rosetta_g_miss_num_map(p5_a29);
1887 ddp_catv_rec.created_by := rosetta_g_miss_num_map(p5_a30);
1888 ddp_catv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a31);
1889 ddp_catv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a32);
1890 ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a33);
1891 ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a34);
1892 ddp_catv_rec.cau_id := rosetta_g_miss_num_map(p5_a35);
1893 ddp_catv_rec.num_days_hold_adv_pay := rosetta_g_miss_num_map(p5_a36);
1894
1895 -- here's the delegated call to the old PL/SQL routine
1896 okl_cat_pvt.validate_row(p_api_version,
1897 p_init_msg_list,
1898 x_return_status,
1899 x_msg_count,
1900 x_msg_data,
1901 ddp_catv_rec);
1902
1903 -- copy data back from the local variables to OUT or IN-OUT args, if any
1904
1905
1906
1907
1908
1909 end;
1910
1911 procedure validate_row(p_api_version NUMBER
1912 , p_init_msg_list VARCHAR2
1913 , x_return_status out nocopy VARCHAR2
1914 , x_msg_count out nocopy NUMBER
1915 , x_msg_data out nocopy VARCHAR2
1916 , p5_a0 JTF_NUMBER_TABLE
1917 , p5_a1 JTF_NUMBER_TABLE
1918 , p5_a2 JTF_VARCHAR2_TABLE_200
1919 , p5_a3 JTF_VARCHAR2_TABLE_2000
1920 , p5_a4 JTF_DATE_TABLE
1921 , p5_a5 JTF_DATE_TABLE
1922 , p5_a6 JTF_NUMBER_TABLE
1923 , p5_a7 JTF_NUMBER_TABLE
1924 , p5_a8 JTF_NUMBER_TABLE
1925 , p5_a9 JTF_VARCHAR2_TABLE_100
1926 , p5_a10 JTF_VARCHAR2_TABLE_100
1927 , p5_a11 JTF_VARCHAR2_TABLE_100
1928 , p5_a12 JTF_VARCHAR2_TABLE_100
1929 , p5_a13 JTF_VARCHAR2_TABLE_100
1930 , p5_a14 JTF_VARCHAR2_TABLE_500
1931 , p5_a15 JTF_VARCHAR2_TABLE_500
1932 , p5_a16 JTF_VARCHAR2_TABLE_500
1933 , p5_a17 JTF_VARCHAR2_TABLE_500
1934 , p5_a18 JTF_VARCHAR2_TABLE_500
1935 , p5_a19 JTF_VARCHAR2_TABLE_500
1936 , p5_a20 JTF_VARCHAR2_TABLE_500
1937 , p5_a21 JTF_VARCHAR2_TABLE_500
1938 , p5_a22 JTF_VARCHAR2_TABLE_500
1939 , p5_a23 JTF_VARCHAR2_TABLE_500
1940 , p5_a24 JTF_VARCHAR2_TABLE_500
1941 , p5_a25 JTF_VARCHAR2_TABLE_500
1942 , p5_a26 JTF_VARCHAR2_TABLE_500
1943 , p5_a27 JTF_VARCHAR2_TABLE_500
1944 , p5_a28 JTF_VARCHAR2_TABLE_500
1945 , p5_a29 JTF_NUMBER_TABLE
1946 , p5_a30 JTF_NUMBER_TABLE
1947 , p5_a31 JTF_DATE_TABLE
1948 , p5_a32 JTF_NUMBER_TABLE
1949 , p5_a33 JTF_DATE_TABLE
1950 , p5_a34 JTF_NUMBER_TABLE
1951 , p5_a35 JTF_NUMBER_TABLE
1952 , p5_a36 JTF_NUMBER_TABLE
1953 )
1954
1955 as
1956 ddp_catv_tbl okl_cat_pvt.catv_tbl_type;
1957 ddindx binary_integer; indx binary_integer;
1958 begin
1959
1960 -- copy data to the local IN or IN-OUT args, if any
1961
1962
1963
1964
1965
1966 okl_cat_pvt_w.rosetta_table_copy_in_p5(ddp_catv_tbl, p5_a0
1967 , p5_a1
1968 , p5_a2
1969 , p5_a3
1970 , p5_a4
1971 , p5_a5
1972 , p5_a6
1973 , p5_a7
1974 , p5_a8
1975 , p5_a9
1976 , p5_a10
1977 , p5_a11
1978 , p5_a12
1979 , p5_a13
1980 , p5_a14
1981 , p5_a15
1982 , p5_a16
1983 , p5_a17
1984 , p5_a18
1985 , p5_a19
1986 , p5_a20
1987 , p5_a21
1988 , p5_a22
1989 , p5_a23
1990 , p5_a24
1991 , p5_a25
1992 , p5_a26
1993 , p5_a27
1994 , p5_a28
1995 , p5_a29
1996 , p5_a30
1997 , p5_a31
1998 , p5_a32
1999 , p5_a33
2000 , p5_a34
2001 , p5_a35
2002 , p5_a36
2003 );
2004
2005 -- here's the delegated call to the old PL/SQL routine
2006 okl_cat_pvt.validate_row(p_api_version,
2007 p_init_msg_list,
2008 x_return_status,
2009 x_msg_count,
2010 x_msg_data,
2011 ddp_catv_tbl);
2012
2013 -- copy data back from the local variables to OUT or IN-OUT args, if any
2014
2015
2016
2017
2018
2019 end;
2020
2021 end okl_cat_pvt_w;