9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_un_proc_pub.adj_tbl_type, a0 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_NUMBER_TABLE
18: , a5 JTF_DATE_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_DATE_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_NUMBER_TABLE
26: , a13 JTF_DATE_TABLE
27: , a14 JTF_VARCHAR2_TABLE_300
254: end loop;
255: end if;
256: end if;
257: end rosetta_table_copy_in_p1;
258: procedure rosetta_table_copy_out_p1(t cn_un_proc_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
259: , a1 out nocopy JTF_DATE_TABLE
260: , a2 out nocopy JTF_NUMBER_TABLE
261: , a3 out nocopy JTF_DATE_TABLE
262: , a4 out nocopy JTF_DATE_TABLE
260: , a2 out nocopy JTF_NUMBER_TABLE
261: , a3 out nocopy JTF_DATE_TABLE
262: , a4 out nocopy JTF_DATE_TABLE
263: , a5 out nocopy JTF_DATE_TABLE
264: , a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , a9 out nocopy JTF_VARCHAR2_TABLE_100
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
261: , a3 out nocopy JTF_DATE_TABLE
262: , a4 out nocopy JTF_DATE_TABLE
263: , a5 out nocopy JTF_DATE_TABLE
264: , a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , a9 out nocopy JTF_VARCHAR2_TABLE_100
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_NUMBER_TABLE
262: , a4 out nocopy JTF_DATE_TABLE
263: , a5 out nocopy JTF_DATE_TABLE
264: , a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , a9 out nocopy JTF_VARCHAR2_TABLE_100
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_NUMBER_TABLE
270: , a12 out nocopy JTF_NUMBER_TABLE
263: , a5 out nocopy JTF_DATE_TABLE
264: , a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , a9 out nocopy JTF_VARCHAR2_TABLE_100
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_NUMBER_TABLE
270: , a12 out nocopy JTF_NUMBER_TABLE
271: , a13 out nocopy JTF_DATE_TABLE
264: , a6 out nocopy JTF_VARCHAR2_TABLE_100
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , a9 out nocopy JTF_VARCHAR2_TABLE_100
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_NUMBER_TABLE
270: , a12 out nocopy JTF_NUMBER_TABLE
271: , a13 out nocopy JTF_DATE_TABLE
272: , a14 out nocopy JTF_VARCHAR2_TABLE_300
372: ) as
373: ddindx binary_integer; indx binary_integer;
374: begin
375: if t is null or t.count = 0 then
376: a0 := JTF_VARCHAR2_TABLE_100();
377: a1 := JTF_DATE_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_DATE_TABLE();
380: a4 := JTF_DATE_TABLE();
378: a2 := JTF_NUMBER_TABLE();
379: a3 := JTF_DATE_TABLE();
380: a4 := JTF_DATE_TABLE();
381: a5 := JTF_DATE_TABLE();
382: a6 := JTF_VARCHAR2_TABLE_100();
383: a7 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_VARCHAR2_TABLE_100();
386: a10 := JTF_VARCHAR2_TABLE_100();
379: a3 := JTF_DATE_TABLE();
380: a4 := JTF_DATE_TABLE();
381: a5 := JTF_DATE_TABLE();
382: a6 := JTF_VARCHAR2_TABLE_100();
383: a7 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_VARCHAR2_TABLE_100();
386: a10 := JTF_VARCHAR2_TABLE_100();
387: a11 := JTF_NUMBER_TABLE();
380: a4 := JTF_DATE_TABLE();
381: a5 := JTF_DATE_TABLE();
382: a6 := JTF_VARCHAR2_TABLE_100();
383: a7 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_VARCHAR2_TABLE_100();
386: a10 := JTF_VARCHAR2_TABLE_100();
387: a11 := JTF_NUMBER_TABLE();
388: a12 := JTF_NUMBER_TABLE();
381: a5 := JTF_DATE_TABLE();
382: a6 := JTF_VARCHAR2_TABLE_100();
383: a7 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_VARCHAR2_TABLE_100();
386: a10 := JTF_VARCHAR2_TABLE_100();
387: a11 := JTF_NUMBER_TABLE();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_DATE_TABLE();
382: a6 := JTF_VARCHAR2_TABLE_100();
383: a7 := JTF_VARCHAR2_TABLE_100();
384: a8 := JTF_VARCHAR2_TABLE_100();
385: a9 := JTF_VARCHAR2_TABLE_100();
386: a10 := JTF_VARCHAR2_TABLE_100();
387: a11 := JTF_NUMBER_TABLE();
388: a12 := JTF_NUMBER_TABLE();
389: a13 := JTF_DATE_TABLE();
390: a14 := JTF_VARCHAR2_TABLE_300();
487: a111 := JTF_VARCHAR2_TABLE_300();
488: a112 := JTF_VARCHAR2_TABLE_300();
489: a113 := JTF_VARCHAR2_TABLE_300();
490: else
491: a0 := JTF_VARCHAR2_TABLE_100();
492: a1 := JTF_DATE_TABLE();
493: a2 := JTF_NUMBER_TABLE();
494: a3 := JTF_DATE_TABLE();
495: a4 := JTF_DATE_TABLE();
493: a2 := JTF_NUMBER_TABLE();
494: a3 := JTF_DATE_TABLE();
495: a4 := JTF_DATE_TABLE();
496: a5 := JTF_DATE_TABLE();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
499: a8 := JTF_VARCHAR2_TABLE_100();
500: a9 := JTF_VARCHAR2_TABLE_100();
501: a10 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_DATE_TABLE();
495: a4 := JTF_DATE_TABLE();
496: a5 := JTF_DATE_TABLE();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
499: a8 := JTF_VARCHAR2_TABLE_100();
500: a9 := JTF_VARCHAR2_TABLE_100();
501: a10 := JTF_VARCHAR2_TABLE_100();
502: a11 := JTF_NUMBER_TABLE();
495: a4 := JTF_DATE_TABLE();
496: a5 := JTF_DATE_TABLE();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
499: a8 := JTF_VARCHAR2_TABLE_100();
500: a9 := JTF_VARCHAR2_TABLE_100();
501: a10 := JTF_VARCHAR2_TABLE_100();
502: a11 := JTF_NUMBER_TABLE();
503: a12 := JTF_NUMBER_TABLE();
496: a5 := JTF_DATE_TABLE();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
499: a8 := JTF_VARCHAR2_TABLE_100();
500: a9 := JTF_VARCHAR2_TABLE_100();
501: a10 := JTF_VARCHAR2_TABLE_100();
502: a11 := JTF_NUMBER_TABLE();
503: a12 := JTF_NUMBER_TABLE();
504: a13 := JTF_DATE_TABLE();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
499: a8 := JTF_VARCHAR2_TABLE_100();
500: a9 := JTF_VARCHAR2_TABLE_100();
501: a10 := JTF_VARCHAR2_TABLE_100();
502: a11 := JTF_NUMBER_TABLE();
503: a12 := JTF_NUMBER_TABLE();
504: a13 := JTF_DATE_TABLE();
505: a14 := JTF_VARCHAR2_TABLE_300();
863: , p_load_status VARCHAR2
864: , p_date_pattern date
865: , p_start_record NUMBER
866: , p_increment_count NUMBER
867: , p20_a0 out nocopy JTF_VARCHAR2_TABLE_100
868: , p20_a1 out nocopy JTF_DATE_TABLE
869: , p20_a2 out nocopy JTF_NUMBER_TABLE
870: , p20_a3 out nocopy JTF_DATE_TABLE
871: , p20_a4 out nocopy JTF_DATE_TABLE
869: , p20_a2 out nocopy JTF_NUMBER_TABLE
870: , p20_a3 out nocopy JTF_DATE_TABLE
871: , p20_a4 out nocopy JTF_DATE_TABLE
872: , p20_a5 out nocopy JTF_DATE_TABLE
873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
874: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100
877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
870: , p20_a3 out nocopy JTF_DATE_TABLE
871: , p20_a4 out nocopy JTF_DATE_TABLE
872: , p20_a5 out nocopy JTF_DATE_TABLE
873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
874: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100
877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
878: , p20_a11 out nocopy JTF_NUMBER_TABLE
871: , p20_a4 out nocopy JTF_DATE_TABLE
872: , p20_a5 out nocopy JTF_DATE_TABLE
873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
874: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100
877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
878: , p20_a11 out nocopy JTF_NUMBER_TABLE
879: , p20_a12 out nocopy JTF_NUMBER_TABLE
872: , p20_a5 out nocopy JTF_DATE_TABLE
873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
874: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100
877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
878: , p20_a11 out nocopy JTF_NUMBER_TABLE
879: , p20_a12 out nocopy JTF_NUMBER_TABLE
880: , p20_a13 out nocopy JTF_DATE_TABLE
873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100
874: , p20_a7 out nocopy JTF_VARCHAR2_TABLE_100
875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100
876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100
877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100
878: , p20_a11 out nocopy JTF_NUMBER_TABLE
879: , p20_a12 out nocopy JTF_NUMBER_TABLE
880: , p20_a13 out nocopy JTF_DATE_TABLE
881: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_300