DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 30: , a14 JTF_VARCHAR2_TABLE_300

26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_200
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_DATE_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100

Line 76: , a60 JTF_VARCHAR2_TABLE_3000

72: , a56 JTF_VARCHAR2_TABLE_200
73: , a57 JTF_VARCHAR2_TABLE_200
74: , a58 JTF_VARCHAR2_TABLE_200
75: , a59 JTF_NUMBER_TABLE
76: , a60 JTF_VARCHAR2_TABLE_3000
77: , a61 JTF_VARCHAR2_TABLE_100
78: , a62 JTF_VARCHAR2_TABLE_100
79: ) as
80: ddindx binary_integer; indx binary_integer;

Line 173: , a14 out nocopy JTF_VARCHAR2_TABLE_300

169: , a10 out nocopy JTF_NUMBER_TABLE
170: , a11 out nocopy JTF_VARCHAR2_TABLE_200
171: , a12 out nocopy JTF_NUMBER_TABLE
172: , a13 out nocopy JTF_VARCHAR2_TABLE_100
173: , a14 out nocopy JTF_VARCHAR2_TABLE_300
174: , a15 out nocopy JTF_NUMBER_TABLE
175: , a16 out nocopy JTF_NUMBER_TABLE
176: , a17 out nocopy JTF_DATE_TABLE
177: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 219: , a60 out nocopy JTF_VARCHAR2_TABLE_3000

215: , a56 out nocopy JTF_VARCHAR2_TABLE_200
216: , a57 out nocopy JTF_VARCHAR2_TABLE_200
217: , a58 out nocopy JTF_VARCHAR2_TABLE_200
218: , a59 out nocopy JTF_NUMBER_TABLE
219: , a60 out nocopy JTF_VARCHAR2_TABLE_3000
220: , a61 out nocopy JTF_VARCHAR2_TABLE_100
221: , a62 out nocopy JTF_VARCHAR2_TABLE_100
222: ) as
223: ddindx binary_integer; indx binary_integer;

Line 240: a14 := JTF_VARCHAR2_TABLE_300();

236: a10 := JTF_NUMBER_TABLE();
237: a11 := JTF_VARCHAR2_TABLE_200();
238: a12 := JTF_NUMBER_TABLE();
239: a13 := JTF_VARCHAR2_TABLE_100();
240: a14 := JTF_VARCHAR2_TABLE_300();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_NUMBER_TABLE();
243: a17 := JTF_DATE_TABLE();
244: a18 := JTF_VARCHAR2_TABLE_100();

Line 286: a60 := JTF_VARCHAR2_TABLE_3000();

282: a56 := JTF_VARCHAR2_TABLE_200();
283: a57 := JTF_VARCHAR2_TABLE_200();
284: a58 := JTF_VARCHAR2_TABLE_200();
285: a59 := JTF_NUMBER_TABLE();
286: a60 := JTF_VARCHAR2_TABLE_3000();
287: a61 := JTF_VARCHAR2_TABLE_100();
288: a62 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();

Line 304: a14 := JTF_VARCHAR2_TABLE_300();

300: a10 := JTF_NUMBER_TABLE();
301: a11 := JTF_VARCHAR2_TABLE_200();
302: a12 := JTF_NUMBER_TABLE();
303: a13 := JTF_VARCHAR2_TABLE_100();
304: a14 := JTF_VARCHAR2_TABLE_300();
305: a15 := JTF_NUMBER_TABLE();
306: a16 := JTF_NUMBER_TABLE();
307: a17 := JTF_DATE_TABLE();
308: a18 := JTF_VARCHAR2_TABLE_100();

Line 350: a60 := JTF_VARCHAR2_TABLE_3000();

346: a56 := JTF_VARCHAR2_TABLE_200();
347: a57 := JTF_VARCHAR2_TABLE_200();
348: a58 := JTF_VARCHAR2_TABLE_200();
349: a59 := JTF_NUMBER_TABLE();
350: a60 := JTF_VARCHAR2_TABLE_3000();
351: a61 := JTF_VARCHAR2_TABLE_100();
352: a62 := JTF_VARCHAR2_TABLE_100();
353: if t.count > 0 then
354: a0.extend(t.count);

Line 497: , a4 JTF_VARCHAR2_TABLE_300

