DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PUB_W dependencies on JTF_NUMBER_TABLE

Line 118: , p5_a0 JTF_NUMBER_TABLE

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

Line 119: , p5_a1 JTF_NUMBER_TABLE

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

Line 121: , p5_a3 JTF_NUMBER_TABLE

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

Line 127: , p5_a9 JTF_NUMBER_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

Line 132: , p5_a14 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
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

Line 133: , p5_a15 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

Line 134: , p5_a16 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

Line 135: , p5_a17 JTF_NUMBER_TABLE

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

Line 136: , p5_a18 JTF_NUMBER_TABLE

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

Line 137: , p5_a19 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
141: , p5_a23 JTF_NUMBER_TABLE

Line 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

Line 142: , p5_a24 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

Line 145: , p5_a27 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

Line 146: , p5_a28 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
150: , p5_a32 JTF_VARCHAR2_TABLE_500

Line 164: , p5_a46 JTF_NUMBER_TABLE

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

Line 166: , p5_a48 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

Line 168: , p5_a50 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

Line 169: , p5_a51 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
173: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 170: , p6_a0 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

Line 171: , p6_a1 out nocopy 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
175: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 173: , p6_a3 out nocopy 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
176: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
177: , p6_a7 out nocopy JTF_DATE_TABLE

Line 179: , p6_a9 out nocopy JTF_NUMBER_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

Line 184: , p6_a14 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
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

Line 185: , p6_a15 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

Line 186: , p6_a16 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

Line 187: , p6_a17 out nocopy JTF_NUMBER_TABLE

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

Line 188: , p6_a18 out nocopy JTF_NUMBER_TABLE

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

Line 189: , p6_a19 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
193: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 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

Line 194: , p6_a24 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

Line 197: , p6_a27 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

Line 198: , p6_a28 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
202: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500

Line 216: , p6_a46 out nocopy JTF_NUMBER_TABLE

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

Line 218: , p6_a48 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: );

Line 220: , p6_a50 out nocopy JTF_NUMBER_TABLE

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

Line 221: , p6_a51 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
225: , x_return_status out nocopy VARCHAR2

Line 338: , p5_a0 JTF_NUMBER_TABLE

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

Line 339: , p5_a1 JTF_NUMBER_TABLE

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

Line 341: , p5_a3 JTF_NUMBER_TABLE

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

Line 347: , p5_a9 JTF_NUMBER_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

Line 352: , p5_a14 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
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

Line 353: , p5_a15 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

Line 354: , p5_a16 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

Line 355: , p5_a17 JTF_NUMBER_TABLE

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

Line 356: , p5_a18 JTF_NUMBER_TABLE

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

Line 357: , p5_a19 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
361: , p5_a23 JTF_NUMBER_TABLE

Line 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

Line 362: , p5_a24 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

Line 365: , p5_a27 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

Line 366: , p5_a28 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
370: , p5_a32 JTF_VARCHAR2_TABLE_500

Line 384: , p5_a46 JTF_NUMBER_TABLE

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

Line 386: , p5_a48 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

Line 388: , p5_a50 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

Line 389: , p5_a51 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
393: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 390: , p6_a0 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

Line 391: , p6_a1 out nocopy 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
395: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 393: , p6_a3 out nocopy 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
396: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
397: , p6_a7 out nocopy JTF_DATE_TABLE

Line 399: , p6_a9 out nocopy JTF_NUMBER_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

Line 404: , p6_a14 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
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

Line 405: , p6_a15 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

Line 406: , p6_a16 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

Line 407: , p6_a17 out nocopy JTF_NUMBER_TABLE

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

Line 408: , p6_a18 out nocopy JTF_NUMBER_TABLE

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

Line 409: , p6_a19 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
413: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 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

Line 414: , p6_a24 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

Line 417: , p6_a27 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

Line 418: , p6_a28 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
422: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500

Line 436: , p6_a46 out nocopy JTF_NUMBER_TABLE

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

Line 438: , p6_a48 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: );

Line 440: , p6_a50 out nocopy JTF_NUMBER_TABLE

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

Line 441: , p6_a51 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
445: , x_return_status out nocopy VARCHAR2

Line 506: , p5_a0 JTF_NUMBER_TABLE

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

Line 507: , p5_a1 JTF_NUMBER_TABLE

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

Line 509: , p5_a3 JTF_NUMBER_TABLE

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

