DBA Data[Home] [Help]

APPS.AHL_WIP_JOB_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 19: , a3 JTF_VARCHAR2_TABLE_300

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_DATE_TABLE

Line 56: , a3 out nocopy JTF_VARCHAR2_TABLE_300

52: end rosetta_table_copy_in_p2;
53: procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_NUMBER_TABLE
56: , a3 out nocopy JTF_VARCHAR2_TABLE_300
57: , a4 out nocopy JTF_NUMBER_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_DATE_TABLE

Line 70: a3 := JTF_VARCHAR2_TABLE_300();

66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_VARCHAR2_TABLE_300();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_DATE_TABLE();

Line 81: a3 := JTF_VARCHAR2_TABLE_300();

77: else
78: a0 := JTF_NUMBER_TABLE();
79: a1 := JTF_NUMBER_TABLE();
80: a2 := JTF_NUMBER_TABLE();
81: a3 := JTF_VARCHAR2_TABLE_300();
82: a4 := JTF_NUMBER_TABLE();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_DATE_TABLE();

Line 139: , a17 JTF_VARCHAR2_TABLE_300

135: , a13 JTF_NUMBER_TABLE
136: , a14 JTF_NUMBER_TABLE
137: , a15 JTF_NUMBER_TABLE
138: , a16 JTF_NUMBER_TABLE
139: , a17 JTF_VARCHAR2_TABLE_300
140: , a18 JTF_DATE_TABLE
141: , a19 JTF_DATE_TABLE
142: , a20 JTF_NUMBER_TABLE
143: , a21 JTF_VARCHAR2_TABLE_100

Line 200: , a17 out nocopy JTF_VARCHAR2_TABLE_300

196: , a13 out nocopy JTF_NUMBER_TABLE
197: , a14 out nocopy JTF_NUMBER_TABLE
198: , a15 out nocopy JTF_NUMBER_TABLE
199: , a16 out nocopy JTF_NUMBER_TABLE
200: , a17 out nocopy JTF_VARCHAR2_TABLE_300
201: , a18 out nocopy JTF_DATE_TABLE
202: , a19 out nocopy JTF_DATE_TABLE
203: , a20 out nocopy JTF_NUMBER_TABLE
204: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 226: a17 := JTF_VARCHAR2_TABLE_300();

222: a13 := JTF_NUMBER_TABLE();
223: a14 := JTF_NUMBER_TABLE();
224: a15 := JTF_NUMBER_TABLE();
225: a16 := JTF_NUMBER_TABLE();
226: a17 := JTF_VARCHAR2_TABLE_300();
227: a18 := JTF_DATE_TABLE();
228: a19 := JTF_DATE_TABLE();
229: a20 := JTF_NUMBER_TABLE();
230: a21 := JTF_VARCHAR2_TABLE_100();

Line 249: a17 := JTF_VARCHAR2_TABLE_300();

245: a13 := JTF_NUMBER_TABLE();
246: a14 := JTF_NUMBER_TABLE();
247: a15 := JTF_NUMBER_TABLE();
248: a16 := JTF_NUMBER_TABLE();
249: a17 := JTF_VARCHAR2_TABLE_300();
250: a18 := JTF_DATE_TABLE();
251: a19 := JTF_DATE_TABLE();
252: a20 := JTF_NUMBER_TABLE();
253: a21 := JTF_VARCHAR2_TABLE_100();

Line 447: , a15 JTF_VARCHAR2_TABLE_300

443: , a11 JTF_VARCHAR2_TABLE_100
444: , a12 JTF_NUMBER_TABLE
445: , a13 JTF_VARCHAR2_TABLE_100
446: , a14 JTF_VARCHAR2_TABLE_100
447: , a15 JTF_VARCHAR2_TABLE_300
448: ) as
449: ddindx binary_integer; indx binary_integer;
450: begin
451: if a0 is not null and a0.count > 0 then

Line 496: , a15 out nocopy JTF_VARCHAR2_TABLE_300

492: , a11 out nocopy JTF_VARCHAR2_TABLE_100
493: , a12 out nocopy JTF_NUMBER_TABLE
494: , a13 out nocopy JTF_VARCHAR2_TABLE_100
495: , a14 out nocopy JTF_VARCHAR2_TABLE_100
496: , a15 out nocopy JTF_VARCHAR2_TABLE_300
497: ) as
498: ddindx binary_integer; indx binary_integer;
499: begin
500: if t is null or t.count = 0 then

Line 516: a15 := JTF_VARCHAR2_TABLE_300();

512: a11 := JTF_VARCHAR2_TABLE_100();
513: a12 := JTF_NUMBER_TABLE();
514: a13 := JTF_VARCHAR2_TABLE_100();
515: a14 := JTF_VARCHAR2_TABLE_100();
516: a15 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_NUMBER_TABLE();
520: a2 := JTF_NUMBER_TABLE();

Line 533: a15 := JTF_VARCHAR2_TABLE_300();

529: a11 := JTF_VARCHAR2_TABLE_100();
530: a12 := JTF_NUMBER_TABLE();
531: a13 := JTF_VARCHAR2_TABLE_100();
532: a14 := JTF_VARCHAR2_TABLE_100();
533: a15 := JTF_VARCHAR2_TABLE_300();
534: if t.count > 0 then
535: a0.extend(t.count);
536: a1.extend(t.count);
537: a2.extend(t.count);

