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_NUMBER_TABLE

Line 52: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE) as

48: end if;
49: end if;
50: end rosetta_table_copy_out_p2;
51:
52: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 JTF_NUMBER_TABLE) as
53: ddindx binary_integer; indx binary_integer;
54: begin
55: if a0 is null then
56: t := null;

Line 76: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE) as

72: end loop;
73: end if;
74: end if;
75: end rosetta_table_copy_in_p3;
76: procedure rosetta_table_copy_out_p3(t ahl_mm_mtl_mgt_pvt.oaf_number_table, a0 out nocopy JTF_NUMBER_TABLE) as
77: ddindx binary_integer; indx binary_integer;
78: begin
79: if t is null then
80: a0 := null;

Line 82: a0 := JTF_NUMBER_TABLE();

78: begin
79: if t is null then
80: a0 := null;
81: elsif t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);

Line 84: a0 := JTF_NUMBER_TABLE();

80: a0 := null;
81: elsif t.count = 0 then
82: a0 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: ddindx := t.first;
88: indx := 1;

Line 101: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 JTF_NUMBER_TABLE

97: end if;
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

Line 103: , a2 JTF_NUMBER_TABLE

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
107: , a6 JTF_VARCHAR2_TABLE_100

Line 105: , a4 JTF_NUMBER_TABLE

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
109: , a8 JTF_NUMBER_TABLE

Line 106: , a5 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
109: , a8 JTF_NUMBER_TABLE
110: , a9 JTF_VARCHAR2_TABLE_100

Line 108: , a7 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
112: , a11 JTF_VARCHAR2_TABLE_100

Line 109: , a8 JTF_NUMBER_TABLE

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
112: , a11 JTF_VARCHAR2_TABLE_100
113: , a12 JTF_VARCHAR2_TABLE_100

Line 148: procedure rosetta_table_copy_out_p10(t ahl_mm_mtl_mgt_pvt.ahl_mtltfr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

144: end loop;
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

Line 150: , a2 out nocopy JTF_NUMBER_TABLE

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
154: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , a4 out nocopy JTF_NUMBER_TABLE

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
156: , a8 out nocopy JTF_NUMBER_TABLE

Line 153: , a5 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
156: , a8 out nocopy JTF_NUMBER_TABLE
157: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 155: , a7 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
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a8 out nocopy JTF_NUMBER_TABLE

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
159: , a11 out nocopy JTF_VARCHAR2_TABLE_100
160: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: a0 := JTF_NUMBER_TABLE();

175: a10 := null;
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();

Line 181: a2 := JTF_NUMBER_TABLE();

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();
185: a6 := JTF_VARCHAR2_TABLE_100();

Line 183: a4 := JTF_NUMBER_TABLE();

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();
187: a8 := JTF_NUMBER_TABLE();

Line 184: a5 := 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();
187: a8 := JTF_NUMBER_TABLE();
188: a9 := JTF_VARCHAR2_TABLE_100();

Line 186: a7 := 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();
190: a11 := JTF_VARCHAR2_TABLE_100();

Line 187: a8 := JTF_NUMBER_TABLE();

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();
190: a11 := JTF_VARCHAR2_TABLE_100();
191: a12 := JTF_VARCHAR2_TABLE_100();

Line 193: a0 := JTF_NUMBER_TABLE();

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();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_NUMBER_TABLE();

Line 195: a2 := JTF_NUMBER_TABLE();

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();
199: a6 := JTF_VARCHAR2_TABLE_100();

Line 197: a4 := JTF_NUMBER_TABLE();

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();
201: a8 := JTF_NUMBER_TABLE();

Line 198: a5 := 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();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();

Line 200: a7 := 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();
204: a11 := JTF_VARCHAR2_TABLE_100();

Line 201: a8 := JTF_NUMBER_TABLE();

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();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_VARCHAR2_TABLE_100();

Line 246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE

242: end if;
243: end if;
244: end rosetta_table_copy_out_p10;
245:
246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
247: , a1 JTF_NUMBER_TABLE
248: , a2 JTF_DATE_TABLE
249: , a3 JTF_NUMBER_TABLE
250: , a4 JTF_VARCHAR2_TABLE_2000

Line 247: , a1 JTF_NUMBER_TABLE

243: end if;
244: end rosetta_table_copy_out_p10;
245:
246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
247: , a1 JTF_NUMBER_TABLE
248: , a2 JTF_DATE_TABLE
249: , a3 JTF_NUMBER_TABLE
250: , a4 JTF_VARCHAR2_TABLE_2000
251: ) as

Line 249: , a3 JTF_NUMBER_TABLE

245:
246: procedure rosetta_table_copy_in_p11(t out nocopy ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 JTF_NUMBER_TABLE
247: , a1 JTF_NUMBER_TABLE
248: , a2 JTF_DATE_TABLE
249: , a3 JTF_NUMBER_TABLE
250: , a4 JTF_VARCHAR2_TABLE_2000
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin

Line 273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE

269: end loop;
270: end if;
271: end if;
272: end rosetta_table_copy_in_p11;
273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
274: , a1 out nocopy JTF_NUMBER_TABLE
275: , a2 out nocopy JTF_DATE_TABLE
276: , a3 out nocopy JTF_NUMBER_TABLE
277: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 274: , a1 out nocopy JTF_NUMBER_TABLE

270: end if;
271: end if;
272: end rosetta_table_copy_in_p11;
273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
274: , a1 out nocopy JTF_NUMBER_TABLE
275: , a2 out nocopy JTF_DATE_TABLE
276: , a3 out nocopy JTF_NUMBER_TABLE
277: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
278: ) as

Line 276: , a3 out nocopy JTF_NUMBER_TABLE

272: end rosetta_table_copy_in_p11;
273: procedure rosetta_table_copy_out_p11(t ahl_mm_mtl_mgt_pvt.mtl_avl_schld_tbl, a0 out nocopy JTF_NUMBER_TABLE
274: , a1 out nocopy JTF_NUMBER_TABLE
275: , a2 out nocopy JTF_DATE_TABLE
276: , a3 out nocopy JTF_NUMBER_TABLE
277: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin

Line 282: a0 := JTF_NUMBER_TABLE();

278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_DATE_TABLE();
285: a3 := JTF_NUMBER_TABLE();
286: a4 := JTF_VARCHAR2_TABLE_2000();

Line 283: a1 := JTF_NUMBER_TABLE();

279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_DATE_TABLE();
285: a3 := JTF_NUMBER_TABLE();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: else

Line 285: a3 := JTF_NUMBER_TABLE();

281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_DATE_TABLE();
285: a3 := JTF_NUMBER_TABLE();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: else
288: a0 := JTF_NUMBER_TABLE();
289: a1 := JTF_NUMBER_TABLE();

Line 288: a0 := JTF_NUMBER_TABLE();

284: a2 := JTF_DATE_TABLE();
285: a3 := JTF_NUMBER_TABLE();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: else
288: a0 := JTF_NUMBER_TABLE();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_DATE_TABLE();
291: a3 := JTF_NUMBER_TABLE();
292: a4 := JTF_VARCHAR2_TABLE_2000();

Line 289: a1 := JTF_NUMBER_TABLE();

285: a3 := JTF_NUMBER_TABLE();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: else
288: a0 := JTF_NUMBER_TABLE();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_DATE_TABLE();
291: a3 := JTF_NUMBER_TABLE();
292: a4 := JTF_VARCHAR2_TABLE_2000();
293: if t.count > 0 then

Line 291: a3 := JTF_NUMBER_TABLE();

287: else
288: a0 := JTF_NUMBER_TABLE();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_DATE_TABLE();
291: a3 := JTF_NUMBER_TABLE();
292: a4 := JTF_VARCHAR2_TABLE_2000();
293: if t.count > 0 then
294: a0.extend(t.count);
295: a1.extend(t.count);

Line 317: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as

313: end if;
314: end if;
315: end rosetta_table_copy_out_p11;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy ahl_mm_mtl_mgt_pvt.number_table_type, a0 JTF_NUMBER_TABLE) as
318: ddindx binary_integer; indx binary_integer;
319: begin
320: if a0 is not null and a0.count > 0 then
321: if a0.count > 0 then

Line 335: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p12;
335: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();

Line 339: a0 := JTF_NUMBER_TABLE();

335: procedure rosetta_table_copy_out_p12(t ahl_mm_mtl_mgt_pvt.number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: if t.count > 0 then
343: a0.extend(t.count);

Line 341: a0 := JTF_NUMBER_TABLE();

337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();
340: else
341: a0 := JTF_NUMBER_TABLE();
342: if t.count > 0 then
343: a0.extend(t.count);
344: ddindx := t.first;
345: indx := 1;

Line 358: procedure rosetta_table_copy_in_p13(t out nocopy ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 JTF_NUMBER_TABLE

354: end if;
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

Line 360: , a2 JTF_NUMBER_TABLE

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;
364: begin

Line 383: procedure rosetta_table_copy_out_p13(t ahl_mm_mtl_mgt_pvt.supply_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

379: end loop;
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

Line 385: , a2 out nocopy JTF_NUMBER_TABLE

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;
389: begin

Line 391: a0 := JTF_NUMBER_TABLE();

387: ) as
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

Line 393: a2 := JTF_NUMBER_TABLE();

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();
397: a1 := JTF_VARCHAR2_TABLE_100();

Line 396: 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();
399: a3 := JTF_VARCHAR2_TABLE_100();
400: if t.count > 0 then

Line 398: 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);
402: a1.extend(t.count);

Line 422: procedure rosetta_table_copy_in_p14(t out nocopy ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 JTF_NUMBER_TABLE

418: end if;
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;

Line 424: , a2 JTF_NUMBER_TABLE

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
428: if a0 is not null and a0.count > 0 then

Line 445: procedure rosetta_table_copy_out_p14(t ahl_mm_mtl_mgt_pvt.aog_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

441: end loop;
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;

Line 447: , a2 out nocopy JTF_NUMBER_TABLE

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
451: if t is null or t.count = 0 then

Line 452: a0 := JTF_NUMBER_TABLE();

448: ) as
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();

Line 454: a2 := JTF_NUMBER_TABLE();

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();
458: a2 := JTF_NUMBER_TABLE();

Line 456: a0 := JTF_NUMBER_TABLE();

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();
458: a2 := JTF_NUMBER_TABLE();
459: if t.count > 0 then
460: a0.extend(t.count);

Line 458: a2 := JTF_NUMBER_TABLE();

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);
462: a2.extend(t.count);

Line 479: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE

475: end if;
476: end if;
477: end rosetta_table_copy_out_p14;
478:
479: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
480: , a1 JTF_NUMBER_TABLE
481: , a2 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;

Line 480: , a1 JTF_NUMBER_TABLE

476: end if;
477: end rosetta_table_copy_out_p14;
478:
479: procedure rosetta_table_copy_in_p15(t out nocopy ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 JTF_NUMBER_TABLE
480: , a1 JTF_NUMBER_TABLE
481: , a2 JTF_VARCHAR2_TABLE_2000
482: ) as
483: ddindx binary_integer; indx binary_integer;
484: begin

Line 502: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE

498: end loop;
499: end if;
500: end if;
501: end rosetta_table_copy_in_p15;
502: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
505: ) as
506: ddindx binary_integer; indx binary_integer;

Line 503: , a1 out nocopy JTF_NUMBER_TABLE

499: end if;
500: end if;
501: end rosetta_table_copy_in_p15;
502: procedure rosetta_table_copy_out_p15(t ahl_mm_mtl_mgt_pvt.inv_mtl_avl_tbl, a0 out nocopy JTF_NUMBER_TABLE
503: , a1 out nocopy JTF_NUMBER_TABLE
504: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
505: ) as
506: ddindx binary_integer; indx binary_integer;
507: begin

Line 509: a0 := JTF_NUMBER_TABLE();

505: ) as
506: ddindx binary_integer; indx binary_integer;
507: begin
508: if t is null or t.count = 0 then
509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_VARCHAR2_TABLE_2000();
512: else
513: a0 := JTF_NUMBER_TABLE();

Line 510: a1 := JTF_NUMBER_TABLE();

506: ddindx binary_integer; indx binary_integer;
507: begin
508: if t is null or t.count = 0 then
509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_VARCHAR2_TABLE_2000();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();

Line 513: a0 := JTF_NUMBER_TABLE();

509: a0 := JTF_NUMBER_TABLE();
510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_VARCHAR2_TABLE_2000();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_VARCHAR2_TABLE_2000();
516: if t.count > 0 then
517: a0.extend(t.count);

Line 514: a1 := JTF_NUMBER_TABLE();

510: a1 := JTF_NUMBER_TABLE();
511: a2 := JTF_VARCHAR2_TABLE_2000();
512: else
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_VARCHAR2_TABLE_2000();
516: if t.count > 0 then
517: a0.extend(t.count);
518: a1.extend(t.count);

Line 536: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE) as

532: end if;
533: end if;
534: end rosetta_table_copy_out_p15;
535:
536: procedure rosetta_table_copy_in_p34(t out nocopy ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 JTF_NUMBER_TABLE) as
537: ddindx binary_integer; indx binary_integer;
538: begin
539: if a0 is not null and a0.count > 0 then
540: if a0.count > 0 then

Line 554: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

550: end loop;
551: end if;
552: end if;
553: end rosetta_table_copy_in_p34;
554: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if t is null or t.count = 0 then
558: a0 := JTF_NUMBER_TABLE();

Line 558: a0 := JTF_NUMBER_TABLE();

554: procedure rosetta_table_copy_out_p34(t ahl_mm_mtl_mgt_pvt.visit_ids_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if t is null or t.count = 0 then
558: a0 := JTF_NUMBER_TABLE();
559: else
560: a0 := JTF_NUMBER_TABLE();
561: if t.count > 0 then
562: a0.extend(t.count);

Line 560: a0 := JTF_NUMBER_TABLE();

556: begin
557: if t is null or t.count = 0 then
558: a0 := JTF_NUMBER_TABLE();
559: else
560: a0 := JTF_NUMBER_TABLE();
561: if t.count > 0 then
562: a0.extend(t.count);
563: ddindx := t.first;
564: indx := 1;

Line 582: , p_schedule_material_id_tbl JTF_NUMBER_TABLE

578: , p_init_msg_list VARCHAR2
579: , p_commit VARCHAR2
580: , p_module_type VARCHAR2
581: , p_validation_level NUMBER
582: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_DATE_TABLE
586: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 583: , p6_a0 out nocopy JTF_NUMBER_TABLE

579: , p_commit VARCHAR2
580: , p_module_type VARCHAR2
581: , p_validation_level NUMBER
582: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_DATE_TABLE
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 584: , p6_a1 out nocopy JTF_NUMBER_TABLE

580: , p_module_type VARCHAR2
581: , p_validation_level NUMBER
582: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_DATE_TABLE
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
588: , x_return_status out nocopy VARCHAR2

Line 586: , p6_a3 out nocopy JTF_NUMBER_TABLE

582: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
583: , p6_a0 out nocopy JTF_NUMBER_TABLE
584: , p6_a1 out nocopy JTF_NUMBER_TABLE
585: , p6_a2 out nocopy JTF_DATE_TABLE
586: , p6_a3 out nocopy JTF_NUMBER_TABLE
587: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
588: , x_return_status out nocopy VARCHAR2
589: , x_msg_count out nocopy NUMBER
590: , x_msg_data out nocopy VARCHAR2

Line 646: , p_schedule_material_id_tbl JTF_NUMBER_TABLE

642: , p_init_msg_list VARCHAR2
643: , p_commit VARCHAR2
644: , p_module_type VARCHAR2
645: , p_validation_level NUMBER
646: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
647: , p6_a0 out nocopy JTF_NUMBER_TABLE
648: , p6_a1 out nocopy JTF_NUMBER_TABLE
649: , p6_a2 out nocopy JTF_DATE_TABLE
650: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 647: , p6_a0 out nocopy JTF_NUMBER_TABLE

643: , p_commit VARCHAR2
644: , p_module_type VARCHAR2
645: , p_validation_level NUMBER
646: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
647: , p6_a0 out nocopy JTF_NUMBER_TABLE
648: , p6_a1 out nocopy JTF_NUMBER_TABLE
649: , p6_a2 out nocopy JTF_DATE_TABLE
650: , p6_a3 out nocopy JTF_NUMBER_TABLE
651: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 648: , p6_a1 out nocopy JTF_NUMBER_TABLE

644: , p_module_type VARCHAR2
645: , p_validation_level NUMBER
646: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
647: , p6_a0 out nocopy JTF_NUMBER_TABLE
648: , p6_a1 out nocopy JTF_NUMBER_TABLE
649: , p6_a2 out nocopy JTF_DATE_TABLE
650: , p6_a3 out nocopy JTF_NUMBER_TABLE
651: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
652: , x_return_status out nocopy VARCHAR2

Line 650: , p6_a3 out nocopy JTF_NUMBER_TABLE

646: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
647: , p6_a0 out nocopy JTF_NUMBER_TABLE
648: , p6_a1 out nocopy JTF_NUMBER_TABLE
649: , p6_a2 out nocopy JTF_DATE_TABLE
650: , p6_a3 out nocopy JTF_NUMBER_TABLE
651: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
652: , x_return_status out nocopy VARCHAR2
653: , x_msg_count out nocopy NUMBER
654: , x_msg_data out nocopy VARCHAR2

Line 711: , p6_a0 out nocopy JTF_NUMBER_TABLE

707: , p_commit VARCHAR2
708: , p_module_type VARCHAR2
709: , p_validation_level NUMBER
710: , p_visit_id NUMBER
711: , p6_a0 out nocopy JTF_NUMBER_TABLE
712: , p6_a1 out nocopy JTF_NUMBER_TABLE
713: , p6_a2 out nocopy JTF_DATE_TABLE
714: , p6_a3 out nocopy JTF_NUMBER_TABLE
715: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 712: , p6_a1 out nocopy JTF_NUMBER_TABLE

708: , p_module_type VARCHAR2
709: , p_validation_level NUMBER
710: , p_visit_id NUMBER
711: , p6_a0 out nocopy JTF_NUMBER_TABLE
712: , p6_a1 out nocopy JTF_NUMBER_TABLE
713: , p6_a2 out nocopy JTF_DATE_TABLE
714: , p6_a3 out nocopy JTF_NUMBER_TABLE
715: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
716: , x_return_status out nocopy VARCHAR2

Line 714: , p6_a3 out nocopy JTF_NUMBER_TABLE

710: , p_visit_id NUMBER
711: , p6_a0 out nocopy JTF_NUMBER_TABLE
712: , p6_a1 out nocopy JTF_NUMBER_TABLE
713: , p6_a2 out nocopy JTF_DATE_TABLE
714: , p6_a3 out nocopy JTF_NUMBER_TABLE
715: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
716: , x_return_status out nocopy VARCHAR2
717: , x_msg_count out nocopy NUMBER
718: , x_msg_data out nocopy VARCHAR2

Line 772: , p5_a0 JTF_NUMBER_TABLE

768: , p_init_msg_list VARCHAR2
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

Line 774: , p5_a2 JTF_NUMBER_TABLE

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
778: , x_return_status out nocopy VARCHAR2

Line 777: , x_mo_lines_tbl out nocopy 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
780: , x_msg_data out nocopy VARCHAR2
781: )