Line 515: , p5_a9 JTF_NUMBER_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

Line 520: , p5_a14 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
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

Line 521: , p5_a15 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

Line 522: , p5_a16 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

Line 523: , p5_a17 JTF_NUMBER_TABLE

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

Line 524: , p5_a18 JTF_NUMBER_TABLE

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

Line 525: , p5_a19 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
529: , p5_a23 JTF_NUMBER_TABLE

Line 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

Line 530: , p5_a24 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

Line 533: , p5_a27 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

Line 534: , p5_a28 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
538: , p5_a32 JTF_VARCHAR2_TABLE_500

Line 552: , p5_a46 JTF_NUMBER_TABLE

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

Line 554: , p5_a48 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: );

Line 556: , p5_a50 JTF_NUMBER_TABLE

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

Line 557: , p5_a51 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
561: , x_return_status out nocopy VARCHAR2

Line 622: , p5_a0 JTF_NUMBER_TABLE

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

Line 623: , p5_a1 JTF_NUMBER_TABLE

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

Line 625: , p5_a3 JTF_NUMBER_TABLE

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

Line 631: , p5_a9 JTF_NUMBER_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

Line 636: , p5_a14 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
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

Line 637: , p5_a15 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

Line 638: , p5_a16 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

Line 639: , p5_a17 JTF_NUMBER_TABLE

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

Line 640: , p5_a18 JTF_NUMBER_TABLE

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

Line 641: , p5_a19 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
645: , p5_a23 JTF_NUMBER_TABLE

Line 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

Line 646: , p5_a24 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

Line 649: , p5_a27 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

Line 650: , p5_a28 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
654: , p5_a32 JTF_VARCHAR2_TABLE_500

Line 668: , p5_a46 JTF_NUMBER_TABLE

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

Line 670: , p5_a48 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: );

Line 672: , p5_a50 JTF_NUMBER_TABLE

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

Line 673: , p5_a51 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
677: , x_return_status out nocopy VARCHAR2

Line 738: , p5_a0 JTF_NUMBER_TABLE

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

Line 739: , p5_a1 JTF_NUMBER_TABLE

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

Line 741: , p5_a3 JTF_NUMBER_TABLE

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

Line 747: , p5_a9 JTF_NUMBER_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

Line 752: , p5_a14 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
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

Line 753: , p5_a15 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

Line 754: , p5_a16 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

Line 755: , p5_a17 JTF_NUMBER_TABLE

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

Line 756: , p5_a18 JTF_NUMBER_TABLE

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

Line 757: , p5_a19 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
761: , p5_a23 JTF_NUMBER_TABLE

Line 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

Line 762: , p5_a24 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

Line 765: , p5_a27 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

Line 766: , p5_a28 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
770: , p5_a32 JTF_VARCHAR2_TABLE_500

Line 784: , p5_a46 JTF_NUMBER_TABLE

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

Line 786: , p5_a48 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: );

Line 788: , p5_a50 JTF_NUMBER_TABLE

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

Line 789: , p5_a51 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
793: , x_return_status out nocopy VARCHAR2

Line 870: , p5_a0 JTF_NUMBER_TABLE

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

Line 871: , p5_a1 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

Line 872: , p5_a2 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

Line 873: , p5_a3 JTF_NUMBER_TABLE

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

Line 874: , p5_a4 JTF_NUMBER_TABLE

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

Line 875: , p5_a5 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

Line 878: , p5_a8 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
880: , p5_a10 JTF_VARCHAR2_TABLE_100
881: , p5_a11 JTF_NUMBER_TABLE
882: , p5_a12 JTF_NUMBER_TABLE

Line 881: , p5_a11 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

Line 882: , p5_a12 JTF_NUMBER_TABLE

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

Line 899: , p5_a29 JTF_NUMBER_TABLE

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

Line 901: , p5_a31 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

Line 903: , p5_a33 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

Line 904: , p6_a0 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

Line 905: , p6_a1 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

Line 906: , p6_a2 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

Line 907: , p6_a3 out nocopy JTF_NUMBER_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
911: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 908: , p6_a4 out nocopy 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
912: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 909: , p6_a5 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

Line 912: , p6_a8 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
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

Line 915: , p6_a11 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

Line 916: , p6_a12 out nocopy JTF_NUMBER_TABLE

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