Line 581: , a1 JTF_VARCHAR2_TABLE_300

577: end if;
578: end rosetta_table_copy_out_p8;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE
581: , a1 JTF_VARCHAR2_TABLE_300
582: , a2 JTF_NUMBER_TABLE
583: , a3 JTF_VARCHAR2_TABLE_32767
584: ) as
585: ddindx binary_integer; indx binary_integer;

Line 606: , a1 out nocopy JTF_VARCHAR2_TABLE_300

602: end if;
603: end if;
604: end rosetta_table_copy_in_p10;
605: procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
606: , a1 out nocopy JTF_VARCHAR2_TABLE_300
607: , a2 out nocopy JTF_NUMBER_TABLE
608: , a3 out nocopy JTF_VARCHAR2_TABLE_32767
609: ) as
610: ddindx binary_integer; indx binary_integer;

Line 614: a1 := JTF_VARCHAR2_TABLE_300();

610: ddindx binary_integer; indx binary_integer;
611: begin
612: if t is null or t.count = 0 then
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_300();
615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
618: a0 := JTF_NUMBER_TABLE();

Line 619: a1 := JTF_VARCHAR2_TABLE_300();

615: a2 := JTF_NUMBER_TABLE();
616: a3 := JTF_VARCHAR2_TABLE_32767();
617: else
618: a0 := JTF_NUMBER_TABLE();
619: a1 := JTF_VARCHAR2_TABLE_300();
620: a2 := JTF_NUMBER_TABLE();
621: a3 := JTF_VARCHAR2_TABLE_32767();
622: if t.count > 0 then
623: a0.extend(t.count);

Line 677: , p7_a3 JTF_VARCHAR2_TABLE_300

673: , p6_a23 VARCHAR2
674: , p7_a0 JTF_NUMBER_TABLE
675: , p7_a1 JTF_NUMBER_TABLE
676: , p7_a2 JTF_NUMBER_TABLE
677: , p7_a3 JTF_VARCHAR2_TABLE_300
678: , p7_a4 JTF_NUMBER_TABLE
679: , p7_a5 JTF_NUMBER_TABLE
680: , p7_a6 JTF_NUMBER_TABLE
681: , p7_a7 JTF_DATE_TABLE

Line 701: , p8_a17 JTF_VARCHAR2_TABLE_300

697: , p8_a13 JTF_NUMBER_TABLE
698: , p8_a14 JTF_NUMBER_TABLE
699: , p8_a15 JTF_NUMBER_TABLE
700: , p8_a16 JTF_NUMBER_TABLE
701: , p8_a17 JTF_VARCHAR2_TABLE_300
702: , p8_a18 JTF_DATE_TABLE
703: , p8_a19 JTF_DATE_TABLE
704: , p8_a20 JTF_NUMBER_TABLE
705: , p8_a21 JTF_VARCHAR2_TABLE_100

Line 860: , p7_a15 JTF_VARCHAR2_TABLE_300

856: , p7_a11 JTF_VARCHAR2_TABLE_100
857: , p7_a12 JTF_NUMBER_TABLE
858: , p7_a13 JTF_VARCHAR2_TABLE_100
859: , p7_a14 JTF_VARCHAR2_TABLE_100
860: , p7_a15 JTF_VARCHAR2_TABLE_300
861: )
862:
863: as
864: ddp_ahl_res_txn_tbl ahl_wip_job_pvt.ahl_res_txn_tbl_type;

Line 973: , p10_a3 JTF_VARCHAR2_TABLE_300

969: , p9_a23 VARCHAR2
970: , p10_a0 JTF_NUMBER_TABLE
971: , p10_a1 JTF_NUMBER_TABLE
972: , p10_a2 JTF_NUMBER_TABLE
973: , p10_a3 JTF_VARCHAR2_TABLE_300
974: , p10_a4 JTF_NUMBER_TABLE
975: , p10_a5 JTF_NUMBER_TABLE
976: , p10_a6 JTF_NUMBER_TABLE
977: , p10_a7 JTF_DATE_TABLE

Line 997: , p11_a17 JTF_VARCHAR2_TABLE_300

993: , p11_a13 JTF_NUMBER_TABLE
994: , p11_a14 JTF_NUMBER_TABLE
995: , p11_a15 JTF_NUMBER_TABLE
996: , p11_a16 JTF_NUMBER_TABLE
997: , p11_a17 JTF_VARCHAR2_TABLE_300
998: , p11_a18 JTF_DATE_TABLE
999: , p11_a19 JTF_DATE_TABLE
1000: , p11_a20 JTF_NUMBER_TABLE
1001: , p11_a21 JTF_VARCHAR2_TABLE_100

Line 1017: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300

1013: , p12_a11 JTF_VARCHAR2_TABLE_100
1014: , x_group_id out nocopy NUMBER
1015: , x_header_id out nocopy NUMBER
1016: , p15_a0 out nocopy JTF_NUMBER_TABLE
1017: , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
1018: , p15_a2 out nocopy JTF_NUMBER_TABLE
1019: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_32767
1020: )
1021: