23: , p_init_msg_list VARCHAR2
24: , x_return_status out nocopy VARCHAR2
25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p6_a0 JTF_NUMBER_TABLE
28: , p6_a1 JTF_NUMBER_TABLE
29: , p6_a2 JTF_NUMBER_TABLE
30: , p6_a3 JTF_VARCHAR2_TABLE_200
31: , p6_a4 JTF_VARCHAR2_TABLE_2000
24: , x_return_status out nocopy VARCHAR2
25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p6_a0 JTF_NUMBER_TABLE
28: , p6_a1 JTF_NUMBER_TABLE
29: , p6_a2 JTF_NUMBER_TABLE
30: , p6_a3 JTF_VARCHAR2_TABLE_200
31: , p6_a4 JTF_VARCHAR2_TABLE_2000
32: , p6_a5 JTF_DATE_TABLE
25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p6_a0 JTF_NUMBER_TABLE
28: , p6_a1 JTF_NUMBER_TABLE
29: , p6_a2 JTF_NUMBER_TABLE
30: , p6_a3 JTF_VARCHAR2_TABLE_200
31: , p6_a4 JTF_VARCHAR2_TABLE_2000
32: , p6_a5 JTF_DATE_TABLE
33: , p6_a6 JTF_DATE_TABLE
30: , p6_a3 JTF_VARCHAR2_TABLE_200
31: , p6_a4 JTF_VARCHAR2_TABLE_2000
32: , p6_a5 JTF_DATE_TABLE
33: , p6_a6 JTF_DATE_TABLE
34: , p6_a7 JTF_NUMBER_TABLE
35: , p6_a8 JTF_DATE_TABLE
36: , p6_a9 JTF_NUMBER_TABLE
37: , p6_a10 JTF_DATE_TABLE
38: , p6_a11 JTF_NUMBER_TABLE
32: , p6_a5 JTF_DATE_TABLE
33: , p6_a6 JTF_DATE_TABLE
34: , p6_a7 JTF_NUMBER_TABLE
35: , p6_a8 JTF_DATE_TABLE
36: , p6_a9 JTF_NUMBER_TABLE
37: , p6_a10 JTF_DATE_TABLE
38: , p6_a11 JTF_NUMBER_TABLE
39: , p7_a0 out nocopy NUMBER
40: , p7_a1 out nocopy NUMBER
34: , p6_a7 JTF_NUMBER_TABLE
35: , p6_a8 JTF_DATE_TABLE
36: , p6_a9 JTF_NUMBER_TABLE
37: , p6_a10 JTF_DATE_TABLE
38: , p6_a11 JTF_NUMBER_TABLE
39: , p7_a0 out nocopy NUMBER
40: , p7_a1 out nocopy NUMBER
41: , p7_a2 out nocopy VARCHAR2
42: , p7_a3 out nocopy VARCHAR2
47: , p7_a8 out nocopy DATE
48: , p7_a9 out nocopy NUMBER
49: , p7_a10 out nocopy DATE
50: , p7_a11 out nocopy NUMBER
51: , p8_a0 out nocopy JTF_NUMBER_TABLE
52: , p8_a1 out nocopy JTF_NUMBER_TABLE
53: , p8_a2 out nocopy JTF_NUMBER_TABLE
54: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , p7_a9 out nocopy NUMBER
49: , p7_a10 out nocopy DATE
50: , p7_a11 out nocopy NUMBER
51: , p8_a0 out nocopy JTF_NUMBER_TABLE
52: , p8_a1 out nocopy JTF_NUMBER_TABLE
53: , p8_a2 out nocopy JTF_NUMBER_TABLE
54: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
56: , p8_a5 out nocopy JTF_DATE_TABLE
49: , p7_a10 out nocopy DATE
50: , p7_a11 out nocopy NUMBER
51: , p8_a0 out nocopy JTF_NUMBER_TABLE
52: , p8_a1 out nocopy JTF_NUMBER_TABLE
53: , p8_a2 out nocopy JTF_NUMBER_TABLE
54: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
56: , p8_a5 out nocopy JTF_DATE_TABLE
57: , p8_a6 out nocopy JTF_DATE_TABLE
54: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
56: , p8_a5 out nocopy JTF_DATE_TABLE
57: , p8_a6 out nocopy JTF_DATE_TABLE
58: , p8_a7 out nocopy JTF_NUMBER_TABLE
59: , p8_a8 out nocopy JTF_DATE_TABLE
60: , p8_a9 out nocopy JTF_NUMBER_TABLE
61: , p8_a10 out nocopy JTF_DATE_TABLE
62: , p8_a11 out nocopy JTF_NUMBER_TABLE
56: , p8_a5 out nocopy JTF_DATE_TABLE
57: , p8_a6 out nocopy JTF_DATE_TABLE
58: , p8_a7 out nocopy JTF_NUMBER_TABLE
59: , p8_a8 out nocopy JTF_DATE_TABLE
60: , p8_a9 out nocopy JTF_NUMBER_TABLE
61: , p8_a10 out nocopy JTF_DATE_TABLE
62: , p8_a11 out nocopy JTF_NUMBER_TABLE
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
58: , p8_a7 out nocopy JTF_NUMBER_TABLE
59: , p8_a8 out nocopy JTF_DATE_TABLE
60: , p8_a9 out nocopy JTF_NUMBER_TABLE
61: , p8_a10 out nocopy JTF_DATE_TABLE
62: , p8_a11 out nocopy JTF_NUMBER_TABLE
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
168: , p_init_msg_list VARCHAR2
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p6_a0 JTF_NUMBER_TABLE
173: , p6_a1 JTF_NUMBER_TABLE
174: , p6_a2 JTF_NUMBER_TABLE
175: , p6_a3 JTF_VARCHAR2_TABLE_200
176: , p6_a4 JTF_VARCHAR2_TABLE_2000
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p6_a0 JTF_NUMBER_TABLE
173: , p6_a1 JTF_NUMBER_TABLE
174: , p6_a2 JTF_NUMBER_TABLE
175: , p6_a3 JTF_VARCHAR2_TABLE_200
176: , p6_a4 JTF_VARCHAR2_TABLE_2000
177: , p6_a5 JTF_DATE_TABLE
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p6_a0 JTF_NUMBER_TABLE
173: , p6_a1 JTF_NUMBER_TABLE
174: , p6_a2 JTF_NUMBER_TABLE
175: , p6_a3 JTF_VARCHAR2_TABLE_200
176: , p6_a4 JTF_VARCHAR2_TABLE_2000
177: , p6_a5 JTF_DATE_TABLE
178: , p6_a6 JTF_DATE_TABLE
175: , p6_a3 JTF_VARCHAR2_TABLE_200
176: , p6_a4 JTF_VARCHAR2_TABLE_2000
177: , p6_a5 JTF_DATE_TABLE
178: , p6_a6 JTF_DATE_TABLE
179: , p6_a7 JTF_NUMBER_TABLE
180: , p6_a8 JTF_DATE_TABLE
181: , p6_a9 JTF_NUMBER_TABLE
182: , p6_a10 JTF_DATE_TABLE
183: , p6_a11 JTF_NUMBER_TABLE
177: , p6_a5 JTF_DATE_TABLE
178: , p6_a6 JTF_DATE_TABLE
179: , p6_a7 JTF_NUMBER_TABLE
180: , p6_a8 JTF_DATE_TABLE
181: , p6_a9 JTF_NUMBER_TABLE
182: , p6_a10 JTF_DATE_TABLE
183: , p6_a11 JTF_NUMBER_TABLE
184: , p7_a0 out nocopy NUMBER
185: , p7_a1 out nocopy NUMBER
179: , p6_a7 JTF_NUMBER_TABLE
180: , p6_a8 JTF_DATE_TABLE
181: , p6_a9 JTF_NUMBER_TABLE
182: , p6_a10 JTF_DATE_TABLE
183: , p6_a11 JTF_NUMBER_TABLE
184: , p7_a0 out nocopy NUMBER
185: , p7_a1 out nocopy NUMBER
186: , p7_a2 out nocopy VARCHAR2
187: , p7_a3 out nocopy VARCHAR2
192: , p7_a8 out nocopy DATE
193: , p7_a9 out nocopy NUMBER
194: , p7_a10 out nocopy DATE
195: , p7_a11 out nocopy NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
197: , p8_a1 out nocopy JTF_NUMBER_TABLE
198: , p8_a2 out nocopy JTF_NUMBER_TABLE
199: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
200: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
193: , p7_a9 out nocopy NUMBER
194: , p7_a10 out nocopy DATE
195: , p7_a11 out nocopy NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
197: , p8_a1 out nocopy JTF_NUMBER_TABLE
198: , p8_a2 out nocopy JTF_NUMBER_TABLE
199: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
200: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p8_a5 out nocopy JTF_DATE_TABLE
194: , p7_a10 out nocopy DATE
195: , p7_a11 out nocopy NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
197: , p8_a1 out nocopy JTF_NUMBER_TABLE
198: , p8_a2 out nocopy JTF_NUMBER_TABLE
199: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
200: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p8_a5 out nocopy JTF_DATE_TABLE
202: , p8_a6 out nocopy JTF_DATE_TABLE
199: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
200: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p8_a5 out nocopy JTF_DATE_TABLE
202: , p8_a6 out nocopy JTF_DATE_TABLE
203: , p8_a7 out nocopy JTF_NUMBER_TABLE
204: , p8_a8 out nocopy JTF_DATE_TABLE
205: , p8_a9 out nocopy JTF_NUMBER_TABLE
206: , p8_a10 out nocopy JTF_DATE_TABLE
207: , p8_a11 out nocopy JTF_NUMBER_TABLE
201: , p8_a5 out nocopy JTF_DATE_TABLE
202: , p8_a6 out nocopy JTF_DATE_TABLE
203: , p8_a7 out nocopy JTF_NUMBER_TABLE
204: , p8_a8 out nocopy JTF_DATE_TABLE
205: , p8_a9 out nocopy JTF_NUMBER_TABLE
206: , p8_a10 out nocopy JTF_DATE_TABLE
207: , p8_a11 out nocopy JTF_NUMBER_TABLE
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
203: , p8_a7 out nocopy JTF_NUMBER_TABLE
204: , p8_a8 out nocopy JTF_DATE_TABLE
205: , p8_a9 out nocopy JTF_NUMBER_TABLE
206: , p8_a10 out nocopy JTF_DATE_TABLE
207: , p8_a11 out nocopy JTF_NUMBER_TABLE
208: , p5_a0 NUMBER := 0-1962.0724
209: , p5_a1 NUMBER := 0-1962.0724
210: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p_init_msg_list VARCHAR2
314: , x_return_status out nocopy VARCHAR2
315: , x_msg_count out nocopy NUMBER
316: , x_msg_data out nocopy VARCHAR2
317: , p6_a0 JTF_NUMBER_TABLE
318: , p6_a1 JTF_NUMBER_TABLE
319: , p6_a2 JTF_NUMBER_TABLE
320: , p6_a3 JTF_VARCHAR2_TABLE_200
321: , p6_a4 JTF_VARCHAR2_TABLE_2000
314: , x_return_status out nocopy VARCHAR2
315: , x_msg_count out nocopy NUMBER
316: , x_msg_data out nocopy VARCHAR2
317: , p6_a0 JTF_NUMBER_TABLE
318: , p6_a1 JTF_NUMBER_TABLE
319: , p6_a2 JTF_NUMBER_TABLE
320: , p6_a3 JTF_VARCHAR2_TABLE_200
321: , p6_a4 JTF_VARCHAR2_TABLE_2000
322: , p6_a5 JTF_DATE_TABLE
315: , x_msg_count out nocopy NUMBER
316: , x_msg_data out nocopy VARCHAR2
317: , p6_a0 JTF_NUMBER_TABLE
318: , p6_a1 JTF_NUMBER_TABLE
319: , p6_a2 JTF_NUMBER_TABLE
320: , p6_a3 JTF_VARCHAR2_TABLE_200
321: , p6_a4 JTF_VARCHAR2_TABLE_2000
322: , p6_a5 JTF_DATE_TABLE
323: , p6_a6 JTF_DATE_TABLE
320: , p6_a3 JTF_VARCHAR2_TABLE_200
321: , p6_a4 JTF_VARCHAR2_TABLE_2000
322: , p6_a5 JTF_DATE_TABLE
323: , p6_a6 JTF_DATE_TABLE
324: , p6_a7 JTF_NUMBER_TABLE
325: , p6_a8 JTF_DATE_TABLE
326: , p6_a9 JTF_NUMBER_TABLE
327: , p6_a10 JTF_DATE_TABLE
328: , p6_a11 JTF_NUMBER_TABLE
322: , p6_a5 JTF_DATE_TABLE
323: , p6_a6 JTF_DATE_TABLE
324: , p6_a7 JTF_NUMBER_TABLE
325: , p6_a8 JTF_DATE_TABLE
326: , p6_a9 JTF_NUMBER_TABLE
327: , p6_a10 JTF_DATE_TABLE
328: , p6_a11 JTF_NUMBER_TABLE
329: , p5_a0 NUMBER := 0-1962.0724
330: , p5_a1 NUMBER := 0-1962.0724
324: , p6_a7 JTF_NUMBER_TABLE
325: , p6_a8 JTF_DATE_TABLE
326: , p6_a9 JTF_NUMBER_TABLE
327: , p6_a10 JTF_DATE_TABLE
328: , p6_a11 JTF_NUMBER_TABLE
329: , p5_a0 NUMBER := 0-1962.0724
330: , p5_a1 NUMBER := 0-1962.0724
331: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
401: , p_init_msg_list VARCHAR2
402: , x_return_status out nocopy VARCHAR2
403: , x_msg_count out nocopy NUMBER
404: , x_msg_data out nocopy VARCHAR2
405: , p5_a0 JTF_NUMBER_TABLE
406: , p5_a1 JTF_NUMBER_TABLE
407: , p5_a2 JTF_VARCHAR2_TABLE_200
408: , p5_a3 JTF_VARCHAR2_TABLE_2000
409: , p5_a4 JTF_VARCHAR2_TABLE_100
402: , x_return_status out nocopy VARCHAR2
403: , x_msg_count out nocopy NUMBER
404: , x_msg_data out nocopy VARCHAR2
405: , p5_a0 JTF_NUMBER_TABLE
406: , p5_a1 JTF_NUMBER_TABLE
407: , p5_a2 JTF_VARCHAR2_TABLE_200
408: , p5_a3 JTF_VARCHAR2_TABLE_2000
409: , p5_a4 JTF_VARCHAR2_TABLE_100
410: , p5_a5 JTF_DATE_TABLE
408: , p5_a3 JTF_VARCHAR2_TABLE_2000
409: , p5_a4 JTF_VARCHAR2_TABLE_100
410: , p5_a5 JTF_DATE_TABLE
411: , p5_a6 JTF_DATE_TABLE
412: , p5_a7 JTF_NUMBER_TABLE
413: , p5_a8 JTF_DATE_TABLE
414: , p5_a9 JTF_NUMBER_TABLE
415: , p5_a10 JTF_DATE_TABLE
416: , p5_a11 JTF_NUMBER_TABLE
410: , p5_a5 JTF_DATE_TABLE
411: , p5_a6 JTF_DATE_TABLE
412: , p5_a7 JTF_NUMBER_TABLE
413: , p5_a8 JTF_DATE_TABLE
414: , p5_a9 JTF_NUMBER_TABLE
415: , p5_a10 JTF_DATE_TABLE
416: , p5_a11 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
412: , p5_a7 JTF_NUMBER_TABLE
413: , p5_a8 JTF_DATE_TABLE
414: , p5_a9 JTF_NUMBER_TABLE
415: , p5_a10 JTF_DATE_TABLE
416: , p5_a11 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
420: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
413: , p5_a8 JTF_DATE_TABLE
414: , p5_a9 JTF_NUMBER_TABLE
415: , p5_a10 JTF_DATE_TABLE
416: , p5_a11 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
420: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a9 JTF_NUMBER_TABLE
415: , p5_a10 JTF_DATE_TABLE
416: , p5_a11 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
420: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a5 out nocopy JTF_DATE_TABLE
420: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a5 out nocopy JTF_DATE_TABLE
423: , p6_a6 out nocopy JTF_DATE_TABLE
424: , p6_a7 out nocopy JTF_NUMBER_TABLE
425: , p6_a8 out nocopy JTF_DATE_TABLE
426: , p6_a9 out nocopy JTF_NUMBER_TABLE
427: , p6_a10 out nocopy JTF_DATE_TABLE
428: , p6_a11 out nocopy JTF_NUMBER_TABLE
422: , p6_a5 out nocopy JTF_DATE_TABLE
423: , p6_a6 out nocopy JTF_DATE_TABLE
424: , p6_a7 out nocopy JTF_NUMBER_TABLE
425: , p6_a8 out nocopy JTF_DATE_TABLE
426: , p6_a9 out nocopy JTF_NUMBER_TABLE
427: , p6_a10 out nocopy JTF_DATE_TABLE
428: , p6_a11 out nocopy JTF_NUMBER_TABLE
429: )
430:
424: , p6_a7 out nocopy JTF_NUMBER_TABLE
425: , p6_a8 out nocopy JTF_DATE_TABLE
426: , p6_a9 out nocopy JTF_NUMBER_TABLE
427: , p6_a10 out nocopy JTF_DATE_TABLE
428: , p6_a11 out nocopy JTF_NUMBER_TABLE
429: )
430:
431: as
432: ddp_pqyv_tbl okl_pdt_qualitys_pub.pqyv_tbl_type;
577: , p_init_msg_list VARCHAR2
578: , x_return_status out nocopy VARCHAR2
579: , x_msg_count out nocopy NUMBER
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_VARCHAR2_TABLE_2000
585: , p5_a4 JTF_VARCHAR2_TABLE_100
578: , x_return_status out nocopy VARCHAR2
579: , x_msg_count out nocopy NUMBER
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_VARCHAR2_TABLE_2000
585: , p5_a4 JTF_VARCHAR2_TABLE_100
586: , p5_a5 JTF_DATE_TABLE
584: , p5_a3 JTF_VARCHAR2_TABLE_2000
585: , p5_a4 JTF_VARCHAR2_TABLE_100
586: , p5_a5 JTF_DATE_TABLE
587: , p5_a6 JTF_DATE_TABLE
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_NUMBER_TABLE
591: , p5_a10 JTF_DATE_TABLE
592: , p5_a11 JTF_NUMBER_TABLE
586: , p5_a5 JTF_DATE_TABLE
587: , p5_a6 JTF_DATE_TABLE
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_NUMBER_TABLE
591: , p5_a10 JTF_DATE_TABLE
592: , p5_a11 JTF_NUMBER_TABLE
593: )
594:
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_NUMBER_TABLE
591: , p5_a10 JTF_DATE_TABLE
592: , p5_a11 JTF_NUMBER_TABLE
593: )
594:
595: as
596: ddp_pqyv_tbl okl_pdt_qualitys_pub.pqyv_tbl_type;
696: , p_init_msg_list VARCHAR2
697: , x_return_status out nocopy VARCHAR2
698: , x_msg_count out nocopy NUMBER
699: , x_msg_data out nocopy VARCHAR2
700: , p5_a0 JTF_NUMBER_TABLE
701: , p5_a1 JTF_NUMBER_TABLE
702: , p5_a2 JTF_VARCHAR2_TABLE_200
703: , p5_a3 JTF_VARCHAR2_TABLE_2000
704: , p5_a4 JTF_VARCHAR2_TABLE_100
697: , x_return_status out nocopy VARCHAR2
698: , x_msg_count out nocopy NUMBER
699: , x_msg_data out nocopy VARCHAR2
700: , p5_a0 JTF_NUMBER_TABLE
701: , p5_a1 JTF_NUMBER_TABLE
702: , p5_a2 JTF_VARCHAR2_TABLE_200
703: , p5_a3 JTF_VARCHAR2_TABLE_2000
704: , p5_a4 JTF_VARCHAR2_TABLE_100
705: , p5_a5 JTF_DATE_TABLE
703: , p5_a3 JTF_VARCHAR2_TABLE_2000
704: , p5_a4 JTF_VARCHAR2_TABLE_100
705: , p5_a5 JTF_DATE_TABLE
706: , p5_a6 JTF_DATE_TABLE
707: , p5_a7 JTF_NUMBER_TABLE
708: , p5_a8 JTF_DATE_TABLE
709: , p5_a9 JTF_NUMBER_TABLE
710: , p5_a10 JTF_DATE_TABLE
711: , p5_a11 JTF_NUMBER_TABLE
705: , p5_a5 JTF_DATE_TABLE
706: , p5_a6 JTF_DATE_TABLE
707: , p5_a7 JTF_NUMBER_TABLE
708: , p5_a8 JTF_DATE_TABLE
709: , p5_a9 JTF_NUMBER_TABLE
710: , p5_a10 JTF_DATE_TABLE
711: , p5_a11 JTF_NUMBER_TABLE
712: , p6_a0 out nocopy JTF_NUMBER_TABLE
713: , p6_a1 out nocopy JTF_NUMBER_TABLE
707: , p5_a7 JTF_NUMBER_TABLE
708: , p5_a8 JTF_DATE_TABLE
709: , p5_a9 JTF_NUMBER_TABLE
710: , p5_a10 JTF_DATE_TABLE
711: , p5_a11 JTF_NUMBER_TABLE
712: , p6_a0 out nocopy JTF_NUMBER_TABLE
713: , p6_a1 out nocopy JTF_NUMBER_TABLE
714: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
715: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
708: , p5_a8 JTF_DATE_TABLE
709: , p5_a9 JTF_NUMBER_TABLE
710: , p5_a10 JTF_DATE_TABLE
711: , p5_a11 JTF_NUMBER_TABLE
712: , p6_a0 out nocopy JTF_NUMBER_TABLE
713: , p6_a1 out nocopy JTF_NUMBER_TABLE
714: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
715: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
716: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
709: , p5_a9 JTF_NUMBER_TABLE
710: , p5_a10 JTF_DATE_TABLE
711: , p5_a11 JTF_NUMBER_TABLE
712: , p6_a0 out nocopy JTF_NUMBER_TABLE
713: , p6_a1 out nocopy JTF_NUMBER_TABLE
714: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
715: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
716: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
717: , p6_a5 out nocopy JTF_DATE_TABLE
715: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
716: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
717: , p6_a5 out nocopy JTF_DATE_TABLE
718: , p6_a6 out nocopy JTF_DATE_TABLE
719: , p6_a7 out nocopy JTF_NUMBER_TABLE
720: , p6_a8 out nocopy JTF_DATE_TABLE
721: , p6_a9 out nocopy JTF_NUMBER_TABLE
722: , p6_a10 out nocopy JTF_DATE_TABLE
723: , p6_a11 out nocopy JTF_NUMBER_TABLE
717: , p6_a5 out nocopy JTF_DATE_TABLE
718: , p6_a6 out nocopy JTF_DATE_TABLE
719: , p6_a7 out nocopy JTF_NUMBER_TABLE
720: , p6_a8 out nocopy JTF_DATE_TABLE
721: , p6_a9 out nocopy JTF_NUMBER_TABLE
722: , p6_a10 out nocopy JTF_DATE_TABLE
723: , p6_a11 out nocopy JTF_NUMBER_TABLE
724: )
725:
719: , p6_a7 out nocopy JTF_NUMBER_TABLE
720: , p6_a8 out nocopy JTF_DATE_TABLE
721: , p6_a9 out nocopy JTF_NUMBER_TABLE
722: , p6_a10 out nocopy JTF_DATE_TABLE
723: , p6_a11 out nocopy JTF_NUMBER_TABLE
724: )
725:
726: as
727: ddp_pqyv_tbl okl_pdt_qualitys_pub.pqyv_tbl_type;
872: , p_init_msg_list VARCHAR2
873: , x_return_status out nocopy VARCHAR2
874: , x_msg_count out nocopy NUMBER
875: , x_msg_data out nocopy VARCHAR2
876: , p5_a0 JTF_NUMBER_TABLE
877: , p5_a1 JTF_NUMBER_TABLE
878: , p5_a2 JTF_VARCHAR2_TABLE_200
879: , p5_a3 JTF_VARCHAR2_TABLE_2000
880: , p5_a4 JTF_VARCHAR2_TABLE_100
873: , x_return_status out nocopy VARCHAR2
874: , x_msg_count out nocopy NUMBER
875: , x_msg_data out nocopy VARCHAR2
876: , p5_a0 JTF_NUMBER_TABLE
877: , p5_a1 JTF_NUMBER_TABLE
878: , p5_a2 JTF_VARCHAR2_TABLE_200
879: , p5_a3 JTF_VARCHAR2_TABLE_2000
880: , p5_a4 JTF_VARCHAR2_TABLE_100
881: , p5_a5 JTF_DATE_TABLE
879: , p5_a3 JTF_VARCHAR2_TABLE_2000
880: , p5_a4 JTF_VARCHAR2_TABLE_100
881: , p5_a5 JTF_DATE_TABLE
882: , p5_a6 JTF_DATE_TABLE
883: , p5_a7 JTF_NUMBER_TABLE
884: , p5_a8 JTF_DATE_TABLE
885: , p5_a9 JTF_NUMBER_TABLE
886: , p5_a10 JTF_DATE_TABLE
887: , p5_a11 JTF_NUMBER_TABLE
881: , p5_a5 JTF_DATE_TABLE
882: , p5_a6 JTF_DATE_TABLE
883: , p5_a7 JTF_NUMBER_TABLE
884: , p5_a8 JTF_DATE_TABLE
885: , p5_a9 JTF_NUMBER_TABLE
886: , p5_a10 JTF_DATE_TABLE
887: , p5_a11 JTF_NUMBER_TABLE
888: )
889:
883: , p5_a7 JTF_NUMBER_TABLE
884: , p5_a8 JTF_DATE_TABLE
885: , p5_a9 JTF_NUMBER_TABLE
886: , p5_a10 JTF_DATE_TABLE
887: , p5_a11 JTF_NUMBER_TABLE
888: )
889:
890: as
891: ddp_pqyv_tbl okl_pdt_qualitys_pub.pqyv_tbl_type;
991: , p_init_msg_list VARCHAR2
992: , x_return_status out nocopy VARCHAR2
993: , x_msg_count out nocopy NUMBER
994: , x_msg_data out nocopy VARCHAR2
995: , p5_a0 JTF_NUMBER_TABLE
996: , p5_a1 JTF_NUMBER_TABLE
997: , p5_a2 JTF_VARCHAR2_TABLE_200
998: , p5_a3 JTF_VARCHAR2_TABLE_2000
999: , p5_a4 JTF_VARCHAR2_TABLE_100
992: , x_return_status out nocopy VARCHAR2
993: , x_msg_count out nocopy NUMBER
994: , x_msg_data out nocopy VARCHAR2
995: , p5_a0 JTF_NUMBER_TABLE
996: , p5_a1 JTF_NUMBER_TABLE
997: , p5_a2 JTF_VARCHAR2_TABLE_200
998: , p5_a3 JTF_VARCHAR2_TABLE_2000
999: , p5_a4 JTF_VARCHAR2_TABLE_100
1000: , p5_a5 JTF_DATE_TABLE
998: , p5_a3 JTF_VARCHAR2_TABLE_2000
999: , p5_a4 JTF_VARCHAR2_TABLE_100
1000: , p5_a5 JTF_DATE_TABLE
1001: , p5_a6 JTF_DATE_TABLE
1002: , p5_a7 JTF_NUMBER_TABLE
1003: , p5_a8 JTF_DATE_TABLE
1004: , p5_a9 JTF_NUMBER_TABLE
1005: , p5_a10 JTF_DATE_TABLE
1006: , p5_a11 JTF_NUMBER_TABLE
1000: , p5_a5 JTF_DATE_TABLE
1001: , p5_a6 JTF_DATE_TABLE
1002: , p5_a7 JTF_NUMBER_TABLE
1003: , p5_a8 JTF_DATE_TABLE
1004: , p5_a9 JTF_NUMBER_TABLE
1005: , p5_a10 JTF_DATE_TABLE
1006: , p5_a11 JTF_NUMBER_TABLE
1007: )
1008:
1002: , p5_a7 JTF_NUMBER_TABLE
1003: , p5_a8 JTF_DATE_TABLE
1004: , p5_a9 JTF_NUMBER_TABLE
1005: , p5_a10 JTF_DATE_TABLE
1006: , p5_a11 JTF_NUMBER_TABLE
1007: )
1008:
1009: as
1010: ddp_pqyv_tbl okl_pdt_qualitys_pub.pqyv_tbl_type;
1110: , p_init_msg_list VARCHAR2
1111: , x_return_status out nocopy VARCHAR2
1112: , x_msg_count out nocopy NUMBER
1113: , x_msg_data out nocopy VARCHAR2
1114: , p5_a0 JTF_NUMBER_TABLE
1115: , p5_a1 JTF_NUMBER_TABLE
1116: , p5_a2 JTF_NUMBER_TABLE
1117: , p5_a3 JTF_VARCHAR2_TABLE_200
1118: , p5_a4 JTF_VARCHAR2_TABLE_2000
1111: , x_return_status out nocopy VARCHAR2
1112: , x_msg_count out nocopy NUMBER
1113: , x_msg_data out nocopy VARCHAR2
1114: , p5_a0 JTF_NUMBER_TABLE
1115: , p5_a1 JTF_NUMBER_TABLE
1116: , p5_a2 JTF_NUMBER_TABLE
1117: , p5_a3 JTF_VARCHAR2_TABLE_200
1118: , p5_a4 JTF_VARCHAR2_TABLE_2000
1119: , p5_a5 JTF_DATE_TABLE
1112: , x_msg_count out nocopy NUMBER
1113: , x_msg_data out nocopy VARCHAR2
1114: , p5_a0 JTF_NUMBER_TABLE
1115: , p5_a1 JTF_NUMBER_TABLE
1116: , p5_a2 JTF_NUMBER_TABLE
1117: , p5_a3 JTF_VARCHAR2_TABLE_200
1118: , p5_a4 JTF_VARCHAR2_TABLE_2000
1119: , p5_a5 JTF_DATE_TABLE
1120: , p5_a6 JTF_DATE_TABLE
1117: , p5_a3 JTF_VARCHAR2_TABLE_200
1118: , p5_a4 JTF_VARCHAR2_TABLE_2000
1119: , p5_a5 JTF_DATE_TABLE
1120: , p5_a6 JTF_DATE_TABLE
1121: , p5_a7 JTF_NUMBER_TABLE
1122: , p5_a8 JTF_DATE_TABLE
1123: , p5_a9 JTF_NUMBER_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1119: , p5_a5 JTF_DATE_TABLE
1120: , p5_a6 JTF_DATE_TABLE
1121: , p5_a7 JTF_NUMBER_TABLE
1122: , p5_a8 JTF_DATE_TABLE
1123: , p5_a9 JTF_NUMBER_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1121: , p5_a7 JTF_NUMBER_TABLE
1122: , p5_a8 JTF_DATE_TABLE
1123: , p5_a9 JTF_NUMBER_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1122: , p5_a8 JTF_DATE_TABLE
1123: , p5_a9 JTF_NUMBER_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a9 JTF_NUMBER_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1124: , p5_a10 JTF_DATE_TABLE
1125: , p5_a11 JTF_NUMBER_TABLE
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1132: , p6_a6 out nocopy JTF_DATE_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1132: , p6_a6 out nocopy JTF_DATE_TABLE
1133: , p6_a7 out nocopy JTF_NUMBER_TABLE
1134: , p6_a8 out nocopy JTF_DATE_TABLE
1135: , p6_a9 out nocopy JTF_NUMBER_TABLE
1136: , p6_a10 out nocopy JTF_DATE_TABLE
1137: , p6_a11 out nocopy JTF_NUMBER_TABLE
1131: , p6_a5 out nocopy JTF_DATE_TABLE
1132: , p6_a6 out nocopy JTF_DATE_TABLE
1133: , p6_a7 out nocopy JTF_NUMBER_TABLE
1134: , p6_a8 out nocopy JTF_DATE_TABLE
1135: , p6_a9 out nocopy JTF_NUMBER_TABLE
1136: , p6_a10 out nocopy JTF_DATE_TABLE
1137: , p6_a11 out nocopy JTF_NUMBER_TABLE
1138: )
1139:
1133: , p6_a7 out nocopy JTF_NUMBER_TABLE
1134: , p6_a8 out nocopy JTF_DATE_TABLE
1135: , p6_a9 out nocopy JTF_NUMBER_TABLE
1136: , p6_a10 out nocopy JTF_DATE_TABLE
1137: , p6_a11 out nocopy JTF_NUMBER_TABLE
1138: )
1139:
1140: as
1141: ddp_qvev_tbl okl_pdt_qualitys_pub.qvev_tbl_type;
1286: , p_init_msg_list VARCHAR2
1287: , x_return_status out nocopy VARCHAR2
1288: , x_msg_count out nocopy NUMBER
1289: , x_msg_data out nocopy VARCHAR2
1290: , p5_a0 JTF_NUMBER_TABLE
1291: , p5_a1 JTF_NUMBER_TABLE
1292: , p5_a2 JTF_NUMBER_TABLE
1293: , p5_a3 JTF_VARCHAR2_TABLE_200
1294: , p5_a4 JTF_VARCHAR2_TABLE_2000
1287: , x_return_status out nocopy VARCHAR2
1288: , x_msg_count out nocopy NUMBER
1289: , x_msg_data out nocopy VARCHAR2
1290: , p5_a0 JTF_NUMBER_TABLE
1291: , p5_a1 JTF_NUMBER_TABLE
1292: , p5_a2 JTF_NUMBER_TABLE
1293: , p5_a3 JTF_VARCHAR2_TABLE_200
1294: , p5_a4 JTF_VARCHAR2_TABLE_2000
1295: , p5_a5 JTF_DATE_TABLE
1288: , x_msg_count out nocopy NUMBER
1289: , x_msg_data out nocopy VARCHAR2
1290: , p5_a0 JTF_NUMBER_TABLE
1291: , p5_a1 JTF_NUMBER_TABLE
1292: , p5_a2 JTF_NUMBER_TABLE
1293: , p5_a3 JTF_VARCHAR2_TABLE_200
1294: , p5_a4 JTF_VARCHAR2_TABLE_2000
1295: , p5_a5 JTF_DATE_TABLE
1296: , p5_a6 JTF_DATE_TABLE
1293: , p5_a3 JTF_VARCHAR2_TABLE_200
1294: , p5_a4 JTF_VARCHAR2_TABLE_2000
1295: , p5_a5 JTF_DATE_TABLE
1296: , p5_a6 JTF_DATE_TABLE
1297: , p5_a7 JTF_NUMBER_TABLE
1298: , p5_a8 JTF_DATE_TABLE
1299: , p5_a9 JTF_NUMBER_TABLE
1300: , p5_a10 JTF_DATE_TABLE
1301: , p5_a11 JTF_NUMBER_TABLE
1295: , p5_a5 JTF_DATE_TABLE
1296: , p5_a6 JTF_DATE_TABLE
1297: , p5_a7 JTF_NUMBER_TABLE
1298: , p5_a8 JTF_DATE_TABLE
1299: , p5_a9 JTF_NUMBER_TABLE
1300: , p5_a10 JTF_DATE_TABLE
1301: , p5_a11 JTF_NUMBER_TABLE
1302: )
1303:
1297: , p5_a7 JTF_NUMBER_TABLE
1298: , p5_a8 JTF_DATE_TABLE
1299: , p5_a9 JTF_NUMBER_TABLE
1300: , p5_a10 JTF_DATE_TABLE
1301: , p5_a11 JTF_NUMBER_TABLE
1302: )
1303:
1304: as
1305: ddp_qvev_tbl okl_pdt_qualitys_pub.qvev_tbl_type;
1405: , p_init_msg_list VARCHAR2
1406: , x_return_status out nocopy VARCHAR2
1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_NUMBER_TABLE
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_2000
1406: , x_return_status out nocopy VARCHAR2
1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_NUMBER_TABLE
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_2000
1414: , p5_a5 JTF_DATE_TABLE
1407: , x_msg_count out nocopy NUMBER
1408: , x_msg_data out nocopy VARCHAR2
1409: , p5_a0 JTF_NUMBER_TABLE
1410: , p5_a1 JTF_NUMBER_TABLE
1411: , p5_a2 JTF_NUMBER_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_2000
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_DATE_TABLE
1412: , p5_a3 JTF_VARCHAR2_TABLE_200
1413: , p5_a4 JTF_VARCHAR2_TABLE_2000
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_DATE_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_DATE_TABLE
1418: , p5_a9 JTF_NUMBER_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1414: , p5_a5 JTF_DATE_TABLE
1415: , p5_a6 JTF_DATE_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_DATE_TABLE
1418: , p5_a9 JTF_NUMBER_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1421: , p6_a0 out nocopy JTF_NUMBER_TABLE
1422: , p6_a1 out nocopy JTF_NUMBER_TABLE
1416: , p5_a7 JTF_NUMBER_TABLE
1417: , p5_a8 JTF_DATE_TABLE
1418: , p5_a9 JTF_NUMBER_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1421: , p6_a0 out nocopy JTF_NUMBER_TABLE
1422: , p6_a1 out nocopy JTF_NUMBER_TABLE
1423: , p6_a2 out nocopy JTF_NUMBER_TABLE
1424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1417: , p5_a8 JTF_DATE_TABLE
1418: , p5_a9 JTF_NUMBER_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1421: , p6_a0 out nocopy JTF_NUMBER_TABLE
1422: , p6_a1 out nocopy JTF_NUMBER_TABLE
1423: , p6_a2 out nocopy JTF_NUMBER_TABLE
1424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1418: , p5_a9 JTF_NUMBER_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1421: , p6_a0 out nocopy JTF_NUMBER_TABLE
1422: , p6_a1 out nocopy JTF_NUMBER_TABLE
1423: , p6_a2 out nocopy JTF_NUMBER_TABLE
1424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1426: , p6_a5 out nocopy JTF_DATE_TABLE
1419: , p5_a10 JTF_DATE_TABLE
1420: , p5_a11 JTF_NUMBER_TABLE
1421: , p6_a0 out nocopy JTF_NUMBER_TABLE
1422: , p6_a1 out nocopy JTF_NUMBER_TABLE
1423: , p6_a2 out nocopy JTF_NUMBER_TABLE
1424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1426: , p6_a5 out nocopy JTF_DATE_TABLE
1427: , p6_a6 out nocopy JTF_DATE_TABLE
1424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1426: , p6_a5 out nocopy JTF_DATE_TABLE
1427: , p6_a6 out nocopy JTF_DATE_TABLE
1428: , p6_a7 out nocopy JTF_NUMBER_TABLE
1429: , p6_a8 out nocopy JTF_DATE_TABLE
1430: , p6_a9 out nocopy JTF_NUMBER_TABLE
1431: , p6_a10 out nocopy JTF_DATE_TABLE
1432: , p6_a11 out nocopy JTF_NUMBER_TABLE
1426: , p6_a5 out nocopy JTF_DATE_TABLE
1427: , p6_a6 out nocopy JTF_DATE_TABLE
1428: , p6_a7 out nocopy JTF_NUMBER_TABLE
1429: , p6_a8 out nocopy JTF_DATE_TABLE
1430: , p6_a9 out nocopy JTF_NUMBER_TABLE
1431: , p6_a10 out nocopy JTF_DATE_TABLE
1432: , p6_a11 out nocopy JTF_NUMBER_TABLE
1433: )
1434:
1428: , p6_a7 out nocopy JTF_NUMBER_TABLE
1429: , p6_a8 out nocopy JTF_DATE_TABLE
1430: , p6_a9 out nocopy JTF_NUMBER_TABLE
1431: , p6_a10 out nocopy JTF_DATE_TABLE
1432: , p6_a11 out nocopy JTF_NUMBER_TABLE
1433: )
1434:
1435: as
1436: ddp_qvev_tbl okl_pdt_qualitys_pub.qvev_tbl_type;
1581: , p_init_msg_list VARCHAR2
1582: , x_return_status out nocopy VARCHAR2
1583: , x_msg_count out nocopy NUMBER
1584: , x_msg_data out nocopy VARCHAR2
1585: , p5_a0 JTF_NUMBER_TABLE
1586: , p5_a1 JTF_NUMBER_TABLE
1587: , p5_a2 JTF_NUMBER_TABLE
1588: , p5_a3 JTF_VARCHAR2_TABLE_200
1589: , p5_a4 JTF_VARCHAR2_TABLE_2000
1582: , x_return_status out nocopy VARCHAR2
1583: , x_msg_count out nocopy NUMBER
1584: , x_msg_data out nocopy VARCHAR2
1585: , p5_a0 JTF_NUMBER_TABLE
1586: , p5_a1 JTF_NUMBER_TABLE
1587: , p5_a2 JTF_NUMBER_TABLE
1588: , p5_a3 JTF_VARCHAR2_TABLE_200
1589: , p5_a4 JTF_VARCHAR2_TABLE_2000
1590: , p5_a5 JTF_DATE_TABLE
1583: , x_msg_count out nocopy NUMBER
1584: , x_msg_data out nocopy VARCHAR2
1585: , p5_a0 JTF_NUMBER_TABLE
1586: , p5_a1 JTF_NUMBER_TABLE
1587: , p5_a2 JTF_NUMBER_TABLE
1588: , p5_a3 JTF_VARCHAR2_TABLE_200
1589: , p5_a4 JTF_VARCHAR2_TABLE_2000
1590: , p5_a5 JTF_DATE_TABLE
1591: , p5_a6 JTF_DATE_TABLE
1588: , p5_a3 JTF_VARCHAR2_TABLE_200
1589: , p5_a4 JTF_VARCHAR2_TABLE_2000
1590: , p5_a5 JTF_DATE_TABLE
1591: , p5_a6 JTF_DATE_TABLE
1592: , p5_a7 JTF_NUMBER_TABLE
1593: , p5_a8 JTF_DATE_TABLE
1594: , p5_a9 JTF_NUMBER_TABLE
1595: , p5_a10 JTF_DATE_TABLE
1596: , p5_a11 JTF_NUMBER_TABLE
1590: , p5_a5 JTF_DATE_TABLE
1591: , p5_a6 JTF_DATE_TABLE
1592: , p5_a7 JTF_NUMBER_TABLE
1593: , p5_a8 JTF_DATE_TABLE
1594: , p5_a9 JTF_NUMBER_TABLE
1595: , p5_a10 JTF_DATE_TABLE
1596: , p5_a11 JTF_NUMBER_TABLE
1597: )
1598:
1592: , p5_a7 JTF_NUMBER_TABLE
1593: , p5_a8 JTF_DATE_TABLE
1594: , p5_a9 JTF_NUMBER_TABLE
1595: , p5_a10 JTF_DATE_TABLE
1596: , p5_a11 JTF_NUMBER_TABLE
1597: )
1598:
1599: as
1600: ddp_qvev_tbl okl_pdt_qualitys_pub.qvev_tbl_type;
1700: , p_init_msg_list VARCHAR2
1701: , x_return_status out nocopy VARCHAR2
1702: , x_msg_count out nocopy NUMBER
1703: , x_msg_data out nocopy VARCHAR2
1704: , p5_a0 JTF_NUMBER_TABLE
1705: , p5_a1 JTF_NUMBER_TABLE
1706: , p5_a2 JTF_NUMBER_TABLE
1707: , p5_a3 JTF_VARCHAR2_TABLE_200
1708: , p5_a4 JTF_VARCHAR2_TABLE_2000
1701: , x_return_status out nocopy VARCHAR2
1702: , x_msg_count out nocopy NUMBER
1703: , x_msg_data out nocopy VARCHAR2
1704: , p5_a0 JTF_NUMBER_TABLE
1705: , p5_a1 JTF_NUMBER_TABLE
1706: , p5_a2 JTF_NUMBER_TABLE
1707: , p5_a3 JTF_VARCHAR2_TABLE_200
1708: , p5_a4 JTF_VARCHAR2_TABLE_2000
1709: , p5_a5 JTF_DATE_TABLE
1702: , x_msg_count out nocopy NUMBER
1703: , x_msg_data out nocopy VARCHAR2
1704: , p5_a0 JTF_NUMBER_TABLE
1705: , p5_a1 JTF_NUMBER_TABLE
1706: , p5_a2 JTF_NUMBER_TABLE
1707: , p5_a3 JTF_VARCHAR2_TABLE_200
1708: , p5_a4 JTF_VARCHAR2_TABLE_2000
1709: , p5_a5 JTF_DATE_TABLE
1710: , p5_a6 JTF_DATE_TABLE
1707: , p5_a3 JTF_VARCHAR2_TABLE_200
1708: , p5_a4 JTF_VARCHAR2_TABLE_2000
1709: , p5_a5 JTF_DATE_TABLE
1710: , p5_a6 JTF_DATE_TABLE
1711: , p5_a7 JTF_NUMBER_TABLE
1712: , p5_a8 JTF_DATE_TABLE
1713: , p5_a9 JTF_NUMBER_TABLE
1714: , p5_a10 JTF_DATE_TABLE
1715: , p5_a11 JTF_NUMBER_TABLE
1709: , p5_a5 JTF_DATE_TABLE
1710: , p5_a6 JTF_DATE_TABLE
1711: , p5_a7 JTF_NUMBER_TABLE
1712: , p5_a8 JTF_DATE_TABLE
1713: , p5_a9 JTF_NUMBER_TABLE
1714: , p5_a10 JTF_DATE_TABLE
1715: , p5_a11 JTF_NUMBER_TABLE
1716: )
1717:
1711: , p5_a7 JTF_NUMBER_TABLE
1712: , p5_a8 JTF_DATE_TABLE
1713: , p5_a9 JTF_NUMBER_TABLE
1714: , p5_a10 JTF_DATE_TABLE
1715: , p5_a11 JTF_NUMBER_TABLE
1716: )
1717:
1718: as
1719: ddp_qvev_tbl okl_pdt_qualitys_pub.qvev_tbl_type;