1: package body fte_services_ui_wrapper_w as
2: /* $Header: FTESEWPB.pls 120.0 2005/06/29 18:58 jishen noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy fte_services_ui_wrapper.lane_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p4;
42: procedure rosetta_table_copy_out_p4(t fte_services_ui_wrapper.lane_table, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_DATE_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_DATE_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_DATE_TABLE();
62: a5 := JTF_DATE_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_DATE_TABLE();
62: a5 := JTF_DATE_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
62: a5 := JTF_DATE_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_DATE_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_DATE_TABLE();
74: a5 := JTF_DATE_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_DATE_TABLE();
74: a5 := JTF_DATE_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
74: a5 := JTF_DATE_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
114: end rosetta_table_copy_out_p4;
115:
116: procedure rosetta_table_copy_in_p6(t out nocopy fte_services_ui_wrapper.rate_chart_header_table, a0 JTF_VARCHAR2_TABLE_100
117: , a1 JTF_VARCHAR2_TABLE_100
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_DATE_TABLE
122: , a6 JTF_DATE_TABLE
116: procedure rosetta_table_copy_in_p6(t out nocopy fte_services_ui_wrapper.rate_chart_header_table, a0 JTF_VARCHAR2_TABLE_100
117: , a1 JTF_VARCHAR2_TABLE_100
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_DATE_TABLE
122: , a6 JTF_DATE_TABLE
123: , a7 JTF_VARCHAR2_TABLE_2000
124: ) as
147: end if;
148: end rosetta_table_copy_in_p6;
149: procedure rosetta_table_copy_out_p6(t fte_services_ui_wrapper.rate_chart_header_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
150: , a1 out nocopy JTF_VARCHAR2_TABLE_100
151: , a2 out nocopy JTF_NUMBER_TABLE
152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
153: , a4 out nocopy JTF_NUMBER_TABLE
154: , a5 out nocopy JTF_DATE_TABLE
155: , a6 out nocopy JTF_DATE_TABLE
149: procedure rosetta_table_copy_out_p6(t fte_services_ui_wrapper.rate_chart_header_table, a0 out nocopy JTF_VARCHAR2_TABLE_100
150: , a1 out nocopy JTF_VARCHAR2_TABLE_100
151: , a2 out nocopy JTF_NUMBER_TABLE
152: , a3 out nocopy JTF_VARCHAR2_TABLE_100
153: , a4 out nocopy JTF_NUMBER_TABLE
154: , a5 out nocopy JTF_DATE_TABLE
155: , a6 out nocopy JTF_DATE_TABLE
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: ) as
159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_VARCHAR2_TABLE_100();
162: a1 := JTF_VARCHAR2_TABLE_100();
163: a2 := JTF_NUMBER_TABLE();
164: a3 := JTF_VARCHAR2_TABLE_100();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_DATE_TABLE();
161: a0 := JTF_VARCHAR2_TABLE_100();
162: a1 := JTF_VARCHAR2_TABLE_100();
163: a2 := JTF_NUMBER_TABLE();
164: a3 := JTF_VARCHAR2_TABLE_100();
165: a4 := JTF_NUMBER_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_DATE_TABLE();
168: a7 := JTF_VARCHAR2_TABLE_2000();
169: else
168: a7 := JTF_VARCHAR2_TABLE_2000();
169: else
170: a0 := JTF_VARCHAR2_TABLE_100();
171: a1 := JTF_VARCHAR2_TABLE_100();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_NUMBER_TABLE();
175: a5 := JTF_DATE_TABLE();
176: a6 := JTF_DATE_TABLE();
170: a0 := JTF_VARCHAR2_TABLE_100();
171: a1 := JTF_VARCHAR2_TABLE_100();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_NUMBER_TABLE();
175: a5 := JTF_DATE_TABLE();
176: a6 := JTF_DATE_TABLE();
177: a7 := JTF_VARCHAR2_TABLE_2000();
178: if t.count > 0 then
204: end if;
205: end if;
206: end rosetta_table_copy_out_p6;
207:
208: procedure rosetta_table_copy_in_p9(t out nocopy fte_services_ui_wrapper.rate_chart_line_table, a0 JTF_NUMBER_TABLE
209: , a1 JTF_VARCHAR2_TABLE_100
210: , a2 JTF_VARCHAR2_TABLE_100
211: , a3 JTF_VARCHAR2_TABLE_100
212: , a4 JTF_VARCHAR2_TABLE_100
209: , a1 JTF_VARCHAR2_TABLE_100
210: , a2 JTF_VARCHAR2_TABLE_100
211: , a3 JTF_VARCHAR2_TABLE_100
212: , a4 JTF_VARCHAR2_TABLE_100
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
215: , a7 JTF_NUMBER_TABLE
216: , a8 JTF_VARCHAR2_TABLE_100
217: , a9 JTF_VARCHAR2_TABLE_100
210: , a2 JTF_VARCHAR2_TABLE_100
211: , a3 JTF_VARCHAR2_TABLE_100
212: , a4 JTF_VARCHAR2_TABLE_100
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
215: , a7 JTF_NUMBER_TABLE
216: , a8 JTF_VARCHAR2_TABLE_100
217: , a9 JTF_VARCHAR2_TABLE_100
218: , a10 JTF_VARCHAR2_TABLE_100
211: , a3 JTF_VARCHAR2_TABLE_100
212: , a4 JTF_VARCHAR2_TABLE_100
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
215: , a7 JTF_NUMBER_TABLE
216: , a8 JTF_VARCHAR2_TABLE_100
217: , a9 JTF_VARCHAR2_TABLE_100
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_VARCHAR2_TABLE_100
217: , a9 JTF_VARCHAR2_TABLE_100
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_VARCHAR2_TABLE_100
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_NUMBER_TABLE
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_DATE_TABLE
225: , a17 JTF_DATE_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_VARCHAR2_TABLE_100
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_NUMBER_TABLE
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_DATE_TABLE
225: , a17 JTF_DATE_TABLE
226: , a18 JTF_VARCHAR2_TABLE_200
219: , a11 JTF_VARCHAR2_TABLE_100
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_NUMBER_TABLE
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_DATE_TABLE
225: , a17 JTF_DATE_TABLE
226: , a18 JTF_VARCHAR2_TABLE_200
227: ) as
259: end loop;
260: end if;
261: end if;
262: end rosetta_table_copy_in_p9;
263: procedure rosetta_table_copy_out_p9(t fte_services_ui_wrapper.rate_chart_line_table, a0 out nocopy JTF_NUMBER_TABLE
264: , a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , a4 out nocopy JTF_VARCHAR2_TABLE_100
264: , a1 out nocopy JTF_VARCHAR2_TABLE_100
265: , a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , a5 out nocopy JTF_NUMBER_TABLE
269: , a6 out nocopy JTF_NUMBER_TABLE
270: , a7 out nocopy JTF_NUMBER_TABLE
271: , a8 out nocopy JTF_VARCHAR2_TABLE_100
272: , a9 out nocopy JTF_VARCHAR2_TABLE_100
265: , a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , a5 out nocopy JTF_NUMBER_TABLE
269: , a6 out nocopy JTF_NUMBER_TABLE
270: , a7 out nocopy JTF_NUMBER_TABLE
271: , a8 out nocopy JTF_VARCHAR2_TABLE_100
272: , a9 out nocopy JTF_VARCHAR2_TABLE_100
273: , a10 out nocopy JTF_VARCHAR2_TABLE_100
266: , a3 out nocopy JTF_VARCHAR2_TABLE_100
267: , a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , a5 out nocopy JTF_NUMBER_TABLE
269: , a6 out nocopy JTF_NUMBER_TABLE
270: , a7 out nocopy JTF_NUMBER_TABLE
271: , a8 out nocopy JTF_VARCHAR2_TABLE_100
272: , a9 out nocopy JTF_VARCHAR2_TABLE_100
273: , a10 out nocopy JTF_VARCHAR2_TABLE_100
274: , a11 out nocopy JTF_VARCHAR2_TABLE_100
272: , a9 out nocopy JTF_VARCHAR2_TABLE_100
273: , a10 out nocopy JTF_VARCHAR2_TABLE_100
274: , a11 out nocopy JTF_VARCHAR2_TABLE_100
275: , a12 out nocopy JTF_VARCHAR2_TABLE_100
276: , a13 out nocopy JTF_NUMBER_TABLE
277: , a14 out nocopy JTF_NUMBER_TABLE
278: , a15 out nocopy JTF_NUMBER_TABLE
279: , a16 out nocopy JTF_DATE_TABLE
280: , a17 out nocopy JTF_DATE_TABLE
273: , a10 out nocopy JTF_VARCHAR2_TABLE_100
274: , a11 out nocopy JTF_VARCHAR2_TABLE_100
275: , a12 out nocopy JTF_VARCHAR2_TABLE_100
276: , a13 out nocopy JTF_NUMBER_TABLE
277: , a14 out nocopy JTF_NUMBER_TABLE
278: , a15 out nocopy JTF_NUMBER_TABLE
279: , a16 out nocopy JTF_DATE_TABLE
280: , a17 out nocopy JTF_DATE_TABLE
281: , a18 out nocopy JTF_VARCHAR2_TABLE_200
274: , a11 out nocopy JTF_VARCHAR2_TABLE_100
275: , a12 out nocopy JTF_VARCHAR2_TABLE_100
276: , a13 out nocopy JTF_NUMBER_TABLE
277: , a14 out nocopy JTF_NUMBER_TABLE
278: , a15 out nocopy JTF_NUMBER_TABLE
279: , a16 out nocopy JTF_DATE_TABLE
280: , a17 out nocopy JTF_DATE_TABLE
281: , a18 out nocopy JTF_VARCHAR2_TABLE_200
282: ) as
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
287: a1 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
293: a7 := JTF_NUMBER_TABLE();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
288: a2 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
293: a7 := JTF_NUMBER_TABLE();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
289: a3 := JTF_VARCHAR2_TABLE_100();
290: a4 := JTF_VARCHAR2_TABLE_100();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
293: a7 := JTF_NUMBER_TABLE();
294: a8 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
295: a9 := JTF_VARCHAR2_TABLE_100();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := JTF_NUMBER_TABLE();
300: a14 := JTF_NUMBER_TABLE();
301: a15 := JTF_NUMBER_TABLE();
302: a16 := JTF_DATE_TABLE();
303: a17 := JTF_DATE_TABLE();
296: a10 := JTF_VARCHAR2_TABLE_100();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := JTF_NUMBER_TABLE();
300: a14 := JTF_NUMBER_TABLE();
301: a15 := JTF_NUMBER_TABLE();
302: a16 := JTF_DATE_TABLE();
303: a17 := JTF_DATE_TABLE();
304: a18 := JTF_VARCHAR2_TABLE_200();
297: a11 := JTF_VARCHAR2_TABLE_100();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := JTF_NUMBER_TABLE();
300: a14 := JTF_NUMBER_TABLE();
301: a15 := JTF_NUMBER_TABLE();
302: a16 := JTF_DATE_TABLE();
303: a17 := JTF_DATE_TABLE();
304: a18 := JTF_VARCHAR2_TABLE_200();
305: else
302: a16 := JTF_DATE_TABLE();
303: a17 := JTF_DATE_TABLE();
304: a18 := JTF_VARCHAR2_TABLE_200();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_VARCHAR2_TABLE_100();
308: a2 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_100();
307: a1 := JTF_VARCHAR2_TABLE_100();
308: a2 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_NUMBER_TABLE();
314: a8 := JTF_VARCHAR2_TABLE_100();
315: a9 := JTF_VARCHAR2_TABLE_100();
308: a2 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_NUMBER_TABLE();
314: a8 := JTF_VARCHAR2_TABLE_100();
315: a9 := JTF_VARCHAR2_TABLE_100();
316: a10 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_NUMBER_TABLE();
314: a8 := JTF_VARCHAR2_TABLE_100();
315: a9 := JTF_VARCHAR2_TABLE_100();
316: a10 := JTF_VARCHAR2_TABLE_100();
317: a11 := JTF_VARCHAR2_TABLE_100();
315: a9 := JTF_VARCHAR2_TABLE_100();
316: a10 := JTF_VARCHAR2_TABLE_100();
317: a11 := JTF_VARCHAR2_TABLE_100();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := JTF_NUMBER_TABLE();
320: a14 := JTF_NUMBER_TABLE();
321: a15 := JTF_NUMBER_TABLE();
322: a16 := JTF_DATE_TABLE();
323: a17 := JTF_DATE_TABLE();
316: a10 := JTF_VARCHAR2_TABLE_100();
317: a11 := JTF_VARCHAR2_TABLE_100();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := JTF_NUMBER_TABLE();
320: a14 := JTF_NUMBER_TABLE();
321: a15 := JTF_NUMBER_TABLE();
322: a16 := JTF_DATE_TABLE();
323: a17 := JTF_DATE_TABLE();
324: a18 := JTF_VARCHAR2_TABLE_200();
317: a11 := JTF_VARCHAR2_TABLE_100();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := JTF_NUMBER_TABLE();
320: a14 := JTF_NUMBER_TABLE();
321: a15 := JTF_NUMBER_TABLE();
322: a16 := JTF_DATE_TABLE();
323: a17 := JTF_DATE_TABLE();
324: a18 := JTF_VARCHAR2_TABLE_200();
325: if t.count > 0 then
373: end if;
374: end if;
375: end rosetta_table_copy_out_p9;
376:
377: procedure rosetta_table_copy_in_p11(t out nocopy fte_services_ui_wrapper.rate_chart_break_table, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_NUMBER_TABLE
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_NUMBER_TABLE
374: end if;
375: end rosetta_table_copy_out_p9;
376:
377: procedure rosetta_table_copy_in_p11(t out nocopy fte_services_ui_wrapper.rate_chart_break_table, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_NUMBER_TABLE
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_NUMBER_TABLE
382: ) as
375: end rosetta_table_copy_out_p9;
376:
377: procedure rosetta_table_copy_in_p11(t out nocopy fte_services_ui_wrapper.rate_chart_break_table, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_NUMBER_TABLE
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
377: procedure rosetta_table_copy_in_p11(t out nocopy fte_services_ui_wrapper.rate_chart_break_table, a0 JTF_NUMBER_TABLE
378: , a1 JTF_NUMBER_TABLE
379: , a2 JTF_NUMBER_TABLE
380: , a3 JTF_VARCHAR2_TABLE_100
381: , a4 JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if a0 is not null and a0.count > 0 then
400: end loop;
401: end if;
402: end if;
403: end rosetta_table_copy_in_p11;
404: procedure rosetta_table_copy_out_p11(t fte_services_ui_wrapper.rate_chart_break_table, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_NUMBER_TABLE
406: , a2 out nocopy JTF_NUMBER_TABLE
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_NUMBER_TABLE
401: end if;
402: end if;
403: end rosetta_table_copy_in_p11;
404: procedure rosetta_table_copy_out_p11(t fte_services_ui_wrapper.rate_chart_break_table, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_NUMBER_TABLE
406: , a2 out nocopy JTF_NUMBER_TABLE
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_NUMBER_TABLE
409: ) as
402: end if;
403: end rosetta_table_copy_in_p11;
404: procedure rosetta_table_copy_out_p11(t fte_services_ui_wrapper.rate_chart_break_table, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_NUMBER_TABLE
406: , a2 out nocopy JTF_NUMBER_TABLE
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_NUMBER_TABLE
409: ) as
410: ddindx binary_integer; indx binary_integer;
404: procedure rosetta_table_copy_out_p11(t fte_services_ui_wrapper.rate_chart_break_table, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_NUMBER_TABLE
406: , a2 out nocopy JTF_NUMBER_TABLE
407: , a3 out nocopy JTF_VARCHAR2_TABLE_100
408: , a4 out nocopy JTF_NUMBER_TABLE
409: ) as
410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then
409: ) as
410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_NUMBER_TABLE();
415: a2 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
410: ddindx binary_integer; indx binary_integer;
411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_NUMBER_TABLE();
415: a2 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
418: else
411: begin
412: if t is null or t.count = 0 then
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_NUMBER_TABLE();
415: a2 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
418: else
419: a0 := JTF_NUMBER_TABLE();
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_NUMBER_TABLE();
415: a2 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_NUMBER_TABLE();
415: a2 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_NUMBER_TABLE();
416: a3 := JTF_VARCHAR2_TABLE_100();
417: a4 := JTF_NUMBER_TABLE();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
417: a4 := JTF_NUMBER_TABLE();
418: else
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
419: a0 := JTF_NUMBER_TABLE();
420: a1 := JTF_NUMBER_TABLE();
421: a2 := JTF_NUMBER_TABLE();
422: a3 := JTF_VARCHAR2_TABLE_100();
423: a4 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);
427: a2.extend(t.count);
444: end if;
445: end if;
446: end rosetta_table_copy_out_p11;
447:
448: procedure rosetta_table_copy_in_p13(t out nocopy fte_services_ui_wrapper.tl_line_table, a0 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_NUMBER_TABLE
451: , a3 JTF_VARCHAR2_TABLE_100
452: , a4 JTF_VARCHAR2_TABLE_100
446: end rosetta_table_copy_out_p11;
447:
448: procedure rosetta_table_copy_in_p13(t out nocopy fte_services_ui_wrapper.tl_line_table, a0 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_NUMBER_TABLE
451: , a3 JTF_VARCHAR2_TABLE_100
452: , a4 JTF_VARCHAR2_TABLE_100
453: , a5 JTF_NUMBER_TABLE
454: , a6 JTF_NUMBER_TABLE
449: , a1 JTF_VARCHAR2_TABLE_100
450: , a2 JTF_NUMBER_TABLE
451: , a3 JTF_VARCHAR2_TABLE_100
452: , a4 JTF_VARCHAR2_TABLE_100
453: , a5 JTF_NUMBER_TABLE
454: , a6 JTF_NUMBER_TABLE
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
450: , a2 JTF_NUMBER_TABLE
451: , a3 JTF_VARCHAR2_TABLE_100
452: , a4 JTF_VARCHAR2_TABLE_100
453: , a5 JTF_NUMBER_TABLE
454: , a6 JTF_NUMBER_TABLE
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
453: , a5 JTF_NUMBER_TABLE
454: , a6 JTF_NUMBER_TABLE
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
454: , a6 JTF_NUMBER_TABLE
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
463: , a15 JTF_NUMBER_TABLE
456: , a8 JTF_DATE_TABLE
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
463: , a15 JTF_NUMBER_TABLE
464: ) as
457: , a9 JTF_NUMBER_TABLE
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
463: , a15 JTF_NUMBER_TABLE
464: ) as
465: ddindx binary_integer; indx binary_integer;
458: , a10 JTF_NUMBER_TABLE
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
463: , a15 JTF_NUMBER_TABLE
464: ) as
465: ddindx binary_integer; indx binary_integer;
466: begin
459: , a11 JTF_NUMBER_TABLE
460: , a12 JTF_NUMBER_TABLE
461: , a13 JTF_NUMBER_TABLE
462: , a14 JTF_NUMBER_TABLE
463: , a15 JTF_NUMBER_TABLE
464: ) as
465: ddindx binary_integer; indx binary_integer;
466: begin
467: if a0 is not null and a0.count > 0 then
493: end loop;
494: end if;
495: end if;
496: end rosetta_table_copy_in_p13;
497: procedure rosetta_table_copy_out_p13(t fte_services_ui_wrapper.tl_line_table, a0 out nocopy JTF_NUMBER_TABLE
498: , a1 out nocopy JTF_VARCHAR2_TABLE_100
499: , a2 out nocopy JTF_NUMBER_TABLE
500: , a3 out nocopy JTF_VARCHAR2_TABLE_100
501: , a4 out nocopy JTF_VARCHAR2_TABLE_100
495: end if;
496: end rosetta_table_copy_in_p13;
497: procedure rosetta_table_copy_out_p13(t fte_services_ui_wrapper.tl_line_table, a0 out nocopy JTF_NUMBER_TABLE
498: , a1 out nocopy JTF_VARCHAR2_TABLE_100
499: , a2 out nocopy JTF_NUMBER_TABLE
500: , a3 out nocopy JTF_VARCHAR2_TABLE_100
501: , a4 out nocopy JTF_VARCHAR2_TABLE_100
502: , a5 out nocopy JTF_NUMBER_TABLE
503: , a6 out nocopy JTF_NUMBER_TABLE
498: , a1 out nocopy JTF_VARCHAR2_TABLE_100
499: , a2 out nocopy JTF_NUMBER_TABLE
500: , a3 out nocopy JTF_VARCHAR2_TABLE_100
501: , a4 out nocopy JTF_VARCHAR2_TABLE_100
502: , a5 out nocopy JTF_NUMBER_TABLE
503: , a6 out nocopy JTF_NUMBER_TABLE
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
499: , a2 out nocopy JTF_NUMBER_TABLE
500: , a3 out nocopy JTF_VARCHAR2_TABLE_100
501: , a4 out nocopy JTF_VARCHAR2_TABLE_100
502: , a5 out nocopy JTF_NUMBER_TABLE
503: , a6 out nocopy JTF_NUMBER_TABLE
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
502: , a5 out nocopy JTF_NUMBER_TABLE
503: , a6 out nocopy JTF_NUMBER_TABLE
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
503: , a6 out nocopy JTF_NUMBER_TABLE
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
512: , a15 out nocopy JTF_NUMBER_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
512: , a15 out nocopy JTF_NUMBER_TABLE
513: ) as
506: , a9 out nocopy JTF_NUMBER_TABLE
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
512: , a15 out nocopy JTF_NUMBER_TABLE
513: ) as
514: ddindx binary_integer; indx binary_integer;
507: , a10 out nocopy JTF_NUMBER_TABLE
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
512: , a15 out nocopy JTF_NUMBER_TABLE
513: ) as
514: ddindx binary_integer; indx binary_integer;
515: begin
508: , a11 out nocopy JTF_NUMBER_TABLE
509: , a12 out nocopy JTF_NUMBER_TABLE
510: , a13 out nocopy JTF_NUMBER_TABLE
511: , a14 out nocopy JTF_NUMBER_TABLE
512: , a15 out nocopy JTF_NUMBER_TABLE
513: ) as
514: ddindx binary_integer; indx binary_integer;
515: begin
516: if t is null or t.count = 0 then
513: ) as
514: ddindx binary_integer; indx binary_integer;
515: begin
516: if t is null or t.count = 0 then
517: a0 := JTF_NUMBER_TABLE();
518: a1 := JTF_VARCHAR2_TABLE_100();
519: a2 := JTF_NUMBER_TABLE();
520: a3 := JTF_VARCHAR2_TABLE_100();
521: a4 := JTF_VARCHAR2_TABLE_100();
515: begin
516: if t is null or t.count = 0 then
517: a0 := JTF_NUMBER_TABLE();
518: a1 := JTF_VARCHAR2_TABLE_100();
519: a2 := JTF_NUMBER_TABLE();
520: a3 := JTF_VARCHAR2_TABLE_100();
521: a4 := JTF_VARCHAR2_TABLE_100();
522: a5 := JTF_NUMBER_TABLE();
523: a6 := JTF_NUMBER_TABLE();
518: a1 := JTF_VARCHAR2_TABLE_100();
519: a2 := JTF_NUMBER_TABLE();
520: a3 := JTF_VARCHAR2_TABLE_100();
521: a4 := JTF_VARCHAR2_TABLE_100();
522: a5 := JTF_NUMBER_TABLE();
523: a6 := JTF_NUMBER_TABLE();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
519: a2 := JTF_NUMBER_TABLE();
520: a3 := JTF_VARCHAR2_TABLE_100();
521: a4 := JTF_VARCHAR2_TABLE_100();
522: a5 := JTF_NUMBER_TABLE();
523: a6 := JTF_NUMBER_TABLE();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
522: a5 := JTF_NUMBER_TABLE();
523: a6 := JTF_NUMBER_TABLE();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
523: a6 := JTF_NUMBER_TABLE();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
525: a8 := JTF_DATE_TABLE();
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
533: else
526: a9 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
533: else
534: a0 := JTF_NUMBER_TABLE();
527: a10 := JTF_NUMBER_TABLE();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
533: else
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
528: a11 := JTF_NUMBER_TABLE();
529: a12 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
533: else
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_NUMBER_TABLE();
530: a13 := JTF_NUMBER_TABLE();
531: a14 := JTF_NUMBER_TABLE();
532: a15 := JTF_NUMBER_TABLE();
533: else
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_NUMBER_TABLE();
537: a3 := JTF_VARCHAR2_TABLE_100();
538: a4 := JTF_VARCHAR2_TABLE_100();
532: a15 := JTF_NUMBER_TABLE();
533: else
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_NUMBER_TABLE();
537: a3 := JTF_VARCHAR2_TABLE_100();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: a6 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_100();
536: a2 := JTF_NUMBER_TABLE();
537: a3 := JTF_VARCHAR2_TABLE_100();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: a6 := JTF_NUMBER_TABLE();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
536: a2 := JTF_NUMBER_TABLE();
537: a3 := JTF_VARCHAR2_TABLE_100();
538: a4 := JTF_VARCHAR2_TABLE_100();
539: a5 := JTF_NUMBER_TABLE();
540: a6 := JTF_NUMBER_TABLE();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
539: a5 := JTF_NUMBER_TABLE();
540: a6 := JTF_NUMBER_TABLE();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
540: a6 := JTF_NUMBER_TABLE();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
549: a15 := JTF_NUMBER_TABLE();
542: a8 := JTF_DATE_TABLE();
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
549: a15 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
543: a9 := JTF_NUMBER_TABLE();
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
549: a15 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);
544: a10 := JTF_NUMBER_TABLE();
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
549: a15 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);
552: a1.extend(t.count);
545: a11 := JTF_NUMBER_TABLE();
546: a12 := JTF_NUMBER_TABLE();
547: a13 := JTF_NUMBER_TABLE();
548: a14 := JTF_NUMBER_TABLE();
549: a15 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);
552: a1.extend(t.count);
553: a2.extend(t.count);
594: end rosetta_table_copy_out_p13;
595:
596: procedure edit_tl_services(p_init_msg_list VARCHAR2
597: , p_transaction_type VARCHAR2
598: , p2_a0 JTF_NUMBER_TABLE
599: , p2_a1 JTF_VARCHAR2_TABLE_100
600: , p2_a2 JTF_VARCHAR2_TABLE_100
601: , p2_a3 JTF_VARCHAR2_TABLE_100
602: , p2_a4 JTF_DATE_TABLE
600: , p2_a2 JTF_VARCHAR2_TABLE_100
601: , p2_a3 JTF_VARCHAR2_TABLE_100
602: , p2_a4 JTF_DATE_TABLE
603: , p2_a5 JTF_DATE_TABLE
604: , p2_a6 JTF_NUMBER_TABLE
605: , p2_a7 JTF_VARCHAR2_TABLE_100
606: , p2_a8 JTF_NUMBER_TABLE
607: , p2_a9 JTF_NUMBER_TABLE
608: , p2_a10 JTF_VARCHAR2_TABLE_100
602: , p2_a4 JTF_DATE_TABLE
603: , p2_a5 JTF_DATE_TABLE
604: , p2_a6 JTF_NUMBER_TABLE
605: , p2_a7 JTF_VARCHAR2_TABLE_100
606: , p2_a8 JTF_NUMBER_TABLE
607: , p2_a9 JTF_NUMBER_TABLE
608: , p2_a10 JTF_VARCHAR2_TABLE_100
609: , p3_a0 JTF_VARCHAR2_TABLE_100
610: , p3_a1 JTF_VARCHAR2_TABLE_100
603: , p2_a5 JTF_DATE_TABLE
604: , p2_a6 JTF_NUMBER_TABLE
605: , p2_a7 JTF_VARCHAR2_TABLE_100
606: , p2_a8 JTF_NUMBER_TABLE
607: , p2_a9 JTF_NUMBER_TABLE
608: , p2_a10 JTF_VARCHAR2_TABLE_100
609: , p3_a0 JTF_VARCHAR2_TABLE_100
610: , p3_a1 JTF_VARCHAR2_TABLE_100
611: , p3_a2 JTF_NUMBER_TABLE
607: , p2_a9 JTF_NUMBER_TABLE
608: , p2_a10 JTF_VARCHAR2_TABLE_100
609: , p3_a0 JTF_VARCHAR2_TABLE_100
610: , p3_a1 JTF_VARCHAR2_TABLE_100
611: , p3_a2 JTF_NUMBER_TABLE
612: , p3_a3 JTF_VARCHAR2_TABLE_100
613: , p3_a4 JTF_NUMBER_TABLE
614: , p3_a5 JTF_DATE_TABLE
615: , p3_a6 JTF_DATE_TABLE
609: , p3_a0 JTF_VARCHAR2_TABLE_100
610: , p3_a1 JTF_VARCHAR2_TABLE_100
611: , p3_a2 JTF_NUMBER_TABLE
612: , p3_a3 JTF_VARCHAR2_TABLE_100
613: , p3_a4 JTF_NUMBER_TABLE
614: , p3_a5 JTF_DATE_TABLE
615: , p3_a6 JTF_DATE_TABLE
616: , p3_a7 JTF_VARCHAR2_TABLE_2000
617: , p4_a0 JTF_NUMBER_TABLE
613: , p3_a4 JTF_NUMBER_TABLE
614: , p3_a5 JTF_DATE_TABLE
615: , p3_a6 JTF_DATE_TABLE
616: , p3_a7 JTF_VARCHAR2_TABLE_2000
617: , p4_a0 JTF_NUMBER_TABLE
618: , p4_a1 JTF_VARCHAR2_TABLE_100
619: , p4_a2 JTF_VARCHAR2_TABLE_100
620: , p4_a3 JTF_VARCHAR2_TABLE_100
621: , p4_a4 JTF_VARCHAR2_TABLE_100
618: , p4_a1 JTF_VARCHAR2_TABLE_100
619: , p4_a2 JTF_VARCHAR2_TABLE_100
620: , p4_a3 JTF_VARCHAR2_TABLE_100
621: , p4_a4 JTF_VARCHAR2_TABLE_100
622: , p4_a5 JTF_NUMBER_TABLE
623: , p4_a6 JTF_NUMBER_TABLE
624: , p4_a7 JTF_NUMBER_TABLE
625: , p4_a8 JTF_VARCHAR2_TABLE_100
626: , p4_a9 JTF_VARCHAR2_TABLE_100
619: , p4_a2 JTF_VARCHAR2_TABLE_100
620: , p4_a3 JTF_VARCHAR2_TABLE_100
621: , p4_a4 JTF_VARCHAR2_TABLE_100
622: , p4_a5 JTF_NUMBER_TABLE
623: , p4_a6 JTF_NUMBER_TABLE
624: , p4_a7 JTF_NUMBER_TABLE
625: , p4_a8 JTF_VARCHAR2_TABLE_100
626: , p4_a9 JTF_VARCHAR2_TABLE_100
627: , p4_a10 JTF_VARCHAR2_TABLE_100
620: , p4_a3 JTF_VARCHAR2_TABLE_100
621: , p4_a4 JTF_VARCHAR2_TABLE_100
622: , p4_a5 JTF_NUMBER_TABLE
623: , p4_a6 JTF_NUMBER_TABLE
624: , p4_a7 JTF_NUMBER_TABLE
625: , p4_a8 JTF_VARCHAR2_TABLE_100
626: , p4_a9 JTF_VARCHAR2_TABLE_100
627: , p4_a10 JTF_VARCHAR2_TABLE_100
628: , p4_a11 JTF_VARCHAR2_TABLE_100
626: , p4_a9 JTF_VARCHAR2_TABLE_100
627: , p4_a10 JTF_VARCHAR2_TABLE_100
628: , p4_a11 JTF_VARCHAR2_TABLE_100
629: , p4_a12 JTF_VARCHAR2_TABLE_100
630: , p4_a13 JTF_NUMBER_TABLE
631: , p4_a14 JTF_NUMBER_TABLE
632: , p4_a15 JTF_NUMBER_TABLE
633: , p4_a16 JTF_DATE_TABLE
634: , p4_a17 JTF_DATE_TABLE
627: , p4_a10 JTF_VARCHAR2_TABLE_100
628: , p4_a11 JTF_VARCHAR2_TABLE_100
629: , p4_a12 JTF_VARCHAR2_TABLE_100
630: , p4_a13 JTF_NUMBER_TABLE
631: , p4_a14 JTF_NUMBER_TABLE
632: , p4_a15 JTF_NUMBER_TABLE
633: , p4_a16 JTF_DATE_TABLE
634: , p4_a17 JTF_DATE_TABLE
635: , p4_a18 JTF_VARCHAR2_TABLE_200
628: , p4_a11 JTF_VARCHAR2_TABLE_100
629: , p4_a12 JTF_VARCHAR2_TABLE_100
630: , p4_a13 JTF_NUMBER_TABLE
631: , p4_a14 JTF_NUMBER_TABLE
632: , p4_a15 JTF_NUMBER_TABLE
633: , p4_a16 JTF_DATE_TABLE
634: , p4_a17 JTF_DATE_TABLE
635: , p4_a18 JTF_VARCHAR2_TABLE_200
636: , x_status out nocopy NUMBER
712: end;
713:
714: procedure rate_chart_wrapper(p0_a0 JTF_VARCHAR2_TABLE_100
715: , p0_a1 JTF_VARCHAR2_TABLE_100
716: , p0_a2 JTF_NUMBER_TABLE
717: , p0_a3 JTF_VARCHAR2_TABLE_100
718: , p0_a4 JTF_NUMBER_TABLE
719: , p0_a5 JTF_DATE_TABLE
720: , p0_a6 JTF_DATE_TABLE
714: procedure rate_chart_wrapper(p0_a0 JTF_VARCHAR2_TABLE_100
715: , p0_a1 JTF_VARCHAR2_TABLE_100
716: , p0_a2 JTF_NUMBER_TABLE
717: , p0_a3 JTF_VARCHAR2_TABLE_100
718: , p0_a4 JTF_NUMBER_TABLE
719: , p0_a5 JTF_DATE_TABLE
720: , p0_a6 JTF_DATE_TABLE
721: , p0_a7 JTF_VARCHAR2_TABLE_2000
722: , p1_a0 JTF_NUMBER_TABLE
718: , p0_a4 JTF_NUMBER_TABLE
719: , p0_a5 JTF_DATE_TABLE
720: , p0_a6 JTF_DATE_TABLE
721: , p0_a7 JTF_VARCHAR2_TABLE_2000
722: , p1_a0 JTF_NUMBER_TABLE
723: , p1_a1 JTF_VARCHAR2_TABLE_100
724: , p1_a2 JTF_VARCHAR2_TABLE_100
725: , p1_a3 JTF_VARCHAR2_TABLE_100
726: , p1_a4 JTF_VARCHAR2_TABLE_100
723: , p1_a1 JTF_VARCHAR2_TABLE_100
724: , p1_a2 JTF_VARCHAR2_TABLE_100
725: , p1_a3 JTF_VARCHAR2_TABLE_100
726: , p1_a4 JTF_VARCHAR2_TABLE_100
727: , p1_a5 JTF_NUMBER_TABLE
728: , p1_a6 JTF_NUMBER_TABLE
729: , p1_a7 JTF_NUMBER_TABLE
730: , p1_a8 JTF_VARCHAR2_TABLE_100
731: , p1_a9 JTF_VARCHAR2_TABLE_100
724: , p1_a2 JTF_VARCHAR2_TABLE_100
725: , p1_a3 JTF_VARCHAR2_TABLE_100
726: , p1_a4 JTF_VARCHAR2_TABLE_100
727: , p1_a5 JTF_NUMBER_TABLE
728: , p1_a6 JTF_NUMBER_TABLE
729: , p1_a7 JTF_NUMBER_TABLE
730: , p1_a8 JTF_VARCHAR2_TABLE_100
731: , p1_a9 JTF_VARCHAR2_TABLE_100
732: , p1_a10 JTF_VARCHAR2_TABLE_100
725: , p1_a3 JTF_VARCHAR2_TABLE_100
726: , p1_a4 JTF_VARCHAR2_TABLE_100
727: , p1_a5 JTF_NUMBER_TABLE
728: , p1_a6 JTF_NUMBER_TABLE
729: , p1_a7 JTF_NUMBER_TABLE
730: , p1_a8 JTF_VARCHAR2_TABLE_100
731: , p1_a9 JTF_VARCHAR2_TABLE_100
732: , p1_a10 JTF_VARCHAR2_TABLE_100
733: , p1_a11 JTF_VARCHAR2_TABLE_100
731: , p1_a9 JTF_VARCHAR2_TABLE_100
732: , p1_a10 JTF_VARCHAR2_TABLE_100
733: , p1_a11 JTF_VARCHAR2_TABLE_100
734: , p1_a12 JTF_VARCHAR2_TABLE_100
735: , p1_a13 JTF_NUMBER_TABLE
736: , p1_a14 JTF_NUMBER_TABLE
737: , p1_a15 JTF_NUMBER_TABLE
738: , p1_a16 JTF_DATE_TABLE
739: , p1_a17 JTF_DATE_TABLE
732: , p1_a10 JTF_VARCHAR2_TABLE_100
733: , p1_a11 JTF_VARCHAR2_TABLE_100
734: , p1_a12 JTF_VARCHAR2_TABLE_100
735: , p1_a13 JTF_NUMBER_TABLE
736: , p1_a14 JTF_NUMBER_TABLE
737: , p1_a15 JTF_NUMBER_TABLE
738: , p1_a16 JTF_DATE_TABLE
739: , p1_a17 JTF_DATE_TABLE
740: , p1_a18 JTF_VARCHAR2_TABLE_200
733: , p1_a11 JTF_VARCHAR2_TABLE_100
734: , p1_a12 JTF_VARCHAR2_TABLE_100
735: , p1_a13 JTF_NUMBER_TABLE
736: , p1_a14 JTF_NUMBER_TABLE
737: , p1_a15 JTF_NUMBER_TABLE
738: , p1_a16 JTF_DATE_TABLE
739: , p1_a17 JTF_DATE_TABLE
740: , p1_a18 JTF_VARCHAR2_TABLE_200
741: , p2_a0 JTF_NUMBER_TABLE
737: , p1_a15 JTF_NUMBER_TABLE
738: , p1_a16 JTF_DATE_TABLE
739: , p1_a17 JTF_DATE_TABLE
740: , p1_a18 JTF_VARCHAR2_TABLE_200
741: , p2_a0 JTF_NUMBER_TABLE
742: , p2_a1 JTF_NUMBER_TABLE
743: , p2_a2 JTF_NUMBER_TABLE
744: , p2_a3 JTF_VARCHAR2_TABLE_100
745: , p2_a4 JTF_NUMBER_TABLE
738: , p1_a16 JTF_DATE_TABLE
739: , p1_a17 JTF_DATE_TABLE
740: , p1_a18 JTF_VARCHAR2_TABLE_200
741: , p2_a0 JTF_NUMBER_TABLE
742: , p2_a1 JTF_NUMBER_TABLE
743: , p2_a2 JTF_NUMBER_TABLE
744: , p2_a3 JTF_VARCHAR2_TABLE_100
745: , p2_a4 JTF_NUMBER_TABLE
746: , p_chart_type VARCHAR2
739: , p1_a17 JTF_DATE_TABLE
740: , p1_a18 JTF_VARCHAR2_TABLE_200
741: , p2_a0 JTF_NUMBER_TABLE
742: , p2_a1 JTF_NUMBER_TABLE
743: , p2_a2 JTF_NUMBER_TABLE
744: , p2_a3 JTF_VARCHAR2_TABLE_100
745: , p2_a4 JTF_NUMBER_TABLE
746: , p_chart_type VARCHAR2
747: , x_status out nocopy NUMBER
741: , p2_a0 JTF_NUMBER_TABLE
742: , p2_a1 JTF_NUMBER_TABLE
743: , p2_a2 JTF_NUMBER_TABLE
744: , p2_a3 JTF_VARCHAR2_TABLE_100
745: , p2_a4 JTF_NUMBER_TABLE
746: , p_chart_type VARCHAR2
747: , x_status out nocopy NUMBER
748: , x_error_msg out nocopy VARCHAR2
749: )
814: end;
815:
816: procedure tl_surcharge_wrapper(p0_a0 JTF_VARCHAR2_TABLE_100
817: , p0_a1 JTF_VARCHAR2_TABLE_100
818: , p0_a2 JTF_NUMBER_TABLE
819: , p0_a3 JTF_VARCHAR2_TABLE_100
820: , p0_a4 JTF_NUMBER_TABLE
821: , p0_a5 JTF_DATE_TABLE
822: , p0_a6 JTF_DATE_TABLE
816: procedure tl_surcharge_wrapper(p0_a0 JTF_VARCHAR2_TABLE_100
817: , p0_a1 JTF_VARCHAR2_TABLE_100
818: , p0_a2 JTF_NUMBER_TABLE
819: , p0_a3 JTF_VARCHAR2_TABLE_100
820: , p0_a4 JTF_NUMBER_TABLE
821: , p0_a5 JTF_DATE_TABLE
822: , p0_a6 JTF_DATE_TABLE
823: , p0_a7 JTF_VARCHAR2_TABLE_2000
824: , p1_a0 JTF_NUMBER_TABLE
820: , p0_a4 JTF_NUMBER_TABLE
821: , p0_a5 JTF_DATE_TABLE
822: , p0_a6 JTF_DATE_TABLE
823: , p0_a7 JTF_VARCHAR2_TABLE_2000
824: , p1_a0 JTF_NUMBER_TABLE
825: , p1_a1 JTF_VARCHAR2_TABLE_100
826: , p1_a2 JTF_NUMBER_TABLE
827: , p1_a3 JTF_VARCHAR2_TABLE_100
828: , p1_a4 JTF_VARCHAR2_TABLE_100
822: , p0_a6 JTF_DATE_TABLE
823: , p0_a7 JTF_VARCHAR2_TABLE_2000
824: , p1_a0 JTF_NUMBER_TABLE
825: , p1_a1 JTF_VARCHAR2_TABLE_100
826: , p1_a2 JTF_NUMBER_TABLE
827: , p1_a3 JTF_VARCHAR2_TABLE_100
828: , p1_a4 JTF_VARCHAR2_TABLE_100
829: , p1_a5 JTF_NUMBER_TABLE
830: , p1_a6 JTF_NUMBER_TABLE
825: , p1_a1 JTF_VARCHAR2_TABLE_100
826: , p1_a2 JTF_NUMBER_TABLE
827: , p1_a3 JTF_VARCHAR2_TABLE_100
828: , p1_a4 JTF_VARCHAR2_TABLE_100
829: , p1_a5 JTF_NUMBER_TABLE
830: , p1_a6 JTF_NUMBER_TABLE
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
826: , p1_a2 JTF_NUMBER_TABLE
827: , p1_a3 JTF_VARCHAR2_TABLE_100
828: , p1_a4 JTF_VARCHAR2_TABLE_100
829: , p1_a5 JTF_NUMBER_TABLE
830: , p1_a6 JTF_NUMBER_TABLE
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
829: , p1_a5 JTF_NUMBER_TABLE
830: , p1_a6 JTF_NUMBER_TABLE
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
830: , p1_a6 JTF_NUMBER_TABLE
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
832: , p1_a8 JTF_DATE_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
833: , p1_a9 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
834: , p1_a10 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
835: , p1_a11 JTF_NUMBER_TABLE
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
843: , p2_a3 JTF_VARCHAR2_TABLE_100
836: , p1_a12 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
843: , p2_a3 JTF_VARCHAR2_TABLE_100
844: , p2_a4 JTF_NUMBER_TABLE
837: , p1_a13 JTF_NUMBER_TABLE
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
843: , p2_a3 JTF_VARCHAR2_TABLE_100
844: , p2_a4 JTF_NUMBER_TABLE
845: , p_action VARCHAR2
838: , p1_a14 JTF_NUMBER_TABLE
839: , p1_a15 JTF_NUMBER_TABLE
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
843: , p2_a3 JTF_VARCHAR2_TABLE_100
844: , p2_a4 JTF_NUMBER_TABLE
845: , p_action VARCHAR2
846: , x_status out nocopy NUMBER
840: , p2_a0 JTF_NUMBER_TABLE
841: , p2_a1 JTF_NUMBER_TABLE
842: , p2_a2 JTF_NUMBER_TABLE
843: , p2_a3 JTF_VARCHAR2_TABLE_100
844: , p2_a4 JTF_NUMBER_TABLE
845: , p_action VARCHAR2
846: , x_status out nocopy NUMBER
847: , x_error_msg out nocopy VARCHAR2
848: )