1: package body ahl_warranty_entl_pvt_w as
2: /* $Header: AHLWENTB.pls 120.0.12020000.2 2012/12/13 05:26:56 shnatu ship $ */
3: procedure rosetta_table_copy_in_p19(t out nocopy ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body ahl_warranty_entl_pvt_w as
2: /* $Header: AHLWENTB.pls 120.0.12020000.2 2012/12/13 05:26:56 shnatu ship $ */
3: procedure rosetta_table_copy_in_p19(t out nocopy ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p19(t out nocopy ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_200
88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p19;
92: procedure rosetta_table_copy_out_p19(t ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
90: end if;
91: end rosetta_table_copy_in_p19;
92: procedure rosetta_table_copy_out_p19(t ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
92: procedure rosetta_table_copy_out_p19(t ahl_warranty_entl_pvt.warranty_entl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_VARCHAR2_TABLE_100
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
97: , a5 out nocopy JTF_DATE_TABLE
98: , a6 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
99: , a7 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
100: , a8 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
101: , a9 out nocopy JTF_NUMBER_TABLE
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
109: , a17 out nocopy JTF_VARCHAR2_TABLE_100
102: , a10 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
109: , a17 out nocopy JTF_VARCHAR2_TABLE_100
110: , a18 out nocopy JTF_VARCHAR2_TABLE_100
103: , a11 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
109: , a17 out nocopy JTF_VARCHAR2_TABLE_100
110: , a18 out nocopy JTF_VARCHAR2_TABLE_100
111: , a19 out nocopy JTF_NUMBER_TABLE
104: , a12 out nocopy JTF_NUMBER_TABLE
105: , a13 out nocopy JTF_NUMBER_TABLE
106: , a14 out nocopy JTF_NUMBER_TABLE
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
109: , a17 out nocopy JTF_VARCHAR2_TABLE_100
110: , a18 out nocopy JTF_VARCHAR2_TABLE_100
111: , a19 out nocopy JTF_NUMBER_TABLE
112: , a20 out nocopy JTF_VARCHAR2_TABLE_100
107: , a15 out nocopy JTF_NUMBER_TABLE
108: , a16 out nocopy JTF_NUMBER_TABLE
109: , a17 out nocopy JTF_VARCHAR2_TABLE_100
110: , a18 out nocopy JTF_VARCHAR2_TABLE_100
111: , a19 out nocopy JTF_NUMBER_TABLE
112: , a20 out nocopy JTF_VARCHAR2_TABLE_100
113: , a21 out nocopy JTF_VARCHAR2_TABLE_200
114: , a22 out nocopy JTF_VARCHAR2_TABLE_200
115: , a23 out nocopy JTF_VARCHAR2_TABLE_200
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin
131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_DATE_TABLE();
136: a4 := JTF_NUMBER_TABLE();
130: begin
131: if t is null or t.count = 0 then
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_DATE_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
132: a0 := JTF_NUMBER_TABLE();
133: a1 := JTF_VARCHAR2_TABLE_100();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_DATE_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
134: a2 := JTF_NUMBER_TABLE();
135: a3 := JTF_DATE_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
135: a3 := JTF_DATE_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
136: a4 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
137: a5 := JTF_DATE_TABLE();
138: a6 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
139: a7 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
140: a8 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
141: a9 := JTF_NUMBER_TABLE();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
149: a17 := JTF_VARCHAR2_TABLE_100();
142: a10 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
149: a17 := JTF_VARCHAR2_TABLE_100();
150: a18 := JTF_VARCHAR2_TABLE_100();
143: a11 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
149: a17 := JTF_VARCHAR2_TABLE_100();
150: a18 := JTF_VARCHAR2_TABLE_100();
151: a19 := JTF_NUMBER_TABLE();
144: a12 := JTF_NUMBER_TABLE();
145: a13 := JTF_NUMBER_TABLE();
146: a14 := JTF_NUMBER_TABLE();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
149: a17 := JTF_VARCHAR2_TABLE_100();
150: a18 := JTF_VARCHAR2_TABLE_100();
151: a19 := JTF_NUMBER_TABLE();
152: a20 := JTF_VARCHAR2_TABLE_100();
147: a15 := JTF_NUMBER_TABLE();
148: a16 := JTF_NUMBER_TABLE();
149: a17 := JTF_VARCHAR2_TABLE_100();
150: a18 := JTF_VARCHAR2_TABLE_100();
151: a19 := JTF_NUMBER_TABLE();
152: a20 := JTF_VARCHAR2_TABLE_100();
153: a21 := JTF_VARCHAR2_TABLE_200();
154: a22 := JTF_VARCHAR2_TABLE_200();
155: a23 := JTF_VARCHAR2_TABLE_200();
165: a33 := JTF_VARCHAR2_TABLE_200();
166: a34 := JTF_VARCHAR2_TABLE_200();
167: a35 := JTF_VARCHAR2_TABLE_200();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_DATE_TABLE();
173: a4 := JTF_NUMBER_TABLE();
167: a35 := JTF_VARCHAR2_TABLE_200();
168: else
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_DATE_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
169: a0 := JTF_NUMBER_TABLE();
170: a1 := JTF_VARCHAR2_TABLE_100();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_DATE_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
171: a2 := JTF_NUMBER_TABLE();
172: a3 := JTF_DATE_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
172: a3 := JTF_DATE_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
173: a4 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
174: a5 := JTF_DATE_TABLE();
175: a6 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
176: a7 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
177: a8 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
178: a9 := JTF_NUMBER_TABLE();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
186: a17 := JTF_VARCHAR2_TABLE_100();
179: a10 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
180: a11 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_NUMBER_TABLE();
181: a12 := JTF_NUMBER_TABLE();
182: a13 := JTF_NUMBER_TABLE();
183: a14 := JTF_NUMBER_TABLE();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_NUMBER_TABLE();
189: a20 := JTF_VARCHAR2_TABLE_100();
184: a15 := JTF_NUMBER_TABLE();
185: a16 := JTF_NUMBER_TABLE();
186: a17 := JTF_VARCHAR2_TABLE_100();
187: a18 := JTF_VARCHAR2_TABLE_100();
188: a19 := JTF_NUMBER_TABLE();
189: a20 := JTF_VARCHAR2_TABLE_100();
190: a21 := JTF_VARCHAR2_TABLE_200();
191: a22 := JTF_VARCHAR2_TABLE_200();
192: a23 := JTF_VARCHAR2_TABLE_200();
294: , p_validation_level NUMBER
295: , p_module_type VARCHAR2
296: , p_user_role VARCHAR2
297: , p_appr_action VARCHAR2
298: , p7_a0 in out nocopy JTF_NUMBER_TABLE
299: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p7_a2 in out nocopy JTF_NUMBER_TABLE
301: , p7_a3 in out nocopy JTF_DATE_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
296: , p_user_role VARCHAR2
297: , p_appr_action VARCHAR2
298: , p7_a0 in out nocopy JTF_NUMBER_TABLE
299: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p7_a2 in out nocopy JTF_NUMBER_TABLE
301: , p7_a3 in out nocopy JTF_DATE_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
298: , p7_a0 in out nocopy JTF_NUMBER_TABLE
299: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p7_a2 in out nocopy JTF_NUMBER_TABLE
301: , p7_a3 in out nocopy JTF_DATE_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
300: , p7_a2 in out nocopy JTF_NUMBER_TABLE
301: , p7_a3 in out nocopy JTF_DATE_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p7_a3 in out nocopy JTF_DATE_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
302: , p7_a4 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
303: , p7_a5 in out nocopy JTF_DATE_TABLE
304: , p7_a6 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
305: , p7_a7 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
306: , p7_a8 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
307: , p7_a9 in out nocopy JTF_NUMBER_TABLE
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
315: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
315: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p7_a11 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
315: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a19 in out nocopy JTF_NUMBER_TABLE
310: , p7_a12 in out nocopy JTF_NUMBER_TABLE
311: , p7_a13 in out nocopy JTF_NUMBER_TABLE
312: , p7_a14 in out nocopy JTF_NUMBER_TABLE
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
315: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a19 in out nocopy JTF_NUMBER_TABLE
318: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_100
313: , p7_a15 in out nocopy JTF_NUMBER_TABLE
314: , p7_a16 in out nocopy JTF_NUMBER_TABLE
315: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a19 in out nocopy JTF_NUMBER_TABLE
318: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_100
319: , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
320: , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
321: , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200