493: procedure rosetta_table_copy_in_p3(t out nocopy ahl_pp_materials_pvt.sch_material_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: , a2 JTF_NUMBER_TABLE
496: , a3 JTF_VARCHAR2_TABLE_100
497: , a4 JTF_VARCHAR2_TABLE_300
498: , a5 JTF_NUMBER_TABLE
499: , a6 JTF_NUMBER_TABLE
500: , a7 JTF_NUMBER_TABLE
501: , a8 JTF_NUMBER_TABLE

Line 562: , a4 out nocopy JTF_VARCHAR2_TABLE_300

558: procedure rosetta_table_copy_out_p3(t ahl_pp_materials_pvt.sch_material_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_NUMBER_TABLE
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , a4 out nocopy JTF_VARCHAR2_TABLE_300
563: , a5 out nocopy JTF_NUMBER_TABLE
564: , a6 out nocopy JTF_NUMBER_TABLE
565: , a7 out nocopy JTF_NUMBER_TABLE
566: , a8 out nocopy JTF_NUMBER_TABLE

Line 590: a4 := JTF_VARCHAR2_TABLE_300();

586: a0 := JTF_NUMBER_TABLE();
587: a1 := JTF_NUMBER_TABLE();
588: a2 := JTF_NUMBER_TABLE();
589: a3 := JTF_VARCHAR2_TABLE_100();
590: a4 := JTF_VARCHAR2_TABLE_300();
591: a5 := JTF_NUMBER_TABLE();
592: a6 := JTF_NUMBER_TABLE();
593: a7 := JTF_NUMBER_TABLE();
594: a8 := JTF_NUMBER_TABLE();

Line 615: a4 := JTF_VARCHAR2_TABLE_300();

611: a0 := JTF_NUMBER_TABLE();
612: a1 := JTF_NUMBER_TABLE();
613: a2 := JTF_NUMBER_TABLE();
614: a3 := JTF_VARCHAR2_TABLE_100();
615: a4 := JTF_VARCHAR2_TABLE_300();
616: a5 := JTF_NUMBER_TABLE();
617: a6 := JTF_NUMBER_TABLE();
618: a7 := JTF_NUMBER_TABLE();
619: a8 := JTF_NUMBER_TABLE();

Line 716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300

712: , p5_a10 in out nocopy JTF_NUMBER_TABLE
713: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
714: , p5_a12 in out nocopy JTF_NUMBER_TABLE
715: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
717: , p5_a15 in out nocopy JTF_NUMBER_TABLE
718: , p5_a16 in out nocopy JTF_NUMBER_TABLE
719: , p5_a17 in out nocopy JTF_DATE_TABLE
720: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 762: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000

758: , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
759: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
760: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
761: , p5_a59 in out nocopy JTF_NUMBER_TABLE
762: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
763: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
764: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
765: , x_job_return_status out nocopy VARCHAR2
766: , x_return_status out nocopy VARCHAR2

Line 958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300

954: , p5_a10 in out nocopy JTF_NUMBER_TABLE
955: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a12 in out nocopy JTF_NUMBER_TABLE
957: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
958: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_300
959: , p5_a15 in out nocopy JTF_NUMBER_TABLE
960: , p5_a16 in out nocopy JTF_NUMBER_TABLE
961: , p5_a17 in out nocopy JTF_DATE_TABLE
962: , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1004: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000

1000: , p5_a56 in out nocopy JTF_VARCHAR2_TABLE_200
1001: , p5_a57 in out nocopy JTF_VARCHAR2_TABLE_200
1002: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_200
1003: , p5_a59 in out nocopy JTF_NUMBER_TABLE
1004: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_3000
1005: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_100
1006: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
1007: , x_return_status out nocopy VARCHAR2
1008: , x_msg_count out nocopy NUMBER

Line 1434: , p4_a14 JTF_VARCHAR2_TABLE_300

1430: , p4_a10 JTF_NUMBER_TABLE
1431: , p4_a11 JTF_VARCHAR2_TABLE_200
1432: , p4_a12 JTF_NUMBER_TABLE
1433: , p4_a13 JTF_VARCHAR2_TABLE_100
1434: , p4_a14 JTF_VARCHAR2_TABLE_300
1435: , p4_a15 JTF_NUMBER_TABLE
1436: , p4_a16 JTF_NUMBER_TABLE
1437: , p4_a17 JTF_DATE_TABLE
1438: , p4_a18 JTF_VARCHAR2_TABLE_100

Line 1480: , p4_a60 JTF_VARCHAR2_TABLE_3000

1476: , p4_a56 JTF_VARCHAR2_TABLE_200
1477: , p4_a57 JTF_VARCHAR2_TABLE_200
1478: , p4_a58 JTF_VARCHAR2_TABLE_200
1479: , p4_a59 JTF_NUMBER_TABLE
1480: , p4_a60 JTF_VARCHAR2_TABLE_3000
1481: , p4_a61 JTF_VARCHAR2_TABLE_100
1482: , p4_a62 JTF_VARCHAR2_TABLE_100
1483: , x_return_status out nocopy VARCHAR2
1484: , x_msg_count out nocopy NUMBER