Line 837: , p_asm_id_tab JTF_NUMBER_TABLE

833: procedure invoke_aog_upd_notification(p_api_version NUMBER
834: , p_init_msg_list VARCHAR2
835: , p_commit VARCHAR2
836: , p_validation_level NUMBER
837: , p_asm_id_tab JTF_NUMBER_TABLE
838: , x_return_status out nocopy VARCHAR2
839: , x_msg_count out nocopy NUMBER
840: , x_msg_data out nocopy VARCHAR2
841: )

Line 887: , p9_a0 in out nocopy JTF_NUMBER_TABLE

883: , p_module_type VARCHAR2
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

Line 889: , p9_a2 in out nocopy JTF_NUMBER_TABLE

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
893: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 891: , p9_a4 in out nocopy JTF_NUMBER_TABLE

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
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE

Line 892: , p9_a5 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
895: , p9_a8 in out nocopy JTF_NUMBER_TABLE
896: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 894: , p9_a7 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
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 895: , p9_a8 in out nocopy JTF_NUMBER_TABLE

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
898: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
899: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 987: , p9_a0 in out nocopy JTF_NUMBER_TABLE

983: , p_module_type VARCHAR2
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

Line 989: , p9_a2 in out nocopy JTF_NUMBER_TABLE

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
993: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 991: , p9_a4 in out nocopy JTF_NUMBER_TABLE

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
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE

Line 992: , p9_a5 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
995: , p9_a8 in out nocopy JTF_NUMBER_TABLE
996: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 994: , p9_a7 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
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 995: , p9_a8 in out nocopy JTF_NUMBER_TABLE

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
998: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
999: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1078: , p_source_org_tbl JTF_NUMBER_TABLE

