1: package okl_cat_pvt_w as
2: /* $Header: OKLECATS.pls 120.2 2005/10/30 04:05:04 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
1: package okl_cat_pvt_w as
2: /* $Header: OKLECATS.pls 120.2 2005/10/30 04:05:04 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cat_pvt.cat_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy 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_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_200
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_200
43: , a2 out nocopy JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_200
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a4 out nocopy JTF_DATE_TABLE
39: , a36 JTF_NUMBER_TABLE
40: );
41: procedure rosetta_table_copy_out_p2(t okl_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42: , a1 out nocopy JTF_VARCHAR2_TABLE_200
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a4 out nocopy JTF_DATE_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
43: , a2 out nocopy JTF_NUMBER_TABLE
44: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a4 out nocopy JTF_DATE_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
44: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a4 out nocopy JTF_DATE_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a4 out nocopy JTF_DATE_TABLE
46: , a5 out nocopy JTF_DATE_TABLE
47: , a6 out nocopy JTF_NUMBER_TABLE
48: , a7 out nocopy JTF_NUMBER_TABLE
49: , a8 out nocopy JTF_NUMBER_TABLE
50: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a10 out nocopy JTF_VARCHAR2_TABLE_100
52: , a11 out nocopy JTF_VARCHAR2_TABLE_100
53: , a12 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
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_NUMBER_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_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_NUMBER_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
76: , a35 out nocopy JTF_NUMBER_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_VARCHAR2_TABLE_2000
84: , a4 JTF_DATE_TABLE
77: , a36 out nocopy JTF_NUMBER_TABLE
78: );
79:
80: procedure rosetta_table_copy_in_p5(t out nocopy okl_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_NUMBER_TABLE
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_VARCHAR2_TABLE_2000
84: , a4 JTF_DATE_TABLE
85: , a5 JTF_DATE_TABLE
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_VARCHAR2_TABLE_2000
84: , a4 JTF_DATE_TABLE
85: , a5 JTF_DATE_TABLE
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_NUMBER_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_VARCHAR2_TABLE_100
90: , a10 JTF_VARCHAR2_TABLE_100
83: , a3 JTF_VARCHAR2_TABLE_2000
84: , a4 JTF_DATE_TABLE
85: , a5 JTF_DATE_TABLE
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_NUMBER_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_VARCHAR2_TABLE_100
90: , a10 JTF_VARCHAR2_TABLE_100
91: , a11 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_DATE_TABLE
85: , a5 JTF_DATE_TABLE
86: , a6 JTF_NUMBER_TABLE
87: , a7 JTF_NUMBER_TABLE
88: , a8 JTF_NUMBER_TABLE
89: , a9 JTF_VARCHAR2_TABLE_100
90: , a10 JTF_VARCHAR2_TABLE_100
91: , a11 JTF_VARCHAR2_TABLE_100
92: , a12 JTF_VARCHAR2_TABLE_100
105: , a25 JTF_VARCHAR2_TABLE_500
106: , a26 JTF_VARCHAR2_TABLE_500
107: , a27 JTF_VARCHAR2_TABLE_500
108: , a28 JTF_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy 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_NUMBER_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
112: , a32 JTF_NUMBER_TABLE
113: , a33 JTF_DATE_TABLE
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_NUMBER_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_VARCHAR2_TABLE_200
114: , a34 JTF_NUMBER_TABLE
115: , a35 JTF_NUMBER_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_VARCHAR2_TABLE_200
121: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a4 out nocopy JTF_DATE_TABLE
115: , a35 JTF_NUMBER_TABLE
116: , a36 JTF_NUMBER_TABLE
117: );
118: procedure rosetta_table_copy_out_p5(t okl_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_NUMBER_TABLE
120: , a2 out nocopy JTF_VARCHAR2_TABLE_200
121: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_DATE_TABLE
120: , a2 out nocopy JTF_VARCHAR2_TABLE_200
121: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_DATE_TABLE
124: , a6 out nocopy JTF_NUMBER_TABLE
125: , a7 out nocopy JTF_NUMBER_TABLE
126: , a8 out nocopy JTF_NUMBER_TABLE
127: , a9 out nocopy JTF_VARCHAR2_TABLE_100
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
121: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_DATE_TABLE
124: , a6 out nocopy JTF_NUMBER_TABLE
125: , a7 out nocopy JTF_NUMBER_TABLE
126: , a8 out nocopy JTF_NUMBER_TABLE
127: , a9 out nocopy JTF_VARCHAR2_TABLE_100
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , a11 out nocopy JTF_VARCHAR2_TABLE_100
122: , a4 out nocopy JTF_DATE_TABLE
123: , a5 out nocopy JTF_DATE_TABLE
124: , a6 out nocopy JTF_NUMBER_TABLE
125: , a7 out nocopy JTF_NUMBER_TABLE
126: , a8 out nocopy JTF_NUMBER_TABLE
127: , a9 out nocopy JTF_VARCHAR2_TABLE_100
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , a11 out nocopy JTF_VARCHAR2_TABLE_100
130: , a12 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
154: , a36 out nocopy JTF_NUMBER_TABLE
155: );
156:
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_NUMBER_TABLE
154: , a36 out nocopy JTF_NUMBER_TABLE
155: );
156:
157: procedure insert_row(p_api_version NUMBER
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_NUMBER_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_VARCHAR2_TABLE_200
245: , p5_a3 JTF_VARCHAR2_TABLE_2000
246: , p5_a4 JTF_DATE_TABLE
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_VARCHAR2_TABLE_200
245: , p5_a3 JTF_VARCHAR2_TABLE_2000
246: , p5_a4 JTF_DATE_TABLE
247: , p5_a5 JTF_DATE_TABLE
244: , p5_a2 JTF_VARCHAR2_TABLE_200
245: , p5_a3 JTF_VARCHAR2_TABLE_2000
246: , p5_a4 JTF_DATE_TABLE
247: , p5_a5 JTF_DATE_TABLE
248: , p5_a6 JTF_NUMBER_TABLE
249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_NUMBER_TABLE
251: , p5_a9 JTF_VARCHAR2_TABLE_100
252: , p5_a10 JTF_VARCHAR2_TABLE_100
245: , p5_a3 JTF_VARCHAR2_TABLE_2000
246: , p5_a4 JTF_DATE_TABLE
247: , p5_a5 JTF_DATE_TABLE
248: , p5_a6 JTF_NUMBER_TABLE
249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_NUMBER_TABLE
251: , p5_a9 JTF_VARCHAR2_TABLE_100
252: , p5_a10 JTF_VARCHAR2_TABLE_100
253: , p5_a11 JTF_VARCHAR2_TABLE_100
246: , p5_a4 JTF_DATE_TABLE
247: , p5_a5 JTF_DATE_TABLE
248: , p5_a6 JTF_NUMBER_TABLE
249: , p5_a7 JTF_NUMBER_TABLE
250: , p5_a8 JTF_NUMBER_TABLE
251: , p5_a9 JTF_VARCHAR2_TABLE_100
252: , p5_a10 JTF_VARCHAR2_TABLE_100
253: , p5_a11 JTF_VARCHAR2_TABLE_100
254: , p5_a12 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
278: , p5_a36 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy 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_NUMBER_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_VARCHAR2_TABLE_200
274: , p5_a32 JTF_NUMBER_TABLE
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_NUMBER_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_VARCHAR2_TABLE_200
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
275: , p5_a33 JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_NUMBER_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_VARCHAR2_TABLE_200
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_DATE_TABLE
276: , p5_a34 JTF_NUMBER_TABLE
277: , p5_a35 JTF_NUMBER_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_VARCHAR2_TABLE_200
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_DATE_TABLE
284: , p6_a5 out nocopy JTF_DATE_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_DATE_TABLE
284: , p6_a5 out nocopy JTF_DATE_TABLE
285: , p6_a6 out nocopy JTF_NUMBER_TABLE
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_NUMBER_TABLE
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_DATE_TABLE
284: , p6_a5 out nocopy JTF_DATE_TABLE
285: , p6_a6 out nocopy JTF_NUMBER_TABLE
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_NUMBER_TABLE
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a4 out nocopy JTF_DATE_TABLE
284: , p6_a5 out nocopy JTF_DATE_TABLE
285: , p6_a6 out nocopy JTF_NUMBER_TABLE
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_NUMBER_TABLE
288: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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_NUMBER_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_NUMBER_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: );
317: procedure lock_row(p_api_version NUMBER
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_NUMBER_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: );
317: procedure lock_row(p_api_version NUMBER
318: , p_init_msg_list VARCHAR2
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_NUMBER_TABLE
315: , p6_a36 out nocopy JTF_NUMBER_TABLE
316: );
317: procedure lock_row(p_api_version NUMBER
318: , p_init_msg_list VARCHAR2
319: , x_return_status out nocopy VARCHAR2
361: , p_init_msg_list VARCHAR2
362: , x_return_status out nocopy VARCHAR2
363: , x_msg_count out nocopy NUMBER
364: , x_msg_data out nocopy VARCHAR2
365: , p5_a0 JTF_NUMBER_TABLE
366: , p5_a1 JTF_NUMBER_TABLE
367: , p5_a2 JTF_VARCHAR2_TABLE_200
368: , p5_a3 JTF_VARCHAR2_TABLE_2000
369: , p5_a4 JTF_DATE_TABLE
362: , x_return_status out nocopy VARCHAR2
363: , x_msg_count out nocopy NUMBER
364: , x_msg_data out nocopy VARCHAR2
365: , p5_a0 JTF_NUMBER_TABLE
366: , p5_a1 JTF_NUMBER_TABLE
367: , p5_a2 JTF_VARCHAR2_TABLE_200
368: , p5_a3 JTF_VARCHAR2_TABLE_2000
369: , p5_a4 JTF_DATE_TABLE
370: , p5_a5 JTF_DATE_TABLE
367: , p5_a2 JTF_VARCHAR2_TABLE_200
368: , p5_a3 JTF_VARCHAR2_TABLE_2000
369: , p5_a4 JTF_DATE_TABLE
370: , p5_a5 JTF_DATE_TABLE
371: , p5_a6 JTF_NUMBER_TABLE
372: , p5_a7 JTF_NUMBER_TABLE
373: , p5_a8 JTF_NUMBER_TABLE
374: , p5_a9 JTF_VARCHAR2_TABLE_100
375: , p5_a10 JTF_VARCHAR2_TABLE_100
368: , p5_a3 JTF_VARCHAR2_TABLE_2000
369: , p5_a4 JTF_DATE_TABLE
370: , p5_a5 JTF_DATE_TABLE
371: , p5_a6 JTF_NUMBER_TABLE
372: , p5_a7 JTF_NUMBER_TABLE
373: , p5_a8 JTF_NUMBER_TABLE
374: , p5_a9 JTF_VARCHAR2_TABLE_100
375: , p5_a10 JTF_VARCHAR2_TABLE_100
376: , p5_a11 JTF_VARCHAR2_TABLE_100
369: , p5_a4 JTF_DATE_TABLE
370: , p5_a5 JTF_DATE_TABLE
371: , p5_a6 JTF_NUMBER_TABLE
372: , p5_a7 JTF_NUMBER_TABLE
373: , p5_a8 JTF_NUMBER_TABLE
374: , p5_a9 JTF_VARCHAR2_TABLE_100
375: , p5_a10 JTF_VARCHAR2_TABLE_100
376: , p5_a11 JTF_VARCHAR2_TABLE_100
377: , p5_a12 JTF_VARCHAR2_TABLE_100
390: , p5_a25 JTF_VARCHAR2_TABLE_500
391: , p5_a26 JTF_VARCHAR2_TABLE_500
392: , p5_a27 JTF_VARCHAR2_TABLE_500
393: , p5_a28 JTF_VARCHAR2_TABLE_500
394: , p5_a29 JTF_NUMBER_TABLE
395: , p5_a30 JTF_NUMBER_TABLE
396: , p5_a31 JTF_DATE_TABLE
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
391: , p5_a26 JTF_VARCHAR2_TABLE_500
392: , p5_a27 JTF_VARCHAR2_TABLE_500
393: , p5_a28 JTF_VARCHAR2_TABLE_500
394: , p5_a29 JTF_NUMBER_TABLE
395: , p5_a30 JTF_NUMBER_TABLE
396: , p5_a31 JTF_DATE_TABLE
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
399: , p5_a34 JTF_NUMBER_TABLE
393: , p5_a28 JTF_VARCHAR2_TABLE_500
394: , p5_a29 JTF_NUMBER_TABLE
395: , p5_a30 JTF_NUMBER_TABLE
396: , p5_a31 JTF_DATE_TABLE
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
399: , p5_a34 JTF_NUMBER_TABLE
400: , p5_a35 JTF_NUMBER_TABLE
401: , p5_a36 JTF_NUMBER_TABLE
395: , p5_a30 JTF_NUMBER_TABLE
396: , p5_a31 JTF_DATE_TABLE
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
399: , p5_a34 JTF_NUMBER_TABLE
400: , p5_a35 JTF_NUMBER_TABLE
401: , p5_a36 JTF_NUMBER_TABLE
402: );
403: procedure update_row(p_api_version NUMBER
396: , p5_a31 JTF_DATE_TABLE
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
399: , p5_a34 JTF_NUMBER_TABLE
400: , p5_a35 JTF_NUMBER_TABLE
401: , p5_a36 JTF_NUMBER_TABLE
402: );
403: procedure update_row(p_api_version NUMBER
404: , p_init_msg_list VARCHAR2
397: , p5_a32 JTF_NUMBER_TABLE
398: , p5_a33 JTF_DATE_TABLE
399: , p5_a34 JTF_NUMBER_TABLE
400: , p5_a35 JTF_NUMBER_TABLE
401: , p5_a36 JTF_NUMBER_TABLE
402: );
403: procedure update_row(p_api_version NUMBER
404: , p_init_msg_list VARCHAR2
405: , x_return_status out nocopy VARCHAR2
484: , p_init_msg_list VARCHAR2
485: , x_return_status out nocopy VARCHAR2
486: , x_msg_count out nocopy NUMBER
487: , x_msg_data out nocopy VARCHAR2
488: , p5_a0 JTF_NUMBER_TABLE
489: , p5_a1 JTF_NUMBER_TABLE
490: , p5_a2 JTF_VARCHAR2_TABLE_200
491: , p5_a3 JTF_VARCHAR2_TABLE_2000
492: , p5_a4 JTF_DATE_TABLE
485: , x_return_status out nocopy VARCHAR2
486: , x_msg_count out nocopy NUMBER
487: , x_msg_data out nocopy VARCHAR2
488: , p5_a0 JTF_NUMBER_TABLE
489: , p5_a1 JTF_NUMBER_TABLE
490: , p5_a2 JTF_VARCHAR2_TABLE_200
491: , p5_a3 JTF_VARCHAR2_TABLE_2000
492: , p5_a4 JTF_DATE_TABLE
493: , p5_a5 JTF_DATE_TABLE
490: , p5_a2 JTF_VARCHAR2_TABLE_200
491: , p5_a3 JTF_VARCHAR2_TABLE_2000
492: , p5_a4 JTF_DATE_TABLE
493: , p5_a5 JTF_DATE_TABLE
494: , p5_a6 JTF_NUMBER_TABLE
495: , p5_a7 JTF_NUMBER_TABLE
496: , p5_a8 JTF_NUMBER_TABLE
497: , p5_a9 JTF_VARCHAR2_TABLE_100
498: , p5_a10 JTF_VARCHAR2_TABLE_100
491: , p5_a3 JTF_VARCHAR2_TABLE_2000
492: , p5_a4 JTF_DATE_TABLE
493: , p5_a5 JTF_DATE_TABLE
494: , p5_a6 JTF_NUMBER_TABLE
495: , p5_a7 JTF_NUMBER_TABLE
496: , p5_a8 JTF_NUMBER_TABLE
497: , p5_a9 JTF_VARCHAR2_TABLE_100
498: , p5_a10 JTF_VARCHAR2_TABLE_100
499: , p5_a11 JTF_VARCHAR2_TABLE_100
492: , p5_a4 JTF_DATE_TABLE
493: , p5_a5 JTF_DATE_TABLE
494: , p5_a6 JTF_NUMBER_TABLE
495: , p5_a7 JTF_NUMBER_TABLE
496: , p5_a8 JTF_NUMBER_TABLE
497: , p5_a9 JTF_VARCHAR2_TABLE_100
498: , p5_a10 JTF_VARCHAR2_TABLE_100
499: , p5_a11 JTF_VARCHAR2_TABLE_100
500: , p5_a12 JTF_VARCHAR2_TABLE_100
513: , p5_a25 JTF_VARCHAR2_TABLE_500
514: , p5_a26 JTF_VARCHAR2_TABLE_500
515: , p5_a27 JTF_VARCHAR2_TABLE_500
516: , p5_a28 JTF_VARCHAR2_TABLE_500
517: , p5_a29 JTF_NUMBER_TABLE
518: , p5_a30 JTF_NUMBER_TABLE
519: , p5_a31 JTF_DATE_TABLE
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
514: , p5_a26 JTF_VARCHAR2_TABLE_500
515: , p5_a27 JTF_VARCHAR2_TABLE_500
516: , p5_a28 JTF_VARCHAR2_TABLE_500
517: , p5_a29 JTF_NUMBER_TABLE
518: , p5_a30 JTF_NUMBER_TABLE
519: , p5_a31 JTF_DATE_TABLE
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
516: , p5_a28 JTF_VARCHAR2_TABLE_500
517: , p5_a29 JTF_NUMBER_TABLE
518: , p5_a30 JTF_NUMBER_TABLE
519: , p5_a31 JTF_DATE_TABLE
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
518: , p5_a30 JTF_NUMBER_TABLE
519: , p5_a31 JTF_DATE_TABLE
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
525: , p6_a0 out nocopy JTF_NUMBER_TABLE
526: , p6_a1 out nocopy JTF_NUMBER_TABLE
519: , p5_a31 JTF_DATE_TABLE
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
525: , p6_a0 out nocopy JTF_NUMBER_TABLE
526: , p6_a1 out nocopy JTF_NUMBER_TABLE
527: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
520: , p5_a32 JTF_NUMBER_TABLE
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
525: , p6_a0 out nocopy JTF_NUMBER_TABLE
526: , p6_a1 out nocopy JTF_NUMBER_TABLE
527: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
528: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
521: , p5_a33 JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
525: , p6_a0 out nocopy JTF_NUMBER_TABLE
526: , p6_a1 out nocopy JTF_NUMBER_TABLE
527: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
528: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 out nocopy JTF_DATE_TABLE
522: , p5_a34 JTF_NUMBER_TABLE
523: , p5_a35 JTF_NUMBER_TABLE
524: , p5_a36 JTF_NUMBER_TABLE
525: , p6_a0 out nocopy JTF_NUMBER_TABLE
526: , p6_a1 out nocopy JTF_NUMBER_TABLE
527: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
528: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 out nocopy JTF_DATE_TABLE
530: , p6_a5 out nocopy JTF_DATE_TABLE
527: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
528: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 out nocopy JTF_DATE_TABLE
530: , p6_a5 out nocopy JTF_DATE_TABLE
531: , p6_a6 out nocopy JTF_NUMBER_TABLE
532: , p6_a7 out nocopy JTF_NUMBER_TABLE
533: , p6_a8 out nocopy JTF_NUMBER_TABLE
534: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
535: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
529: , p6_a4 out nocopy JTF_DATE_TABLE
530: , p6_a5 out nocopy JTF_DATE_TABLE
531: , p6_a6 out nocopy JTF_NUMBER_TABLE
532: , p6_a7 out nocopy JTF_NUMBER_TABLE
533: , p6_a8 out nocopy JTF_NUMBER_TABLE
534: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
535: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
536: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a4 out nocopy JTF_DATE_TABLE
530: , p6_a5 out nocopy JTF_DATE_TABLE
531: , p6_a6 out nocopy JTF_NUMBER_TABLE
532: , p6_a7 out nocopy JTF_NUMBER_TABLE
533: , p6_a8 out nocopy JTF_NUMBER_TABLE
534: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
535: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
536: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
537: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
551: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
552: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
553: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
554: , p6_a29 out nocopy JTF_NUMBER_TABLE
555: , p6_a30 out nocopy JTF_NUMBER_TABLE
556: , p6_a31 out nocopy JTF_DATE_TABLE
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
551: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
552: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
553: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
554: , p6_a29 out nocopy JTF_NUMBER_TABLE
555: , p6_a30 out nocopy JTF_NUMBER_TABLE
556: , p6_a31 out nocopy JTF_DATE_TABLE
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
559: , p6_a34 out nocopy JTF_NUMBER_TABLE
553: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
554: , p6_a29 out nocopy JTF_NUMBER_TABLE
555: , p6_a30 out nocopy JTF_NUMBER_TABLE
556: , p6_a31 out nocopy JTF_DATE_TABLE
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
559: , p6_a34 out nocopy JTF_NUMBER_TABLE
560: , p6_a35 out nocopy JTF_NUMBER_TABLE
561: , p6_a36 out nocopy JTF_NUMBER_TABLE
555: , p6_a30 out nocopy JTF_NUMBER_TABLE
556: , p6_a31 out nocopy JTF_DATE_TABLE
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
559: , p6_a34 out nocopy JTF_NUMBER_TABLE
560: , p6_a35 out nocopy JTF_NUMBER_TABLE
561: , p6_a36 out nocopy JTF_NUMBER_TABLE
562: );
563: procedure delete_row(p_api_version NUMBER
556: , p6_a31 out nocopy JTF_DATE_TABLE
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
559: , p6_a34 out nocopy JTF_NUMBER_TABLE
560: , p6_a35 out nocopy JTF_NUMBER_TABLE
561: , p6_a36 out nocopy JTF_NUMBER_TABLE
562: );
563: procedure delete_row(p_api_version NUMBER
564: , p_init_msg_list VARCHAR2
557: , p6_a32 out nocopy JTF_NUMBER_TABLE
558: , p6_a33 out nocopy JTF_DATE_TABLE
559: , p6_a34 out nocopy JTF_NUMBER_TABLE
560: , p6_a35 out nocopy JTF_NUMBER_TABLE
561: , p6_a36 out nocopy JTF_NUMBER_TABLE
562: );
563: procedure delete_row(p_api_version NUMBER
564: , p_init_msg_list VARCHAR2
565: , x_return_status out nocopy VARCHAR2
607: , p_init_msg_list VARCHAR2
608: , x_return_status out nocopy VARCHAR2
609: , x_msg_count out nocopy NUMBER
610: , x_msg_data out nocopy VARCHAR2
611: , p5_a0 JTF_NUMBER_TABLE
612: , p5_a1 JTF_NUMBER_TABLE
613: , p5_a2 JTF_VARCHAR2_TABLE_200
614: , p5_a3 JTF_VARCHAR2_TABLE_2000
615: , p5_a4 JTF_DATE_TABLE
608: , x_return_status out nocopy VARCHAR2
609: , x_msg_count out nocopy NUMBER
610: , x_msg_data out nocopy VARCHAR2
611: , p5_a0 JTF_NUMBER_TABLE
612: , p5_a1 JTF_NUMBER_TABLE
613: , p5_a2 JTF_VARCHAR2_TABLE_200
614: , p5_a3 JTF_VARCHAR2_TABLE_2000
615: , p5_a4 JTF_DATE_TABLE
616: , p5_a5 JTF_DATE_TABLE
613: , p5_a2 JTF_VARCHAR2_TABLE_200
614: , p5_a3 JTF_VARCHAR2_TABLE_2000
615: , p5_a4 JTF_DATE_TABLE
616: , p5_a5 JTF_DATE_TABLE
617: , p5_a6 JTF_NUMBER_TABLE
618: , p5_a7 JTF_NUMBER_TABLE
619: , p5_a8 JTF_NUMBER_TABLE
620: , p5_a9 JTF_VARCHAR2_TABLE_100
621: , p5_a10 JTF_VARCHAR2_TABLE_100
614: , p5_a3 JTF_VARCHAR2_TABLE_2000
615: , p5_a4 JTF_DATE_TABLE
616: , p5_a5 JTF_DATE_TABLE
617: , p5_a6 JTF_NUMBER_TABLE
618: , p5_a7 JTF_NUMBER_TABLE
619: , p5_a8 JTF_NUMBER_TABLE
620: , p5_a9 JTF_VARCHAR2_TABLE_100
621: , p5_a10 JTF_VARCHAR2_TABLE_100
622: , p5_a11 JTF_VARCHAR2_TABLE_100
615: , p5_a4 JTF_DATE_TABLE
616: , p5_a5 JTF_DATE_TABLE
617: , p5_a6 JTF_NUMBER_TABLE
618: , p5_a7 JTF_NUMBER_TABLE
619: , p5_a8 JTF_NUMBER_TABLE
620: , p5_a9 JTF_VARCHAR2_TABLE_100
621: , p5_a10 JTF_VARCHAR2_TABLE_100
622: , p5_a11 JTF_VARCHAR2_TABLE_100
623: , p5_a12 JTF_VARCHAR2_TABLE_100
636: , p5_a25 JTF_VARCHAR2_TABLE_500
637: , p5_a26 JTF_VARCHAR2_TABLE_500
638: , p5_a27 JTF_VARCHAR2_TABLE_500
639: , p5_a28 JTF_VARCHAR2_TABLE_500
640: , p5_a29 JTF_NUMBER_TABLE
641: , p5_a30 JTF_NUMBER_TABLE
642: , p5_a31 JTF_DATE_TABLE
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
637: , p5_a26 JTF_VARCHAR2_TABLE_500
638: , p5_a27 JTF_VARCHAR2_TABLE_500
639: , p5_a28 JTF_VARCHAR2_TABLE_500
640: , p5_a29 JTF_NUMBER_TABLE
641: , p5_a30 JTF_NUMBER_TABLE
642: , p5_a31 JTF_DATE_TABLE
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
645: , p5_a34 JTF_NUMBER_TABLE
639: , p5_a28 JTF_VARCHAR2_TABLE_500
640: , p5_a29 JTF_NUMBER_TABLE
641: , p5_a30 JTF_NUMBER_TABLE
642: , p5_a31 JTF_DATE_TABLE
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
645: , p5_a34 JTF_NUMBER_TABLE
646: , p5_a35 JTF_NUMBER_TABLE
647: , p5_a36 JTF_NUMBER_TABLE
641: , p5_a30 JTF_NUMBER_TABLE
642: , p5_a31 JTF_DATE_TABLE
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
645: , p5_a34 JTF_NUMBER_TABLE
646: , p5_a35 JTF_NUMBER_TABLE
647: , p5_a36 JTF_NUMBER_TABLE
648: );
649: procedure validate_row(p_api_version NUMBER
642: , p5_a31 JTF_DATE_TABLE
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
645: , p5_a34 JTF_NUMBER_TABLE
646: , p5_a35 JTF_NUMBER_TABLE
647: , p5_a36 JTF_NUMBER_TABLE
648: );
649: procedure validate_row(p_api_version NUMBER
650: , p_init_msg_list VARCHAR2
643: , p5_a32 JTF_NUMBER_TABLE
644: , p5_a33 JTF_DATE_TABLE
645: , p5_a34 JTF_NUMBER_TABLE
646: , p5_a35 JTF_NUMBER_TABLE
647: , p5_a36 JTF_NUMBER_TABLE
648: );
649: procedure validate_row(p_api_version NUMBER
650: , p_init_msg_list VARCHAR2
651: , x_return_status out nocopy VARCHAR2
693: , p_init_msg_list VARCHAR2
694: , x_return_status out nocopy VARCHAR2
695: , x_msg_count out nocopy NUMBER
696: , x_msg_data out nocopy VARCHAR2
697: , p5_a0 JTF_NUMBER_TABLE
698: , p5_a1 JTF_NUMBER_TABLE
699: , p5_a2 JTF_VARCHAR2_TABLE_200
700: , p5_a3 JTF_VARCHAR2_TABLE_2000
701: , p5_a4 JTF_DATE_TABLE
694: , x_return_status out nocopy VARCHAR2
695: , x_msg_count out nocopy NUMBER
696: , x_msg_data out nocopy VARCHAR2
697: , p5_a0 JTF_NUMBER_TABLE
698: , p5_a1 JTF_NUMBER_TABLE
699: , p5_a2 JTF_VARCHAR2_TABLE_200
700: , p5_a3 JTF_VARCHAR2_TABLE_2000
701: , p5_a4 JTF_DATE_TABLE
702: , p5_a5 JTF_DATE_TABLE
699: , p5_a2 JTF_VARCHAR2_TABLE_200
700: , p5_a3 JTF_VARCHAR2_TABLE_2000
701: , p5_a4 JTF_DATE_TABLE
702: , p5_a5 JTF_DATE_TABLE
703: , p5_a6 JTF_NUMBER_TABLE
704: , p5_a7 JTF_NUMBER_TABLE
705: , p5_a8 JTF_NUMBER_TABLE
706: , p5_a9 JTF_VARCHAR2_TABLE_100
707: , p5_a10 JTF_VARCHAR2_TABLE_100
700: , p5_a3 JTF_VARCHAR2_TABLE_2000
701: , p5_a4 JTF_DATE_TABLE
702: , p5_a5 JTF_DATE_TABLE
703: , p5_a6 JTF_NUMBER_TABLE
704: , p5_a7 JTF_NUMBER_TABLE
705: , p5_a8 JTF_NUMBER_TABLE
706: , p5_a9 JTF_VARCHAR2_TABLE_100
707: , p5_a10 JTF_VARCHAR2_TABLE_100
708: , p5_a11 JTF_VARCHAR2_TABLE_100
701: , p5_a4 JTF_DATE_TABLE
702: , p5_a5 JTF_DATE_TABLE
703: , p5_a6 JTF_NUMBER_TABLE
704: , p5_a7 JTF_NUMBER_TABLE
705: , p5_a8 JTF_NUMBER_TABLE
706: , p5_a9 JTF_VARCHAR2_TABLE_100
707: , p5_a10 JTF_VARCHAR2_TABLE_100
708: , p5_a11 JTF_VARCHAR2_TABLE_100
709: , p5_a12 JTF_VARCHAR2_TABLE_100
722: , p5_a25 JTF_VARCHAR2_TABLE_500
723: , p5_a26 JTF_VARCHAR2_TABLE_500
724: , p5_a27 JTF_VARCHAR2_TABLE_500
725: , p5_a28 JTF_VARCHAR2_TABLE_500
726: , p5_a29 JTF_NUMBER_TABLE
727: , p5_a30 JTF_NUMBER_TABLE
728: , p5_a31 JTF_DATE_TABLE
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
723: , p5_a26 JTF_VARCHAR2_TABLE_500
724: , p5_a27 JTF_VARCHAR2_TABLE_500
725: , p5_a28 JTF_VARCHAR2_TABLE_500
726: , p5_a29 JTF_NUMBER_TABLE
727: , p5_a30 JTF_NUMBER_TABLE
728: , p5_a31 JTF_DATE_TABLE
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
731: , p5_a34 JTF_NUMBER_TABLE
725: , p5_a28 JTF_VARCHAR2_TABLE_500
726: , p5_a29 JTF_NUMBER_TABLE
727: , p5_a30 JTF_NUMBER_TABLE
728: , p5_a31 JTF_DATE_TABLE
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
731: , p5_a34 JTF_NUMBER_TABLE
732: , p5_a35 JTF_NUMBER_TABLE
733: , p5_a36 JTF_NUMBER_TABLE
727: , p5_a30 JTF_NUMBER_TABLE
728: , p5_a31 JTF_DATE_TABLE
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
731: , p5_a34 JTF_NUMBER_TABLE
732: , p5_a35 JTF_NUMBER_TABLE
733: , p5_a36 JTF_NUMBER_TABLE
734: );
735: end okl_cat_pvt_w;
728: , p5_a31 JTF_DATE_TABLE
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
731: , p5_a34 JTF_NUMBER_TABLE
732: , p5_a35 JTF_NUMBER_TABLE
733: , p5_a36 JTF_NUMBER_TABLE
734: );
735: end okl_cat_pvt_w;
729: , p5_a32 JTF_NUMBER_TABLE
730: , p5_a33 JTF_DATE_TABLE
731: , p5_a34 JTF_NUMBER_TABLE
732: , p5_a35 JTF_NUMBER_TABLE
733: , p5_a36 JTF_NUMBER_TABLE
734: );
735: end okl_cat_pvt_w;