[Home] [Help]
PACKAGE: APPS.OKL_PRTFL_LINES_PUB_W
Source
1 package okl_prtfl_lines_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUPFLS.pls 115.1 2002/12/19 23:32:00 gkadarka noship $ */
3 procedure insert_prtfl_lines(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p5_a0 JTF_NUMBER_TABLE
9 , p5_a1 JTF_VARCHAR2_TABLE_300
10 , p5_a2 JTF_NUMBER_TABLE
11 , p5_a3 JTF_DATE_TABLE
12 , p5_a4 JTF_DATE_TABLE
13 , p5_a5 JTF_DATE_TABLE
14 , p5_a6 JTF_VARCHAR2_TABLE_100
15 , p5_a7 JTF_VARCHAR2_TABLE_100
16 , p5_a8 JTF_NUMBER_TABLE
17 , p5_a9 JTF_NUMBER_TABLE
18 , p5_a10 JTF_NUMBER_TABLE
19 , p5_a11 JTF_NUMBER_TABLE
20 , p5_a12 JTF_VARCHAR2_TABLE_2000
21 , p5_a13 JTF_NUMBER_TABLE
22 , p5_a14 JTF_NUMBER_TABLE
23 , p5_a15 JTF_NUMBER_TABLE
24 , p5_a16 JTF_NUMBER_TABLE
25 , p5_a17 JTF_DATE_TABLE
26 , p5_a18 JTF_VARCHAR2_TABLE_300
27 , p5_a19 JTF_VARCHAR2_TABLE_300
28 , p5_a20 JTF_VARCHAR2_TABLE_300
29 , p5_a21 JTF_VARCHAR2_TABLE_300
30 , p5_a22 JTF_VARCHAR2_TABLE_300
31 , p5_a23 JTF_VARCHAR2_TABLE_300
32 , p5_a24 JTF_VARCHAR2_TABLE_300
33 , p5_a25 JTF_VARCHAR2_TABLE_300
34 , p5_a26 JTF_VARCHAR2_TABLE_300
35 , p5_a27 JTF_VARCHAR2_TABLE_300
36 , p5_a28 JTF_VARCHAR2_TABLE_300
37 , p5_a29 JTF_VARCHAR2_TABLE_300
38 , p5_a30 JTF_VARCHAR2_TABLE_300
39 , p5_a31 JTF_VARCHAR2_TABLE_300
40 , p5_a32 JTF_VARCHAR2_TABLE_300
41 , p5_a33 JTF_VARCHAR2_TABLE_300
42 , p5_a34 JTF_NUMBER_TABLE
43 , p5_a35 JTF_DATE_TABLE
44 , p5_a36 JTF_NUMBER_TABLE
45 , p5_a37 JTF_DATE_TABLE
46 , p5_a38 JTF_NUMBER_TABLE
47 , p5_a39 JTF_VARCHAR2_TABLE_100
48 , p5_a40 JTF_VARCHAR2_TABLE_100
49 , p5_a41 JTF_VARCHAR2_TABLE_100
50 , p5_a42 JTF_NUMBER_TABLE
51 , p5_a43 JTF_DATE_TABLE
52 , p6_a0 out nocopy JTF_NUMBER_TABLE
53 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
54 , p6_a2 out nocopy JTF_NUMBER_TABLE
55 , p6_a3 out nocopy JTF_DATE_TABLE
56 , p6_a4 out nocopy JTF_DATE_TABLE
57 , p6_a5 out nocopy JTF_DATE_TABLE
58 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
59 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
60 , p6_a8 out nocopy JTF_NUMBER_TABLE
61 , p6_a9 out nocopy JTF_NUMBER_TABLE
62 , p6_a10 out nocopy JTF_NUMBER_TABLE
63 , p6_a11 out nocopy JTF_NUMBER_TABLE
64 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
65 , p6_a13 out nocopy JTF_NUMBER_TABLE
66 , p6_a14 out nocopy JTF_NUMBER_TABLE
67 , p6_a15 out nocopy JTF_NUMBER_TABLE
68 , p6_a16 out nocopy JTF_NUMBER_TABLE
69 , p6_a17 out nocopy JTF_DATE_TABLE
70 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
71 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
72 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
73 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
74 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
75 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
76 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
77 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
78 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
79 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
80 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
81 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
82 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
83 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
84 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
85 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
86 , p6_a34 out nocopy JTF_NUMBER_TABLE
87 , p6_a35 out nocopy JTF_DATE_TABLE
88 , p6_a36 out nocopy JTF_NUMBER_TABLE
89 , p6_a37 out nocopy JTF_DATE_TABLE
90 , p6_a38 out nocopy JTF_NUMBER_TABLE
91 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
92 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
93 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
94 , p6_a42 out nocopy JTF_NUMBER_TABLE
95 , p6_a43 out nocopy JTF_DATE_TABLE
96 );
97 procedure insert_prtfl_lines(p_api_version NUMBER
98 , p_init_msg_list VARCHAR2
99 , x_return_status out nocopy VARCHAR2
100 , x_msg_count out nocopy NUMBER
101 , x_msg_data out nocopy VARCHAR2
102 , p6_a0 out nocopy NUMBER
103 , p6_a1 out nocopy VARCHAR2
104 , p6_a2 out nocopy NUMBER
105 , p6_a3 out nocopy DATE
106 , p6_a4 out nocopy DATE
107 , p6_a5 out nocopy DATE
108 , p6_a6 out nocopy VARCHAR2
109 , p6_a7 out nocopy VARCHAR2
110 , p6_a8 out nocopy NUMBER
111 , p6_a9 out nocopy NUMBER
112 , p6_a10 out nocopy NUMBER
113 , p6_a11 out nocopy NUMBER
114 , p6_a12 out nocopy VARCHAR2
115 , p6_a13 out nocopy NUMBER
116 , p6_a14 out nocopy NUMBER
117 , p6_a15 out nocopy NUMBER
118 , p6_a16 out nocopy NUMBER
119 , p6_a17 out nocopy DATE
120 , p6_a18 out nocopy VARCHAR2
121 , p6_a19 out nocopy VARCHAR2
122 , p6_a20 out nocopy VARCHAR2
123 , p6_a21 out nocopy VARCHAR2
124 , p6_a22 out nocopy VARCHAR2
125 , p6_a23 out nocopy VARCHAR2
126 , p6_a24 out nocopy VARCHAR2
127 , p6_a25 out nocopy VARCHAR2
128 , p6_a26 out nocopy VARCHAR2
129 , p6_a27 out nocopy VARCHAR2
130 , p6_a28 out nocopy VARCHAR2
131 , p6_a29 out nocopy VARCHAR2
132 , p6_a30 out nocopy VARCHAR2
133 , p6_a31 out nocopy VARCHAR2
134 , p6_a32 out nocopy VARCHAR2
135 , p6_a33 out nocopy VARCHAR2
136 , p6_a34 out nocopy NUMBER
137 , p6_a35 out nocopy DATE
138 , p6_a36 out nocopy NUMBER
139 , p6_a37 out nocopy DATE
140 , p6_a38 out nocopy NUMBER
141 , p6_a39 out nocopy VARCHAR2
142 , p6_a40 out nocopy VARCHAR2
143 , p6_a41 out nocopy VARCHAR2
144 , p6_a42 out nocopy NUMBER
145 , p6_a43 out nocopy DATE
146 , p5_a0 NUMBER := 0-1962.0724
147 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a2 NUMBER := 0-1962.0724
149 , p5_a3 DATE := fnd_api.g_miss_date
150 , p5_a4 DATE := fnd_api.g_miss_date
151 , p5_a5 DATE := fnd_api.g_miss_date
152 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a8 NUMBER := 0-1962.0724
155 , p5_a9 NUMBER := 0-1962.0724
156 , p5_a10 NUMBER := 0-1962.0724
157 , p5_a11 NUMBER := 0-1962.0724
158 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
159 , p5_a13 NUMBER := 0-1962.0724
160 , p5_a14 NUMBER := 0-1962.0724
161 , p5_a15 NUMBER := 0-1962.0724
162 , p5_a16 NUMBER := 0-1962.0724
163 , p5_a17 DATE := fnd_api.g_miss_date
164 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
168 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
169 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
170 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
171 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
172 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
173 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
174 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
175 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
176 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
177 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
178 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
180 , p5_a34 NUMBER := 0-1962.0724
181 , p5_a35 DATE := fnd_api.g_miss_date
182 , p5_a36 NUMBER := 0-1962.0724
183 , p5_a37 DATE := fnd_api.g_miss_date
184 , p5_a38 NUMBER := 0-1962.0724
185 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
186 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
187 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
188 , p5_a42 NUMBER := 0-1962.0724
189 , p5_a43 DATE := fnd_api.g_miss_date
190 );
191 procedure lock_prtfl_lines(p_api_version NUMBER
192 , p_init_msg_list VARCHAR2
193 , x_return_status out nocopy VARCHAR2
194 , x_msg_count out nocopy NUMBER
195 , x_msg_data out nocopy VARCHAR2
196 , p5_a0 JTF_NUMBER_TABLE
197 , p5_a1 JTF_VARCHAR2_TABLE_300
198 , p5_a2 JTF_NUMBER_TABLE
199 , p5_a3 JTF_DATE_TABLE
200 , p5_a4 JTF_DATE_TABLE
201 , p5_a5 JTF_DATE_TABLE
202 , p5_a6 JTF_VARCHAR2_TABLE_100
203 , p5_a7 JTF_VARCHAR2_TABLE_100
204 , p5_a8 JTF_NUMBER_TABLE
205 , p5_a9 JTF_NUMBER_TABLE
206 , p5_a10 JTF_NUMBER_TABLE
207 , p5_a11 JTF_NUMBER_TABLE
208 , p5_a12 JTF_VARCHAR2_TABLE_2000
209 , p5_a13 JTF_NUMBER_TABLE
210 , p5_a14 JTF_NUMBER_TABLE
211 , p5_a15 JTF_NUMBER_TABLE
212 , p5_a16 JTF_NUMBER_TABLE
213 , p5_a17 JTF_DATE_TABLE
214 , p5_a18 JTF_VARCHAR2_TABLE_300
215 , p5_a19 JTF_VARCHAR2_TABLE_300
216 , p5_a20 JTF_VARCHAR2_TABLE_300
217 , p5_a21 JTF_VARCHAR2_TABLE_300
218 , p5_a22 JTF_VARCHAR2_TABLE_300
219 , p5_a23 JTF_VARCHAR2_TABLE_300
220 , p5_a24 JTF_VARCHAR2_TABLE_300
221 , p5_a25 JTF_VARCHAR2_TABLE_300
222 , p5_a26 JTF_VARCHAR2_TABLE_300
223 , p5_a27 JTF_VARCHAR2_TABLE_300
224 , p5_a28 JTF_VARCHAR2_TABLE_300
225 , p5_a29 JTF_VARCHAR2_TABLE_300
226 , p5_a30 JTF_VARCHAR2_TABLE_300
227 , p5_a31 JTF_VARCHAR2_TABLE_300
228 , p5_a32 JTF_VARCHAR2_TABLE_300
229 , p5_a33 JTF_VARCHAR2_TABLE_300
230 , p5_a34 JTF_NUMBER_TABLE
231 , p5_a35 JTF_DATE_TABLE
232 , p5_a36 JTF_NUMBER_TABLE
233 , p5_a37 JTF_DATE_TABLE
234 , p5_a38 JTF_NUMBER_TABLE
235 , p5_a39 JTF_VARCHAR2_TABLE_100
236 , p5_a40 JTF_VARCHAR2_TABLE_100
237 , p5_a41 JTF_VARCHAR2_TABLE_100
238 , p5_a42 JTF_NUMBER_TABLE
239 , p5_a43 JTF_DATE_TABLE
240 );
241 procedure lock_prtfl_lines(p_api_version NUMBER
242 , p_init_msg_list VARCHAR2
243 , x_return_status out nocopy VARCHAR2
244 , x_msg_count out nocopy NUMBER
245 , x_msg_data out nocopy VARCHAR2
246 , p5_a0 NUMBER := 0-1962.0724
247 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
248 , p5_a2 NUMBER := 0-1962.0724
249 , p5_a3 DATE := fnd_api.g_miss_date
250 , p5_a4 DATE := fnd_api.g_miss_date
251 , p5_a5 DATE := fnd_api.g_miss_date
252 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
253 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
254 , p5_a8 NUMBER := 0-1962.0724
255 , p5_a9 NUMBER := 0-1962.0724
256 , p5_a10 NUMBER := 0-1962.0724
257 , p5_a11 NUMBER := 0-1962.0724
258 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
259 , p5_a13 NUMBER := 0-1962.0724
260 , p5_a14 NUMBER := 0-1962.0724
261 , p5_a15 NUMBER := 0-1962.0724
262 , p5_a16 NUMBER := 0-1962.0724
263 , p5_a17 DATE := fnd_api.g_miss_date
264 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
265 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
266 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
267 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
269 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
270 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
271 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
277 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a34 NUMBER := 0-1962.0724
281 , p5_a35 DATE := fnd_api.g_miss_date
282 , p5_a36 NUMBER := 0-1962.0724
283 , p5_a37 DATE := fnd_api.g_miss_date
284 , p5_a38 NUMBER := 0-1962.0724
285 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
286 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
287 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
288 , p5_a42 NUMBER := 0-1962.0724
289 , p5_a43 DATE := fnd_api.g_miss_date
290 );
291 procedure update_prtfl_lines(p_api_version NUMBER
292 , p_init_msg_list VARCHAR2
293 , x_return_status out nocopy VARCHAR2
294 , x_msg_count out nocopy NUMBER
295 , x_msg_data out nocopy VARCHAR2
296 , p5_a0 JTF_NUMBER_TABLE
297 , p5_a1 JTF_VARCHAR2_TABLE_300
298 , p5_a2 JTF_NUMBER_TABLE
299 , p5_a3 JTF_DATE_TABLE
300 , p5_a4 JTF_DATE_TABLE
301 , p5_a5 JTF_DATE_TABLE
302 , p5_a6 JTF_VARCHAR2_TABLE_100
303 , p5_a7 JTF_VARCHAR2_TABLE_100
304 , p5_a8 JTF_NUMBER_TABLE
305 , p5_a9 JTF_NUMBER_TABLE
306 , p5_a10 JTF_NUMBER_TABLE
307 , p5_a11 JTF_NUMBER_TABLE
308 , p5_a12 JTF_VARCHAR2_TABLE_2000
309 , p5_a13 JTF_NUMBER_TABLE
310 , p5_a14 JTF_NUMBER_TABLE
311 , p5_a15 JTF_NUMBER_TABLE
312 , p5_a16 JTF_NUMBER_TABLE
313 , p5_a17 JTF_DATE_TABLE
314 , p5_a18 JTF_VARCHAR2_TABLE_300
315 , p5_a19 JTF_VARCHAR2_TABLE_300
316 , p5_a20 JTF_VARCHAR2_TABLE_300
317 , p5_a21 JTF_VARCHAR2_TABLE_300
318 , p5_a22 JTF_VARCHAR2_TABLE_300
319 , p5_a23 JTF_VARCHAR2_TABLE_300
320 , p5_a24 JTF_VARCHAR2_TABLE_300
321 , p5_a25 JTF_VARCHAR2_TABLE_300
322 , p5_a26 JTF_VARCHAR2_TABLE_300
323 , p5_a27 JTF_VARCHAR2_TABLE_300
324 , p5_a28 JTF_VARCHAR2_TABLE_300
325 , p5_a29 JTF_VARCHAR2_TABLE_300
326 , p5_a30 JTF_VARCHAR2_TABLE_300
327 , p5_a31 JTF_VARCHAR2_TABLE_300
328 , p5_a32 JTF_VARCHAR2_TABLE_300
329 , p5_a33 JTF_VARCHAR2_TABLE_300
330 , p5_a34 JTF_NUMBER_TABLE
331 , p5_a35 JTF_DATE_TABLE
332 , p5_a36 JTF_NUMBER_TABLE
333 , p5_a37 JTF_DATE_TABLE
334 , p5_a38 JTF_NUMBER_TABLE
335 , p5_a39 JTF_VARCHAR2_TABLE_100
336 , p5_a40 JTF_VARCHAR2_TABLE_100
337 , p5_a41 JTF_VARCHAR2_TABLE_100
338 , p5_a42 JTF_NUMBER_TABLE
339 , p5_a43 JTF_DATE_TABLE
340 , p6_a0 out nocopy JTF_NUMBER_TABLE
341 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
342 , p6_a2 out nocopy JTF_NUMBER_TABLE
343 , p6_a3 out nocopy JTF_DATE_TABLE
344 , p6_a4 out nocopy JTF_DATE_TABLE
345 , p6_a5 out nocopy JTF_DATE_TABLE
346 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
347 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
348 , p6_a8 out nocopy JTF_NUMBER_TABLE
349 , p6_a9 out nocopy JTF_NUMBER_TABLE
350 , p6_a10 out nocopy JTF_NUMBER_TABLE
351 , p6_a11 out nocopy JTF_NUMBER_TABLE
352 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
353 , p6_a13 out nocopy JTF_NUMBER_TABLE
354 , p6_a14 out nocopy JTF_NUMBER_TABLE
355 , p6_a15 out nocopy JTF_NUMBER_TABLE
356 , p6_a16 out nocopy JTF_NUMBER_TABLE
357 , p6_a17 out nocopy JTF_DATE_TABLE
358 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
359 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
360 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
361 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
362 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
363 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
364 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
365 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
366 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
367 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
368 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
369 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
370 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
371 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
372 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
373 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
374 , p6_a34 out nocopy JTF_NUMBER_TABLE
375 , p6_a35 out nocopy JTF_DATE_TABLE
376 , p6_a36 out nocopy JTF_NUMBER_TABLE
377 , p6_a37 out nocopy JTF_DATE_TABLE
378 , p6_a38 out nocopy JTF_NUMBER_TABLE
379 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
381 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
382 , p6_a42 out nocopy JTF_NUMBER_TABLE
383 , p6_a43 out nocopy JTF_DATE_TABLE
384 );
385 procedure update_prtfl_lines(p_api_version NUMBER
386 , p_init_msg_list VARCHAR2
387 , x_return_status out nocopy VARCHAR2
388 , x_msg_count out nocopy NUMBER
389 , x_msg_data out nocopy VARCHAR2
390 , p6_a0 out nocopy NUMBER
391 , p6_a1 out nocopy VARCHAR2
392 , p6_a2 out nocopy NUMBER
393 , p6_a3 out nocopy DATE
394 , p6_a4 out nocopy DATE
395 , p6_a5 out nocopy DATE
396 , p6_a6 out nocopy VARCHAR2
397 , p6_a7 out nocopy VARCHAR2
398 , p6_a8 out nocopy NUMBER
399 , p6_a9 out nocopy NUMBER
400 , p6_a10 out nocopy NUMBER
401 , p6_a11 out nocopy NUMBER
402 , p6_a12 out nocopy VARCHAR2
403 , p6_a13 out nocopy NUMBER
404 , p6_a14 out nocopy NUMBER
405 , p6_a15 out nocopy NUMBER
406 , p6_a16 out nocopy NUMBER
407 , p6_a17 out nocopy DATE
408 , p6_a18 out nocopy VARCHAR2
409 , p6_a19 out nocopy VARCHAR2
410 , p6_a20 out nocopy VARCHAR2
411 , p6_a21 out nocopy VARCHAR2
412 , p6_a22 out nocopy VARCHAR2
413 , p6_a23 out nocopy VARCHAR2
414 , p6_a24 out nocopy VARCHAR2
415 , p6_a25 out nocopy VARCHAR2
416 , p6_a26 out nocopy VARCHAR2
417 , p6_a27 out nocopy VARCHAR2
418 , p6_a28 out nocopy VARCHAR2
419 , p6_a29 out nocopy VARCHAR2
420 , p6_a30 out nocopy VARCHAR2
421 , p6_a31 out nocopy VARCHAR2
422 , p6_a32 out nocopy VARCHAR2
423 , p6_a33 out nocopy VARCHAR2
424 , p6_a34 out nocopy NUMBER
425 , p6_a35 out nocopy DATE
426 , p6_a36 out nocopy NUMBER
427 , p6_a37 out nocopy DATE
428 , p6_a38 out nocopy NUMBER
429 , p6_a39 out nocopy VARCHAR2
430 , p6_a40 out nocopy VARCHAR2
431 , p6_a41 out nocopy VARCHAR2
432 , p6_a42 out nocopy NUMBER
433 , p6_a43 out nocopy DATE
434 , p5_a0 NUMBER := 0-1962.0724
435 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
436 , p5_a2 NUMBER := 0-1962.0724
437 , p5_a3 DATE := fnd_api.g_miss_date
438 , p5_a4 DATE := fnd_api.g_miss_date
439 , p5_a5 DATE := fnd_api.g_miss_date
440 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
441 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
442 , p5_a8 NUMBER := 0-1962.0724
443 , p5_a9 NUMBER := 0-1962.0724
444 , p5_a10 NUMBER := 0-1962.0724
445 , p5_a11 NUMBER := 0-1962.0724
446 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
447 , p5_a13 NUMBER := 0-1962.0724
448 , p5_a14 NUMBER := 0-1962.0724
449 , p5_a15 NUMBER := 0-1962.0724
450 , p5_a16 NUMBER := 0-1962.0724
451 , p5_a17 DATE := fnd_api.g_miss_date
452 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
453 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
454 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
455 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
456 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
457 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
458 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
459 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
460 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
461 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
462 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
463 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
464 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
465 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
466 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
467 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
468 , p5_a34 NUMBER := 0-1962.0724
469 , p5_a35 DATE := fnd_api.g_miss_date
470 , p5_a36 NUMBER := 0-1962.0724
471 , p5_a37 DATE := fnd_api.g_miss_date
472 , p5_a38 NUMBER := 0-1962.0724
473 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
474 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
475 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
476 , p5_a42 NUMBER := 0-1962.0724
477 , p5_a43 DATE := fnd_api.g_miss_date
478 );
479 procedure delete_prtfl_lines(p_api_version NUMBER
480 , p_init_msg_list VARCHAR2
481 , x_return_status out nocopy VARCHAR2
482 , x_msg_count out nocopy NUMBER
483 , x_msg_data out nocopy VARCHAR2
484 , p5_a0 JTF_NUMBER_TABLE
485 , p5_a1 JTF_VARCHAR2_TABLE_300
486 , p5_a2 JTF_NUMBER_TABLE
487 , p5_a3 JTF_DATE_TABLE
488 , p5_a4 JTF_DATE_TABLE
489 , p5_a5 JTF_DATE_TABLE
490 , p5_a6 JTF_VARCHAR2_TABLE_100
491 , p5_a7 JTF_VARCHAR2_TABLE_100
492 , p5_a8 JTF_NUMBER_TABLE
493 , p5_a9 JTF_NUMBER_TABLE
494 , p5_a10 JTF_NUMBER_TABLE
495 , p5_a11 JTF_NUMBER_TABLE
496 , p5_a12 JTF_VARCHAR2_TABLE_2000
497 , p5_a13 JTF_NUMBER_TABLE
498 , p5_a14 JTF_NUMBER_TABLE
499 , p5_a15 JTF_NUMBER_TABLE
500 , p5_a16 JTF_NUMBER_TABLE
501 , p5_a17 JTF_DATE_TABLE
502 , p5_a18 JTF_VARCHAR2_TABLE_300
503 , p5_a19 JTF_VARCHAR2_TABLE_300
504 , p5_a20 JTF_VARCHAR2_TABLE_300
505 , p5_a21 JTF_VARCHAR2_TABLE_300
506 , p5_a22 JTF_VARCHAR2_TABLE_300
507 , p5_a23 JTF_VARCHAR2_TABLE_300
508 , p5_a24 JTF_VARCHAR2_TABLE_300
509 , p5_a25 JTF_VARCHAR2_TABLE_300
510 , p5_a26 JTF_VARCHAR2_TABLE_300
511 , p5_a27 JTF_VARCHAR2_TABLE_300
512 , p5_a28 JTF_VARCHAR2_TABLE_300
513 , p5_a29 JTF_VARCHAR2_TABLE_300
514 , p5_a30 JTF_VARCHAR2_TABLE_300
515 , p5_a31 JTF_VARCHAR2_TABLE_300
516 , p5_a32 JTF_VARCHAR2_TABLE_300
517 , p5_a33 JTF_VARCHAR2_TABLE_300
518 , p5_a34 JTF_NUMBER_TABLE
519 , p5_a35 JTF_DATE_TABLE
520 , p5_a36 JTF_NUMBER_TABLE
521 , p5_a37 JTF_DATE_TABLE
522 , p5_a38 JTF_NUMBER_TABLE
523 , p5_a39 JTF_VARCHAR2_TABLE_100
524 , p5_a40 JTF_VARCHAR2_TABLE_100
525 , p5_a41 JTF_VARCHAR2_TABLE_100
526 , p5_a42 JTF_NUMBER_TABLE
527 , p5_a43 JTF_DATE_TABLE
528 );
529 procedure delete_prtfl_lines(p_api_version NUMBER
530 , p_init_msg_list VARCHAR2
531 , x_return_status out nocopy VARCHAR2
532 , x_msg_count out nocopy NUMBER
533 , x_msg_data out nocopy VARCHAR2
534 , p5_a0 NUMBER := 0-1962.0724
535 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
536 , p5_a2 NUMBER := 0-1962.0724
537 , p5_a3 DATE := fnd_api.g_miss_date
538 , p5_a4 DATE := fnd_api.g_miss_date
539 , p5_a5 DATE := fnd_api.g_miss_date
540 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
541 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542 , p5_a8 NUMBER := 0-1962.0724
543 , p5_a9 NUMBER := 0-1962.0724
544 , p5_a10 NUMBER := 0-1962.0724
545 , p5_a11 NUMBER := 0-1962.0724
546 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547 , p5_a13 NUMBER := 0-1962.0724
548 , p5_a14 NUMBER := 0-1962.0724
549 , p5_a15 NUMBER := 0-1962.0724
550 , p5_a16 NUMBER := 0-1962.0724
551 , p5_a17 DATE := fnd_api.g_miss_date
552 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
558 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
559 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
560 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
561 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
562 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
563 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
564 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
565 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
566 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
567 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
568 , p5_a34 NUMBER := 0-1962.0724
569 , p5_a35 DATE := fnd_api.g_miss_date
570 , p5_a36 NUMBER := 0-1962.0724
571 , p5_a37 DATE := fnd_api.g_miss_date
572 , p5_a38 NUMBER := 0-1962.0724
573 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
574 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
575 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
576 , p5_a42 NUMBER := 0-1962.0724
577 , p5_a43 DATE := fnd_api.g_miss_date
578 );
579 procedure validate_prtfl_lines(p_api_version NUMBER
580 , p_init_msg_list VARCHAR2
581 , x_return_status out nocopy VARCHAR2
582 , x_msg_count out nocopy NUMBER
583 , x_msg_data out nocopy VARCHAR2
584 , p5_a0 JTF_NUMBER_TABLE
585 , p5_a1 JTF_VARCHAR2_TABLE_300
586 , p5_a2 JTF_NUMBER_TABLE
587 , p5_a3 JTF_DATE_TABLE
588 , p5_a4 JTF_DATE_TABLE
589 , p5_a5 JTF_DATE_TABLE
590 , p5_a6 JTF_VARCHAR2_TABLE_100
591 , p5_a7 JTF_VARCHAR2_TABLE_100
592 , p5_a8 JTF_NUMBER_TABLE
593 , p5_a9 JTF_NUMBER_TABLE
594 , p5_a10 JTF_NUMBER_TABLE
595 , p5_a11 JTF_NUMBER_TABLE
596 , p5_a12 JTF_VARCHAR2_TABLE_2000
597 , p5_a13 JTF_NUMBER_TABLE
598 , p5_a14 JTF_NUMBER_TABLE
599 , p5_a15 JTF_NUMBER_TABLE
600 , p5_a16 JTF_NUMBER_TABLE
601 , p5_a17 JTF_DATE_TABLE
602 , p5_a18 JTF_VARCHAR2_TABLE_300
603 , p5_a19 JTF_VARCHAR2_TABLE_300
604 , p5_a20 JTF_VARCHAR2_TABLE_300
605 , p5_a21 JTF_VARCHAR2_TABLE_300
606 , p5_a22 JTF_VARCHAR2_TABLE_300
607 , p5_a23 JTF_VARCHAR2_TABLE_300
608 , p5_a24 JTF_VARCHAR2_TABLE_300
609 , p5_a25 JTF_VARCHAR2_TABLE_300
610 , p5_a26 JTF_VARCHAR2_TABLE_300
611 , p5_a27 JTF_VARCHAR2_TABLE_300
612 , p5_a28 JTF_VARCHAR2_TABLE_300
613 , p5_a29 JTF_VARCHAR2_TABLE_300
614 , p5_a30 JTF_VARCHAR2_TABLE_300
615 , p5_a31 JTF_VARCHAR2_TABLE_300
616 , p5_a32 JTF_VARCHAR2_TABLE_300
617 , p5_a33 JTF_VARCHAR2_TABLE_300
618 , p5_a34 JTF_NUMBER_TABLE
619 , p5_a35 JTF_DATE_TABLE
620 , p5_a36 JTF_NUMBER_TABLE
621 , p5_a37 JTF_DATE_TABLE
622 , p5_a38 JTF_NUMBER_TABLE
623 , p5_a39 JTF_VARCHAR2_TABLE_100
624 , p5_a40 JTF_VARCHAR2_TABLE_100
625 , p5_a41 JTF_VARCHAR2_TABLE_100
626 , p5_a42 JTF_NUMBER_TABLE
627 , p5_a43 JTF_DATE_TABLE
628 );
629 procedure validate_prtfl_lines(p_api_version NUMBER
630 , p_init_msg_list VARCHAR2
631 , x_return_status out nocopy VARCHAR2
632 , x_msg_count out nocopy NUMBER
633 , x_msg_data out nocopy VARCHAR2
634 , p5_a0 NUMBER := 0-1962.0724
635 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a2 NUMBER := 0-1962.0724
637 , p5_a3 DATE := fnd_api.g_miss_date
638 , p5_a4 DATE := fnd_api.g_miss_date
639 , p5_a5 DATE := fnd_api.g_miss_date
640 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a8 NUMBER := 0-1962.0724
643 , p5_a9 NUMBER := 0-1962.0724
644 , p5_a10 NUMBER := 0-1962.0724
645 , p5_a11 NUMBER := 0-1962.0724
646 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
647 , p5_a13 NUMBER := 0-1962.0724
648 , p5_a14 NUMBER := 0-1962.0724
649 , p5_a15 NUMBER := 0-1962.0724
650 , p5_a16 NUMBER := 0-1962.0724
651 , p5_a17 DATE := fnd_api.g_miss_date
652 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
654 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
655 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
656 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
657 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
658 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
659 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
660 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
661 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
662 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
663 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
664 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
665 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
666 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
667 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
668 , p5_a34 NUMBER := 0-1962.0724
669 , p5_a35 DATE := fnd_api.g_miss_date
670 , p5_a36 NUMBER := 0-1962.0724
671 , p5_a37 DATE := fnd_api.g_miss_date
672 , p5_a38 NUMBER := 0-1962.0724
673 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
674 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
676 , p5_a42 NUMBER := 0-1962.0724
677 , p5_a43 DATE := fnd_api.g_miss_date
678 );
679 end okl_prtfl_lines_pub_w;