[Home] [Help]
PACKAGE: APPS.OKL_KRP_PVT_W
Source
1 package okl_krp_pvt_w as
2 /* $Header: OKLEKRPS.pls 120.2 2005/11/22 23:39:31 ramurt noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_krp_pvt.krpv_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_VARCHAR2_TABLE_100
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_VARCHAR2_TABLE_100
30 , a27 JTF_VARCHAR2_TABLE_100
31 , a28 JTF_VARCHAR2_TABLE_500
32 , a29 JTF_VARCHAR2_TABLE_500
33 , a30 JTF_VARCHAR2_TABLE_500
34 , a31 JTF_VARCHAR2_TABLE_500
35 , a32 JTF_VARCHAR2_TABLE_500
36 , a33 JTF_VARCHAR2_TABLE_500
37 , a34 JTF_VARCHAR2_TABLE_500
38 , a35 JTF_VARCHAR2_TABLE_500
39 , a36 JTF_VARCHAR2_TABLE_500
40 , a37 JTF_VARCHAR2_TABLE_500
41 , a38 JTF_VARCHAR2_TABLE_500
42 , a39 JTF_VARCHAR2_TABLE_500
43 , a40 JTF_VARCHAR2_TABLE_500
44 , a41 JTF_VARCHAR2_TABLE_500
45 , a42 JTF_VARCHAR2_TABLE_500
46 , a43 JTF_NUMBER_TABLE
47 , a44 JTF_DATE_TABLE
48 , a45 JTF_NUMBER_TABLE
49 , a46 JTF_DATE_TABLE
50 , a47 JTF_NUMBER_TABLE
51 , a48 JTF_VARCHAR2_TABLE_100
52 );
53 procedure rosetta_table_copy_out_p2(t okl_krp_pvt.krpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54 , a1 out nocopy JTF_VARCHAR2_TABLE_100
55 , a2 out nocopy JTF_DATE_TABLE
56 , a3 out nocopy JTF_DATE_TABLE
57 , a4 out nocopy JTF_NUMBER_TABLE
58 , a5 out nocopy JTF_NUMBER_TABLE
59 , a6 out nocopy JTF_DATE_TABLE
60 , a7 out nocopy JTF_NUMBER_TABLE
61 , a8 out nocopy JTF_NUMBER_TABLE
62 , a9 out nocopy JTF_NUMBER_TABLE
63 , a10 out nocopy JTF_VARCHAR2_TABLE_100
64 , a11 out nocopy JTF_VARCHAR2_TABLE_100
65 , a12 out nocopy JTF_VARCHAR2_TABLE_100
66 , a13 out nocopy JTF_VARCHAR2_TABLE_100
67 , a14 out nocopy JTF_VARCHAR2_TABLE_100
68 , a15 out nocopy JTF_NUMBER_TABLE
69 , a16 out nocopy JTF_VARCHAR2_TABLE_100
70 , a17 out nocopy JTF_NUMBER_TABLE
71 , a18 out nocopy JTF_VARCHAR2_TABLE_100
72 , a19 out nocopy JTF_DATE_TABLE
73 , a20 out nocopy JTF_VARCHAR2_TABLE_100
74 , a21 out nocopy JTF_DATE_TABLE
75 , a22 out nocopy JTF_VARCHAR2_TABLE_100
76 , a23 out nocopy JTF_NUMBER_TABLE
77 , a24 out nocopy JTF_VARCHAR2_TABLE_100
78 , a25 out nocopy JTF_DATE_TABLE
79 , a26 out nocopy JTF_VARCHAR2_TABLE_100
80 , a27 out nocopy JTF_VARCHAR2_TABLE_100
81 , a28 out nocopy JTF_VARCHAR2_TABLE_500
82 , a29 out nocopy JTF_VARCHAR2_TABLE_500
83 , a30 out nocopy JTF_VARCHAR2_TABLE_500
84 , a31 out nocopy JTF_VARCHAR2_TABLE_500
85 , a32 out nocopy JTF_VARCHAR2_TABLE_500
86 , a33 out nocopy JTF_VARCHAR2_TABLE_500
87 , a34 out nocopy JTF_VARCHAR2_TABLE_500
88 , a35 out nocopy JTF_VARCHAR2_TABLE_500
89 , a36 out nocopy JTF_VARCHAR2_TABLE_500
90 , a37 out nocopy JTF_VARCHAR2_TABLE_500
91 , a38 out nocopy JTF_VARCHAR2_TABLE_500
92 , a39 out nocopy JTF_VARCHAR2_TABLE_500
93 , a40 out nocopy JTF_VARCHAR2_TABLE_500
94 , a41 out nocopy JTF_VARCHAR2_TABLE_500
95 , a42 out nocopy JTF_VARCHAR2_TABLE_500
96 , a43 out nocopy JTF_NUMBER_TABLE
97 , a44 out nocopy JTF_DATE_TABLE
98 , a45 out nocopy JTF_NUMBER_TABLE
99 , a46 out nocopy JTF_DATE_TABLE
100 , a47 out nocopy JTF_NUMBER_TABLE
101 , a48 out nocopy JTF_VARCHAR2_TABLE_100
102 );
103
104 procedure rosetta_table_copy_in_p5(t out nocopy okl_krp_pvt.krp_tbl_type, a0 JTF_NUMBER_TABLE
105 , a1 JTF_VARCHAR2_TABLE_100
106 , a2 JTF_DATE_TABLE
107 , a3 JTF_DATE_TABLE
108 , a4 JTF_NUMBER_TABLE
109 , a5 JTF_NUMBER_TABLE
110 , a6 JTF_DATE_TABLE
111 , a7 JTF_NUMBER_TABLE
112 , a8 JTF_NUMBER_TABLE
113 , a9 JTF_NUMBER_TABLE
114 , a10 JTF_VARCHAR2_TABLE_100
115 , a11 JTF_VARCHAR2_TABLE_100
116 , a12 JTF_VARCHAR2_TABLE_100
117 , a13 JTF_VARCHAR2_TABLE_100
118 , a14 JTF_VARCHAR2_TABLE_100
119 , a15 JTF_NUMBER_TABLE
120 , a16 JTF_VARCHAR2_TABLE_100
121 , a17 JTF_NUMBER_TABLE
122 , a18 JTF_VARCHAR2_TABLE_100
123 , a19 JTF_DATE_TABLE
124 , a20 JTF_VARCHAR2_TABLE_100
125 , a21 JTF_DATE_TABLE
126 , a22 JTF_VARCHAR2_TABLE_100
127 , a23 JTF_NUMBER_TABLE
128 , a24 JTF_VARCHAR2_TABLE_100
129 , a25 JTF_DATE_TABLE
130 , a26 JTF_VARCHAR2_TABLE_100
131 , a27 JTF_VARCHAR2_TABLE_100
132 , a28 JTF_VARCHAR2_TABLE_500
133 , a29 JTF_VARCHAR2_TABLE_500
134 , a30 JTF_VARCHAR2_TABLE_500
135 , a31 JTF_VARCHAR2_TABLE_500
136 , a32 JTF_VARCHAR2_TABLE_500
137 , a33 JTF_VARCHAR2_TABLE_500
138 , a34 JTF_VARCHAR2_TABLE_500
139 , a35 JTF_VARCHAR2_TABLE_500
140 , a36 JTF_VARCHAR2_TABLE_500
141 , a37 JTF_VARCHAR2_TABLE_500
142 , a38 JTF_VARCHAR2_TABLE_500
143 , a39 JTF_VARCHAR2_TABLE_500
144 , a40 JTF_VARCHAR2_TABLE_500
145 , a41 JTF_VARCHAR2_TABLE_500
146 , a42 JTF_VARCHAR2_TABLE_500
147 , a43 JTF_NUMBER_TABLE
148 , a44 JTF_DATE_TABLE
149 , a45 JTF_NUMBER_TABLE
150 , a46 JTF_DATE_TABLE
151 , a47 JTF_NUMBER_TABLE
152 , a48 JTF_VARCHAR2_TABLE_100
153 );
154 procedure rosetta_table_copy_out_p5(t okl_krp_pvt.krp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
155 , a1 out nocopy JTF_VARCHAR2_TABLE_100
156 , a2 out nocopy JTF_DATE_TABLE
157 , a3 out nocopy JTF_DATE_TABLE
158 , a4 out nocopy JTF_NUMBER_TABLE
159 , a5 out nocopy JTF_NUMBER_TABLE
160 , a6 out nocopy JTF_DATE_TABLE
161 , a7 out nocopy JTF_NUMBER_TABLE
162 , a8 out nocopy JTF_NUMBER_TABLE
163 , a9 out nocopy JTF_NUMBER_TABLE
164 , a10 out nocopy JTF_VARCHAR2_TABLE_100
165 , a11 out nocopy JTF_VARCHAR2_TABLE_100
166 , a12 out nocopy JTF_VARCHAR2_TABLE_100
167 , a13 out nocopy JTF_VARCHAR2_TABLE_100
168 , a14 out nocopy JTF_VARCHAR2_TABLE_100
169 , a15 out nocopy JTF_NUMBER_TABLE
170 , a16 out nocopy JTF_VARCHAR2_TABLE_100
171 , a17 out nocopy JTF_NUMBER_TABLE
172 , a18 out nocopy JTF_VARCHAR2_TABLE_100
173 , a19 out nocopy JTF_DATE_TABLE
174 , a20 out nocopy JTF_VARCHAR2_TABLE_100
175 , a21 out nocopy JTF_DATE_TABLE
176 , a22 out nocopy JTF_VARCHAR2_TABLE_100
177 , a23 out nocopy JTF_NUMBER_TABLE
178 , a24 out nocopy JTF_VARCHAR2_TABLE_100
179 , a25 out nocopy JTF_DATE_TABLE
180 , a26 out nocopy JTF_VARCHAR2_TABLE_100
181 , a27 out nocopy JTF_VARCHAR2_TABLE_100
182 , a28 out nocopy JTF_VARCHAR2_TABLE_500
183 , a29 out nocopy JTF_VARCHAR2_TABLE_500
184 , a30 out nocopy JTF_VARCHAR2_TABLE_500
185 , a31 out nocopy JTF_VARCHAR2_TABLE_500
186 , a32 out nocopy JTF_VARCHAR2_TABLE_500
187 , a33 out nocopy JTF_VARCHAR2_TABLE_500
188 , a34 out nocopy JTF_VARCHAR2_TABLE_500
189 , a35 out nocopy JTF_VARCHAR2_TABLE_500
190 , a36 out nocopy JTF_VARCHAR2_TABLE_500
191 , a37 out nocopy JTF_VARCHAR2_TABLE_500
192 , a38 out nocopy JTF_VARCHAR2_TABLE_500
193 , a39 out nocopy JTF_VARCHAR2_TABLE_500
194 , a40 out nocopy JTF_VARCHAR2_TABLE_500
195 , a41 out nocopy JTF_VARCHAR2_TABLE_500
196 , a42 out nocopy JTF_VARCHAR2_TABLE_500
197 , a43 out nocopy JTF_NUMBER_TABLE
198 , a44 out nocopy JTF_DATE_TABLE
199 , a45 out nocopy JTF_NUMBER_TABLE
200 , a46 out nocopy JTF_DATE_TABLE
201 , a47 out nocopy JTF_NUMBER_TABLE
202 , a48 out nocopy JTF_VARCHAR2_TABLE_100
203 );
204
205 procedure insert_row(p_api_version NUMBER
206 , p_init_msg_list VARCHAR2
207 , x_return_status out nocopy VARCHAR2
208 , x_msg_count out nocopy NUMBER
209 , x_msg_data out nocopy VARCHAR2
210 , p6_a0 out nocopy NUMBER
211 , p6_a1 out nocopy VARCHAR2
212 , p6_a2 out nocopy DATE
213 , p6_a3 out nocopy DATE
214 , p6_a4 out nocopy NUMBER
215 , p6_a5 out nocopy NUMBER
216 , p6_a6 out nocopy DATE
217 , p6_a7 out nocopy NUMBER
218 , p6_a8 out nocopy NUMBER
219 , p6_a9 out nocopy NUMBER
220 , p6_a10 out nocopy VARCHAR2
221 , p6_a11 out nocopy VARCHAR2
222 , p6_a12 out nocopy VARCHAR2
223 , p6_a13 out nocopy VARCHAR2
224 , p6_a14 out nocopy VARCHAR2
225 , p6_a15 out nocopy NUMBER
226 , p6_a16 out nocopy VARCHAR2
227 , p6_a17 out nocopy NUMBER
228 , p6_a18 out nocopy VARCHAR2
229 , p6_a19 out nocopy DATE
230 , p6_a20 out nocopy VARCHAR2
231 , p6_a21 out nocopy DATE
232 , p6_a22 out nocopy VARCHAR2
233 , p6_a23 out nocopy NUMBER
234 , p6_a24 out nocopy VARCHAR2
235 , p6_a25 out nocopy DATE
236 , p6_a26 out nocopy VARCHAR2
237 , p6_a27 out nocopy VARCHAR2
238 , p6_a28 out nocopy VARCHAR2
239 , p6_a29 out nocopy VARCHAR2
240 , p6_a30 out nocopy VARCHAR2
241 , p6_a31 out nocopy VARCHAR2
242 , p6_a32 out nocopy VARCHAR2
243 , p6_a33 out nocopy VARCHAR2
244 , p6_a34 out nocopy VARCHAR2
245 , p6_a35 out nocopy VARCHAR2
246 , p6_a36 out nocopy VARCHAR2
247 , p6_a37 out nocopy VARCHAR2
248 , p6_a38 out nocopy VARCHAR2
249 , p6_a39 out nocopy VARCHAR2
250 , p6_a40 out nocopy VARCHAR2
251 , p6_a41 out nocopy VARCHAR2
252 , p6_a42 out nocopy VARCHAR2
253 , p6_a43 out nocopy NUMBER
254 , p6_a44 out nocopy DATE
255 , p6_a45 out nocopy NUMBER
256 , p6_a46 out nocopy DATE
257 , p6_a47 out nocopy NUMBER
258 , p6_a48 out nocopy VARCHAR2
259 , p5_a0 NUMBER := 0-1962.0724
260 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
261 , p5_a2 DATE := fnd_api.g_miss_date
262 , p5_a3 DATE := fnd_api.g_miss_date
263 , p5_a4 NUMBER := 0-1962.0724
264 , p5_a5 NUMBER := 0-1962.0724
265 , p5_a6 DATE := fnd_api.g_miss_date
266 , p5_a7 NUMBER := 0-1962.0724
267 , p5_a8 NUMBER := 0-1962.0724
268 , p5_a9 NUMBER := 0-1962.0724
269 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
270 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
271 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a15 NUMBER := 0-1962.0724
275 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a17 NUMBER := 0-1962.0724
277 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a19 DATE := fnd_api.g_miss_date
279 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a21 DATE := fnd_api.g_miss_date
281 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
282 , p5_a23 NUMBER := 0-1962.0724
283 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
284 , p5_a25 DATE := fnd_api.g_miss_date
285 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
286 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
288 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
289 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
290 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
291 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
292 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
293 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
294 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
295 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
296 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
297 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
298 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
299 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
300 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
301 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
302 , p5_a43 NUMBER := 0-1962.0724
303 , p5_a44 DATE := fnd_api.g_miss_date
304 , p5_a45 NUMBER := 0-1962.0724
305 , p5_a46 DATE := fnd_api.g_miss_date
306 , p5_a47 NUMBER := 0-1962.0724
307 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
308 );
309 procedure insert_row(p_api_version NUMBER
310 , p_init_msg_list VARCHAR2
311 , x_return_status out nocopy VARCHAR2
312 , x_msg_count out nocopy NUMBER
313 , x_msg_data out nocopy VARCHAR2
314 , p5_a0 JTF_NUMBER_TABLE
315 , p5_a1 JTF_VARCHAR2_TABLE_100
316 , p5_a2 JTF_DATE_TABLE
317 , p5_a3 JTF_DATE_TABLE
318 , p5_a4 JTF_NUMBER_TABLE
319 , p5_a5 JTF_NUMBER_TABLE
320 , p5_a6 JTF_DATE_TABLE
321 , p5_a7 JTF_NUMBER_TABLE
322 , p5_a8 JTF_NUMBER_TABLE
323 , p5_a9 JTF_NUMBER_TABLE
324 , p5_a10 JTF_VARCHAR2_TABLE_100
325 , p5_a11 JTF_VARCHAR2_TABLE_100
326 , p5_a12 JTF_VARCHAR2_TABLE_100
327 , p5_a13 JTF_VARCHAR2_TABLE_100
328 , p5_a14 JTF_VARCHAR2_TABLE_100
329 , p5_a15 JTF_NUMBER_TABLE
330 , p5_a16 JTF_VARCHAR2_TABLE_100
331 , p5_a17 JTF_NUMBER_TABLE
332 , p5_a18 JTF_VARCHAR2_TABLE_100
333 , p5_a19 JTF_DATE_TABLE
334 , p5_a20 JTF_VARCHAR2_TABLE_100
335 , p5_a21 JTF_DATE_TABLE
336 , p5_a22 JTF_VARCHAR2_TABLE_100
337 , p5_a23 JTF_NUMBER_TABLE
338 , p5_a24 JTF_VARCHAR2_TABLE_100
339 , p5_a25 JTF_DATE_TABLE
340 , p5_a26 JTF_VARCHAR2_TABLE_100
341 , p5_a27 JTF_VARCHAR2_TABLE_100
342 , p5_a28 JTF_VARCHAR2_TABLE_500
343 , p5_a29 JTF_VARCHAR2_TABLE_500
344 , p5_a30 JTF_VARCHAR2_TABLE_500
345 , p5_a31 JTF_VARCHAR2_TABLE_500
346 , p5_a32 JTF_VARCHAR2_TABLE_500
347 , p5_a33 JTF_VARCHAR2_TABLE_500
348 , p5_a34 JTF_VARCHAR2_TABLE_500
349 , p5_a35 JTF_VARCHAR2_TABLE_500
350 , p5_a36 JTF_VARCHAR2_TABLE_500
351 , p5_a37 JTF_VARCHAR2_TABLE_500
352 , p5_a38 JTF_VARCHAR2_TABLE_500
353 , p5_a39 JTF_VARCHAR2_TABLE_500
354 , p5_a40 JTF_VARCHAR2_TABLE_500
355 , p5_a41 JTF_VARCHAR2_TABLE_500
356 , p5_a42 JTF_VARCHAR2_TABLE_500
357 , p5_a43 JTF_NUMBER_TABLE
358 , p5_a44 JTF_DATE_TABLE
359 , p5_a45 JTF_NUMBER_TABLE
360 , p5_a46 JTF_DATE_TABLE
361 , p5_a47 JTF_NUMBER_TABLE
362 , p5_a48 JTF_VARCHAR2_TABLE_100
363 , p6_a0 out nocopy JTF_NUMBER_TABLE
364 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
365 , p6_a2 out nocopy JTF_DATE_TABLE
366 , p6_a3 out nocopy JTF_DATE_TABLE
367 , p6_a4 out nocopy JTF_NUMBER_TABLE
368 , p6_a5 out nocopy JTF_NUMBER_TABLE
369 , p6_a6 out nocopy JTF_DATE_TABLE
370 , p6_a7 out nocopy JTF_NUMBER_TABLE
371 , p6_a8 out nocopy JTF_NUMBER_TABLE
372 , p6_a9 out nocopy JTF_NUMBER_TABLE
373 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
374 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
375 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
376 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
377 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
378 , p6_a15 out nocopy JTF_NUMBER_TABLE
379 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
380 , p6_a17 out nocopy JTF_NUMBER_TABLE
381 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
382 , p6_a19 out nocopy JTF_DATE_TABLE
383 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
384 , p6_a21 out nocopy JTF_DATE_TABLE
385 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
386 , p6_a23 out nocopy JTF_NUMBER_TABLE
387 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
388 , p6_a25 out nocopy JTF_DATE_TABLE
389 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
390 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
391 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
392 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
393 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
394 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
395 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
396 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
397 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
398 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
399 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
400 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
401 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
402 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
403 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
404 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
405 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
406 , p6_a43 out nocopy JTF_NUMBER_TABLE
407 , p6_a44 out nocopy JTF_DATE_TABLE
408 , p6_a45 out nocopy JTF_NUMBER_TABLE
409 , p6_a46 out nocopy JTF_DATE_TABLE
410 , p6_a47 out nocopy JTF_NUMBER_TABLE
411 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
412 );
413 procedure lock_row(p_api_version NUMBER
414 , p_init_msg_list VARCHAR2
415 , x_return_status out nocopy VARCHAR2
416 , x_msg_count out nocopy NUMBER
417 , x_msg_data out nocopy VARCHAR2
418 , p5_a0 NUMBER := 0-1962.0724
419 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
420 , p5_a2 DATE := fnd_api.g_miss_date
421 , p5_a3 DATE := fnd_api.g_miss_date
422 , p5_a4 NUMBER := 0-1962.0724
423 , p5_a5 NUMBER := 0-1962.0724
424 , p5_a6 DATE := fnd_api.g_miss_date
425 , p5_a7 NUMBER := 0-1962.0724
426 , p5_a8 NUMBER := 0-1962.0724
427 , p5_a9 NUMBER := 0-1962.0724
428 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
429 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
430 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
431 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
432 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
433 , p5_a15 NUMBER := 0-1962.0724
434 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
435 , p5_a17 NUMBER := 0-1962.0724
436 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
437 , p5_a19 DATE := fnd_api.g_miss_date
438 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
439 , p5_a21 DATE := fnd_api.g_miss_date
440 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
441 , p5_a23 NUMBER := 0-1962.0724
442 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
443 , p5_a25 DATE := fnd_api.g_miss_date
444 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
445 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
446 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
447 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
448 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
449 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
450 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
451 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
452 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
453 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
454 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
455 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
456 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
457 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
458 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
459 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
460 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
461 , p5_a43 NUMBER := 0-1962.0724
462 , p5_a44 DATE := fnd_api.g_miss_date
463 , p5_a45 NUMBER := 0-1962.0724
464 , p5_a46 DATE := fnd_api.g_miss_date
465 , p5_a47 NUMBER := 0-1962.0724
466 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
467 );
468 procedure lock_row(p_api_version NUMBER
469 , p_init_msg_list VARCHAR2
470 , x_return_status out nocopy VARCHAR2
471 , x_msg_count out nocopy NUMBER
472 , x_msg_data out nocopy VARCHAR2
473 , p5_a0 JTF_NUMBER_TABLE
474 , p5_a1 JTF_VARCHAR2_TABLE_100
475 , p5_a2 JTF_DATE_TABLE
476 , p5_a3 JTF_DATE_TABLE
477 , p5_a4 JTF_NUMBER_TABLE
478 , p5_a5 JTF_NUMBER_TABLE
479 , p5_a6 JTF_DATE_TABLE
480 , p5_a7 JTF_NUMBER_TABLE
481 , p5_a8 JTF_NUMBER_TABLE
482 , p5_a9 JTF_NUMBER_TABLE
483 , p5_a10 JTF_VARCHAR2_TABLE_100
484 , p5_a11 JTF_VARCHAR2_TABLE_100
485 , p5_a12 JTF_VARCHAR2_TABLE_100
486 , p5_a13 JTF_VARCHAR2_TABLE_100
487 , p5_a14 JTF_VARCHAR2_TABLE_100
488 , p5_a15 JTF_NUMBER_TABLE
489 , p5_a16 JTF_VARCHAR2_TABLE_100
490 , p5_a17 JTF_NUMBER_TABLE
491 , p5_a18 JTF_VARCHAR2_TABLE_100
492 , p5_a19 JTF_DATE_TABLE
493 , p5_a20 JTF_VARCHAR2_TABLE_100
494 , p5_a21 JTF_DATE_TABLE
495 , p5_a22 JTF_VARCHAR2_TABLE_100
496 , p5_a23 JTF_NUMBER_TABLE
497 , p5_a24 JTF_VARCHAR2_TABLE_100
498 , p5_a25 JTF_DATE_TABLE
499 , p5_a26 JTF_VARCHAR2_TABLE_100
500 , p5_a27 JTF_VARCHAR2_TABLE_100
501 , p5_a28 JTF_VARCHAR2_TABLE_500
502 , p5_a29 JTF_VARCHAR2_TABLE_500
503 , p5_a30 JTF_VARCHAR2_TABLE_500
504 , p5_a31 JTF_VARCHAR2_TABLE_500
505 , p5_a32 JTF_VARCHAR2_TABLE_500
506 , p5_a33 JTF_VARCHAR2_TABLE_500
507 , p5_a34 JTF_VARCHAR2_TABLE_500
508 , p5_a35 JTF_VARCHAR2_TABLE_500
509 , p5_a36 JTF_VARCHAR2_TABLE_500
510 , p5_a37 JTF_VARCHAR2_TABLE_500
511 , p5_a38 JTF_VARCHAR2_TABLE_500
512 , p5_a39 JTF_VARCHAR2_TABLE_500
513 , p5_a40 JTF_VARCHAR2_TABLE_500
514 , p5_a41 JTF_VARCHAR2_TABLE_500
515 , p5_a42 JTF_VARCHAR2_TABLE_500
516 , p5_a43 JTF_NUMBER_TABLE
517 , p5_a44 JTF_DATE_TABLE
518 , p5_a45 JTF_NUMBER_TABLE
519 , p5_a46 JTF_DATE_TABLE
520 , p5_a47 JTF_NUMBER_TABLE
521 , p5_a48 JTF_VARCHAR2_TABLE_100
522 );
523 procedure update_row(p_api_version NUMBER
524 , p_init_msg_list VARCHAR2
525 , x_return_status out nocopy VARCHAR2
526 , x_msg_count out nocopy NUMBER
527 , x_msg_data out nocopy VARCHAR2
528 , p6_a0 out nocopy NUMBER
529 , p6_a1 out nocopy VARCHAR2
530 , p6_a2 out nocopy DATE
531 , p6_a3 out nocopy DATE
532 , p6_a4 out nocopy NUMBER
533 , p6_a5 out nocopy NUMBER
534 , p6_a6 out nocopy DATE
535 , p6_a7 out nocopy NUMBER
536 , p6_a8 out nocopy NUMBER
537 , p6_a9 out nocopy NUMBER
538 , p6_a10 out nocopy VARCHAR2
539 , p6_a11 out nocopy VARCHAR2
540 , p6_a12 out nocopy VARCHAR2
541 , p6_a13 out nocopy VARCHAR2
542 , p6_a14 out nocopy VARCHAR2
543 , p6_a15 out nocopy NUMBER
544 , p6_a16 out nocopy VARCHAR2
545 , p6_a17 out nocopy NUMBER
546 , p6_a18 out nocopy VARCHAR2
547 , p6_a19 out nocopy DATE
548 , p6_a20 out nocopy VARCHAR2
549 , p6_a21 out nocopy DATE
550 , p6_a22 out nocopy VARCHAR2
551 , p6_a23 out nocopy NUMBER
552 , p6_a24 out nocopy VARCHAR2
553 , p6_a25 out nocopy DATE
554 , p6_a26 out nocopy VARCHAR2
555 , p6_a27 out nocopy VARCHAR2
556 , p6_a28 out nocopy VARCHAR2
557 , p6_a29 out nocopy VARCHAR2
558 , p6_a30 out nocopy VARCHAR2
559 , p6_a31 out nocopy VARCHAR2
560 , p6_a32 out nocopy VARCHAR2
561 , p6_a33 out nocopy VARCHAR2
562 , p6_a34 out nocopy VARCHAR2
563 , p6_a35 out nocopy VARCHAR2
564 , p6_a36 out nocopy VARCHAR2
565 , p6_a37 out nocopy VARCHAR2
566 , p6_a38 out nocopy VARCHAR2
567 , p6_a39 out nocopy VARCHAR2
568 , p6_a40 out nocopy VARCHAR2
569 , p6_a41 out nocopy VARCHAR2
570 , p6_a42 out nocopy VARCHAR2
571 , p6_a43 out nocopy NUMBER
572 , p6_a44 out nocopy DATE
573 , p6_a45 out nocopy NUMBER
574 , p6_a46 out nocopy DATE
575 , p6_a47 out nocopy NUMBER
576 , p6_a48 out nocopy VARCHAR2
577 , p5_a0 NUMBER := 0-1962.0724
578 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
579 , p5_a2 DATE := fnd_api.g_miss_date
580 , p5_a3 DATE := fnd_api.g_miss_date
581 , p5_a4 NUMBER := 0-1962.0724
582 , p5_a5 NUMBER := 0-1962.0724
583 , p5_a6 DATE := fnd_api.g_miss_date
584 , p5_a7 NUMBER := 0-1962.0724
585 , p5_a8 NUMBER := 0-1962.0724
586 , p5_a9 NUMBER := 0-1962.0724
587 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
588 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
589 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
590 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
591 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
592 , p5_a15 NUMBER := 0-1962.0724
593 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
594 , p5_a17 NUMBER := 0-1962.0724
595 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
596 , p5_a19 DATE := fnd_api.g_miss_date
597 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a21 DATE := fnd_api.g_miss_date
599 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
600 , p5_a23 NUMBER := 0-1962.0724
601 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a25 DATE := fnd_api.g_miss_date
603 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a43 NUMBER := 0-1962.0724
621 , p5_a44 DATE := fnd_api.g_miss_date
622 , p5_a45 NUMBER := 0-1962.0724
623 , p5_a46 DATE := fnd_api.g_miss_date
624 , p5_a47 NUMBER := 0-1962.0724
625 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
626 );
627 procedure update_row(p_api_version NUMBER
628 , p_init_msg_list VARCHAR2
629 , x_return_status out nocopy VARCHAR2
630 , x_msg_count out nocopy NUMBER
631 , x_msg_data out nocopy VARCHAR2
632 , p5_a0 JTF_NUMBER_TABLE
633 , p5_a1 JTF_VARCHAR2_TABLE_100
634 , p5_a2 JTF_DATE_TABLE
635 , p5_a3 JTF_DATE_TABLE
636 , p5_a4 JTF_NUMBER_TABLE
637 , p5_a5 JTF_NUMBER_TABLE
638 , p5_a6 JTF_DATE_TABLE
639 , p5_a7 JTF_NUMBER_TABLE
640 , p5_a8 JTF_NUMBER_TABLE
641 , p5_a9 JTF_NUMBER_TABLE
642 , p5_a10 JTF_VARCHAR2_TABLE_100
643 , p5_a11 JTF_VARCHAR2_TABLE_100
644 , p5_a12 JTF_VARCHAR2_TABLE_100
645 , p5_a13 JTF_VARCHAR2_TABLE_100
646 , p5_a14 JTF_VARCHAR2_TABLE_100
647 , p5_a15 JTF_NUMBER_TABLE
648 , p5_a16 JTF_VARCHAR2_TABLE_100
649 , p5_a17 JTF_NUMBER_TABLE
650 , p5_a18 JTF_VARCHAR2_TABLE_100
651 , p5_a19 JTF_DATE_TABLE
652 , p5_a20 JTF_VARCHAR2_TABLE_100
653 , p5_a21 JTF_DATE_TABLE
654 , p5_a22 JTF_VARCHAR2_TABLE_100
655 , p5_a23 JTF_NUMBER_TABLE
656 , p5_a24 JTF_VARCHAR2_TABLE_100
657 , p5_a25 JTF_DATE_TABLE
658 , p5_a26 JTF_VARCHAR2_TABLE_100
659 , p5_a27 JTF_VARCHAR2_TABLE_100
660 , p5_a28 JTF_VARCHAR2_TABLE_500
661 , p5_a29 JTF_VARCHAR2_TABLE_500
662 , p5_a30 JTF_VARCHAR2_TABLE_500
663 , p5_a31 JTF_VARCHAR2_TABLE_500
664 , p5_a32 JTF_VARCHAR2_TABLE_500
665 , p5_a33 JTF_VARCHAR2_TABLE_500
666 , p5_a34 JTF_VARCHAR2_TABLE_500
667 , p5_a35 JTF_VARCHAR2_TABLE_500
668 , p5_a36 JTF_VARCHAR2_TABLE_500
669 , p5_a37 JTF_VARCHAR2_TABLE_500
670 , p5_a38 JTF_VARCHAR2_TABLE_500
671 , p5_a39 JTF_VARCHAR2_TABLE_500
672 , p5_a40 JTF_VARCHAR2_TABLE_500
673 , p5_a41 JTF_VARCHAR2_TABLE_500
674 , p5_a42 JTF_VARCHAR2_TABLE_500
675 , p5_a43 JTF_NUMBER_TABLE
676 , p5_a44 JTF_DATE_TABLE
677 , p5_a45 JTF_NUMBER_TABLE
678 , p5_a46 JTF_DATE_TABLE
679 , p5_a47 JTF_NUMBER_TABLE
680 , p5_a48 JTF_VARCHAR2_TABLE_100
681 , p6_a0 out nocopy JTF_NUMBER_TABLE
682 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
683 , p6_a2 out nocopy JTF_DATE_TABLE
684 , p6_a3 out nocopy JTF_DATE_TABLE
685 , p6_a4 out nocopy JTF_NUMBER_TABLE
686 , p6_a5 out nocopy JTF_NUMBER_TABLE
687 , p6_a6 out nocopy JTF_DATE_TABLE
688 , p6_a7 out nocopy JTF_NUMBER_TABLE
689 , p6_a8 out nocopy JTF_NUMBER_TABLE
690 , p6_a9 out nocopy JTF_NUMBER_TABLE
691 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
692 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
693 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
694 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
695 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
696 , p6_a15 out nocopy JTF_NUMBER_TABLE
697 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
698 , p6_a17 out nocopy JTF_NUMBER_TABLE
699 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
700 , p6_a19 out nocopy JTF_DATE_TABLE
701 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
702 , p6_a21 out nocopy JTF_DATE_TABLE
703 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
704 , p6_a23 out nocopy JTF_NUMBER_TABLE
705 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
706 , p6_a25 out nocopy JTF_DATE_TABLE
707 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
708 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
709 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
710 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
711 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
712 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
713 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
714 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
715 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
716 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
717 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
718 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
719 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
720 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
721 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
722 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
723 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
724 , p6_a43 out nocopy JTF_NUMBER_TABLE
725 , p6_a44 out nocopy JTF_DATE_TABLE
726 , p6_a45 out nocopy JTF_NUMBER_TABLE
727 , p6_a46 out nocopy JTF_DATE_TABLE
728 , p6_a47 out nocopy JTF_NUMBER_TABLE
729 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
730 );
731 procedure delete_row(p_api_version NUMBER
732 , p_init_msg_list VARCHAR2
733 , x_return_status out nocopy VARCHAR2
734 , x_msg_count out nocopy NUMBER
735 , x_msg_data out nocopy VARCHAR2
736 , p5_a0 NUMBER := 0-1962.0724
737 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
738 , p5_a2 DATE := fnd_api.g_miss_date
739 , p5_a3 DATE := fnd_api.g_miss_date
740 , p5_a4 NUMBER := 0-1962.0724
741 , p5_a5 NUMBER := 0-1962.0724
742 , p5_a6 DATE := fnd_api.g_miss_date
743 , p5_a7 NUMBER := 0-1962.0724
744 , p5_a8 NUMBER := 0-1962.0724
745 , p5_a9 NUMBER := 0-1962.0724
746 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
747 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
748 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
749 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
750 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
751 , p5_a15 NUMBER := 0-1962.0724
752 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a17 NUMBER := 0-1962.0724
754 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
755 , p5_a19 DATE := fnd_api.g_miss_date
756 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a21 DATE := fnd_api.g_miss_date
758 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
759 , p5_a23 NUMBER := 0-1962.0724
760 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
761 , p5_a25 DATE := fnd_api.g_miss_date
762 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
763 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
766 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
767 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
768 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
769 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
770 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
771 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
772 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
773 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
774 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
775 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
776 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
777 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
778 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
779 , p5_a43 NUMBER := 0-1962.0724
780 , p5_a44 DATE := fnd_api.g_miss_date
781 , p5_a45 NUMBER := 0-1962.0724
782 , p5_a46 DATE := fnd_api.g_miss_date
783 , p5_a47 NUMBER := 0-1962.0724
784 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
785 );
786 procedure delete_row(p_api_version NUMBER
787 , p_init_msg_list VARCHAR2
788 , x_return_status out nocopy VARCHAR2
789 , x_msg_count out nocopy NUMBER
790 , x_msg_data out nocopy VARCHAR2
791 , p5_a0 JTF_NUMBER_TABLE
792 , p5_a1 JTF_VARCHAR2_TABLE_100
793 , p5_a2 JTF_DATE_TABLE
794 , p5_a3 JTF_DATE_TABLE
795 , p5_a4 JTF_NUMBER_TABLE
796 , p5_a5 JTF_NUMBER_TABLE
797 , p5_a6 JTF_DATE_TABLE
798 , p5_a7 JTF_NUMBER_TABLE
799 , p5_a8 JTF_NUMBER_TABLE
800 , p5_a9 JTF_NUMBER_TABLE
801 , p5_a10 JTF_VARCHAR2_TABLE_100
802 , p5_a11 JTF_VARCHAR2_TABLE_100
803 , p5_a12 JTF_VARCHAR2_TABLE_100
804 , p5_a13 JTF_VARCHAR2_TABLE_100
805 , p5_a14 JTF_VARCHAR2_TABLE_100
806 , p5_a15 JTF_NUMBER_TABLE
807 , p5_a16 JTF_VARCHAR2_TABLE_100
808 , p5_a17 JTF_NUMBER_TABLE
809 , p5_a18 JTF_VARCHAR2_TABLE_100
810 , p5_a19 JTF_DATE_TABLE
811 , p5_a20 JTF_VARCHAR2_TABLE_100
812 , p5_a21 JTF_DATE_TABLE
813 , p5_a22 JTF_VARCHAR2_TABLE_100
814 , p5_a23 JTF_NUMBER_TABLE
815 , p5_a24 JTF_VARCHAR2_TABLE_100
816 , p5_a25 JTF_DATE_TABLE
817 , p5_a26 JTF_VARCHAR2_TABLE_100
818 , p5_a27 JTF_VARCHAR2_TABLE_100
819 , p5_a28 JTF_VARCHAR2_TABLE_500
820 , p5_a29 JTF_VARCHAR2_TABLE_500
821 , p5_a30 JTF_VARCHAR2_TABLE_500
822 , p5_a31 JTF_VARCHAR2_TABLE_500
823 , p5_a32 JTF_VARCHAR2_TABLE_500
824 , p5_a33 JTF_VARCHAR2_TABLE_500
825 , p5_a34 JTF_VARCHAR2_TABLE_500
826 , p5_a35 JTF_VARCHAR2_TABLE_500
827 , p5_a36 JTF_VARCHAR2_TABLE_500
828 , p5_a37 JTF_VARCHAR2_TABLE_500
829 , p5_a38 JTF_VARCHAR2_TABLE_500
830 , p5_a39 JTF_VARCHAR2_TABLE_500
831 , p5_a40 JTF_VARCHAR2_TABLE_500
832 , p5_a41 JTF_VARCHAR2_TABLE_500
833 , p5_a42 JTF_VARCHAR2_TABLE_500
834 , p5_a43 JTF_NUMBER_TABLE
835 , p5_a44 JTF_DATE_TABLE
836 , p5_a45 JTF_NUMBER_TABLE
837 , p5_a46 JTF_DATE_TABLE
838 , p5_a47 JTF_NUMBER_TABLE
839 , p5_a48 JTF_VARCHAR2_TABLE_100
840 );
841 procedure validate_row(p_api_version NUMBER
842 , p_init_msg_list VARCHAR2
843 , x_return_status out nocopy VARCHAR2
844 , x_msg_count out nocopy NUMBER
845 , x_msg_data out nocopy VARCHAR2
846 , p5_a0 NUMBER := 0-1962.0724
847 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
848 , p5_a2 DATE := fnd_api.g_miss_date
849 , p5_a3 DATE := fnd_api.g_miss_date
850 , p5_a4 NUMBER := 0-1962.0724
851 , p5_a5 NUMBER := 0-1962.0724
852 , p5_a6 DATE := fnd_api.g_miss_date
853 , p5_a7 NUMBER := 0-1962.0724
854 , p5_a8 NUMBER := 0-1962.0724
855 , p5_a9 NUMBER := 0-1962.0724
856 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861 , p5_a15 NUMBER := 0-1962.0724
862 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863 , p5_a17 NUMBER := 0-1962.0724
864 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865 , p5_a19 DATE := fnd_api.g_miss_date
866 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867 , p5_a21 DATE := fnd_api.g_miss_date
868 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869 , p5_a23 NUMBER := 0-1962.0724
870 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
871 , p5_a25 DATE := fnd_api.g_miss_date
872 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
873 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
874 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
876 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
881 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a43 NUMBER := 0-1962.0724
890 , p5_a44 DATE := fnd_api.g_miss_date
891 , p5_a45 NUMBER := 0-1962.0724
892 , p5_a46 DATE := fnd_api.g_miss_date
893 , p5_a47 NUMBER := 0-1962.0724
894 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
895 );
896 procedure validate_row(p_api_version NUMBER
897 , p_init_msg_list VARCHAR2
898 , x_return_status out nocopy VARCHAR2
899 , x_msg_count out nocopy NUMBER
900 , x_msg_data out nocopy VARCHAR2
901 , p5_a0 JTF_NUMBER_TABLE
902 , p5_a1 JTF_VARCHAR2_TABLE_100
903 , p5_a2 JTF_DATE_TABLE
904 , p5_a3 JTF_DATE_TABLE
905 , p5_a4 JTF_NUMBER_TABLE
906 , p5_a5 JTF_NUMBER_TABLE
907 , p5_a6 JTF_DATE_TABLE
908 , p5_a7 JTF_NUMBER_TABLE
909 , p5_a8 JTF_NUMBER_TABLE
910 , p5_a9 JTF_NUMBER_TABLE
911 , p5_a10 JTF_VARCHAR2_TABLE_100
912 , p5_a11 JTF_VARCHAR2_TABLE_100
913 , p5_a12 JTF_VARCHAR2_TABLE_100
914 , p5_a13 JTF_VARCHAR2_TABLE_100
915 , p5_a14 JTF_VARCHAR2_TABLE_100
916 , p5_a15 JTF_NUMBER_TABLE
917 , p5_a16 JTF_VARCHAR2_TABLE_100
918 , p5_a17 JTF_NUMBER_TABLE
919 , p5_a18 JTF_VARCHAR2_TABLE_100
920 , p5_a19 JTF_DATE_TABLE
921 , p5_a20 JTF_VARCHAR2_TABLE_100
922 , p5_a21 JTF_DATE_TABLE
923 , p5_a22 JTF_VARCHAR2_TABLE_100
924 , p5_a23 JTF_NUMBER_TABLE
925 , p5_a24 JTF_VARCHAR2_TABLE_100
926 , p5_a25 JTF_DATE_TABLE
927 , p5_a26 JTF_VARCHAR2_TABLE_100
928 , p5_a27 JTF_VARCHAR2_TABLE_100
929 , p5_a28 JTF_VARCHAR2_TABLE_500
930 , p5_a29 JTF_VARCHAR2_TABLE_500
931 , p5_a30 JTF_VARCHAR2_TABLE_500
932 , p5_a31 JTF_VARCHAR2_TABLE_500
933 , p5_a32 JTF_VARCHAR2_TABLE_500
934 , p5_a33 JTF_VARCHAR2_TABLE_500
935 , p5_a34 JTF_VARCHAR2_TABLE_500
936 , p5_a35 JTF_VARCHAR2_TABLE_500
937 , p5_a36 JTF_VARCHAR2_TABLE_500
938 , p5_a37 JTF_VARCHAR2_TABLE_500
939 , p5_a38 JTF_VARCHAR2_TABLE_500
940 , p5_a39 JTF_VARCHAR2_TABLE_500
941 , p5_a40 JTF_VARCHAR2_TABLE_500
942 , p5_a41 JTF_VARCHAR2_TABLE_500
943 , p5_a42 JTF_VARCHAR2_TABLE_500
944 , p5_a43 JTF_NUMBER_TABLE
945 , p5_a44 JTF_DATE_TABLE
946 , p5_a45 JTF_NUMBER_TABLE
947 , p5_a46 JTF_DATE_TABLE
948 , p5_a47 JTF_NUMBER_TABLE
949 , p5_a48 JTF_VARCHAR2_TABLE_100
950 );
951 procedure validate_row(p_api_version NUMBER
952 , p_init_msg_list VARCHAR2
953 , x_return_status out nocopy VARCHAR2
954 , x_msg_count out nocopy NUMBER
955 , x_msg_data out nocopy VARCHAR2
956 , p_deal_type VARCHAR2
957 , p_rev_rec_method VARCHAR2
958 , p_int_calc_basis VARCHAR2
959 , p8_a0 JTF_NUMBER_TABLE
960 , p8_a1 JTF_VARCHAR2_TABLE_100
961 , p8_a2 JTF_DATE_TABLE
962 , p8_a3 JTF_DATE_TABLE
963 , p8_a4 JTF_NUMBER_TABLE
964 , p8_a5 JTF_NUMBER_TABLE
965 , p8_a6 JTF_DATE_TABLE
966 , p8_a7 JTF_NUMBER_TABLE
967 , p8_a8 JTF_NUMBER_TABLE
968 , p8_a9 JTF_NUMBER_TABLE
969 , p8_a10 JTF_VARCHAR2_TABLE_100
970 , p8_a11 JTF_VARCHAR2_TABLE_100
971 , p8_a12 JTF_VARCHAR2_TABLE_100
972 , p8_a13 JTF_VARCHAR2_TABLE_100
973 , p8_a14 JTF_VARCHAR2_TABLE_100
974 , p8_a15 JTF_NUMBER_TABLE
975 , p8_a16 JTF_VARCHAR2_TABLE_100
976 , p8_a17 JTF_NUMBER_TABLE
977 , p8_a18 JTF_VARCHAR2_TABLE_100
978 , p8_a19 JTF_DATE_TABLE
979 , p8_a20 JTF_VARCHAR2_TABLE_100
980 , p8_a21 JTF_DATE_TABLE
981 , p8_a22 JTF_VARCHAR2_TABLE_100
982 , p8_a23 JTF_NUMBER_TABLE
983 , p8_a24 JTF_VARCHAR2_TABLE_100
984 , p8_a25 JTF_DATE_TABLE
985 , p8_a26 JTF_VARCHAR2_TABLE_100
986 , p8_a27 JTF_VARCHAR2_TABLE_100
987 , p8_a28 JTF_VARCHAR2_TABLE_500
988 , p8_a29 JTF_VARCHAR2_TABLE_500
989 , p8_a30 JTF_VARCHAR2_TABLE_500
990 , p8_a31 JTF_VARCHAR2_TABLE_500
991 , p8_a32 JTF_VARCHAR2_TABLE_500
992 , p8_a33 JTF_VARCHAR2_TABLE_500
993 , p8_a34 JTF_VARCHAR2_TABLE_500
994 , p8_a35 JTF_VARCHAR2_TABLE_500
995 , p8_a36 JTF_VARCHAR2_TABLE_500
996 , p8_a37 JTF_VARCHAR2_TABLE_500
997 , p8_a38 JTF_VARCHAR2_TABLE_500
998 , p8_a39 JTF_VARCHAR2_TABLE_500
999 , p8_a40 JTF_VARCHAR2_TABLE_500
1000 , p8_a41 JTF_VARCHAR2_TABLE_500
1001 , p8_a42 JTF_VARCHAR2_TABLE_500
1002 , p8_a43 JTF_NUMBER_TABLE
1003 , p8_a44 JTF_DATE_TABLE
1004 , p8_a45 JTF_NUMBER_TABLE
1005 , p8_a46 JTF_DATE_TABLE
1006 , p8_a47 JTF_NUMBER_TABLE
1007 , p8_a48 JTF_VARCHAR2_TABLE_100
1008 , p_stack_messages VARCHAR2
1009 , p_validate_flag VARCHAR2
1010 );
1011 end okl_krp_pvt_w;