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_BKT_PVT_W

Source


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