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_AET_PVT_W

Source


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