Line 933: , p6_a29 out nocopy JTF_NUMBER_TABLE

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

Line 935: , p6_a31 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

Line 937: , p6_a33 out nocopy JTF_NUMBER_TABLE

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

Line 1018: , p5_a0 JTF_NUMBER_TABLE

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

Line 1019: , p5_a1 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

Line 1020: , p5_a2 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

Line 1021: , p5_a3 JTF_NUMBER_TABLE

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

Line 1022: , p5_a4 JTF_NUMBER_TABLE

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

Line 1023: , p5_a5 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

Line 1026: , p5_a8 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
1028: , p5_a10 JTF_VARCHAR2_TABLE_100
1029: , p5_a11 JTF_NUMBER_TABLE
1030: , p5_a12 JTF_NUMBER_TABLE

Line 1029: , p5_a11 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

Line 1030: , p5_a12 JTF_NUMBER_TABLE

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

Line 1047: , p5_a29 JTF_NUMBER_TABLE

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

Line 1049: , p5_a31 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

Line 1051: , p5_a33 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

Line 1052: , p6_a0 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

Line 1053: , p6_a1 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

Line 1054: , p6_a2 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

Line 1055: , p6_a3 out nocopy JTF_NUMBER_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
1059: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1056: , p6_a4 out nocopy 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
1060: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 1057: , p6_a5 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

Line 1060: , p6_a8 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
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

Line 1063: , p6_a11 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

Line 1064: , p6_a12 out nocopy JTF_NUMBER_TABLE

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

Line 1081: , p6_a29 out nocopy JTF_NUMBER_TABLE

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

Line 1083: , p6_a31 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

Line 1085: , p6_a33 out nocopy JTF_NUMBER_TABLE

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

Line 1132: , p5_a0 JTF_NUMBER_TABLE

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

Line 1133: , p5_a1 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

Line 1134: , p5_a2 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

Line 1135: , p5_a3 JTF_NUMBER_TABLE

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

Line 1136: , p5_a4 JTF_NUMBER_TABLE

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

Line 1137: , p5_a5 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

Line 1140: , p5_a8 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
1142: , p5_a10 JTF_VARCHAR2_TABLE_100
1143: , p5_a11 JTF_NUMBER_TABLE
1144: , p5_a12 JTF_NUMBER_TABLE

Line 1143: , p5_a11 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

Line 1144: , p5_a12 JTF_NUMBER_TABLE

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

Line 1161: , p5_a29 JTF_NUMBER_TABLE

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

Line 1163: , p5_a31 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

Line 1165: , p5_a33 JTF_NUMBER_TABLE

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

Line 1212: , p5_a0 JTF_NUMBER_TABLE

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

Line 1213: , p5_a1 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

Line 1214: , p5_a2 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

Line 1215: , p5_a3 JTF_NUMBER_TABLE

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

Line 1216: , p5_a4 JTF_NUMBER_TABLE

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

Line 1217: , p5_a5 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

Line 1220: , p5_a8 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
1222: , p5_a10 JTF_VARCHAR2_TABLE_100
1223: , p5_a11 JTF_NUMBER_TABLE
1224: , p5_a12 JTF_NUMBER_TABLE

Line 1223: , p5_a11 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

Line 1224: , p5_a12 JTF_NUMBER_TABLE

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

Line 1241: , p5_a29 JTF_NUMBER_TABLE

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

Line 1243: , p5_a31 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

Line 1245: , p5_a33 JTF_NUMBER_TABLE

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

Line 1292: , p5_a0 JTF_NUMBER_TABLE

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

Line 1293: , p5_a1 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

Line 1294: , p5_a2 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

Line 1295: , p5_a3 JTF_NUMBER_TABLE

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

Line 1296: , p5_a4 JTF_NUMBER_TABLE

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

Line 1297: , p5_a5 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

Line 1300: , p5_a8 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
1302: , p5_a10 JTF_VARCHAR2_TABLE_100
1303: , p5_a11 JTF_NUMBER_TABLE
1304: , p5_a12 JTF_NUMBER_TABLE

Line 1303: , p5_a11 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

Line 1304: , p5_a12 JTF_NUMBER_TABLE

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

Line 1321: , p5_a29 JTF_NUMBER_TABLE

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

Line 1323: , p5_a31 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;

Line 1325: , p5_a33 JTF_NUMBER_TABLE

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;