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
8: , a5 JTF_DATE_TABLE
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
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
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
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 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
14: ) as
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
17: if a0 is not null and a0.count > 0 then
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
47: , a5 out nocopy JTF_DATE_TABLE
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
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
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
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 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
53: ) as
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
56: if t is null or t.count = 0 then
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();
62: a5 := JTF_DATE_TABLE();
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();
62: a5 := JTF_DATE_TABLE();
63: a6 := JTF_NUMBER_TABLE();
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();
62: a5 := JTF_DATE_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := 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();
68: else
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();
71: a2 := JTF_VARCHAR2_TABLE_100();
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();
74: a5 := JTF_DATE_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();
74: a5 := JTF_DATE_TABLE();
75: a6 := JTF_NUMBER_TABLE();
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();
74: a5 := JTF_DATE_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := 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();
80: if t.count > 0 then
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);
83: a2.extend(t.count);
112: end if;
113: end if;
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
113: end if;
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
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
123: , a7 JTF_VARCHAR2_TABLE_2000
145: end loop;
146: end if;
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
146: end if;
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
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
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: ) as
158: ddindx binary_integer; indx binary_integer;
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();
158: ddindx binary_integer; indx binary_integer;
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();
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();
168: a7 := JTF_VARCHAR2_TABLE_2000();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_DATE_TABLE();
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();
167: a6 := JTF_DATE_TABLE();
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();
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();
177: a7 := JTF_VARCHAR2_TABLE_2000();
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
213: , a5 JTF_NUMBER_TABLE
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
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
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
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
215: , a7 JTF_NUMBER_TABLE
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
213: , a5 JTF_NUMBER_TABLE
214: , a6 JTF_NUMBER_TABLE
215: , a7 JTF_NUMBER_TABLE
216: , a8 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
220: , a12 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
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 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
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_NUMBER_TABLE
222: , a14 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
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_NUMBER_TABLE
222: , a14 JTF_NUMBER_TABLE
223: , a15 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
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
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
268: , a5 out nocopy JTF_NUMBER_TABLE
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
268: , a5 out nocopy JTF_NUMBER_TABLE
269: , a6 out nocopy JTF_NUMBER_TABLE
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
268: , a5 out nocopy JTF_NUMBER_TABLE
269: , a6 out nocopy JTF_NUMBER_TABLE
270: , a7 out nocopy JTF_NUMBER_TABLE
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
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
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
275: , a12 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
275: , a12 out nocopy JTF_VARCHAR2_TABLE_100
276: , a13 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
275: , a12 out nocopy JTF_VARCHAR2_TABLE_100
276: , a13 out nocopy JTF_NUMBER_TABLE
277: , a14 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
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
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
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
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();
291: a5 := JTF_NUMBER_TABLE();
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();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
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();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
293: a7 := JTF_NUMBER_TABLE();
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();
291: a5 := JTF_NUMBER_TABLE();
292: a6 := JTF_NUMBER_TABLE();
293: a7 := JTF_NUMBER_TABLE();
294: a8 := 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();
298: a12 := 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();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := 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();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := JTF_NUMBER_TABLE();
300: a14 := 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();
298: a12 := JTF_VARCHAR2_TABLE_100();
299: a13 := JTF_NUMBER_TABLE();
300: a14 := JTF_NUMBER_TABLE();
301: a15 := 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();
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
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();
311: a5 := JTF_NUMBER_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();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
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();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_NUMBER_TABLE();
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();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_NUMBER_TABLE();
314: a8 := 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();
318: a12 := 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();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := 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();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := JTF_NUMBER_TABLE();
320: a14 := 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();
318: a12 := JTF_VARCHAR2_TABLE_100();
319: a13 := JTF_NUMBER_TABLE();
320: a14 := JTF_NUMBER_TABLE();
321: a15 := 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();
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();
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;
384: begin
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;
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();
420: a1 := 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);
426: a1.extend(t.count);
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
453: , a5 JTF_NUMBER_TABLE
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
455: , a7 JTF_DATE_TABLE
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
455: , a7 JTF_DATE_TABLE
456: , a8 JTF_DATE_TABLE
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
502: , a5 out nocopy JTF_NUMBER_TABLE
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
504: , a7 out nocopy JTF_DATE_TABLE
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
504: , a7 out nocopy JTF_DATE_TABLE
505: , a8 out nocopy JTF_DATE_TABLE
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();
522: a5 := JTF_NUMBER_TABLE();
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();
524: a7 := JTF_DATE_TABLE();
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();
524: a7 := JTF_DATE_TABLE();
525: a8 := JTF_DATE_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();
539: a5 := 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();
541: a7 := JTF_DATE_TABLE();
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();
541: a7 := JTF_DATE_TABLE();
542: a8 := JTF_DATE_TABLE();
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
603: , p2_a5 JTF_DATE_TABLE
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
603: , p2_a5 JTF_DATE_TABLE
604: , p2_a6 JTF_NUMBER_TABLE
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
603: , p2_a5 JTF_DATE_TABLE
604: , p2_a6 JTF_NUMBER_TABLE
605: , p2_a7 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
609: , p3_a0 JTF_VARCHAR2_TABLE_100
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
612: , p3_a3 JTF_VARCHAR2_TABLE_100
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
612: , p3_a3 JTF_VARCHAR2_TABLE_100
613: , p3_a4 JTF_NUMBER_TABLE
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
612: , p3_a3 JTF_VARCHAR2_TABLE_100
613: , p3_a4 JTF_NUMBER_TABLE
614: , p3_a5 JTF_DATE_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
616: , p3_a7 JTF_VARCHAR2_TABLE_2000
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
622: , p4_a5 JTF_NUMBER_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
622: , p4_a5 JTF_NUMBER_TABLE
623: , p4_a6 JTF_NUMBER_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
622: , p4_a5 JTF_NUMBER_TABLE
623: , p4_a6 JTF_NUMBER_TABLE
624: , p4_a7 JTF_NUMBER_TABLE
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
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
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
629: , p4_a12 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
629: , p4_a12 JTF_VARCHAR2_TABLE_100
630: , p4_a13 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
629: , p4_a12 JTF_VARCHAR2_TABLE_100
630: , p4_a13 JTF_NUMBER_TABLE
631: , p4_a14 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
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
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
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
710:
711:
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
711:
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
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
721: , p0_a7 JTF_VARCHAR2_TABLE_2000
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
727: , p1_a5 JTF_NUMBER_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
727: , p1_a5 JTF_NUMBER_TABLE
728: , p1_a6 JTF_NUMBER_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
727: , p1_a5 JTF_NUMBER_TABLE
728: , p1_a6 JTF_NUMBER_TABLE
729: , p1_a7 JTF_NUMBER_TABLE
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
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
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
734: , p1_a12 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
734: , p1_a12 JTF_VARCHAR2_TABLE_100
735: , p1_a13 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
734: , p1_a12 JTF_VARCHAR2_TABLE_100
735: , p1_a13 JTF_NUMBER_TABLE
736: , p1_a14 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
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
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
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
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
748: , x_error_msg out nocopy VARCHAR2
812:
813:
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
813:
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
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
823: , p0_a7 JTF_VARCHAR2_TABLE_2000
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
829: , p1_a5 JTF_NUMBER_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
831: , p1_a7 JTF_DATE_TABLE
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
831: , p1_a7 JTF_DATE_TABLE
832: , p1_a8 JTF_DATE_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
847: , x_error_msg out nocopy VARCHAR2