1: package okl_vcr_pvt_w as
2: /* $Header: OKLIVCRS.pls 120.0 2005/08/03 07:55:44 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_vcr_pvt_w as
2: /* $Header: OKLIVCRS.pls 120.0 2005/08/03 07:55:44 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_vcr_pvt_w as
2: /* $Header: OKLIVCRS.pls 120.0 2005/08/03 07:55:44 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
2: /* $Header: OKLIVCRS.pls 120.0 2005/08/03 07:55:44 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
27: , a24 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_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
38: , a35 JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_DATE_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_NUMBER_TABLE
45: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a5 out nocopy JTF_VARCHAR2_TABLE_100
47: , a6 out nocopy JTF_DATE_TABLE
48: , a7 out nocopy JTF_DATE_TABLE
65: , a24 out nocopy JTF_VARCHAR2_TABLE_500
66: , a25 out nocopy JTF_VARCHAR2_TABLE_500
67: , a26 out nocopy JTF_VARCHAR2_TABLE_500
68: , a27 out nocopy JTF_VARCHAR2_TABLE_500
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_NUMBER_TABLE
72: , a31 out nocopy JTF_DATE_TABLE
73: , a32 out nocopy JTF_NUMBER_TABLE
66: , a25 out nocopy JTF_VARCHAR2_TABLE_500
67: , a26 out nocopy JTF_VARCHAR2_TABLE_500
68: , a27 out nocopy JTF_VARCHAR2_TABLE_500
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_NUMBER_TABLE
72: , a31 out nocopy JTF_DATE_TABLE
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
67: , a26 out nocopy JTF_VARCHAR2_TABLE_500
68: , a27 out nocopy JTF_VARCHAR2_TABLE_500
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_NUMBER_TABLE
72: , a31 out nocopy JTF_DATE_TABLE
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
69: , a28 out nocopy JTF_NUMBER_TABLE
70: , a29 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_NUMBER_TABLE
72: , a31 out nocopy JTF_DATE_TABLE
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
71: , a30 out nocopy JTF_NUMBER_TABLE
72: , a31 out nocopy JTF_DATE_TABLE
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
73: , a32 out nocopy JTF_NUMBER_TABLE
74: , a33 out nocopy JTF_DATE_TABLE
75: , a34 out nocopy JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_100
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_DATE_TABLE
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_NUMBER_TABLE
83: , a3 JTF_NUMBER_TABLE
84: , a4 JTF_VARCHAR2_TABLE_100
85: , a5 JTF_VARCHAR2_TABLE_100
86: , a6 JTF_DATE_TABLE
87: , a7 JTF_DATE_TABLE
104: , a24 JTF_VARCHAR2_TABLE_500
105: , a25 JTF_VARCHAR2_TABLE_500
106: , a26 JTF_VARCHAR2_TABLE_500
107: , a27 JTF_VARCHAR2_TABLE_500
108: , a28 JTF_NUMBER_TABLE
109: , a29 JTF_NUMBER_TABLE
110: , a30 JTF_NUMBER_TABLE
111: , a31 JTF_DATE_TABLE
112: , a32 JTF_NUMBER_TABLE
105: , a25 JTF_VARCHAR2_TABLE_500
106: , a26 JTF_VARCHAR2_TABLE_500
107: , a27 JTF_VARCHAR2_TABLE_500
108: , a28 JTF_NUMBER_TABLE
109: , a29 JTF_NUMBER_TABLE
110: , a30 JTF_NUMBER_TABLE
111: , a31 JTF_DATE_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
106: , a26 JTF_VARCHAR2_TABLE_500
107: , a27 JTF_VARCHAR2_TABLE_500
108: , a28 JTF_NUMBER_TABLE
109: , a29 JTF_NUMBER_TABLE
110: , a30 JTF_NUMBER_TABLE
111: , a31 JTF_DATE_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
114: , a34 JTF_NUMBER_TABLE
108: , a28 JTF_NUMBER_TABLE
109: , a29 JTF_NUMBER_TABLE
110: , a30 JTF_NUMBER_TABLE
111: , a31 JTF_DATE_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_DATE_TABLE
116: , a36 JTF_NUMBER_TABLE
110: , a30 JTF_NUMBER_TABLE
111: , a31 JTF_DATE_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_DATE_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_DATE_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_DATE_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
115: , a35 JTF_DATE_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_DATE_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_NUMBER_TABLE
121: , a3 out nocopy JTF_NUMBER_TABLE
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , a6 out nocopy JTF_DATE_TABLE
125: , a7 out nocopy JTF_DATE_TABLE
142: , a24 out nocopy JTF_VARCHAR2_TABLE_500
143: , a25 out nocopy JTF_VARCHAR2_TABLE_500
144: , a26 out nocopy JTF_VARCHAR2_TABLE_500
145: , a27 out nocopy JTF_VARCHAR2_TABLE_500
146: , a28 out nocopy JTF_NUMBER_TABLE
147: , a29 out nocopy JTF_NUMBER_TABLE
148: , a30 out nocopy JTF_NUMBER_TABLE
149: , a31 out nocopy JTF_DATE_TABLE
150: , a32 out nocopy JTF_NUMBER_TABLE
143: , a25 out nocopy JTF_VARCHAR2_TABLE_500
144: , a26 out nocopy JTF_VARCHAR2_TABLE_500
145: , a27 out nocopy JTF_VARCHAR2_TABLE_500
146: , a28 out nocopy JTF_NUMBER_TABLE
147: , a29 out nocopy JTF_NUMBER_TABLE
148: , a30 out nocopy JTF_NUMBER_TABLE
149: , a31 out nocopy JTF_DATE_TABLE
150: , a32 out nocopy JTF_NUMBER_TABLE
151: , a33 out nocopy JTF_DATE_TABLE
144: , a26 out nocopy JTF_VARCHAR2_TABLE_500
145: , a27 out nocopy JTF_VARCHAR2_TABLE_500
146: , a28 out nocopy JTF_NUMBER_TABLE
147: , a29 out nocopy JTF_NUMBER_TABLE
148: , a30 out nocopy JTF_NUMBER_TABLE
149: , a31 out nocopy JTF_DATE_TABLE
150: , a32 out nocopy JTF_NUMBER_TABLE
151: , a33 out nocopy JTF_DATE_TABLE
152: , a34 out nocopy JTF_NUMBER_TABLE
146: , a28 out nocopy JTF_NUMBER_TABLE
147: , a29 out nocopy JTF_NUMBER_TABLE
148: , a30 out nocopy JTF_NUMBER_TABLE
149: , a31 out nocopy JTF_DATE_TABLE
150: , a32 out nocopy JTF_NUMBER_TABLE
151: , a33 out nocopy JTF_DATE_TABLE
152: , a34 out nocopy JTF_NUMBER_TABLE
153: , a35 out nocopy JTF_DATE_TABLE
154: , a36 out nocopy JTF_NUMBER_TABLE
148: , a30 out nocopy JTF_NUMBER_TABLE
149: , a31 out nocopy JTF_DATE_TABLE
150: , a32 out nocopy JTF_NUMBER_TABLE
151: , a33 out nocopy JTF_DATE_TABLE
152: , a34 out nocopy JTF_NUMBER_TABLE
153: , a35 out nocopy JTF_DATE_TABLE
154: , a36 out nocopy JTF_NUMBER_TABLE
155: );
156:
150: , a32 out nocopy JTF_NUMBER_TABLE
151: , a33 out nocopy JTF_DATE_TABLE
152: , a34 out nocopy JTF_NUMBER_TABLE
153: , a35 out nocopy JTF_DATE_TABLE
154: , a36 out nocopy JTF_NUMBER_TABLE
155: );
156:
157: procedure insert_row(p_api_version NUMBER
158: , p_init_msg_list VARCHAR2
238: , p_init_msg_list VARCHAR2
239: , x_return_status out nocopy VARCHAR2
240: , x_msg_count out nocopy NUMBER
241: , x_msg_data out nocopy VARCHAR2
242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
239: , x_return_status out nocopy VARCHAR2
240: , x_msg_count out nocopy NUMBER
241: , x_msg_data out nocopy VARCHAR2
242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_VARCHAR2_TABLE_100
240: , x_msg_count out nocopy NUMBER
241: , x_msg_data out nocopy VARCHAR2
242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_VARCHAR2_TABLE_100
248: , p5_a6 JTF_DATE_TABLE
241: , x_msg_data out nocopy VARCHAR2
242: , p5_a0 JTF_NUMBER_TABLE
243: , p5_a1 JTF_NUMBER_TABLE
244: , p5_a2 JTF_NUMBER_TABLE
245: , p5_a3 JTF_NUMBER_TABLE
246: , p5_a4 JTF_VARCHAR2_TABLE_100
247: , p5_a5 JTF_VARCHAR2_TABLE_100
248: , p5_a6 JTF_DATE_TABLE
249: , p5_a7 JTF_DATE_TABLE
266: , p5_a24 JTF_VARCHAR2_TABLE_500
267: , p5_a25 JTF_VARCHAR2_TABLE_500
268: , p5_a26 JTF_VARCHAR2_TABLE_500
269: , p5_a27 JTF_VARCHAR2_TABLE_500
270: , p5_a28 JTF_NUMBER_TABLE
271: , p5_a29 JTF_NUMBER_TABLE
272: , p5_a30 JTF_NUMBER_TABLE
273: , p5_a31 JTF_DATE_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
267: , p5_a25 JTF_VARCHAR2_TABLE_500
268: , p5_a26 JTF_VARCHAR2_TABLE_500
269: , p5_a27 JTF_VARCHAR2_TABLE_500
270: , p5_a28 JTF_NUMBER_TABLE
271: , p5_a29 JTF_NUMBER_TABLE
272: , p5_a30 JTF_NUMBER_TABLE
273: , p5_a31 JTF_DATE_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
268: , p5_a26 JTF_VARCHAR2_TABLE_500
269: , p5_a27 JTF_VARCHAR2_TABLE_500
270: , p5_a28 JTF_NUMBER_TABLE
271: , p5_a29 JTF_NUMBER_TABLE
272: , p5_a30 JTF_NUMBER_TABLE
273: , p5_a31 JTF_DATE_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
270: , p5_a28 JTF_NUMBER_TABLE
271: , p5_a29 JTF_NUMBER_TABLE
272: , p5_a30 JTF_NUMBER_TABLE
273: , p5_a31 JTF_DATE_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
272: , p5_a30 JTF_NUMBER_TABLE
273: , p5_a31 JTF_DATE_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
277: , p5_a35 JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_DATE_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_NUMBER_TABLE
282: , p6_a3 out nocopy JTF_NUMBER_TABLE
283: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_DATE_TABLE
286: , p6_a7 out nocopy JTF_DATE_TABLE
303: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
305: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_NUMBER_TABLE
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_NUMBER_TABLE
310: , p6_a31 out nocopy JTF_DATE_TABLE
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
304: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
305: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_NUMBER_TABLE
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_NUMBER_TABLE
310: , p6_a31 out nocopy JTF_DATE_TABLE
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
312: , p6_a33 out nocopy JTF_DATE_TABLE
305: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_NUMBER_TABLE
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_NUMBER_TABLE
310: , p6_a31 out nocopy JTF_DATE_TABLE
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
312: , p6_a33 out nocopy JTF_DATE_TABLE
313: , p6_a34 out nocopy JTF_NUMBER_TABLE
307: , p6_a28 out nocopy JTF_NUMBER_TABLE
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_NUMBER_TABLE
310: , p6_a31 out nocopy JTF_DATE_TABLE
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
312: , p6_a33 out nocopy JTF_DATE_TABLE
313: , p6_a34 out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_NUMBER_TABLE
310: , p6_a31 out nocopy JTF_DATE_TABLE
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
312: , p6_a33 out nocopy JTF_DATE_TABLE
313: , p6_a34 out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
311: , p6_a32 out nocopy JTF_NUMBER_TABLE
312: , p6_a33 out nocopy JTF_DATE_TABLE
313: , p6_a34 out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a33 out nocopy JTF_DATE_TABLE
313: , p6_a34 out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
314: , p6_a35 out nocopy JTF_DATE_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
316: , p7_a0 in out nocopy JTF_NUMBER_TABLE
317: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a2 in out nocopy JTF_NUMBER_TABLE
319: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
320: , p7_a4 in out nocopy JTF_NUMBER_TABLE
321: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
323: );
324: procedure insert_row(p_api_version NUMBER
325: , p_init_msg_list VARCHAR2
326: , x_return_status out nocopy VARCHAR2
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
326: , x_return_status out nocopy VARCHAR2
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
334: , p5_a5 JTF_VARCHAR2_TABLE_100
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
334: , p5_a5 JTF_VARCHAR2_TABLE_100
335: , p5_a6 JTF_DATE_TABLE
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_100
334: , p5_a5 JTF_VARCHAR2_TABLE_100
335: , p5_a6 JTF_DATE_TABLE
336: , p5_a7 JTF_DATE_TABLE
353: , p5_a24 JTF_VARCHAR2_TABLE_500
354: , p5_a25 JTF_VARCHAR2_TABLE_500
355: , p5_a26 JTF_VARCHAR2_TABLE_500
356: , p5_a27 JTF_VARCHAR2_TABLE_500
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_NUMBER_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
354: , p5_a25 JTF_VARCHAR2_TABLE_500
355: , p5_a26 JTF_VARCHAR2_TABLE_500
356: , p5_a27 JTF_VARCHAR2_TABLE_500
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_NUMBER_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
355: , p5_a26 JTF_VARCHAR2_TABLE_500
356: , p5_a27 JTF_VARCHAR2_TABLE_500
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_NUMBER_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
363: , p5_a34 JTF_NUMBER_TABLE
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_NUMBER_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
363: , p5_a34 JTF_NUMBER_TABLE
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
363: , p5_a34 JTF_NUMBER_TABLE
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
363: , p5_a34 JTF_NUMBER_TABLE
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
362: , p5_a33 JTF_DATE_TABLE
363: , p5_a34 JTF_NUMBER_TABLE
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
363: , p5_a34 JTF_NUMBER_TABLE
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
364: , p5_a35 JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_DATE_TABLE
365: , p5_a36 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_NUMBER_TABLE
369: , p6_a3 out nocopy JTF_NUMBER_TABLE
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a6 out nocopy JTF_DATE_TABLE
373: , p6_a7 out nocopy JTF_DATE_TABLE
390: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
391: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
392: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
393: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
394: , p6_a28 out nocopy JTF_NUMBER_TABLE
395: , p6_a29 out nocopy JTF_NUMBER_TABLE
396: , p6_a30 out nocopy JTF_NUMBER_TABLE
397: , p6_a31 out nocopy JTF_DATE_TABLE
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
391: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
392: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
393: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
394: , p6_a28 out nocopy JTF_NUMBER_TABLE
395: , p6_a29 out nocopy JTF_NUMBER_TABLE
396: , p6_a30 out nocopy JTF_NUMBER_TABLE
397: , p6_a31 out nocopy JTF_DATE_TABLE
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
399: , p6_a33 out nocopy JTF_DATE_TABLE
392: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
393: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
394: , p6_a28 out nocopy JTF_NUMBER_TABLE
395: , p6_a29 out nocopy JTF_NUMBER_TABLE
396: , p6_a30 out nocopy JTF_NUMBER_TABLE
397: , p6_a31 out nocopy JTF_DATE_TABLE
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
399: , p6_a33 out nocopy JTF_DATE_TABLE
400: , p6_a34 out nocopy JTF_NUMBER_TABLE
394: , p6_a28 out nocopy JTF_NUMBER_TABLE
395: , p6_a29 out nocopy JTF_NUMBER_TABLE
396: , p6_a30 out nocopy JTF_NUMBER_TABLE
397: , p6_a31 out nocopy JTF_DATE_TABLE
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
399: , p6_a33 out nocopy JTF_DATE_TABLE
400: , p6_a34 out nocopy JTF_NUMBER_TABLE
401: , p6_a35 out nocopy JTF_DATE_TABLE
402: , p6_a36 out nocopy JTF_NUMBER_TABLE
396: , p6_a30 out nocopy JTF_NUMBER_TABLE
397: , p6_a31 out nocopy JTF_DATE_TABLE
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
399: , p6_a33 out nocopy JTF_DATE_TABLE
400: , p6_a34 out nocopy JTF_NUMBER_TABLE
401: , p6_a35 out nocopy JTF_DATE_TABLE
402: , p6_a36 out nocopy JTF_NUMBER_TABLE
403: );
404: procedure lock_row(p_api_version NUMBER
398: , p6_a32 out nocopy JTF_NUMBER_TABLE
399: , p6_a33 out nocopy JTF_DATE_TABLE
400: , p6_a34 out nocopy JTF_NUMBER_TABLE
401: , p6_a35 out nocopy JTF_DATE_TABLE
402: , p6_a36 out nocopy JTF_NUMBER_TABLE
403: );
404: procedure lock_row(p_api_version NUMBER
405: , p_init_msg_list VARCHAR2
406: , x_return_status out nocopy VARCHAR2
448: , p_init_msg_list VARCHAR2
449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
449: , x_return_status out nocopy VARCHAR2
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_DATE_TABLE
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_NUMBER_TABLE
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_VARCHAR2_TABLE_100
458: , p5_a6 JTF_DATE_TABLE
459: , p5_a7 JTF_DATE_TABLE
476: , p5_a24 JTF_VARCHAR2_TABLE_500
477: , p5_a25 JTF_VARCHAR2_TABLE_500
478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_NUMBER_TABLE
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_NUMBER_TABLE
477: , p5_a25 JTF_VARCHAR2_TABLE_500
478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_NUMBER_TABLE
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_NUMBER_TABLE
485: , p5_a33 JTF_DATE_TABLE
478: , p5_a26 JTF_VARCHAR2_TABLE_500
479: , p5_a27 JTF_VARCHAR2_TABLE_500
480: , p5_a28 JTF_NUMBER_TABLE
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_NUMBER_TABLE
485: , p5_a33 JTF_DATE_TABLE
486: , p5_a34 JTF_NUMBER_TABLE
480: , p5_a28 JTF_NUMBER_TABLE
481: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_NUMBER_TABLE
485: , p5_a33 JTF_DATE_TABLE
486: , p5_a34 JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
482: , p5_a30 JTF_NUMBER_TABLE
483: , p5_a31 JTF_DATE_TABLE
484: , p5_a32 JTF_NUMBER_TABLE
485: , p5_a33 JTF_DATE_TABLE
486: , p5_a34 JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
484: , p5_a32 JTF_NUMBER_TABLE
485: , p5_a33 JTF_DATE_TABLE
486: , p5_a34 JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
485: , p5_a33 JTF_DATE_TABLE
486: , p5_a34 JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
487: , p5_a35 JTF_DATE_TABLE
488: , p5_a36 JTF_NUMBER_TABLE
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a0 in out nocopy JTF_NUMBER_TABLE
490: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a2 in out nocopy JTF_NUMBER_TABLE
492: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
493: , p6_a4 in out nocopy JTF_NUMBER_TABLE
494: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
495: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
496: );
497: procedure lock_row(p_api_version NUMBER
498: , p_init_msg_list VARCHAR2
499: , x_return_status out nocopy VARCHAR2
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
499: , x_return_status out nocopy VARCHAR2
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_DATE_TABLE
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_NUMBER_TABLE
505: , p5_a3 JTF_NUMBER_TABLE
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , p5_a6 JTF_DATE_TABLE
509: , p5_a7 JTF_DATE_TABLE
526: , p5_a24 JTF_VARCHAR2_TABLE_500
527: , p5_a25 JTF_VARCHAR2_TABLE_500
528: , p5_a26 JTF_VARCHAR2_TABLE_500
529: , p5_a27 JTF_VARCHAR2_TABLE_500
530: , p5_a28 JTF_NUMBER_TABLE
531: , p5_a29 JTF_NUMBER_TABLE
532: , p5_a30 JTF_NUMBER_TABLE
533: , p5_a31 JTF_DATE_TABLE
534: , p5_a32 JTF_NUMBER_TABLE
527: , p5_a25 JTF_VARCHAR2_TABLE_500
528: , p5_a26 JTF_VARCHAR2_TABLE_500
529: , p5_a27 JTF_VARCHAR2_TABLE_500
530: , p5_a28 JTF_NUMBER_TABLE
531: , p5_a29 JTF_NUMBER_TABLE
532: , p5_a30 JTF_NUMBER_TABLE
533: , p5_a31 JTF_DATE_TABLE
534: , p5_a32 JTF_NUMBER_TABLE
535: , p5_a33 JTF_DATE_TABLE
528: , p5_a26 JTF_VARCHAR2_TABLE_500
529: , p5_a27 JTF_VARCHAR2_TABLE_500
530: , p5_a28 JTF_NUMBER_TABLE
531: , p5_a29 JTF_NUMBER_TABLE
532: , p5_a30 JTF_NUMBER_TABLE
533: , p5_a31 JTF_DATE_TABLE
534: , p5_a32 JTF_NUMBER_TABLE
535: , p5_a33 JTF_DATE_TABLE
536: , p5_a34 JTF_NUMBER_TABLE
530: , p5_a28 JTF_NUMBER_TABLE
531: , p5_a29 JTF_NUMBER_TABLE
532: , p5_a30 JTF_NUMBER_TABLE
533: , p5_a31 JTF_DATE_TABLE
534: , p5_a32 JTF_NUMBER_TABLE
535: , p5_a33 JTF_DATE_TABLE
536: , p5_a34 JTF_NUMBER_TABLE
537: , p5_a35 JTF_DATE_TABLE
538: , p5_a36 JTF_NUMBER_TABLE
532: , p5_a30 JTF_NUMBER_TABLE
533: , p5_a31 JTF_DATE_TABLE
534: , p5_a32 JTF_NUMBER_TABLE
535: , p5_a33 JTF_DATE_TABLE
536: , p5_a34 JTF_NUMBER_TABLE
537: , p5_a35 JTF_DATE_TABLE
538: , p5_a36 JTF_NUMBER_TABLE
539: );
540: procedure update_row(p_api_version NUMBER
534: , p5_a32 JTF_NUMBER_TABLE
535: , p5_a33 JTF_DATE_TABLE
536: , p5_a34 JTF_NUMBER_TABLE
537: , p5_a35 JTF_DATE_TABLE
538: , p5_a36 JTF_NUMBER_TABLE
539: );
540: procedure update_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
621: , p_init_msg_list VARCHAR2
622: , x_return_status out nocopy VARCHAR2
623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
622: , x_return_status out nocopy VARCHAR2
623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
630: , p5_a5 JTF_VARCHAR2_TABLE_100
623: , x_msg_count out nocopy NUMBER
624: , x_msg_data out nocopy VARCHAR2
625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_DATE_TABLE
624: , x_msg_data out nocopy VARCHAR2
625: , p5_a0 JTF_NUMBER_TABLE
626: , p5_a1 JTF_NUMBER_TABLE
627: , p5_a2 JTF_NUMBER_TABLE
628: , p5_a3 JTF_NUMBER_TABLE
629: , p5_a4 JTF_VARCHAR2_TABLE_100
630: , p5_a5 JTF_VARCHAR2_TABLE_100
631: , p5_a6 JTF_DATE_TABLE
632: , p5_a7 JTF_DATE_TABLE
649: , p5_a24 JTF_VARCHAR2_TABLE_500
650: , p5_a25 JTF_VARCHAR2_TABLE_500
651: , p5_a26 JTF_VARCHAR2_TABLE_500
652: , p5_a27 JTF_VARCHAR2_TABLE_500
653: , p5_a28 JTF_NUMBER_TABLE
654: , p5_a29 JTF_NUMBER_TABLE
655: , p5_a30 JTF_NUMBER_TABLE
656: , p5_a31 JTF_DATE_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
650: , p5_a25 JTF_VARCHAR2_TABLE_500
651: , p5_a26 JTF_VARCHAR2_TABLE_500
652: , p5_a27 JTF_VARCHAR2_TABLE_500
653: , p5_a28 JTF_NUMBER_TABLE
654: , p5_a29 JTF_NUMBER_TABLE
655: , p5_a30 JTF_NUMBER_TABLE
656: , p5_a31 JTF_DATE_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
651: , p5_a26 JTF_VARCHAR2_TABLE_500
652: , p5_a27 JTF_VARCHAR2_TABLE_500
653: , p5_a28 JTF_NUMBER_TABLE
654: , p5_a29 JTF_NUMBER_TABLE
655: , p5_a30 JTF_NUMBER_TABLE
656: , p5_a31 JTF_DATE_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
659: , p5_a34 JTF_NUMBER_TABLE
653: , p5_a28 JTF_NUMBER_TABLE
654: , p5_a29 JTF_NUMBER_TABLE
655: , p5_a30 JTF_NUMBER_TABLE
656: , p5_a31 JTF_DATE_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
659: , p5_a34 JTF_NUMBER_TABLE
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
655: , p5_a30 JTF_NUMBER_TABLE
656: , p5_a31 JTF_DATE_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
659: , p5_a34 JTF_NUMBER_TABLE
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
657: , p5_a32 JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
659: , p5_a34 JTF_NUMBER_TABLE
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
658: , p5_a33 JTF_DATE_TABLE
659: , p5_a34 JTF_NUMBER_TABLE
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
659: , p5_a34 JTF_NUMBER_TABLE
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
660: , p5_a35 JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
668: , p6_a6 out nocopy JTF_DATE_TABLE
661: , p5_a36 JTF_NUMBER_TABLE
662: , p6_a0 out nocopy JTF_NUMBER_TABLE
663: , p6_a1 out nocopy JTF_NUMBER_TABLE
664: , p6_a2 out nocopy JTF_NUMBER_TABLE
665: , p6_a3 out nocopy JTF_NUMBER_TABLE
666: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
667: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
668: , p6_a6 out nocopy JTF_DATE_TABLE
669: , p6_a7 out nocopy JTF_DATE_TABLE
686: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
687: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
688: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
689: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
690: , p6_a28 out nocopy JTF_NUMBER_TABLE
691: , p6_a29 out nocopy JTF_NUMBER_TABLE
692: , p6_a30 out nocopy JTF_NUMBER_TABLE
693: , p6_a31 out nocopy JTF_DATE_TABLE
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
687: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
688: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
689: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
690: , p6_a28 out nocopy JTF_NUMBER_TABLE
691: , p6_a29 out nocopy JTF_NUMBER_TABLE
692: , p6_a30 out nocopy JTF_NUMBER_TABLE
693: , p6_a31 out nocopy JTF_DATE_TABLE
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
695: , p6_a33 out nocopy JTF_DATE_TABLE
688: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
689: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
690: , p6_a28 out nocopy JTF_NUMBER_TABLE
691: , p6_a29 out nocopy JTF_NUMBER_TABLE
692: , p6_a30 out nocopy JTF_NUMBER_TABLE
693: , p6_a31 out nocopy JTF_DATE_TABLE
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
695: , p6_a33 out nocopy JTF_DATE_TABLE
696: , p6_a34 out nocopy JTF_NUMBER_TABLE
690: , p6_a28 out nocopy JTF_NUMBER_TABLE
691: , p6_a29 out nocopy JTF_NUMBER_TABLE
692: , p6_a30 out nocopy JTF_NUMBER_TABLE
693: , p6_a31 out nocopy JTF_DATE_TABLE
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
695: , p6_a33 out nocopy JTF_DATE_TABLE
696: , p6_a34 out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
692: , p6_a30 out nocopy JTF_NUMBER_TABLE
693: , p6_a31 out nocopy JTF_DATE_TABLE
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
695: , p6_a33 out nocopy JTF_DATE_TABLE
696: , p6_a34 out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a32 out nocopy JTF_NUMBER_TABLE
695: , p6_a33 out nocopy JTF_DATE_TABLE
696: , p6_a34 out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
695: , p6_a33 out nocopy JTF_DATE_TABLE
696: , p6_a34 out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
697: , p6_a35 out nocopy JTF_DATE_TABLE
698: , p6_a36 out nocopy JTF_NUMBER_TABLE
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
699: , p7_a0 in out nocopy JTF_NUMBER_TABLE
700: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
701: , p7_a2 in out nocopy JTF_NUMBER_TABLE
702: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
703: , p7_a4 in out nocopy JTF_NUMBER_TABLE
704: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
705: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
706: );
707: procedure update_row(p_api_version NUMBER
708: , p_init_msg_list VARCHAR2
709: , x_return_status out nocopy VARCHAR2
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
709: , x_return_status out nocopy VARCHAR2
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
717: , p5_a5 JTF_VARCHAR2_TABLE_100
710: , x_msg_count out nocopy NUMBER
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_DATE_TABLE
711: , x_msg_data out nocopy VARCHAR2
712: , p5_a0 JTF_NUMBER_TABLE
713: , p5_a1 JTF_NUMBER_TABLE
714: , p5_a2 JTF_NUMBER_TABLE
715: , p5_a3 JTF_NUMBER_TABLE
716: , p5_a4 JTF_VARCHAR2_TABLE_100
717: , p5_a5 JTF_VARCHAR2_TABLE_100
718: , p5_a6 JTF_DATE_TABLE
719: , p5_a7 JTF_DATE_TABLE
736: , p5_a24 JTF_VARCHAR2_TABLE_500
737: , p5_a25 JTF_VARCHAR2_TABLE_500
738: , p5_a26 JTF_VARCHAR2_TABLE_500
739: , p5_a27 JTF_VARCHAR2_TABLE_500
740: , p5_a28 JTF_NUMBER_TABLE
741: , p5_a29 JTF_NUMBER_TABLE
742: , p5_a30 JTF_NUMBER_TABLE
743: , p5_a31 JTF_DATE_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
737: , p5_a25 JTF_VARCHAR2_TABLE_500
738: , p5_a26 JTF_VARCHAR2_TABLE_500
739: , p5_a27 JTF_VARCHAR2_TABLE_500
740: , p5_a28 JTF_NUMBER_TABLE
741: , p5_a29 JTF_NUMBER_TABLE
742: , p5_a30 JTF_NUMBER_TABLE
743: , p5_a31 JTF_DATE_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
738: , p5_a26 JTF_VARCHAR2_TABLE_500
739: , p5_a27 JTF_VARCHAR2_TABLE_500
740: , p5_a28 JTF_NUMBER_TABLE
741: , p5_a29 JTF_NUMBER_TABLE
742: , p5_a30 JTF_NUMBER_TABLE
743: , p5_a31 JTF_DATE_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
746: , p5_a34 JTF_NUMBER_TABLE
740: , p5_a28 JTF_NUMBER_TABLE
741: , p5_a29 JTF_NUMBER_TABLE
742: , p5_a30 JTF_NUMBER_TABLE
743: , p5_a31 JTF_DATE_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
746: , p5_a34 JTF_NUMBER_TABLE
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
742: , p5_a30 JTF_NUMBER_TABLE
743: , p5_a31 JTF_DATE_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
746: , p5_a34 JTF_NUMBER_TABLE
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
744: , p5_a32 JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
746: , p5_a34 JTF_NUMBER_TABLE
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
745: , p5_a33 JTF_DATE_TABLE
746: , p5_a34 JTF_NUMBER_TABLE
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
746: , p5_a34 JTF_NUMBER_TABLE
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
747: , p5_a35 JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a6 out nocopy JTF_DATE_TABLE
748: , p5_a36 JTF_NUMBER_TABLE
749: , p6_a0 out nocopy JTF_NUMBER_TABLE
750: , p6_a1 out nocopy JTF_NUMBER_TABLE
751: , p6_a2 out nocopy JTF_NUMBER_TABLE
752: , p6_a3 out nocopy JTF_NUMBER_TABLE
753: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
754: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
755: , p6_a6 out nocopy JTF_DATE_TABLE
756: , p6_a7 out nocopy JTF_DATE_TABLE
773: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
774: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
775: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
776: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
777: , p6_a28 out nocopy JTF_NUMBER_TABLE
778: , p6_a29 out nocopy JTF_NUMBER_TABLE
779: , p6_a30 out nocopy JTF_NUMBER_TABLE
780: , p6_a31 out nocopy JTF_DATE_TABLE
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
774: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
775: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
776: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
777: , p6_a28 out nocopy JTF_NUMBER_TABLE
778: , p6_a29 out nocopy JTF_NUMBER_TABLE
779: , p6_a30 out nocopy JTF_NUMBER_TABLE
780: , p6_a31 out nocopy JTF_DATE_TABLE
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
782: , p6_a33 out nocopy JTF_DATE_TABLE
775: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
776: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
777: , p6_a28 out nocopy JTF_NUMBER_TABLE
778: , p6_a29 out nocopy JTF_NUMBER_TABLE
779: , p6_a30 out nocopy JTF_NUMBER_TABLE
780: , p6_a31 out nocopy JTF_DATE_TABLE
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
782: , p6_a33 out nocopy JTF_DATE_TABLE
783: , p6_a34 out nocopy JTF_NUMBER_TABLE
777: , p6_a28 out nocopy JTF_NUMBER_TABLE
778: , p6_a29 out nocopy JTF_NUMBER_TABLE
779: , p6_a30 out nocopy JTF_NUMBER_TABLE
780: , p6_a31 out nocopy JTF_DATE_TABLE
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
782: , p6_a33 out nocopy JTF_DATE_TABLE
783: , p6_a34 out nocopy JTF_NUMBER_TABLE
784: , p6_a35 out nocopy JTF_DATE_TABLE
785: , p6_a36 out nocopy JTF_NUMBER_TABLE
779: , p6_a30 out nocopy JTF_NUMBER_TABLE
780: , p6_a31 out nocopy JTF_DATE_TABLE
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
782: , p6_a33 out nocopy JTF_DATE_TABLE
783: , p6_a34 out nocopy JTF_NUMBER_TABLE
784: , p6_a35 out nocopy JTF_DATE_TABLE
785: , p6_a36 out nocopy JTF_NUMBER_TABLE
786: );
787: procedure delete_row(p_api_version NUMBER
781: , p6_a32 out nocopy JTF_NUMBER_TABLE
782: , p6_a33 out nocopy JTF_DATE_TABLE
783: , p6_a34 out nocopy JTF_NUMBER_TABLE
784: , p6_a35 out nocopy JTF_DATE_TABLE
785: , p6_a36 out nocopy JTF_NUMBER_TABLE
786: );
787: procedure delete_row(p_api_version NUMBER
788: , p_init_msg_list VARCHAR2
789: , x_return_status out nocopy VARCHAR2
831: , p_init_msg_list VARCHAR2
832: , x_return_status out nocopy VARCHAR2
833: , x_msg_count out nocopy NUMBER
834: , x_msg_data out nocopy VARCHAR2
835: , p5_a0 JTF_NUMBER_TABLE
836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
832: , x_return_status out nocopy VARCHAR2
833: , x_msg_count out nocopy NUMBER
834: , x_msg_data out nocopy VARCHAR2
835: , p5_a0 JTF_NUMBER_TABLE
836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
840: , p5_a5 JTF_VARCHAR2_TABLE_100
833: , x_msg_count out nocopy NUMBER
834: , x_msg_data out nocopy VARCHAR2
835: , p5_a0 JTF_NUMBER_TABLE
836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
840: , p5_a5 JTF_VARCHAR2_TABLE_100
841: , p5_a6 JTF_DATE_TABLE
834: , x_msg_data out nocopy VARCHAR2
835: , p5_a0 JTF_NUMBER_TABLE
836: , p5_a1 JTF_NUMBER_TABLE
837: , p5_a2 JTF_NUMBER_TABLE
838: , p5_a3 JTF_NUMBER_TABLE
839: , p5_a4 JTF_VARCHAR2_TABLE_100
840: , p5_a5 JTF_VARCHAR2_TABLE_100
841: , p5_a6 JTF_DATE_TABLE
842: , p5_a7 JTF_DATE_TABLE
859: , p5_a24 JTF_VARCHAR2_TABLE_500
860: , p5_a25 JTF_VARCHAR2_TABLE_500
861: , p5_a26 JTF_VARCHAR2_TABLE_500
862: , p5_a27 JTF_VARCHAR2_TABLE_500
863: , p5_a28 JTF_NUMBER_TABLE
864: , p5_a29 JTF_NUMBER_TABLE
865: , p5_a30 JTF_NUMBER_TABLE
866: , p5_a31 JTF_DATE_TABLE
867: , p5_a32 JTF_NUMBER_TABLE
860: , p5_a25 JTF_VARCHAR2_TABLE_500
861: , p5_a26 JTF_VARCHAR2_TABLE_500
862: , p5_a27 JTF_VARCHAR2_TABLE_500
863: , p5_a28 JTF_NUMBER_TABLE
864: , p5_a29 JTF_NUMBER_TABLE
865: , p5_a30 JTF_NUMBER_TABLE
866: , p5_a31 JTF_DATE_TABLE
867: , p5_a32 JTF_NUMBER_TABLE
868: , p5_a33 JTF_DATE_TABLE
861: , p5_a26 JTF_VARCHAR2_TABLE_500
862: , p5_a27 JTF_VARCHAR2_TABLE_500
863: , p5_a28 JTF_NUMBER_TABLE
864: , p5_a29 JTF_NUMBER_TABLE
865: , p5_a30 JTF_NUMBER_TABLE
866: , p5_a31 JTF_DATE_TABLE
867: , p5_a32 JTF_NUMBER_TABLE
868: , p5_a33 JTF_DATE_TABLE
869: , p5_a34 JTF_NUMBER_TABLE
863: , p5_a28 JTF_NUMBER_TABLE
864: , p5_a29 JTF_NUMBER_TABLE
865: , p5_a30 JTF_NUMBER_TABLE
866: , p5_a31 JTF_DATE_TABLE
867: , p5_a32 JTF_NUMBER_TABLE
868: , p5_a33 JTF_DATE_TABLE
869: , p5_a34 JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
865: , p5_a30 JTF_NUMBER_TABLE
866: , p5_a31 JTF_DATE_TABLE
867: , p5_a32 JTF_NUMBER_TABLE
868: , p5_a33 JTF_DATE_TABLE
869: , p5_a34 JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
867: , p5_a32 JTF_NUMBER_TABLE
868: , p5_a33 JTF_DATE_TABLE
869: , p5_a34 JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p5_a33 JTF_DATE_TABLE
869: , p5_a34 JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
870: , p5_a35 JTF_DATE_TABLE
871: , p5_a36 JTF_NUMBER_TABLE
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
878: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a0 in out nocopy JTF_NUMBER_TABLE
873: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a2 in out nocopy JTF_NUMBER_TABLE
875: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
876: , p6_a4 in out nocopy JTF_NUMBER_TABLE
877: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
878: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
879: );
880: procedure delete_row(p_api_version NUMBER
881: , p_init_msg_list VARCHAR2
882: , x_return_status out nocopy VARCHAR2
883: , x_msg_count out nocopy NUMBER
884: , x_msg_data out nocopy VARCHAR2
885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
882: , x_return_status out nocopy VARCHAR2
883: , x_msg_count out nocopy NUMBER
884: , x_msg_data out nocopy VARCHAR2
885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
890: , p5_a5 JTF_VARCHAR2_TABLE_100
883: , x_msg_count out nocopy NUMBER
884: , x_msg_data out nocopy VARCHAR2
885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_DATE_TABLE
884: , x_msg_data out nocopy VARCHAR2
885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_NUMBER_TABLE
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_VARCHAR2_TABLE_100
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_DATE_TABLE
892: , p5_a7 JTF_DATE_TABLE
909: , p5_a24 JTF_VARCHAR2_TABLE_500
910: , p5_a25 JTF_VARCHAR2_TABLE_500
911: , p5_a26 JTF_VARCHAR2_TABLE_500
912: , p5_a27 JTF_VARCHAR2_TABLE_500
913: , p5_a28 JTF_NUMBER_TABLE
914: , p5_a29 JTF_NUMBER_TABLE
915: , p5_a30 JTF_NUMBER_TABLE
916: , p5_a31 JTF_DATE_TABLE
917: , p5_a32 JTF_NUMBER_TABLE
910: , p5_a25 JTF_VARCHAR2_TABLE_500
911: , p5_a26 JTF_VARCHAR2_TABLE_500
912: , p5_a27 JTF_VARCHAR2_TABLE_500
913: , p5_a28 JTF_NUMBER_TABLE
914: , p5_a29 JTF_NUMBER_TABLE
915: , p5_a30 JTF_NUMBER_TABLE
916: , p5_a31 JTF_DATE_TABLE
917: , p5_a32 JTF_NUMBER_TABLE
918: , p5_a33 JTF_DATE_TABLE
911: , p5_a26 JTF_VARCHAR2_TABLE_500
912: , p5_a27 JTF_VARCHAR2_TABLE_500
913: , p5_a28 JTF_NUMBER_TABLE
914: , p5_a29 JTF_NUMBER_TABLE
915: , p5_a30 JTF_NUMBER_TABLE
916: , p5_a31 JTF_DATE_TABLE
917: , p5_a32 JTF_NUMBER_TABLE
918: , p5_a33 JTF_DATE_TABLE
919: , p5_a34 JTF_NUMBER_TABLE
913: , p5_a28 JTF_NUMBER_TABLE
914: , p5_a29 JTF_NUMBER_TABLE
915: , p5_a30 JTF_NUMBER_TABLE
916: , p5_a31 JTF_DATE_TABLE
917: , p5_a32 JTF_NUMBER_TABLE
918: , p5_a33 JTF_DATE_TABLE
919: , p5_a34 JTF_NUMBER_TABLE
920: , p5_a35 JTF_DATE_TABLE
921: , p5_a36 JTF_NUMBER_TABLE
915: , p5_a30 JTF_NUMBER_TABLE
916: , p5_a31 JTF_DATE_TABLE
917: , p5_a32 JTF_NUMBER_TABLE
918: , p5_a33 JTF_DATE_TABLE
919: , p5_a34 JTF_NUMBER_TABLE
920: , p5_a35 JTF_DATE_TABLE
921: , p5_a36 JTF_NUMBER_TABLE
922: );
923: procedure validate_row(p_api_version NUMBER
917: , p5_a32 JTF_NUMBER_TABLE
918: , p5_a33 JTF_DATE_TABLE
919: , p5_a34 JTF_NUMBER_TABLE
920: , p5_a35 JTF_DATE_TABLE
921: , p5_a36 JTF_NUMBER_TABLE
922: );
923: procedure validate_row(p_api_version NUMBER
924: , p_init_msg_list VARCHAR2
925: , x_return_status out nocopy VARCHAR2
967: , p_init_msg_list VARCHAR2
968: , x_return_status out nocopy VARCHAR2
969: , x_msg_count out nocopy NUMBER
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 JTF_NUMBER_TABLE
972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
968: , x_return_status out nocopy VARCHAR2
969: , x_msg_count out nocopy NUMBER
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 JTF_NUMBER_TABLE
972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
976: , p5_a5 JTF_VARCHAR2_TABLE_100
969: , x_msg_count out nocopy NUMBER
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 JTF_NUMBER_TABLE
972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
976: , p5_a5 JTF_VARCHAR2_TABLE_100
977: , p5_a6 JTF_DATE_TABLE
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 JTF_NUMBER_TABLE
972: , p5_a1 JTF_NUMBER_TABLE
973: , p5_a2 JTF_NUMBER_TABLE
974: , p5_a3 JTF_NUMBER_TABLE
975: , p5_a4 JTF_VARCHAR2_TABLE_100
976: , p5_a5 JTF_VARCHAR2_TABLE_100
977: , p5_a6 JTF_DATE_TABLE
978: , p5_a7 JTF_DATE_TABLE
995: , p5_a24 JTF_VARCHAR2_TABLE_500
996: , p5_a25 JTF_VARCHAR2_TABLE_500
997: , p5_a26 JTF_VARCHAR2_TABLE_500
998: , p5_a27 JTF_VARCHAR2_TABLE_500
999: , p5_a28 JTF_NUMBER_TABLE
1000: , p5_a29 JTF_NUMBER_TABLE
1001: , p5_a30 JTF_NUMBER_TABLE
1002: , p5_a31 JTF_DATE_TABLE
1003: , p5_a32 JTF_NUMBER_TABLE
996: , p5_a25 JTF_VARCHAR2_TABLE_500
997: , p5_a26 JTF_VARCHAR2_TABLE_500
998: , p5_a27 JTF_VARCHAR2_TABLE_500
999: , p5_a28 JTF_NUMBER_TABLE
1000: , p5_a29 JTF_NUMBER_TABLE
1001: , p5_a30 JTF_NUMBER_TABLE
1002: , p5_a31 JTF_DATE_TABLE
1003: , p5_a32 JTF_NUMBER_TABLE
1004: , p5_a33 JTF_DATE_TABLE
997: , p5_a26 JTF_VARCHAR2_TABLE_500
998: , p5_a27 JTF_VARCHAR2_TABLE_500
999: , p5_a28 JTF_NUMBER_TABLE
1000: , p5_a29 JTF_NUMBER_TABLE
1001: , p5_a30 JTF_NUMBER_TABLE
1002: , p5_a31 JTF_DATE_TABLE
1003: , p5_a32 JTF_NUMBER_TABLE
1004: , p5_a33 JTF_DATE_TABLE
1005: , p5_a34 JTF_NUMBER_TABLE
999: , p5_a28 JTF_NUMBER_TABLE
1000: , p5_a29 JTF_NUMBER_TABLE
1001: , p5_a30 JTF_NUMBER_TABLE
1002: , p5_a31 JTF_DATE_TABLE
1003: , p5_a32 JTF_NUMBER_TABLE
1004: , p5_a33 JTF_DATE_TABLE
1005: , p5_a34 JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1001: , p5_a30 JTF_NUMBER_TABLE
1002: , p5_a31 JTF_DATE_TABLE
1003: , p5_a32 JTF_NUMBER_TABLE
1004: , p5_a33 JTF_DATE_TABLE
1005: , p5_a34 JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1003: , p5_a32 JTF_NUMBER_TABLE
1004: , p5_a33 JTF_DATE_TABLE
1005: , p5_a34 JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1004: , p5_a33 JTF_DATE_TABLE
1005: , p5_a34 JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1006: , p5_a35 JTF_DATE_TABLE
1007: , p5_a36 JTF_NUMBER_TABLE
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1008: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1009: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1010: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1011: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1013: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1014: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1015: );
1016: procedure validate_row(p_api_version NUMBER
1017: , p_init_msg_list VARCHAR2
1018: , x_return_status out nocopy VARCHAR2
1019: , x_msg_count out nocopy NUMBER
1020: , x_msg_data out nocopy VARCHAR2
1021: , p5_a0 JTF_NUMBER_TABLE
1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1018: , x_return_status out nocopy VARCHAR2
1019: , x_msg_count out nocopy NUMBER
1020: , x_msg_data out nocopy VARCHAR2
1021: , p5_a0 JTF_NUMBER_TABLE
1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1026: , p5_a5 JTF_VARCHAR2_TABLE_100
1019: , x_msg_count out nocopy NUMBER
1020: , x_msg_data out nocopy VARCHAR2
1021: , p5_a0 JTF_NUMBER_TABLE
1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1026: , p5_a5 JTF_VARCHAR2_TABLE_100
1027: , p5_a6 JTF_DATE_TABLE
1020: , x_msg_data out nocopy VARCHAR2
1021: , p5_a0 JTF_NUMBER_TABLE
1022: , p5_a1 JTF_NUMBER_TABLE
1023: , p5_a2 JTF_NUMBER_TABLE
1024: , p5_a3 JTF_NUMBER_TABLE
1025: , p5_a4 JTF_VARCHAR2_TABLE_100
1026: , p5_a5 JTF_VARCHAR2_TABLE_100
1027: , p5_a6 JTF_DATE_TABLE
1028: , p5_a7 JTF_DATE_TABLE
1045: , p5_a24 JTF_VARCHAR2_TABLE_500
1046: , p5_a25 JTF_VARCHAR2_TABLE_500
1047: , p5_a26 JTF_VARCHAR2_TABLE_500
1048: , p5_a27 JTF_VARCHAR2_TABLE_500
1049: , p5_a28 JTF_NUMBER_TABLE
1050: , p5_a29 JTF_NUMBER_TABLE
1051: , p5_a30 JTF_NUMBER_TABLE
1052: , p5_a31 JTF_DATE_TABLE
1053: , p5_a32 JTF_NUMBER_TABLE
1046: , p5_a25 JTF_VARCHAR2_TABLE_500
1047: , p5_a26 JTF_VARCHAR2_TABLE_500
1048: , p5_a27 JTF_VARCHAR2_TABLE_500
1049: , p5_a28 JTF_NUMBER_TABLE
1050: , p5_a29 JTF_NUMBER_TABLE
1051: , p5_a30 JTF_NUMBER_TABLE
1052: , p5_a31 JTF_DATE_TABLE
1053: , p5_a32 JTF_NUMBER_TABLE
1054: , p5_a33 JTF_DATE_TABLE
1047: , p5_a26 JTF_VARCHAR2_TABLE_500
1048: , p5_a27 JTF_VARCHAR2_TABLE_500
1049: , p5_a28 JTF_NUMBER_TABLE
1050: , p5_a29 JTF_NUMBER_TABLE
1051: , p5_a30 JTF_NUMBER_TABLE
1052: , p5_a31 JTF_DATE_TABLE
1053: , p5_a32 JTF_NUMBER_TABLE
1054: , p5_a33 JTF_DATE_TABLE
1055: , p5_a34 JTF_NUMBER_TABLE
1049: , p5_a28 JTF_NUMBER_TABLE
1050: , p5_a29 JTF_NUMBER_TABLE
1051: , p5_a30 JTF_NUMBER_TABLE
1052: , p5_a31 JTF_DATE_TABLE
1053: , p5_a32 JTF_NUMBER_TABLE
1054: , p5_a33 JTF_DATE_TABLE
1055: , p5_a34 JTF_NUMBER_TABLE
1056: , p5_a35 JTF_DATE_TABLE
1057: , p5_a36 JTF_NUMBER_TABLE
1051: , p5_a30 JTF_NUMBER_TABLE
1052: , p5_a31 JTF_DATE_TABLE
1053: , p5_a32 JTF_NUMBER_TABLE
1054: , p5_a33 JTF_DATE_TABLE
1055: , p5_a34 JTF_NUMBER_TABLE
1056: , p5_a35 JTF_DATE_TABLE
1057: , p5_a36 JTF_NUMBER_TABLE
1058: );
1059: end okl_vcr_pvt_w;
1053: , p5_a32 JTF_NUMBER_TABLE
1054: , p5_a33 JTF_DATE_TABLE
1055: , p5_a34 JTF_NUMBER_TABLE
1056: , p5_a35 JTF_DATE_TABLE
1057: , p5_a36 JTF_NUMBER_TABLE
1058: );
1059: end okl_vcr_pvt_w;