1: package okl_tas_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLITASS.pls 120.2 2007/11/06 07:36:24 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_tas_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLITASS.pls 120.2 2007/11/06 07:36:24 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
2: /* $Header: OKLITASS.pls 120.2 2007/11/06 07:36:24 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: );
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_VARCHAR2_TABLE_500
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_VARCHAR2_TABLE_500
45: , a6 out nocopy JTF_VARCHAR2_TABLE_500
46: , a7 out nocopy JTF_VARCHAR2_TABLE_500
55: , a16 out nocopy JTF_VARCHAR2_TABLE_500
56: , a17 out nocopy JTF_VARCHAR2_TABLE_500
57: , a18 out nocopy JTF_VARCHAR2_TABLE_500
58: , a19 out nocopy JTF_VARCHAR2_TABLE_500
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_DATE_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_DATE_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
57: , a18 out nocopy JTF_VARCHAR2_TABLE_500
58: , a19 out nocopy JTF_VARCHAR2_TABLE_500
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_DATE_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_DATE_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
64: , a25 out nocopy JTF_VARCHAR2_TABLE_100
65: , a26 out nocopy JTF_NUMBER_TABLE
59: , a20 out nocopy JTF_NUMBER_TABLE
60: , a21 out nocopy JTF_DATE_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_DATE_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
64: , a25 out nocopy JTF_VARCHAR2_TABLE_100
65: , a26 out nocopy JTF_NUMBER_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_DATE_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
64: , a25 out nocopy JTF_VARCHAR2_TABLE_100
65: , a26 out nocopy JTF_NUMBER_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
64: , a25 out nocopy JTF_VARCHAR2_TABLE_100
65: , a26 out nocopy JTF_NUMBER_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
65: , a26 out nocopy JTF_NUMBER_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_DATE_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_DATE_TABLE
74: );
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_DATE_TABLE
74: );
75:
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_NUMBER_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_DATE_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_DATE_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_NUMBER_TABLE
79: , a3 JTF_VARCHAR2_TABLE_100
80: , a4 JTF_VARCHAR2_TABLE_500
73: , a34 out nocopy JTF_DATE_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_NUMBER_TABLE
79: , a3 JTF_VARCHAR2_TABLE_100
80: , a4 JTF_VARCHAR2_TABLE_500
81: , a5 JTF_VARCHAR2_TABLE_500
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_NUMBER_TABLE
79: , a3 JTF_VARCHAR2_TABLE_100
80: , a4 JTF_VARCHAR2_TABLE_500
81: , a5 JTF_VARCHAR2_TABLE_500
82: , a6 JTF_VARCHAR2_TABLE_500
92: , a16 JTF_VARCHAR2_TABLE_500
93: , a17 JTF_VARCHAR2_TABLE_500
94: , a18 JTF_VARCHAR2_TABLE_500
95: , a19 JTF_VARCHAR2_TABLE_100
96: , a20 JTF_NUMBER_TABLE
97: , a21 JTF_DATE_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE
100: , a24 JTF_NUMBER_TABLE
94: , a18 JTF_VARCHAR2_TABLE_500
95: , a19 JTF_VARCHAR2_TABLE_100
96: , a20 JTF_NUMBER_TABLE
97: , a21 JTF_DATE_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE
100: , a24 JTF_NUMBER_TABLE
101: , a25 JTF_VARCHAR2_TABLE_100
102: , a26 JTF_NUMBER_TABLE
96: , a20 JTF_NUMBER_TABLE
97: , a21 JTF_DATE_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE
100: , a24 JTF_NUMBER_TABLE
101: , a25 JTF_VARCHAR2_TABLE_100
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE
100: , a24 JTF_NUMBER_TABLE
101: , a25 JTF_VARCHAR2_TABLE_100
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
100: , a24 JTF_NUMBER_TABLE
101: , a25 JTF_VARCHAR2_TABLE_100
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
111: );
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_VARCHAR2_TABLE_500
109: , a33 JTF_NUMBER_TABLE
110: , a34 JTF_DATE_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_VARCHAR2_TABLE_500
117: , a5 out nocopy JTF_VARCHAR2_TABLE_500
110: , a34 JTF_DATE_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_VARCHAR2_TABLE_500
117: , a5 out nocopy JTF_VARCHAR2_TABLE_500
118: , a6 out nocopy JTF_VARCHAR2_TABLE_500
128: , a16 out nocopy JTF_VARCHAR2_TABLE_500
129: , a17 out nocopy JTF_VARCHAR2_TABLE_500
130: , a18 out nocopy JTF_VARCHAR2_TABLE_500
131: , a19 out nocopy JTF_VARCHAR2_TABLE_100
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
130: , a18 out nocopy JTF_VARCHAR2_TABLE_500
131: , a19 out nocopy JTF_VARCHAR2_TABLE_100
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: );
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: );
148:
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: );
148:
149: procedure insert_row(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_NUMBER_TABLE
233: , p5_a3 JTF_VARCHAR2_TABLE_100
234: , p5_a4 JTF_VARCHAR2_TABLE_500
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_NUMBER_TABLE
233: , p5_a3 JTF_VARCHAR2_TABLE_100
234: , p5_a4 JTF_VARCHAR2_TABLE_500
235: , p5_a5 JTF_VARCHAR2_TABLE_500
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_NUMBER_TABLE
233: , p5_a3 JTF_VARCHAR2_TABLE_100
234: , p5_a4 JTF_VARCHAR2_TABLE_500
235: , p5_a5 JTF_VARCHAR2_TABLE_500
236: , p5_a6 JTF_VARCHAR2_TABLE_500
246: , p5_a16 JTF_VARCHAR2_TABLE_500
247: , p5_a17 JTF_VARCHAR2_TABLE_500
248: , p5_a18 JTF_VARCHAR2_TABLE_500
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_NUMBER_TABLE
251: , p5_a21 JTF_DATE_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
248: , p5_a18 JTF_VARCHAR2_TABLE_500
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_NUMBER_TABLE
251: , p5_a21 JTF_DATE_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_NUMBER_TABLE
250: , p5_a20 JTF_NUMBER_TABLE
251: , p5_a21 JTF_DATE_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
261: , p5_a31 JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
263: , p5_a33 JTF_NUMBER_TABLE
264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a20 out nocopy JTF_NUMBER_TABLE
286: , p6_a21 out nocopy JTF_DATE_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
283: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a20 out nocopy JTF_NUMBER_TABLE
286: , p6_a21 out nocopy JTF_DATE_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
285: , p6_a20 out nocopy JTF_NUMBER_TABLE
286: , p6_a21 out nocopy JTF_DATE_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_NUMBER_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_NUMBER_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_NUMBER_TABLE
299: , p6_a34 out nocopy JTF_DATE_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_NUMBER_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_NUMBER_TABLE
299: , p6_a34 out nocopy JTF_DATE_TABLE
300: );
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_NUMBER_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_NUMBER_TABLE
299: , p6_a34 out nocopy JTF_DATE_TABLE
300: );
301: procedure lock_row(p_api_version NUMBER
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_NUMBER_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_NUMBER_TABLE
299: , p6_a34 out nocopy JTF_DATE_TABLE
300: );
301: procedure lock_row(p_api_version NUMBER
302: , p_init_msg_list VARCHAR2
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_NUMBER_TABLE
350: , p5_a3 JTF_VARCHAR2_TABLE_100
351: , p5_a4 JTF_VARCHAR2_TABLE_500
344: , x_return_status out nocopy VARCHAR2
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_NUMBER_TABLE
350: , p5_a3 JTF_VARCHAR2_TABLE_100
351: , p5_a4 JTF_VARCHAR2_TABLE_500
352: , p5_a5 JTF_VARCHAR2_TABLE_500
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_NUMBER_TABLE
350: , p5_a3 JTF_VARCHAR2_TABLE_100
351: , p5_a4 JTF_VARCHAR2_TABLE_500
352: , p5_a5 JTF_VARCHAR2_TABLE_500
353: , p5_a6 JTF_VARCHAR2_TABLE_500
363: , p5_a16 JTF_VARCHAR2_TABLE_500
364: , p5_a17 JTF_VARCHAR2_TABLE_500
365: , p5_a18 JTF_VARCHAR2_TABLE_500
366: , p5_a19 JTF_VARCHAR2_TABLE_100
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_DATE_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
365: , p5_a18 JTF_VARCHAR2_TABLE_500
366: , p5_a19 JTF_VARCHAR2_TABLE_100
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_DATE_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_DATE_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_NUMBER_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_NUMBER_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_DATE_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_NUMBER_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_DATE_TABLE
382: );
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_NUMBER_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_DATE_TABLE
382: );
383: procedure update_row(p_api_version NUMBER
376: , p5_a29 JTF_VARCHAR2_TABLE_4000
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_NUMBER_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_NUMBER_TABLE
381: , p5_a34 JTF_DATE_TABLE
382: );
383: procedure update_row(p_api_version NUMBER
384: , p_init_msg_list VARCHAR2
460: , p_init_msg_list VARCHAR2
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_NUMBER_TABLE
467: , p5_a3 JTF_VARCHAR2_TABLE_100
468: , p5_a4 JTF_VARCHAR2_TABLE_500
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_NUMBER_TABLE
467: , p5_a3 JTF_VARCHAR2_TABLE_100
468: , p5_a4 JTF_VARCHAR2_TABLE_500
469: , p5_a5 JTF_VARCHAR2_TABLE_500
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_NUMBER_TABLE
467: , p5_a3 JTF_VARCHAR2_TABLE_100
468: , p5_a4 JTF_VARCHAR2_TABLE_500
469: , p5_a5 JTF_VARCHAR2_TABLE_500
470: , p5_a6 JTF_VARCHAR2_TABLE_500
480: , p5_a16 JTF_VARCHAR2_TABLE_500
481: , p5_a17 JTF_VARCHAR2_TABLE_500
482: , p5_a18 JTF_VARCHAR2_TABLE_500
483: , p5_a19 JTF_VARCHAR2_TABLE_100
484: , p5_a20 JTF_NUMBER_TABLE
485: , p5_a21 JTF_DATE_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
482: , p5_a18 JTF_VARCHAR2_TABLE_500
483: , p5_a19 JTF_VARCHAR2_TABLE_100
484: , p5_a20 JTF_NUMBER_TABLE
485: , p5_a21 JTF_DATE_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_VARCHAR2_TABLE_100
490: , p5_a26 JTF_NUMBER_TABLE
484: , p5_a20 JTF_NUMBER_TABLE
485: , p5_a21 JTF_DATE_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_VARCHAR2_TABLE_100
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_VARCHAR2_TABLE_100
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_VARCHAR2_TABLE_100
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
495: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
503: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
503: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
497: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
503: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
517: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
518: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a20 out nocopy JTF_NUMBER_TABLE
520: , p6_a21 out nocopy JTF_DATE_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
517: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
518: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a20 out nocopy JTF_NUMBER_TABLE
520: , p6_a21 out nocopy JTF_DATE_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
519: , p6_a20 out nocopy JTF_NUMBER_TABLE
520: , p6_a21 out nocopy JTF_DATE_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_NUMBER_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_NUMBER_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_NUMBER_TABLE
533: , p6_a34 out nocopy JTF_DATE_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_NUMBER_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_NUMBER_TABLE
533: , p6_a34 out nocopy JTF_DATE_TABLE
534: );
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_NUMBER_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_NUMBER_TABLE
533: , p6_a34 out nocopy JTF_DATE_TABLE
534: );
535: procedure delete_row(p_api_version NUMBER
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_NUMBER_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_NUMBER_TABLE
533: , p6_a34 out nocopy JTF_DATE_TABLE
534: );
535: procedure delete_row(p_api_version NUMBER
536: , p_init_msg_list VARCHAR2
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_NUMBER_TABLE
584: , p5_a3 JTF_VARCHAR2_TABLE_100
585: , p5_a4 JTF_VARCHAR2_TABLE_500
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_NUMBER_TABLE
584: , p5_a3 JTF_VARCHAR2_TABLE_100
585: , p5_a4 JTF_VARCHAR2_TABLE_500
586: , p5_a5 JTF_VARCHAR2_TABLE_500
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_NUMBER_TABLE
584: , p5_a3 JTF_VARCHAR2_TABLE_100
585: , p5_a4 JTF_VARCHAR2_TABLE_500
586: , p5_a5 JTF_VARCHAR2_TABLE_500
587: , p5_a6 JTF_VARCHAR2_TABLE_500
597: , p5_a16 JTF_VARCHAR2_TABLE_500
598: , p5_a17 JTF_VARCHAR2_TABLE_500
599: , p5_a18 JTF_VARCHAR2_TABLE_500
600: , p5_a19 JTF_VARCHAR2_TABLE_100
601: , p5_a20 JTF_NUMBER_TABLE
602: , p5_a21 JTF_DATE_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
599: , p5_a18 JTF_VARCHAR2_TABLE_500
600: , p5_a19 JTF_VARCHAR2_TABLE_100
601: , p5_a20 JTF_NUMBER_TABLE
602: , p5_a21 JTF_DATE_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
606: , p5_a25 JTF_VARCHAR2_TABLE_100
607: , p5_a26 JTF_NUMBER_TABLE
601: , p5_a20 JTF_NUMBER_TABLE
602: , p5_a21 JTF_DATE_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
606: , p5_a25 JTF_VARCHAR2_TABLE_100
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
606: , p5_a25 JTF_VARCHAR2_TABLE_100
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
606: , p5_a25 JTF_VARCHAR2_TABLE_100
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_NUMBER_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_NUMBER_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_NUMBER_TABLE
615: , p5_a34 JTF_DATE_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_NUMBER_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_NUMBER_TABLE
615: , p5_a34 JTF_DATE_TABLE
616: );
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_NUMBER_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_NUMBER_TABLE
615: , p5_a34 JTF_DATE_TABLE
616: );
617: procedure validate_row(p_api_version NUMBER
610: , p5_a29 JTF_VARCHAR2_TABLE_4000
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_NUMBER_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_NUMBER_TABLE
615: , p5_a34 JTF_DATE_TABLE
616: );
617: procedure validate_row(p_api_version NUMBER
618: , p_init_msg_list VARCHAR2
659: , p_init_msg_list VARCHAR2
660: , x_return_status out nocopy VARCHAR2
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_NUMBER_TABLE
666: , p5_a3 JTF_VARCHAR2_TABLE_100
667: , p5_a4 JTF_VARCHAR2_TABLE_500
660: , x_return_status out nocopy VARCHAR2
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_NUMBER_TABLE
666: , p5_a3 JTF_VARCHAR2_TABLE_100
667: , p5_a4 JTF_VARCHAR2_TABLE_500
668: , p5_a5 JTF_VARCHAR2_TABLE_500
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_NUMBER_TABLE
666: , p5_a3 JTF_VARCHAR2_TABLE_100
667: , p5_a4 JTF_VARCHAR2_TABLE_500
668: , p5_a5 JTF_VARCHAR2_TABLE_500
669: , p5_a6 JTF_VARCHAR2_TABLE_500
679: , p5_a16 JTF_VARCHAR2_TABLE_500
680: , p5_a17 JTF_VARCHAR2_TABLE_500
681: , p5_a18 JTF_VARCHAR2_TABLE_500
682: , p5_a19 JTF_VARCHAR2_TABLE_100
683: , p5_a20 JTF_NUMBER_TABLE
684: , p5_a21 JTF_DATE_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
681: , p5_a18 JTF_VARCHAR2_TABLE_500
682: , p5_a19 JTF_VARCHAR2_TABLE_100
683: , p5_a20 JTF_NUMBER_TABLE
684: , p5_a21 JTF_DATE_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
688: , p5_a25 JTF_VARCHAR2_TABLE_100
689: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a20 JTF_NUMBER_TABLE
684: , p5_a21 JTF_DATE_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
688: , p5_a25 JTF_VARCHAR2_TABLE_100
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
688: , p5_a25 JTF_VARCHAR2_TABLE_100
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
688: , p5_a25 JTF_VARCHAR2_TABLE_100
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_NUMBER_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_NUMBER_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_NUMBER_TABLE
697: , p5_a34 JTF_DATE_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_NUMBER_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_NUMBER_TABLE
697: , p5_a34 JTF_DATE_TABLE
698: );
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_NUMBER_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_NUMBER_TABLE
697: , p5_a34 JTF_DATE_TABLE
698: );
699: end okl_tas_pvt_w;
692: , p5_a29 JTF_VARCHAR2_TABLE_4000
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_NUMBER_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_NUMBER_TABLE
697: , p5_a34 JTF_DATE_TABLE
698: );
699: end okl_tas_pvt_w;