eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MM_MTL_MGT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as

1: package body ahl_mm_mtl_mgt_pvt_w as
2: /* $Header: AHLWMMGB.pls 120.0.12020000.2 2012/12/13 05:58:33 shnatu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 JTF_VARCHAR2_TABLE_100) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is null then
7: t := null;

Line 27: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

23: end loop;
24: end if;
25: end if;
26: end rosetta_table_copy_in_p2;
27: procedure rosetta_table_copy_out_p2(t ahl_mm_mtl_mgt_pvt.oaf_varchar2_table_100, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if t is null then
31: a0 := null;

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

29: begin
30: if t is null then
31: a0 := null;
32: elsif t.count = 0 then
33: a0 := JTF_VARCHAR2_TABLE_100();
34: else
35: a0 := JTF_VARCHAR2_TABLE_100();
36: if t.count > 0 then
37: a0.extend(t.count);

Line 35: a0 := JTF_VARCHAR2_TABLE_100();

31: a0 := null;
32: elsif t.count = 0 then
33: a0 := JTF_VARCHAR2_TABLE_100();
34: else
35: a0 := JTF_VARCHAR2_TABLE_100();
36: if t.count > 0 then
37: a0.extend(t.count);
38: ddindx := t.first;
39: indx := 1;

Line 102: , a1 JTF_VARCHAR2_TABLE_100

98: end if;
99: end rosetta_table_copy_out_p3;
100:
101: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_VARCHAR2_TABLE_100
103: , a2 JTF_NUMBER_TABLE
104: , a3 JTF_VARCHAR2_TABLE_100
105: , a4 JTF_NUMBER_TABLE
106: , a5 JTF_NUMBER_TABLE

Line 104: , a3 JTF_VARCHAR2_TABLE_100

100:
101: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_VARCHAR2_TABLE_100
103: , a2 JTF_NUMBER_TABLE
104: , a3 JTF_VARCHAR2_TABLE_100
105: , a4 JTF_NUMBER_TABLE
106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_100
108: , a7 JTF_NUMBER_TABLE

Line 107: , a6 JTF_VARCHAR2_TABLE_100

103: , a2 JTF_NUMBER_TABLE
104: , a3 JTF_VARCHAR2_TABLE_100
105: , a4 JTF_NUMBER_TABLE
106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_100
108: , a7 JTF_NUMBER_TABLE
109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100
111: , a10 JTF_VARCHAR2_TABLE_100

Line 110: , a9 JTF_VARCHAR2_TABLE_100

106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_100
108: , a7 JTF_NUMBER_TABLE
109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100
111: , a10 JTF_VARCHAR2_TABLE_100
112: , a11 JTF_VARCHAR2_TABLE_100
113: , a12 JTF_VARCHAR2_TABLE_100
114: ) as

Line 111: , a10 JTF_VARCHAR2_TABLE_100

107: , a6 JTF_VARCHAR2_TABLE_100
108: , a7 JTF_NUMBER_TABLE
109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100
111: , a10 JTF_VARCHAR2_TABLE_100
112: , a11 JTF_VARCHAR2_TABLE_100
113: , a12 JTF_VARCHAR2_TABLE_100
114: ) as
115: ddindx binary_integer; indx binary_integer;

Line 112: , a11 JTF_VARCHAR2_TABLE_100

108: , a7 JTF_NUMBER_TABLE
109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100
111: , a10 JTF_VARCHAR2_TABLE_100
112: , a11 JTF_VARCHAR2_TABLE_100
113: , a12 JTF_VARCHAR2_TABLE_100
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin

Line 113: , a12 JTF_VARCHAR2_TABLE_100

109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100
111: , a10 JTF_VARCHAR2_TABLE_100
112: , a11 JTF_VARCHAR2_TABLE_100
113: , a12 JTF_VARCHAR2_TABLE_100
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if a0 is not null and a0.count=0 then

Line 149: , a1 out nocopy JTF_VARCHAR2_TABLE_100

145: end if;
146: end if;
147: end rosetta_table_copy_in_p10;
148: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_VARCHAR2_TABLE_100
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_100
152: , a4 out nocopy JTF_NUMBER_TABLE
153: , a5 out nocopy JTF_NUMBER_TABLE

Line 151: , a3 out nocopy JTF_VARCHAR2_TABLE_100

147: end rosetta_table_copy_in_p10;
148: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_VARCHAR2_TABLE_100
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_100
152: , a4 out nocopy JTF_NUMBER_TABLE
153: , a5 out nocopy JTF_NUMBER_TABLE
154: , a6 out nocopy JTF_VARCHAR2_TABLE_100
155: , a7 out nocopy JTF_NUMBER_TABLE

Line 154: , a6 out nocopy JTF_VARCHAR2_TABLE_100

150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_100
152: , a4 out nocopy JTF_NUMBER_TABLE
153: , a5 out nocopy JTF_NUMBER_TABLE
154: , a6 out nocopy JTF_VARCHAR2_TABLE_100
155: , a7 out nocopy JTF_NUMBER_TABLE
156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100
158: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 157: , a9 out nocopy JTF_VARCHAR2_TABLE_100

153: , a5 out nocopy JTF_NUMBER_TABLE
154: , a6 out nocopy JTF_VARCHAR2_TABLE_100
155: , a7 out nocopy JTF_NUMBER_TABLE
156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100
158: , a10 out nocopy JTF_VARCHAR2_TABLE_100
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100
160: , a12 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as

Line 158: , a10 out nocopy JTF_VARCHAR2_TABLE_100

154: , a6 out nocopy JTF_VARCHAR2_TABLE_100
155: , a7 out nocopy JTF_NUMBER_TABLE
156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100
158: , a10 out nocopy JTF_VARCHAR2_TABLE_100
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100
160: , a12 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;

Line 159: , a11 out nocopy JTF_VARCHAR2_TABLE_100

155: , a7 out nocopy JTF_NUMBER_TABLE
156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100
158: , a10 out nocopy JTF_VARCHAR2_TABLE_100
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100
160: , a12 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin

Line 160: , a12 out nocopy JTF_VARCHAR2_TABLE_100

156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100
158: , a10 out nocopy JTF_VARCHAR2_TABLE_100
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100
160: , a12 out nocopy JTF_VARCHAR2_TABLE_100
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null then

Line 180: a1 := JTF_VARCHAR2_TABLE_100();

176: a11 := null;
177: a12 := null;
178: elsif t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_NUMBER_TABLE();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();
184: a5 := JTF_NUMBER_TABLE();

Line 182: a3 := JTF_VARCHAR2_TABLE_100();

178: elsif t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_VARCHAR2_TABLE_100();
181: a2 := JTF_NUMBER_TABLE();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_NUMBER_TABLE();

Line 185: a6 := JTF_VARCHAR2_TABLE_100();

181: a2 := JTF_NUMBER_TABLE();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();
184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();

Line 188: a9 := JTF_VARCHAR2_TABLE_100();

184: a5 := JTF_NUMBER_TABLE();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: else

Line 189: a10 := JTF_VARCHAR2_TABLE_100();

185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: else
193: a0 := JTF_NUMBER_TABLE();

Line 190: a11 := JTF_VARCHAR2_TABLE_100();

186: a7 := JTF_NUMBER_TABLE();
187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: else
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_VARCHAR2_TABLE_100();

Line 191: a12 := JTF_VARCHAR2_TABLE_100();

187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_VARCHAR2_TABLE_100();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: else
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_VARCHAR2_TABLE_100();
195: a2 := JTF_NUMBER_TABLE();

Line 194: a1 := JTF_VARCHAR2_TABLE_100();

190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();
192: else
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_VARCHAR2_TABLE_100();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_NUMBER_TABLE();
198: a5 := JTF_NUMBER_TABLE();

Line 196: a3 := JTF_VARCHAR2_TABLE_100();

192: else
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_VARCHAR2_TABLE_100();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_NUMBER_TABLE();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();

Line 199: a6 := JTF_VARCHAR2_TABLE_100();

195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_NUMBER_TABLE();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();

Line 202: a9 := JTF_VARCHAR2_TABLE_100();

198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_VARCHAR2_TABLE_100();
206: if t.count > 0 then

Line 203: a10 := JTF_VARCHAR2_TABLE_100();

199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_VARCHAR2_TABLE_100();
206: if t.count > 0 then
207: a0.extend(t.count);

Line 204: a11 := JTF_VARCHAR2_TABLE_100();

200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_VARCHAR2_TABLE_100();
206: if t.count > 0 then
207: a0.extend(t.count);
208: a1.extend(t.count);

Line 205: a12 := JTF_VARCHAR2_TABLE_100();

201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_VARCHAR2_TABLE_100();
206: if t.count > 0 then
207: a0.extend(t.count);
208: a1.extend(t.count);
209: a2.extend(t.count);

Line 359: , a1 JTF_VARCHAR2_TABLE_100

355: end if;
356: end rosetta_table_copy_out_p12;
357:
358: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
359: , a1 JTF_VARCHAR2_TABLE_100
360: , a2 JTF_NUMBER_TABLE
361: , a3 JTF_VARCHAR2_TABLE_100
362: ) as
363: ddindx binary_integer; indx binary_integer;

Line 361: , a3 JTF_VARCHAR2_TABLE_100

357:
358: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE
359: , a1 JTF_VARCHAR2_TABLE_100
360: , a2 JTF_NUMBER_TABLE
361: , a3 JTF_VARCHAR2_TABLE_100
362: ) as
363: ddindx binary_integer; indx binary_integer;
364: begin
365: if a0 is not null and a0.count > 0 then

Line 384: , a1 out nocopy JTF_VARCHAR2_TABLE_100

380: end if;
381: end if;
382: end rosetta_table_copy_in_p13;
383: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
384: , a1 out nocopy JTF_VARCHAR2_TABLE_100
385: , a2 out nocopy JTF_NUMBER_TABLE
386: , a3 out nocopy JTF_VARCHAR2_TABLE_100
387: ) as
388: ddindx binary_integer; indx binary_integer;

Line 386: , a3 out nocopy JTF_VARCHAR2_TABLE_100

382: end rosetta_table_copy_in_p13;
383: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
384: , a1 out nocopy JTF_VARCHAR2_TABLE_100
385: , a2 out nocopy JTF_NUMBER_TABLE
386: , a3 out nocopy JTF_VARCHAR2_TABLE_100
387: ) as
388: ddindx binary_integer; indx binary_integer;
389: begin
390: if t is null or t.count = 0 then

Line 392: a1 := JTF_VARCHAR2_TABLE_100();

388: ddindx binary_integer; indx binary_integer;
389: begin
390: if t is null or t.count = 0 then
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_VARCHAR2_TABLE_100();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_VARCHAR2_TABLE_100();
395: else
396: a0 := JTF_NUMBER_TABLE();

Line 394: a3 := JTF_VARCHAR2_TABLE_100();

390: if t is null or t.count = 0 then
391: a0 := JTF_NUMBER_TABLE();
392: a1 := JTF_VARCHAR2_TABLE_100();
393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_VARCHAR2_TABLE_100();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_VARCHAR2_TABLE_100();
398: a2 := JTF_NUMBER_TABLE();

Line 397: a1 := JTF_VARCHAR2_TABLE_100();

393: a2 := JTF_NUMBER_TABLE();
394: a3 := JTF_VARCHAR2_TABLE_100();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_VARCHAR2_TABLE_100();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_VARCHAR2_TABLE_100();
400: if t.count > 0 then
401: a0.extend(t.count);

Line 399: a3 := JTF_VARCHAR2_TABLE_100();

395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_VARCHAR2_TABLE_100();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_VARCHAR2_TABLE_100();
400: if t.count > 0 then
401: a0.extend(t.count);
402: a1.extend(t.count);
403: a2.extend(t.count);

Line 423: , a1 JTF_VARCHAR2_TABLE_100

419: end if;
420: end rosetta_table_copy_out_p13;
421:
422: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE
423: , a1 JTF_VARCHAR2_TABLE_100
424: , a2 JTF_NUMBER_TABLE
425: ) as
426: ddindx binary_integer; indx binary_integer;
427: begin

Line 446: , a1 out nocopy JTF_VARCHAR2_TABLE_100

442: end if;
443: end if;
444: end rosetta_table_copy_in_p14;
445: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
446: , a1 out nocopy JTF_VARCHAR2_TABLE_100
447: , a2 out nocopy JTF_NUMBER_TABLE
448: ) as
449: ddindx binary_integer; indx binary_integer;
450: begin

Line 453: a1 := JTF_VARCHAR2_TABLE_100();

449: ddindx binary_integer; indx binary_integer;
450: begin
451: if t is null or t.count = 0 then
452: a0 := JTF_NUMBER_TABLE();
453: a1 := JTF_VARCHAR2_TABLE_100();
454: a2 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_100();

Line 457: a1 := JTF_VARCHAR2_TABLE_100();

453: a1 := JTF_VARCHAR2_TABLE_100();
454: a2 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_100();
458: a2 := JTF_NUMBER_TABLE();
459: if t.count > 0 then
460: a0.extend(t.count);
461: a1.extend(t.count);

Line 773: , p5_a1 JTF_VARCHAR2_TABLE_100

769: , p_commit VARCHAR2
770: , p_validation_level NUMBER
771: , p_scheduled_material_id NUMBER
772: , p5_a0 JTF_NUMBER_TABLE
773: , p5_a1 JTF_VARCHAR2_TABLE_100
774: , p5_a2 JTF_NUMBER_TABLE
775: , p5_a3 JTF_VARCHAR2_TABLE_100
776: , x_mo_hdr_id out nocopy NUMBER
777: , x_mo_lines_tbl out nocopy JTF_NUMBER_TABLE

Line 775: , p5_a3 JTF_VARCHAR2_TABLE_100

771: , p_scheduled_material_id NUMBER
772: , p5_a0 JTF_NUMBER_TABLE
773: , p5_a1 JTF_VARCHAR2_TABLE_100
774: , p5_a2 JTF_NUMBER_TABLE
775: , p5_a3 JTF_VARCHAR2_TABLE_100
776: , x_mo_hdr_id out nocopy NUMBER
777: , x_mo_lines_tbl out nocopy JTF_NUMBER_TABLE
778: , x_return_status out nocopy VARCHAR2
779: , x_msg_count out nocopy NUMBER

Line 888: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

884: , x_return_status out nocopy VARCHAR2
885: , x_msg_count out nocopy NUMBER
886: , x_msg_data out nocopy VARCHAR2
887: , p9_a0 in out nocopy JTF_NUMBER_TABLE
888: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
889: , p9_a2 in out nocopy JTF_NUMBER_TABLE
890: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
891: , p9_a4 in out nocopy JTF_NUMBER_TABLE
892: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 890: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

886: , x_msg_data out nocopy VARCHAR2
887: , p9_a0 in out nocopy JTF_NUMBER_TABLE
888: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
889: , p9_a2 in out nocopy JTF_NUMBER_TABLE
890: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
891: , p9_a4 in out nocopy JTF_NUMBER_TABLE
892: , p9_a5 in out nocopy JTF_NUMBER_TABLE
893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
894: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

889: , p9_a2 in out nocopy JTF_NUMBER_TABLE
890: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
891: , p9_a4 in out nocopy JTF_NUMBER_TABLE
892: , p9_a5 in out nocopy JTF_NUMBER_TABLE
893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
894: , p9_a7 in out nocopy JTF_NUMBER_TABLE
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

892: , p9_a5 in out nocopy JTF_NUMBER_TABLE
893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
894: , p9_a7 in out nocopy JTF_NUMBER_TABLE
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p_sched_material_id NUMBER

Line 897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
894: , p9_a7 in out nocopy JTF_NUMBER_TABLE
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p_sched_material_id NUMBER
901: , x_reservation_id out nocopy NUMBER

Line 898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

894: , p9_a7 in out nocopy JTF_NUMBER_TABLE
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p_sched_material_id NUMBER
901: , x_reservation_id out nocopy NUMBER
902: )

Line 899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p_sched_material_id NUMBER
901: , x_reservation_id out nocopy NUMBER
902: )
903:

Line 988: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

984: , x_return_status out nocopy VARCHAR2
985: , x_msg_count out nocopy NUMBER
986: , x_msg_data out nocopy VARCHAR2
987: , p9_a0 in out nocopy JTF_NUMBER_TABLE
988: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
989: , p9_a2 in out nocopy JTF_NUMBER_TABLE
990: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
991: , p9_a4 in out nocopy JTF_NUMBER_TABLE
992: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 990: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

986: , x_msg_data out nocopy VARCHAR2
987: , p9_a0 in out nocopy JTF_NUMBER_TABLE
988: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
989: , p9_a2 in out nocopy JTF_NUMBER_TABLE
990: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
991: , p9_a4 in out nocopy JTF_NUMBER_TABLE
992: , p9_a5 in out nocopy JTF_NUMBER_TABLE
993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
994: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

989: , p9_a2 in out nocopy JTF_NUMBER_TABLE
990: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
991: , p9_a4 in out nocopy JTF_NUMBER_TABLE
992: , p9_a5 in out nocopy JTF_NUMBER_TABLE
993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
994: , p9_a7 in out nocopy JTF_NUMBER_TABLE
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

992: , p9_a5 in out nocopy JTF_NUMBER_TABLE
993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
994: , p9_a7 in out nocopy JTF_NUMBER_TABLE
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1000: )

Line 997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
994: , p9_a7 in out nocopy JTF_NUMBER_TABLE
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1000: )
1001:

Line 998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

994: , p9_a7 in out nocopy JTF_NUMBER_TABLE
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1000: )
1001:
1002: as

Line 999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
997: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1000: )
1001:
1002: as
1003: ddp_x_mtltfr_tbl ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type;

Line 1079: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100

1075: , x_msg_data out nocopy VARCHAR2
1076: , x_return_status out nocopy VARCHAR2
1077: , p_sch_mtl_id NUMBER
1078: , p_source_org_tbl JTF_NUMBER_TABLE
1079: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100
1080: , p_source_locators_tbl JTF_NUMBER_TABLE
1081: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100
1082: , x_requisition_num out nocopy VARCHAR2
1083: , x_requisition_hdr_id out nocopy NUMBER

Line 1081: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100

1077: , p_sch_mtl_id NUMBER
1078: , p_source_org_tbl JTF_NUMBER_TABLE
1079: , p_source_sub_inv_tbl JTF_VARCHAR2_TABLE_100
1080: , p_source_locators_tbl JTF_NUMBER_TABLE
1081: , p_serial_num_tbl JTF_VARCHAR2_TABLE_100
1082: , x_requisition_num out nocopy VARCHAR2
1083: , x_requisition_hdr_id out nocopy NUMBER
1084: , x_int_order_num out nocopy NUMBER
1085: , x_int_order_hdr_id out nocopy NUMBER

Line 1207: , p4_a1 JTF_VARCHAR2_TABLE_100

1203: , p_init_msg_list VARCHAR2
1204: , p_commit VARCHAR2
1205: , p_validation_level NUMBER
1206: , p4_a0 JTF_NUMBER_TABLE
1207: , p4_a1 JTF_VARCHAR2_TABLE_100
1208: , p4_a2 JTF_NUMBER_TABLE
1209: , x_return_status out nocopy VARCHAR2
1210: , x_msg_count out nocopy NUMBER
1211: , x_msg_data out nocopy VARCHAR2