1: package okl_dra_pvt_w as
2: /* $Header: OKLIDRAS.pls 120.0 2007/04/27 09:20:33 gkhuntet noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dra_pvt.drav_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
1: package okl_dra_pvt_w as
2: /* $Header: OKLIDRAS.pls 120.0 2007/04/27 09:20:33 gkhuntet noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dra_pvt.drav_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dra_pvt.drav_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_200
46: , a4 out nocopy JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_200
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
42: procedure rosetta_table_copy_out_p2(t okl_dra_pvt.drav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_200
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_VARCHAR2_TABLE_100
55: , a13 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_VARCHAR2_TABLE_100
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_VARCHAR2_TABLE_100
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_500
72: , a30 out nocopy JTF_VARCHAR2_TABLE_500
73: , a31 out nocopy JTF_VARCHAR2_TABLE_500
74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
73: , a31 out nocopy JTF_VARCHAR2_TABLE_500
74: , a32 out nocopy JTF_VARCHAR2_TABLE_500
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
75: , a33 out nocopy JTF_NUMBER_TABLE
76: , a34 out nocopy JTF_DATE_TABLE
77: , a35 out nocopy JTF_NUMBER_TABLE
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_DATE_TABLE
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_100
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_2000
83: , a1 JTF_VARCHAR2_TABLE_100
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_2000
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_DATE_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_DATE_TABLE
91: , a9 JTF_NUMBER_TABLE
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_2000
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_DATE_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_DATE_TABLE
91: , a9 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_DATE_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_DATE_TABLE
91: , a9 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_DATE_TABLE
91: , a9 JTF_NUMBER_TABLE
92: );
93: procedure rosetta_table_copy_out_p5(t okl_dra_pvt.okl_disb_rules_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_DATE_TABLE
100: , a7 out nocopy JTF_NUMBER_TABLE
101: , a8 out nocopy JTF_DATE_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_DATE_TABLE
100: , a7 out nocopy JTF_NUMBER_TABLE
101: , a8 out nocopy JTF_DATE_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: );
104:
98: , a5 out nocopy JTF_NUMBER_TABLE
99: , a6 out nocopy JTF_DATE_TABLE
100: , a7 out nocopy JTF_NUMBER_TABLE
101: , a8 out nocopy JTF_DATE_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
101: , a8 out nocopy JTF_DATE_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_200
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_DATE_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: );
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_200
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_DATE_TABLE
110: , a5 JTF_DATE_TABLE
104:
105: procedure rosetta_table_copy_in_p8(t out nocopy okl_dra_pvt.dra_tbl_type, a0 JTF_NUMBER_TABLE
106: , a1 JTF_NUMBER_TABLE
107: , a2 JTF_VARCHAR2_TABLE_200
108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_DATE_TABLE
110: , a5 JTF_DATE_TABLE
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_100
109: , a4 JTF_DATE_TABLE
110: , a5 JTF_DATE_TABLE
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_100
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_NUMBER_TABLE
115: , a10 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_VARCHAR2_TABLE_100
117: , a12 JTF_NUMBER_TABLE
110: , a5 JTF_DATE_TABLE
111: , a6 JTF_VARCHAR2_TABLE_100
112: , a7 JTF_VARCHAR2_TABLE_100
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_NUMBER_TABLE
115: , a10 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_VARCHAR2_TABLE_100
117: , a12 JTF_NUMBER_TABLE
118: , a13 JTF_VARCHAR2_TABLE_100
113: , a8 JTF_NUMBER_TABLE
114: , a9 JTF_NUMBER_TABLE
115: , a10 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_VARCHAR2_TABLE_100
117: , a12 JTF_NUMBER_TABLE
118: , a13 JTF_VARCHAR2_TABLE_100
119: , a14 JTF_VARCHAR2_TABLE_100
120: , a15 JTF_VARCHAR2_TABLE_100
121: , a16 JTF_VARCHAR2_TABLE_500
132: , a27 JTF_VARCHAR2_TABLE_500
133: , a28 JTF_VARCHAR2_TABLE_500
134: , a29 JTF_VARCHAR2_TABLE_500
135: , a30 JTF_VARCHAR2_TABLE_500
136: , a31 JTF_NUMBER_TABLE
137: , a32 JTF_DATE_TABLE
138: , a33 JTF_NUMBER_TABLE
139: , a34 JTF_DATE_TABLE
140: , a35 JTF_NUMBER_TABLE
134: , a29 JTF_VARCHAR2_TABLE_500
135: , a30 JTF_VARCHAR2_TABLE_500
136: , a31 JTF_NUMBER_TABLE
137: , a32 JTF_DATE_TABLE
138: , a33 JTF_NUMBER_TABLE
139: , a34 JTF_DATE_TABLE
140: , a35 JTF_NUMBER_TABLE
141: );
142: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
136: , a31 JTF_NUMBER_TABLE
137: , a32 JTF_DATE_TABLE
138: , a33 JTF_NUMBER_TABLE
139: , a34 JTF_DATE_TABLE
140: , a35 JTF_NUMBER_TABLE
141: );
142: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
143: , a1 out nocopy JTF_NUMBER_TABLE
144: , a2 out nocopy JTF_VARCHAR2_TABLE_200
138: , a33 JTF_NUMBER_TABLE
139: , a34 JTF_DATE_TABLE
140: , a35 JTF_NUMBER_TABLE
141: );
142: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
143: , a1 out nocopy JTF_NUMBER_TABLE
144: , a2 out nocopy JTF_VARCHAR2_TABLE_200
145: , a3 out nocopy JTF_NUMBER_TABLE
146: , a4 out nocopy JTF_DATE_TABLE
139: , a34 JTF_DATE_TABLE
140: , a35 JTF_NUMBER_TABLE
141: );
142: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
143: , a1 out nocopy JTF_NUMBER_TABLE
144: , a2 out nocopy JTF_VARCHAR2_TABLE_200
145: , a3 out nocopy JTF_NUMBER_TABLE
146: , a4 out nocopy JTF_DATE_TABLE
147: , a5 out nocopy JTF_DATE_TABLE
141: );
142: procedure rosetta_table_copy_out_p8(t okl_dra_pvt.dra_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
143: , a1 out nocopy JTF_NUMBER_TABLE
144: , a2 out nocopy JTF_VARCHAR2_TABLE_200
145: , a3 out nocopy JTF_NUMBER_TABLE
146: , a4 out nocopy JTF_DATE_TABLE
147: , a5 out nocopy JTF_DATE_TABLE
148: , a6 out nocopy JTF_VARCHAR2_TABLE_100
149: , a7 out nocopy JTF_VARCHAR2_TABLE_100
146: , a4 out nocopy JTF_DATE_TABLE
147: , a5 out nocopy JTF_DATE_TABLE
148: , a6 out nocopy JTF_VARCHAR2_TABLE_100
149: , a7 out nocopy JTF_VARCHAR2_TABLE_100
150: , a8 out nocopy JTF_NUMBER_TABLE
151: , a9 out nocopy JTF_NUMBER_TABLE
152: , a10 out nocopy JTF_VARCHAR2_TABLE_100
153: , a11 out nocopy JTF_VARCHAR2_TABLE_100
154: , a12 out nocopy JTF_NUMBER_TABLE
147: , a5 out nocopy JTF_DATE_TABLE
148: , a6 out nocopy JTF_VARCHAR2_TABLE_100
149: , a7 out nocopy JTF_VARCHAR2_TABLE_100
150: , a8 out nocopy JTF_NUMBER_TABLE
151: , a9 out nocopy JTF_NUMBER_TABLE
152: , a10 out nocopy JTF_VARCHAR2_TABLE_100
153: , a11 out nocopy JTF_VARCHAR2_TABLE_100
154: , a12 out nocopy JTF_NUMBER_TABLE
155: , a13 out nocopy JTF_VARCHAR2_TABLE_100
150: , a8 out nocopy JTF_NUMBER_TABLE
151: , a9 out nocopy JTF_NUMBER_TABLE
152: , a10 out nocopy JTF_VARCHAR2_TABLE_100
153: , a11 out nocopy JTF_VARCHAR2_TABLE_100
154: , a12 out nocopy JTF_NUMBER_TABLE
155: , a13 out nocopy JTF_VARCHAR2_TABLE_100
156: , a14 out nocopy JTF_VARCHAR2_TABLE_100
157: , a15 out nocopy JTF_VARCHAR2_TABLE_100
158: , a16 out nocopy JTF_VARCHAR2_TABLE_500
169: , a27 out nocopy JTF_VARCHAR2_TABLE_500
170: , a28 out nocopy JTF_VARCHAR2_TABLE_500
171: , a29 out nocopy JTF_VARCHAR2_TABLE_500
172: , a30 out nocopy JTF_VARCHAR2_TABLE_500
173: , a31 out nocopy JTF_NUMBER_TABLE
174: , a32 out nocopy JTF_DATE_TABLE
175: , a33 out nocopy JTF_NUMBER_TABLE
176: , a34 out nocopy JTF_DATE_TABLE
177: , a35 out nocopy JTF_NUMBER_TABLE
171: , a29 out nocopy JTF_VARCHAR2_TABLE_500
172: , a30 out nocopy JTF_VARCHAR2_TABLE_500
173: , a31 out nocopy JTF_NUMBER_TABLE
174: , a32 out nocopy JTF_DATE_TABLE
175: , a33 out nocopy JTF_NUMBER_TABLE
176: , a34 out nocopy JTF_DATE_TABLE
177: , a35 out nocopy JTF_NUMBER_TABLE
178: );
179:
173: , a31 out nocopy JTF_NUMBER_TABLE
174: , a32 out nocopy JTF_DATE_TABLE
175: , a33 out nocopy JTF_NUMBER_TABLE
176: , a34 out nocopy JTF_DATE_TABLE
177: , a35 out nocopy JTF_NUMBER_TABLE
178: );
179:
180: procedure insert_row(p_api_version NUMBER
181: , p_init_msg_list VARCHAR2
263: , p_init_msg_list VARCHAR2
264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_200
271: , p5_a4 JTF_NUMBER_TABLE
264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_200
271: , p5_a4 JTF_NUMBER_TABLE
272: , p5_a5 JTF_DATE_TABLE
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_200
271: , p5_a4 JTF_NUMBER_TABLE
272: , p5_a5 JTF_DATE_TABLE
273: , p5_a6 JTF_DATE_TABLE
274: , p5_a7 JTF_VARCHAR2_TABLE_100
275: , p5_a8 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_DATE_TABLE
273: , p5_a6 JTF_DATE_TABLE
274: , p5_a7 JTF_VARCHAR2_TABLE_100
275: , p5_a8 JTF_VARCHAR2_TABLE_100
276: , p5_a9 JTF_NUMBER_TABLE
277: , p5_a10 JTF_NUMBER_TABLE
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_VARCHAR2_TABLE_100
280: , p5_a13 JTF_NUMBER_TABLE
273: , p5_a6 JTF_DATE_TABLE
274: , p5_a7 JTF_VARCHAR2_TABLE_100
275: , p5_a8 JTF_VARCHAR2_TABLE_100
276: , p5_a9 JTF_NUMBER_TABLE
277: , p5_a10 JTF_NUMBER_TABLE
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_VARCHAR2_TABLE_100
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_VARCHAR2_TABLE_100
276: , p5_a9 JTF_NUMBER_TABLE
277: , p5_a10 JTF_NUMBER_TABLE
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_VARCHAR2_TABLE_100
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_VARCHAR2_TABLE_100
282: , p5_a15 JTF_VARCHAR2_TABLE_100
283: , p5_a16 JTF_VARCHAR2_TABLE_2000
284: , p5_a17 JTF_VARCHAR2_TABLE_100
296: , p5_a29 JTF_VARCHAR2_TABLE_500
297: , p5_a30 JTF_VARCHAR2_TABLE_500
298: , p5_a31 JTF_VARCHAR2_TABLE_500
299: , p5_a32 JTF_VARCHAR2_TABLE_500
300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a31 JTF_VARCHAR2_TABLE_500
299: , p5_a32 JTF_VARCHAR2_TABLE_500
300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p5_a33 JTF_NUMBER_TABLE
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
301: , p5_a34 JTF_DATE_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
309: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p5_a35 JTF_NUMBER_TABLE
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
309: , p6_a4 out nocopy JTF_NUMBER_TABLE
310: , p6_a5 out nocopy JTF_DATE_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
309: , p6_a4 out nocopy JTF_NUMBER_TABLE
310: , p6_a5 out nocopy JTF_DATE_TABLE
311: , p6_a6 out nocopy JTF_DATE_TABLE
312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_DATE_TABLE
311: , p6_a6 out nocopy JTF_DATE_TABLE
312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a9 out nocopy JTF_NUMBER_TABLE
315: , p6_a10 out nocopy JTF_NUMBER_TABLE
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
311: , p6_a6 out nocopy JTF_DATE_TABLE
312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a9 out nocopy JTF_NUMBER_TABLE
315: , p6_a10 out nocopy JTF_NUMBER_TABLE
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a9 out nocopy JTF_NUMBER_TABLE
315: , p6_a10 out nocopy JTF_NUMBER_TABLE
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
322: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
335: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
337: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE
336: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
337: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
338: , p6_a33 out nocopy JTF_NUMBER_TABLE
339: , p6_a34 out nocopy JTF_DATE_TABLE
340: , p6_a35 out nocopy JTF_NUMBER_TABLE
341: , p6_a36 out nocopy JTF_DATE_TABLE
342: , p6_a37 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2
389: , p_init_msg_list VARCHAR2
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_200
397: , p5_a4 JTF_NUMBER_TABLE
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_200
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_DATE_TABLE
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_200
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_DATE_TABLE
399: , p5_a6 JTF_DATE_TABLE
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_DATE_TABLE
399: , p5_a6 JTF_DATE_TABLE
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_NUMBER_TABLE
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_VARCHAR2_TABLE_100
406: , p5_a13 JTF_NUMBER_TABLE
399: , p5_a6 JTF_DATE_TABLE
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_NUMBER_TABLE
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_VARCHAR2_TABLE_100
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_NUMBER_TABLE
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_VARCHAR2_TABLE_100
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_VARCHAR2_TABLE_100
408: , p5_a15 JTF_VARCHAR2_TABLE_100
409: , p5_a16 JTF_VARCHAR2_TABLE_2000
410: , p5_a17 JTF_VARCHAR2_TABLE_100
422: , p5_a29 JTF_VARCHAR2_TABLE_500
423: , p5_a30 JTF_VARCHAR2_TABLE_500
424: , p5_a31 JTF_VARCHAR2_TABLE_500
425: , p5_a32 JTF_VARCHAR2_TABLE_500
426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE
424: , p5_a31 JTF_VARCHAR2_TABLE_500
425: , p5_a32 JTF_VARCHAR2_TABLE_500
426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE
431: );
432: procedure update_row(p_api_version NUMBER
426: , p5_a33 JTF_NUMBER_TABLE
427: , p5_a34 JTF_DATE_TABLE
428: , p5_a35 JTF_NUMBER_TABLE
429: , p5_a36 JTF_DATE_TABLE
430: , p5_a37 JTF_NUMBER_TABLE
431: );
432: procedure update_row(p_api_version NUMBER
433: , p_init_msg_list VARCHAR2
434: , x_return_status out nocopy VARCHAR2
515: , p_init_msg_list VARCHAR2
516: , x_return_status out nocopy VARCHAR2
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_200
523: , p5_a4 JTF_NUMBER_TABLE
516: , x_return_status out nocopy VARCHAR2
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_200
523: , p5_a4 JTF_NUMBER_TABLE
524: , p5_a5 JTF_DATE_TABLE
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_200
523: , p5_a4 JTF_NUMBER_TABLE
524: , p5_a5 JTF_DATE_TABLE
525: , p5_a6 JTF_DATE_TABLE
526: , p5_a7 JTF_VARCHAR2_TABLE_100
527: , p5_a8 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_DATE_TABLE
525: , p5_a6 JTF_DATE_TABLE
526: , p5_a7 JTF_VARCHAR2_TABLE_100
527: , p5_a8 JTF_VARCHAR2_TABLE_100
528: , p5_a9 JTF_NUMBER_TABLE
529: , p5_a10 JTF_NUMBER_TABLE
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_VARCHAR2_TABLE_100
532: , p5_a13 JTF_NUMBER_TABLE
525: , p5_a6 JTF_DATE_TABLE
526: , p5_a7 JTF_VARCHAR2_TABLE_100
527: , p5_a8 JTF_VARCHAR2_TABLE_100
528: , p5_a9 JTF_NUMBER_TABLE
529: , p5_a10 JTF_NUMBER_TABLE
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_VARCHAR2_TABLE_100
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_VARCHAR2_TABLE_100
528: , p5_a9 JTF_NUMBER_TABLE
529: , p5_a10 JTF_NUMBER_TABLE
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_VARCHAR2_TABLE_100
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_VARCHAR2_TABLE_100
534: , p5_a15 JTF_VARCHAR2_TABLE_100
535: , p5_a16 JTF_VARCHAR2_TABLE_2000
536: , p5_a17 JTF_VARCHAR2_TABLE_100
548: , p5_a29 JTF_VARCHAR2_TABLE_500
549: , p5_a30 JTF_VARCHAR2_TABLE_500
550: , p5_a31 JTF_VARCHAR2_TABLE_500
551: , p5_a32 JTF_VARCHAR2_TABLE_500
552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
550: , p5_a31 JTF_VARCHAR2_TABLE_500
551: , p5_a32 JTF_VARCHAR2_TABLE_500
552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
552: , p5_a33 JTF_NUMBER_TABLE
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
553: , p5_a34 JTF_DATE_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
561: , p6_a4 out nocopy JTF_NUMBER_TABLE
554: , p5_a35 JTF_NUMBER_TABLE
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
561: , p6_a4 out nocopy JTF_NUMBER_TABLE
562: , p6_a5 out nocopy JTF_DATE_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
561: , p6_a4 out nocopy JTF_NUMBER_TABLE
562: , p6_a5 out nocopy JTF_DATE_TABLE
563: , p6_a6 out nocopy JTF_DATE_TABLE
564: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_DATE_TABLE
563: , p6_a6 out nocopy JTF_DATE_TABLE
564: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a9 out nocopy JTF_NUMBER_TABLE
567: , p6_a10 out nocopy JTF_NUMBER_TABLE
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
563: , p6_a6 out nocopy JTF_DATE_TABLE
564: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a9 out nocopy JTF_NUMBER_TABLE
567: , p6_a10 out nocopy JTF_NUMBER_TABLE
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a9 out nocopy JTF_NUMBER_TABLE
567: , p6_a10 out nocopy JTF_NUMBER_TABLE
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
572: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
573: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
574: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE
588: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE
595: );
596: procedure delete_row(p_api_version NUMBER
590: , p6_a33 out nocopy JTF_NUMBER_TABLE
591: , p6_a34 out nocopy JTF_DATE_TABLE
592: , p6_a35 out nocopy JTF_NUMBER_TABLE
593: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a37 out nocopy JTF_NUMBER_TABLE
595: );
596: procedure delete_row(p_api_version NUMBER
597: , p_init_msg_list VARCHAR2
598: , x_return_status out nocopy VARCHAR2
641: , p_init_msg_list VARCHAR2
642: , x_return_status out nocopy VARCHAR2
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_200
649: , p5_a4 JTF_NUMBER_TABLE
642: , x_return_status out nocopy VARCHAR2
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_200
649: , p5_a4 JTF_NUMBER_TABLE
650: , p5_a5 JTF_DATE_TABLE
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_200
649: , p5_a4 JTF_NUMBER_TABLE
650: , p5_a5 JTF_DATE_TABLE
651: , p5_a6 JTF_DATE_TABLE
652: , p5_a7 JTF_VARCHAR2_TABLE_100
653: , p5_a8 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_DATE_TABLE
651: , p5_a6 JTF_DATE_TABLE
652: , p5_a7 JTF_VARCHAR2_TABLE_100
653: , p5_a8 JTF_VARCHAR2_TABLE_100
654: , p5_a9 JTF_NUMBER_TABLE
655: , p5_a10 JTF_NUMBER_TABLE
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_VARCHAR2_TABLE_100
658: , p5_a13 JTF_NUMBER_TABLE
651: , p5_a6 JTF_DATE_TABLE
652: , p5_a7 JTF_VARCHAR2_TABLE_100
653: , p5_a8 JTF_VARCHAR2_TABLE_100
654: , p5_a9 JTF_NUMBER_TABLE
655: , p5_a10 JTF_NUMBER_TABLE
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_VARCHAR2_TABLE_100
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_VARCHAR2_TABLE_100
654: , p5_a9 JTF_NUMBER_TABLE
655: , p5_a10 JTF_NUMBER_TABLE
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_VARCHAR2_TABLE_100
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_VARCHAR2_TABLE_100
660: , p5_a15 JTF_VARCHAR2_TABLE_100
661: , p5_a16 JTF_VARCHAR2_TABLE_2000
662: , p5_a17 JTF_VARCHAR2_TABLE_100
674: , p5_a29 JTF_VARCHAR2_TABLE_500
675: , p5_a30 JTF_VARCHAR2_TABLE_500
676: , p5_a31 JTF_VARCHAR2_TABLE_500
677: , p5_a32 JTF_VARCHAR2_TABLE_500
678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE
676: , p5_a31 JTF_VARCHAR2_TABLE_500
677: , p5_a32 JTF_VARCHAR2_TABLE_500
678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE
683: );
684: procedure validate_row(p_api_version NUMBER
678: , p5_a33 JTF_NUMBER_TABLE
679: , p5_a34 JTF_DATE_TABLE
680: , p5_a35 JTF_NUMBER_TABLE
681: , p5_a36 JTF_DATE_TABLE
682: , p5_a37 JTF_NUMBER_TABLE
683: );
684: procedure validate_row(p_api_version NUMBER
685: , p_init_msg_list VARCHAR2
686: , x_return_status out nocopy VARCHAR2
729: , p_init_msg_list VARCHAR2
730: , x_return_status out nocopy VARCHAR2
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_200
737: , p5_a4 JTF_NUMBER_TABLE
730: , x_return_status out nocopy VARCHAR2
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_200
737: , p5_a4 JTF_NUMBER_TABLE
738: , p5_a5 JTF_DATE_TABLE
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_200
737: , p5_a4 JTF_NUMBER_TABLE
738: , p5_a5 JTF_DATE_TABLE
739: , p5_a6 JTF_DATE_TABLE
740: , p5_a7 JTF_VARCHAR2_TABLE_100
741: , p5_a8 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_DATE_TABLE
739: , p5_a6 JTF_DATE_TABLE
740: , p5_a7 JTF_VARCHAR2_TABLE_100
741: , p5_a8 JTF_VARCHAR2_TABLE_100
742: , p5_a9 JTF_NUMBER_TABLE
743: , p5_a10 JTF_NUMBER_TABLE
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_VARCHAR2_TABLE_100
746: , p5_a13 JTF_NUMBER_TABLE
739: , p5_a6 JTF_DATE_TABLE
740: , p5_a7 JTF_VARCHAR2_TABLE_100
741: , p5_a8 JTF_VARCHAR2_TABLE_100
742: , p5_a9 JTF_NUMBER_TABLE
743: , p5_a10 JTF_NUMBER_TABLE
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_VARCHAR2_TABLE_100
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_VARCHAR2_TABLE_100
742: , p5_a9 JTF_NUMBER_TABLE
743: , p5_a10 JTF_NUMBER_TABLE
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_VARCHAR2_TABLE_100
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_VARCHAR2_TABLE_100
748: , p5_a15 JTF_VARCHAR2_TABLE_100
749: , p5_a16 JTF_VARCHAR2_TABLE_2000
750: , p5_a17 JTF_VARCHAR2_TABLE_100
762: , p5_a29 JTF_VARCHAR2_TABLE_500
763: , p5_a30 JTF_VARCHAR2_TABLE_500
764: , p5_a31 JTF_VARCHAR2_TABLE_500
765: , p5_a32 JTF_VARCHAR2_TABLE_500
766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE
764: , p5_a31 JTF_VARCHAR2_TABLE_500
765: , p5_a32 JTF_VARCHAR2_TABLE_500
766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE
771: );
772: end okl_dra_pvt_w;
766: , p5_a33 JTF_NUMBER_TABLE
767: , p5_a34 JTF_DATE_TABLE
768: , p5_a35 JTF_NUMBER_TABLE
769: , p5_a36 JTF_DATE_TABLE
770: , p5_a37 JTF_NUMBER_TABLE
771: );
772: end okl_dra_pvt_w;