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_TRY_PVT_W

Source


1 package okl_try_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLITRYS.pls 120.2 2005/07/15 07:40:29 asawanka noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy okl_try_pvt.try_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     );
21   procedure rosetta_table_copy_out_p2(t okl_try_pvt.try_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
22     , a1 out nocopy JTF_NUMBER_TABLE
23     , a2 out nocopy JTF_NUMBER_TABLE
24     , a3 out nocopy JTF_NUMBER_TABLE
25     , a4 out nocopy JTF_VARCHAR2_TABLE_100
26     , a5 out nocopy JTF_VARCHAR2_TABLE_100
27     , a6 out nocopy JTF_NUMBER_TABLE
28     , a7 out nocopy JTF_NUMBER_TABLE
29     , a8 out nocopy JTF_NUMBER_TABLE
30     , a9 out nocopy JTF_DATE_TABLE
31     , a10 out nocopy JTF_NUMBER_TABLE
32     , a11 out nocopy JTF_DATE_TABLE
33     , a12 out nocopy JTF_NUMBER_TABLE
34     , a13 out nocopy JTF_VARCHAR2_TABLE_100
35     , a14 out nocopy JTF_VARCHAR2_TABLE_100
36     , a15 out nocopy JTF_VARCHAR2_TABLE_100
37     , a16 out nocopy JTF_VARCHAR2_TABLE_100
38     );
39 
40   procedure rosetta_table_copy_in_p5(t out nocopy okl_try_pvt.okl_trx_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
41     , a1 JTF_VARCHAR2_TABLE_100
42     , a2 JTF_VARCHAR2_TABLE_100
43     , a3 JTF_VARCHAR2_TABLE_100
44     , a4 JTF_VARCHAR2_TABLE_200
45     , a5 JTF_VARCHAR2_TABLE_2000
46     , a6 JTF_VARCHAR2_TABLE_100
47     , a7 JTF_VARCHAR2_TABLE_100
48     , a8 JTF_NUMBER_TABLE
49     , a9 JTF_DATE_TABLE
50     , a10 JTF_NUMBER_TABLE
51     , a11 JTF_DATE_TABLE
52     , a12 JTF_NUMBER_TABLE
53     );
54   procedure rosetta_table_copy_out_p5(t okl_try_pvt.okl_trx_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55     , a1 out nocopy JTF_VARCHAR2_TABLE_100
56     , a2 out nocopy JTF_VARCHAR2_TABLE_100
57     , a3 out nocopy JTF_VARCHAR2_TABLE_100
58     , a4 out nocopy JTF_VARCHAR2_TABLE_200
59     , a5 out nocopy JTF_VARCHAR2_TABLE_2000
60     , a6 out nocopy JTF_VARCHAR2_TABLE_100
61     , a7 out nocopy JTF_VARCHAR2_TABLE_100
62     , a8 out nocopy JTF_NUMBER_TABLE
63     , a9 out nocopy JTF_DATE_TABLE
64     , a10 out nocopy JTF_NUMBER_TABLE
65     , a11 out nocopy JTF_DATE_TABLE
66     , a12 out nocopy JTF_NUMBER_TABLE
67     );
68 
69   procedure rosetta_table_copy_in_p8(t out nocopy okl_try_pvt.tryv_tbl_type, a0 JTF_NUMBER_TABLE
70     , a1 JTF_NUMBER_TABLE
71     , a2 JTF_VARCHAR2_TABLE_100
72     , a3 JTF_VARCHAR2_TABLE_100
73     , a4 JTF_NUMBER_TABLE
74     , a5 JTF_NUMBER_TABLE
75     , a6 JTF_NUMBER_TABLE
76     , a7 JTF_VARCHAR2_TABLE_100
77     , a8 JTF_VARCHAR2_TABLE_200
78     , a9 JTF_VARCHAR2_TABLE_2000
79     , a10 JTF_VARCHAR2_TABLE_100
80     , a11 JTF_VARCHAR2_TABLE_100
81     , a12 JTF_NUMBER_TABLE
82     , a13 JTF_NUMBER_TABLE
83     , a14 JTF_DATE_TABLE
84     , a15 JTF_NUMBER_TABLE
85     , a16 JTF_DATE_TABLE
86     , a17 JTF_NUMBER_TABLE
87     , a18 JTF_VARCHAR2_TABLE_100
88     , a19 JTF_VARCHAR2_TABLE_100
89     , a20 JTF_VARCHAR2_TABLE_100
90     , a21 JTF_VARCHAR2_TABLE_100
91     );
92   procedure rosetta_table_copy_out_p8(t okl_try_pvt.tryv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93     , a1 out nocopy JTF_NUMBER_TABLE
94     , a2 out nocopy JTF_VARCHAR2_TABLE_100
95     , a3 out nocopy JTF_VARCHAR2_TABLE_100
96     , a4 out nocopy JTF_NUMBER_TABLE
97     , a5 out nocopy JTF_NUMBER_TABLE
98     , a6 out nocopy JTF_NUMBER_TABLE
99     , a7 out nocopy JTF_VARCHAR2_TABLE_100
100     , a8 out nocopy JTF_VARCHAR2_TABLE_200
101     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
102     , a10 out nocopy JTF_VARCHAR2_TABLE_100
103     , a11 out nocopy JTF_VARCHAR2_TABLE_100
104     , a12 out nocopy JTF_NUMBER_TABLE
105     , a13 out nocopy JTF_NUMBER_TABLE
106     , a14 out nocopy JTF_DATE_TABLE
107     , a15 out nocopy JTF_NUMBER_TABLE
108     , a16 out nocopy JTF_DATE_TABLE
109     , a17 out nocopy JTF_NUMBER_TABLE
110     , a18 out nocopy JTF_VARCHAR2_TABLE_100
111     , a19 out nocopy JTF_VARCHAR2_TABLE_100
112     , a20 out nocopy JTF_VARCHAR2_TABLE_100
113     , a21 out nocopy JTF_VARCHAR2_TABLE_100
114     );
115 
116   procedure insert_row(p_api_version  NUMBER
117     , p_init_msg_list  VARCHAR2
118     , x_return_status out nocopy  VARCHAR2
119     , x_msg_count out nocopy  NUMBER
120     , x_msg_data out nocopy  VARCHAR2
121     , p6_a0 out nocopy  NUMBER
122     , p6_a1 out nocopy  NUMBER
123     , p6_a2 out nocopy  VARCHAR2
124     , p6_a3 out nocopy  VARCHAR2
125     , p6_a4 out nocopy  NUMBER
126     , p6_a5 out nocopy  NUMBER
127     , p6_a6 out nocopy  NUMBER
128     , p6_a7 out nocopy  VARCHAR2
129     , p6_a8 out nocopy  VARCHAR2
130     , p6_a9 out nocopy  VARCHAR2
131     , p6_a10 out nocopy  VARCHAR2
132     , p6_a11 out nocopy  VARCHAR2
133     , p6_a12 out nocopy  NUMBER
134     , p6_a13 out nocopy  NUMBER
135     , p6_a14 out nocopy  DATE
136     , p6_a15 out nocopy  NUMBER
137     , p6_a16 out nocopy  DATE
138     , p6_a17 out nocopy  NUMBER
139     , p6_a18 out nocopy  VARCHAR2
140     , p6_a19 out nocopy  VARCHAR2
141     , p6_a20 out nocopy  VARCHAR2
142     , p6_a21 out nocopy  VARCHAR2
143     , p5_a0  NUMBER := 0-1962.0724
144     , p5_a1  NUMBER := 0-1962.0724
145     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
146     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
147     , p5_a4  NUMBER := 0-1962.0724
148     , p5_a5  NUMBER := 0-1962.0724
149     , p5_a6  NUMBER := 0-1962.0724
150     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
151     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
152     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
153     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
154     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
155     , p5_a12  NUMBER := 0-1962.0724
156     , p5_a13  NUMBER := 0-1962.0724
157     , p5_a14  DATE := fnd_api.g_miss_date
158     , p5_a15  NUMBER := 0-1962.0724
159     , p5_a16  DATE := fnd_api.g_miss_date
160     , p5_a17  NUMBER := 0-1962.0724
161     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
163     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
164     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
165   );
166   procedure insert_row(p_api_version  NUMBER
167     , p_init_msg_list  VARCHAR2
168     , x_return_status out nocopy  VARCHAR2
169     , x_msg_count out nocopy  NUMBER
170     , x_msg_data out nocopy  VARCHAR2
171     , p5_a0 JTF_NUMBER_TABLE
172     , p5_a1 JTF_NUMBER_TABLE
173     , p5_a2 JTF_VARCHAR2_TABLE_100
174     , p5_a3 JTF_VARCHAR2_TABLE_100
175     , p5_a4 JTF_NUMBER_TABLE
176     , p5_a5 JTF_NUMBER_TABLE
177     , p5_a6 JTF_NUMBER_TABLE
178     , p5_a7 JTF_VARCHAR2_TABLE_100
179     , p5_a8 JTF_VARCHAR2_TABLE_200
180     , p5_a9 JTF_VARCHAR2_TABLE_2000
181     , p5_a10 JTF_VARCHAR2_TABLE_100
182     , p5_a11 JTF_VARCHAR2_TABLE_100
183     , p5_a12 JTF_NUMBER_TABLE
184     , p5_a13 JTF_NUMBER_TABLE
185     , p5_a14 JTF_DATE_TABLE
186     , p5_a15 JTF_NUMBER_TABLE
187     , p5_a16 JTF_DATE_TABLE
188     , p5_a17 JTF_NUMBER_TABLE
189     , p5_a18 JTF_VARCHAR2_TABLE_100
190     , p5_a19 JTF_VARCHAR2_TABLE_100
191     , p5_a20 JTF_VARCHAR2_TABLE_100
192     , p5_a21 JTF_VARCHAR2_TABLE_100
193     , p6_a0 out nocopy JTF_NUMBER_TABLE
194     , p6_a1 out nocopy JTF_NUMBER_TABLE
195     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197     , p6_a4 out nocopy JTF_NUMBER_TABLE
198     , p6_a5 out nocopy JTF_NUMBER_TABLE
199     , p6_a6 out nocopy JTF_NUMBER_TABLE
200     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
201     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
202     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
203     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
204     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
205     , p6_a12 out nocopy JTF_NUMBER_TABLE
206     , p6_a13 out nocopy JTF_NUMBER_TABLE
207     , p6_a14 out nocopy JTF_DATE_TABLE
208     , p6_a15 out nocopy JTF_NUMBER_TABLE
209     , p6_a16 out nocopy JTF_DATE_TABLE
210     , p6_a17 out nocopy JTF_NUMBER_TABLE
211     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
212     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
213     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
214     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
215   );
216   procedure lock_row(p_api_version  NUMBER
217     , p_init_msg_list  VARCHAR2
218     , x_return_status out nocopy  VARCHAR2
219     , x_msg_count out nocopy  NUMBER
220     , x_msg_data out nocopy  VARCHAR2
221     , p5_a0  NUMBER := 0-1962.0724
222     , p5_a1  NUMBER := 0-1962.0724
223     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
224     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a4  NUMBER := 0-1962.0724
226     , p5_a5  NUMBER := 0-1962.0724
227     , p5_a6  NUMBER := 0-1962.0724
228     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a12  NUMBER := 0-1962.0724
234     , p5_a13  NUMBER := 0-1962.0724
235     , p5_a14  DATE := fnd_api.g_miss_date
236     , p5_a15  NUMBER := 0-1962.0724
237     , p5_a16  DATE := fnd_api.g_miss_date
238     , p5_a17  NUMBER := 0-1962.0724
239     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
243   );
244   procedure lock_row(p_api_version  NUMBER
245     , p_init_msg_list  VARCHAR2
246     , x_return_status out nocopy  VARCHAR2
247     , x_msg_count out nocopy  NUMBER
248     , x_msg_data out nocopy  VARCHAR2
249     , p5_a0 JTF_NUMBER_TABLE
250     , p5_a1 JTF_NUMBER_TABLE
251     , p5_a2 JTF_VARCHAR2_TABLE_100
252     , p5_a3 JTF_VARCHAR2_TABLE_100
253     , p5_a4 JTF_NUMBER_TABLE
254     , p5_a5 JTF_NUMBER_TABLE
255     , p5_a6 JTF_NUMBER_TABLE
256     , p5_a7 JTF_VARCHAR2_TABLE_100
257     , p5_a8 JTF_VARCHAR2_TABLE_200
258     , p5_a9 JTF_VARCHAR2_TABLE_2000
259     , p5_a10 JTF_VARCHAR2_TABLE_100
260     , p5_a11 JTF_VARCHAR2_TABLE_100
261     , p5_a12 JTF_NUMBER_TABLE
262     , p5_a13 JTF_NUMBER_TABLE
263     , p5_a14 JTF_DATE_TABLE
264     , p5_a15 JTF_NUMBER_TABLE
265     , p5_a16 JTF_DATE_TABLE
266     , p5_a17 JTF_NUMBER_TABLE
267     , p5_a18 JTF_VARCHAR2_TABLE_100
268     , p5_a19 JTF_VARCHAR2_TABLE_100
269     , p5_a20 JTF_VARCHAR2_TABLE_100
270     , p5_a21 JTF_VARCHAR2_TABLE_100
271   );
272   procedure update_row(p_api_version  NUMBER
273     , p_init_msg_list  VARCHAR2
274     , x_return_status out nocopy  VARCHAR2
275     , x_msg_count out nocopy  NUMBER
276     , x_msg_data out nocopy  VARCHAR2
277     , p6_a0 out nocopy  NUMBER
278     , p6_a1 out nocopy  NUMBER
279     , p6_a2 out nocopy  VARCHAR2
280     , p6_a3 out nocopy  VARCHAR2
281     , p6_a4 out nocopy  NUMBER
282     , p6_a5 out nocopy  NUMBER
283     , p6_a6 out nocopy  NUMBER
284     , p6_a7 out nocopy  VARCHAR2
285     , p6_a8 out nocopy  VARCHAR2
286     , p6_a9 out nocopy  VARCHAR2
287     , p6_a10 out nocopy  VARCHAR2
288     , p6_a11 out nocopy  VARCHAR2
289     , p6_a12 out nocopy  NUMBER
290     , p6_a13 out nocopy  NUMBER
291     , p6_a14 out nocopy  DATE
292     , p6_a15 out nocopy  NUMBER
293     , p6_a16 out nocopy  DATE
294     , p6_a17 out nocopy  NUMBER
295     , p6_a18 out nocopy  VARCHAR2
296     , p6_a19 out nocopy  VARCHAR2
297     , p6_a20 out nocopy  VARCHAR2
298     , p6_a21 out nocopy  VARCHAR2
299     , p5_a0  NUMBER := 0-1962.0724
300     , p5_a1  NUMBER := 0-1962.0724
301     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
302     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
303     , p5_a4  NUMBER := 0-1962.0724
304     , p5_a5  NUMBER := 0-1962.0724
305     , p5_a6  NUMBER := 0-1962.0724
306     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
307     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
308     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
309     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
310     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
311     , p5_a12  NUMBER := 0-1962.0724
312     , p5_a13  NUMBER := 0-1962.0724
313     , p5_a14  DATE := fnd_api.g_miss_date
314     , p5_a15  NUMBER := 0-1962.0724
315     , p5_a16  DATE := fnd_api.g_miss_date
316     , p5_a17  NUMBER := 0-1962.0724
317     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
318     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
319     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
320     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
321   );
322   procedure update_row(p_api_version  NUMBER
323     , p_init_msg_list  VARCHAR2
324     , x_return_status out nocopy  VARCHAR2
325     , x_msg_count out nocopy  NUMBER
326     , x_msg_data out nocopy  VARCHAR2
327     , p5_a0 JTF_NUMBER_TABLE
328     , p5_a1 JTF_NUMBER_TABLE
329     , p5_a2 JTF_VARCHAR2_TABLE_100
330     , p5_a3 JTF_VARCHAR2_TABLE_100
331     , p5_a4 JTF_NUMBER_TABLE
332     , p5_a5 JTF_NUMBER_TABLE
333     , p5_a6 JTF_NUMBER_TABLE
334     , p5_a7 JTF_VARCHAR2_TABLE_100
335     , p5_a8 JTF_VARCHAR2_TABLE_200
336     , p5_a9 JTF_VARCHAR2_TABLE_2000
337     , p5_a10 JTF_VARCHAR2_TABLE_100
338     , p5_a11 JTF_VARCHAR2_TABLE_100
339     , p5_a12 JTF_NUMBER_TABLE
340     , p5_a13 JTF_NUMBER_TABLE
341     , p5_a14 JTF_DATE_TABLE
342     , p5_a15 JTF_NUMBER_TABLE
343     , p5_a16 JTF_DATE_TABLE
344     , p5_a17 JTF_NUMBER_TABLE
345     , p5_a18 JTF_VARCHAR2_TABLE_100
346     , p5_a19 JTF_VARCHAR2_TABLE_100
347     , p5_a20 JTF_VARCHAR2_TABLE_100
348     , p5_a21 JTF_VARCHAR2_TABLE_100
349     , p6_a0 out nocopy JTF_NUMBER_TABLE
350     , p6_a1 out nocopy JTF_NUMBER_TABLE
351     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
352     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
353     , p6_a4 out nocopy JTF_NUMBER_TABLE
354     , p6_a5 out nocopy JTF_NUMBER_TABLE
355     , p6_a6 out nocopy JTF_NUMBER_TABLE
356     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
357     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
358     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
359     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
360     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
361     , p6_a12 out nocopy JTF_NUMBER_TABLE
362     , p6_a13 out nocopy JTF_NUMBER_TABLE
363     , p6_a14 out nocopy JTF_DATE_TABLE
364     , p6_a15 out nocopy JTF_NUMBER_TABLE
365     , p6_a16 out nocopy JTF_DATE_TABLE
366     , p6_a17 out nocopy JTF_NUMBER_TABLE
367     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
368     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
369     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
370     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
371   );
372   procedure delete_row(p_api_version  NUMBER
373     , p_init_msg_list  VARCHAR2
374     , x_return_status out nocopy  VARCHAR2
375     , x_msg_count out nocopy  NUMBER
376     , x_msg_data out nocopy  VARCHAR2
377     , p5_a0  NUMBER := 0-1962.0724
378     , p5_a1  NUMBER := 0-1962.0724
379     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
380     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
381     , p5_a4  NUMBER := 0-1962.0724
382     , p5_a5  NUMBER := 0-1962.0724
383     , p5_a6  NUMBER := 0-1962.0724
384     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
385     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
386     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
387     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
388     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
389     , p5_a12  NUMBER := 0-1962.0724
390     , p5_a13  NUMBER := 0-1962.0724
391     , p5_a14  DATE := fnd_api.g_miss_date
392     , p5_a15  NUMBER := 0-1962.0724
393     , p5_a16  DATE := fnd_api.g_miss_date
394     , p5_a17  NUMBER := 0-1962.0724
395     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
396     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
397     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
398     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
399   );
400   procedure delete_row(p_api_version  NUMBER
401     , p_init_msg_list  VARCHAR2
402     , x_return_status out nocopy  VARCHAR2
403     , x_msg_count out nocopy  NUMBER
404     , x_msg_data out nocopy  VARCHAR2
405     , p5_a0 JTF_NUMBER_TABLE
406     , p5_a1 JTF_NUMBER_TABLE
407     , p5_a2 JTF_VARCHAR2_TABLE_100
408     , p5_a3 JTF_VARCHAR2_TABLE_100
409     , p5_a4 JTF_NUMBER_TABLE
410     , p5_a5 JTF_NUMBER_TABLE
411     , p5_a6 JTF_NUMBER_TABLE
412     , p5_a7 JTF_VARCHAR2_TABLE_100
413     , p5_a8 JTF_VARCHAR2_TABLE_200
414     , p5_a9 JTF_VARCHAR2_TABLE_2000
415     , p5_a10 JTF_VARCHAR2_TABLE_100
416     , p5_a11 JTF_VARCHAR2_TABLE_100
417     , p5_a12 JTF_NUMBER_TABLE
418     , p5_a13 JTF_NUMBER_TABLE
419     , p5_a14 JTF_DATE_TABLE
420     , p5_a15 JTF_NUMBER_TABLE
421     , p5_a16 JTF_DATE_TABLE
422     , p5_a17 JTF_NUMBER_TABLE
423     , p5_a18 JTF_VARCHAR2_TABLE_100
424     , p5_a19 JTF_VARCHAR2_TABLE_100
425     , p5_a20 JTF_VARCHAR2_TABLE_100
426     , p5_a21 JTF_VARCHAR2_TABLE_100
427   );
428   procedure validate_row(p_api_version  NUMBER
429     , p_init_msg_list  VARCHAR2
430     , x_return_status out nocopy  VARCHAR2
431     , x_msg_count out nocopy  NUMBER
432     , x_msg_data out nocopy  VARCHAR2
433     , p5_a0  NUMBER := 0-1962.0724
434     , p5_a1  NUMBER := 0-1962.0724
435     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
436     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
437     , p5_a4  NUMBER := 0-1962.0724
438     , p5_a5  NUMBER := 0-1962.0724
439     , p5_a6  NUMBER := 0-1962.0724
440     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
441     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
442     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
443     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
444     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
445     , p5_a12  NUMBER := 0-1962.0724
446     , p5_a13  NUMBER := 0-1962.0724
447     , p5_a14  DATE := fnd_api.g_miss_date
448     , p5_a15  NUMBER := 0-1962.0724
449     , p5_a16  DATE := fnd_api.g_miss_date
450     , p5_a17  NUMBER := 0-1962.0724
451     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
452     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
453     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
454     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
455   );
456   procedure validate_row(p_api_version  NUMBER
457     , p_init_msg_list  VARCHAR2
458     , x_return_status out nocopy  VARCHAR2
459     , x_msg_count out nocopy  NUMBER
460     , x_msg_data out nocopy  VARCHAR2
461     , p5_a0 JTF_NUMBER_TABLE
462     , p5_a1 JTF_NUMBER_TABLE
463     , p5_a2 JTF_VARCHAR2_TABLE_100
464     , p5_a3 JTF_VARCHAR2_TABLE_100
465     , p5_a4 JTF_NUMBER_TABLE
466     , p5_a5 JTF_NUMBER_TABLE
467     , p5_a6 JTF_NUMBER_TABLE
468     , p5_a7 JTF_VARCHAR2_TABLE_100
469     , p5_a8 JTF_VARCHAR2_TABLE_200
470     , p5_a9 JTF_VARCHAR2_TABLE_2000
471     , p5_a10 JTF_VARCHAR2_TABLE_100
472     , p5_a11 JTF_VARCHAR2_TABLE_100
473     , p5_a12 JTF_NUMBER_TABLE
474     , p5_a13 JTF_NUMBER_TABLE
475     , p5_a14 JTF_DATE_TABLE
476     , p5_a15 JTF_NUMBER_TABLE
477     , p5_a16 JTF_DATE_TABLE
478     , p5_a17 JTF_NUMBER_TABLE
479     , p5_a18 JTF_VARCHAR2_TABLE_100
480     , p5_a19 JTF_VARCHAR2_TABLE_100
481     , p5_a20 JTF_VARCHAR2_TABLE_100
482     , p5_a21 JTF_VARCHAR2_TABLE_100
483   );
484 end okl_try_pvt_w;