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