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_p2(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
15: , a2 JTF_DATE_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_200
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_200
26: , a13 JTF_VARCHAR2_TABLE_200
80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_DATE_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
81: end if;
82: end if;
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_DATE_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
83: end rosetta_table_copy_in_p2;
84: procedure rosetta_table_copy_out_p2(t ahl_prd_disp_mtl_txn_pvt.disp_mtl_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_DATE_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_DATE_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_DATE_TABLE
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
87: , a3 out nocopy JTF_NUMBER_TABLE
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a11 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_DATE_TABLE
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a11 out nocopy JTF_VARCHAR2_TABLE_100
96: , a12 out nocopy JTF_VARCHAR2_TABLE_200
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_NUMBER_TABLE
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a11 out nocopy JTF_VARCHAR2_TABLE_100
96: , a12 out nocopy JTF_VARCHAR2_TABLE_200
97: , a13 out nocopy JTF_VARCHAR2_TABLE_200
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
117: a2 := JTF_DATE_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_DATE_TABLE();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_200();
120: a5 := JTF_NUMBER_TABLE();
121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_VARCHAR2_TABLE_200();
128: a13 := JTF_VARCHAR2_TABLE_200();
139: a24 := JTF_VARCHAR2_TABLE_200();
140: a25 := JTF_VARCHAR2_TABLE_200();
141: a26 := JTF_VARCHAR2_TABLE_200();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_DATE_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_200();
141: a26 := JTF_VARCHAR2_TABLE_200();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_DATE_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
142: else
143: a0 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_DATE_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
144: a1 := JTF_NUMBER_TABLE();
145: a2 := JTF_DATE_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
145: a2 := JTF_DATE_TABLE();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
146: a3 := JTF_NUMBER_TABLE();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
147: a4 := JTF_DATE_TABLE();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
155: a12 := JTF_VARCHAR2_TABLE_200();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_NUMBER_TABLE();
150: a7 := JTF_NUMBER_TABLE();
151: a8 := JTF_NUMBER_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
155: a12 := JTF_VARCHAR2_TABLE_200();
156: a13 := JTF_VARCHAR2_TABLE_200();
234: end if;
235: end if;
236: end rosetta_table_copy_out_p2;
237:
238: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 JTF_NUMBER_TABLE
239: , a1 JTF_NUMBER_TABLE
240: , a2 JTF_NUMBER_TABLE
241: , a3 JTF_VARCHAR2_TABLE_100
242: , a4 JTF_NUMBER_TABLE
235: end if;
236: end rosetta_table_copy_out_p2;
237:
238: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 JTF_NUMBER_TABLE
239: , a1 JTF_NUMBER_TABLE
240: , a2 JTF_NUMBER_TABLE
241: , a3 JTF_VARCHAR2_TABLE_100
242: , a4 JTF_NUMBER_TABLE
243: , a5 JTF_VARCHAR2_TABLE_100
236: end rosetta_table_copy_out_p2;
237:
238: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 JTF_NUMBER_TABLE
239: , a1 JTF_NUMBER_TABLE
240: , a2 JTF_NUMBER_TABLE
241: , a3 JTF_VARCHAR2_TABLE_100
242: , a4 JTF_NUMBER_TABLE
243: , a5 JTF_VARCHAR2_TABLE_100
244: , a6 JTF_VARCHAR2_TABLE_100
238: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 JTF_NUMBER_TABLE
239: , a1 JTF_NUMBER_TABLE
240: , a2 JTF_NUMBER_TABLE
241: , a3 JTF_VARCHAR2_TABLE_100
242: , a4 JTF_NUMBER_TABLE
243: , a5 JTF_VARCHAR2_TABLE_100
244: , a6 JTF_VARCHAR2_TABLE_100
245: , a7 JTF_VARCHAR2_TABLE_100
246: , a8 JTF_VARCHAR2_TABLE_100
248: , a10 JTF_VARCHAR2_TABLE_100
249: , a11 JTF_VARCHAR2_TABLE_200
250: , a12 JTF_VARCHAR2_TABLE_100
251: , a13 JTF_VARCHAR2_TABLE_100
252: , a14 JTF_NUMBER_TABLE
253: , a15 JTF_VARCHAR2_TABLE_100
254: , a16 JTF_NUMBER_TABLE
255: , a17 JTF_VARCHAR2_TABLE_100
256: , a18 JTF_NUMBER_TABLE
250: , a12 JTF_VARCHAR2_TABLE_100
251: , a13 JTF_VARCHAR2_TABLE_100
252: , a14 JTF_NUMBER_TABLE
253: , a15 JTF_VARCHAR2_TABLE_100
254: , a16 JTF_NUMBER_TABLE
255: , a17 JTF_VARCHAR2_TABLE_100
256: , a18 JTF_NUMBER_TABLE
257: , a19 JTF_VARCHAR2_TABLE_100
258: ) as
252: , a14 JTF_NUMBER_TABLE
253: , a15 JTF_VARCHAR2_TABLE_100
254: , a16 JTF_NUMBER_TABLE
255: , a17 JTF_VARCHAR2_TABLE_100
256: , a18 JTF_NUMBER_TABLE
257: , a19 JTF_VARCHAR2_TABLE_100
258: ) as
259: ddindx binary_integer; indx binary_integer;
260: begin
291: end loop;
292: end if;
293: end if;
294: end rosetta_table_copy_in_p3;
295: procedure rosetta_table_copy_out_p3(t ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_NUMBER_TABLE
297: , a2 out nocopy JTF_NUMBER_TABLE
298: , a3 out nocopy JTF_VARCHAR2_TABLE_100
299: , a4 out nocopy JTF_NUMBER_TABLE
292: end if;
293: end if;
294: end rosetta_table_copy_in_p3;
295: procedure rosetta_table_copy_out_p3(t ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_NUMBER_TABLE
297: , a2 out nocopy JTF_NUMBER_TABLE
298: , a3 out nocopy JTF_VARCHAR2_TABLE_100
299: , a4 out nocopy JTF_NUMBER_TABLE
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
293: end if;
294: end rosetta_table_copy_in_p3;
295: procedure rosetta_table_copy_out_p3(t ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_NUMBER_TABLE
297: , a2 out nocopy JTF_NUMBER_TABLE
298: , a3 out nocopy JTF_VARCHAR2_TABLE_100
299: , a4 out nocopy JTF_NUMBER_TABLE
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100
295: procedure rosetta_table_copy_out_p3(t ahl_prd_disp_mtl_txn_pvt.disp_mtxn_assoc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
296: , a1 out nocopy JTF_NUMBER_TABLE
297: , a2 out nocopy JTF_NUMBER_TABLE
298: , a3 out nocopy JTF_VARCHAR2_TABLE_100
299: , a4 out nocopy JTF_NUMBER_TABLE
300: , a5 out nocopy JTF_VARCHAR2_TABLE_100
301: , a6 out nocopy JTF_VARCHAR2_TABLE_100
302: , a7 out nocopy JTF_VARCHAR2_TABLE_100
303: , a8 out nocopy JTF_VARCHAR2_TABLE_100
305: , a10 out nocopy JTF_VARCHAR2_TABLE_100
306: , a11 out nocopy JTF_VARCHAR2_TABLE_200
307: , a12 out nocopy JTF_VARCHAR2_TABLE_100
308: , a13 out nocopy JTF_VARCHAR2_TABLE_100
309: , a14 out nocopy JTF_NUMBER_TABLE
310: , a15 out nocopy JTF_VARCHAR2_TABLE_100
311: , a16 out nocopy JTF_NUMBER_TABLE
312: , a17 out nocopy JTF_VARCHAR2_TABLE_100
313: , a18 out nocopy JTF_NUMBER_TABLE
307: , a12 out nocopy JTF_VARCHAR2_TABLE_100
308: , a13 out nocopy JTF_VARCHAR2_TABLE_100
309: , a14 out nocopy JTF_NUMBER_TABLE
310: , a15 out nocopy JTF_VARCHAR2_TABLE_100
311: , a16 out nocopy JTF_NUMBER_TABLE
312: , a17 out nocopy JTF_VARCHAR2_TABLE_100
313: , a18 out nocopy JTF_NUMBER_TABLE
314: , a19 out nocopy JTF_VARCHAR2_TABLE_100
315: ) as
309: , a14 out nocopy JTF_NUMBER_TABLE
310: , a15 out nocopy JTF_VARCHAR2_TABLE_100
311: , a16 out nocopy JTF_NUMBER_TABLE
312: , a17 out nocopy JTF_VARCHAR2_TABLE_100
313: , a18 out nocopy JTF_NUMBER_TABLE
314: , a19 out nocopy JTF_VARCHAR2_TABLE_100
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if t is null or t.count = 0 then
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_NUMBER_TABLE();
321: a2 := JTF_NUMBER_TABLE();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if t is null or t.count = 0 then
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_NUMBER_TABLE();
321: a2 := JTF_NUMBER_TABLE();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_VARCHAR2_TABLE_100();
317: begin
318: if t is null or t.count = 0 then
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_NUMBER_TABLE();
321: a2 := JTF_NUMBER_TABLE();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_VARCHAR2_TABLE_100();
325: a6 := JTF_VARCHAR2_TABLE_100();
319: a0 := JTF_NUMBER_TABLE();
320: a1 := JTF_NUMBER_TABLE();
321: a2 := JTF_NUMBER_TABLE();
322: a3 := JTF_VARCHAR2_TABLE_100();
323: a4 := JTF_NUMBER_TABLE();
324: a5 := JTF_VARCHAR2_TABLE_100();
325: a6 := JTF_VARCHAR2_TABLE_100();
326: a7 := JTF_VARCHAR2_TABLE_100();
327: a8 := JTF_VARCHAR2_TABLE_100();
329: a10 := JTF_VARCHAR2_TABLE_100();
330: a11 := JTF_VARCHAR2_TABLE_200();
331: a12 := JTF_VARCHAR2_TABLE_100();
332: a13 := JTF_VARCHAR2_TABLE_100();
333: a14 := JTF_NUMBER_TABLE();
334: a15 := JTF_VARCHAR2_TABLE_100();
335: a16 := JTF_NUMBER_TABLE();
336: a17 := JTF_VARCHAR2_TABLE_100();
337: a18 := JTF_NUMBER_TABLE();
331: a12 := JTF_VARCHAR2_TABLE_100();
332: a13 := JTF_VARCHAR2_TABLE_100();
333: a14 := JTF_NUMBER_TABLE();
334: a15 := JTF_VARCHAR2_TABLE_100();
335: a16 := JTF_NUMBER_TABLE();
336: a17 := JTF_VARCHAR2_TABLE_100();
337: a18 := JTF_NUMBER_TABLE();
338: a19 := JTF_VARCHAR2_TABLE_100();
339: else
333: a14 := JTF_NUMBER_TABLE();
334: a15 := JTF_VARCHAR2_TABLE_100();
335: a16 := JTF_NUMBER_TABLE();
336: a17 := JTF_VARCHAR2_TABLE_100();
337: a18 := JTF_NUMBER_TABLE();
338: a19 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_NUMBER_TABLE();
336: a17 := JTF_VARCHAR2_TABLE_100();
337: a18 := JTF_NUMBER_TABLE();
338: a19 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_NUMBER_TABLE();
342: a2 := JTF_NUMBER_TABLE();
343: a3 := JTF_VARCHAR2_TABLE_100();
344: a4 := JTF_NUMBER_TABLE();
337: a18 := JTF_NUMBER_TABLE();
338: a19 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_NUMBER_TABLE();
342: a2 := JTF_NUMBER_TABLE();
343: a3 := JTF_VARCHAR2_TABLE_100();
344: a4 := JTF_NUMBER_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
338: a19 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_NUMBER_TABLE();
342: a2 := JTF_NUMBER_TABLE();
343: a3 := JTF_VARCHAR2_TABLE_100();
344: a4 := JTF_NUMBER_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
346: a6 := JTF_VARCHAR2_TABLE_100();
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_NUMBER_TABLE();
342: a2 := JTF_NUMBER_TABLE();
343: a3 := JTF_VARCHAR2_TABLE_100();
344: a4 := JTF_NUMBER_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
346: a6 := JTF_VARCHAR2_TABLE_100();
347: a7 := JTF_VARCHAR2_TABLE_100();
348: a8 := JTF_VARCHAR2_TABLE_100();
350: a10 := JTF_VARCHAR2_TABLE_100();
351: a11 := JTF_VARCHAR2_TABLE_200();
352: a12 := JTF_VARCHAR2_TABLE_100();
353: a13 := JTF_VARCHAR2_TABLE_100();
354: a14 := JTF_NUMBER_TABLE();
355: a15 := JTF_VARCHAR2_TABLE_100();
356: a16 := JTF_NUMBER_TABLE();
357: a17 := JTF_VARCHAR2_TABLE_100();
358: a18 := JTF_NUMBER_TABLE();
352: a12 := JTF_VARCHAR2_TABLE_100();
353: a13 := JTF_VARCHAR2_TABLE_100();
354: a14 := JTF_NUMBER_TABLE();
355: a15 := JTF_VARCHAR2_TABLE_100();
356: a16 := JTF_NUMBER_TABLE();
357: a17 := JTF_VARCHAR2_TABLE_100();
358: a18 := JTF_NUMBER_TABLE();
359: a19 := JTF_VARCHAR2_TABLE_100();
360: if t.count > 0 then
354: a14 := JTF_NUMBER_TABLE();
355: a15 := JTF_VARCHAR2_TABLE_100();
356: a16 := JTF_NUMBER_TABLE();
357: a17 := JTF_VARCHAR2_TABLE_100();
358: a18 := JTF_NUMBER_TABLE();
359: a19 := JTF_VARCHAR2_TABLE_100();
360: if t.count > 0 then
361: a0.extend(t.count);
362: a1.extend(t.count);
418: , x_return_status out nocopy VARCHAR2
419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p_module VARCHAR2
422: , p8_a0 in out nocopy JTF_NUMBER_TABLE
423: , p8_a1 in out nocopy JTF_NUMBER_TABLE
424: , p8_a2 in out nocopy JTF_DATE_TABLE
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p_module VARCHAR2
422: , p8_a0 in out nocopy JTF_NUMBER_TABLE
423: , p8_a1 in out nocopy JTF_NUMBER_TABLE
424: , p8_a2 in out nocopy JTF_DATE_TABLE
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
421: , p_module VARCHAR2
422: , p8_a0 in out nocopy JTF_NUMBER_TABLE
423: , p8_a1 in out nocopy JTF_NUMBER_TABLE
424: , p8_a2 in out nocopy JTF_DATE_TABLE
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
423: , p8_a1 in out nocopy JTF_NUMBER_TABLE
424: , p8_a2 in out nocopy JTF_DATE_TABLE
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
430: , p8_a8 in out nocopy JTF_NUMBER_TABLE
431: , p8_a9 in out nocopy JTF_NUMBER_TABLE
424: , p8_a2 in out nocopy JTF_DATE_TABLE
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
430: , p8_a8 in out nocopy JTF_NUMBER_TABLE
431: , p8_a9 in out nocopy JTF_NUMBER_TABLE
432: , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p8_a3 in out nocopy JTF_NUMBER_TABLE
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
430: , p8_a8 in out nocopy JTF_NUMBER_TABLE
431: , p8_a9 in out nocopy JTF_NUMBER_TABLE
432: , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
426: , p8_a4 in out nocopy JTF_DATE_TABLE
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
430: , p8_a8 in out nocopy JTF_NUMBER_TABLE
431: , p8_a9 in out nocopy JTF_NUMBER_TABLE
432: , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
434: , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
427: , p8_a5 in out nocopy JTF_NUMBER_TABLE
428: , p8_a6 in out nocopy JTF_NUMBER_TABLE
429: , p8_a7 in out nocopy JTF_NUMBER_TABLE
430: , p8_a8 in out nocopy JTF_NUMBER_TABLE
431: , p8_a9 in out nocopy JTF_NUMBER_TABLE
432: , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_100
433: , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_100
434: , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
435: , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p_wo_mtl_txn_id NUMBER
552: , p8_a0 out nocopy JTF_NUMBER_TABLE
553: , p8_a1 out nocopy JTF_NUMBER_TABLE
554: , p8_a2 out nocopy JTF_NUMBER_TABLE
555: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
556: , p8_a4 out nocopy JTF_NUMBER_TABLE
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p_wo_mtl_txn_id NUMBER
552: , p8_a0 out nocopy JTF_NUMBER_TABLE
553: , p8_a1 out nocopy JTF_NUMBER_TABLE
554: , p8_a2 out nocopy JTF_NUMBER_TABLE
555: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
556: , p8_a4 out nocopy JTF_NUMBER_TABLE
557: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
550: , x_msg_data out nocopy VARCHAR2
551: , p_wo_mtl_txn_id NUMBER
552: , p8_a0 out nocopy JTF_NUMBER_TABLE
553: , p8_a1 out nocopy JTF_NUMBER_TABLE
554: , p8_a2 out nocopy JTF_NUMBER_TABLE
555: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
556: , p8_a4 out nocopy JTF_NUMBER_TABLE
557: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
558: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
552: , p8_a0 out nocopy JTF_NUMBER_TABLE
553: , p8_a1 out nocopy JTF_NUMBER_TABLE
554: , p8_a2 out nocopy JTF_NUMBER_TABLE
555: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
556: , p8_a4 out nocopy JTF_NUMBER_TABLE
557: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
558: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
559: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
560: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
562: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
563: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
564: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
565: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
566: , p8_a14 out nocopy JTF_NUMBER_TABLE
567: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
568: , p8_a16 out nocopy JTF_NUMBER_TABLE
569: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
570: , p8_a18 out nocopy JTF_NUMBER_TABLE
564: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
565: , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
566: , p8_a14 out nocopy JTF_NUMBER_TABLE
567: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
568: , p8_a16 out nocopy JTF_NUMBER_TABLE
569: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
570: , p8_a18 out nocopy JTF_NUMBER_TABLE
571: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
572: )
566: , p8_a14 out nocopy JTF_NUMBER_TABLE
567: , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
568: , p8_a16 out nocopy JTF_NUMBER_TABLE
569: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
570: , p8_a18 out nocopy JTF_NUMBER_TABLE
571: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
572: )
573:
574: as