1074: , x_msg_count out nocopy NUMBER
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

Line 1080: , p_source_locators_tbl JTF_NUMBER_TABLE

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
1084: , x_int_order_num out nocopy NUMBER

Line 1161: , p_schedule_material_id_tbl JTF_NUMBER_TABLE

1157: procedure aog_upd_notification(p_api_version NUMBER
1158: , p_init_msg_list VARCHAR2
1159: , p_commit VARCHAR2
1160: , p_validation_level NUMBER
1161: , p_schedule_material_id_tbl JTF_NUMBER_TABLE
1162: , x_return_status out nocopy VARCHAR2
1163: , x_msg_count out nocopy NUMBER
1164: , x_msg_data out nocopy VARCHAR2
1165: )

Line 1206: , p4_a0 JTF_NUMBER_TABLE

1202: procedure update_aog(p_api_version NUMBER
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

Line 1208: , p4_a2 JTF_NUMBER_TABLE

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
1212: )

Line 1332: , p7_a0 out nocopy JTF_NUMBER_TABLE

1328: , p_module_type VARCHAR2
1329: , p_validation_level NUMBER
1330: , p_org_id NUMBER
1331: , p_inv_item_id NUMBER
1332: , p7_a0 out nocopy JTF_NUMBER_TABLE
1333: , p7_a1 out nocopy JTF_NUMBER_TABLE
1334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1335: , x_return_status out nocopy VARCHAR2
1336: , x_msg_count out nocopy NUMBER

Line 1333: , p7_a1 out nocopy JTF_NUMBER_TABLE

1329: , p_validation_level NUMBER
1330: , p_org_id NUMBER
1331: , p_inv_item_id NUMBER
1332: , p7_a0 out nocopy JTF_NUMBER_TABLE
1333: , p7_a1 out nocopy JTF_NUMBER_TABLE
1334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_2000
1335: , x_return_status out nocopy VARCHAR2
1336: , x_msg_count out nocopy NUMBER
1337: , x_msg_data out nocopy VARCHAR2

Line 1392: , p_visit_ids JTF_NUMBER_TABLE

1388: , p_init_msg_list VARCHAR2
1389: , p_commit VARCHAR2
1390: , p_module_type VARCHAR2
1391: , p_validation_level NUMBER
1392: , p_visit_ids JTF_NUMBER_TABLE
1393: , p6_a0 out nocopy JTF_NUMBER_TABLE
1394: , p6_a1 out nocopy JTF_NUMBER_TABLE
1395: , p6_a2 out nocopy JTF_DATE_TABLE
1396: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 1393: , p6_a0 out nocopy JTF_NUMBER_TABLE

1389: , p_commit VARCHAR2
1390: , p_module_type VARCHAR2
1391: , p_validation_level NUMBER
1392: , p_visit_ids JTF_NUMBER_TABLE
1393: , p6_a0 out nocopy JTF_NUMBER_TABLE
1394: , p6_a1 out nocopy JTF_NUMBER_TABLE
1395: , p6_a2 out nocopy JTF_DATE_TABLE
1396: , p6_a3 out nocopy JTF_NUMBER_TABLE
1397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1394: , p6_a1 out nocopy JTF_NUMBER_TABLE

1390: , p_module_type VARCHAR2
1391: , p_validation_level NUMBER
1392: , p_visit_ids JTF_NUMBER_TABLE
1393: , p6_a0 out nocopy JTF_NUMBER_TABLE
1394: , p6_a1 out nocopy JTF_NUMBER_TABLE
1395: , p6_a2 out nocopy JTF_DATE_TABLE
1396: , p6_a3 out nocopy JTF_NUMBER_TABLE
1397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1398: , x_return_status out nocopy VARCHAR2

Line 1396: , p6_a3 out nocopy JTF_NUMBER_TABLE

1392: , p_visit_ids JTF_NUMBER_TABLE
1393: , p6_a0 out nocopy JTF_NUMBER_TABLE
1394: , p6_a1 out nocopy JTF_NUMBER_TABLE
1395: , p6_a2 out nocopy JTF_DATE_TABLE
1396: , p6_a3 out nocopy JTF_NUMBER_TABLE
1397: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1398: , x_return_status out nocopy VARCHAR2
1399: , x_msg_count out nocopy NUMBER
1400: , x_msg_data out nocopy VARCHAR2