1: package okl_opt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOPTS.pls 115.3 2002/12/24 04:06:02 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
1: package okl_opt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOPTS.pls 115.3 2002/12/24 04:06:02 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_VARCHAR2_TABLE_200
33: , a2 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_VARCHAR2_TABLE_200
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
35: , a4 out nocopy JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_VARCHAR2_TABLE_200
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
35: , a4 out nocopy JTF_DATE_TABLE
36: , a5 out nocopy JTF_DATE_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a18 out nocopy JTF_VARCHAR2_TABLE_500
50: , a19 out nocopy JTF_VARCHAR2_TABLE_500
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_VARCHAR2_TABLE_200
63: , a3 JTF_VARCHAR2_TABLE_2000
64: , a4 JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_VARCHAR2_TABLE_200
63: , a3 JTF_VARCHAR2_TABLE_2000
64: , a4 JTF_DATE_TABLE
65: , a5 JTF_DATE_TABLE
78: , a18 JTF_VARCHAR2_TABLE_500
79: , a19 JTF_VARCHAR2_TABLE_500
80: , a20 JTF_VARCHAR2_TABLE_500
81: , a21 JTF_VARCHAR2_TABLE_500
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
80: , a20 JTF_VARCHAR2_TABLE_500
81: , a21 JTF_VARCHAR2_TABLE_500
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_DATE_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
106: , a18 out nocopy JTF_VARCHAR2_TABLE_500
107: , a19 out nocopy JTF_VARCHAR2_TABLE_500
108: , a20 out nocopy JTF_VARCHAR2_TABLE_500
109: , a21 out nocopy JTF_VARCHAR2_TABLE_500
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_VARCHAR2_TABLE_500
109: , a21 out nocopy JTF_VARCHAR2_TABLE_500
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
115: );
116:
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
115: );
116:
117: procedure insert_row(p_api_version NUMBER
118: , p_init_msg_list VARCHAR2
178: , p_init_msg_list VARCHAR2
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_DATE_TABLE
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_DATE_TABLE
187: , p5_a5 JTF_DATE_TABLE
200: , p5_a18 JTF_VARCHAR2_TABLE_500
201: , p5_a19 JTF_VARCHAR2_TABLE_500
202: , p5_a20 JTF_VARCHAR2_TABLE_500
203: , p5_a21 JTF_VARCHAR2_TABLE_500
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
202: , p5_a20 JTF_VARCHAR2_TABLE_500
203: , p5_a21 JTF_VARCHAR2_TABLE_500
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a4 out nocopy JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a4 out nocopy JTF_DATE_TABLE
214: , p6_a5 out nocopy JTF_DATE_TABLE
227: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
228: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
229: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
230: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
229: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
230: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
236: );
237: procedure lock_row(p_api_version NUMBER
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
236: );
237: procedure lock_row(p_api_version NUMBER
238: , p_init_msg_list VARCHAR2
239: , x_return_status out nocopy VARCHAR2
271: , p_init_msg_list VARCHAR2
272: , x_return_status out nocopy VARCHAR2
273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_VARCHAR2_TABLE_200
278: , p5_a3 JTF_VARCHAR2_TABLE_2000
279: , p5_a4 JTF_DATE_TABLE
272: , x_return_status out nocopy VARCHAR2
273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_VARCHAR2_TABLE_200
278: , p5_a3 JTF_VARCHAR2_TABLE_2000
279: , p5_a4 JTF_DATE_TABLE
280: , p5_a5 JTF_DATE_TABLE
293: , p5_a18 JTF_VARCHAR2_TABLE_500
294: , p5_a19 JTF_VARCHAR2_TABLE_500
295: , p5_a20 JTF_VARCHAR2_TABLE_500
296: , p5_a21 JTF_VARCHAR2_TABLE_500
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
295: , p5_a20 JTF_VARCHAR2_TABLE_500
296: , p5_a21 JTF_VARCHAR2_TABLE_500
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
302: );
303: procedure update_row(p_api_version NUMBER
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
302: );
303: procedure update_row(p_api_version NUMBER
304: , p_init_msg_list VARCHAR2
305: , x_return_status out nocopy VARCHAR2
364: , p_init_msg_list VARCHAR2
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_VARCHAR2_TABLE_200
371: , p5_a3 JTF_VARCHAR2_TABLE_2000
372: , p5_a4 JTF_DATE_TABLE
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_VARCHAR2_TABLE_200
371: , p5_a3 JTF_VARCHAR2_TABLE_2000
372: , p5_a4 JTF_DATE_TABLE
373: , p5_a5 JTF_DATE_TABLE
386: , p5_a18 JTF_VARCHAR2_TABLE_500
387: , p5_a19 JTF_VARCHAR2_TABLE_500
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_VARCHAR2_TABLE_500
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_VARCHAR2_TABLE_500
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
399: , p6_a4 out nocopy JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
399: , p6_a4 out nocopy JTF_DATE_TABLE
400: , p6_a5 out nocopy JTF_DATE_TABLE
413: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_row(p_api_version NUMBER
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_row(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2
425: , x_return_status out nocopy VARCHAR2
457: , p_init_msg_list VARCHAR2
458: , x_return_status out nocopy VARCHAR2
459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_VARCHAR2_TABLE_200
464: , p5_a3 JTF_VARCHAR2_TABLE_2000
465: , p5_a4 JTF_DATE_TABLE
458: , x_return_status out nocopy VARCHAR2
459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_VARCHAR2_TABLE_200
464: , p5_a3 JTF_VARCHAR2_TABLE_2000
465: , p5_a4 JTF_DATE_TABLE
466: , p5_a5 JTF_DATE_TABLE
479: , p5_a18 JTF_VARCHAR2_TABLE_500
480: , p5_a19 JTF_VARCHAR2_TABLE_500
481: , p5_a20 JTF_VARCHAR2_TABLE_500
482: , p5_a21 JTF_VARCHAR2_TABLE_500
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a20 JTF_VARCHAR2_TABLE_500
482: , p5_a21 JTF_VARCHAR2_TABLE_500
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
488: );
489: procedure validate_row(p_api_version NUMBER
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
488: );
489: procedure validate_row(p_api_version NUMBER
490: , p_init_msg_list VARCHAR2
491: , x_return_status out nocopy VARCHAR2
523: , p_init_msg_list VARCHAR2
524: , x_return_status out nocopy VARCHAR2
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_VARCHAR2_TABLE_200
530: , p5_a3 JTF_VARCHAR2_TABLE_2000
531: , p5_a4 JTF_DATE_TABLE
524: , x_return_status out nocopy VARCHAR2
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_VARCHAR2_TABLE_200
530: , p5_a3 JTF_VARCHAR2_TABLE_2000
531: , p5_a4 JTF_DATE_TABLE
532: , p5_a5 JTF_DATE_TABLE
545: , p5_a18 JTF_VARCHAR2_TABLE_500
546: , p5_a19 JTF_VARCHAR2_TABLE_500
547: , p5_a20 JTF_VARCHAR2_TABLE_500
548: , p5_a21 JTF_VARCHAR2_TABLE_500
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
547: , p5_a20 JTF_VARCHAR2_TABLE_500
548: , p5_a21 JTF_VARCHAR2_TABLE_500
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
554: );
555: end okl_opt_pvt_w;
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
554: );
555: end okl_opt_pvt_w;