1: package okl_idi_pvt_w as
2: /* $Header: OKLIIDIS.pls 120.1 2005/07/13 09:26:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_idi_pvt_w as
2: /* $Header: OKLIIDIS.pls 120.1 2005/07/13 09:26:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
2: /* $Header: OKLIIDIS.pls 120.1 2005/07/13 09:26:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 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_VARCHAR2_TABLE_500
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_VARCHAR2_TABLE_500
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: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy 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: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
38: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
49: , a10 out nocopy JTF_DATE_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
49: , a10 out nocopy JTF_DATE_TABLE
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
49: , a10 out nocopy JTF_DATE_TABLE
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_DATE_TABLE
53: , a14 out nocopy JTF_VARCHAR2_TABLE_100
54: , a15 out nocopy JTF_VARCHAR2_TABLE_500
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
49: , a10 out nocopy JTF_DATE_TABLE
50: , a11 out nocopy JTF_NUMBER_TABLE
51: , a12 out nocopy JTF_NUMBER_TABLE
52: , a13 out nocopy JTF_DATE_TABLE
53: , a14 out nocopy JTF_VARCHAR2_TABLE_100
54: , a15 out nocopy JTF_VARCHAR2_TABLE_500
55: , a16 out nocopy JTF_VARCHAR2_TABLE_500
65: , a26 out nocopy JTF_VARCHAR2_TABLE_500
66: , a27 out nocopy JTF_VARCHAR2_TABLE_500
67: , a28 out nocopy JTF_VARCHAR2_TABLE_500
68: , a29 out nocopy JTF_VARCHAR2_TABLE_500
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_DATE_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_DATE_TABLE
73: , a34 out nocopy JTF_NUMBER_TABLE
67: , a28 out nocopy JTF_VARCHAR2_TABLE_500
68: , a29 out nocopy JTF_VARCHAR2_TABLE_500
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_DATE_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_DATE_TABLE
73: , a34 out nocopy JTF_NUMBER_TABLE
74: );
75:
69: , a30 out nocopy JTF_NUMBER_TABLE
70: , a31 out nocopy JTF_DATE_TABLE
71: , a32 out nocopy JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_DATE_TABLE
73: , a34 out nocopy JTF_NUMBER_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
72: , a33 out nocopy JTF_DATE_TABLE
73: , a34 out nocopy JTF_NUMBER_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
73: , a34 out nocopy JTF_NUMBER_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
83: , a7 JTF_NUMBER_TABLE
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
83: , a7 JTF_NUMBER_TABLE
84: , a8 JTF_DATE_TABLE
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
83: , a7 JTF_NUMBER_TABLE
84: , a8 JTF_DATE_TABLE
85: , a9 JTF_DATE_TABLE
86: , a10 JTF_VARCHAR2_TABLE_100
87: , a11 JTF_VARCHAR2_TABLE_500
98: , a22 JTF_VARCHAR2_TABLE_500
99: , a23 JTF_VARCHAR2_TABLE_500
100: , a24 JTF_VARCHAR2_TABLE_500
101: , a25 JTF_VARCHAR2_TABLE_500
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_NUMBER_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_DATE_TABLE
106: , a30 JTF_NUMBER_TABLE
99: , a23 JTF_VARCHAR2_TABLE_500
100: , a24 JTF_VARCHAR2_TABLE_500
101: , a25 JTF_VARCHAR2_TABLE_500
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_NUMBER_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_DATE_TABLE
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_DATE_TABLE
100: , a24 JTF_VARCHAR2_TABLE_500
101: , a25 JTF_VARCHAR2_TABLE_500
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_NUMBER_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_DATE_TABLE
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_DATE_TABLE
108: , a32 JTF_NUMBER_TABLE
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_NUMBER_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_DATE_TABLE
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_DATE_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_DATE_TABLE
110: , a34 JTF_NUMBER_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_DATE_TABLE
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_DATE_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_DATE_TABLE
110: , a34 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a30 JTF_NUMBER_TABLE
107: , a31 JTF_DATE_TABLE
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_DATE_TABLE
110: , a34 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
108: , a32 JTF_NUMBER_TABLE
109: , a33 JTF_DATE_TABLE
110: , a34 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
109: , a33 JTF_DATE_TABLE
110: , a34 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a7 out nocopy JTF_NUMBER_TABLE
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_DATE_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_DATE_TABLE
121: , a9 out nocopy JTF_DATE_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_500
134: , a22 out nocopy JTF_VARCHAR2_TABLE_500
135: , a23 out nocopy JTF_VARCHAR2_TABLE_500
136: , a24 out nocopy JTF_VARCHAR2_TABLE_500
137: , a25 out nocopy JTF_VARCHAR2_TABLE_500
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_NUMBER_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_DATE_TABLE
142: , a30 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_VARCHAR2_TABLE_500
136: , a24 out nocopy JTF_VARCHAR2_TABLE_500
137: , a25 out nocopy JTF_VARCHAR2_TABLE_500
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_NUMBER_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_DATE_TABLE
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_VARCHAR2_TABLE_500
137: , a25 out nocopy JTF_VARCHAR2_TABLE_500
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_NUMBER_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_DATE_TABLE
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_DATE_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_NUMBER_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_DATE_TABLE
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_DATE_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_DATE_TABLE
146: , a34 out nocopy JTF_NUMBER_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_DATE_TABLE
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_DATE_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_DATE_TABLE
146: , a34 out nocopy JTF_NUMBER_TABLE
147: );
148:
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_DATE_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_DATE_TABLE
146: , a34 out nocopy JTF_NUMBER_TABLE
147: );
148:
149: procedure insert_row(p_api_version NUMBER
150: , p_init_msg_list VARCHAR2
226: , p_init_msg_list VARCHAR2
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
227: , x_return_status out nocopy VARCHAR2
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
237: , p5_a7 JTF_NUMBER_TABLE
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_DATE_TABLE
240: , p5_a10 JTF_VARCHAR2_TABLE_100
241: , p5_a11 JTF_VARCHAR2_TABLE_500
252: , p5_a22 JTF_VARCHAR2_TABLE_500
253: , p5_a23 JTF_VARCHAR2_TABLE_500
254: , p5_a24 JTF_VARCHAR2_TABLE_500
255: , p5_a25 JTF_VARCHAR2_TABLE_500
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_DATE_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
253: , p5_a23 JTF_VARCHAR2_TABLE_500
254: , p5_a24 JTF_VARCHAR2_TABLE_500
255: , p5_a25 JTF_VARCHAR2_TABLE_500
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_DATE_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
254: , p5_a24 JTF_VARCHAR2_TABLE_500
255: , p5_a25 JTF_VARCHAR2_TABLE_500
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_DATE_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_DATE_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_DATE_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p5_a30 JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
261: , p5_a31 JTF_DATE_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
262: , p5_a32 JTF_NUMBER_TABLE
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p6_a7 out nocopy JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p6_a7 out nocopy JTF_NUMBER_TABLE
273: , p6_a8 out nocopy JTF_DATE_TABLE
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p6_a7 out nocopy JTF_NUMBER_TABLE
273: , p6_a8 out nocopy JTF_DATE_TABLE
274: , p6_a9 out nocopy JTF_DATE_TABLE
275: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
276: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
288: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_DATE_TABLE
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_DATE_TABLE
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_DATE_TABLE
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_DATE_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_DATE_TABLE
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_DATE_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_DATE_TABLE
299: , p6_a34 out nocopy JTF_NUMBER_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_DATE_TABLE
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_DATE_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_DATE_TABLE
299: , p6_a34 out nocopy JTF_NUMBER_TABLE
300: );
301: procedure lock_row(p_api_version NUMBER
295: , p6_a30 out nocopy JTF_NUMBER_TABLE
296: , p6_a31 out nocopy JTF_DATE_TABLE
297: , p6_a32 out nocopy JTF_NUMBER_TABLE
298: , p6_a33 out nocopy JTF_DATE_TABLE
299: , p6_a34 out nocopy JTF_NUMBER_TABLE
300: );
301: procedure lock_row(p_api_version NUMBER
302: , p_init_msg_list VARCHAR2
303: , x_return_status out nocopy VARCHAR2
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
344: , x_return_status out nocopy VARCHAR2
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
354: , p5_a7 JTF_NUMBER_TABLE
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
354: , p5_a7 JTF_NUMBER_TABLE
355: , p5_a8 JTF_DATE_TABLE
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
354: , p5_a7 JTF_NUMBER_TABLE
355: , p5_a8 JTF_DATE_TABLE
356: , p5_a9 JTF_DATE_TABLE
357: , p5_a10 JTF_VARCHAR2_TABLE_100
358: , p5_a11 JTF_VARCHAR2_TABLE_500
369: , p5_a22 JTF_VARCHAR2_TABLE_500
370: , p5_a23 JTF_VARCHAR2_TABLE_500
371: , p5_a24 JTF_VARCHAR2_TABLE_500
372: , p5_a25 JTF_VARCHAR2_TABLE_500
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_DATE_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
370: , p5_a23 JTF_VARCHAR2_TABLE_500
371: , p5_a24 JTF_VARCHAR2_TABLE_500
372: , p5_a25 JTF_VARCHAR2_TABLE_500
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_DATE_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_DATE_TABLE
371: , p5_a24 JTF_VARCHAR2_TABLE_500
372: , p5_a25 JTF_VARCHAR2_TABLE_500
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_DATE_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_DATE_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_DATE_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_DATE_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_DATE_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_DATE_TABLE
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_DATE_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_DATE_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
382: );
383: procedure update_row(p_api_version NUMBER
377: , p5_a30 JTF_NUMBER_TABLE
378: , p5_a31 JTF_DATE_TABLE
379: , p5_a32 JTF_NUMBER_TABLE
380: , p5_a33 JTF_DATE_TABLE
381: , p5_a34 JTF_NUMBER_TABLE
382: );
383: procedure update_row(p_api_version NUMBER
384: , p_init_msg_list VARCHAR2
385: , x_return_status out nocopy VARCHAR2
460: , p_init_msg_list VARCHAR2
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
461: , x_return_status out nocopy VARCHAR2
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
471: , p5_a7 JTF_NUMBER_TABLE
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_DATE_TABLE
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_DATE_TABLE
473: , p5_a9 JTF_DATE_TABLE
474: , p5_a10 JTF_VARCHAR2_TABLE_100
475: , p5_a11 JTF_VARCHAR2_TABLE_500
486: , p5_a22 JTF_VARCHAR2_TABLE_500
487: , p5_a23 JTF_VARCHAR2_TABLE_500
488: , p5_a24 JTF_VARCHAR2_TABLE_500
489: , p5_a25 JTF_VARCHAR2_TABLE_500
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_DATE_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
487: , p5_a23 JTF_VARCHAR2_TABLE_500
488: , p5_a24 JTF_VARCHAR2_TABLE_500
489: , p5_a25 JTF_VARCHAR2_TABLE_500
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_DATE_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
488: , p5_a24 JTF_VARCHAR2_TABLE_500
489: , p5_a25 JTF_VARCHAR2_TABLE_500
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_DATE_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_DATE_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_DATE_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
494: , p5_a30 JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p5_a31 JTF_DATE_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
496: , p5_a32 JTF_NUMBER_TABLE
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_DATE_TABLE
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_DATE_TABLE
508: , p6_a9 out nocopy JTF_DATE_TABLE
509: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
521: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
522: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
523: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_NUMBER_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_DATE_TABLE
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
523: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_NUMBER_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_DATE_TABLE
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_NUMBER_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_DATE_TABLE
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_DATE_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_NUMBER_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_DATE_TABLE
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_DATE_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_DATE_TABLE
533: , p6_a34 out nocopy JTF_NUMBER_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_DATE_TABLE
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_DATE_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_DATE_TABLE
533: , p6_a34 out nocopy JTF_NUMBER_TABLE
534: );
535: procedure delete_row(p_api_version NUMBER
529: , p6_a30 out nocopy JTF_NUMBER_TABLE
530: , p6_a31 out nocopy JTF_DATE_TABLE
531: , p6_a32 out nocopy JTF_NUMBER_TABLE
532: , p6_a33 out nocopy JTF_DATE_TABLE
533: , p6_a34 out nocopy JTF_NUMBER_TABLE
534: );
535: procedure delete_row(p_api_version NUMBER
536: , p_init_msg_list VARCHAR2
537: , x_return_status out nocopy VARCHAR2
577: , p_init_msg_list VARCHAR2
578: , x_return_status out nocopy VARCHAR2
579: , x_msg_count out nocopy NUMBER
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
578: , x_return_status out nocopy VARCHAR2
579: , x_msg_count out nocopy NUMBER
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
588: , p5_a7 JTF_NUMBER_TABLE
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_DATE_TABLE
591: , p5_a10 JTF_VARCHAR2_TABLE_100
592: , p5_a11 JTF_VARCHAR2_TABLE_500
603: , p5_a22 JTF_VARCHAR2_TABLE_500
604: , p5_a23 JTF_VARCHAR2_TABLE_500
605: , p5_a24 JTF_VARCHAR2_TABLE_500
606: , p5_a25 JTF_VARCHAR2_TABLE_500
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_NUMBER_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_DATE_TABLE
611: , p5_a30 JTF_NUMBER_TABLE
604: , p5_a23 JTF_VARCHAR2_TABLE_500
605: , p5_a24 JTF_VARCHAR2_TABLE_500
606: , p5_a25 JTF_VARCHAR2_TABLE_500
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_NUMBER_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_DATE_TABLE
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_DATE_TABLE
605: , p5_a24 JTF_VARCHAR2_TABLE_500
606: , p5_a25 JTF_VARCHAR2_TABLE_500
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_NUMBER_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_DATE_TABLE
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_DATE_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_NUMBER_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_DATE_TABLE
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_DATE_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_DATE_TABLE
615: , p5_a34 JTF_NUMBER_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_DATE_TABLE
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_DATE_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_DATE_TABLE
615: , p5_a34 JTF_NUMBER_TABLE
616: );
617: procedure validate_row(p_api_version NUMBER
611: , p5_a30 JTF_NUMBER_TABLE
612: , p5_a31 JTF_DATE_TABLE
613: , p5_a32 JTF_NUMBER_TABLE
614: , p5_a33 JTF_DATE_TABLE
615: , p5_a34 JTF_NUMBER_TABLE
616: );
617: procedure validate_row(p_api_version NUMBER
618: , p_init_msg_list VARCHAR2
619: , x_return_status out nocopy VARCHAR2
659: , p_init_msg_list VARCHAR2
660: , x_return_status out nocopy VARCHAR2
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
660: , x_return_status out nocopy VARCHAR2
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
670: , p5_a7 JTF_NUMBER_TABLE
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
670: , p5_a7 JTF_NUMBER_TABLE
671: , p5_a8 JTF_DATE_TABLE
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
670: , p5_a7 JTF_NUMBER_TABLE
671: , p5_a8 JTF_DATE_TABLE
672: , p5_a9 JTF_DATE_TABLE
673: , p5_a10 JTF_VARCHAR2_TABLE_100
674: , p5_a11 JTF_VARCHAR2_TABLE_500
685: , p5_a22 JTF_VARCHAR2_TABLE_500
686: , p5_a23 JTF_VARCHAR2_TABLE_500
687: , p5_a24 JTF_VARCHAR2_TABLE_500
688: , p5_a25 JTF_VARCHAR2_TABLE_500
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_NUMBER_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_DATE_TABLE
693: , p5_a30 JTF_NUMBER_TABLE
686: , p5_a23 JTF_VARCHAR2_TABLE_500
687: , p5_a24 JTF_VARCHAR2_TABLE_500
688: , p5_a25 JTF_VARCHAR2_TABLE_500
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_NUMBER_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_DATE_TABLE
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_DATE_TABLE
687: , p5_a24 JTF_VARCHAR2_TABLE_500
688: , p5_a25 JTF_VARCHAR2_TABLE_500
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_NUMBER_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_DATE_TABLE
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_DATE_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_NUMBER_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_DATE_TABLE
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_DATE_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_DATE_TABLE
697: , p5_a34 JTF_NUMBER_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_DATE_TABLE
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_DATE_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_DATE_TABLE
697: , p5_a34 JTF_NUMBER_TABLE
698: );
699: end okl_idi_pvt_w;
693: , p5_a30 JTF_NUMBER_TABLE
694: , p5_a31 JTF_DATE_TABLE
695: , p5_a32 JTF_NUMBER_TABLE
696: , p5_a33 JTF_DATE_TABLE
697: , p5_a34 JTF_NUMBER_TABLE
698: );
699: end okl_idi_pvt_w;