[Home] [Help]
PACKAGE: APPS.OKL_BKT_PVT_W
Source
1 package okl_bkt_pvt_w AUTHID CURRENT_USER 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;