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_PROCESS_PROVISIONS_PUB_W

Source


1 package okl_process_provisions_pub_w as
2   /* $Header: OKLUPRVS.pls 120.1 2005/07/18 10:31:37 asawanka noship $ */
3   procedure create_provisions(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  NUMBER
15     , p6_a7 out nocopy  VARCHAR2
16     , p6_a8 out nocopy  VARCHAR2
17     , p6_a9 out nocopy  VARCHAR2
18     , p6_a10 out nocopy  VARCHAR2
19     , p6_a11 out nocopy  VARCHAR2
20     , p6_a12 out nocopy  VARCHAR2
21     , p6_a13 out nocopy  VARCHAR2
22     , p6_a14 out nocopy  VARCHAR2
23     , p6_a15 out nocopy  VARCHAR2
24     , p6_a16 out nocopy  VARCHAR2
25     , p6_a17 out nocopy  VARCHAR2
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  DATE
35     , p6_a27 out nocopy  DATE
36     , p6_a28 out nocopy  NUMBER
37     , p6_a29 out nocopy  DATE
38     , p6_a30 out nocopy  NUMBER
39     , p6_a31 out nocopy  DATE
40     , p6_a32 out nocopy  NUMBER
41     , p5_a0  NUMBER := 0-1962.0724
42     , p5_a1  NUMBER := 0-1962.0724
43     , p5_a2  NUMBER := 0-1962.0724
44     , p5_a3  NUMBER := 0-1962.0724
45     , p5_a4  NUMBER := 0-1962.0724
46     , p5_a5  NUMBER := 0-1962.0724
47     , p5_a6  NUMBER := 0-1962.0724
48     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
49     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
50     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
51     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
52     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
53     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
54     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
55     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
56     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
57     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
58     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
59     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
60     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
61     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
62     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
63     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
64     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
65     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
66     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
67     , p5_a26  DATE := fnd_api.g_miss_date
68     , p5_a27  DATE := fnd_api.g_miss_date
69     , p5_a28  NUMBER := 0-1962.0724
70     , p5_a29  DATE := fnd_api.g_miss_date
71     , p5_a30  NUMBER := 0-1962.0724
72     , p5_a31  DATE := fnd_api.g_miss_date
73     , p5_a32  NUMBER := 0-1962.0724
74   );
75   procedure create_provisions(p_api_version  NUMBER
76     , p_init_msg_list  VARCHAR2
77     , x_return_status out nocopy  VARCHAR2
78     , x_msg_count out nocopy  NUMBER
79     , x_msg_data out nocopy  VARCHAR2
80     , p5_a0 JTF_NUMBER_TABLE
81     , p5_a1 JTF_NUMBER_TABLE
82     , p5_a2 JTF_NUMBER_TABLE
83     , p5_a3 JTF_NUMBER_TABLE
84     , p5_a4 JTF_NUMBER_TABLE
85     , p5_a5 JTF_NUMBER_TABLE
86     , p5_a6 JTF_NUMBER_TABLE
87     , p5_a7 JTF_VARCHAR2_TABLE_200
88     , p5_a8 JTF_VARCHAR2_TABLE_2000
89     , p5_a9 JTF_VARCHAR2_TABLE_100
90     , p5_a10 JTF_VARCHAR2_TABLE_500
91     , p5_a11 JTF_VARCHAR2_TABLE_500
92     , p5_a12 JTF_VARCHAR2_TABLE_500
93     , p5_a13 JTF_VARCHAR2_TABLE_500
94     , p5_a14 JTF_VARCHAR2_TABLE_500
95     , p5_a15 JTF_VARCHAR2_TABLE_500
96     , p5_a16 JTF_VARCHAR2_TABLE_500
97     , p5_a17 JTF_VARCHAR2_TABLE_500
98     , p5_a18 JTF_VARCHAR2_TABLE_500
99     , p5_a19 JTF_VARCHAR2_TABLE_500
100     , p5_a20 JTF_VARCHAR2_TABLE_500
101     , p5_a21 JTF_VARCHAR2_TABLE_500
102     , p5_a22 JTF_VARCHAR2_TABLE_500
103     , p5_a23 JTF_VARCHAR2_TABLE_500
104     , p5_a24 JTF_VARCHAR2_TABLE_500
105     , p5_a25 JTF_VARCHAR2_TABLE_100
106     , p5_a26 JTF_DATE_TABLE
107     , p5_a27 JTF_DATE_TABLE
108     , p5_a28 JTF_NUMBER_TABLE
109     , p5_a29 JTF_DATE_TABLE
110     , p5_a30 JTF_NUMBER_TABLE
111     , p5_a31 JTF_DATE_TABLE
112     , p5_a32 JTF_NUMBER_TABLE
113     , p6_a0 out nocopy JTF_NUMBER_TABLE
114     , p6_a1 out nocopy JTF_NUMBER_TABLE
115     , p6_a2 out nocopy JTF_NUMBER_TABLE
116     , p6_a3 out nocopy JTF_NUMBER_TABLE
117     , p6_a4 out nocopy JTF_NUMBER_TABLE
118     , p6_a5 out nocopy JTF_NUMBER_TABLE
119     , p6_a6 out nocopy JTF_NUMBER_TABLE
120     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
121     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
122     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
123     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
124     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
125     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
126     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
127     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
128     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
129     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
130     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
131     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
132     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
133     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
134     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
135     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
136     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
137     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
138     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
139     , p6_a26 out nocopy JTF_DATE_TABLE
140     , p6_a27 out nocopy JTF_DATE_TABLE
141     , p6_a28 out nocopy JTF_NUMBER_TABLE
142     , p6_a29 out nocopy JTF_DATE_TABLE
143     , p6_a30 out nocopy JTF_NUMBER_TABLE
144     , p6_a31 out nocopy JTF_DATE_TABLE
145     , p6_a32 out nocopy JTF_NUMBER_TABLE
146   );
147   procedure update_provisions(p_api_version  NUMBER
148     , p_init_msg_list  VARCHAR2
149     , x_return_status out nocopy  VARCHAR2
150     , x_msg_count out nocopy  NUMBER
151     , x_msg_data out nocopy  VARCHAR2
152     , p6_a0 out nocopy  NUMBER
153     , p6_a1 out nocopy  NUMBER
154     , p6_a2 out nocopy  NUMBER
155     , p6_a3 out nocopy  NUMBER
156     , p6_a4 out nocopy  NUMBER
157     , p6_a5 out nocopy  NUMBER
158     , p6_a6 out nocopy  NUMBER
159     , p6_a7 out nocopy  VARCHAR2
160     , p6_a8 out nocopy  VARCHAR2
161     , p6_a9 out nocopy  VARCHAR2
162     , p6_a10 out nocopy  VARCHAR2
163     , p6_a11 out nocopy  VARCHAR2
164     , p6_a12 out nocopy  VARCHAR2
165     , p6_a13 out nocopy  VARCHAR2
166     , p6_a14 out nocopy  VARCHAR2
167     , p6_a15 out nocopy  VARCHAR2
168     , p6_a16 out nocopy  VARCHAR2
169     , p6_a17 out nocopy  VARCHAR2
170     , p6_a18 out nocopy  VARCHAR2
171     , p6_a19 out nocopy  VARCHAR2
172     , p6_a20 out nocopy  VARCHAR2
173     , p6_a21 out nocopy  VARCHAR2
174     , p6_a22 out nocopy  VARCHAR2
175     , p6_a23 out nocopy  VARCHAR2
176     , p6_a24 out nocopy  VARCHAR2
177     , p6_a25 out nocopy  VARCHAR2
178     , p6_a26 out nocopy  DATE
179     , p6_a27 out nocopy  DATE
180     , p6_a28 out nocopy  NUMBER
181     , p6_a29 out nocopy  DATE
182     , p6_a30 out nocopy  NUMBER
183     , p6_a31 out nocopy  DATE
184     , p6_a32 out nocopy  NUMBER
185     , p5_a0  NUMBER := 0-1962.0724
186     , p5_a1  NUMBER := 0-1962.0724
187     , p5_a2  NUMBER := 0-1962.0724
188     , p5_a3  NUMBER := 0-1962.0724
189     , p5_a4  NUMBER := 0-1962.0724
190     , p5_a5  NUMBER := 0-1962.0724
191     , p5_a6  NUMBER := 0-1962.0724
192     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
193     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
194     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
195     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
196     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
197     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
198     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
200     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
201     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
202     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
205     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
206     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
207     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
208     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
209     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
210     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
211     , p5_a26  DATE := fnd_api.g_miss_date
212     , p5_a27  DATE := fnd_api.g_miss_date
213     , p5_a28  NUMBER := 0-1962.0724
214     , p5_a29  DATE := fnd_api.g_miss_date
215     , p5_a30  NUMBER := 0-1962.0724
216     , p5_a31  DATE := fnd_api.g_miss_date
217     , p5_a32  NUMBER := 0-1962.0724
218   );
219   procedure update_provisions(p_api_version  NUMBER
220     , p_init_msg_list  VARCHAR2
221     , x_return_status out nocopy  VARCHAR2
222     , x_msg_count out nocopy  NUMBER
223     , x_msg_data out nocopy  VARCHAR2
224     , p5_a0 JTF_NUMBER_TABLE
225     , p5_a1 JTF_NUMBER_TABLE
226     , p5_a2 JTF_NUMBER_TABLE
227     , p5_a3 JTF_NUMBER_TABLE
228     , p5_a4 JTF_NUMBER_TABLE
229     , p5_a5 JTF_NUMBER_TABLE
230     , p5_a6 JTF_NUMBER_TABLE
231     , p5_a7 JTF_VARCHAR2_TABLE_200
232     , p5_a8 JTF_VARCHAR2_TABLE_2000
233     , p5_a9 JTF_VARCHAR2_TABLE_100
234     , p5_a10 JTF_VARCHAR2_TABLE_500
235     , p5_a11 JTF_VARCHAR2_TABLE_500
236     , p5_a12 JTF_VARCHAR2_TABLE_500
237     , p5_a13 JTF_VARCHAR2_TABLE_500
238     , p5_a14 JTF_VARCHAR2_TABLE_500
239     , p5_a15 JTF_VARCHAR2_TABLE_500
240     , p5_a16 JTF_VARCHAR2_TABLE_500
241     , p5_a17 JTF_VARCHAR2_TABLE_500
242     , p5_a18 JTF_VARCHAR2_TABLE_500
243     , p5_a19 JTF_VARCHAR2_TABLE_500
244     , p5_a20 JTF_VARCHAR2_TABLE_500
245     , p5_a21 JTF_VARCHAR2_TABLE_500
246     , p5_a22 JTF_VARCHAR2_TABLE_500
247     , p5_a23 JTF_VARCHAR2_TABLE_500
248     , p5_a24 JTF_VARCHAR2_TABLE_500
249     , p5_a25 JTF_VARCHAR2_TABLE_100
250     , p5_a26 JTF_DATE_TABLE
251     , p5_a27 JTF_DATE_TABLE
252     , p5_a28 JTF_NUMBER_TABLE
253     , p5_a29 JTF_DATE_TABLE
254     , p5_a30 JTF_NUMBER_TABLE
255     , p5_a31 JTF_DATE_TABLE
256     , p5_a32 JTF_NUMBER_TABLE
257     , p6_a0 out nocopy JTF_NUMBER_TABLE
258     , p6_a1 out nocopy JTF_NUMBER_TABLE
259     , p6_a2 out nocopy JTF_NUMBER_TABLE
260     , p6_a3 out nocopy JTF_NUMBER_TABLE
261     , p6_a4 out nocopy JTF_NUMBER_TABLE
262     , p6_a5 out nocopy JTF_NUMBER_TABLE
263     , p6_a6 out nocopy JTF_NUMBER_TABLE
264     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
265     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
266     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
267     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
268     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
269     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
270     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
271     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
272     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
273     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
274     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
275     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
276     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
277     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
278     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
279     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
280     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
281     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
282     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
283     , p6_a26 out nocopy JTF_DATE_TABLE
284     , p6_a27 out nocopy JTF_DATE_TABLE
285     , p6_a28 out nocopy JTF_NUMBER_TABLE
286     , p6_a29 out nocopy JTF_DATE_TABLE
287     , p6_a30 out nocopy JTF_NUMBER_TABLE
288     , p6_a31 out nocopy JTF_DATE_TABLE
289     , p6_a32 out nocopy JTF_NUMBER_TABLE
290   );
291   procedure delete_provisions(p_api_version  NUMBER
292     , p_init_msg_list  VARCHAR2
293     , x_return_status out nocopy  VARCHAR2
294     , x_msg_count out nocopy  NUMBER
295     , x_msg_data out nocopy  VARCHAR2
296     , p5_a0  NUMBER := 0-1962.0724
297     , p5_a1  NUMBER := 0-1962.0724
298     , p5_a2  NUMBER := 0-1962.0724
299     , p5_a3  NUMBER := 0-1962.0724
300     , p5_a4  NUMBER := 0-1962.0724
301     , p5_a5  NUMBER := 0-1962.0724
302     , p5_a6  NUMBER := 0-1962.0724
303     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
304     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
305     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
306     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
307     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
308     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
309     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
310     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
311     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
312     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
313     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
314     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
315     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
316     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
317     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
318     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
319     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
320     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
321     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
322     , p5_a26  DATE := fnd_api.g_miss_date
323     , p5_a27  DATE := fnd_api.g_miss_date
324     , p5_a28  NUMBER := 0-1962.0724
325     , p5_a29  DATE := fnd_api.g_miss_date
326     , p5_a30  NUMBER := 0-1962.0724
327     , p5_a31  DATE := fnd_api.g_miss_date
328     , p5_a32  NUMBER := 0-1962.0724
329   );
330   procedure delete_provisions(p_api_version  NUMBER
331     , p_init_msg_list  VARCHAR2
332     , x_return_status out nocopy  VARCHAR2
333     , x_msg_count out nocopy  NUMBER
334     , x_msg_data out nocopy  VARCHAR2
335     , p5_a0 JTF_NUMBER_TABLE
336     , p5_a1 JTF_NUMBER_TABLE
337     , p5_a2 JTF_NUMBER_TABLE
338     , p5_a3 JTF_NUMBER_TABLE
339     , p5_a4 JTF_NUMBER_TABLE
340     , p5_a5 JTF_NUMBER_TABLE
341     , p5_a6 JTF_NUMBER_TABLE
342     , p5_a7 JTF_VARCHAR2_TABLE_200
343     , p5_a8 JTF_VARCHAR2_TABLE_2000
344     , p5_a9 JTF_VARCHAR2_TABLE_100
345     , p5_a10 JTF_VARCHAR2_TABLE_500
346     , p5_a11 JTF_VARCHAR2_TABLE_500
347     , p5_a12 JTF_VARCHAR2_TABLE_500
348     , p5_a13 JTF_VARCHAR2_TABLE_500
349     , p5_a14 JTF_VARCHAR2_TABLE_500
350     , p5_a15 JTF_VARCHAR2_TABLE_500
351     , p5_a16 JTF_VARCHAR2_TABLE_500
352     , p5_a17 JTF_VARCHAR2_TABLE_500
353     , p5_a18 JTF_VARCHAR2_TABLE_500
354     , p5_a19 JTF_VARCHAR2_TABLE_500
355     , p5_a20 JTF_VARCHAR2_TABLE_500
356     , p5_a21 JTF_VARCHAR2_TABLE_500
357     , p5_a22 JTF_VARCHAR2_TABLE_500
358     , p5_a23 JTF_VARCHAR2_TABLE_500
359     , p5_a24 JTF_VARCHAR2_TABLE_500
360     , p5_a25 JTF_VARCHAR2_TABLE_100
361     , p5_a26 JTF_DATE_TABLE
362     , p5_a27 JTF_DATE_TABLE
363     , p5_a28 JTF_NUMBER_TABLE
364     , p5_a29 JTF_DATE_TABLE
365     , p5_a30 JTF_NUMBER_TABLE
366     , p5_a31 JTF_DATE_TABLE
367     , p5_a32 JTF_NUMBER_TABLE
368   );
369 end okl_process_provisions_pub_w;