114: , p_init_msg_list VARCHAR2
115: , x_return_status out nocopy VARCHAR2
116: , x_msg_count out nocopy NUMBER
117: , x_msg_data out nocopy VARCHAR2
118: , p5_a0 JTF_NUMBER_TABLE
119: , p5_a1 JTF_NUMBER_TABLE
120: , p5_a2 JTF_VARCHAR2_TABLE_100
121: , p5_a3 JTF_NUMBER_TABLE
122: , p5_a4 JTF_VARCHAR2_TABLE_100
115: , x_return_status out nocopy VARCHAR2
116: , x_msg_count out nocopy NUMBER
117: , x_msg_data out nocopy VARCHAR2
118: , p5_a0 JTF_NUMBER_TABLE
119: , p5_a1 JTF_NUMBER_TABLE
120: , p5_a2 JTF_VARCHAR2_TABLE_100
121: , p5_a3 JTF_NUMBER_TABLE
122: , p5_a4 JTF_VARCHAR2_TABLE_100
123: , p5_a5 JTF_VARCHAR2_TABLE_200
117: , x_msg_data out nocopy VARCHAR2
118: , p5_a0 JTF_NUMBER_TABLE
119: , p5_a1 JTF_NUMBER_TABLE
120: , p5_a2 JTF_VARCHAR2_TABLE_100
121: , p5_a3 JTF_NUMBER_TABLE
122: , p5_a4 JTF_VARCHAR2_TABLE_100
123: , p5_a5 JTF_VARCHAR2_TABLE_200
124: , p5_a6 JTF_VARCHAR2_TABLE_2000
125: , p5_a7 JTF_DATE_TABLE
123: , p5_a5 JTF_VARCHAR2_TABLE_200
124: , p5_a6 JTF_VARCHAR2_TABLE_2000
125: , p5_a7 JTF_DATE_TABLE
126: , p5_a8 JTF_DATE_TABLE
127: , p5_a9 JTF_NUMBER_TABLE
128: , p5_a10 JTF_VARCHAR2_TABLE_100
129: , p5_a11 JTF_VARCHAR2_TABLE_100
130: , p5_a12 JTF_VARCHAR2_TABLE_100
131: , p5_a13 JTF_VARCHAR2_TABLE_100
128: , p5_a10 JTF_VARCHAR2_TABLE_100
129: , p5_a11 JTF_VARCHAR2_TABLE_100
130: , p5_a12 JTF_VARCHAR2_TABLE_100
131: , p5_a13 JTF_VARCHAR2_TABLE_100
132: , p5_a14 JTF_NUMBER_TABLE
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
129: , p5_a11 JTF_VARCHAR2_TABLE_100
130: , p5_a12 JTF_VARCHAR2_TABLE_100
131: , p5_a13 JTF_VARCHAR2_TABLE_100
132: , p5_a14 JTF_NUMBER_TABLE
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
130: , p5_a12 JTF_VARCHAR2_TABLE_100
131: , p5_a13 JTF_VARCHAR2_TABLE_100
132: , p5_a14 JTF_NUMBER_TABLE
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
131: , p5_a13 JTF_VARCHAR2_TABLE_100
132: , p5_a14 JTF_NUMBER_TABLE
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
139: , p5_a21 JTF_VARCHAR2_TABLE_100
132: , p5_a14 JTF_NUMBER_TABLE
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
139: , p5_a21 JTF_VARCHAR2_TABLE_100
140: , p5_a22 JTF_VARCHAR2_TABLE_100
133: , p5_a15 JTF_NUMBER_TABLE
134: , p5_a16 JTF_NUMBER_TABLE
135: , p5_a17 JTF_NUMBER_TABLE
136: , p5_a18 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
139: , p5_a21 JTF_VARCHAR2_TABLE_100
140: , p5_a22 JTF_VARCHAR2_TABLE_100
141: , p5_a23 JTF_NUMBER_TABLE
137: , p5_a19 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
139: , p5_a21 JTF_VARCHAR2_TABLE_100
140: , p5_a22 JTF_VARCHAR2_TABLE_100
141: , p5_a23 JTF_NUMBER_TABLE
142: , p5_a24 JTF_NUMBER_TABLE
143: , p5_a25 JTF_VARCHAR2_TABLE_100
144: , p5_a26 JTF_VARCHAR2_TABLE_100
145: , p5_a27 JTF_NUMBER_TABLE
138: , p5_a20 JTF_VARCHAR2_TABLE_100
139: , p5_a21 JTF_VARCHAR2_TABLE_100
140: , p5_a22 JTF_VARCHAR2_TABLE_100
141: , p5_a23 JTF_NUMBER_TABLE
142: , p5_a24 JTF_NUMBER_TABLE
143: , p5_a25 JTF_VARCHAR2_TABLE_100
144: , p5_a26 JTF_VARCHAR2_TABLE_100
145: , p5_a27 JTF_NUMBER_TABLE
146: , p5_a28 JTF_NUMBER_TABLE
141: , p5_a23 JTF_NUMBER_TABLE
142: , p5_a24 JTF_NUMBER_TABLE
143: , p5_a25 JTF_VARCHAR2_TABLE_100
144: , p5_a26 JTF_VARCHAR2_TABLE_100
145: , p5_a27 JTF_NUMBER_TABLE
146: , p5_a28 JTF_NUMBER_TABLE
147: , p5_a29 JTF_VARCHAR2_TABLE_100
148: , p5_a30 JTF_VARCHAR2_TABLE_100
149: , p5_a31 JTF_VARCHAR2_TABLE_500
142: , p5_a24 JTF_NUMBER_TABLE
143: , p5_a25 JTF_VARCHAR2_TABLE_100
144: , p5_a26 JTF_VARCHAR2_TABLE_100
145: , p5_a27 JTF_NUMBER_TABLE
146: , p5_a28 JTF_NUMBER_TABLE
147: , p5_a29 JTF_VARCHAR2_TABLE_100
148: , p5_a30 JTF_VARCHAR2_TABLE_100
149: , p5_a31 JTF_VARCHAR2_TABLE_500
150: , p5_a32 JTF_VARCHAR2_TABLE_500
160: , p5_a42 JTF_VARCHAR2_TABLE_500
161: , p5_a43 JTF_VARCHAR2_TABLE_100
162: , p5_a44 JTF_VARCHAR2_TABLE_500
163: , p5_a45 JTF_VARCHAR2_TABLE_500
164: , p5_a46 JTF_NUMBER_TABLE
165: , p5_a47 JTF_DATE_TABLE
166: , p5_a48 JTF_NUMBER_TABLE
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
162: , p5_a44 JTF_VARCHAR2_TABLE_500
163: , p5_a45 JTF_VARCHAR2_TABLE_500
164: , p5_a46 JTF_NUMBER_TABLE
165: , p5_a47 JTF_DATE_TABLE
166: , p5_a48 JTF_NUMBER_TABLE
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
164: , p5_a46 JTF_NUMBER_TABLE
165: , p5_a47 JTF_DATE_TABLE
166: , p5_a48 JTF_NUMBER_TABLE
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
171: , p6_a1 out nocopy JTF_NUMBER_TABLE
172: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
165: , p5_a47 JTF_DATE_TABLE
166: , p5_a48 JTF_NUMBER_TABLE
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
171: , p6_a1 out nocopy JTF_NUMBER_TABLE
172: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p5_a48 JTF_NUMBER_TABLE
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
171: , p6_a1 out nocopy JTF_NUMBER_TABLE
172: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a3 out nocopy JTF_NUMBER_TABLE
174: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
167: , p5_a49 JTF_DATE_TABLE
168: , p5_a50 JTF_NUMBER_TABLE
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
171: , p6_a1 out nocopy JTF_NUMBER_TABLE
172: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a3 out nocopy JTF_NUMBER_TABLE
174: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
169: , p5_a51 JTF_NUMBER_TABLE
170: , p6_a0 out nocopy JTF_NUMBER_TABLE
171: , p6_a1 out nocopy JTF_NUMBER_TABLE
172: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a3 out nocopy JTF_NUMBER_TABLE
174: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
176: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
177: , p6_a7 out nocopy JTF_DATE_TABLE
175: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
176: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
177: , p6_a7 out nocopy JTF_DATE_TABLE
178: , p6_a8 out nocopy JTF_DATE_TABLE
179: , p6_a9 out nocopy JTF_NUMBER_TABLE
180: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
181: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a14 out nocopy JTF_NUMBER_TABLE
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
181: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a14 out nocopy JTF_NUMBER_TABLE
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
182: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a14 out nocopy JTF_NUMBER_TABLE
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a14 out nocopy JTF_NUMBER_TABLE
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
184: , p6_a14 out nocopy JTF_NUMBER_TABLE
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a15 out nocopy JTF_NUMBER_TABLE
186: , p6_a16 out nocopy JTF_NUMBER_TABLE
187: , p6_a17 out nocopy JTF_NUMBER_TABLE
188: , p6_a18 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a23 out nocopy JTF_NUMBER_TABLE
189: , p6_a19 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a23 out nocopy JTF_NUMBER_TABLE
194: , p6_a24 out nocopy JTF_NUMBER_TABLE
195: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a27 out nocopy JTF_NUMBER_TABLE
190: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
191: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
192: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a23 out nocopy JTF_NUMBER_TABLE
194: , p6_a24 out nocopy JTF_NUMBER_TABLE
195: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a27 out nocopy JTF_NUMBER_TABLE
198: , p6_a28 out nocopy JTF_NUMBER_TABLE
193: , p6_a23 out nocopy JTF_NUMBER_TABLE
194: , p6_a24 out nocopy JTF_NUMBER_TABLE
195: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a27 out nocopy JTF_NUMBER_TABLE
198: , p6_a28 out nocopy JTF_NUMBER_TABLE
199: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
200: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
194: , p6_a24 out nocopy JTF_NUMBER_TABLE
195: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a27 out nocopy JTF_NUMBER_TABLE
198: , p6_a28 out nocopy JTF_NUMBER_TABLE
199: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
200: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
202: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
212: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
213: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
215: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a46 out nocopy JTF_NUMBER_TABLE
217: , p6_a47 out nocopy JTF_DATE_TABLE
218: , p6_a48 out nocopy JTF_NUMBER_TABLE
219: , p6_a49 out nocopy JTF_DATE_TABLE
220: , p6_a50 out nocopy JTF_NUMBER_TABLE
214: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
215: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a46 out nocopy JTF_NUMBER_TABLE
217: , p6_a47 out nocopy JTF_DATE_TABLE
218: , p6_a48 out nocopy JTF_NUMBER_TABLE
219: , p6_a49 out nocopy JTF_DATE_TABLE
220: , p6_a50 out nocopy JTF_NUMBER_TABLE
221: , p6_a51 out nocopy JTF_NUMBER_TABLE
222: );
216: , p6_a46 out nocopy JTF_NUMBER_TABLE
217: , p6_a47 out nocopy JTF_DATE_TABLE
218: , p6_a48 out nocopy JTF_NUMBER_TABLE
219: , p6_a49 out nocopy JTF_DATE_TABLE
220: , p6_a50 out nocopy JTF_NUMBER_TABLE
221: , p6_a51 out nocopy JTF_NUMBER_TABLE
222: );
223: procedure update_subsidy(p_api_version NUMBER
224: , p_init_msg_list VARCHAR2
217: , p6_a47 out nocopy JTF_DATE_TABLE
218: , p6_a48 out nocopy JTF_NUMBER_TABLE
219: , p6_a49 out nocopy JTF_DATE_TABLE
220: , p6_a50 out nocopy JTF_NUMBER_TABLE
221: , p6_a51 out nocopy JTF_NUMBER_TABLE
222: );
223: procedure update_subsidy(p_api_version NUMBER
224: , p_init_msg_list VARCHAR2
225: , x_return_status out nocopy VARCHAR2
334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_VARCHAR2_TABLE_200
337: , x_msg_data out nocopy VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_VARCHAR2_TABLE_200
344: , p5_a6 JTF_VARCHAR2_TABLE_2000
345: , p5_a7 JTF_DATE_TABLE
343: , p5_a5 JTF_VARCHAR2_TABLE_200
344: , p5_a6 JTF_VARCHAR2_TABLE_2000
345: , p5_a7 JTF_DATE_TABLE
346: , p5_a8 JTF_DATE_TABLE
347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_VARCHAR2_TABLE_100
349: , p5_a11 JTF_VARCHAR2_TABLE_100
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
348: , p5_a10 JTF_VARCHAR2_TABLE_100
349: , p5_a11 JTF_VARCHAR2_TABLE_100
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_NUMBER_TABLE
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
349: , p5_a11 JTF_VARCHAR2_TABLE_100
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_NUMBER_TABLE
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
350: , p5_a12 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_NUMBER_TABLE
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_NUMBER_TABLE
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
359: , p5_a21 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_NUMBER_TABLE
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
359: , p5_a21 JTF_VARCHAR2_TABLE_100
360: , p5_a22 JTF_VARCHAR2_TABLE_100
353: , p5_a15 JTF_NUMBER_TABLE
354: , p5_a16 JTF_NUMBER_TABLE
355: , p5_a17 JTF_NUMBER_TABLE
356: , p5_a18 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
359: , p5_a21 JTF_VARCHAR2_TABLE_100
360: , p5_a22 JTF_VARCHAR2_TABLE_100
361: , p5_a23 JTF_NUMBER_TABLE
357: , p5_a19 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
359: , p5_a21 JTF_VARCHAR2_TABLE_100
360: , p5_a22 JTF_VARCHAR2_TABLE_100
361: , p5_a23 JTF_NUMBER_TABLE
362: , p5_a24 JTF_NUMBER_TABLE
363: , p5_a25 JTF_VARCHAR2_TABLE_100
364: , p5_a26 JTF_VARCHAR2_TABLE_100
365: , p5_a27 JTF_NUMBER_TABLE
358: , p5_a20 JTF_VARCHAR2_TABLE_100
359: , p5_a21 JTF_VARCHAR2_TABLE_100
360: , p5_a22 JTF_VARCHAR2_TABLE_100
361: , p5_a23 JTF_NUMBER_TABLE
362: , p5_a24 JTF_NUMBER_TABLE
363: , p5_a25 JTF_VARCHAR2_TABLE_100
364: , p5_a26 JTF_VARCHAR2_TABLE_100
365: , p5_a27 JTF_NUMBER_TABLE
366: , p5_a28 JTF_NUMBER_TABLE
361: , p5_a23 JTF_NUMBER_TABLE
362: , p5_a24 JTF_NUMBER_TABLE
363: , p5_a25 JTF_VARCHAR2_TABLE_100
364: , p5_a26 JTF_VARCHAR2_TABLE_100
365: , p5_a27 JTF_NUMBER_TABLE
366: , p5_a28 JTF_NUMBER_TABLE
367: , p5_a29 JTF_VARCHAR2_TABLE_100
368: , p5_a30 JTF_VARCHAR2_TABLE_100
369: , p5_a31 JTF_VARCHAR2_TABLE_500
362: , p5_a24 JTF_NUMBER_TABLE
363: , p5_a25 JTF_VARCHAR2_TABLE_100
364: , p5_a26 JTF_VARCHAR2_TABLE_100
365: , p5_a27 JTF_NUMBER_TABLE
366: , p5_a28 JTF_NUMBER_TABLE
367: , p5_a29 JTF_VARCHAR2_TABLE_100
368: , p5_a30 JTF_VARCHAR2_TABLE_100
369: , p5_a31 JTF_VARCHAR2_TABLE_500
370: , p5_a32 JTF_VARCHAR2_TABLE_500
380: , p5_a42 JTF_VARCHAR2_TABLE_500
381: , p5_a43 JTF_VARCHAR2_TABLE_100
382: , p5_a44 JTF_VARCHAR2_TABLE_500
383: , p5_a45 JTF_VARCHAR2_TABLE_500
384: , p5_a46 JTF_NUMBER_TABLE
385: , p5_a47 JTF_DATE_TABLE
386: , p5_a48 JTF_NUMBER_TABLE
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
382: , p5_a44 JTF_VARCHAR2_TABLE_500
383: , p5_a45 JTF_VARCHAR2_TABLE_500
384: , p5_a46 JTF_NUMBER_TABLE
385: , p5_a47 JTF_DATE_TABLE
386: , p5_a48 JTF_NUMBER_TABLE
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
384: , p5_a46 JTF_NUMBER_TABLE
385: , p5_a47 JTF_DATE_TABLE
386: , p5_a48 JTF_NUMBER_TABLE
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
391: , p6_a1 out nocopy JTF_NUMBER_TABLE
392: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
385: , p5_a47 JTF_DATE_TABLE
386: , p5_a48 JTF_NUMBER_TABLE
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
391: , p6_a1 out nocopy JTF_NUMBER_TABLE
392: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p5_a48 JTF_NUMBER_TABLE
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
391: , p6_a1 out nocopy JTF_NUMBER_TABLE
392: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p6_a3 out nocopy JTF_NUMBER_TABLE
394: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p5_a49 JTF_DATE_TABLE
388: , p5_a50 JTF_NUMBER_TABLE
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
391: , p6_a1 out nocopy JTF_NUMBER_TABLE
392: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p6_a3 out nocopy JTF_NUMBER_TABLE
394: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
395: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
389: , p5_a51 JTF_NUMBER_TABLE
390: , p6_a0 out nocopy JTF_NUMBER_TABLE
391: , p6_a1 out nocopy JTF_NUMBER_TABLE
392: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
393: , p6_a3 out nocopy JTF_NUMBER_TABLE
394: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
395: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
396: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
397: , p6_a7 out nocopy JTF_DATE_TABLE
395: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
396: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
397: , p6_a7 out nocopy JTF_DATE_TABLE
398: , p6_a8 out nocopy JTF_DATE_TABLE
399: , p6_a9 out nocopy JTF_NUMBER_TABLE
400: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
402: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
400: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
402: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
404: , p6_a14 out nocopy JTF_NUMBER_TABLE
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
401: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
402: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
404: , p6_a14 out nocopy JTF_NUMBER_TABLE
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
402: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
404: , p6_a14 out nocopy JTF_NUMBER_TABLE
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
404: , p6_a14 out nocopy JTF_NUMBER_TABLE
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
404: , p6_a14 out nocopy JTF_NUMBER_TABLE
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
405: , p6_a15 out nocopy JTF_NUMBER_TABLE
406: , p6_a16 out nocopy JTF_NUMBER_TABLE
407: , p6_a17 out nocopy JTF_NUMBER_TABLE
408: , p6_a18 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a23 out nocopy JTF_NUMBER_TABLE
409: , p6_a19 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a23 out nocopy JTF_NUMBER_TABLE
414: , p6_a24 out nocopy JTF_NUMBER_TABLE
415: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a27 out nocopy JTF_NUMBER_TABLE
410: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
413: , p6_a23 out nocopy JTF_NUMBER_TABLE
414: , p6_a24 out nocopy JTF_NUMBER_TABLE
415: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a27 out nocopy JTF_NUMBER_TABLE
418: , p6_a28 out nocopy JTF_NUMBER_TABLE
413: , p6_a23 out nocopy JTF_NUMBER_TABLE
414: , p6_a24 out nocopy JTF_NUMBER_TABLE
415: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a27 out nocopy JTF_NUMBER_TABLE
418: , p6_a28 out nocopy JTF_NUMBER_TABLE
419: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
420: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
421: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a24 out nocopy JTF_NUMBER_TABLE
415: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
416: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a27 out nocopy JTF_NUMBER_TABLE
418: , p6_a28 out nocopy JTF_NUMBER_TABLE
419: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
420: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
421: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
422: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
432: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
433: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
435: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
436: , p6_a46 out nocopy JTF_NUMBER_TABLE
437: , p6_a47 out nocopy JTF_DATE_TABLE
438: , p6_a48 out nocopy JTF_NUMBER_TABLE
439: , p6_a49 out nocopy JTF_DATE_TABLE
440: , p6_a50 out nocopy JTF_NUMBER_TABLE
434: , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
435: , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
436: , p6_a46 out nocopy JTF_NUMBER_TABLE
437: , p6_a47 out nocopy JTF_DATE_TABLE
438: , p6_a48 out nocopy JTF_NUMBER_TABLE
439: , p6_a49 out nocopy JTF_DATE_TABLE
440: , p6_a50 out nocopy JTF_NUMBER_TABLE
441: , p6_a51 out nocopy JTF_NUMBER_TABLE
442: );
436: , p6_a46 out nocopy JTF_NUMBER_TABLE
437: , p6_a47 out nocopy JTF_DATE_TABLE
438: , p6_a48 out nocopy JTF_NUMBER_TABLE
439: , p6_a49 out nocopy JTF_DATE_TABLE
440: , p6_a50 out nocopy JTF_NUMBER_TABLE
441: , p6_a51 out nocopy JTF_NUMBER_TABLE
442: );
443: procedure delete_subsidy(p_api_version NUMBER
444: , p_init_msg_list VARCHAR2
437: , p6_a47 out nocopy JTF_DATE_TABLE
438: , p6_a48 out nocopy JTF_NUMBER_TABLE
439: , p6_a49 out nocopy JTF_DATE_TABLE
440: , p6_a50 out nocopy JTF_NUMBER_TABLE
441: , p6_a51 out nocopy JTF_NUMBER_TABLE
442: );
443: procedure delete_subsidy(p_api_version NUMBER
444: , p_init_msg_list VARCHAR2
445: , x_return_status out nocopy VARCHAR2
502: , p_init_msg_list VARCHAR2
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_VARCHAR2_TABLE_100
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_VARCHAR2_TABLE_100
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_VARCHAR2_TABLE_100
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_VARCHAR2_TABLE_100
511: , p5_a5 JTF_VARCHAR2_TABLE_200
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_VARCHAR2_TABLE_100
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_VARCHAR2_TABLE_100
511: , p5_a5 JTF_VARCHAR2_TABLE_200
512: , p5_a6 JTF_VARCHAR2_TABLE_2000
513: , p5_a7 JTF_DATE_TABLE
511: , p5_a5 JTF_VARCHAR2_TABLE_200
512: , p5_a6 JTF_VARCHAR2_TABLE_2000
513: , p5_a7 JTF_DATE_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
516: , p5_a10 JTF_VARCHAR2_TABLE_100
517: , p5_a11 JTF_VARCHAR2_TABLE_100
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_100
516: , p5_a10 JTF_VARCHAR2_TABLE_100
517: , p5_a11 JTF_VARCHAR2_TABLE_100
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_100
520: , p5_a14 JTF_NUMBER_TABLE
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
517: , p5_a11 JTF_VARCHAR2_TABLE_100
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_100
520: , p5_a14 JTF_NUMBER_TABLE
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_100
520: , p5_a14 JTF_NUMBER_TABLE
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_100
520: , p5_a14 JTF_NUMBER_TABLE
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
527: , p5_a21 JTF_VARCHAR2_TABLE_100
520: , p5_a14 JTF_NUMBER_TABLE
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
527: , p5_a21 JTF_VARCHAR2_TABLE_100
528: , p5_a22 JTF_VARCHAR2_TABLE_100
521: , p5_a15 JTF_NUMBER_TABLE
522: , p5_a16 JTF_NUMBER_TABLE
523: , p5_a17 JTF_NUMBER_TABLE
524: , p5_a18 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
527: , p5_a21 JTF_VARCHAR2_TABLE_100
528: , p5_a22 JTF_VARCHAR2_TABLE_100
529: , p5_a23 JTF_NUMBER_TABLE
525: , p5_a19 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
527: , p5_a21 JTF_VARCHAR2_TABLE_100
528: , p5_a22 JTF_VARCHAR2_TABLE_100
529: , p5_a23 JTF_NUMBER_TABLE
530: , p5_a24 JTF_NUMBER_TABLE
531: , p5_a25 JTF_VARCHAR2_TABLE_100
532: , p5_a26 JTF_VARCHAR2_TABLE_100
533: , p5_a27 JTF_NUMBER_TABLE
526: , p5_a20 JTF_VARCHAR2_TABLE_100
527: , p5_a21 JTF_VARCHAR2_TABLE_100
528: , p5_a22 JTF_VARCHAR2_TABLE_100
529: , p5_a23 JTF_NUMBER_TABLE
530: , p5_a24 JTF_NUMBER_TABLE
531: , p5_a25 JTF_VARCHAR2_TABLE_100
532: , p5_a26 JTF_VARCHAR2_TABLE_100
533: , p5_a27 JTF_NUMBER_TABLE
534: , p5_a28 JTF_NUMBER_TABLE
529: , p5_a23 JTF_NUMBER_TABLE
530: , p5_a24 JTF_NUMBER_TABLE
531: , p5_a25 JTF_VARCHAR2_TABLE_100
532: , p5_a26 JTF_VARCHAR2_TABLE_100
533: , p5_a27 JTF_NUMBER_TABLE
534: , p5_a28 JTF_NUMBER_TABLE
535: , p5_a29 JTF_VARCHAR2_TABLE_100
536: , p5_a30 JTF_VARCHAR2_TABLE_100
537: , p5_a31 JTF_VARCHAR2_TABLE_500
530: , p5_a24 JTF_NUMBER_TABLE
531: , p5_a25 JTF_VARCHAR2_TABLE_100
532: , p5_a26 JTF_VARCHAR2_TABLE_100
533: , p5_a27 JTF_NUMBER_TABLE
534: , p5_a28 JTF_NUMBER_TABLE
535: , p5_a29 JTF_VARCHAR2_TABLE_100
536: , p5_a30 JTF_VARCHAR2_TABLE_100
537: , p5_a31 JTF_VARCHAR2_TABLE_500
538: , p5_a32 JTF_VARCHAR2_TABLE_500
548: , p5_a42 JTF_VARCHAR2_TABLE_500
549: , p5_a43 JTF_VARCHAR2_TABLE_100
550: , p5_a44 JTF_VARCHAR2_TABLE_500
551: , p5_a45 JTF_VARCHAR2_TABLE_500
552: , p5_a46 JTF_NUMBER_TABLE
553: , p5_a47 JTF_DATE_TABLE
554: , p5_a48 JTF_NUMBER_TABLE
555: , p5_a49 JTF_DATE_TABLE
556: , p5_a50 JTF_NUMBER_TABLE
550: , p5_a44 JTF_VARCHAR2_TABLE_500
551: , p5_a45 JTF_VARCHAR2_TABLE_500
552: , p5_a46 JTF_NUMBER_TABLE
553: , p5_a47 JTF_DATE_TABLE
554: , p5_a48 JTF_NUMBER_TABLE
555: , p5_a49 JTF_DATE_TABLE
556: , p5_a50 JTF_NUMBER_TABLE
557: , p5_a51 JTF_NUMBER_TABLE
558: );
552: , p5_a46 JTF_NUMBER_TABLE
553: , p5_a47 JTF_DATE_TABLE
554: , p5_a48 JTF_NUMBER_TABLE
555: , p5_a49 JTF_DATE_TABLE
556: , p5_a50 JTF_NUMBER_TABLE
557: , p5_a51 JTF_NUMBER_TABLE
558: );
559: procedure lock_subsidy(p_api_version NUMBER
560: , p_init_msg_list VARCHAR2
553: , p5_a47 JTF_DATE_TABLE
554: , p5_a48 JTF_NUMBER_TABLE
555: , p5_a49 JTF_DATE_TABLE
556: , p5_a50 JTF_NUMBER_TABLE
557: , p5_a51 JTF_NUMBER_TABLE
558: );
559: procedure lock_subsidy(p_api_version NUMBER
560: , p_init_msg_list VARCHAR2
561: , x_return_status out nocopy VARCHAR2
618: , p_init_msg_list VARCHAR2
619: , x_return_status out nocopy VARCHAR2
620: , x_msg_count out nocopy NUMBER
621: , x_msg_data out nocopy VARCHAR2
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_VARCHAR2_TABLE_100
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , x_return_status out nocopy VARCHAR2
620: , x_msg_count out nocopy NUMBER
621: , x_msg_data out nocopy VARCHAR2
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_VARCHAR2_TABLE_100
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_VARCHAR2_TABLE_100
627: , p5_a5 JTF_VARCHAR2_TABLE_200
621: , x_msg_data out nocopy VARCHAR2
622: , p5_a0 JTF_NUMBER_TABLE
623: , p5_a1 JTF_NUMBER_TABLE
624: , p5_a2 JTF_VARCHAR2_TABLE_100
625: , p5_a3 JTF_NUMBER_TABLE
626: , p5_a4 JTF_VARCHAR2_TABLE_100
627: , p5_a5 JTF_VARCHAR2_TABLE_200
628: , p5_a6 JTF_VARCHAR2_TABLE_2000
629: , p5_a7 JTF_DATE_TABLE
627: , p5_a5 JTF_VARCHAR2_TABLE_200
628: , p5_a6 JTF_VARCHAR2_TABLE_2000
629: , p5_a7 JTF_DATE_TABLE
630: , p5_a8 JTF_DATE_TABLE
631: , p5_a9 JTF_NUMBER_TABLE
632: , p5_a10 JTF_VARCHAR2_TABLE_100
633: , p5_a11 JTF_VARCHAR2_TABLE_100
634: , p5_a12 JTF_VARCHAR2_TABLE_100
635: , p5_a13 JTF_VARCHAR2_TABLE_100
632: , p5_a10 JTF_VARCHAR2_TABLE_100
633: , p5_a11 JTF_VARCHAR2_TABLE_100
634: , p5_a12 JTF_VARCHAR2_TABLE_100
635: , p5_a13 JTF_VARCHAR2_TABLE_100
636: , p5_a14 JTF_NUMBER_TABLE
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
633: , p5_a11 JTF_VARCHAR2_TABLE_100
634: , p5_a12 JTF_VARCHAR2_TABLE_100
635: , p5_a13 JTF_VARCHAR2_TABLE_100
636: , p5_a14 JTF_NUMBER_TABLE
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
634: , p5_a12 JTF_VARCHAR2_TABLE_100
635: , p5_a13 JTF_VARCHAR2_TABLE_100
636: , p5_a14 JTF_NUMBER_TABLE
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
635: , p5_a13 JTF_VARCHAR2_TABLE_100
636: , p5_a14 JTF_NUMBER_TABLE
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
643: , p5_a21 JTF_VARCHAR2_TABLE_100
636: , p5_a14 JTF_NUMBER_TABLE
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
643: , p5_a21 JTF_VARCHAR2_TABLE_100
644: , p5_a22 JTF_VARCHAR2_TABLE_100
637: , p5_a15 JTF_NUMBER_TABLE
638: , p5_a16 JTF_NUMBER_TABLE
639: , p5_a17 JTF_NUMBER_TABLE
640: , p5_a18 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
643: , p5_a21 JTF_VARCHAR2_TABLE_100
644: , p5_a22 JTF_VARCHAR2_TABLE_100
645: , p5_a23 JTF_NUMBER_TABLE
641: , p5_a19 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
643: , p5_a21 JTF_VARCHAR2_TABLE_100
644: , p5_a22 JTF_VARCHAR2_TABLE_100
645: , p5_a23 JTF_NUMBER_TABLE
646: , p5_a24 JTF_NUMBER_TABLE
647: , p5_a25 JTF_VARCHAR2_TABLE_100
648: , p5_a26 JTF_VARCHAR2_TABLE_100
649: , p5_a27 JTF_NUMBER_TABLE
642: , p5_a20 JTF_VARCHAR2_TABLE_100
643: , p5_a21 JTF_VARCHAR2_TABLE_100
644: , p5_a22 JTF_VARCHAR2_TABLE_100
645: , p5_a23 JTF_NUMBER_TABLE
646: , p5_a24 JTF_NUMBER_TABLE
647: , p5_a25 JTF_VARCHAR2_TABLE_100
648: , p5_a26 JTF_VARCHAR2_TABLE_100
649: , p5_a27 JTF_NUMBER_TABLE
650: , p5_a28 JTF_NUMBER_TABLE
645: , p5_a23 JTF_NUMBER_TABLE
646: , p5_a24 JTF_NUMBER_TABLE
647: , p5_a25 JTF_VARCHAR2_TABLE_100
648: , p5_a26 JTF_VARCHAR2_TABLE_100
649: , p5_a27 JTF_NUMBER_TABLE
650: , p5_a28 JTF_NUMBER_TABLE
651: , p5_a29 JTF_VARCHAR2_TABLE_100
652: , p5_a30 JTF_VARCHAR2_TABLE_100
653: , p5_a31 JTF_VARCHAR2_TABLE_500
646: , p5_a24 JTF_NUMBER_TABLE
647: , p5_a25 JTF_VARCHAR2_TABLE_100
648: , p5_a26 JTF_VARCHAR2_TABLE_100
649: , p5_a27 JTF_NUMBER_TABLE
650: , p5_a28 JTF_NUMBER_TABLE
651: , p5_a29 JTF_VARCHAR2_TABLE_100
652: , p5_a30 JTF_VARCHAR2_TABLE_100
653: , p5_a31 JTF_VARCHAR2_TABLE_500
654: , p5_a32 JTF_VARCHAR2_TABLE_500
664: , p5_a42 JTF_VARCHAR2_TABLE_500
665: , p5_a43 JTF_VARCHAR2_TABLE_100
666: , p5_a44 JTF_VARCHAR2_TABLE_500
667: , p5_a45 JTF_VARCHAR2_TABLE_500
668: , p5_a46 JTF_NUMBER_TABLE
669: , p5_a47 JTF_DATE_TABLE
670: , p5_a48 JTF_NUMBER_TABLE
671: , p5_a49 JTF_DATE_TABLE
672: , p5_a50 JTF_NUMBER_TABLE
666: , p5_a44 JTF_VARCHAR2_TABLE_500
667: , p5_a45 JTF_VARCHAR2_TABLE_500
668: , p5_a46 JTF_NUMBER_TABLE
669: , p5_a47 JTF_DATE_TABLE
670: , p5_a48 JTF_NUMBER_TABLE
671: , p5_a49 JTF_DATE_TABLE
672: , p5_a50 JTF_NUMBER_TABLE
673: , p5_a51 JTF_NUMBER_TABLE
674: );
668: , p5_a46 JTF_NUMBER_TABLE
669: , p5_a47 JTF_DATE_TABLE
670: , p5_a48 JTF_NUMBER_TABLE
671: , p5_a49 JTF_DATE_TABLE
672: , p5_a50 JTF_NUMBER_TABLE
673: , p5_a51 JTF_NUMBER_TABLE
674: );
675: procedure validate_subsidy(p_api_version NUMBER
676: , p_init_msg_list VARCHAR2
669: , p5_a47 JTF_DATE_TABLE
670: , p5_a48 JTF_NUMBER_TABLE
671: , p5_a49 JTF_DATE_TABLE
672: , p5_a50 JTF_NUMBER_TABLE
673: , p5_a51 JTF_NUMBER_TABLE
674: );
675: procedure validate_subsidy(p_api_version NUMBER
676: , p_init_msg_list VARCHAR2
677: , x_return_status out nocopy VARCHAR2
734: , p_init_msg_list VARCHAR2
735: , x_return_status out nocopy VARCHAR2
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_NUMBER_TABLE
742: , p5_a4 JTF_VARCHAR2_TABLE_100
735: , x_return_status out nocopy VARCHAR2
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_NUMBER_TABLE
742: , p5_a4 JTF_VARCHAR2_TABLE_100
743: , p5_a5 JTF_VARCHAR2_TABLE_200
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_NUMBER_TABLE
742: , p5_a4 JTF_VARCHAR2_TABLE_100
743: , p5_a5 JTF_VARCHAR2_TABLE_200
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_DATE_TABLE
743: , p5_a5 JTF_VARCHAR2_TABLE_200
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_DATE_TABLE
746: , p5_a8 JTF_DATE_TABLE
747: , p5_a9 JTF_NUMBER_TABLE
748: , p5_a10 JTF_VARCHAR2_TABLE_100
749: , p5_a11 JTF_VARCHAR2_TABLE_100
750: , p5_a12 JTF_VARCHAR2_TABLE_100
751: , p5_a13 JTF_VARCHAR2_TABLE_100
748: , p5_a10 JTF_VARCHAR2_TABLE_100
749: , p5_a11 JTF_VARCHAR2_TABLE_100
750: , p5_a12 JTF_VARCHAR2_TABLE_100
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_NUMBER_TABLE
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
749: , p5_a11 JTF_VARCHAR2_TABLE_100
750: , p5_a12 JTF_VARCHAR2_TABLE_100
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_NUMBER_TABLE
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
750: , p5_a12 JTF_VARCHAR2_TABLE_100
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_NUMBER_TABLE
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_NUMBER_TABLE
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
759: , p5_a21 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_NUMBER_TABLE
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
759: , p5_a21 JTF_VARCHAR2_TABLE_100
760: , p5_a22 JTF_VARCHAR2_TABLE_100
753: , p5_a15 JTF_NUMBER_TABLE
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_NUMBER_TABLE
756: , p5_a18 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
759: , p5_a21 JTF_VARCHAR2_TABLE_100
760: , p5_a22 JTF_VARCHAR2_TABLE_100
761: , p5_a23 JTF_NUMBER_TABLE
757: , p5_a19 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
759: , p5_a21 JTF_VARCHAR2_TABLE_100
760: , p5_a22 JTF_VARCHAR2_TABLE_100
761: , p5_a23 JTF_NUMBER_TABLE
762: , p5_a24 JTF_NUMBER_TABLE
763: , p5_a25 JTF_VARCHAR2_TABLE_100
764: , p5_a26 JTF_VARCHAR2_TABLE_100
765: , p5_a27 JTF_NUMBER_TABLE
758: , p5_a20 JTF_VARCHAR2_TABLE_100
759: , p5_a21 JTF_VARCHAR2_TABLE_100
760: , p5_a22 JTF_VARCHAR2_TABLE_100
761: , p5_a23 JTF_NUMBER_TABLE
762: , p5_a24 JTF_NUMBER_TABLE
763: , p5_a25 JTF_VARCHAR2_TABLE_100
764: , p5_a26 JTF_VARCHAR2_TABLE_100
765: , p5_a27 JTF_NUMBER_TABLE
766: , p5_a28 JTF_NUMBER_TABLE
761: , p5_a23 JTF_NUMBER_TABLE
762: , p5_a24 JTF_NUMBER_TABLE
763: , p5_a25 JTF_VARCHAR2_TABLE_100
764: , p5_a26 JTF_VARCHAR2_TABLE_100
765: , p5_a27 JTF_NUMBER_TABLE
766: , p5_a28 JTF_NUMBER_TABLE
767: , p5_a29 JTF_VARCHAR2_TABLE_100
768: , p5_a30 JTF_VARCHAR2_TABLE_100
769: , p5_a31 JTF_VARCHAR2_TABLE_500
762: , p5_a24 JTF_NUMBER_TABLE
763: , p5_a25 JTF_VARCHAR2_TABLE_100
764: , p5_a26 JTF_VARCHAR2_TABLE_100
765: , p5_a27 JTF_NUMBER_TABLE
766: , p5_a28 JTF_NUMBER_TABLE
767: , p5_a29 JTF_VARCHAR2_TABLE_100
768: , p5_a30 JTF_VARCHAR2_TABLE_100
769: , p5_a31 JTF_VARCHAR2_TABLE_500
770: , p5_a32 JTF_VARCHAR2_TABLE_500
780: , p5_a42 JTF_VARCHAR2_TABLE_500
781: , p5_a43 JTF_VARCHAR2_TABLE_100
782: , p5_a44 JTF_VARCHAR2_TABLE_500
783: , p5_a45 JTF_VARCHAR2_TABLE_500
784: , p5_a46 JTF_NUMBER_TABLE
785: , p5_a47 JTF_DATE_TABLE
786: , p5_a48 JTF_NUMBER_TABLE
787: , p5_a49 JTF_DATE_TABLE
788: , p5_a50 JTF_NUMBER_TABLE
782: , p5_a44 JTF_VARCHAR2_TABLE_500
783: , p5_a45 JTF_VARCHAR2_TABLE_500
784: , p5_a46 JTF_NUMBER_TABLE
785: , p5_a47 JTF_DATE_TABLE
786: , p5_a48 JTF_NUMBER_TABLE
787: , p5_a49 JTF_DATE_TABLE
788: , p5_a50 JTF_NUMBER_TABLE
789: , p5_a51 JTF_NUMBER_TABLE
790: );
784: , p5_a46 JTF_NUMBER_TABLE
785: , p5_a47 JTF_DATE_TABLE
786: , p5_a48 JTF_NUMBER_TABLE
787: , p5_a49 JTF_DATE_TABLE
788: , p5_a50 JTF_NUMBER_TABLE
789: , p5_a51 JTF_NUMBER_TABLE
790: );
791: procedure create_subsidy_criteria(p_api_version NUMBER
792: , p_init_msg_list VARCHAR2
785: , p5_a47 JTF_DATE_TABLE
786: , p5_a48 JTF_NUMBER_TABLE
787: , p5_a49 JTF_DATE_TABLE
788: , p5_a50 JTF_NUMBER_TABLE
789: , p5_a51 JTF_NUMBER_TABLE
790: );
791: procedure create_subsidy_criteria(p_api_version NUMBER
792: , p_init_msg_list VARCHAR2
793: , x_return_status out nocopy VARCHAR2
866: , p_init_msg_list VARCHAR2
867: , x_return_status out nocopy VARCHAR2
868: , x_msg_count out nocopy NUMBER
869: , x_msg_data out nocopy VARCHAR2
870: , p5_a0 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
867: , x_return_status out nocopy VARCHAR2
868: , x_msg_count out nocopy NUMBER
869: , x_msg_data out nocopy VARCHAR2
870: , p5_a0 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
868: , x_msg_count out nocopy NUMBER
869: , x_msg_data out nocopy VARCHAR2
870: , p5_a0 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
876: , p5_a6 JTF_VARCHAR2_TABLE_100
869: , x_msg_data out nocopy VARCHAR2
870: , p5_a0 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
876: , p5_a6 JTF_VARCHAR2_TABLE_100
877: , p5_a7 JTF_VARCHAR2_TABLE_100
870: , p5_a0 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
876: , p5_a6 JTF_VARCHAR2_TABLE_100
877: , p5_a7 JTF_VARCHAR2_TABLE_100
878: , p5_a8 JTF_NUMBER_TABLE
871: , p5_a1 JTF_NUMBER_TABLE
872: , p5_a2 JTF_NUMBER_TABLE
873: , p5_a3 JTF_NUMBER_TABLE
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
876: , p5_a6 JTF_VARCHAR2_TABLE_100
877: , p5_a7 JTF_VARCHAR2_TABLE_100
878: , p5_a8 JTF_NUMBER_TABLE
879: , p5_a9 JTF_VARCHAR2_TABLE_100
874: , p5_a4 JTF_NUMBER_TABLE
875: , p5_a5 JTF_NUMBER_TABLE
876: , p5_a6 JTF_VARCHAR2_TABLE_100
877: , p5_a7 JTF_VARCHAR2_TABLE_100
878: , p5_a8 JTF_NUMBER_TABLE
879: , p5_a9 JTF_VARCHAR2_TABLE_100
880: , p5_a10 JTF_VARCHAR2_TABLE_100
881: , p5_a11 JTF_NUMBER_TABLE
882: , p5_a12 JTF_NUMBER_TABLE
877: , p5_a7 JTF_VARCHAR2_TABLE_100
878: , p5_a8 JTF_NUMBER_TABLE
879: , p5_a9 JTF_VARCHAR2_TABLE_100
880: , p5_a10 JTF_VARCHAR2_TABLE_100
881: , p5_a11 JTF_NUMBER_TABLE
882: , p5_a12 JTF_NUMBER_TABLE
883: , p5_a13 JTF_VARCHAR2_TABLE_100
884: , p5_a14 JTF_VARCHAR2_TABLE_500
885: , p5_a15 JTF_VARCHAR2_TABLE_500
878: , p5_a8 JTF_NUMBER_TABLE
879: , p5_a9 JTF_VARCHAR2_TABLE_100
880: , p5_a10 JTF_VARCHAR2_TABLE_100
881: , p5_a11 JTF_NUMBER_TABLE
882: , p5_a12 JTF_NUMBER_TABLE
883: , p5_a13 JTF_VARCHAR2_TABLE_100
884: , p5_a14 JTF_VARCHAR2_TABLE_500
885: , p5_a15 JTF_VARCHAR2_TABLE_500
886: , p5_a16 JTF_VARCHAR2_TABLE_500
895: , p5_a25 JTF_VARCHAR2_TABLE_500
896: , p5_a26 JTF_VARCHAR2_TABLE_500
897: , p5_a27 JTF_VARCHAR2_TABLE_500
898: , p5_a28 JTF_VARCHAR2_TABLE_500
899: , p5_a29 JTF_NUMBER_TABLE
900: , p5_a30 JTF_DATE_TABLE
901: , p5_a31 JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
897: , p5_a27 JTF_VARCHAR2_TABLE_500
898: , p5_a28 JTF_VARCHAR2_TABLE_500
899: , p5_a29 JTF_NUMBER_TABLE
900: , p5_a30 JTF_DATE_TABLE
901: , p5_a31 JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
899: , p5_a29 JTF_NUMBER_TABLE
900: , p5_a30 JTF_DATE_TABLE
901: , p5_a31 JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
900: , p5_a30 JTF_DATE_TABLE
901: , p5_a31 JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
901: , p5_a31 JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
902: , p5_a32 JTF_DATE_TABLE
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
903: , p5_a33 JTF_NUMBER_TABLE
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
904: , p6_a0 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
912: , p6_a8 out nocopy JTF_NUMBER_TABLE
905: , p6_a1 out nocopy JTF_NUMBER_TABLE
906: , p6_a2 out nocopy JTF_NUMBER_TABLE
907: , p6_a3 out nocopy JTF_NUMBER_TABLE
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
912: , p6_a8 out nocopy JTF_NUMBER_TABLE
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
908: , p6_a4 out nocopy JTF_NUMBER_TABLE
909: , p6_a5 out nocopy JTF_NUMBER_TABLE
910: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
912: , p6_a8 out nocopy JTF_NUMBER_TABLE
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_NUMBER_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
912: , p6_a8 out nocopy JTF_NUMBER_TABLE
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_NUMBER_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
912: , p6_a8 out nocopy JTF_NUMBER_TABLE
913: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
914: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a11 out nocopy JTF_NUMBER_TABLE
916: , p6_a12 out nocopy JTF_NUMBER_TABLE
917: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
918: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
919: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
920: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
929: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
930: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
931: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
933: , p6_a29 out nocopy JTF_NUMBER_TABLE
934: , p6_a30 out nocopy JTF_DATE_TABLE
935: , p6_a31 out nocopy JTF_NUMBER_TABLE
936: , p6_a32 out nocopy JTF_DATE_TABLE
937: , p6_a33 out nocopy JTF_NUMBER_TABLE
931: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
933: , p6_a29 out nocopy JTF_NUMBER_TABLE
934: , p6_a30 out nocopy JTF_DATE_TABLE
935: , p6_a31 out nocopy JTF_NUMBER_TABLE
936: , p6_a32 out nocopy JTF_DATE_TABLE
937: , p6_a33 out nocopy JTF_NUMBER_TABLE
938: );
939: procedure update_subsidy_criteria(p_api_version NUMBER
933: , p6_a29 out nocopy JTF_NUMBER_TABLE
934: , p6_a30 out nocopy JTF_DATE_TABLE
935: , p6_a31 out nocopy JTF_NUMBER_TABLE
936: , p6_a32 out nocopy JTF_DATE_TABLE
937: , p6_a33 out nocopy JTF_NUMBER_TABLE
938: );
939: procedure update_subsidy_criteria(p_api_version NUMBER
940: , p_init_msg_list VARCHAR2
941: , x_return_status out nocopy VARCHAR2
1014: , p_init_msg_list VARCHAR2
1015: , x_return_status out nocopy VARCHAR2
1016: , x_msg_count out nocopy NUMBER
1017: , x_msg_data out nocopy VARCHAR2
1018: , p5_a0 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1015: , x_return_status out nocopy VARCHAR2
1016: , x_msg_count out nocopy NUMBER
1017: , x_msg_data out nocopy VARCHAR2
1018: , p5_a0 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1016: , x_msg_count out nocopy NUMBER
1017: , x_msg_data out nocopy VARCHAR2
1018: , p5_a0 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1024: , p5_a6 JTF_VARCHAR2_TABLE_100
1017: , x_msg_data out nocopy VARCHAR2
1018: , p5_a0 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1024: , p5_a6 JTF_VARCHAR2_TABLE_100
1025: , p5_a7 JTF_VARCHAR2_TABLE_100
1018: , p5_a0 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1024: , p5_a6 JTF_VARCHAR2_TABLE_100
1025: , p5_a7 JTF_VARCHAR2_TABLE_100
1026: , p5_a8 JTF_NUMBER_TABLE
1019: , p5_a1 JTF_NUMBER_TABLE
1020: , p5_a2 JTF_NUMBER_TABLE
1021: , p5_a3 JTF_NUMBER_TABLE
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1024: , p5_a6 JTF_VARCHAR2_TABLE_100
1025: , p5_a7 JTF_VARCHAR2_TABLE_100
1026: , p5_a8 JTF_NUMBER_TABLE
1027: , p5_a9 JTF_VARCHAR2_TABLE_100
1022: , p5_a4 JTF_NUMBER_TABLE
1023: , p5_a5 JTF_NUMBER_TABLE
1024: , p5_a6 JTF_VARCHAR2_TABLE_100
1025: , p5_a7 JTF_VARCHAR2_TABLE_100
1026: , p5_a8 JTF_NUMBER_TABLE
1027: , p5_a9 JTF_VARCHAR2_TABLE_100
1028: , p5_a10 JTF_VARCHAR2_TABLE_100
1029: , p5_a11 JTF_NUMBER_TABLE
1030: , p5_a12 JTF_NUMBER_TABLE
1025: , p5_a7 JTF_VARCHAR2_TABLE_100
1026: , p5_a8 JTF_NUMBER_TABLE
1027: , p5_a9 JTF_VARCHAR2_TABLE_100
1028: , p5_a10 JTF_VARCHAR2_TABLE_100
1029: , p5_a11 JTF_NUMBER_TABLE
1030: , p5_a12 JTF_NUMBER_TABLE
1031: , p5_a13 JTF_VARCHAR2_TABLE_100
1032: , p5_a14 JTF_VARCHAR2_TABLE_500
1033: , p5_a15 JTF_VARCHAR2_TABLE_500
1026: , p5_a8 JTF_NUMBER_TABLE
1027: , p5_a9 JTF_VARCHAR2_TABLE_100
1028: , p5_a10 JTF_VARCHAR2_TABLE_100
1029: , p5_a11 JTF_NUMBER_TABLE
1030: , p5_a12 JTF_NUMBER_TABLE
1031: , p5_a13 JTF_VARCHAR2_TABLE_100
1032: , p5_a14 JTF_VARCHAR2_TABLE_500
1033: , p5_a15 JTF_VARCHAR2_TABLE_500
1034: , p5_a16 JTF_VARCHAR2_TABLE_500
1043: , p5_a25 JTF_VARCHAR2_TABLE_500
1044: , p5_a26 JTF_VARCHAR2_TABLE_500
1045: , p5_a27 JTF_VARCHAR2_TABLE_500
1046: , p5_a28 JTF_VARCHAR2_TABLE_500
1047: , p5_a29 JTF_NUMBER_TABLE
1048: , p5_a30 JTF_DATE_TABLE
1049: , p5_a31 JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1045: , p5_a27 JTF_VARCHAR2_TABLE_500
1046: , p5_a28 JTF_VARCHAR2_TABLE_500
1047: , p5_a29 JTF_NUMBER_TABLE
1048: , p5_a30 JTF_DATE_TABLE
1049: , p5_a31 JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1047: , p5_a29 JTF_NUMBER_TABLE
1048: , p5_a30 JTF_DATE_TABLE
1049: , p5_a31 JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1048: , p5_a30 JTF_DATE_TABLE
1049: , p5_a31 JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1049: , p5_a31 JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1050: , p5_a32 JTF_DATE_TABLE
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1058: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1051: , p5_a33 JTF_NUMBER_TABLE
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1058: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p6_a0 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1058: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE
1053: , p6_a1 out nocopy JTF_NUMBER_TABLE
1054: , p6_a2 out nocopy JTF_NUMBER_TABLE
1055: , p6_a3 out nocopy JTF_NUMBER_TABLE
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1058: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE
1061: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1056: , p6_a4 out nocopy JTF_NUMBER_TABLE
1057: , p6_a5 out nocopy JTF_NUMBER_TABLE
1058: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE
1061: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1062: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a11 out nocopy JTF_NUMBER_TABLE
1064: , p6_a12 out nocopy JTF_NUMBER_TABLE
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE
1061: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1062: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a11 out nocopy JTF_NUMBER_TABLE
1064: , p6_a12 out nocopy JTF_NUMBER_TABLE
1065: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1066: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1067: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE
1061: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1062: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1063: , p6_a11 out nocopy JTF_NUMBER_TABLE
1064: , p6_a12 out nocopy JTF_NUMBER_TABLE
1065: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1066: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1067: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1068: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1077: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1078: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1079: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1080: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1081: , p6_a29 out nocopy JTF_NUMBER_TABLE
1082: , p6_a30 out nocopy JTF_DATE_TABLE
1083: , p6_a31 out nocopy JTF_NUMBER_TABLE
1084: , p6_a32 out nocopy JTF_DATE_TABLE
1085: , p6_a33 out nocopy JTF_NUMBER_TABLE
1079: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1080: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1081: , p6_a29 out nocopy JTF_NUMBER_TABLE
1082: , p6_a30 out nocopy JTF_DATE_TABLE
1083: , p6_a31 out nocopy JTF_NUMBER_TABLE
1084: , p6_a32 out nocopy JTF_DATE_TABLE
1085: , p6_a33 out nocopy JTF_NUMBER_TABLE
1086: );
1087: procedure delete_subsidy_criteria(p_api_version NUMBER
1081: , p6_a29 out nocopy JTF_NUMBER_TABLE
1082: , p6_a30 out nocopy JTF_DATE_TABLE
1083: , p6_a31 out nocopy JTF_NUMBER_TABLE
1084: , p6_a32 out nocopy JTF_DATE_TABLE
1085: , p6_a33 out nocopy JTF_NUMBER_TABLE
1086: );
1087: procedure delete_subsidy_criteria(p_api_version NUMBER
1088: , p_init_msg_list VARCHAR2
1089: , x_return_status out nocopy VARCHAR2
1128: , p_init_msg_list VARCHAR2
1129: , x_return_status out nocopy VARCHAR2
1130: , x_msg_count out nocopy NUMBER
1131: , x_msg_data out nocopy VARCHAR2
1132: , p5_a0 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1129: , x_return_status out nocopy VARCHAR2
1130: , x_msg_count out nocopy NUMBER
1131: , x_msg_data out nocopy VARCHAR2
1132: , p5_a0 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1130: , x_msg_count out nocopy NUMBER
1131: , x_msg_data out nocopy VARCHAR2
1132: , p5_a0 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1138: , p5_a6 JTF_VARCHAR2_TABLE_100
1131: , x_msg_data out nocopy VARCHAR2
1132: , p5_a0 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1138: , p5_a6 JTF_VARCHAR2_TABLE_100
1139: , p5_a7 JTF_VARCHAR2_TABLE_100
1132: , p5_a0 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1138: , p5_a6 JTF_VARCHAR2_TABLE_100
1139: , p5_a7 JTF_VARCHAR2_TABLE_100
1140: , p5_a8 JTF_NUMBER_TABLE
1133: , p5_a1 JTF_NUMBER_TABLE
1134: , p5_a2 JTF_NUMBER_TABLE
1135: , p5_a3 JTF_NUMBER_TABLE
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1138: , p5_a6 JTF_VARCHAR2_TABLE_100
1139: , p5_a7 JTF_VARCHAR2_TABLE_100
1140: , p5_a8 JTF_NUMBER_TABLE
1141: , p5_a9 JTF_VARCHAR2_TABLE_100
1136: , p5_a4 JTF_NUMBER_TABLE
1137: , p5_a5 JTF_NUMBER_TABLE
1138: , p5_a6 JTF_VARCHAR2_TABLE_100
1139: , p5_a7 JTF_VARCHAR2_TABLE_100
1140: , p5_a8 JTF_NUMBER_TABLE
1141: , p5_a9 JTF_VARCHAR2_TABLE_100
1142: , p5_a10 JTF_VARCHAR2_TABLE_100
1143: , p5_a11 JTF_NUMBER_TABLE
1144: , p5_a12 JTF_NUMBER_TABLE
1139: , p5_a7 JTF_VARCHAR2_TABLE_100
1140: , p5_a8 JTF_NUMBER_TABLE
1141: , p5_a9 JTF_VARCHAR2_TABLE_100
1142: , p5_a10 JTF_VARCHAR2_TABLE_100
1143: , p5_a11 JTF_NUMBER_TABLE
1144: , p5_a12 JTF_NUMBER_TABLE
1145: , p5_a13 JTF_VARCHAR2_TABLE_100
1146: , p5_a14 JTF_VARCHAR2_TABLE_500
1147: , p5_a15 JTF_VARCHAR2_TABLE_500
1140: , p5_a8 JTF_NUMBER_TABLE
1141: , p5_a9 JTF_VARCHAR2_TABLE_100
1142: , p5_a10 JTF_VARCHAR2_TABLE_100
1143: , p5_a11 JTF_NUMBER_TABLE
1144: , p5_a12 JTF_NUMBER_TABLE
1145: , p5_a13 JTF_VARCHAR2_TABLE_100
1146: , p5_a14 JTF_VARCHAR2_TABLE_500
1147: , p5_a15 JTF_VARCHAR2_TABLE_500
1148: , p5_a16 JTF_VARCHAR2_TABLE_500
1157: , p5_a25 JTF_VARCHAR2_TABLE_500
1158: , p5_a26 JTF_VARCHAR2_TABLE_500
1159: , p5_a27 JTF_VARCHAR2_TABLE_500
1160: , p5_a28 JTF_VARCHAR2_TABLE_500
1161: , p5_a29 JTF_NUMBER_TABLE
1162: , p5_a30 JTF_DATE_TABLE
1163: , p5_a31 JTF_NUMBER_TABLE
1164: , p5_a32 JTF_DATE_TABLE
1165: , p5_a33 JTF_NUMBER_TABLE
1159: , p5_a27 JTF_VARCHAR2_TABLE_500
1160: , p5_a28 JTF_VARCHAR2_TABLE_500
1161: , p5_a29 JTF_NUMBER_TABLE
1162: , p5_a30 JTF_DATE_TABLE
1163: , p5_a31 JTF_NUMBER_TABLE
1164: , p5_a32 JTF_DATE_TABLE
1165: , p5_a33 JTF_NUMBER_TABLE
1166: );
1167: procedure lock_subsidy_criteria(p_api_version NUMBER
1161: , p5_a29 JTF_NUMBER_TABLE
1162: , p5_a30 JTF_DATE_TABLE
1163: , p5_a31 JTF_NUMBER_TABLE
1164: , p5_a32 JTF_DATE_TABLE
1165: , p5_a33 JTF_NUMBER_TABLE
1166: );
1167: procedure lock_subsidy_criteria(p_api_version NUMBER
1168: , p_init_msg_list VARCHAR2
1169: , x_return_status out nocopy VARCHAR2
1208: , p_init_msg_list VARCHAR2
1209: , x_return_status out nocopy VARCHAR2
1210: , x_msg_count out nocopy NUMBER
1211: , x_msg_data out nocopy VARCHAR2
1212: , p5_a0 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1209: , x_return_status out nocopy VARCHAR2
1210: , x_msg_count out nocopy NUMBER
1211: , x_msg_data out nocopy VARCHAR2
1212: , p5_a0 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1210: , x_msg_count out nocopy NUMBER
1211: , x_msg_data out nocopy VARCHAR2
1212: , p5_a0 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1218: , p5_a6 JTF_VARCHAR2_TABLE_100
1211: , x_msg_data out nocopy VARCHAR2
1212: , p5_a0 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1218: , p5_a6 JTF_VARCHAR2_TABLE_100
1219: , p5_a7 JTF_VARCHAR2_TABLE_100
1212: , p5_a0 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1218: , p5_a6 JTF_VARCHAR2_TABLE_100
1219: , p5_a7 JTF_VARCHAR2_TABLE_100
1220: , p5_a8 JTF_NUMBER_TABLE
1213: , p5_a1 JTF_NUMBER_TABLE
1214: , p5_a2 JTF_NUMBER_TABLE
1215: , p5_a3 JTF_NUMBER_TABLE
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1218: , p5_a6 JTF_VARCHAR2_TABLE_100
1219: , p5_a7 JTF_VARCHAR2_TABLE_100
1220: , p5_a8 JTF_NUMBER_TABLE
1221: , p5_a9 JTF_VARCHAR2_TABLE_100
1216: , p5_a4 JTF_NUMBER_TABLE
1217: , p5_a5 JTF_NUMBER_TABLE
1218: , p5_a6 JTF_VARCHAR2_TABLE_100
1219: , p5_a7 JTF_VARCHAR2_TABLE_100
1220: , p5_a8 JTF_NUMBER_TABLE
1221: , p5_a9 JTF_VARCHAR2_TABLE_100
1222: , p5_a10 JTF_VARCHAR2_TABLE_100
1223: , p5_a11 JTF_NUMBER_TABLE
1224: , p5_a12 JTF_NUMBER_TABLE
1219: , p5_a7 JTF_VARCHAR2_TABLE_100
1220: , p5_a8 JTF_NUMBER_TABLE
1221: , p5_a9 JTF_VARCHAR2_TABLE_100
1222: , p5_a10 JTF_VARCHAR2_TABLE_100
1223: , p5_a11 JTF_NUMBER_TABLE
1224: , p5_a12 JTF_NUMBER_TABLE
1225: , p5_a13 JTF_VARCHAR2_TABLE_100
1226: , p5_a14 JTF_VARCHAR2_TABLE_500
1227: , p5_a15 JTF_VARCHAR2_TABLE_500
1220: , p5_a8 JTF_NUMBER_TABLE
1221: , p5_a9 JTF_VARCHAR2_TABLE_100
1222: , p5_a10 JTF_VARCHAR2_TABLE_100
1223: , p5_a11 JTF_NUMBER_TABLE
1224: , p5_a12 JTF_NUMBER_TABLE
1225: , p5_a13 JTF_VARCHAR2_TABLE_100
1226: , p5_a14 JTF_VARCHAR2_TABLE_500
1227: , p5_a15 JTF_VARCHAR2_TABLE_500
1228: , p5_a16 JTF_VARCHAR2_TABLE_500
1237: , p5_a25 JTF_VARCHAR2_TABLE_500
1238: , p5_a26 JTF_VARCHAR2_TABLE_500
1239: , p5_a27 JTF_VARCHAR2_TABLE_500
1240: , p5_a28 JTF_VARCHAR2_TABLE_500
1241: , p5_a29 JTF_NUMBER_TABLE
1242: , p5_a30 JTF_DATE_TABLE
1243: , p5_a31 JTF_NUMBER_TABLE
1244: , p5_a32 JTF_DATE_TABLE
1245: , p5_a33 JTF_NUMBER_TABLE
1239: , p5_a27 JTF_VARCHAR2_TABLE_500
1240: , p5_a28 JTF_VARCHAR2_TABLE_500
1241: , p5_a29 JTF_NUMBER_TABLE
1242: , p5_a30 JTF_DATE_TABLE
1243: , p5_a31 JTF_NUMBER_TABLE
1244: , p5_a32 JTF_DATE_TABLE
1245: , p5_a33 JTF_NUMBER_TABLE
1246: );
1247: procedure validate_subsidy_criteria(p_api_version NUMBER
1241: , p5_a29 JTF_NUMBER_TABLE
1242: , p5_a30 JTF_DATE_TABLE
1243: , p5_a31 JTF_NUMBER_TABLE
1244: , p5_a32 JTF_DATE_TABLE
1245: , p5_a33 JTF_NUMBER_TABLE
1246: );
1247: procedure validate_subsidy_criteria(p_api_version NUMBER
1248: , p_init_msg_list VARCHAR2
1249: , x_return_status out nocopy VARCHAR2
1288: , p_init_msg_list VARCHAR2
1289: , x_return_status out nocopy VARCHAR2
1290: , x_msg_count out nocopy NUMBER
1291: , x_msg_data out nocopy VARCHAR2
1292: , p5_a0 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1289: , x_return_status out nocopy VARCHAR2
1290: , x_msg_count out nocopy NUMBER
1291: , x_msg_data out nocopy VARCHAR2
1292: , p5_a0 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1290: , x_msg_count out nocopy NUMBER
1291: , x_msg_data out nocopy VARCHAR2
1292: , p5_a0 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1298: , p5_a6 JTF_VARCHAR2_TABLE_100
1291: , x_msg_data out nocopy VARCHAR2
1292: , p5_a0 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1298: , p5_a6 JTF_VARCHAR2_TABLE_100
1299: , p5_a7 JTF_VARCHAR2_TABLE_100
1292: , p5_a0 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1298: , p5_a6 JTF_VARCHAR2_TABLE_100
1299: , p5_a7 JTF_VARCHAR2_TABLE_100
1300: , p5_a8 JTF_NUMBER_TABLE
1293: , p5_a1 JTF_NUMBER_TABLE
1294: , p5_a2 JTF_NUMBER_TABLE
1295: , p5_a3 JTF_NUMBER_TABLE
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1298: , p5_a6 JTF_VARCHAR2_TABLE_100
1299: , p5_a7 JTF_VARCHAR2_TABLE_100
1300: , p5_a8 JTF_NUMBER_TABLE
1301: , p5_a9 JTF_VARCHAR2_TABLE_100
1296: , p5_a4 JTF_NUMBER_TABLE
1297: , p5_a5 JTF_NUMBER_TABLE
1298: , p5_a6 JTF_VARCHAR2_TABLE_100
1299: , p5_a7 JTF_VARCHAR2_TABLE_100
1300: , p5_a8 JTF_NUMBER_TABLE
1301: , p5_a9 JTF_VARCHAR2_TABLE_100
1302: , p5_a10 JTF_VARCHAR2_TABLE_100
1303: , p5_a11 JTF_NUMBER_TABLE
1304: , p5_a12 JTF_NUMBER_TABLE
1299: , p5_a7 JTF_VARCHAR2_TABLE_100
1300: , p5_a8 JTF_NUMBER_TABLE
1301: , p5_a9 JTF_VARCHAR2_TABLE_100
1302: , p5_a10 JTF_VARCHAR2_TABLE_100
1303: , p5_a11 JTF_NUMBER_TABLE
1304: , p5_a12 JTF_NUMBER_TABLE
1305: , p5_a13 JTF_VARCHAR2_TABLE_100
1306: , p5_a14 JTF_VARCHAR2_TABLE_500
1307: , p5_a15 JTF_VARCHAR2_TABLE_500
1300: , p5_a8 JTF_NUMBER_TABLE
1301: , p5_a9 JTF_VARCHAR2_TABLE_100
1302: , p5_a10 JTF_VARCHAR2_TABLE_100
1303: , p5_a11 JTF_NUMBER_TABLE
1304: , p5_a12 JTF_NUMBER_TABLE
1305: , p5_a13 JTF_VARCHAR2_TABLE_100
1306: , p5_a14 JTF_VARCHAR2_TABLE_500
1307: , p5_a15 JTF_VARCHAR2_TABLE_500
1308: , p5_a16 JTF_VARCHAR2_TABLE_500
1317: , p5_a25 JTF_VARCHAR2_TABLE_500
1318: , p5_a26 JTF_VARCHAR2_TABLE_500
1319: , p5_a27 JTF_VARCHAR2_TABLE_500
1320: , p5_a28 JTF_VARCHAR2_TABLE_500
1321: , p5_a29 JTF_NUMBER_TABLE
1322: , p5_a30 JTF_DATE_TABLE
1323: , p5_a31 JTF_NUMBER_TABLE
1324: , p5_a32 JTF_DATE_TABLE
1325: , p5_a33 JTF_NUMBER_TABLE
1319: , p5_a27 JTF_VARCHAR2_TABLE_500
1320: , p5_a28 JTF_VARCHAR2_TABLE_500
1321: , p5_a29 JTF_NUMBER_TABLE
1322: , p5_a30 JTF_DATE_TABLE
1323: , p5_a31 JTF_NUMBER_TABLE
1324: , p5_a32 JTF_DATE_TABLE
1325: , p5_a33 JTF_NUMBER_TABLE
1326: );
1327: end okl_subsidy_pub_w;
1321: , p5_a29 JTF_NUMBER_TABLE
1322: , p5_a30 JTF_DATE_TABLE
1323: , p5_a31 JTF_NUMBER_TABLE
1324: , p5_a32 JTF_DATE_TABLE
1325: , p5_a33 JTF_NUMBER_TABLE
1326: );
1327: end okl_subsidy_pub_w;