DBA Data[Home] [Help]

APPS.CN_UN_PROC_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_un_proc_pub.adj_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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

Line 19: , a6 JTF_VARCHAR2_TABLE_100

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

Line 20: , a7 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

Line 21: , a8 JTF_VARCHAR2_TABLE_100

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

Line 22: , a9 JTF_VARCHAR2_TABLE_100

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

Line 23: , a10 JTF_VARCHAR2_TABLE_100

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

Line 258: procedure rosetta_table_copy_out_p1(t cn_un_proc_pub.adj_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 264: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 265: , a7 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

Line 266: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 267: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 268: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 376: a0 := JTF_VARCHAR2_TABLE_100();

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();

Line 382: a6 := JTF_VARCHAR2_TABLE_100();

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();

Line 383: a7 := 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();

Line 384: a8 := JTF_VARCHAR2_TABLE_100();

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();

Line 385: a9 := JTF_VARCHAR2_TABLE_100();

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();

Line 386: a10 := JTF_VARCHAR2_TABLE_100();

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();

Line 491: a0 := JTF_VARCHAR2_TABLE_100();

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();

Line 497: a6 := JTF_VARCHAR2_TABLE_100();

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();

Line 498: a7 := 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();

Line 499: a8 := JTF_VARCHAR2_TABLE_100();

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();

Line 500: a9 := JTF_VARCHAR2_TABLE_100();

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();

Line 501: a10 := JTF_VARCHAR2_TABLE_100();

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();

Line 867: , p20_a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 873: , p20_a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 874: , p20_a7 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

Line 875: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 876: , p20_a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 877: , p20_a10 out nocopy JTF_VARCHAR2_TABLE_100

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