[Home] [Help]
PACKAGE: APPS.OKL_BTC_PVT_W
Source
1 package okl_btc_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEBTCS.pls 120.4 2007/09/28 06:48:42 varangan ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_btc_pvt.btc_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
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_NUMBER_TABLE
15 , a12 JTF_DATE_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_500
19 , a16 JTF_VARCHAR2_TABLE_500
20 , a17 JTF_VARCHAR2_TABLE_500
21 , a18 JTF_VARCHAR2_TABLE_500
22 , a19 JTF_VARCHAR2_TABLE_500
23 , a20 JTF_VARCHAR2_TABLE_500
24 , a21 JTF_VARCHAR2_TABLE_500
25 , a22 JTF_VARCHAR2_TABLE_500
26 , a23 JTF_VARCHAR2_TABLE_500
27 , a24 JTF_VARCHAR2_TABLE_500
28 , a25 JTF_VARCHAR2_TABLE_500
29 , a26 JTF_VARCHAR2_TABLE_500
30 , a27 JTF_VARCHAR2_TABLE_500
31 , a28 JTF_VARCHAR2_TABLE_500
32 , a29 JTF_VARCHAR2_TABLE_500
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_DATE_TABLE
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_DATE_TABLE
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_NUMBER_TABLE
41 , a38 JTF_DATE_TABLE
42 , a39 JTF_NUMBER_TABLE
43 );
44 procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45 , a1 out nocopy JTF_NUMBER_TABLE
46 , a2 out nocopy JTF_DATE_TABLE
47 , a3 out nocopy JTF_DATE_TABLE
48 , a4 out nocopy JTF_DATE_TABLE
49 , a5 out nocopy JTF_NUMBER_TABLE
50 , a6 out nocopy JTF_NUMBER_TABLE
51 , a7 out nocopy JTF_VARCHAR2_TABLE_100
52 , a8 out nocopy JTF_NUMBER_TABLE
53 , a9 out nocopy JTF_NUMBER_TABLE
54 , a10 out nocopy JTF_NUMBER_TABLE
55 , a11 out nocopy JTF_NUMBER_TABLE
56 , a12 out nocopy JTF_DATE_TABLE
57 , a13 out nocopy JTF_NUMBER_TABLE
58 , a14 out nocopy JTF_VARCHAR2_TABLE_100
59 , a15 out nocopy JTF_VARCHAR2_TABLE_500
60 , a16 out nocopy JTF_VARCHAR2_TABLE_500
61 , a17 out nocopy JTF_VARCHAR2_TABLE_500
62 , a18 out nocopy JTF_VARCHAR2_TABLE_500
63 , a19 out nocopy JTF_VARCHAR2_TABLE_500
64 , a20 out nocopy JTF_VARCHAR2_TABLE_500
65 , a21 out nocopy JTF_VARCHAR2_TABLE_500
66 , a22 out nocopy JTF_VARCHAR2_TABLE_500
67 , a23 out nocopy JTF_VARCHAR2_TABLE_500
68 , a24 out nocopy JTF_VARCHAR2_TABLE_500
69 , a25 out nocopy JTF_VARCHAR2_TABLE_500
70 , a26 out nocopy JTF_VARCHAR2_TABLE_500
71 , a27 out nocopy JTF_VARCHAR2_TABLE_500
72 , a28 out nocopy JTF_VARCHAR2_TABLE_500
73 , a29 out nocopy JTF_VARCHAR2_TABLE_500
74 , a30 out nocopy JTF_NUMBER_TABLE
75 , a31 out nocopy JTF_DATE_TABLE
76 , a32 out nocopy JTF_NUMBER_TABLE
77 , a33 out nocopy JTF_DATE_TABLE
78 , a34 out nocopy JTF_NUMBER_TABLE
79 , a35 out nocopy JTF_VARCHAR2_TABLE_100
80 , a36 out nocopy JTF_VARCHAR2_TABLE_100
81 , a37 out nocopy JTF_NUMBER_TABLE
82 , a38 out nocopy JTF_DATE_TABLE
83 , a39 out nocopy JTF_NUMBER_TABLE
84 );
85
86 procedure rosetta_table_copy_in_p5(t out nocopy okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 JTF_NUMBER_TABLE
87 , a1 JTF_VARCHAR2_TABLE_100
88 , a2 JTF_VARCHAR2_TABLE_100
89 , a3 JTF_VARCHAR2_TABLE_100
90 , a4 JTF_VARCHAR2_TABLE_200
91 , a5 JTF_VARCHAR2_TABLE_2000
92 , a6 JTF_NUMBER_TABLE
93 , a7 JTF_DATE_TABLE
94 , a8 JTF_NUMBER_TABLE
95 , a9 JTF_DATE_TABLE
96 , a10 JTF_NUMBER_TABLE
97 );
98 procedure rosetta_table_copy_out_p5(t okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99 , a1 out nocopy JTF_VARCHAR2_TABLE_100
100 , a2 out nocopy JTF_VARCHAR2_TABLE_100
101 , a3 out nocopy JTF_VARCHAR2_TABLE_100
102 , a4 out nocopy JTF_VARCHAR2_TABLE_200
103 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
104 , a6 out nocopy JTF_NUMBER_TABLE
105 , a7 out nocopy JTF_DATE_TABLE
106 , a8 out nocopy JTF_NUMBER_TABLE
107 , a9 out nocopy JTF_DATE_TABLE
108 , a10 out nocopy JTF_NUMBER_TABLE
109 );
110
111 procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE
112 , a1 JTF_NUMBER_TABLE
113 , a2 JTF_VARCHAR2_TABLE_100
114 , a3 JTF_VARCHAR2_TABLE_200
115 , a4 JTF_DATE_TABLE
116 , a5 JTF_DATE_TABLE
117 , a6 JTF_DATE_TABLE
118 , a7 JTF_NUMBER_TABLE
119 , a8 JTF_NUMBER_TABLE
120 , a9 JTF_VARCHAR2_TABLE_100
121 , a10 JTF_NUMBER_TABLE
122 , a11 JTF_VARCHAR2_TABLE_2000
123 , a12 JTF_VARCHAR2_TABLE_100
124 , a13 JTF_VARCHAR2_TABLE_500
125 , a14 JTF_VARCHAR2_TABLE_500
126 , a15 JTF_VARCHAR2_TABLE_500
127 , a16 JTF_VARCHAR2_TABLE_500
128 , a17 JTF_VARCHAR2_TABLE_500
129 , a18 JTF_VARCHAR2_TABLE_500
130 , a19 JTF_VARCHAR2_TABLE_500
131 , a20 JTF_VARCHAR2_TABLE_500
132 , a21 JTF_VARCHAR2_TABLE_500
133 , a22 JTF_VARCHAR2_TABLE_500
134 , a23 JTF_VARCHAR2_TABLE_500
135 , a24 JTF_VARCHAR2_TABLE_500
136 , a25 JTF_VARCHAR2_TABLE_500
137 , a26 JTF_VARCHAR2_TABLE_500
138 , a27 JTF_VARCHAR2_TABLE_500
139 , a28 JTF_NUMBER_TABLE
140 , a29 JTF_NUMBER_TABLE
141 , a30 JTF_NUMBER_TABLE
142 , a31 JTF_DATE_TABLE
143 , a32 JTF_NUMBER_TABLE
144 , a33 JTF_NUMBER_TABLE
145 , a34 JTF_DATE_TABLE
146 , a35 JTF_NUMBER_TABLE
147 , a36 JTF_DATE_TABLE
148 , a37 JTF_NUMBER_TABLE
149 , a38 JTF_VARCHAR2_TABLE_100
150 , a39 JTF_VARCHAR2_TABLE_100
151 , a40 JTF_NUMBER_TABLE
152 , a41 JTF_DATE_TABLE
153 , a42 JTF_NUMBER_TABLE
154 );
155 procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
156 , a1 out nocopy JTF_NUMBER_TABLE
157 , a2 out nocopy JTF_VARCHAR2_TABLE_100
158 , a3 out nocopy JTF_VARCHAR2_TABLE_200
159 , a4 out nocopy JTF_DATE_TABLE
160 , a5 out nocopy JTF_DATE_TABLE
161 , a6 out nocopy JTF_DATE_TABLE
162 , a7 out nocopy JTF_NUMBER_TABLE
163 , a8 out nocopy JTF_NUMBER_TABLE
164 , a9 out nocopy JTF_VARCHAR2_TABLE_100
165 , a10 out nocopy JTF_NUMBER_TABLE
166 , a11 out nocopy JTF_VARCHAR2_TABLE_2000
167 , a12 out nocopy JTF_VARCHAR2_TABLE_100
168 , a13 out nocopy JTF_VARCHAR2_TABLE_500
169 , a14 out nocopy JTF_VARCHAR2_TABLE_500
170 , a15 out nocopy JTF_VARCHAR2_TABLE_500
171 , a16 out nocopy JTF_VARCHAR2_TABLE_500
172 , a17 out nocopy JTF_VARCHAR2_TABLE_500
173 , a18 out nocopy JTF_VARCHAR2_TABLE_500
174 , a19 out nocopy JTF_VARCHAR2_TABLE_500
175 , a20 out nocopy JTF_VARCHAR2_TABLE_500
176 , a21 out nocopy JTF_VARCHAR2_TABLE_500
177 , a22 out nocopy JTF_VARCHAR2_TABLE_500
178 , a23 out nocopy JTF_VARCHAR2_TABLE_500
179 , a24 out nocopy JTF_VARCHAR2_TABLE_500
180 , a25 out nocopy JTF_VARCHAR2_TABLE_500
181 , a26 out nocopy JTF_VARCHAR2_TABLE_500
182 , a27 out nocopy JTF_VARCHAR2_TABLE_500
183 , a28 out nocopy JTF_NUMBER_TABLE
184 , a29 out nocopy JTF_NUMBER_TABLE
185 , a30 out nocopy JTF_NUMBER_TABLE
186 , a31 out nocopy JTF_DATE_TABLE
187 , a32 out nocopy JTF_NUMBER_TABLE
188 , a33 out nocopy JTF_NUMBER_TABLE
189 , a34 out nocopy JTF_DATE_TABLE
190 , a35 out nocopy JTF_NUMBER_TABLE
191 , a36 out nocopy JTF_DATE_TABLE
192 , a37 out nocopy JTF_NUMBER_TABLE
193 , a38 out nocopy JTF_VARCHAR2_TABLE_100
194 , a39 out nocopy JTF_VARCHAR2_TABLE_100
195 , a40 out nocopy JTF_NUMBER_TABLE
196 , a41 out nocopy JTF_DATE_TABLE
197 , a42 out nocopy JTF_NUMBER_TABLE
198 );
199
200 procedure insert_row(p_api_version NUMBER
201 , p_init_msg_list VARCHAR2
202 , x_return_status out nocopy VARCHAR2
203 , x_msg_count out nocopy NUMBER
204 , x_msg_data out nocopy VARCHAR2
205 , p6_a0 out nocopy NUMBER
206 , p6_a1 out nocopy NUMBER
207 , p6_a2 out nocopy VARCHAR2
208 , p6_a3 out nocopy VARCHAR2
209 , p6_a4 out nocopy DATE
210 , p6_a5 out nocopy DATE
211 , p6_a6 out nocopy DATE
212 , p6_a7 out nocopy NUMBER
213 , p6_a8 out nocopy NUMBER
214 , p6_a9 out nocopy VARCHAR2
215 , p6_a10 out nocopy NUMBER
216 , p6_a11 out nocopy VARCHAR2
217 , p6_a12 out nocopy VARCHAR2
218 , p6_a13 out nocopy VARCHAR2
219 , p6_a14 out nocopy VARCHAR2
220 , p6_a15 out nocopy VARCHAR2
221 , p6_a16 out nocopy VARCHAR2
222 , p6_a17 out nocopy VARCHAR2
223 , p6_a18 out nocopy VARCHAR2
224 , p6_a19 out nocopy VARCHAR2
225 , p6_a20 out nocopy VARCHAR2
226 , p6_a21 out nocopy VARCHAR2
227 , p6_a22 out nocopy VARCHAR2
228 , p6_a23 out nocopy VARCHAR2
229 , p6_a24 out nocopy VARCHAR2
230 , p6_a25 out nocopy VARCHAR2
231 , p6_a26 out nocopy VARCHAR2
232 , p6_a27 out nocopy VARCHAR2
233 , p6_a28 out nocopy NUMBER
234 , p6_a29 out nocopy NUMBER
235 , p6_a30 out nocopy NUMBER
236 , p6_a31 out nocopy DATE
237 , p6_a32 out nocopy NUMBER
238 , p6_a33 out nocopy NUMBER
239 , p6_a34 out nocopy DATE
240 , p6_a35 out nocopy NUMBER
241 , p6_a36 out nocopy DATE
242 , p6_a37 out nocopy NUMBER
243 , p6_a38 out nocopy VARCHAR2
244 , p6_a39 out nocopy VARCHAR2
245 , p6_a40 out nocopy NUMBER
246 , p6_a41 out nocopy DATE
247 , p6_a42 out nocopy NUMBER
248 , p5_a0 NUMBER := 0-1962.0724
249 , p5_a1 NUMBER := 0-1962.0724
250 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
251 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
252 , p5_a4 DATE := fnd_api.g_miss_date
253 , p5_a5 DATE := fnd_api.g_miss_date
254 , p5_a6 DATE := fnd_api.g_miss_date
255 , p5_a7 NUMBER := 0-1962.0724
256 , p5_a8 NUMBER := 0-1962.0724
257 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
258 , p5_a10 NUMBER := 0-1962.0724
259 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
260 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
261 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
262 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
263 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
264 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
265 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
266 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
267 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
269 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
270 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
271 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a28 NUMBER := 0-1962.0724
277 , p5_a29 NUMBER := 0-1962.0724
278 , p5_a30 NUMBER := 0-1962.0724
279 , p5_a31 DATE := fnd_api.g_miss_date
280 , p5_a32 NUMBER := 0-1962.0724
281 , p5_a33 NUMBER := 0-1962.0724
282 , p5_a34 DATE := fnd_api.g_miss_date
283 , p5_a35 NUMBER := 0-1962.0724
284 , p5_a36 DATE := fnd_api.g_miss_date
285 , p5_a37 NUMBER := 0-1962.0724
286 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
288 , p5_a40 NUMBER := 0-1962.0724
289 , p5_a41 DATE := fnd_api.g_miss_date
290 , p5_a42 NUMBER := 0-1962.0724
291 );
292 procedure insert_row(p_api_version NUMBER
293 , p_init_msg_list VARCHAR2
294 , x_return_status out nocopy VARCHAR2
295 , x_msg_count out nocopy NUMBER
296 , x_msg_data out nocopy VARCHAR2
297 , p5_a0 JTF_NUMBER_TABLE
298 , p5_a1 JTF_NUMBER_TABLE
299 , p5_a2 JTF_VARCHAR2_TABLE_100
300 , p5_a3 JTF_VARCHAR2_TABLE_200
301 , p5_a4 JTF_DATE_TABLE
302 , p5_a5 JTF_DATE_TABLE
303 , p5_a6 JTF_DATE_TABLE
304 , p5_a7 JTF_NUMBER_TABLE
305 , p5_a8 JTF_NUMBER_TABLE
306 , p5_a9 JTF_VARCHAR2_TABLE_100
307 , p5_a10 JTF_NUMBER_TABLE
308 , p5_a11 JTF_VARCHAR2_TABLE_2000
309 , p5_a12 JTF_VARCHAR2_TABLE_100
310 , p5_a13 JTF_VARCHAR2_TABLE_500
311 , p5_a14 JTF_VARCHAR2_TABLE_500
312 , p5_a15 JTF_VARCHAR2_TABLE_500
313 , p5_a16 JTF_VARCHAR2_TABLE_500
314 , p5_a17 JTF_VARCHAR2_TABLE_500
315 , p5_a18 JTF_VARCHAR2_TABLE_500
316 , p5_a19 JTF_VARCHAR2_TABLE_500
317 , p5_a20 JTF_VARCHAR2_TABLE_500
318 , p5_a21 JTF_VARCHAR2_TABLE_500
319 , p5_a22 JTF_VARCHAR2_TABLE_500
320 , p5_a23 JTF_VARCHAR2_TABLE_500
321 , p5_a24 JTF_VARCHAR2_TABLE_500
322 , p5_a25 JTF_VARCHAR2_TABLE_500
323 , p5_a26 JTF_VARCHAR2_TABLE_500
324 , p5_a27 JTF_VARCHAR2_TABLE_500
325 , p5_a28 JTF_NUMBER_TABLE
326 , p5_a29 JTF_NUMBER_TABLE
327 , p5_a30 JTF_NUMBER_TABLE
328 , p5_a31 JTF_DATE_TABLE
329 , p5_a32 JTF_NUMBER_TABLE
330 , p5_a33 JTF_NUMBER_TABLE
331 , p5_a34 JTF_DATE_TABLE
332 , p5_a35 JTF_NUMBER_TABLE
333 , p5_a36 JTF_DATE_TABLE
334 , p5_a37 JTF_NUMBER_TABLE
335 , p5_a38 JTF_VARCHAR2_TABLE_100
336 , p5_a39 JTF_VARCHAR2_TABLE_100
337 , p5_a40 JTF_NUMBER_TABLE
338 , p5_a41 JTF_DATE_TABLE
339 , p5_a42 JTF_NUMBER_TABLE
340 , p6_a0 out nocopy JTF_NUMBER_TABLE
341 , p6_a1 out nocopy JTF_NUMBER_TABLE
342 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
344 , p6_a4 out nocopy JTF_DATE_TABLE
345 , p6_a5 out nocopy JTF_DATE_TABLE
346 , p6_a6 out nocopy JTF_DATE_TABLE
347 , p6_a7 out nocopy JTF_NUMBER_TABLE
348 , p6_a8 out nocopy JTF_NUMBER_TABLE
349 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
350 , p6_a10 out nocopy JTF_NUMBER_TABLE
351 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
352 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
353 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
354 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
355 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
356 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
357 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
358 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
359 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
360 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
361 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
362 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
363 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
364 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
365 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
366 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
367 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
368 , p6_a28 out nocopy JTF_NUMBER_TABLE
369 , p6_a29 out nocopy JTF_NUMBER_TABLE
370 , p6_a30 out nocopy JTF_NUMBER_TABLE
371 , p6_a31 out nocopy JTF_DATE_TABLE
372 , p6_a32 out nocopy JTF_NUMBER_TABLE
373 , p6_a33 out nocopy JTF_NUMBER_TABLE
374 , p6_a34 out nocopy JTF_DATE_TABLE
375 , p6_a35 out nocopy JTF_NUMBER_TABLE
376 , p6_a36 out nocopy JTF_DATE_TABLE
377 , p6_a37 out nocopy JTF_NUMBER_TABLE
378 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
379 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380 , p6_a40 out nocopy JTF_NUMBER_TABLE
381 , p6_a41 out nocopy JTF_DATE_TABLE
382 , p6_a42 out nocopy JTF_NUMBER_TABLE
383 );
384 procedure lock_row(p_api_version NUMBER
385 , p_init_msg_list VARCHAR2
386 , x_return_status out nocopy VARCHAR2
387 , x_msg_count out nocopy NUMBER
388 , x_msg_data out nocopy VARCHAR2
389 , p5_a0 NUMBER := 0-1962.0724
390 , p5_a1 NUMBER := 0-1962.0724
391 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
392 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a4 DATE := fnd_api.g_miss_date
394 , p5_a5 DATE := fnd_api.g_miss_date
395 , p5_a6 DATE := fnd_api.g_miss_date
396 , p5_a7 NUMBER := 0-1962.0724
397 , p5_a8 NUMBER := 0-1962.0724
398 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
399 , p5_a10 NUMBER := 0-1962.0724
400 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
401 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
402 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
403 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
404 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
405 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
406 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
407 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
408 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
409 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
410 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
411 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
412 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
413 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
414 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
415 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
416 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
417 , p5_a28 NUMBER := 0-1962.0724
418 , p5_a29 NUMBER := 0-1962.0724
419 , p5_a30 NUMBER := 0-1962.0724
420 , p5_a31 DATE := fnd_api.g_miss_date
421 , p5_a32 NUMBER := 0-1962.0724
422 , p5_a33 NUMBER := 0-1962.0724
423 , p5_a34 DATE := fnd_api.g_miss_date
424 , p5_a35 NUMBER := 0-1962.0724
425 , p5_a36 DATE := fnd_api.g_miss_date
426 , p5_a37 NUMBER := 0-1962.0724
427 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
428 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
429 , p5_a40 NUMBER := 0-1962.0724
430 , p5_a41 DATE := fnd_api.g_miss_date
431 , p5_a42 NUMBER := 0-1962.0724
432 );
433 procedure lock_row(p_api_version NUMBER
434 , p_init_msg_list VARCHAR2
435 , x_return_status out nocopy VARCHAR2
436 , x_msg_count out nocopy NUMBER
437 , x_msg_data out nocopy VARCHAR2
438 , p5_a0 JTF_NUMBER_TABLE
439 , p5_a1 JTF_NUMBER_TABLE
440 , p5_a2 JTF_VARCHAR2_TABLE_100
441 , p5_a3 JTF_VARCHAR2_TABLE_200
442 , p5_a4 JTF_DATE_TABLE
443 , p5_a5 JTF_DATE_TABLE
444 , p5_a6 JTF_DATE_TABLE
445 , p5_a7 JTF_NUMBER_TABLE
446 , p5_a8 JTF_NUMBER_TABLE
447 , p5_a9 JTF_VARCHAR2_TABLE_100
448 , p5_a10 JTF_NUMBER_TABLE
449 , p5_a11 JTF_VARCHAR2_TABLE_2000
450 , p5_a12 JTF_VARCHAR2_TABLE_100
451 , p5_a13 JTF_VARCHAR2_TABLE_500
452 , p5_a14 JTF_VARCHAR2_TABLE_500
453 , p5_a15 JTF_VARCHAR2_TABLE_500
454 , p5_a16 JTF_VARCHAR2_TABLE_500
455 , p5_a17 JTF_VARCHAR2_TABLE_500
456 , p5_a18 JTF_VARCHAR2_TABLE_500
457 , p5_a19 JTF_VARCHAR2_TABLE_500
458 , p5_a20 JTF_VARCHAR2_TABLE_500
459 , p5_a21 JTF_VARCHAR2_TABLE_500
460 , p5_a22 JTF_VARCHAR2_TABLE_500
461 , p5_a23 JTF_VARCHAR2_TABLE_500
462 , p5_a24 JTF_VARCHAR2_TABLE_500
463 , p5_a25 JTF_VARCHAR2_TABLE_500
464 , p5_a26 JTF_VARCHAR2_TABLE_500
465 , p5_a27 JTF_VARCHAR2_TABLE_500
466 , p5_a28 JTF_NUMBER_TABLE
467 , p5_a29 JTF_NUMBER_TABLE
468 , p5_a30 JTF_NUMBER_TABLE
469 , p5_a31 JTF_DATE_TABLE
470 , p5_a32 JTF_NUMBER_TABLE
471 , p5_a33 JTF_NUMBER_TABLE
472 , p5_a34 JTF_DATE_TABLE
473 , p5_a35 JTF_NUMBER_TABLE
474 , p5_a36 JTF_DATE_TABLE
475 , p5_a37 JTF_NUMBER_TABLE
476 , p5_a38 JTF_VARCHAR2_TABLE_100
477 , p5_a39 JTF_VARCHAR2_TABLE_100
478 , p5_a40 JTF_NUMBER_TABLE
479 , p5_a41 JTF_DATE_TABLE
480 , p5_a42 JTF_NUMBER_TABLE
481 );
482 procedure update_row(p_api_version NUMBER
483 , p_init_msg_list VARCHAR2
484 , x_return_status out nocopy VARCHAR2
485 , x_msg_count out nocopy NUMBER
486 , x_msg_data out nocopy VARCHAR2
487 , p6_a0 out nocopy NUMBER
488 , p6_a1 out nocopy NUMBER
489 , p6_a2 out nocopy VARCHAR2
490 , p6_a3 out nocopy VARCHAR2
491 , p6_a4 out nocopy DATE
492 , p6_a5 out nocopy DATE
493 , p6_a6 out nocopy DATE
494 , p6_a7 out nocopy NUMBER
495 , p6_a8 out nocopy NUMBER
496 , p6_a9 out nocopy VARCHAR2
497 , p6_a10 out nocopy NUMBER
498 , p6_a11 out nocopy VARCHAR2
499 , p6_a12 out nocopy VARCHAR2
500 , p6_a13 out nocopy VARCHAR2
501 , p6_a14 out nocopy VARCHAR2
502 , p6_a15 out nocopy VARCHAR2
503 , p6_a16 out nocopy VARCHAR2
504 , p6_a17 out nocopy VARCHAR2
505 , p6_a18 out nocopy VARCHAR2
506 , p6_a19 out nocopy VARCHAR2
507 , p6_a20 out nocopy VARCHAR2
508 , p6_a21 out nocopy VARCHAR2
509 , p6_a22 out nocopy VARCHAR2
510 , p6_a23 out nocopy VARCHAR2
511 , p6_a24 out nocopy VARCHAR2
512 , p6_a25 out nocopy VARCHAR2
513 , p6_a26 out nocopy VARCHAR2
514 , p6_a27 out nocopy VARCHAR2
515 , p6_a28 out nocopy NUMBER
516 , p6_a29 out nocopy NUMBER
517 , p6_a30 out nocopy NUMBER
518 , p6_a31 out nocopy DATE
519 , p6_a32 out nocopy NUMBER
520 , p6_a33 out nocopy NUMBER
521 , p6_a34 out nocopy DATE
522 , p6_a35 out nocopy NUMBER
523 , p6_a36 out nocopy DATE
524 , p6_a37 out nocopy NUMBER
525 , p6_a38 out nocopy VARCHAR2
526 , p6_a39 out nocopy VARCHAR2
527 , p6_a40 out nocopy NUMBER
528 , p6_a41 out nocopy DATE
529 , p6_a42 out nocopy NUMBER
530 , p5_a0 NUMBER := 0-1962.0724
531 , p5_a1 NUMBER := 0-1962.0724
532 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
533 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
534 , p5_a4 DATE := fnd_api.g_miss_date
535 , p5_a5 DATE := fnd_api.g_miss_date
536 , p5_a6 DATE := fnd_api.g_miss_date
537 , p5_a7 NUMBER := 0-1962.0724
538 , p5_a8 NUMBER := 0-1962.0724
539 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
540 , p5_a10 NUMBER := 0-1962.0724
541 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
542 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
543 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
544 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
545 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
546 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
547 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
548 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
549 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
550 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
551 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
552 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
553 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
554 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
555 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
556 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
557 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
558 , p5_a28 NUMBER := 0-1962.0724
559 , p5_a29 NUMBER := 0-1962.0724
560 , p5_a30 NUMBER := 0-1962.0724
561 , p5_a31 DATE := fnd_api.g_miss_date
562 , p5_a32 NUMBER := 0-1962.0724
563 , p5_a33 NUMBER := 0-1962.0724
564 , p5_a34 DATE := fnd_api.g_miss_date
565 , p5_a35 NUMBER := 0-1962.0724
566 , p5_a36 DATE := fnd_api.g_miss_date
567 , p5_a37 NUMBER := 0-1962.0724
568 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
569 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a40 NUMBER := 0-1962.0724
571 , p5_a41 DATE := fnd_api.g_miss_date
572 , p5_a42 NUMBER := 0-1962.0724
573 );
574 procedure update_row(p_api_version NUMBER
575 , p_init_msg_list VARCHAR2
576 , x_return_status out nocopy VARCHAR2
577 , x_msg_count out nocopy NUMBER
578 , x_msg_data out nocopy VARCHAR2
579 , p5_a0 JTF_NUMBER_TABLE
580 , p5_a1 JTF_NUMBER_TABLE
581 , p5_a2 JTF_VARCHAR2_TABLE_100
582 , p5_a3 JTF_VARCHAR2_TABLE_200
583 , p5_a4 JTF_DATE_TABLE
584 , p5_a5 JTF_DATE_TABLE
585 , p5_a6 JTF_DATE_TABLE
586 , p5_a7 JTF_NUMBER_TABLE
587 , p5_a8 JTF_NUMBER_TABLE
588 , p5_a9 JTF_VARCHAR2_TABLE_100
589 , p5_a10 JTF_NUMBER_TABLE
590 , p5_a11 JTF_VARCHAR2_TABLE_2000
591 , p5_a12 JTF_VARCHAR2_TABLE_100
592 , p5_a13 JTF_VARCHAR2_TABLE_500
593 , p5_a14 JTF_VARCHAR2_TABLE_500
594 , p5_a15 JTF_VARCHAR2_TABLE_500
595 , p5_a16 JTF_VARCHAR2_TABLE_500
596 , p5_a17 JTF_VARCHAR2_TABLE_500
597 , p5_a18 JTF_VARCHAR2_TABLE_500
598 , p5_a19 JTF_VARCHAR2_TABLE_500
599 , p5_a20 JTF_VARCHAR2_TABLE_500
600 , p5_a21 JTF_VARCHAR2_TABLE_500
601 , p5_a22 JTF_VARCHAR2_TABLE_500
602 , p5_a23 JTF_VARCHAR2_TABLE_500
603 , p5_a24 JTF_VARCHAR2_TABLE_500
604 , p5_a25 JTF_VARCHAR2_TABLE_500
605 , p5_a26 JTF_VARCHAR2_TABLE_500
606 , p5_a27 JTF_VARCHAR2_TABLE_500
607 , p5_a28 JTF_NUMBER_TABLE
608 , p5_a29 JTF_NUMBER_TABLE
609 , p5_a30 JTF_NUMBER_TABLE
610 , p5_a31 JTF_DATE_TABLE
611 , p5_a32 JTF_NUMBER_TABLE
612 , p5_a33 JTF_NUMBER_TABLE
613 , p5_a34 JTF_DATE_TABLE
614 , p5_a35 JTF_NUMBER_TABLE
615 , p5_a36 JTF_DATE_TABLE
616 , p5_a37 JTF_NUMBER_TABLE
617 , p5_a38 JTF_VARCHAR2_TABLE_100
618 , p5_a39 JTF_VARCHAR2_TABLE_100
619 , p5_a40 JTF_NUMBER_TABLE
620 , p5_a41 JTF_DATE_TABLE
621 , p5_a42 JTF_NUMBER_TABLE
622 , p6_a0 out nocopy JTF_NUMBER_TABLE
623 , p6_a1 out nocopy JTF_NUMBER_TABLE
624 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
625 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
626 , p6_a4 out nocopy JTF_DATE_TABLE
627 , p6_a5 out nocopy JTF_DATE_TABLE
628 , p6_a6 out nocopy JTF_DATE_TABLE
629 , p6_a7 out nocopy JTF_NUMBER_TABLE
630 , p6_a8 out nocopy JTF_NUMBER_TABLE
631 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
632 , p6_a10 out nocopy JTF_NUMBER_TABLE
633 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_2000
634 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
635 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
636 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
637 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
638 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
639 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
640 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
641 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
642 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
643 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
644 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
645 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
646 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
647 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
648 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
649 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
650 , p6_a28 out nocopy JTF_NUMBER_TABLE
651 , p6_a29 out nocopy JTF_NUMBER_TABLE
652 , p6_a30 out nocopy JTF_NUMBER_TABLE
653 , p6_a31 out nocopy JTF_DATE_TABLE
654 , p6_a32 out nocopy JTF_NUMBER_TABLE
655 , p6_a33 out nocopy JTF_NUMBER_TABLE
656 , p6_a34 out nocopy JTF_DATE_TABLE
657 , p6_a35 out nocopy JTF_NUMBER_TABLE
658 , p6_a36 out nocopy JTF_DATE_TABLE
659 , p6_a37 out nocopy JTF_NUMBER_TABLE
660 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
661 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
662 , p6_a40 out nocopy JTF_NUMBER_TABLE
663 , p6_a41 out nocopy JTF_DATE_TABLE
664 , p6_a42 out nocopy JTF_NUMBER_TABLE
665 );
666 procedure delete_row(p_api_version NUMBER
667 , p_init_msg_list VARCHAR2
668 , x_return_status out nocopy VARCHAR2
669 , x_msg_count out nocopy NUMBER
670 , x_msg_data out nocopy VARCHAR2
671 , p5_a0 NUMBER := 0-1962.0724
672 , p5_a1 NUMBER := 0-1962.0724
673 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
674 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a4 DATE := fnd_api.g_miss_date
676 , p5_a5 DATE := fnd_api.g_miss_date
677 , p5_a6 DATE := fnd_api.g_miss_date
678 , p5_a7 NUMBER := 0-1962.0724
679 , p5_a8 NUMBER := 0-1962.0724
680 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a10 NUMBER := 0-1962.0724
682 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
683 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
684 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
685 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
686 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
687 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
688 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
689 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
690 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
691 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
692 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
693 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
694 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
695 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
696 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
697 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
698 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
699 , p5_a28 NUMBER := 0-1962.0724
700 , p5_a29 NUMBER := 0-1962.0724
701 , p5_a30 NUMBER := 0-1962.0724
702 , p5_a31 DATE := fnd_api.g_miss_date
703 , p5_a32 NUMBER := 0-1962.0724
704 , p5_a33 NUMBER := 0-1962.0724
705 , p5_a34 DATE := fnd_api.g_miss_date
706 , p5_a35 NUMBER := 0-1962.0724
707 , p5_a36 DATE := fnd_api.g_miss_date
708 , p5_a37 NUMBER := 0-1962.0724
709 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
710 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
711 , p5_a40 NUMBER := 0-1962.0724
712 , p5_a41 DATE := fnd_api.g_miss_date
713 , p5_a42 NUMBER := 0-1962.0724
714 );
715 procedure delete_row(p_api_version NUMBER
716 , p_init_msg_list VARCHAR2
717 , x_return_status out nocopy VARCHAR2
718 , x_msg_count out nocopy NUMBER
719 , x_msg_data out nocopy VARCHAR2
720 , p5_a0 JTF_NUMBER_TABLE
721 , p5_a1 JTF_NUMBER_TABLE
722 , p5_a2 JTF_VARCHAR2_TABLE_100
723 , p5_a3 JTF_VARCHAR2_TABLE_200
724 , p5_a4 JTF_DATE_TABLE
725 , p5_a5 JTF_DATE_TABLE
726 , p5_a6 JTF_DATE_TABLE
727 , p5_a7 JTF_NUMBER_TABLE
728 , p5_a8 JTF_NUMBER_TABLE
729 , p5_a9 JTF_VARCHAR2_TABLE_100
730 , p5_a10 JTF_NUMBER_TABLE
731 , p5_a11 JTF_VARCHAR2_TABLE_2000
732 , p5_a12 JTF_VARCHAR2_TABLE_100
733 , p5_a13 JTF_VARCHAR2_TABLE_500
734 , p5_a14 JTF_VARCHAR2_TABLE_500
735 , p5_a15 JTF_VARCHAR2_TABLE_500
736 , p5_a16 JTF_VARCHAR2_TABLE_500
737 , p5_a17 JTF_VARCHAR2_TABLE_500
738 , p5_a18 JTF_VARCHAR2_TABLE_500
739 , p5_a19 JTF_VARCHAR2_TABLE_500
740 , p5_a20 JTF_VARCHAR2_TABLE_500
741 , p5_a21 JTF_VARCHAR2_TABLE_500
742 , p5_a22 JTF_VARCHAR2_TABLE_500
743 , p5_a23 JTF_VARCHAR2_TABLE_500
744 , p5_a24 JTF_VARCHAR2_TABLE_500
745 , p5_a25 JTF_VARCHAR2_TABLE_500
746 , p5_a26 JTF_VARCHAR2_TABLE_500
747 , p5_a27 JTF_VARCHAR2_TABLE_500
748 , p5_a28 JTF_NUMBER_TABLE
749 , p5_a29 JTF_NUMBER_TABLE
750 , p5_a30 JTF_NUMBER_TABLE
751 , p5_a31 JTF_DATE_TABLE
752 , p5_a32 JTF_NUMBER_TABLE
753 , p5_a33 JTF_NUMBER_TABLE
754 , p5_a34 JTF_DATE_TABLE
755 , p5_a35 JTF_NUMBER_TABLE
756 , p5_a36 JTF_DATE_TABLE
757 , p5_a37 JTF_NUMBER_TABLE
758 , p5_a38 JTF_VARCHAR2_TABLE_100
759 , p5_a39 JTF_VARCHAR2_TABLE_100
760 , p5_a40 JTF_NUMBER_TABLE
761 , p5_a41 JTF_DATE_TABLE
762 , p5_a42 JTF_NUMBER_TABLE
763 );
764 procedure validate_row(p_api_version NUMBER
765 , p_init_msg_list VARCHAR2
766 , x_return_status out nocopy VARCHAR2
767 , x_msg_count out nocopy NUMBER
768 , x_msg_data out nocopy VARCHAR2
769 , p5_a0 NUMBER := 0-1962.0724
770 , p5_a1 NUMBER := 0-1962.0724
771 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a4 DATE := fnd_api.g_miss_date
774 , p5_a5 DATE := fnd_api.g_miss_date
775 , p5_a6 DATE := fnd_api.g_miss_date
776 , p5_a7 NUMBER := 0-1962.0724
777 , p5_a8 NUMBER := 0-1962.0724
778 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a10 NUMBER := 0-1962.0724
780 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
781 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
782 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
783 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
784 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
785 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
786 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
787 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
788 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
789 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
790 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
791 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
792 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
793 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
794 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
795 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
796 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
797 , p5_a28 NUMBER := 0-1962.0724
798 , p5_a29 NUMBER := 0-1962.0724
799 , p5_a30 NUMBER := 0-1962.0724
800 , p5_a31 DATE := fnd_api.g_miss_date
801 , p5_a32 NUMBER := 0-1962.0724
802 , p5_a33 NUMBER := 0-1962.0724
803 , p5_a34 DATE := fnd_api.g_miss_date
804 , p5_a35 NUMBER := 0-1962.0724
805 , p5_a36 DATE := fnd_api.g_miss_date
806 , p5_a37 NUMBER := 0-1962.0724
807 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
808 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
809 , p5_a40 NUMBER := 0-1962.0724
810 , p5_a41 DATE := fnd_api.g_miss_date
811 , p5_a42 NUMBER := 0-1962.0724
812 );
813 procedure validate_row(p_api_version NUMBER
814 , p_init_msg_list VARCHAR2
815 , x_return_status out nocopy VARCHAR2
816 , x_msg_count out nocopy NUMBER
817 , x_msg_data out nocopy VARCHAR2
818 , p5_a0 JTF_NUMBER_TABLE
819 , p5_a1 JTF_NUMBER_TABLE
820 , p5_a2 JTF_VARCHAR2_TABLE_100
821 , p5_a3 JTF_VARCHAR2_TABLE_200
822 , p5_a4 JTF_DATE_TABLE
823 , p5_a5 JTF_DATE_TABLE
824 , p5_a6 JTF_DATE_TABLE
825 , p5_a7 JTF_NUMBER_TABLE
826 , p5_a8 JTF_NUMBER_TABLE
827 , p5_a9 JTF_VARCHAR2_TABLE_100
828 , p5_a10 JTF_NUMBER_TABLE
829 , p5_a11 JTF_VARCHAR2_TABLE_2000
830 , p5_a12 JTF_VARCHAR2_TABLE_100
831 , p5_a13 JTF_VARCHAR2_TABLE_500
832 , p5_a14 JTF_VARCHAR2_TABLE_500
833 , p5_a15 JTF_VARCHAR2_TABLE_500
834 , p5_a16 JTF_VARCHAR2_TABLE_500
835 , p5_a17 JTF_VARCHAR2_TABLE_500
836 , p5_a18 JTF_VARCHAR2_TABLE_500
837 , p5_a19 JTF_VARCHAR2_TABLE_500
838 , p5_a20 JTF_VARCHAR2_TABLE_500
839 , p5_a21 JTF_VARCHAR2_TABLE_500
840 , p5_a22 JTF_VARCHAR2_TABLE_500
841 , p5_a23 JTF_VARCHAR2_TABLE_500
842 , p5_a24 JTF_VARCHAR2_TABLE_500
843 , p5_a25 JTF_VARCHAR2_TABLE_500
844 , p5_a26 JTF_VARCHAR2_TABLE_500
845 , p5_a27 JTF_VARCHAR2_TABLE_500
846 , p5_a28 JTF_NUMBER_TABLE
847 , p5_a29 JTF_NUMBER_TABLE
848 , p5_a30 JTF_NUMBER_TABLE
849 , p5_a31 JTF_DATE_TABLE
850 , p5_a32 JTF_NUMBER_TABLE
851 , p5_a33 JTF_NUMBER_TABLE
852 , p5_a34 JTF_DATE_TABLE
853 , p5_a35 JTF_NUMBER_TABLE
854 , p5_a36 JTF_DATE_TABLE
855 , p5_a37 JTF_NUMBER_TABLE
856 , p5_a38 JTF_VARCHAR2_TABLE_100
857 , p5_a39 JTF_VARCHAR2_TABLE_100
858 , p5_a40 JTF_NUMBER_TABLE
859 , p5_a41 JTF_DATE_TABLE
860 , p5_a42 JTF_NUMBER_TABLE
861 );
862 end okl_btc_pvt_w;