1: package okl_lrf_pvt_w as
2: /* $Header: OKLILRFS.pls 120.1 2005/07/05 12:29:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_lrf_pvt_w as
2: /* $Header: OKLILRFS.pls 120.1 2005/07/05 12:29:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package okl_lrf_pvt_w as
2: /* $Header: OKLILRFS.pls 120.1 2005/07/05 12:29:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLILRFS.pls 120.1 2005/07/05 12:29:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p28(t out nocopy okl_lrf_pvt.lrfv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
34: procedure rosetta_table_copy_out_p28(t okl_lrf_pvt.lrfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_DATE_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_DATE_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_DATE_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_VARCHAR2_TABLE_100
47: , a13 out nocopy JTF_VARCHAR2_TABLE_500
41: , a7 out nocopy JTF_NUMBER_TABLE
42: , a8 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_DATE_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_VARCHAR2_TABLE_100
47: , a13 out nocopy JTF_VARCHAR2_TABLE_500
48: , a14 out nocopy JTF_VARCHAR2_TABLE_500
49: , a15 out nocopy JTF_VARCHAR2_TABLE_500
59: , a25 out nocopy JTF_VARCHAR2_TABLE_500
60: , a26 out nocopy JTF_VARCHAR2_TABLE_500
61: , a27 out nocopy JTF_VARCHAR2_TABLE_500
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
65:
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
66: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrf_pvt.lrf_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_DATE_TABLE
69: , a3 JTF_NUMBER_TABLE
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_DATE_TABLE
77: , a11 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_DATE_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_VARCHAR2_TABLE_500
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_DATE_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_VARCHAR2_TABLE_500
80: , a14 JTF_VARCHAR2_TABLE_500
81: , a15 JTF_VARCHAR2_TABLE_500
91: , a25 JTF_VARCHAR2_TABLE_500
92: , a26 JTF_VARCHAR2_TABLE_500
93: , a27 JTF_VARCHAR2_TABLE_500
94: , a28 JTF_VARCHAR2_TABLE_100
95: , a29 JTF_NUMBER_TABLE
96: );
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
93: , a27 JTF_VARCHAR2_TABLE_500
94: , a28 JTF_VARCHAR2_TABLE_100
95: , a29 JTF_NUMBER_TABLE
96: );
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
94: , a28 JTF_VARCHAR2_TABLE_100
95: , a29 JTF_NUMBER_TABLE
96: );
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
95: , a29 JTF_NUMBER_TABLE
96: );
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
96: );
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
97: procedure rosetta_table_copy_out_p31(t okl_lrf_pvt.lrf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
106: , a9 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
106: , a9 out nocopy JTF_NUMBER_TABLE
107: , a10 out nocopy JTF_DATE_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
106: , a9 out nocopy JTF_NUMBER_TABLE
107: , a10 out nocopy JTF_DATE_TABLE
108: , a11 out nocopy JTF_NUMBER_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
106: , a9 out nocopy JTF_NUMBER_TABLE
107: , a10 out nocopy JTF_DATE_TABLE
108: , a11 out nocopy JTF_NUMBER_TABLE
109: , a12 out nocopy JTF_VARCHAR2_TABLE_100
110: , a13 out nocopy JTF_VARCHAR2_TABLE_500
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_DATE_TABLE
106: , a9 out nocopy JTF_NUMBER_TABLE
107: , a10 out nocopy JTF_DATE_TABLE
108: , a11 out nocopy JTF_NUMBER_TABLE
109: , a12 out nocopy JTF_VARCHAR2_TABLE_100
110: , a13 out nocopy JTF_VARCHAR2_TABLE_500
111: , a14 out nocopy JTF_VARCHAR2_TABLE_500
112: , a15 out nocopy JTF_VARCHAR2_TABLE_500
122: , a25 out nocopy JTF_VARCHAR2_TABLE_500
123: , a26 out nocopy JTF_VARCHAR2_TABLE_500
124: , a27 out nocopy JTF_VARCHAR2_TABLE_500
125: , a28 out nocopy JTF_VARCHAR2_TABLE_100
126: , a29 out nocopy JTF_NUMBER_TABLE
127: );
128:
129: procedure insert_row(p_api_version NUMBER
130: , p_init_msg_list VARCHAR2
196: , p_init_msg_list VARCHAR2
197: , x_return_status out nocopy VARCHAR2
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
197: , x_return_status out nocopy VARCHAR2
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
199: , x_msg_data out nocopy VARCHAR2
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
200: , p5_a0 JTF_NUMBER_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
201: , p5_a1 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
209: , p5_a9 JTF_NUMBER_TABLE
202: , p5_a2 JTF_NUMBER_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
209: , p5_a9 JTF_NUMBER_TABLE
210: , p5_a10 JTF_DATE_TABLE
203: , p5_a3 JTF_NUMBER_TABLE
204: , p5_a4 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
209: , p5_a9 JTF_NUMBER_TABLE
210: , p5_a10 JTF_DATE_TABLE
211: , p5_a11 JTF_NUMBER_TABLE
205: , p5_a5 JTF_NUMBER_TABLE
206: , p5_a6 JTF_NUMBER_TABLE
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
209: , p5_a9 JTF_NUMBER_TABLE
210: , p5_a10 JTF_DATE_TABLE
211: , p5_a11 JTF_NUMBER_TABLE
212: , p5_a12 JTF_VARCHAR2_TABLE_100
213: , p5_a13 JTF_VARCHAR2_TABLE_500
207: , p5_a7 JTF_NUMBER_TABLE
208: , p5_a8 JTF_DATE_TABLE
209: , p5_a9 JTF_NUMBER_TABLE
210: , p5_a10 JTF_DATE_TABLE
211: , p5_a11 JTF_NUMBER_TABLE
212: , p5_a12 JTF_VARCHAR2_TABLE_100
213: , p5_a13 JTF_VARCHAR2_TABLE_500
214: , p5_a14 JTF_VARCHAR2_TABLE_500
215: , p5_a15 JTF_VARCHAR2_TABLE_500
225: , p5_a25 JTF_VARCHAR2_TABLE_500
226: , p5_a26 JTF_VARCHAR2_TABLE_500
227: , p5_a27 JTF_VARCHAR2_TABLE_500
228: , p5_a28 JTF_VARCHAR2_TABLE_100
229: , p5_a29 JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
226: , p5_a26 JTF_VARCHAR2_TABLE_500
227: , p5_a27 JTF_VARCHAR2_TABLE_500
228: , p5_a28 JTF_VARCHAR2_TABLE_100
229: , p5_a29 JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
227: , p5_a27 JTF_VARCHAR2_TABLE_500
228: , p5_a28 JTF_VARCHAR2_TABLE_100
229: , p5_a29 JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
228: , p5_a28 JTF_VARCHAR2_TABLE_100
229: , p5_a29 JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
229: , p5_a29 JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
230: , p6_a0 out nocopy JTF_NUMBER_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
231: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
239: , p6_a9 out nocopy JTF_NUMBER_TABLE
232: , p6_a2 out nocopy JTF_NUMBER_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
239: , p6_a9 out nocopy JTF_NUMBER_TABLE
240: , p6_a10 out nocopy JTF_DATE_TABLE
233: , p6_a3 out nocopy JTF_NUMBER_TABLE
234: , p6_a4 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
239: , p6_a9 out nocopy JTF_NUMBER_TABLE
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_NUMBER_TABLE
235: , p6_a5 out nocopy JTF_NUMBER_TABLE
236: , p6_a6 out nocopy JTF_NUMBER_TABLE
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
239: , p6_a9 out nocopy JTF_NUMBER_TABLE
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_NUMBER_TABLE
242: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
237: , p6_a7 out nocopy JTF_NUMBER_TABLE
238: , p6_a8 out nocopy JTF_DATE_TABLE
239: , p6_a9 out nocopy JTF_NUMBER_TABLE
240: , p6_a10 out nocopy JTF_DATE_TABLE
241: , p6_a11 out nocopy JTF_NUMBER_TABLE
242: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
255: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a29 out nocopy JTF_NUMBER_TABLE
260: );
261: procedure lock_row(p_api_version NUMBER
262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2
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_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
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_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
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_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_NUMBER_TABLE
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_NUMBER_TABLE
310: , p5_a8 JTF_DATE_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_NUMBER_TABLE
310: , p5_a8 JTF_DATE_TABLE
311: , p5_a9 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_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
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_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
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_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: , p5_a12 JTF_VARCHAR2_TABLE_100
315: , p5_a13 JTF_VARCHAR2_TABLE_500
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: , p5_a12 JTF_VARCHAR2_TABLE_100
315: , p5_a13 JTF_VARCHAR2_TABLE_500
316: , p5_a14 JTF_VARCHAR2_TABLE_500
317: , p5_a15 JTF_VARCHAR2_TABLE_500
327: , p5_a25 JTF_VARCHAR2_TABLE_500
328: , p5_a26 JTF_VARCHAR2_TABLE_500
329: , p5_a27 JTF_VARCHAR2_TABLE_500
330: , p5_a28 JTF_VARCHAR2_TABLE_100
331: , p5_a29 JTF_NUMBER_TABLE
332: );
333: procedure update_row(p_api_version NUMBER
334: , p_init_msg_list VARCHAR2
335: , x_return_status out nocopy VARCHAR2
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: , p5_a0 JTF_NUMBER_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
401: , x_return_status out nocopy VARCHAR2
402: , x_msg_count out nocopy NUMBER
403: , x_msg_data out nocopy VARCHAR2
404: , p5_a0 JTF_NUMBER_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
402: , x_msg_count out nocopy NUMBER
403: , x_msg_data out nocopy VARCHAR2
404: , p5_a0 JTF_NUMBER_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
403: , x_msg_data out nocopy VARCHAR2
404: , p5_a0 JTF_NUMBER_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
404: , p5_a0 JTF_NUMBER_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
405: , p5_a1 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
413: , p5_a9 JTF_NUMBER_TABLE
406: , p5_a2 JTF_NUMBER_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
413: , p5_a9 JTF_NUMBER_TABLE
414: , p5_a10 JTF_DATE_TABLE
407: , p5_a3 JTF_NUMBER_TABLE
408: , p5_a4 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
413: , p5_a9 JTF_NUMBER_TABLE
414: , p5_a10 JTF_DATE_TABLE
415: , p5_a11 JTF_NUMBER_TABLE
409: , p5_a5 JTF_NUMBER_TABLE
410: , p5_a6 JTF_NUMBER_TABLE
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
413: , p5_a9 JTF_NUMBER_TABLE
414: , p5_a10 JTF_DATE_TABLE
415: , p5_a11 JTF_NUMBER_TABLE
416: , p5_a12 JTF_VARCHAR2_TABLE_100
417: , p5_a13 JTF_VARCHAR2_TABLE_500
411: , p5_a7 JTF_NUMBER_TABLE
412: , p5_a8 JTF_DATE_TABLE
413: , p5_a9 JTF_NUMBER_TABLE
414: , p5_a10 JTF_DATE_TABLE
415: , p5_a11 JTF_NUMBER_TABLE
416: , p5_a12 JTF_VARCHAR2_TABLE_100
417: , p5_a13 JTF_VARCHAR2_TABLE_500
418: , p5_a14 JTF_VARCHAR2_TABLE_500
419: , p5_a15 JTF_VARCHAR2_TABLE_500
429: , p5_a25 JTF_VARCHAR2_TABLE_500
430: , p5_a26 JTF_VARCHAR2_TABLE_500
431: , p5_a27 JTF_VARCHAR2_TABLE_500
432: , p5_a28 JTF_VARCHAR2_TABLE_100
433: , p5_a29 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
430: , p5_a26 JTF_VARCHAR2_TABLE_500
431: , p5_a27 JTF_VARCHAR2_TABLE_500
432: , p5_a28 JTF_VARCHAR2_TABLE_100
433: , p5_a29 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
431: , p5_a27 JTF_VARCHAR2_TABLE_500
432: , p5_a28 JTF_VARCHAR2_TABLE_100
433: , p5_a29 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
432: , p5_a28 JTF_VARCHAR2_TABLE_100
433: , p5_a29 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
433: , p5_a29 JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
434: , p6_a0 out nocopy JTF_NUMBER_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
435: , p6_a1 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
443: , p6_a9 out nocopy JTF_NUMBER_TABLE
436: , p6_a2 out nocopy JTF_NUMBER_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
443: , p6_a9 out nocopy JTF_NUMBER_TABLE
444: , p6_a10 out nocopy JTF_DATE_TABLE
437: , p6_a3 out nocopy JTF_NUMBER_TABLE
438: , p6_a4 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
443: , p6_a9 out nocopy JTF_NUMBER_TABLE
444: , p6_a10 out nocopy JTF_DATE_TABLE
445: , p6_a11 out nocopy JTF_NUMBER_TABLE
439: , p6_a5 out nocopy JTF_NUMBER_TABLE
440: , p6_a6 out nocopy JTF_NUMBER_TABLE
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
443: , p6_a9 out nocopy JTF_NUMBER_TABLE
444: , p6_a10 out nocopy JTF_DATE_TABLE
445: , p6_a11 out nocopy JTF_NUMBER_TABLE
446: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a7 out nocopy JTF_NUMBER_TABLE
442: , p6_a8 out nocopy JTF_DATE_TABLE
443: , p6_a9 out nocopy JTF_NUMBER_TABLE
444: , p6_a10 out nocopy JTF_DATE_TABLE
445: , p6_a11 out nocopy JTF_NUMBER_TABLE
446: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
448: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
449: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
459: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
460: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
461: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
462: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
463: , p6_a29 out nocopy JTF_NUMBER_TABLE
464: );
465: procedure delete_row(p_api_version NUMBER
466: , p_init_msg_list VARCHAR2
467: , x_return_status out nocopy VARCHAR2
502: , p_init_msg_list VARCHAR2
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
503: , x_return_status out nocopy VARCHAR2
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
504: , x_msg_count out nocopy NUMBER
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
505: , x_msg_data out nocopy VARCHAR2
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
506: , p5_a0 JTF_NUMBER_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
507: , p5_a1 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
508: , p5_a2 JTF_NUMBER_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
516: , p5_a10 JTF_DATE_TABLE
509: , p5_a3 JTF_NUMBER_TABLE
510: , p5_a4 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
516: , p5_a10 JTF_DATE_TABLE
517: , p5_a11 JTF_NUMBER_TABLE
511: , p5_a5 JTF_NUMBER_TABLE
512: , p5_a6 JTF_NUMBER_TABLE
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
516: , p5_a10 JTF_DATE_TABLE
517: , p5_a11 JTF_NUMBER_TABLE
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_500
513: , p5_a7 JTF_NUMBER_TABLE
514: , p5_a8 JTF_DATE_TABLE
515: , p5_a9 JTF_NUMBER_TABLE
516: , p5_a10 JTF_DATE_TABLE
517: , p5_a11 JTF_NUMBER_TABLE
518: , p5_a12 JTF_VARCHAR2_TABLE_100
519: , p5_a13 JTF_VARCHAR2_TABLE_500
520: , p5_a14 JTF_VARCHAR2_TABLE_500
521: , p5_a15 JTF_VARCHAR2_TABLE_500
531: , p5_a25 JTF_VARCHAR2_TABLE_500
532: , p5_a26 JTF_VARCHAR2_TABLE_500
533: , p5_a27 JTF_VARCHAR2_TABLE_500
534: , p5_a28 JTF_VARCHAR2_TABLE_100
535: , p5_a29 JTF_NUMBER_TABLE
536: );
537: procedure validate_row(p_api_version NUMBER
538: , p_init_msg_list VARCHAR2
539: , x_return_status out nocopy VARCHAR2
574: , p_init_msg_list VARCHAR2
575: , x_return_status out nocopy VARCHAR2
576: , x_msg_count out nocopy NUMBER
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 JTF_NUMBER_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
575: , x_return_status out nocopy VARCHAR2
576: , x_msg_count out nocopy NUMBER
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 JTF_NUMBER_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
576: , x_msg_count out nocopy NUMBER
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 JTF_NUMBER_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 JTF_NUMBER_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
578: , p5_a0 JTF_NUMBER_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
579: , p5_a1 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
587: , p5_a9 JTF_NUMBER_TABLE
580: , p5_a2 JTF_NUMBER_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
587: , p5_a9 JTF_NUMBER_TABLE
588: , p5_a10 JTF_DATE_TABLE
581: , p5_a3 JTF_NUMBER_TABLE
582: , p5_a4 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
587: , p5_a9 JTF_NUMBER_TABLE
588: , p5_a10 JTF_DATE_TABLE
589: , p5_a11 JTF_NUMBER_TABLE
583: , p5_a5 JTF_NUMBER_TABLE
584: , p5_a6 JTF_NUMBER_TABLE
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
587: , p5_a9 JTF_NUMBER_TABLE
588: , p5_a10 JTF_DATE_TABLE
589: , p5_a11 JTF_NUMBER_TABLE
590: , p5_a12 JTF_VARCHAR2_TABLE_100
591: , p5_a13 JTF_VARCHAR2_TABLE_500
585: , p5_a7 JTF_NUMBER_TABLE
586: , p5_a8 JTF_DATE_TABLE
587: , p5_a9 JTF_NUMBER_TABLE
588: , p5_a10 JTF_DATE_TABLE
589: , p5_a11 JTF_NUMBER_TABLE
590: , p5_a12 JTF_VARCHAR2_TABLE_100
591: , p5_a13 JTF_VARCHAR2_TABLE_500
592: , p5_a14 JTF_VARCHAR2_TABLE_500
593: , p5_a15 JTF_VARCHAR2_TABLE_500
603: , p5_a25 JTF_VARCHAR2_TABLE_500
604: , p5_a26 JTF_VARCHAR2_TABLE_500
605: , p5_a27 JTF_VARCHAR2_TABLE_500
606: , p5_a28 JTF_VARCHAR2_TABLE_100
607: , p5_a29 JTF_NUMBER_TABLE
608: );
609: end okl_lrf_pvt_w;