[Home] [Help]
PACKAGE: APPS.OKL_AET_PVT_W
Source
1 package okl_aet_pvt_w 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;