DBA Data[Home] [Help]

PACKAGE: APPS.OKL_OPD_PVT_W

Source


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