1: package body okl_rep_pvt_w as
2: /* $Header: OKLIREPB.pls 120.0 2007/12/10 18:28:25 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package body okl_rep_pvt_w as
2: /* $Header: OKLIREPB.pls 120.0 2007/12/10 18:28:25 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: ) as
56: end loop;
57: end if;
58: end if;
59: end rosetta_table_copy_in_p2;
60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_300
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_NUMBER_TABLE
58: end if;
59: end rosetta_table_copy_in_p2;
60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_300
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_300
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100
67: , a7 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
70: , a10 out nocopy JTF_DATE_TABLE
71: , a11 out nocopy JTF_DATE_TABLE
72: , a12 out nocopy JTF_NUMBER_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_DATE_TABLE
76: , a16 out nocopy JTF_NUMBER_TABLE
70: , a10 out nocopy JTF_DATE_TABLE
71: , a11 out nocopy JTF_DATE_TABLE
72: , a12 out nocopy JTF_NUMBER_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_DATE_TABLE
76: , a16 out nocopy JTF_NUMBER_TABLE
77: , a17 out nocopy JTF_VARCHAR2_TABLE_100
78: , a18 out nocopy JTF_VARCHAR2_TABLE_100
72: , a12 out nocopy JTF_NUMBER_TABLE
73: , a13 out nocopy JTF_DATE_TABLE
74: , a14 out nocopy JTF_NUMBER_TABLE
75: , a15 out nocopy JTF_DATE_TABLE
76: , a16 out nocopy JTF_NUMBER_TABLE
77: , a17 out nocopy JTF_VARCHAR2_TABLE_100
78: , a18 out nocopy JTF_VARCHAR2_TABLE_100
79: , a19 out nocopy JTF_VARCHAR2_TABLE_100
80: ) as
80: ) as
81: ddindx binary_integer; indx binary_integer;
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_300();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_NUMBER_TABLE();
82: begin
83: if t is null or t.count = 0 then
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_300();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_VARCHAR2_TABLE_100();
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_300();
86: a2 := JTF_NUMBER_TABLE();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_NUMBER_TABLE();
89: a5 := JTF_VARCHAR2_TABLE_100();
90: a6 := JTF_VARCHAR2_TABLE_100();
91: a7 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_VARCHAR2_TABLE_100();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_VARCHAR2_TABLE_2000();
94: a10 := JTF_DATE_TABLE();
95: a11 := JTF_DATE_TABLE();
96: a12 := JTF_NUMBER_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_DATE_TABLE();
100: a16 := JTF_NUMBER_TABLE();
94: a10 := JTF_DATE_TABLE();
95: a11 := JTF_DATE_TABLE();
96: a12 := JTF_NUMBER_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_DATE_TABLE();
100: a16 := JTF_NUMBER_TABLE();
101: a17 := JTF_VARCHAR2_TABLE_100();
102: a18 := JTF_VARCHAR2_TABLE_100();
96: a12 := JTF_NUMBER_TABLE();
97: a13 := JTF_DATE_TABLE();
98: a14 := JTF_NUMBER_TABLE();
99: a15 := JTF_DATE_TABLE();
100: a16 := JTF_NUMBER_TABLE();
101: a17 := JTF_VARCHAR2_TABLE_100();
102: a18 := JTF_VARCHAR2_TABLE_100();
103: a19 := JTF_VARCHAR2_TABLE_100();
104: else
101: a17 := JTF_VARCHAR2_TABLE_100();
102: a18 := JTF_VARCHAR2_TABLE_100();
103: a19 := JTF_VARCHAR2_TABLE_100();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_300();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_VARCHAR2_TABLE_100();
109: a4 := JTF_NUMBER_TABLE();
103: a19 := JTF_VARCHAR2_TABLE_100();
104: else
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_300();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_VARCHAR2_TABLE_100();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_VARCHAR2_TABLE_100();
111: a6 := JTF_VARCHAR2_TABLE_100();
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_300();
107: a2 := JTF_NUMBER_TABLE();
108: a3 := JTF_VARCHAR2_TABLE_100();
109: a4 := JTF_NUMBER_TABLE();
110: a5 := JTF_VARCHAR2_TABLE_100();
111: a6 := JTF_VARCHAR2_TABLE_100();
112: a7 := JTF_VARCHAR2_TABLE_100();
113: a8 := JTF_VARCHAR2_TABLE_100();
113: a8 := JTF_VARCHAR2_TABLE_100();
114: a9 := JTF_VARCHAR2_TABLE_2000();
115: a10 := JTF_DATE_TABLE();
116: a11 := JTF_DATE_TABLE();
117: a12 := JTF_NUMBER_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_DATE_TABLE();
121: a16 := JTF_NUMBER_TABLE();
115: a10 := JTF_DATE_TABLE();
116: a11 := JTF_DATE_TABLE();
117: a12 := JTF_NUMBER_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_DATE_TABLE();
121: a16 := JTF_NUMBER_TABLE();
122: a17 := JTF_VARCHAR2_TABLE_100();
123: a18 := JTF_VARCHAR2_TABLE_100();
117: a12 := JTF_NUMBER_TABLE();
118: a13 := JTF_DATE_TABLE();
119: a14 := JTF_NUMBER_TABLE();
120: a15 := JTF_DATE_TABLE();
121: a16 := JTF_NUMBER_TABLE();
122: a17 := JTF_VARCHAR2_TABLE_100();
123: a18 := JTF_VARCHAR2_TABLE_100();
124: a19 := JTF_VARCHAR2_TABLE_100();
125: if t.count > 0 then
175: end if;
176: end if;
177: end rosetta_table_copy_out_p2;
178:
179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_300
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_NUMBER_TABLE
177: end rosetta_table_copy_out_p2;
178:
179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_300
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_VARCHAR2_TABLE_100
185: , a6 JTF_VARCHAR2_TABLE_100
179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_300
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_NUMBER_TABLE
184: , a5 JTF_VARCHAR2_TABLE_100
185: , a6 JTF_VARCHAR2_TABLE_100
186: , a7 JTF_DATE_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
186: , a7 JTF_DATE_TABLE
187: , a8 JTF_VARCHAR2_TABLE_100
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_DATE_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_DATE_TABLE
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_DATE_TABLE
194: , a15 JTF_NUMBER_TABLE
188: , a9 JTF_VARCHAR2_TABLE_100
189: , a10 JTF_DATE_TABLE
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_DATE_TABLE
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_DATE_TABLE
194: , a15 JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
190: , a11 JTF_NUMBER_TABLE
191: , a12 JTF_DATE_TABLE
192: , a13 JTF_NUMBER_TABLE
193: , a14 JTF_DATE_TABLE
194: , a15 JTF_NUMBER_TABLE
195: ) as
196: ddindx binary_integer; indx binary_integer;
197: begin
198: if a0 is not null and a0.count > 0 then
224: end loop;
225: end if;
226: end if;
227: end rosetta_table_copy_in_p5;
228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_VARCHAR2_TABLE_300
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_NUMBER_TABLE
226: end if;
227: end rosetta_table_copy_in_p5;
228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_VARCHAR2_TABLE_300
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_NUMBER_TABLE
233: , a5 out nocopy JTF_VARCHAR2_TABLE_100
234: , a6 out nocopy JTF_VARCHAR2_TABLE_100
228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_VARCHAR2_TABLE_300
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_NUMBER_TABLE
233: , a5 out nocopy JTF_VARCHAR2_TABLE_100
234: , a6 out nocopy JTF_VARCHAR2_TABLE_100
235: , a7 out nocopy JTF_DATE_TABLE
236: , a8 out nocopy JTF_VARCHAR2_TABLE_100
235: , a7 out nocopy JTF_DATE_TABLE
236: , a8 out nocopy JTF_VARCHAR2_TABLE_100
237: , a9 out nocopy JTF_VARCHAR2_TABLE_100
238: , a10 out nocopy JTF_DATE_TABLE
239: , a11 out nocopy JTF_NUMBER_TABLE
240: , a12 out nocopy JTF_DATE_TABLE
241: , a13 out nocopy JTF_NUMBER_TABLE
242: , a14 out nocopy JTF_DATE_TABLE
243: , a15 out nocopy JTF_NUMBER_TABLE
237: , a9 out nocopy JTF_VARCHAR2_TABLE_100
238: , a10 out nocopy JTF_DATE_TABLE
239: , a11 out nocopy JTF_NUMBER_TABLE
240: , a12 out nocopy JTF_DATE_TABLE
241: , a13 out nocopy JTF_NUMBER_TABLE
242: , a14 out nocopy JTF_DATE_TABLE
243: , a15 out nocopy JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
239: , a11 out nocopy JTF_NUMBER_TABLE
240: , a12 out nocopy JTF_DATE_TABLE
241: , a13 out nocopy JTF_NUMBER_TABLE
242: , a14 out nocopy JTF_DATE_TABLE
243: , a15 out nocopy JTF_NUMBER_TABLE
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
247: if t is null or t.count = 0 then
244: ) as
245: ddindx binary_integer; indx binary_integer;
246: begin
247: if t is null or t.count = 0 then
248: a0 := JTF_NUMBER_TABLE();
249: a1 := JTF_VARCHAR2_TABLE_300();
250: a2 := JTF_NUMBER_TABLE();
251: a3 := JTF_VARCHAR2_TABLE_100();
252: a4 := JTF_NUMBER_TABLE();
246: begin
247: if t is null or t.count = 0 then
248: a0 := JTF_NUMBER_TABLE();
249: a1 := JTF_VARCHAR2_TABLE_300();
250: a2 := JTF_NUMBER_TABLE();
251: a3 := JTF_VARCHAR2_TABLE_100();
252: a4 := JTF_NUMBER_TABLE();
253: a5 := JTF_VARCHAR2_TABLE_100();
254: a6 := JTF_VARCHAR2_TABLE_100();
248: a0 := JTF_NUMBER_TABLE();
249: a1 := JTF_VARCHAR2_TABLE_300();
250: a2 := JTF_NUMBER_TABLE();
251: a3 := JTF_VARCHAR2_TABLE_100();
252: a4 := JTF_NUMBER_TABLE();
253: a5 := JTF_VARCHAR2_TABLE_100();
254: a6 := JTF_VARCHAR2_TABLE_100();
255: a7 := JTF_DATE_TABLE();
256: a8 := JTF_VARCHAR2_TABLE_100();
255: a7 := JTF_DATE_TABLE();
256: a8 := JTF_VARCHAR2_TABLE_100();
257: a9 := JTF_VARCHAR2_TABLE_100();
258: a10 := JTF_DATE_TABLE();
259: a11 := JTF_NUMBER_TABLE();
260: a12 := JTF_DATE_TABLE();
261: a13 := JTF_NUMBER_TABLE();
262: a14 := JTF_DATE_TABLE();
263: a15 := JTF_NUMBER_TABLE();
257: a9 := JTF_VARCHAR2_TABLE_100();
258: a10 := JTF_DATE_TABLE();
259: a11 := JTF_NUMBER_TABLE();
260: a12 := JTF_DATE_TABLE();
261: a13 := JTF_NUMBER_TABLE();
262: a14 := JTF_DATE_TABLE();
263: a15 := JTF_NUMBER_TABLE();
264: else
265: a0 := JTF_NUMBER_TABLE();
259: a11 := JTF_NUMBER_TABLE();
260: a12 := JTF_DATE_TABLE();
261: a13 := JTF_NUMBER_TABLE();
262: a14 := JTF_DATE_TABLE();
263: a15 := JTF_NUMBER_TABLE();
264: else
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_300();
267: a2 := JTF_NUMBER_TABLE();
261: a13 := JTF_NUMBER_TABLE();
262: a14 := JTF_DATE_TABLE();
263: a15 := JTF_NUMBER_TABLE();
264: else
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_300();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_100();
269: a4 := JTF_NUMBER_TABLE();
263: a15 := JTF_NUMBER_TABLE();
264: else
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_300();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_100();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_VARCHAR2_TABLE_100();
271: a6 := JTF_VARCHAR2_TABLE_100();
265: a0 := JTF_NUMBER_TABLE();
266: a1 := JTF_VARCHAR2_TABLE_300();
267: a2 := JTF_NUMBER_TABLE();
268: a3 := JTF_VARCHAR2_TABLE_100();
269: a4 := JTF_NUMBER_TABLE();
270: a5 := JTF_VARCHAR2_TABLE_100();
271: a6 := JTF_VARCHAR2_TABLE_100();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_VARCHAR2_TABLE_100();
272: a7 := JTF_DATE_TABLE();
273: a8 := JTF_VARCHAR2_TABLE_100();
274: a9 := JTF_VARCHAR2_TABLE_100();
275: a10 := JTF_DATE_TABLE();
276: a11 := JTF_NUMBER_TABLE();
277: a12 := JTF_DATE_TABLE();
278: a13 := JTF_NUMBER_TABLE();
279: a14 := JTF_DATE_TABLE();
280: a15 := JTF_NUMBER_TABLE();
274: a9 := JTF_VARCHAR2_TABLE_100();
275: a10 := JTF_DATE_TABLE();
276: a11 := JTF_NUMBER_TABLE();
277: a12 := JTF_DATE_TABLE();
278: a13 := JTF_NUMBER_TABLE();
279: a14 := JTF_DATE_TABLE();
280: a15 := JTF_NUMBER_TABLE();
281: if t.count > 0 then
282: a0.extend(t.count);
276: a11 := JTF_NUMBER_TABLE();
277: a12 := JTF_DATE_TABLE();
278: a13 := JTF_NUMBER_TABLE();
279: a14 := JTF_DATE_TABLE();
280: a15 := JTF_NUMBER_TABLE();
281: if t.count > 0 then
282: a0.extend(t.count);
283: a1.extend(t.count);
284: a2.extend(t.count);
323: end if;
324: end if;
325: end rosetta_table_copy_out_p5;
326:
327: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_300
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_300
332: , a5 JTF_VARCHAR2_TABLE_2000
333: , a6 JTF_NUMBER_TABLE
334: , a7 JTF_DATE_TABLE
335: , a8 JTF_NUMBER_TABLE
336: , a9 JTF_DATE_TABLE
337: , a10 JTF_NUMBER_TABLE
331: , a4 JTF_VARCHAR2_TABLE_300
332: , a5 JTF_VARCHAR2_TABLE_2000
333: , a6 JTF_NUMBER_TABLE
334: , a7 JTF_DATE_TABLE
335: , a8 JTF_NUMBER_TABLE
336: , a9 JTF_DATE_TABLE
337: , a10 JTF_NUMBER_TABLE
338: ) as
339: ddindx binary_integer; indx binary_integer;
333: , a6 JTF_NUMBER_TABLE
334: , a7 JTF_DATE_TABLE
335: , a8 JTF_NUMBER_TABLE
336: , a9 JTF_DATE_TABLE
337: , a10 JTF_NUMBER_TABLE
338: ) as
339: ddindx binary_integer; indx binary_integer;
340: begin
341: if a0 is not null and a0.count > 0 then
362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p8;
366: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_VARCHAR2_TABLE_100
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_VARCHAR2_TABLE_300
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_VARCHAR2_TABLE_300
371: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_DATE_TABLE
374: , a8 out nocopy JTF_NUMBER_TABLE
375: , a9 out nocopy JTF_DATE_TABLE
376: , a10 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_300
371: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_DATE_TABLE
374: , a8 out nocopy JTF_NUMBER_TABLE
375: , a9 out nocopy JTF_DATE_TABLE
376: , a10 out nocopy JTF_NUMBER_TABLE
377: ) as
378: ddindx binary_integer; indx binary_integer;
372: , a6 out nocopy JTF_NUMBER_TABLE
373: , a7 out nocopy JTF_DATE_TABLE
374: , a8 out nocopy JTF_NUMBER_TABLE
375: , a9 out nocopy JTF_DATE_TABLE
376: , a10 out nocopy JTF_NUMBER_TABLE
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin
380: if t is null or t.count = 0 then
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin
380: if t is null or t.count = 0 then
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_VARCHAR2_TABLE_100();
383: a2 := JTF_VARCHAR2_TABLE_100();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_300();
383: a2 := JTF_VARCHAR2_TABLE_100();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_300();
386: a5 := JTF_VARCHAR2_TABLE_2000();
387: a6 := JTF_NUMBER_TABLE();
388: a7 := JTF_DATE_TABLE();
389: a8 := JTF_NUMBER_TABLE();
390: a9 := JTF_DATE_TABLE();
391: a10 := JTF_NUMBER_TABLE();
385: a4 := JTF_VARCHAR2_TABLE_300();
386: a5 := JTF_VARCHAR2_TABLE_2000();
387: a6 := JTF_NUMBER_TABLE();
388: a7 := JTF_DATE_TABLE();
389: a8 := JTF_NUMBER_TABLE();
390: a9 := JTF_DATE_TABLE();
391: a10 := JTF_NUMBER_TABLE();
392: else
393: a0 := JTF_NUMBER_TABLE();
387: a6 := JTF_NUMBER_TABLE();
388: a7 := JTF_DATE_TABLE();
389: a8 := JTF_NUMBER_TABLE();
390: a9 := JTF_DATE_TABLE();
391: a10 := JTF_NUMBER_TABLE();
392: else
393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_VARCHAR2_TABLE_100();
395: a2 := JTF_VARCHAR2_TABLE_100();
389: a8 := JTF_NUMBER_TABLE();
390: a9 := JTF_DATE_TABLE();
391: a10 := JTF_NUMBER_TABLE();
392: else
393: a0 := JTF_NUMBER_TABLE();
394: a1 := JTF_VARCHAR2_TABLE_100();
395: a2 := JTF_VARCHAR2_TABLE_100();
396: a3 := JTF_VARCHAR2_TABLE_100();
397: a4 := JTF_VARCHAR2_TABLE_300();
395: a2 := JTF_VARCHAR2_TABLE_100();
396: a3 := JTF_VARCHAR2_TABLE_100();
397: a4 := JTF_VARCHAR2_TABLE_300();
398: a5 := JTF_VARCHAR2_TABLE_2000();
399: a6 := JTF_NUMBER_TABLE();
400: a7 := JTF_DATE_TABLE();
401: a8 := JTF_NUMBER_TABLE();
402: a9 := JTF_DATE_TABLE();
403: a10 := JTF_NUMBER_TABLE();
397: a4 := JTF_VARCHAR2_TABLE_300();
398: a5 := JTF_VARCHAR2_TABLE_2000();
399: a6 := JTF_NUMBER_TABLE();
400: a7 := JTF_DATE_TABLE();
401: a8 := JTF_NUMBER_TABLE();
402: a9 := JTF_DATE_TABLE();
403: a10 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
399: a6 := JTF_NUMBER_TABLE();
400: a7 := JTF_DATE_TABLE();
401: a8 := JTF_NUMBER_TABLE();
402: a9 := JTF_DATE_TABLE();
403: a10 := JTF_NUMBER_TABLE();
404: if t.count > 0 then
405: a0.extend(t.count);
406: a1.extend(t.count);
407: a2.extend(t.count);
560: , p_init_msg_list VARCHAR2
561: , x_return_status out nocopy VARCHAR2
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: , p5_a0 JTF_NUMBER_TABLE
565: , p5_a1 JTF_VARCHAR2_TABLE_300
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_VARCHAR2_TABLE_100
568: , p5_a4 JTF_NUMBER_TABLE
562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: , p5_a0 JTF_NUMBER_TABLE
565: , p5_a1 JTF_VARCHAR2_TABLE_300
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_VARCHAR2_TABLE_100
568: , p5_a4 JTF_NUMBER_TABLE
569: , p5_a5 JTF_VARCHAR2_TABLE_100
570: , p5_a6 JTF_VARCHAR2_TABLE_100
564: , p5_a0 JTF_NUMBER_TABLE
565: , p5_a1 JTF_VARCHAR2_TABLE_300
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_VARCHAR2_TABLE_100
568: , p5_a4 JTF_NUMBER_TABLE
569: , p5_a5 JTF_VARCHAR2_TABLE_100
570: , p5_a6 JTF_VARCHAR2_TABLE_100
571: , p5_a7 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_VARCHAR2_TABLE_100
573: , p5_a9 JTF_VARCHAR2_TABLE_2000
574: , p5_a10 JTF_DATE_TABLE
575: , p5_a11 JTF_DATE_TABLE
576: , p5_a12 JTF_NUMBER_TABLE
577: , p5_a13 JTF_DATE_TABLE
578: , p5_a14 JTF_NUMBER_TABLE
579: , p5_a15 JTF_DATE_TABLE
580: , p5_a16 JTF_NUMBER_TABLE
574: , p5_a10 JTF_DATE_TABLE
575: , p5_a11 JTF_DATE_TABLE
576: , p5_a12 JTF_NUMBER_TABLE
577: , p5_a13 JTF_DATE_TABLE
578: , p5_a14 JTF_NUMBER_TABLE
579: , p5_a15 JTF_DATE_TABLE
580: , p5_a16 JTF_NUMBER_TABLE
581: , p5_a17 JTF_VARCHAR2_TABLE_100
582: , p5_a18 JTF_VARCHAR2_TABLE_100
576: , p5_a12 JTF_NUMBER_TABLE
577: , p5_a13 JTF_DATE_TABLE
578: , p5_a14 JTF_NUMBER_TABLE
579: , p5_a15 JTF_DATE_TABLE
580: , p5_a16 JTF_NUMBER_TABLE
581: , p5_a17 JTF_VARCHAR2_TABLE_100
582: , p5_a18 JTF_VARCHAR2_TABLE_100
583: , p5_a19 JTF_VARCHAR2_TABLE_100
584: , p6_a0 out nocopy JTF_NUMBER_TABLE
580: , p5_a16 JTF_NUMBER_TABLE
581: , p5_a17 JTF_VARCHAR2_TABLE_100
582: , p5_a18 JTF_VARCHAR2_TABLE_100
583: , p5_a19 JTF_VARCHAR2_TABLE_100
584: , p6_a0 out nocopy JTF_NUMBER_TABLE
585: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
586: , p6_a2 out nocopy JTF_NUMBER_TABLE
587: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a4 out nocopy JTF_NUMBER_TABLE
582: , p5_a18 JTF_VARCHAR2_TABLE_100
583: , p5_a19 JTF_VARCHAR2_TABLE_100
584: , p6_a0 out nocopy JTF_NUMBER_TABLE
585: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
586: , p6_a2 out nocopy JTF_NUMBER_TABLE
587: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a4 out nocopy JTF_NUMBER_TABLE
589: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
584: , p6_a0 out nocopy JTF_NUMBER_TABLE
585: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
586: , p6_a2 out nocopy JTF_NUMBER_TABLE
587: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a4 out nocopy JTF_NUMBER_TABLE
589: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
593: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
594: , p6_a10 out nocopy JTF_DATE_TABLE
595: , p6_a11 out nocopy JTF_DATE_TABLE
596: , p6_a12 out nocopy JTF_NUMBER_TABLE
597: , p6_a13 out nocopy JTF_DATE_TABLE
598: , p6_a14 out nocopy JTF_NUMBER_TABLE
599: , p6_a15 out nocopy JTF_DATE_TABLE
600: , p6_a16 out nocopy JTF_NUMBER_TABLE
594: , p6_a10 out nocopy JTF_DATE_TABLE
595: , p6_a11 out nocopy JTF_DATE_TABLE
596: , p6_a12 out nocopy JTF_NUMBER_TABLE
597: , p6_a13 out nocopy JTF_DATE_TABLE
598: , p6_a14 out nocopy JTF_NUMBER_TABLE
599: , p6_a15 out nocopy JTF_DATE_TABLE
600: , p6_a16 out nocopy JTF_NUMBER_TABLE
601: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a12 out nocopy JTF_NUMBER_TABLE
597: , p6_a13 out nocopy JTF_DATE_TABLE
598: , p6_a14 out nocopy JTF_NUMBER_TABLE
599: , p6_a15 out nocopy JTF_DATE_TABLE
600: , p6_a16 out nocopy JTF_NUMBER_TABLE
601: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
604: , p7_a0 in out nocopy JTF_NUMBER_TABLE
600: , p6_a16 out nocopy JTF_NUMBER_TABLE
601: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
602: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
604: , p7_a0 in out nocopy JTF_NUMBER_TABLE
605: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a2 in out nocopy JTF_NUMBER_TABLE
607: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
608: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
604: , p7_a0 in out nocopy JTF_NUMBER_TABLE
605: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a2 in out nocopy JTF_NUMBER_TABLE
607: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
608: , p7_a4 in out nocopy JTF_NUMBER_TABLE
609: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
604: , p7_a0 in out nocopy JTF_NUMBER_TABLE
605: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
606: , p7_a2 in out nocopy JTF_NUMBER_TABLE
607: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
608: , p7_a4 in out nocopy JTF_NUMBER_TABLE
609: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
610: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
611: )
612:
708: , p_init_msg_list VARCHAR2
709: , x_return_status out nocopy VARCHAR2
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_VARCHAR2_TABLE_300
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_VARCHAR2_TABLE_100
716: , p5_a4 JTF_NUMBER_TABLE
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_VARCHAR2_TABLE_300
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_VARCHAR2_TABLE_100
716: , p5_a4 JTF_NUMBER_TABLE
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_VARCHAR2_TABLE_100
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_VARCHAR2_TABLE_300
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_VARCHAR2_TABLE_100
716: , p5_a4 JTF_NUMBER_TABLE
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_VARCHAR2_TABLE_100
719: , p5_a7 JTF_VARCHAR2_TABLE_100
720: , p5_a8 JTF_VARCHAR2_TABLE_100
720: , p5_a8 JTF_VARCHAR2_TABLE_100
721: , p5_a9 JTF_VARCHAR2_TABLE_2000
722: , p5_a10 JTF_DATE_TABLE
723: , p5_a11 JTF_DATE_TABLE
724: , p5_a12 JTF_NUMBER_TABLE
725: , p5_a13 JTF_DATE_TABLE
726: , p5_a14 JTF_NUMBER_TABLE
727: , p5_a15 JTF_DATE_TABLE
728: , p5_a16 JTF_NUMBER_TABLE
722: , p5_a10 JTF_DATE_TABLE
723: , p5_a11 JTF_DATE_TABLE
724: , p5_a12 JTF_NUMBER_TABLE
725: , p5_a13 JTF_DATE_TABLE
726: , p5_a14 JTF_NUMBER_TABLE
727: , p5_a15 JTF_DATE_TABLE
728: , p5_a16 JTF_NUMBER_TABLE
729: , p5_a17 JTF_VARCHAR2_TABLE_100
730: , p5_a18 JTF_VARCHAR2_TABLE_100
724: , p5_a12 JTF_NUMBER_TABLE
725: , p5_a13 JTF_DATE_TABLE
726: , p5_a14 JTF_NUMBER_TABLE
727: , p5_a15 JTF_DATE_TABLE
728: , p5_a16 JTF_NUMBER_TABLE
729: , p5_a17 JTF_VARCHAR2_TABLE_100
730: , p5_a18 JTF_VARCHAR2_TABLE_100
731: , p5_a19 JTF_VARCHAR2_TABLE_100
732: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p5_a16 JTF_NUMBER_TABLE
729: , p5_a17 JTF_VARCHAR2_TABLE_100
730: , p5_a18 JTF_VARCHAR2_TABLE_100
731: , p5_a19 JTF_VARCHAR2_TABLE_100
732: , p6_a0 out nocopy JTF_NUMBER_TABLE
733: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
734: , p6_a2 out nocopy JTF_NUMBER_TABLE
735: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a4 out nocopy JTF_NUMBER_TABLE
730: , p5_a18 JTF_VARCHAR2_TABLE_100
731: , p5_a19 JTF_VARCHAR2_TABLE_100
732: , p6_a0 out nocopy JTF_NUMBER_TABLE
733: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
734: , p6_a2 out nocopy JTF_NUMBER_TABLE
735: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a4 out nocopy JTF_NUMBER_TABLE
737: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
738: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
732: , p6_a0 out nocopy JTF_NUMBER_TABLE
733: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
734: , p6_a2 out nocopy JTF_NUMBER_TABLE
735: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a4 out nocopy JTF_NUMBER_TABLE
737: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
738: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
742: , p6_a10 out nocopy JTF_DATE_TABLE
743: , p6_a11 out nocopy JTF_DATE_TABLE
744: , p6_a12 out nocopy JTF_NUMBER_TABLE
745: , p6_a13 out nocopy JTF_DATE_TABLE
746: , p6_a14 out nocopy JTF_NUMBER_TABLE
747: , p6_a15 out nocopy JTF_DATE_TABLE
748: , p6_a16 out nocopy JTF_NUMBER_TABLE
742: , p6_a10 out nocopy JTF_DATE_TABLE
743: , p6_a11 out nocopy JTF_DATE_TABLE
744: , p6_a12 out nocopy JTF_NUMBER_TABLE
745: , p6_a13 out nocopy JTF_DATE_TABLE
746: , p6_a14 out nocopy JTF_NUMBER_TABLE
747: , p6_a15 out nocopy JTF_DATE_TABLE
748: , p6_a16 out nocopy JTF_NUMBER_TABLE
749: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
744: , p6_a12 out nocopy JTF_NUMBER_TABLE
745: , p6_a13 out nocopy JTF_DATE_TABLE
746: , p6_a14 out nocopy JTF_NUMBER_TABLE
747: , p6_a15 out nocopy JTF_DATE_TABLE
748: , p6_a16 out nocopy JTF_NUMBER_TABLE
749: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
752: )
904: , p_init_msg_list VARCHAR2
905: , x_return_status out nocopy VARCHAR2
906: , x_msg_count out nocopy NUMBER
907: , x_msg_data out nocopy VARCHAR2
908: , p5_a0 JTF_NUMBER_TABLE
909: , p5_a1 JTF_VARCHAR2_TABLE_300
910: , p5_a2 JTF_NUMBER_TABLE
911: , p5_a3 JTF_VARCHAR2_TABLE_100
912: , p5_a4 JTF_NUMBER_TABLE
906: , x_msg_count out nocopy NUMBER
907: , x_msg_data out nocopy VARCHAR2
908: , p5_a0 JTF_NUMBER_TABLE
909: , p5_a1 JTF_VARCHAR2_TABLE_300
910: , p5_a2 JTF_NUMBER_TABLE
911: , p5_a3 JTF_VARCHAR2_TABLE_100
912: , p5_a4 JTF_NUMBER_TABLE
913: , p5_a5 JTF_VARCHAR2_TABLE_100
914: , p5_a6 JTF_VARCHAR2_TABLE_100
908: , p5_a0 JTF_NUMBER_TABLE
909: , p5_a1 JTF_VARCHAR2_TABLE_300
910: , p5_a2 JTF_NUMBER_TABLE
911: , p5_a3 JTF_VARCHAR2_TABLE_100
912: , p5_a4 JTF_NUMBER_TABLE
913: , p5_a5 JTF_VARCHAR2_TABLE_100
914: , p5_a6 JTF_VARCHAR2_TABLE_100
915: , p5_a7 JTF_VARCHAR2_TABLE_100
916: , p5_a8 JTF_VARCHAR2_TABLE_100
916: , p5_a8 JTF_VARCHAR2_TABLE_100
917: , p5_a9 JTF_VARCHAR2_TABLE_2000
918: , p5_a10 JTF_DATE_TABLE
919: , p5_a11 JTF_DATE_TABLE
920: , p5_a12 JTF_NUMBER_TABLE
921: , p5_a13 JTF_DATE_TABLE
922: , p5_a14 JTF_NUMBER_TABLE
923: , p5_a15 JTF_DATE_TABLE
924: , p5_a16 JTF_NUMBER_TABLE
918: , p5_a10 JTF_DATE_TABLE
919: , p5_a11 JTF_DATE_TABLE
920: , p5_a12 JTF_NUMBER_TABLE
921: , p5_a13 JTF_DATE_TABLE
922: , p5_a14 JTF_NUMBER_TABLE
923: , p5_a15 JTF_DATE_TABLE
924: , p5_a16 JTF_NUMBER_TABLE
925: , p5_a17 JTF_VARCHAR2_TABLE_100
926: , p5_a18 JTF_VARCHAR2_TABLE_100
920: , p5_a12 JTF_NUMBER_TABLE
921: , p5_a13 JTF_DATE_TABLE
922: , p5_a14 JTF_NUMBER_TABLE
923: , p5_a15 JTF_DATE_TABLE
924: , p5_a16 JTF_NUMBER_TABLE
925: , p5_a17 JTF_VARCHAR2_TABLE_100
926: , p5_a18 JTF_VARCHAR2_TABLE_100
927: , p5_a19 JTF_VARCHAR2_TABLE_100
928: , p6_a0 in out nocopy JTF_NUMBER_TABLE
924: , p5_a16 JTF_NUMBER_TABLE
925: , p5_a17 JTF_VARCHAR2_TABLE_100
926: , p5_a18 JTF_VARCHAR2_TABLE_100
927: , p5_a19 JTF_VARCHAR2_TABLE_100
928: , p6_a0 in out nocopy JTF_NUMBER_TABLE
929: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
930: , p6_a2 in out nocopy JTF_NUMBER_TABLE
931: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
932: , p6_a4 in out nocopy JTF_NUMBER_TABLE
926: , p5_a18 JTF_VARCHAR2_TABLE_100
927: , p5_a19 JTF_VARCHAR2_TABLE_100
928: , p6_a0 in out nocopy JTF_NUMBER_TABLE
929: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
930: , p6_a2 in out nocopy JTF_NUMBER_TABLE
931: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
932: , p6_a4 in out nocopy JTF_NUMBER_TABLE
933: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
928: , p6_a0 in out nocopy JTF_NUMBER_TABLE
929: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
930: , p6_a2 in out nocopy JTF_NUMBER_TABLE
931: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
932: , p6_a4 in out nocopy JTF_NUMBER_TABLE
933: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
934: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
935: )
936:
1007: , p_init_msg_list VARCHAR2
1008: , x_return_status out nocopy VARCHAR2
1009: , x_msg_count out nocopy NUMBER
1010: , x_msg_data out nocopy VARCHAR2
1011: , p5_a0 JTF_NUMBER_TABLE
1012: , p5_a1 JTF_VARCHAR2_TABLE_300
1013: , p5_a2 JTF_NUMBER_TABLE
1014: , p5_a3 JTF_VARCHAR2_TABLE_100
1015: , p5_a4 JTF_NUMBER_TABLE
1009: , x_msg_count out nocopy NUMBER
1010: , x_msg_data out nocopy VARCHAR2
1011: , p5_a0 JTF_NUMBER_TABLE
1012: , p5_a1 JTF_VARCHAR2_TABLE_300
1013: , p5_a2 JTF_NUMBER_TABLE
1014: , p5_a3 JTF_VARCHAR2_TABLE_100
1015: , p5_a4 JTF_NUMBER_TABLE
1016: , p5_a5 JTF_VARCHAR2_TABLE_100
1017: , p5_a6 JTF_VARCHAR2_TABLE_100
1011: , p5_a0 JTF_NUMBER_TABLE
1012: , p5_a1 JTF_VARCHAR2_TABLE_300
1013: , p5_a2 JTF_NUMBER_TABLE
1014: , p5_a3 JTF_VARCHAR2_TABLE_100
1015: , p5_a4 JTF_NUMBER_TABLE
1016: , p5_a5 JTF_VARCHAR2_TABLE_100
1017: , p5_a6 JTF_VARCHAR2_TABLE_100
1018: , p5_a7 JTF_VARCHAR2_TABLE_100
1019: , p5_a8 JTF_VARCHAR2_TABLE_100
1019: , p5_a8 JTF_VARCHAR2_TABLE_100
1020: , p5_a9 JTF_VARCHAR2_TABLE_2000
1021: , p5_a10 JTF_DATE_TABLE
1022: , p5_a11 JTF_DATE_TABLE
1023: , p5_a12 JTF_NUMBER_TABLE
1024: , p5_a13 JTF_DATE_TABLE
1025: , p5_a14 JTF_NUMBER_TABLE
1026: , p5_a15 JTF_DATE_TABLE
1027: , p5_a16 JTF_NUMBER_TABLE
1021: , p5_a10 JTF_DATE_TABLE
1022: , p5_a11 JTF_DATE_TABLE
1023: , p5_a12 JTF_NUMBER_TABLE
1024: , p5_a13 JTF_DATE_TABLE
1025: , p5_a14 JTF_NUMBER_TABLE
1026: , p5_a15 JTF_DATE_TABLE
1027: , p5_a16 JTF_NUMBER_TABLE
1028: , p5_a17 JTF_VARCHAR2_TABLE_100
1029: , p5_a18 JTF_VARCHAR2_TABLE_100
1023: , p5_a12 JTF_NUMBER_TABLE
1024: , p5_a13 JTF_DATE_TABLE
1025: , p5_a14 JTF_NUMBER_TABLE
1026: , p5_a15 JTF_DATE_TABLE
1027: , p5_a16 JTF_NUMBER_TABLE
1028: , p5_a17 JTF_VARCHAR2_TABLE_100
1029: , p5_a18 JTF_VARCHAR2_TABLE_100
1030: , p5_a19 JTF_VARCHAR2_TABLE_100
1031: )
1202: , p_init_msg_list VARCHAR2
1203: , x_return_status out nocopy VARCHAR2
1204: , x_msg_count out nocopy NUMBER
1205: , x_msg_data out nocopy VARCHAR2
1206: , p5_a0 JTF_NUMBER_TABLE
1207: , p5_a1 JTF_VARCHAR2_TABLE_300
1208: , p5_a2 JTF_NUMBER_TABLE
1209: , p5_a3 JTF_VARCHAR2_TABLE_100
1210: , p5_a4 JTF_NUMBER_TABLE
1204: , x_msg_count out nocopy NUMBER
1205: , x_msg_data out nocopy VARCHAR2
1206: , p5_a0 JTF_NUMBER_TABLE
1207: , p5_a1 JTF_VARCHAR2_TABLE_300
1208: , p5_a2 JTF_NUMBER_TABLE
1209: , p5_a3 JTF_VARCHAR2_TABLE_100
1210: , p5_a4 JTF_NUMBER_TABLE
1211: , p5_a5 JTF_VARCHAR2_TABLE_100
1212: , p5_a6 JTF_VARCHAR2_TABLE_100
1206: , p5_a0 JTF_NUMBER_TABLE
1207: , p5_a1 JTF_VARCHAR2_TABLE_300
1208: , p5_a2 JTF_NUMBER_TABLE
1209: , p5_a3 JTF_VARCHAR2_TABLE_100
1210: , p5_a4 JTF_NUMBER_TABLE
1211: , p5_a5 JTF_VARCHAR2_TABLE_100
1212: , p5_a6 JTF_VARCHAR2_TABLE_100
1213: , p5_a7 JTF_VARCHAR2_TABLE_100
1214: , p5_a8 JTF_VARCHAR2_TABLE_100
1214: , p5_a8 JTF_VARCHAR2_TABLE_100
1215: , p5_a9 JTF_VARCHAR2_TABLE_2000
1216: , p5_a10 JTF_DATE_TABLE
1217: , p5_a11 JTF_DATE_TABLE
1218: , p5_a12 JTF_NUMBER_TABLE
1219: , p5_a13 JTF_DATE_TABLE
1220: , p5_a14 JTF_NUMBER_TABLE
1221: , p5_a15 JTF_DATE_TABLE
1222: , p5_a16 JTF_NUMBER_TABLE
1216: , p5_a10 JTF_DATE_TABLE
1217: , p5_a11 JTF_DATE_TABLE
1218: , p5_a12 JTF_NUMBER_TABLE
1219: , p5_a13 JTF_DATE_TABLE
1220: , p5_a14 JTF_NUMBER_TABLE
1221: , p5_a15 JTF_DATE_TABLE
1222: , p5_a16 JTF_NUMBER_TABLE
1223: , p5_a17 JTF_VARCHAR2_TABLE_100
1224: , p5_a18 JTF_VARCHAR2_TABLE_100
1218: , p5_a12 JTF_NUMBER_TABLE
1219: , p5_a13 JTF_DATE_TABLE
1220: , p5_a14 JTF_NUMBER_TABLE
1221: , p5_a15 JTF_DATE_TABLE
1222: , p5_a16 JTF_NUMBER_TABLE
1223: , p5_a17 JTF_VARCHAR2_TABLE_100
1224: , p5_a18 JTF_VARCHAR2_TABLE_100
1225: , p5_a19 JTF_VARCHAR2_TABLE_100
1226: , p6_a0 out nocopy JTF_NUMBER_TABLE
1222: , p5_a16 JTF_NUMBER_TABLE
1223: , p5_a17 JTF_VARCHAR2_TABLE_100
1224: , p5_a18 JTF_VARCHAR2_TABLE_100
1225: , p5_a19 JTF_VARCHAR2_TABLE_100
1226: , p6_a0 out nocopy JTF_NUMBER_TABLE
1227: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1228: , p6_a2 out nocopy JTF_NUMBER_TABLE
1229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a4 out nocopy JTF_NUMBER_TABLE
1224: , p5_a18 JTF_VARCHAR2_TABLE_100
1225: , p5_a19 JTF_VARCHAR2_TABLE_100
1226: , p6_a0 out nocopy JTF_NUMBER_TABLE
1227: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1228: , p6_a2 out nocopy JTF_NUMBER_TABLE
1229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a4 out nocopy JTF_NUMBER_TABLE
1231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1226: , p6_a0 out nocopy JTF_NUMBER_TABLE
1227: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1228: , p6_a2 out nocopy JTF_NUMBER_TABLE
1229: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1230: , p6_a4 out nocopy JTF_NUMBER_TABLE
1231: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1232: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1233: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1234: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1234: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1235: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1236: , p6_a10 out nocopy JTF_DATE_TABLE
1237: , p6_a11 out nocopy JTF_DATE_TABLE
1238: , p6_a12 out nocopy JTF_NUMBER_TABLE
1239: , p6_a13 out nocopy JTF_DATE_TABLE
1240: , p6_a14 out nocopy JTF_NUMBER_TABLE
1241: , p6_a15 out nocopy JTF_DATE_TABLE
1242: , p6_a16 out nocopy JTF_NUMBER_TABLE
1236: , p6_a10 out nocopy JTF_DATE_TABLE
1237: , p6_a11 out nocopy JTF_DATE_TABLE
1238: , p6_a12 out nocopy JTF_NUMBER_TABLE
1239: , p6_a13 out nocopy JTF_DATE_TABLE
1240: , p6_a14 out nocopy JTF_NUMBER_TABLE
1241: , p6_a15 out nocopy JTF_DATE_TABLE
1242: , p6_a16 out nocopy JTF_NUMBER_TABLE
1243: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1238: , p6_a12 out nocopy JTF_NUMBER_TABLE
1239: , p6_a13 out nocopy JTF_DATE_TABLE
1240: , p6_a14 out nocopy JTF_NUMBER_TABLE
1241: , p6_a15 out nocopy JTF_DATE_TABLE
1242: , p6_a16 out nocopy JTF_NUMBER_TABLE
1243: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1242: , p6_a16 out nocopy JTF_NUMBER_TABLE
1243: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1247: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1248: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1249: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1250: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1244: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1245: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1247: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1248: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1249: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1250: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1251: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1252: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1246: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1247: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1248: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1249: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1250: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1251: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1252: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1253: )
1254:
1350: , p_init_msg_list VARCHAR2
1351: , x_return_status out nocopy VARCHAR2
1352: , x_msg_count out nocopy NUMBER
1353: , x_msg_data out nocopy VARCHAR2
1354: , p5_a0 JTF_NUMBER_TABLE
1355: , p5_a1 JTF_VARCHAR2_TABLE_300
1356: , p5_a2 JTF_NUMBER_TABLE
1357: , p5_a3 JTF_VARCHAR2_TABLE_100
1358: , p5_a4 JTF_NUMBER_TABLE
1352: , x_msg_count out nocopy NUMBER
1353: , x_msg_data out nocopy VARCHAR2
1354: , p5_a0 JTF_NUMBER_TABLE
1355: , p5_a1 JTF_VARCHAR2_TABLE_300
1356: , p5_a2 JTF_NUMBER_TABLE
1357: , p5_a3 JTF_VARCHAR2_TABLE_100
1358: , p5_a4 JTF_NUMBER_TABLE
1359: , p5_a5 JTF_VARCHAR2_TABLE_100
1360: , p5_a6 JTF_VARCHAR2_TABLE_100
1354: , p5_a0 JTF_NUMBER_TABLE
1355: , p5_a1 JTF_VARCHAR2_TABLE_300
1356: , p5_a2 JTF_NUMBER_TABLE
1357: , p5_a3 JTF_VARCHAR2_TABLE_100
1358: , p5_a4 JTF_NUMBER_TABLE
1359: , p5_a5 JTF_VARCHAR2_TABLE_100
1360: , p5_a6 JTF_VARCHAR2_TABLE_100
1361: , p5_a7 JTF_VARCHAR2_TABLE_100
1362: , p5_a8 JTF_VARCHAR2_TABLE_100
1362: , p5_a8 JTF_VARCHAR2_TABLE_100
1363: , p5_a9 JTF_VARCHAR2_TABLE_2000
1364: , p5_a10 JTF_DATE_TABLE
1365: , p5_a11 JTF_DATE_TABLE
1366: , p5_a12 JTF_NUMBER_TABLE
1367: , p5_a13 JTF_DATE_TABLE
1368: , p5_a14 JTF_NUMBER_TABLE
1369: , p5_a15 JTF_DATE_TABLE
1370: , p5_a16 JTF_NUMBER_TABLE
1364: , p5_a10 JTF_DATE_TABLE
1365: , p5_a11 JTF_DATE_TABLE
1366: , p5_a12 JTF_NUMBER_TABLE
1367: , p5_a13 JTF_DATE_TABLE
1368: , p5_a14 JTF_NUMBER_TABLE
1369: , p5_a15 JTF_DATE_TABLE
1370: , p5_a16 JTF_NUMBER_TABLE
1371: , p5_a17 JTF_VARCHAR2_TABLE_100
1372: , p5_a18 JTF_VARCHAR2_TABLE_100
1366: , p5_a12 JTF_NUMBER_TABLE
1367: , p5_a13 JTF_DATE_TABLE
1368: , p5_a14 JTF_NUMBER_TABLE
1369: , p5_a15 JTF_DATE_TABLE
1370: , p5_a16 JTF_NUMBER_TABLE
1371: , p5_a17 JTF_VARCHAR2_TABLE_100
1372: , p5_a18 JTF_VARCHAR2_TABLE_100
1373: , p5_a19 JTF_VARCHAR2_TABLE_100
1374: , p6_a0 out nocopy JTF_NUMBER_TABLE
1370: , p5_a16 JTF_NUMBER_TABLE
1371: , p5_a17 JTF_VARCHAR2_TABLE_100
1372: , p5_a18 JTF_VARCHAR2_TABLE_100
1373: , p5_a19 JTF_VARCHAR2_TABLE_100
1374: , p6_a0 out nocopy JTF_NUMBER_TABLE
1375: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1376: , p6_a2 out nocopy JTF_NUMBER_TABLE
1377: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1378: , p6_a4 out nocopy JTF_NUMBER_TABLE
1372: , p5_a18 JTF_VARCHAR2_TABLE_100
1373: , p5_a19 JTF_VARCHAR2_TABLE_100
1374: , p6_a0 out nocopy JTF_NUMBER_TABLE
1375: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1376: , p6_a2 out nocopy JTF_NUMBER_TABLE
1377: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1378: , p6_a4 out nocopy JTF_NUMBER_TABLE
1379: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1380: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1374: , p6_a0 out nocopy JTF_NUMBER_TABLE
1375: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1376: , p6_a2 out nocopy JTF_NUMBER_TABLE
1377: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1378: , p6_a4 out nocopy JTF_NUMBER_TABLE
1379: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1380: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1382: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1382: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1383: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1384: , p6_a10 out nocopy JTF_DATE_TABLE
1385: , p6_a11 out nocopy JTF_DATE_TABLE
1386: , p6_a12 out nocopy JTF_NUMBER_TABLE
1387: , p6_a13 out nocopy JTF_DATE_TABLE
1388: , p6_a14 out nocopy JTF_NUMBER_TABLE
1389: , p6_a15 out nocopy JTF_DATE_TABLE
1390: , p6_a16 out nocopy JTF_NUMBER_TABLE
1384: , p6_a10 out nocopy JTF_DATE_TABLE
1385: , p6_a11 out nocopy JTF_DATE_TABLE
1386: , p6_a12 out nocopy JTF_NUMBER_TABLE
1387: , p6_a13 out nocopy JTF_DATE_TABLE
1388: , p6_a14 out nocopy JTF_NUMBER_TABLE
1389: , p6_a15 out nocopy JTF_DATE_TABLE
1390: , p6_a16 out nocopy JTF_NUMBER_TABLE
1391: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1392: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1386: , p6_a12 out nocopy JTF_NUMBER_TABLE
1387: , p6_a13 out nocopy JTF_DATE_TABLE
1388: , p6_a14 out nocopy JTF_NUMBER_TABLE
1389: , p6_a15 out nocopy JTF_DATE_TABLE
1390: , p6_a16 out nocopy JTF_NUMBER_TABLE
1391: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1392: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1393: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1394: )
1546: , p_init_msg_list VARCHAR2
1547: , x_return_status out nocopy VARCHAR2
1548: , x_msg_count out nocopy NUMBER
1549: , x_msg_data out nocopy VARCHAR2
1550: , p5_a0 JTF_NUMBER_TABLE
1551: , p5_a1 JTF_VARCHAR2_TABLE_300
1552: , p5_a2 JTF_NUMBER_TABLE
1553: , p5_a3 JTF_VARCHAR2_TABLE_100
1554: , p5_a4 JTF_NUMBER_TABLE
1548: , x_msg_count out nocopy NUMBER
1549: , x_msg_data out nocopy VARCHAR2
1550: , p5_a0 JTF_NUMBER_TABLE
1551: , p5_a1 JTF_VARCHAR2_TABLE_300
1552: , p5_a2 JTF_NUMBER_TABLE
1553: , p5_a3 JTF_VARCHAR2_TABLE_100
1554: , p5_a4 JTF_NUMBER_TABLE
1555: , p5_a5 JTF_VARCHAR2_TABLE_100
1556: , p5_a6 JTF_VARCHAR2_TABLE_100
1550: , p5_a0 JTF_NUMBER_TABLE
1551: , p5_a1 JTF_VARCHAR2_TABLE_300
1552: , p5_a2 JTF_NUMBER_TABLE
1553: , p5_a3 JTF_VARCHAR2_TABLE_100
1554: , p5_a4 JTF_NUMBER_TABLE
1555: , p5_a5 JTF_VARCHAR2_TABLE_100
1556: , p5_a6 JTF_VARCHAR2_TABLE_100
1557: , p5_a7 JTF_VARCHAR2_TABLE_100
1558: , p5_a8 JTF_VARCHAR2_TABLE_100
1558: , p5_a8 JTF_VARCHAR2_TABLE_100
1559: , p5_a9 JTF_VARCHAR2_TABLE_2000
1560: , p5_a10 JTF_DATE_TABLE
1561: , p5_a11 JTF_DATE_TABLE
1562: , p5_a12 JTF_NUMBER_TABLE
1563: , p5_a13 JTF_DATE_TABLE
1564: , p5_a14 JTF_NUMBER_TABLE
1565: , p5_a15 JTF_DATE_TABLE
1566: , p5_a16 JTF_NUMBER_TABLE
1560: , p5_a10 JTF_DATE_TABLE
1561: , p5_a11 JTF_DATE_TABLE
1562: , p5_a12 JTF_NUMBER_TABLE
1563: , p5_a13 JTF_DATE_TABLE
1564: , p5_a14 JTF_NUMBER_TABLE
1565: , p5_a15 JTF_DATE_TABLE
1566: , p5_a16 JTF_NUMBER_TABLE
1567: , p5_a17 JTF_VARCHAR2_TABLE_100
1568: , p5_a18 JTF_VARCHAR2_TABLE_100
1562: , p5_a12 JTF_NUMBER_TABLE
1563: , p5_a13 JTF_DATE_TABLE
1564: , p5_a14 JTF_NUMBER_TABLE
1565: , p5_a15 JTF_DATE_TABLE
1566: , p5_a16 JTF_NUMBER_TABLE
1567: , p5_a17 JTF_VARCHAR2_TABLE_100
1568: , p5_a18 JTF_VARCHAR2_TABLE_100
1569: , p5_a19 JTF_VARCHAR2_TABLE_100
1570: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1566: , p5_a16 JTF_NUMBER_TABLE
1567: , p5_a17 JTF_VARCHAR2_TABLE_100
1568: , p5_a18 JTF_VARCHAR2_TABLE_100
1569: , p5_a19 JTF_VARCHAR2_TABLE_100
1570: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1571: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1572: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1573: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1574: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1568: , p5_a18 JTF_VARCHAR2_TABLE_100
1569: , p5_a19 JTF_VARCHAR2_TABLE_100
1570: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1571: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1572: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1573: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1574: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1575: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1576: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1570: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1571: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1572: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1573: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1574: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1575: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1576: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1577: )
1578:
1649: , p_init_msg_list VARCHAR2
1650: , x_return_status out nocopy VARCHAR2
1651: , x_msg_count out nocopy NUMBER
1652: , x_msg_data out nocopy VARCHAR2
1653: , p5_a0 JTF_NUMBER_TABLE
1654: , p5_a1 JTF_VARCHAR2_TABLE_300
1655: , p5_a2 JTF_NUMBER_TABLE
1656: , p5_a3 JTF_VARCHAR2_TABLE_100
1657: , p5_a4 JTF_NUMBER_TABLE
1651: , x_msg_count out nocopy NUMBER
1652: , x_msg_data out nocopy VARCHAR2
1653: , p5_a0 JTF_NUMBER_TABLE
1654: , p5_a1 JTF_VARCHAR2_TABLE_300
1655: , p5_a2 JTF_NUMBER_TABLE
1656: , p5_a3 JTF_VARCHAR2_TABLE_100
1657: , p5_a4 JTF_NUMBER_TABLE
1658: , p5_a5 JTF_VARCHAR2_TABLE_100
1659: , p5_a6 JTF_VARCHAR2_TABLE_100
1653: , p5_a0 JTF_NUMBER_TABLE
1654: , p5_a1 JTF_VARCHAR2_TABLE_300
1655: , p5_a2 JTF_NUMBER_TABLE
1656: , p5_a3 JTF_VARCHAR2_TABLE_100
1657: , p5_a4 JTF_NUMBER_TABLE
1658: , p5_a5 JTF_VARCHAR2_TABLE_100
1659: , p5_a6 JTF_VARCHAR2_TABLE_100
1660: , p5_a7 JTF_VARCHAR2_TABLE_100
1661: , p5_a8 JTF_VARCHAR2_TABLE_100
1661: , p5_a8 JTF_VARCHAR2_TABLE_100
1662: , p5_a9 JTF_VARCHAR2_TABLE_2000
1663: , p5_a10 JTF_DATE_TABLE
1664: , p5_a11 JTF_DATE_TABLE
1665: , p5_a12 JTF_NUMBER_TABLE
1666: , p5_a13 JTF_DATE_TABLE
1667: , p5_a14 JTF_NUMBER_TABLE
1668: , p5_a15 JTF_DATE_TABLE
1669: , p5_a16 JTF_NUMBER_TABLE
1663: , p5_a10 JTF_DATE_TABLE
1664: , p5_a11 JTF_DATE_TABLE
1665: , p5_a12 JTF_NUMBER_TABLE
1666: , p5_a13 JTF_DATE_TABLE
1667: , p5_a14 JTF_NUMBER_TABLE
1668: , p5_a15 JTF_DATE_TABLE
1669: , p5_a16 JTF_NUMBER_TABLE
1670: , p5_a17 JTF_VARCHAR2_TABLE_100
1671: , p5_a18 JTF_VARCHAR2_TABLE_100
1665: , p5_a12 JTF_NUMBER_TABLE
1666: , p5_a13 JTF_DATE_TABLE
1667: , p5_a14 JTF_NUMBER_TABLE
1668: , p5_a15 JTF_DATE_TABLE
1669: , p5_a16 JTF_NUMBER_TABLE
1670: , p5_a17 JTF_VARCHAR2_TABLE_100
1671: , p5_a18 JTF_VARCHAR2_TABLE_100
1672: , p5_a19 JTF_VARCHAR2_TABLE_100
1673: )
1800: , p_init_msg_list VARCHAR2
1801: , x_return_status out nocopy VARCHAR2
1802: , x_msg_count out nocopy NUMBER
1803: , x_msg_data out nocopy VARCHAR2
1804: , p5_a0 JTF_NUMBER_TABLE
1805: , p5_a1 JTF_VARCHAR2_TABLE_300
1806: , p5_a2 JTF_NUMBER_TABLE
1807: , p5_a3 JTF_VARCHAR2_TABLE_100
1808: , p5_a4 JTF_NUMBER_TABLE
1802: , x_msg_count out nocopy NUMBER
1803: , x_msg_data out nocopy VARCHAR2
1804: , p5_a0 JTF_NUMBER_TABLE
1805: , p5_a1 JTF_VARCHAR2_TABLE_300
1806: , p5_a2 JTF_NUMBER_TABLE
1807: , p5_a3 JTF_VARCHAR2_TABLE_100
1808: , p5_a4 JTF_NUMBER_TABLE
1809: , p5_a5 JTF_VARCHAR2_TABLE_100
1810: , p5_a6 JTF_VARCHAR2_TABLE_100
1804: , p5_a0 JTF_NUMBER_TABLE
1805: , p5_a1 JTF_VARCHAR2_TABLE_300
1806: , p5_a2 JTF_NUMBER_TABLE
1807: , p5_a3 JTF_VARCHAR2_TABLE_100
1808: , p5_a4 JTF_NUMBER_TABLE
1809: , p5_a5 JTF_VARCHAR2_TABLE_100
1810: , p5_a6 JTF_VARCHAR2_TABLE_100
1811: , p5_a7 JTF_VARCHAR2_TABLE_100
1812: , p5_a8 JTF_VARCHAR2_TABLE_100
1812: , p5_a8 JTF_VARCHAR2_TABLE_100
1813: , p5_a9 JTF_VARCHAR2_TABLE_2000
1814: , p5_a10 JTF_DATE_TABLE
1815: , p5_a11 JTF_DATE_TABLE
1816: , p5_a12 JTF_NUMBER_TABLE
1817: , p5_a13 JTF_DATE_TABLE
1818: , p5_a14 JTF_NUMBER_TABLE
1819: , p5_a15 JTF_DATE_TABLE
1820: , p5_a16 JTF_NUMBER_TABLE
1814: , p5_a10 JTF_DATE_TABLE
1815: , p5_a11 JTF_DATE_TABLE
1816: , p5_a12 JTF_NUMBER_TABLE
1817: , p5_a13 JTF_DATE_TABLE
1818: , p5_a14 JTF_NUMBER_TABLE
1819: , p5_a15 JTF_DATE_TABLE
1820: , p5_a16 JTF_NUMBER_TABLE
1821: , p5_a17 JTF_VARCHAR2_TABLE_100
1822: , p5_a18 JTF_VARCHAR2_TABLE_100
1816: , p5_a12 JTF_NUMBER_TABLE
1817: , p5_a13 JTF_DATE_TABLE
1818: , p5_a14 JTF_NUMBER_TABLE
1819: , p5_a15 JTF_DATE_TABLE
1820: , p5_a16 JTF_NUMBER_TABLE
1821: , p5_a17 JTF_VARCHAR2_TABLE_100
1822: , p5_a18 JTF_VARCHAR2_TABLE_100
1823: , p5_a19 JTF_VARCHAR2_TABLE_100
1824: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1820: , p5_a16 JTF_NUMBER_TABLE
1821: , p5_a17 JTF_VARCHAR2_TABLE_100
1822: , p5_a18 JTF_VARCHAR2_TABLE_100
1823: , p5_a19 JTF_VARCHAR2_TABLE_100
1824: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1825: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1827: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1828: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1822: , p5_a18 JTF_VARCHAR2_TABLE_100
1823: , p5_a19 JTF_VARCHAR2_TABLE_100
1824: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1825: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1827: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1828: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1829: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1830: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1824: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1825: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1826: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1827: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1828: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1829: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1830: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1831: )
1832:
1903: , p_init_msg_list VARCHAR2
1904: , x_return_status out nocopy VARCHAR2
1905: , x_msg_count out nocopy NUMBER
1906: , x_msg_data out nocopy VARCHAR2
1907: , p5_a0 JTF_NUMBER_TABLE
1908: , p5_a1 JTF_VARCHAR2_TABLE_300
1909: , p5_a2 JTF_NUMBER_TABLE
1910: , p5_a3 JTF_VARCHAR2_TABLE_100
1911: , p5_a4 JTF_NUMBER_TABLE
1905: , x_msg_count out nocopy NUMBER
1906: , x_msg_data out nocopy VARCHAR2
1907: , p5_a0 JTF_NUMBER_TABLE
1908: , p5_a1 JTF_VARCHAR2_TABLE_300
1909: , p5_a2 JTF_NUMBER_TABLE
1910: , p5_a3 JTF_VARCHAR2_TABLE_100
1911: , p5_a4 JTF_NUMBER_TABLE
1912: , p5_a5 JTF_VARCHAR2_TABLE_100
1913: , p5_a6 JTF_VARCHAR2_TABLE_100
1907: , p5_a0 JTF_NUMBER_TABLE
1908: , p5_a1 JTF_VARCHAR2_TABLE_300
1909: , p5_a2 JTF_NUMBER_TABLE
1910: , p5_a3 JTF_VARCHAR2_TABLE_100
1911: , p5_a4 JTF_NUMBER_TABLE
1912: , p5_a5 JTF_VARCHAR2_TABLE_100
1913: , p5_a6 JTF_VARCHAR2_TABLE_100
1914: , p5_a7 JTF_VARCHAR2_TABLE_100
1915: , p5_a8 JTF_VARCHAR2_TABLE_100
1915: , p5_a8 JTF_VARCHAR2_TABLE_100
1916: , p5_a9 JTF_VARCHAR2_TABLE_2000
1917: , p5_a10 JTF_DATE_TABLE
1918: , p5_a11 JTF_DATE_TABLE
1919: , p5_a12 JTF_NUMBER_TABLE
1920: , p5_a13 JTF_DATE_TABLE
1921: , p5_a14 JTF_NUMBER_TABLE
1922: , p5_a15 JTF_DATE_TABLE
1923: , p5_a16 JTF_NUMBER_TABLE
1917: , p5_a10 JTF_DATE_TABLE
1918: , p5_a11 JTF_DATE_TABLE
1919: , p5_a12 JTF_NUMBER_TABLE
1920: , p5_a13 JTF_DATE_TABLE
1921: , p5_a14 JTF_NUMBER_TABLE
1922: , p5_a15 JTF_DATE_TABLE
1923: , p5_a16 JTF_NUMBER_TABLE
1924: , p5_a17 JTF_VARCHAR2_TABLE_100
1925: , p5_a18 JTF_VARCHAR2_TABLE_100
1919: , p5_a12 JTF_NUMBER_TABLE
1920: , p5_a13 JTF_DATE_TABLE
1921: , p5_a14 JTF_NUMBER_TABLE
1922: , p5_a15 JTF_DATE_TABLE
1923: , p5_a16 JTF_NUMBER_TABLE
1924: , p5_a17 JTF_VARCHAR2_TABLE_100
1925: , p5_a18 JTF_VARCHAR2_TABLE_100
1926: , p5_a19 JTF_VARCHAR2_TABLE_100
1927: )