[Home] [Help]
PACKAGE: APPS.OKL_PTL_QUALITYS_PVT_W
Source
1 package okl_ptl_qualitys_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLOPTQS.pls 115.3 2002/12/24 04:12:50 sgorantl noship $ */
3 procedure create_ptl_qualitys(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 , p6_a0 JTF_NUMBER_TABLE
9 , p6_a1 JTF_NUMBER_TABLE
10 , p6_a2 JTF_NUMBER_TABLE
11 , p6_a3 JTF_VARCHAR2_TABLE_200
12 , p6_a4 JTF_VARCHAR2_TABLE_2000
13 , p6_a5 JTF_DATE_TABLE
14 , p6_a6 JTF_DATE_TABLE
15 , p6_a7 JTF_NUMBER_TABLE
16 , p6_a8 JTF_DATE_TABLE
17 , p6_a9 JTF_NUMBER_TABLE
18 , p6_a10 JTF_DATE_TABLE
19 , p6_a11 JTF_NUMBER_TABLE
20 , p7_a0 out nocopy NUMBER
21 , p7_a1 out nocopy NUMBER
22 , p7_a2 out nocopy VARCHAR2
23 , p7_a3 out nocopy VARCHAR2
24 , p7_a4 out nocopy DATE
25 , p7_a5 out nocopy DATE
26 , p7_a6 out nocopy NUMBER
27 , p7_a7 out nocopy DATE
28 , p7_a8 out nocopy NUMBER
29 , p7_a9 out nocopy DATE
30 , p7_a10 out nocopy NUMBER
31 , p8_a0 out nocopy JTF_NUMBER_TABLE
32 , p8_a1 out nocopy JTF_NUMBER_TABLE
33 , p8_a2 out nocopy JTF_NUMBER_TABLE
34 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
35 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
36 , p8_a5 out nocopy JTF_DATE_TABLE
37 , p8_a6 out nocopy JTF_DATE_TABLE
38 , p8_a7 out nocopy JTF_NUMBER_TABLE
39 , p8_a8 out nocopy JTF_DATE_TABLE
40 , p8_a9 out nocopy JTF_NUMBER_TABLE
41 , p8_a10 out nocopy JTF_DATE_TABLE
42 , p8_a11 out nocopy JTF_NUMBER_TABLE
43 , p5_a0 NUMBER := 0-1962.0724
44 , p5_a1 NUMBER := 0-1962.0724
45 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
46 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
47 , p5_a4 DATE := fnd_api.g_miss_date
48 , p5_a5 DATE := fnd_api.g_miss_date
49 , p5_a6 NUMBER := 0-1962.0724
50 , p5_a7 DATE := fnd_api.g_miss_date
51 , p5_a8 NUMBER := 0-1962.0724
52 , p5_a9 DATE := fnd_api.g_miss_date
53 , p5_a10 NUMBER := 0-1962.0724
54 );
55 procedure update_ptl_qualitys(p_api_version NUMBER
56 , p_init_msg_list VARCHAR2
57 , x_return_status out nocopy VARCHAR2
58 , x_msg_count out nocopy NUMBER
59 , x_msg_data out nocopy VARCHAR2
60 , p6_a0 JTF_NUMBER_TABLE
61 , p6_a1 JTF_NUMBER_TABLE
62 , p6_a2 JTF_NUMBER_TABLE
63 , p6_a3 JTF_VARCHAR2_TABLE_200
64 , p6_a4 JTF_VARCHAR2_TABLE_2000
65 , p6_a5 JTF_DATE_TABLE
66 , p6_a6 JTF_DATE_TABLE
67 , p6_a7 JTF_NUMBER_TABLE
68 , p6_a8 JTF_DATE_TABLE
69 , p6_a9 JTF_NUMBER_TABLE
70 , p6_a10 JTF_DATE_TABLE
71 , p6_a11 JTF_NUMBER_TABLE
72 , p7_a0 out nocopy NUMBER
73 , p7_a1 out nocopy NUMBER
74 , p7_a2 out nocopy VARCHAR2
75 , p7_a3 out nocopy VARCHAR2
76 , p7_a4 out nocopy DATE
77 , p7_a5 out nocopy DATE
78 , p7_a6 out nocopy NUMBER
79 , p7_a7 out nocopy DATE
80 , p7_a8 out nocopy NUMBER
81 , p7_a9 out nocopy DATE
82 , p7_a10 out nocopy NUMBER
83 , p8_a0 out nocopy JTF_NUMBER_TABLE
84 , p8_a1 out nocopy JTF_NUMBER_TABLE
85 , p8_a2 out nocopy JTF_NUMBER_TABLE
86 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
87 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
88 , p8_a5 out nocopy JTF_DATE_TABLE
89 , p8_a6 out nocopy JTF_DATE_TABLE
90 , p8_a7 out nocopy JTF_NUMBER_TABLE
91 , p8_a8 out nocopy JTF_DATE_TABLE
92 , p8_a9 out nocopy JTF_NUMBER_TABLE
93 , p8_a10 out nocopy JTF_DATE_TABLE
94 , p8_a11 out nocopy JTF_NUMBER_TABLE
95 , p5_a0 NUMBER := 0-1962.0724
96 , p5_a1 NUMBER := 0-1962.0724
97 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a4 DATE := fnd_api.g_miss_date
100 , p5_a5 DATE := fnd_api.g_miss_date
101 , p5_a6 NUMBER := 0-1962.0724
102 , p5_a7 DATE := fnd_api.g_miss_date
103 , p5_a8 NUMBER := 0-1962.0724
104 , p5_a9 DATE := fnd_api.g_miss_date
105 , p5_a10 NUMBER := 0-1962.0724
106 );
107 procedure validate_ptl_qualitys(p_api_version NUMBER
108 , p_init_msg_list VARCHAR2
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_count out nocopy NUMBER
111 , x_msg_data out nocopy VARCHAR2
112 , p6_a0 JTF_NUMBER_TABLE
113 , p6_a1 JTF_NUMBER_TABLE
114 , p6_a2 JTF_NUMBER_TABLE
115 , p6_a3 JTF_VARCHAR2_TABLE_200
116 , p6_a4 JTF_VARCHAR2_TABLE_2000
117 , p6_a5 JTF_DATE_TABLE
118 , p6_a6 JTF_DATE_TABLE
119 , p6_a7 JTF_NUMBER_TABLE
120 , p6_a8 JTF_DATE_TABLE
121 , p6_a9 JTF_NUMBER_TABLE
122 , p6_a10 JTF_DATE_TABLE
123 , p6_a11 JTF_NUMBER_TABLE
124 , p5_a0 NUMBER := 0-1962.0724
125 , p5_a1 NUMBER := 0-1962.0724
126 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a4 DATE := fnd_api.g_miss_date
129 , p5_a5 DATE := fnd_api.g_miss_date
130 , p5_a6 NUMBER := 0-1962.0724
131 , p5_a7 DATE := fnd_api.g_miss_date
132 , p5_a8 NUMBER := 0-1962.0724
133 , p5_a9 DATE := fnd_api.g_miss_date
134 , p5_a10 NUMBER := 0-1962.0724
135 );
136 procedure create_ptl_qualitys(p_api_version NUMBER
137 , p_init_msg_list VARCHAR2
138 , x_return_status out nocopy VARCHAR2
139 , x_msg_count out nocopy NUMBER
140 , x_msg_data out nocopy VARCHAR2
141 , p5_a0 JTF_NUMBER_TABLE
142 , p5_a1 JTF_NUMBER_TABLE
143 , p5_a2 JTF_VARCHAR2_TABLE_200
144 , p5_a3 JTF_VARCHAR2_TABLE_2000
145 , p5_a4 JTF_DATE_TABLE
146 , p5_a5 JTF_DATE_TABLE
147 , p5_a6 JTF_NUMBER_TABLE
148 , p5_a7 JTF_DATE_TABLE
149 , p5_a8 JTF_NUMBER_TABLE
150 , p5_a9 JTF_DATE_TABLE
151 , p5_a10 JTF_NUMBER_TABLE
152 , p6_a0 out nocopy JTF_NUMBER_TABLE
153 , p6_a1 out nocopy JTF_NUMBER_TABLE
154 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
155 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
156 , p6_a4 out nocopy JTF_DATE_TABLE
157 , p6_a5 out nocopy JTF_DATE_TABLE
158 , p6_a6 out nocopy JTF_NUMBER_TABLE
159 , p6_a7 out nocopy JTF_DATE_TABLE
160 , p6_a8 out nocopy JTF_NUMBER_TABLE
161 , p6_a9 out nocopy JTF_DATE_TABLE
162 , p6_a10 out nocopy JTF_NUMBER_TABLE
163 );
164 procedure create_ptl_qualitys(p_api_version NUMBER
165 , p_init_msg_list VARCHAR2
166 , x_return_status out nocopy VARCHAR2
167 , x_msg_count out nocopy NUMBER
168 , x_msg_data out nocopy VARCHAR2
169 , p6_a0 out nocopy NUMBER
170 , p6_a1 out nocopy NUMBER
171 , p6_a2 out nocopy VARCHAR2
172 , p6_a3 out nocopy VARCHAR2
173 , p6_a4 out nocopy DATE
174 , p6_a5 out nocopy DATE
175 , p6_a6 out nocopy NUMBER
176 , p6_a7 out nocopy DATE
177 , p6_a8 out nocopy NUMBER
178 , p6_a9 out nocopy DATE
179 , p6_a10 out nocopy NUMBER
180 , p5_a0 NUMBER := 0-1962.0724
181 , p5_a1 NUMBER := 0-1962.0724
182 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
184 , p5_a4 DATE := fnd_api.g_miss_date
185 , p5_a5 DATE := fnd_api.g_miss_date
186 , p5_a6 NUMBER := 0-1962.0724
187 , p5_a7 DATE := fnd_api.g_miss_date
188 , p5_a8 NUMBER := 0-1962.0724
189 , p5_a9 DATE := fnd_api.g_miss_date
190 , p5_a10 NUMBER := 0-1962.0724
191 );
192 procedure lock_ptl_qualitys(p_api_version NUMBER
193 , p_init_msg_list VARCHAR2
194 , x_return_status out nocopy VARCHAR2
195 , x_msg_count out nocopy NUMBER
196 , x_msg_data out nocopy VARCHAR2
197 , p5_a0 JTF_NUMBER_TABLE
198 , p5_a1 JTF_NUMBER_TABLE
199 , p5_a2 JTF_VARCHAR2_TABLE_200
200 , p5_a3 JTF_VARCHAR2_TABLE_2000
201 , p5_a4 JTF_DATE_TABLE
202 , p5_a5 JTF_DATE_TABLE
203 , p5_a6 JTF_NUMBER_TABLE
204 , p5_a7 JTF_DATE_TABLE
205 , p5_a8 JTF_NUMBER_TABLE
206 , p5_a9 JTF_DATE_TABLE
207 , p5_a10 JTF_NUMBER_TABLE
208 );
209 procedure lock_ptl_qualitys(p_api_version NUMBER
210 , p_init_msg_list VARCHAR2
211 , x_return_status out nocopy VARCHAR2
212 , x_msg_count out nocopy NUMBER
213 , x_msg_data out nocopy VARCHAR2
214 , p5_a0 NUMBER := 0-1962.0724
215 , p5_a1 NUMBER := 0-1962.0724
216 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
217 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
218 , p5_a4 DATE := fnd_api.g_miss_date
219 , p5_a5 DATE := fnd_api.g_miss_date
220 , p5_a6 NUMBER := 0-1962.0724
221 , p5_a7 DATE := fnd_api.g_miss_date
222 , p5_a8 NUMBER := 0-1962.0724
223 , p5_a9 DATE := fnd_api.g_miss_date
224 , p5_a10 NUMBER := 0-1962.0724
225 );
226 procedure update_ptl_qualitys(p_api_version NUMBER
227 , p_init_msg_list VARCHAR2
228 , x_return_status out nocopy VARCHAR2
229 , x_msg_count out nocopy NUMBER
230 , x_msg_data out nocopy VARCHAR2
231 , p5_a0 JTF_NUMBER_TABLE
232 , p5_a1 JTF_NUMBER_TABLE
233 , p5_a2 JTF_VARCHAR2_TABLE_200
234 , p5_a3 JTF_VARCHAR2_TABLE_2000
235 , p5_a4 JTF_DATE_TABLE
236 , p5_a5 JTF_DATE_TABLE
237 , p5_a6 JTF_NUMBER_TABLE
238 , p5_a7 JTF_DATE_TABLE
239 , p5_a8 JTF_NUMBER_TABLE
240 , p5_a9 JTF_DATE_TABLE
241 , p5_a10 JTF_NUMBER_TABLE
242 , p6_a0 out nocopy JTF_NUMBER_TABLE
243 , p6_a1 out nocopy JTF_NUMBER_TABLE
244 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
245 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
246 , p6_a4 out nocopy JTF_DATE_TABLE
247 , p6_a5 out nocopy JTF_DATE_TABLE
248 , p6_a6 out nocopy JTF_NUMBER_TABLE
249 , p6_a7 out nocopy JTF_DATE_TABLE
250 , p6_a8 out nocopy JTF_NUMBER_TABLE
251 , p6_a9 out nocopy JTF_DATE_TABLE
252 , p6_a10 out nocopy JTF_NUMBER_TABLE
253 );
254 procedure update_ptl_qualitys(p_api_version NUMBER
255 , p_init_msg_list VARCHAR2
256 , x_return_status out nocopy VARCHAR2
257 , x_msg_count out nocopy NUMBER
258 , x_msg_data out nocopy VARCHAR2
259 , p6_a0 out nocopy NUMBER
260 , p6_a1 out nocopy NUMBER
261 , p6_a2 out nocopy VARCHAR2
262 , p6_a3 out nocopy VARCHAR2
263 , p6_a4 out nocopy DATE
264 , p6_a5 out nocopy DATE
265 , p6_a6 out nocopy NUMBER
266 , p6_a7 out nocopy DATE
267 , p6_a8 out nocopy NUMBER
268 , p6_a9 out nocopy DATE
269 , p6_a10 out nocopy NUMBER
270 , p5_a0 NUMBER := 0-1962.0724
271 , p5_a1 NUMBER := 0-1962.0724
272 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a4 DATE := fnd_api.g_miss_date
275 , p5_a5 DATE := fnd_api.g_miss_date
276 , p5_a6 NUMBER := 0-1962.0724
277 , p5_a7 DATE := fnd_api.g_miss_date
278 , p5_a8 NUMBER := 0-1962.0724
279 , p5_a9 DATE := fnd_api.g_miss_date
280 , p5_a10 NUMBER := 0-1962.0724
281 );
282 procedure delete_ptl_qualitys(p_api_version NUMBER
283 , p_init_msg_list VARCHAR2
284 , x_return_status out nocopy VARCHAR2
285 , x_msg_count out nocopy NUMBER
286 , x_msg_data out nocopy VARCHAR2
287 , p5_a0 JTF_NUMBER_TABLE
288 , p5_a1 JTF_NUMBER_TABLE
289 , p5_a2 JTF_VARCHAR2_TABLE_200
290 , p5_a3 JTF_VARCHAR2_TABLE_2000
291 , p5_a4 JTF_DATE_TABLE
292 , p5_a5 JTF_DATE_TABLE
293 , p5_a6 JTF_NUMBER_TABLE
294 , p5_a7 JTF_DATE_TABLE
295 , p5_a8 JTF_NUMBER_TABLE
296 , p5_a9 JTF_DATE_TABLE
297 , p5_a10 JTF_NUMBER_TABLE
298 );
299 procedure delete_ptl_qualitys(p_api_version NUMBER
300 , p_init_msg_list VARCHAR2
301 , x_return_status out nocopy VARCHAR2
302 , x_msg_count out nocopy NUMBER
303 , x_msg_data out nocopy VARCHAR2
304 , p5_a0 NUMBER := 0-1962.0724
305 , p5_a1 NUMBER := 0-1962.0724
306 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
307 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
308 , p5_a4 DATE := fnd_api.g_miss_date
309 , p5_a5 DATE := fnd_api.g_miss_date
310 , p5_a6 NUMBER := 0-1962.0724
311 , p5_a7 DATE := fnd_api.g_miss_date
312 , p5_a8 NUMBER := 0-1962.0724
313 , p5_a9 DATE := fnd_api.g_miss_date
314 , p5_a10 NUMBER := 0-1962.0724
315 );
316 procedure validate_ptl_qualitys(p_api_version NUMBER
317 , p_init_msg_list VARCHAR2
318 , x_return_status out nocopy VARCHAR2
319 , x_msg_count out nocopy NUMBER
320 , x_msg_data out nocopy VARCHAR2
321 , p5_a0 JTF_NUMBER_TABLE
322 , p5_a1 JTF_NUMBER_TABLE
323 , p5_a2 JTF_VARCHAR2_TABLE_200
324 , p5_a3 JTF_VARCHAR2_TABLE_2000
325 , p5_a4 JTF_DATE_TABLE
326 , p5_a5 JTF_DATE_TABLE
327 , p5_a6 JTF_NUMBER_TABLE
328 , p5_a7 JTF_DATE_TABLE
329 , p5_a8 JTF_NUMBER_TABLE
330 , p5_a9 JTF_DATE_TABLE
331 , p5_a10 JTF_NUMBER_TABLE
332 );
333 procedure validate_ptl_qualitys(p_api_version NUMBER
334 , p_init_msg_list VARCHAR2
335 , x_return_status out nocopy VARCHAR2
336 , x_msg_count out nocopy NUMBER
337 , x_msg_data out nocopy VARCHAR2
338 , p5_a0 NUMBER := 0-1962.0724
339 , p5_a1 NUMBER := 0-1962.0724
340 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
342 , p5_a4 DATE := fnd_api.g_miss_date
343 , p5_a5 DATE := fnd_api.g_miss_date
344 , p5_a6 NUMBER := 0-1962.0724
345 , p5_a7 DATE := fnd_api.g_miss_date
346 , p5_a8 NUMBER := 0-1962.0724
347 , p5_a9 DATE := fnd_api.g_miss_date
348 , p5_a10 NUMBER := 0-1962.0724
349 );
350 procedure create_ptl_qlty_values(p_api_version NUMBER
351 , p_init_msg_list VARCHAR2
352 , x_return_status out nocopy VARCHAR2
353 , x_msg_count out nocopy NUMBER
354 , x_msg_data out nocopy VARCHAR2
355 , p5_a0 JTF_NUMBER_TABLE
356 , p5_a1 JTF_NUMBER_TABLE
357 , p5_a2 JTF_NUMBER_TABLE
358 , p5_a3 JTF_VARCHAR2_TABLE_200
359 , p5_a4 JTF_VARCHAR2_TABLE_2000
360 , p5_a5 JTF_DATE_TABLE
361 , p5_a6 JTF_DATE_TABLE
362 , p5_a7 JTF_NUMBER_TABLE
363 , p5_a8 JTF_DATE_TABLE
364 , p5_a9 JTF_NUMBER_TABLE
365 , p5_a10 JTF_DATE_TABLE
366 , p5_a11 JTF_NUMBER_TABLE
367 , p6_a0 out nocopy JTF_NUMBER_TABLE
368 , p6_a1 out nocopy JTF_NUMBER_TABLE
369 , p6_a2 out nocopy JTF_NUMBER_TABLE
370 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
371 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
372 , p6_a5 out nocopy JTF_DATE_TABLE
373 , p6_a6 out nocopy JTF_DATE_TABLE
374 , p6_a7 out nocopy JTF_NUMBER_TABLE
375 , p6_a8 out nocopy JTF_DATE_TABLE
376 , p6_a9 out nocopy JTF_NUMBER_TABLE
377 , p6_a10 out nocopy JTF_DATE_TABLE
378 , p6_a11 out nocopy JTF_NUMBER_TABLE
379 );
380 procedure create_ptl_qlty_values(p_api_version NUMBER
381 , p_init_msg_list VARCHAR2
382 , x_return_status out nocopy VARCHAR2
383 , x_msg_count out nocopy NUMBER
384 , x_msg_data out nocopy VARCHAR2
385 , p6_a0 out nocopy NUMBER
386 , p6_a1 out nocopy NUMBER
387 , p6_a2 out nocopy NUMBER
388 , p6_a3 out nocopy VARCHAR2
389 , p6_a4 out nocopy VARCHAR2
390 , p6_a5 out nocopy DATE
391 , p6_a6 out nocopy DATE
392 , p6_a7 out nocopy NUMBER
396 , p6_a11 out nocopy NUMBER
393 , p6_a8 out nocopy DATE
394 , p6_a9 out nocopy NUMBER
395 , p6_a10 out nocopy DATE
397 , p5_a0 NUMBER := 0-1962.0724
398 , p5_a1 NUMBER := 0-1962.0724
399 , p5_a2 NUMBER := 0-1962.0724
400 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
401 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
402 , p5_a5 DATE := fnd_api.g_miss_date
403 , p5_a6 DATE := fnd_api.g_miss_date
404 , p5_a7 NUMBER := 0-1962.0724
405 , p5_a8 DATE := fnd_api.g_miss_date
406 , p5_a9 NUMBER := 0-1962.0724
407 , p5_a10 DATE := fnd_api.g_miss_date
408 , p5_a11 NUMBER := 0-1962.0724
409 );
410 procedure lock_ptl_qlty_values(p_api_version NUMBER
411 , p_init_msg_list VARCHAR2
412 , x_return_status out nocopy VARCHAR2
413 , x_msg_count out nocopy NUMBER
414 , x_msg_data out nocopy VARCHAR2
415 , p5_a0 JTF_NUMBER_TABLE
416 , p5_a1 JTF_NUMBER_TABLE
417 , p5_a2 JTF_NUMBER_TABLE
418 , p5_a3 JTF_VARCHAR2_TABLE_200
419 , p5_a4 JTF_VARCHAR2_TABLE_2000
420 , p5_a5 JTF_DATE_TABLE
421 , p5_a6 JTF_DATE_TABLE
422 , p5_a7 JTF_NUMBER_TABLE
423 , p5_a8 JTF_DATE_TABLE
424 , p5_a9 JTF_NUMBER_TABLE
425 , p5_a10 JTF_DATE_TABLE
426 , p5_a11 JTF_NUMBER_TABLE
427 );
428 procedure lock_ptl_qlty_values(p_api_version NUMBER
429 , p_init_msg_list VARCHAR2
430 , x_return_status out nocopy VARCHAR2
431 , x_msg_count out nocopy NUMBER
432 , x_msg_data out nocopy VARCHAR2
433 , p5_a0 NUMBER := 0-1962.0724
434 , p5_a1 NUMBER := 0-1962.0724
435 , p5_a2 NUMBER := 0-1962.0724
436 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
437 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
438 , p5_a5 DATE := fnd_api.g_miss_date
439 , p5_a6 DATE := fnd_api.g_miss_date
440 , p5_a7 NUMBER := 0-1962.0724
441 , p5_a8 DATE := fnd_api.g_miss_date
442 , p5_a9 NUMBER := 0-1962.0724
443 , p5_a10 DATE := fnd_api.g_miss_date
444 , p5_a11 NUMBER := 0-1962.0724
445 );
446 procedure update_ptl_qlty_values(p_api_version NUMBER
447 , p_init_msg_list VARCHAR2
448 , x_return_status out nocopy VARCHAR2
449 , x_msg_count out nocopy NUMBER
450 , x_msg_data out nocopy VARCHAR2
451 , p5_a0 JTF_NUMBER_TABLE
452 , p5_a1 JTF_NUMBER_TABLE
453 , p5_a2 JTF_NUMBER_TABLE
454 , p5_a3 JTF_VARCHAR2_TABLE_200
455 , p5_a4 JTF_VARCHAR2_TABLE_2000
456 , p5_a5 JTF_DATE_TABLE
457 , p5_a6 JTF_DATE_TABLE
458 , p5_a7 JTF_NUMBER_TABLE
459 , p5_a8 JTF_DATE_TABLE
460 , p5_a9 JTF_NUMBER_TABLE
461 , p5_a10 JTF_DATE_TABLE
462 , p5_a11 JTF_NUMBER_TABLE
463 , p6_a0 out nocopy JTF_NUMBER_TABLE
464 , p6_a1 out nocopy JTF_NUMBER_TABLE
465 , p6_a2 out nocopy JTF_NUMBER_TABLE
466 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
467 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
468 , p6_a5 out nocopy JTF_DATE_TABLE
469 , p6_a6 out nocopy JTF_DATE_TABLE
470 , p6_a7 out nocopy JTF_NUMBER_TABLE
471 , p6_a8 out nocopy JTF_DATE_TABLE
472 , p6_a9 out nocopy JTF_NUMBER_TABLE
473 , p6_a10 out nocopy JTF_DATE_TABLE
474 , p6_a11 out nocopy JTF_NUMBER_TABLE
475 );
476 procedure update_ptl_qlty_values(p_api_version NUMBER
477 , p_init_msg_list VARCHAR2
478 , x_return_status out nocopy VARCHAR2
479 , x_msg_count out nocopy NUMBER
480 , x_msg_data out nocopy VARCHAR2
481 , p6_a0 out nocopy NUMBER
482 , p6_a1 out nocopy NUMBER
483 , p6_a2 out nocopy NUMBER
484 , p6_a3 out nocopy VARCHAR2
485 , p6_a4 out nocopy VARCHAR2
486 , p6_a5 out nocopy DATE
487 , p6_a6 out nocopy DATE
488 , p6_a7 out nocopy NUMBER
489 , p6_a8 out nocopy DATE
490 , p6_a9 out nocopy NUMBER
491 , p6_a10 out nocopy DATE
492 , p6_a11 out nocopy NUMBER
493 , p5_a0 NUMBER := 0-1962.0724
494 , p5_a1 NUMBER := 0-1962.0724
495 , p5_a2 NUMBER := 0-1962.0724
496 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
497 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a5 DATE := fnd_api.g_miss_date
499 , p5_a6 DATE := fnd_api.g_miss_date
500 , p5_a7 NUMBER := 0-1962.0724
501 , p5_a8 DATE := fnd_api.g_miss_date
502 , p5_a9 NUMBER := 0-1962.0724
503 , p5_a10 DATE := fnd_api.g_miss_date
504 , p5_a11 NUMBER := 0-1962.0724
505 );
506 procedure delete_ptl_qlty_values(p_api_version NUMBER
507 , p_init_msg_list VARCHAR2
508 , x_return_status out nocopy VARCHAR2
509 , x_msg_count out nocopy NUMBER
510 , x_msg_data out nocopy VARCHAR2
511 , p5_a0 JTF_NUMBER_TABLE
512 , p5_a1 JTF_NUMBER_TABLE
513 , p5_a2 JTF_NUMBER_TABLE
514 , p5_a3 JTF_VARCHAR2_TABLE_200
515 , p5_a4 JTF_VARCHAR2_TABLE_2000
516 , p5_a5 JTF_DATE_TABLE
517 , p5_a6 JTF_DATE_TABLE
518 , p5_a7 JTF_NUMBER_TABLE
519 , p5_a8 JTF_DATE_TABLE
520 , p5_a9 JTF_NUMBER_TABLE
521 , p5_a10 JTF_DATE_TABLE
522 , p5_a11 JTF_NUMBER_TABLE
523 );
524 procedure delete_ptl_qlty_values(p_api_version NUMBER
525 , p_init_msg_list VARCHAR2
526 , x_return_status out nocopy VARCHAR2
527 , x_msg_count out nocopy NUMBER
528 , x_msg_data out nocopy VARCHAR2
529 , p5_a0 NUMBER := 0-1962.0724
530 , p5_a1 NUMBER := 0-1962.0724
531 , p5_a2 NUMBER := 0-1962.0724
532 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
533 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
534 , p5_a5 DATE := fnd_api.g_miss_date
535 , p5_a6 DATE := fnd_api.g_miss_date
536 , p5_a7 NUMBER := 0-1962.0724
537 , p5_a8 DATE := fnd_api.g_miss_date
538 , p5_a9 NUMBER := 0-1962.0724
539 , p5_a10 DATE := fnd_api.g_miss_date
540 , p5_a11 NUMBER := 0-1962.0724
541 );
542 procedure validate_ptl_qlty_values(p_api_version NUMBER
543 , p_init_msg_list VARCHAR2
544 , x_return_status out nocopy VARCHAR2
545 , x_msg_count out nocopy NUMBER
546 , x_msg_data out nocopy VARCHAR2
547 , p5_a0 JTF_NUMBER_TABLE
548 , p5_a1 JTF_NUMBER_TABLE
549 , p5_a2 JTF_NUMBER_TABLE
550 , p5_a3 JTF_VARCHAR2_TABLE_200
551 , p5_a4 JTF_VARCHAR2_TABLE_2000
552 , p5_a5 JTF_DATE_TABLE
553 , p5_a6 JTF_DATE_TABLE
554 , p5_a7 JTF_NUMBER_TABLE
555 , p5_a8 JTF_DATE_TABLE
556 , p5_a9 JTF_NUMBER_TABLE
557 , p5_a10 JTF_DATE_TABLE
558 , p5_a11 JTF_NUMBER_TABLE
559 );
560 procedure validate_ptl_qlty_values(p_api_version NUMBER
561 , p_init_msg_list VARCHAR2
562 , x_return_status out nocopy VARCHAR2
563 , x_msg_count out nocopy NUMBER
564 , x_msg_data out nocopy VARCHAR2
565 , p5_a0 NUMBER := 0-1962.0724
566 , p5_a1 NUMBER := 0-1962.0724
567 , p5_a2 NUMBER := 0-1962.0724
568 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a5 DATE := fnd_api.g_miss_date
571 , p5_a6 DATE := fnd_api.g_miss_date
572 , p5_a7 NUMBER := 0-1962.0724
573 , p5_a8 DATE := fnd_api.g_miss_date
574 , p5_a9 NUMBER := 0-1962.0724
575 , p5_a10 DATE := fnd_api.g_miss_date
576 , p5_a11 NUMBER := 0-1962.0724
577 );
578 end okl_ptl_qualitys_pvt_w;