eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_SUBSIDY_RFND_DTLS_PVT_W

Source


1 package okl_subsidy_rfnd_dtls_pvt_w as
2   /* $Header: OKLESRFS.pls 120.3 2005/10/13 22:35:47 manumanu noship $ */
3   procedure create_refund_dtls(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 out nocopy  NUMBER
9     , p6_a1 out nocopy  NUMBER
10     , p6_a2 out nocopy  NUMBER
11     , p6_a3 out nocopy  NUMBER
12     , p6_a4 out nocopy  NUMBER
13     , p6_a5 out nocopy  NUMBER
14     , p6_a6 out nocopy  VARCHAR2
15     , p6_a7 out nocopy  VARCHAR2
16     , p6_a8 out nocopy  NUMBER
17     , p6_a9 out nocopy  DATE
18     , p6_a10 out nocopy  VARCHAR2
19     , p6_a11 out nocopy  NUMBER
20     , p6_a12 out nocopy  VARCHAR2
21     , p6_a13 out nocopy  NUMBER
22     , p6_a14 out nocopy  NUMBER
23     , p6_a15 out nocopy  VARCHAR2
24     , p6_a16 out nocopy  NUMBER
25     , p6_a17 out nocopy  NUMBER
26     , p6_a18 out nocopy  VARCHAR2
27     , p6_a19 out nocopy  VARCHAR2
28     , p6_a20 out nocopy  VARCHAR2
29     , p6_a21 out nocopy  VARCHAR2
30     , p6_a22 out nocopy  VARCHAR2
31     , p6_a23 out nocopy  VARCHAR2
32     , p6_a24 out nocopy  VARCHAR2
33     , p6_a25 out nocopy  VARCHAR2
34     , p6_a26 out nocopy  VARCHAR2
35     , p6_a27 out nocopy  VARCHAR2
36     , p6_a28 out nocopy  VARCHAR2
37     , p6_a29 out nocopy  VARCHAR2
38     , p6_a30 out nocopy  VARCHAR2
39     , p6_a31 out nocopy  VARCHAR2
40     , p6_a32 out nocopy  VARCHAR2
41     , p6_a33 out nocopy  VARCHAR2
42     , p6_a34 out nocopy  VARCHAR2
43     , p6_a35 out nocopy  NUMBER
44     , p6_a36 out nocopy  DATE
45     , p6_a37 out nocopy  NUMBER
46     , p6_a38 out nocopy  DATE
47     , p6_a39 out nocopy  NUMBER
48     , p5_a0  NUMBER := 0-1962.0724
49     , p5_a1  NUMBER := 0-1962.0724
50     , p5_a2  NUMBER := 0-1962.0724
51     , p5_a3  NUMBER := 0-1962.0724
52     , p5_a4  NUMBER := 0-1962.0724
53     , p5_a5  NUMBER := 0-1962.0724
54     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
55     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
56     , p5_a8  NUMBER := 0-1962.0724
57     , p5_a9  DATE := fnd_api.g_miss_date
58     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
59     , p5_a11  NUMBER := 0-1962.0724
60     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
61     , p5_a13  NUMBER := 0-1962.0724
62     , p5_a14  NUMBER := 0-1962.0724
63     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
64     , p5_a16  NUMBER := 0-1962.0724
65     , p5_a17  NUMBER := 0-1962.0724
66     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
67     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
68     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
69     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
70     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
71     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
72     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
73     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
74     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
75     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
76     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
77     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
78     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
79     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
80     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
81     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
82     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
83     , p5_a35  NUMBER := 0-1962.0724
84     , p5_a36  DATE := fnd_api.g_miss_date
85     , p5_a37  NUMBER := 0-1962.0724
86     , p5_a38  DATE := fnd_api.g_miss_date
87     , p5_a39  NUMBER := 0-1962.0724
88   );
89   procedure create_refund_dtls(p_api_version  NUMBER
90     , p_init_msg_list  VARCHAR2
91     , x_return_status out nocopy  VARCHAR2
92     , x_msg_count out nocopy  NUMBER
93     , x_msg_data out nocopy  VARCHAR2
94     , p5_a0 JTF_NUMBER_TABLE
95     , p5_a1 JTF_NUMBER_TABLE
96     , p5_a2 JTF_NUMBER_TABLE
97     , p5_a3 JTF_NUMBER_TABLE
98     , p5_a4 JTF_NUMBER_TABLE
99     , p5_a5 JTF_NUMBER_TABLE
100     , p5_a6 JTF_VARCHAR2_TABLE_100
101     , p5_a7 JTF_VARCHAR2_TABLE_100
102     , p5_a8 JTF_NUMBER_TABLE
103     , p5_a9 JTF_DATE_TABLE
104     , p5_a10 JTF_VARCHAR2_TABLE_100
105     , p5_a11 JTF_NUMBER_TABLE
106     , p5_a12 JTF_VARCHAR2_TABLE_100
107     , p5_a13 JTF_NUMBER_TABLE
108     , p5_a14 JTF_NUMBER_TABLE
109     , p5_a15 JTF_VARCHAR2_TABLE_100
110     , p5_a16 JTF_NUMBER_TABLE
111     , p5_a17 JTF_NUMBER_TABLE
112     , p5_a18 JTF_VARCHAR2_TABLE_100
113     , p5_a19 JTF_VARCHAR2_TABLE_100
114     , p5_a20 JTF_VARCHAR2_TABLE_500
115     , p5_a21 JTF_VARCHAR2_TABLE_500
116     , p5_a22 JTF_VARCHAR2_TABLE_500
117     , p5_a23 JTF_VARCHAR2_TABLE_500
118     , p5_a24 JTF_VARCHAR2_TABLE_500
119     , p5_a25 JTF_VARCHAR2_TABLE_500
120     , p5_a26 JTF_VARCHAR2_TABLE_500
121     , p5_a27 JTF_VARCHAR2_TABLE_500
122     , p5_a28 JTF_VARCHAR2_TABLE_500
123     , p5_a29 JTF_VARCHAR2_TABLE_500
124     , p5_a30 JTF_VARCHAR2_TABLE_500
125     , p5_a31 JTF_VARCHAR2_TABLE_500
126     , p5_a32 JTF_VARCHAR2_TABLE_500
127     , p5_a33 JTF_VARCHAR2_TABLE_500
128     , p5_a34 JTF_VARCHAR2_TABLE_500
129     , p5_a35 JTF_NUMBER_TABLE
130     , p5_a36 JTF_DATE_TABLE
131     , p5_a37 JTF_NUMBER_TABLE
132     , p5_a38 JTF_DATE_TABLE
133     , p5_a39 JTF_NUMBER_TABLE
134     , p6_a0 out nocopy JTF_NUMBER_TABLE
135     , p6_a1 out nocopy JTF_NUMBER_TABLE
136     , p6_a2 out nocopy JTF_NUMBER_TABLE
137     , p6_a3 out nocopy JTF_NUMBER_TABLE
138     , p6_a4 out nocopy JTF_NUMBER_TABLE
139     , p6_a5 out nocopy JTF_NUMBER_TABLE
140     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
141     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
142     , p6_a8 out nocopy JTF_NUMBER_TABLE
143     , p6_a9 out nocopy JTF_DATE_TABLE
144     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
145     , p6_a11 out nocopy JTF_NUMBER_TABLE
146     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
147     , p6_a13 out nocopy JTF_NUMBER_TABLE
148     , p6_a14 out nocopy JTF_NUMBER_TABLE
149     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
150     , p6_a16 out nocopy JTF_NUMBER_TABLE
151     , p6_a17 out nocopy JTF_NUMBER_TABLE
152     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
153     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
154     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
155     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
156     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
157     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
158     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
159     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
160     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
161     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
162     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
163     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
164     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
165     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
166     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
167     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
168     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
169     , p6_a35 out nocopy JTF_NUMBER_TABLE
170     , p6_a36 out nocopy JTF_DATE_TABLE
171     , p6_a37 out nocopy JTF_NUMBER_TABLE
172     , p6_a38 out nocopy JTF_DATE_TABLE
173     , p6_a39 out nocopy JTF_NUMBER_TABLE
174   );
175   procedure lock_refund_dtls(p_api_version  NUMBER
176     , p_init_msg_list  VARCHAR2
177     , x_return_status out nocopy  VARCHAR2
178     , x_msg_count out nocopy  NUMBER
179     , x_msg_data out nocopy  VARCHAR2
180     , p5_a0  NUMBER := 0-1962.0724
181     , p5_a1  NUMBER := 0-1962.0724
182     , p5_a2  NUMBER := 0-1962.0724
183     , p5_a3  NUMBER := 0-1962.0724
184     , p5_a4  NUMBER := 0-1962.0724
185     , p5_a5  NUMBER := 0-1962.0724
186     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
187     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
188     , p5_a8  NUMBER := 0-1962.0724
189     , p5_a9  DATE := fnd_api.g_miss_date
190     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a11  NUMBER := 0-1962.0724
192     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
193     , p5_a13  NUMBER := 0-1962.0724
194     , p5_a14  NUMBER := 0-1962.0724
195     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
196     , p5_a16  NUMBER := 0-1962.0724
197     , p5_a17  NUMBER := 0-1962.0724
198     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
200     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
201     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
202     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
205     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
206     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
207     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
208     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
209     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
210     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
212     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
213     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
214     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
215     , p5_a35  NUMBER := 0-1962.0724
216     , p5_a36  DATE := fnd_api.g_miss_date
217     , p5_a37  NUMBER := 0-1962.0724
218     , p5_a38  DATE := fnd_api.g_miss_date
219     , p5_a39  NUMBER := 0-1962.0724
220   );
221   procedure lock_refund_dtls(p_api_version  NUMBER
222     , p_init_msg_list  VARCHAR2
223     , x_return_status out nocopy  VARCHAR2
224     , x_msg_count out nocopy  NUMBER
225     , x_msg_data out nocopy  VARCHAR2
226     , p5_a0 JTF_NUMBER_TABLE
227     , p5_a1 JTF_NUMBER_TABLE
228     , p5_a2 JTF_NUMBER_TABLE
229     , p5_a3 JTF_NUMBER_TABLE
230     , p5_a4 JTF_NUMBER_TABLE
231     , p5_a5 JTF_NUMBER_TABLE
232     , p5_a6 JTF_VARCHAR2_TABLE_100
233     , p5_a7 JTF_VARCHAR2_TABLE_100
234     , p5_a8 JTF_NUMBER_TABLE
235     , p5_a9 JTF_DATE_TABLE
236     , p5_a10 JTF_VARCHAR2_TABLE_100
237     , p5_a11 JTF_NUMBER_TABLE
238     , p5_a12 JTF_VARCHAR2_TABLE_100
239     , p5_a13 JTF_NUMBER_TABLE
240     , p5_a14 JTF_NUMBER_TABLE
241     , p5_a15 JTF_VARCHAR2_TABLE_100
242     , p5_a16 JTF_NUMBER_TABLE
243     , p5_a17 JTF_NUMBER_TABLE
244     , p5_a18 JTF_VARCHAR2_TABLE_100
245     , p5_a19 JTF_VARCHAR2_TABLE_100
246     , p5_a20 JTF_VARCHAR2_TABLE_500
247     , p5_a21 JTF_VARCHAR2_TABLE_500
248     , p5_a22 JTF_VARCHAR2_TABLE_500
249     , p5_a23 JTF_VARCHAR2_TABLE_500
250     , p5_a24 JTF_VARCHAR2_TABLE_500
251     , p5_a25 JTF_VARCHAR2_TABLE_500
252     , p5_a26 JTF_VARCHAR2_TABLE_500
253     , p5_a27 JTF_VARCHAR2_TABLE_500
254     , p5_a28 JTF_VARCHAR2_TABLE_500
255     , p5_a29 JTF_VARCHAR2_TABLE_500
256     , p5_a30 JTF_VARCHAR2_TABLE_500
257     , p5_a31 JTF_VARCHAR2_TABLE_500
258     , p5_a32 JTF_VARCHAR2_TABLE_500
259     , p5_a33 JTF_VARCHAR2_TABLE_500
260     , p5_a34 JTF_VARCHAR2_TABLE_500
261     , p5_a35 JTF_NUMBER_TABLE
262     , p5_a36 JTF_DATE_TABLE
263     , p5_a37 JTF_NUMBER_TABLE
264     , p5_a38 JTF_DATE_TABLE
265     , p5_a39 JTF_NUMBER_TABLE
266   );
267   procedure update_refund_dtls(p_api_version  NUMBER
268     , p_init_msg_list  VARCHAR2
269     , x_return_status out nocopy  VARCHAR2
270     , x_msg_count out nocopy  NUMBER
271     , x_msg_data out nocopy  VARCHAR2
272     , p6_a0 out nocopy  NUMBER
273     , p6_a1 out nocopy  NUMBER
274     , p6_a2 out nocopy  NUMBER
275     , p6_a3 out nocopy  NUMBER
276     , p6_a4 out nocopy  NUMBER
277     , p6_a5 out nocopy  NUMBER
278     , p6_a6 out nocopy  VARCHAR2
279     , p6_a7 out nocopy  VARCHAR2
280     , p6_a8 out nocopy  NUMBER
281     , p6_a9 out nocopy  DATE
282     , p6_a10 out nocopy  VARCHAR2
283     , p6_a11 out nocopy  NUMBER
284     , p6_a12 out nocopy  VARCHAR2
285     , p6_a13 out nocopy  NUMBER
286     , p6_a14 out nocopy  NUMBER
287     , p6_a15 out nocopy  VARCHAR2
288     , p6_a16 out nocopy  NUMBER
289     , p6_a17 out nocopy  NUMBER
290     , p6_a18 out nocopy  VARCHAR2
291     , p6_a19 out nocopy  VARCHAR2
292     , p6_a20 out nocopy  VARCHAR2
293     , p6_a21 out nocopy  VARCHAR2
294     , p6_a22 out nocopy  VARCHAR2
295     , p6_a23 out nocopy  VARCHAR2
296     , p6_a24 out nocopy  VARCHAR2
297     , p6_a25 out nocopy  VARCHAR2
298     , p6_a26 out nocopy  VARCHAR2
299     , p6_a27 out nocopy  VARCHAR2
300     , p6_a28 out nocopy  VARCHAR2
301     , p6_a29 out nocopy  VARCHAR2
302     , p6_a30 out nocopy  VARCHAR2
303     , p6_a31 out nocopy  VARCHAR2
304     , p6_a32 out nocopy  VARCHAR2
305     , p6_a33 out nocopy  VARCHAR2
306     , p6_a34 out nocopy  VARCHAR2
307     , p6_a35 out nocopy  NUMBER
308     , p6_a36 out nocopy  DATE
309     , p6_a37 out nocopy  NUMBER
310     , p6_a38 out nocopy  DATE
311     , p6_a39 out nocopy  NUMBER
312     , p5_a0  NUMBER := 0-1962.0724
313     , p5_a1  NUMBER := 0-1962.0724
314     , p5_a2  NUMBER := 0-1962.0724
315     , p5_a3  NUMBER := 0-1962.0724
316     , p5_a4  NUMBER := 0-1962.0724
317     , p5_a5  NUMBER := 0-1962.0724
318     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
319     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
320     , p5_a8  NUMBER := 0-1962.0724
321     , p5_a9  DATE := fnd_api.g_miss_date
322     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
323     , p5_a11  NUMBER := 0-1962.0724
324     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
325     , p5_a13  NUMBER := 0-1962.0724
326     , p5_a14  NUMBER := 0-1962.0724
327     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
328     , p5_a16  NUMBER := 0-1962.0724
329     , p5_a17  NUMBER := 0-1962.0724
330     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
331     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
332     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
333     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
334     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
335     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
336     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
337     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
338     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
339     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
340     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
341     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
342     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
343     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
344     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
345     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
346     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
347     , p5_a35  NUMBER := 0-1962.0724
348     , p5_a36  DATE := fnd_api.g_miss_date
349     , p5_a37  NUMBER := 0-1962.0724
350     , p5_a38  DATE := fnd_api.g_miss_date
351     , p5_a39  NUMBER := 0-1962.0724
352   );
353   procedure update_refund_dtls(p_api_version  NUMBER
354     , p_init_msg_list  VARCHAR2
355     , x_return_status out nocopy  VARCHAR2
356     , x_msg_count out nocopy  NUMBER
357     , x_msg_data out nocopy  VARCHAR2
358     , p5_a0 JTF_NUMBER_TABLE
359     , p5_a1 JTF_NUMBER_TABLE
360     , p5_a2 JTF_NUMBER_TABLE
361     , p5_a3 JTF_NUMBER_TABLE
362     , p5_a4 JTF_NUMBER_TABLE
363     , p5_a5 JTF_NUMBER_TABLE
364     , p5_a6 JTF_VARCHAR2_TABLE_100
365     , p5_a7 JTF_VARCHAR2_TABLE_100
366     , p5_a8 JTF_NUMBER_TABLE
367     , p5_a9 JTF_DATE_TABLE
368     , p5_a10 JTF_VARCHAR2_TABLE_100
369     , p5_a11 JTF_NUMBER_TABLE
370     , p5_a12 JTF_VARCHAR2_TABLE_100
371     , p5_a13 JTF_NUMBER_TABLE
372     , p5_a14 JTF_NUMBER_TABLE
373     , p5_a15 JTF_VARCHAR2_TABLE_100
374     , p5_a16 JTF_NUMBER_TABLE
375     , p5_a17 JTF_NUMBER_TABLE
376     , p5_a18 JTF_VARCHAR2_TABLE_100
377     , p5_a19 JTF_VARCHAR2_TABLE_100
378     , p5_a20 JTF_VARCHAR2_TABLE_500
379     , p5_a21 JTF_VARCHAR2_TABLE_500
380     , p5_a22 JTF_VARCHAR2_TABLE_500
381     , p5_a23 JTF_VARCHAR2_TABLE_500
382     , p5_a24 JTF_VARCHAR2_TABLE_500
383     , p5_a25 JTF_VARCHAR2_TABLE_500
384     , p5_a26 JTF_VARCHAR2_TABLE_500
385     , p5_a27 JTF_VARCHAR2_TABLE_500
386     , p5_a28 JTF_VARCHAR2_TABLE_500
387     , p5_a29 JTF_VARCHAR2_TABLE_500
388     , p5_a30 JTF_VARCHAR2_TABLE_500
389     , p5_a31 JTF_VARCHAR2_TABLE_500
390     , p5_a32 JTF_VARCHAR2_TABLE_500
391     , p5_a33 JTF_VARCHAR2_TABLE_500
392     , p5_a34 JTF_VARCHAR2_TABLE_500
393     , p5_a35 JTF_NUMBER_TABLE
394     , p5_a36 JTF_DATE_TABLE
395     , p5_a37 JTF_NUMBER_TABLE
396     , p5_a38 JTF_DATE_TABLE
397     , p5_a39 JTF_NUMBER_TABLE
398     , p6_a0 out nocopy JTF_NUMBER_TABLE
399     , p6_a1 out nocopy JTF_NUMBER_TABLE
400     , p6_a2 out nocopy JTF_NUMBER_TABLE
401     , p6_a3 out nocopy JTF_NUMBER_TABLE
402     , p6_a4 out nocopy JTF_NUMBER_TABLE
403     , p6_a5 out nocopy JTF_NUMBER_TABLE
404     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
405     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
406     , p6_a8 out nocopy JTF_NUMBER_TABLE
407     , p6_a9 out nocopy JTF_DATE_TABLE
408     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
409     , p6_a11 out nocopy JTF_NUMBER_TABLE
410     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
411     , p6_a13 out nocopy JTF_NUMBER_TABLE
412     , p6_a14 out nocopy JTF_NUMBER_TABLE
413     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
414     , p6_a16 out nocopy JTF_NUMBER_TABLE
415     , p6_a17 out nocopy JTF_NUMBER_TABLE
416     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
417     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
418     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
419     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
420     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
421     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
422     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
423     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
424     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
425     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
426     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
427     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
428     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
429     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
430     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
431     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
432     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
433     , p6_a35 out nocopy JTF_NUMBER_TABLE
434     , p6_a36 out nocopy JTF_DATE_TABLE
435     , p6_a37 out nocopy JTF_NUMBER_TABLE
436     , p6_a38 out nocopy JTF_DATE_TABLE
437     , p6_a39 out nocopy JTF_NUMBER_TABLE
438   );
439   procedure delete_refund_dtls(p_api_version  NUMBER
440     , p_init_msg_list  VARCHAR2
441     , x_return_status out nocopy  VARCHAR2
442     , x_msg_count out nocopy  NUMBER
443     , x_msg_data out nocopy  VARCHAR2
444     , p5_a0  NUMBER := 0-1962.0724
445     , p5_a1  NUMBER := 0-1962.0724
446     , p5_a2  NUMBER := 0-1962.0724
447     , p5_a3  NUMBER := 0-1962.0724
448     , p5_a4  NUMBER := 0-1962.0724
449     , p5_a5  NUMBER := 0-1962.0724
450     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
451     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
452     , p5_a8  NUMBER := 0-1962.0724
453     , p5_a9  DATE := fnd_api.g_miss_date
454     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
455     , p5_a11  NUMBER := 0-1962.0724
456     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
457     , p5_a13  NUMBER := 0-1962.0724
458     , p5_a14  NUMBER := 0-1962.0724
459     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
460     , p5_a16  NUMBER := 0-1962.0724
461     , p5_a17  NUMBER := 0-1962.0724
462     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
463     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
464     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
465     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
466     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
467     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
468     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
469     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
470     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
471     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
472     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
473     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
474     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
475     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
476     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
477     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
478     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
479     , p5_a35  NUMBER := 0-1962.0724
480     , p5_a36  DATE := fnd_api.g_miss_date
481     , p5_a37  NUMBER := 0-1962.0724
482     , p5_a38  DATE := fnd_api.g_miss_date
483     , p5_a39  NUMBER := 0-1962.0724
484   );
485   procedure delete_refund_dtls(p_api_version  NUMBER
486     , p_init_msg_list  VARCHAR2
487     , x_return_status out nocopy  VARCHAR2
488     , x_msg_count out nocopy  NUMBER
489     , x_msg_data out nocopy  VARCHAR2
490     , p5_a0 JTF_NUMBER_TABLE
491     , p5_a1 JTF_NUMBER_TABLE
492     , p5_a2 JTF_NUMBER_TABLE
493     , p5_a3 JTF_NUMBER_TABLE
494     , p5_a4 JTF_NUMBER_TABLE
495     , p5_a5 JTF_NUMBER_TABLE
496     , p5_a6 JTF_VARCHAR2_TABLE_100
497     , p5_a7 JTF_VARCHAR2_TABLE_100
498     , p5_a8 JTF_NUMBER_TABLE
499     , p5_a9 JTF_DATE_TABLE
500     , p5_a10 JTF_VARCHAR2_TABLE_100
501     , p5_a11 JTF_NUMBER_TABLE
502     , p5_a12 JTF_VARCHAR2_TABLE_100
503     , p5_a13 JTF_NUMBER_TABLE
504     , p5_a14 JTF_NUMBER_TABLE
505     , p5_a15 JTF_VARCHAR2_TABLE_100
506     , p5_a16 JTF_NUMBER_TABLE
507     , p5_a17 JTF_NUMBER_TABLE
508     , p5_a18 JTF_VARCHAR2_TABLE_100
509     , p5_a19 JTF_VARCHAR2_TABLE_100
510     , p5_a20 JTF_VARCHAR2_TABLE_500
511     , p5_a21 JTF_VARCHAR2_TABLE_500
512     , p5_a22 JTF_VARCHAR2_TABLE_500
513     , p5_a23 JTF_VARCHAR2_TABLE_500
514     , p5_a24 JTF_VARCHAR2_TABLE_500
515     , p5_a25 JTF_VARCHAR2_TABLE_500
516     , p5_a26 JTF_VARCHAR2_TABLE_500
517     , p5_a27 JTF_VARCHAR2_TABLE_500
518     , p5_a28 JTF_VARCHAR2_TABLE_500
519     , p5_a29 JTF_VARCHAR2_TABLE_500
520     , p5_a30 JTF_VARCHAR2_TABLE_500
521     , p5_a31 JTF_VARCHAR2_TABLE_500
522     , p5_a32 JTF_VARCHAR2_TABLE_500
523     , p5_a33 JTF_VARCHAR2_TABLE_500
524     , p5_a34 JTF_VARCHAR2_TABLE_500
525     , p5_a35 JTF_NUMBER_TABLE
526     , p5_a36 JTF_DATE_TABLE
527     , p5_a37 JTF_NUMBER_TABLE
528     , p5_a38 JTF_DATE_TABLE
529     , p5_a39 JTF_NUMBER_TABLE
530   );
531   procedure validate_refund_dtls(p_api_version  NUMBER
532     , p_init_msg_list  VARCHAR2
533     , x_return_status out nocopy  VARCHAR2
534     , x_msg_count out nocopy  NUMBER
535     , x_msg_data out nocopy  VARCHAR2
536     , p5_a0  NUMBER := 0-1962.0724
537     , p5_a1  NUMBER := 0-1962.0724
538     , p5_a2  NUMBER := 0-1962.0724
539     , p5_a3  NUMBER := 0-1962.0724
540     , p5_a4  NUMBER := 0-1962.0724
541     , p5_a5  NUMBER := 0-1962.0724
542     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
543     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
544     , p5_a8  NUMBER := 0-1962.0724
545     , p5_a9  DATE := fnd_api.g_miss_date
546     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
547     , p5_a11  NUMBER := 0-1962.0724
548     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
549     , p5_a13  NUMBER := 0-1962.0724
550     , p5_a14  NUMBER := 0-1962.0724
551     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
552     , p5_a16  NUMBER := 0-1962.0724
553     , p5_a17  NUMBER := 0-1962.0724
554     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
555     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
556     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
557     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
558     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
559     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
560     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
561     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
562     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
563     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
564     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
565     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
566     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
567     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
568     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
569     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
570     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
571     , p5_a35  NUMBER := 0-1962.0724
572     , p5_a36  DATE := fnd_api.g_miss_date
573     , p5_a37  NUMBER := 0-1962.0724
574     , p5_a38  DATE := fnd_api.g_miss_date
575     , p5_a39  NUMBER := 0-1962.0724
576   );
577   procedure validate_refund_dtls(p_api_version  NUMBER
578     , p_init_msg_list  VARCHAR2
579     , x_return_status out nocopy  VARCHAR2
580     , x_msg_count out nocopy  NUMBER
581     , x_msg_data out nocopy  VARCHAR2
582     , p5_a0 JTF_NUMBER_TABLE
583     , p5_a1 JTF_NUMBER_TABLE
584     , p5_a2 JTF_NUMBER_TABLE
585     , p5_a3 JTF_NUMBER_TABLE
586     , p5_a4 JTF_NUMBER_TABLE
587     , p5_a5 JTF_NUMBER_TABLE
588     , p5_a6 JTF_VARCHAR2_TABLE_100
589     , p5_a7 JTF_VARCHAR2_TABLE_100
590     , p5_a8 JTF_NUMBER_TABLE
591     , p5_a9 JTF_DATE_TABLE
592     , p5_a10 JTF_VARCHAR2_TABLE_100
593     , p5_a11 JTF_NUMBER_TABLE
594     , p5_a12 JTF_VARCHAR2_TABLE_100
595     , p5_a13 JTF_NUMBER_TABLE
596     , p5_a14 JTF_NUMBER_TABLE
597     , p5_a15 JTF_VARCHAR2_TABLE_100
598     , p5_a16 JTF_NUMBER_TABLE
599     , p5_a17 JTF_NUMBER_TABLE
600     , p5_a18 JTF_VARCHAR2_TABLE_100
601     , p5_a19 JTF_VARCHAR2_TABLE_100
602     , p5_a20 JTF_VARCHAR2_TABLE_500
603     , p5_a21 JTF_VARCHAR2_TABLE_500
604     , p5_a22 JTF_VARCHAR2_TABLE_500
605     , p5_a23 JTF_VARCHAR2_TABLE_500
606     , p5_a24 JTF_VARCHAR2_TABLE_500
607     , p5_a25 JTF_VARCHAR2_TABLE_500
608     , p5_a26 JTF_VARCHAR2_TABLE_500
609     , p5_a27 JTF_VARCHAR2_TABLE_500
610     , p5_a28 JTF_VARCHAR2_TABLE_500
611     , p5_a29 JTF_VARCHAR2_TABLE_500
612     , p5_a30 JTF_VARCHAR2_TABLE_500
613     , p5_a31 JTF_VARCHAR2_TABLE_500
614     , p5_a32 JTF_VARCHAR2_TABLE_500
615     , p5_a33 JTF_VARCHAR2_TABLE_500
616     , p5_a34 JTF_VARCHAR2_TABLE_500
617     , p5_a35 JTF_NUMBER_TABLE
618     , p5_a36 JTF_DATE_TABLE
619     , p5_a37 JTF_NUMBER_TABLE
620     , p5_a38 JTF_DATE_TABLE
621     , p5_a39 JTF_NUMBER_TABLE
622   );
623 end okl_subsidy_rfnd_dtls_pvt_w;