1: package okl_atl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIATLS.pls 115.5 2003/03/26 19:47:56 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_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_atl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIATLS.pls 115.5 2003/03/26 19:47:56 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_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_atl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIATLS.pls 115.5 2003/03/26 19:47:56 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_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_VARCHAR2_TABLE_100
2: /* $Header: OKLIATLS.pls 115.5 2003/03/26 19:47:56 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_atl_pvt.atl_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_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: );
36: procedure rosetta_table_copy_out_p2(t okl_atl_pvt.atl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_NUMBER_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_NUMBER_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_100
48: , a12 out nocopy JTF_VARCHAR2_TABLE_500
49: , a13 out nocopy JTF_VARCHAR2_TABLE_500
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a9 out nocopy JTF_NUMBER_TABLE
46: , a10 out nocopy JTF_NUMBER_TABLE
47: , a11 out nocopy JTF_VARCHAR2_TABLE_100
48: , a12 out nocopy JTF_VARCHAR2_TABLE_500
49: , a13 out nocopy JTF_VARCHAR2_TABLE_500
50: , a14 out nocopy JTF_VARCHAR2_TABLE_500
59: , a23 out nocopy JTF_VARCHAR2_TABLE_500
60: , a24 out nocopy JTF_VARCHAR2_TABLE_500
61: , a25 out nocopy JTF_VARCHAR2_TABLE_500
62: , a26 out nocopy JTF_VARCHAR2_TABLE_500
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
61: , a25 out nocopy JTF_VARCHAR2_TABLE_500
62: , a26 out nocopy JTF_VARCHAR2_TABLE_500
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_100
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_atl_pvt.atlv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_VARCHAR2_TABLE_2000
78: , a8 JTF_NUMBER_TABLE
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_VARCHAR2_TABLE_2000
78: , a8 JTF_NUMBER_TABLE
79: , a9 JTF_VARCHAR2_TABLE_100
80: , a10 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_NUMBER_TABLE
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_NUMBER_TABLE
77: , a7 JTF_VARCHAR2_TABLE_2000
78: , a8 JTF_NUMBER_TABLE
79: , a9 JTF_VARCHAR2_TABLE_100
80: , a10 JTF_VARCHAR2_TABLE_100
81: , a11 JTF_VARCHAR2_TABLE_500
82: , a12 JTF_VARCHAR2_TABLE_500
92: , a22 JTF_VARCHAR2_TABLE_500
93: , a23 JTF_VARCHAR2_TABLE_500
94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
93: , a23 JTF_VARCHAR2_TABLE_500
94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
102: , a32 JTF_NUMBER_TABLE
96: , a26 JTF_NUMBER_TABLE
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
102: , a32 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
102: , a32 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
100: , a30 JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
102: , a32 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
101: , a31 JTF_DATE_TABLE
102: , a32 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_VARCHAR2_TABLE_100
102: , a32 JTF_NUMBER_TABLE
103: );
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_VARCHAR2_TABLE_100
110: , a6 out nocopy JTF_NUMBER_TABLE
104: procedure rosetta_table_copy_out_p5(t okl_atl_pvt.atlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_VARCHAR2_TABLE_100
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a8 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_VARCHAR2_TABLE_100
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a8 out nocopy JTF_NUMBER_TABLE
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100
108: , a4 out nocopy JTF_NUMBER_TABLE
109: , a5 out nocopy JTF_VARCHAR2_TABLE_100
110: , a6 out nocopy JTF_NUMBER_TABLE
111: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a8 out nocopy JTF_NUMBER_TABLE
113: , a9 out nocopy JTF_VARCHAR2_TABLE_100
114: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a11 out nocopy JTF_VARCHAR2_TABLE_500
116: , a12 out nocopy JTF_VARCHAR2_TABLE_500
126: , a22 out nocopy JTF_VARCHAR2_TABLE_500
127: , a23 out nocopy JTF_VARCHAR2_TABLE_500
128: , a24 out nocopy JTF_VARCHAR2_TABLE_500
129: , a25 out nocopy JTF_VARCHAR2_TABLE_500
130: , a26 out nocopy JTF_NUMBER_TABLE
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_NUMBER_TABLE
133: , a29 out nocopy JTF_DATE_TABLE
134: , a30 out nocopy JTF_NUMBER_TABLE
127: , a23 out nocopy JTF_VARCHAR2_TABLE_500
128: , a24 out nocopy JTF_VARCHAR2_TABLE_500
129: , a25 out nocopy JTF_VARCHAR2_TABLE_500
130: , a26 out nocopy JTF_NUMBER_TABLE
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_NUMBER_TABLE
133: , a29 out nocopy JTF_DATE_TABLE
134: , a30 out nocopy JTF_NUMBER_TABLE
135: , a31 out nocopy JTF_DATE_TABLE
128: , a24 out nocopy JTF_VARCHAR2_TABLE_500
129: , a25 out nocopy JTF_VARCHAR2_TABLE_500
130: , a26 out nocopy JTF_NUMBER_TABLE
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_NUMBER_TABLE
133: , a29 out nocopy JTF_DATE_TABLE
134: , a30 out nocopy JTF_NUMBER_TABLE
135: , a31 out nocopy JTF_DATE_TABLE
136: , a32 out nocopy JTF_NUMBER_TABLE
130: , a26 out nocopy JTF_NUMBER_TABLE
131: , a27 out nocopy JTF_NUMBER_TABLE
132: , a28 out nocopy JTF_NUMBER_TABLE
133: , a29 out nocopy JTF_DATE_TABLE
134: , a30 out nocopy JTF_NUMBER_TABLE
135: , a31 out nocopy JTF_DATE_TABLE
136: , a32 out nocopy JTF_NUMBER_TABLE
137: );
138:
132: , a28 out nocopy JTF_NUMBER_TABLE
133: , a29 out nocopy JTF_DATE_TABLE
134: , a30 out nocopy JTF_NUMBER_TABLE
135: , a31 out nocopy JTF_DATE_TABLE
136: , a32 out nocopy JTF_NUMBER_TABLE
137: );
138:
139: procedure insert_row(p_api_version NUMBER
140: , p_init_msg_list VARCHAR2
212: , p_init_msg_list VARCHAR2
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2
216: , p5_a0 JTF_NUMBER_TABLE
217: , p5_a1 JTF_NUMBER_TABLE
218: , p5_a2 JTF_NUMBER_TABLE
219: , p5_a3 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2
216: , p5_a0 JTF_NUMBER_TABLE
217: , p5_a1 JTF_NUMBER_TABLE
218: , p5_a2 JTF_NUMBER_TABLE
219: , p5_a3 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_VARCHAR2_TABLE_100
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2
216: , p5_a0 JTF_NUMBER_TABLE
217: , p5_a1 JTF_NUMBER_TABLE
218: , p5_a2 JTF_NUMBER_TABLE
219: , p5_a3 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_VARCHAR2_TABLE_100
222: , p5_a6 JTF_NUMBER_TABLE
216: , p5_a0 JTF_NUMBER_TABLE
217: , p5_a1 JTF_NUMBER_TABLE
218: , p5_a2 JTF_NUMBER_TABLE
219: , p5_a3 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_VARCHAR2_TABLE_100
222: , p5_a6 JTF_NUMBER_TABLE
223: , p5_a7 JTF_VARCHAR2_TABLE_2000
224: , p5_a8 JTF_NUMBER_TABLE
218: , p5_a2 JTF_NUMBER_TABLE
219: , p5_a3 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_VARCHAR2_TABLE_100
222: , p5_a6 JTF_NUMBER_TABLE
223: , p5_a7 JTF_VARCHAR2_TABLE_2000
224: , p5_a8 JTF_NUMBER_TABLE
225: , p5_a9 JTF_VARCHAR2_TABLE_100
226: , p5_a10 JTF_VARCHAR2_TABLE_100
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_VARCHAR2_TABLE_100
222: , p5_a6 JTF_NUMBER_TABLE
223: , p5_a7 JTF_VARCHAR2_TABLE_2000
224: , p5_a8 JTF_NUMBER_TABLE
225: , p5_a9 JTF_VARCHAR2_TABLE_100
226: , p5_a10 JTF_VARCHAR2_TABLE_100
227: , p5_a11 JTF_VARCHAR2_TABLE_500
228: , p5_a12 JTF_VARCHAR2_TABLE_500
238: , p5_a22 JTF_VARCHAR2_TABLE_500
239: , p5_a23 JTF_VARCHAR2_TABLE_500
240: , p5_a24 JTF_VARCHAR2_TABLE_500
241: , p5_a25 JTF_VARCHAR2_TABLE_500
242: , p5_a26 JTF_NUMBER_TABLE
243: , p5_a27 JTF_NUMBER_TABLE
244: , p5_a28 JTF_NUMBER_TABLE
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
239: , p5_a23 JTF_VARCHAR2_TABLE_500
240: , p5_a24 JTF_VARCHAR2_TABLE_500
241: , p5_a25 JTF_VARCHAR2_TABLE_500
242: , p5_a26 JTF_NUMBER_TABLE
243: , p5_a27 JTF_NUMBER_TABLE
244: , p5_a28 JTF_NUMBER_TABLE
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
240: , p5_a24 JTF_VARCHAR2_TABLE_500
241: , p5_a25 JTF_VARCHAR2_TABLE_500
242: , p5_a26 JTF_NUMBER_TABLE
243: , p5_a27 JTF_NUMBER_TABLE
244: , p5_a28 JTF_NUMBER_TABLE
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
242: , p5_a26 JTF_NUMBER_TABLE
243: , p5_a27 JTF_NUMBER_TABLE
244: , p5_a28 JTF_NUMBER_TABLE
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p5_a28 JTF_NUMBER_TABLE
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
245: , p5_a29 JTF_DATE_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
246: , p5_a30 JTF_NUMBER_TABLE
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
247: , p5_a31 JTF_DATE_TABLE
248: , p5_a32 JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
249: , p6_a0 out nocopy JTF_NUMBER_TABLE
250: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a8 out nocopy JTF_NUMBER_TABLE
251: , p6_a2 out nocopy JTF_NUMBER_TABLE
252: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a8 out nocopy JTF_NUMBER_TABLE
258: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a4 out nocopy JTF_NUMBER_TABLE
254: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a6 out nocopy JTF_NUMBER_TABLE
256: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a8 out nocopy JTF_NUMBER_TABLE
258: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
261: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
272: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_NUMBER_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
272: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_NUMBER_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: , p6_a31 out nocopy JTF_DATE_TABLE
273: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_NUMBER_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: , p6_a31 out nocopy JTF_DATE_TABLE
281: , p6_a32 out nocopy JTF_NUMBER_TABLE
275: , p6_a26 out nocopy JTF_NUMBER_TABLE
276: , p6_a27 out nocopy JTF_NUMBER_TABLE
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: , p6_a31 out nocopy JTF_DATE_TABLE
281: , p6_a32 out nocopy JTF_NUMBER_TABLE
282: );
283: procedure lock_row(p_api_version NUMBER
277: , p6_a28 out nocopy JTF_NUMBER_TABLE
278: , p6_a29 out nocopy JTF_DATE_TABLE
279: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: , p6_a31 out nocopy JTF_DATE_TABLE
281: , p6_a32 out nocopy JTF_NUMBER_TABLE
282: );
283: procedure lock_row(p_api_version NUMBER
284: , p_init_msg_list VARCHAR2
285: , x_return_status out nocopy VARCHAR2
323: , p_init_msg_list VARCHAR2
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_NUMBER_TABLE
327: , p5_a0 JTF_NUMBER_TABLE
328: , p5_a1 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_NUMBER_TABLE
334: , p5_a7 JTF_VARCHAR2_TABLE_2000
335: , p5_a8 JTF_NUMBER_TABLE
329: , p5_a2 JTF_NUMBER_TABLE
330: , p5_a3 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_NUMBER_TABLE
334: , p5_a7 JTF_VARCHAR2_TABLE_2000
335: , p5_a8 JTF_NUMBER_TABLE
336: , p5_a9 JTF_VARCHAR2_TABLE_100
337: , p5_a10 JTF_VARCHAR2_TABLE_100
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_NUMBER_TABLE
334: , p5_a7 JTF_VARCHAR2_TABLE_2000
335: , p5_a8 JTF_NUMBER_TABLE
336: , p5_a9 JTF_VARCHAR2_TABLE_100
337: , p5_a10 JTF_VARCHAR2_TABLE_100
338: , p5_a11 JTF_VARCHAR2_TABLE_500
339: , p5_a12 JTF_VARCHAR2_TABLE_500
349: , p5_a22 JTF_VARCHAR2_TABLE_500
350: , p5_a23 JTF_VARCHAR2_TABLE_500
351: , p5_a24 JTF_VARCHAR2_TABLE_500
352: , p5_a25 JTF_VARCHAR2_TABLE_500
353: , p5_a26 JTF_NUMBER_TABLE
354: , p5_a27 JTF_NUMBER_TABLE
355: , p5_a28 JTF_NUMBER_TABLE
356: , p5_a29 JTF_DATE_TABLE
357: , p5_a30 JTF_NUMBER_TABLE
350: , p5_a23 JTF_VARCHAR2_TABLE_500
351: , p5_a24 JTF_VARCHAR2_TABLE_500
352: , p5_a25 JTF_VARCHAR2_TABLE_500
353: , p5_a26 JTF_NUMBER_TABLE
354: , p5_a27 JTF_NUMBER_TABLE
355: , p5_a28 JTF_NUMBER_TABLE
356: , p5_a29 JTF_DATE_TABLE
357: , p5_a30 JTF_NUMBER_TABLE
358: , p5_a31 JTF_DATE_TABLE
351: , p5_a24 JTF_VARCHAR2_TABLE_500
352: , p5_a25 JTF_VARCHAR2_TABLE_500
353: , p5_a26 JTF_NUMBER_TABLE
354: , p5_a27 JTF_NUMBER_TABLE
355: , p5_a28 JTF_NUMBER_TABLE
356: , p5_a29 JTF_DATE_TABLE
357: , p5_a30 JTF_NUMBER_TABLE
358: , p5_a31 JTF_DATE_TABLE
359: , p5_a32 JTF_NUMBER_TABLE
353: , p5_a26 JTF_NUMBER_TABLE
354: , p5_a27 JTF_NUMBER_TABLE
355: , p5_a28 JTF_NUMBER_TABLE
356: , p5_a29 JTF_DATE_TABLE
357: , p5_a30 JTF_NUMBER_TABLE
358: , p5_a31 JTF_DATE_TABLE
359: , p5_a32 JTF_NUMBER_TABLE
360: );
361: procedure update_row(p_api_version NUMBER
355: , p5_a28 JTF_NUMBER_TABLE
356: , p5_a29 JTF_DATE_TABLE
357: , p5_a30 JTF_NUMBER_TABLE
358: , p5_a31 JTF_DATE_TABLE
359: , p5_a32 JTF_NUMBER_TABLE
360: );
361: procedure update_row(p_api_version NUMBER
362: , p_init_msg_list VARCHAR2
363: , x_return_status out nocopy VARCHAR2
434: , p_init_msg_list VARCHAR2
435: , x_return_status out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER
437: , x_msg_data out nocopy VARCHAR2
438: , p5_a0 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_NUMBER_TABLE
441: , p5_a3 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
435: , x_return_status out nocopy VARCHAR2
436: , x_msg_count out nocopy NUMBER
437: , x_msg_data out nocopy VARCHAR2
438: , p5_a0 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_NUMBER_TABLE
441: , p5_a3 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
443: , p5_a5 JTF_VARCHAR2_TABLE_100
436: , x_msg_count out nocopy NUMBER
437: , x_msg_data out nocopy VARCHAR2
438: , p5_a0 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_NUMBER_TABLE
441: , p5_a3 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
443: , p5_a5 JTF_VARCHAR2_TABLE_100
444: , p5_a6 JTF_NUMBER_TABLE
438: , p5_a0 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_NUMBER_TABLE
441: , p5_a3 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
443: , p5_a5 JTF_VARCHAR2_TABLE_100
444: , p5_a6 JTF_NUMBER_TABLE
445: , p5_a7 JTF_VARCHAR2_TABLE_2000
446: , p5_a8 JTF_NUMBER_TABLE
440: , p5_a2 JTF_NUMBER_TABLE
441: , p5_a3 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
443: , p5_a5 JTF_VARCHAR2_TABLE_100
444: , p5_a6 JTF_NUMBER_TABLE
445: , p5_a7 JTF_VARCHAR2_TABLE_2000
446: , p5_a8 JTF_NUMBER_TABLE
447: , p5_a9 JTF_VARCHAR2_TABLE_100
448: , p5_a10 JTF_VARCHAR2_TABLE_100
442: , p5_a4 JTF_NUMBER_TABLE
443: , p5_a5 JTF_VARCHAR2_TABLE_100
444: , p5_a6 JTF_NUMBER_TABLE
445: , p5_a7 JTF_VARCHAR2_TABLE_2000
446: , p5_a8 JTF_NUMBER_TABLE
447: , p5_a9 JTF_VARCHAR2_TABLE_100
448: , p5_a10 JTF_VARCHAR2_TABLE_100
449: , p5_a11 JTF_VARCHAR2_TABLE_500
450: , p5_a12 JTF_VARCHAR2_TABLE_500
460: , p5_a22 JTF_VARCHAR2_TABLE_500
461: , p5_a23 JTF_VARCHAR2_TABLE_500
462: , p5_a24 JTF_VARCHAR2_TABLE_500
463: , p5_a25 JTF_VARCHAR2_TABLE_500
464: , p5_a26 JTF_NUMBER_TABLE
465: , p5_a27 JTF_NUMBER_TABLE
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
461: , p5_a23 JTF_VARCHAR2_TABLE_500
462: , p5_a24 JTF_VARCHAR2_TABLE_500
463: , p5_a25 JTF_VARCHAR2_TABLE_500
464: , p5_a26 JTF_NUMBER_TABLE
465: , p5_a27 JTF_NUMBER_TABLE
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
462: , p5_a24 JTF_VARCHAR2_TABLE_500
463: , p5_a25 JTF_VARCHAR2_TABLE_500
464: , p5_a26 JTF_NUMBER_TABLE
465: , p5_a27 JTF_NUMBER_TABLE
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
464: , p5_a26 JTF_NUMBER_TABLE
465: , p5_a27 JTF_NUMBER_TABLE
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
467: , p5_a29 JTF_DATE_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
476: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
476: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a6 out nocopy JTF_NUMBER_TABLE
471: , p6_a0 out nocopy JTF_NUMBER_TABLE
472: , p6_a1 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
476: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a6 out nocopy JTF_NUMBER_TABLE
478: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a8 out nocopy JTF_NUMBER_TABLE
473: , p6_a2 out nocopy JTF_NUMBER_TABLE
474: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
476: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a6 out nocopy JTF_NUMBER_TABLE
478: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a8 out nocopy JTF_NUMBER_TABLE
480: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
481: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a4 out nocopy JTF_NUMBER_TABLE
476: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a6 out nocopy JTF_NUMBER_TABLE
478: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a8 out nocopy JTF_NUMBER_TABLE
480: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
481: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
483: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
493: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
494: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
495: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
496: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
497: , p6_a26 out nocopy JTF_NUMBER_TABLE
498: , p6_a27 out nocopy JTF_NUMBER_TABLE
499: , p6_a28 out nocopy JTF_NUMBER_TABLE
500: , p6_a29 out nocopy JTF_DATE_TABLE
501: , p6_a30 out nocopy JTF_NUMBER_TABLE
494: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
495: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
496: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
497: , p6_a26 out nocopy JTF_NUMBER_TABLE
498: , p6_a27 out nocopy JTF_NUMBER_TABLE
499: , p6_a28 out nocopy JTF_NUMBER_TABLE
500: , p6_a29 out nocopy JTF_DATE_TABLE
501: , p6_a30 out nocopy JTF_NUMBER_TABLE
502: , p6_a31 out nocopy JTF_DATE_TABLE
495: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
496: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
497: , p6_a26 out nocopy JTF_NUMBER_TABLE
498: , p6_a27 out nocopy JTF_NUMBER_TABLE
499: , p6_a28 out nocopy JTF_NUMBER_TABLE
500: , p6_a29 out nocopy JTF_DATE_TABLE
501: , p6_a30 out nocopy JTF_NUMBER_TABLE
502: , p6_a31 out nocopy JTF_DATE_TABLE
503: , p6_a32 out nocopy JTF_NUMBER_TABLE
497: , p6_a26 out nocopy JTF_NUMBER_TABLE
498: , p6_a27 out nocopy JTF_NUMBER_TABLE
499: , p6_a28 out nocopy JTF_NUMBER_TABLE
500: , p6_a29 out nocopy JTF_DATE_TABLE
501: , p6_a30 out nocopy JTF_NUMBER_TABLE
502: , p6_a31 out nocopy JTF_DATE_TABLE
503: , p6_a32 out nocopy JTF_NUMBER_TABLE
504: );
505: procedure delete_row(p_api_version NUMBER
499: , p6_a28 out nocopy JTF_NUMBER_TABLE
500: , p6_a29 out nocopy JTF_DATE_TABLE
501: , p6_a30 out nocopy JTF_NUMBER_TABLE
502: , p6_a31 out nocopy JTF_DATE_TABLE
503: , p6_a32 out nocopy JTF_NUMBER_TABLE
504: );
505: procedure delete_row(p_api_version NUMBER
506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
545: , p_init_msg_list VARCHAR2
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
549: , p5_a0 JTF_NUMBER_TABLE
550: , p5_a1 JTF_NUMBER_TABLE
551: , p5_a2 JTF_NUMBER_TABLE
552: , p5_a3 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
546: , x_return_status out nocopy VARCHAR2
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
549: , p5_a0 JTF_NUMBER_TABLE
550: , p5_a1 JTF_NUMBER_TABLE
551: , p5_a2 JTF_NUMBER_TABLE
552: , p5_a3 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
554: , p5_a5 JTF_VARCHAR2_TABLE_100
547: , x_msg_count out nocopy NUMBER
548: , x_msg_data out nocopy VARCHAR2
549: , p5_a0 JTF_NUMBER_TABLE
550: , p5_a1 JTF_NUMBER_TABLE
551: , p5_a2 JTF_NUMBER_TABLE
552: , p5_a3 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
554: , p5_a5 JTF_VARCHAR2_TABLE_100
555: , p5_a6 JTF_NUMBER_TABLE
549: , p5_a0 JTF_NUMBER_TABLE
550: , p5_a1 JTF_NUMBER_TABLE
551: , p5_a2 JTF_NUMBER_TABLE
552: , p5_a3 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
554: , p5_a5 JTF_VARCHAR2_TABLE_100
555: , p5_a6 JTF_NUMBER_TABLE
556: , p5_a7 JTF_VARCHAR2_TABLE_2000
557: , p5_a8 JTF_NUMBER_TABLE
551: , p5_a2 JTF_NUMBER_TABLE
552: , p5_a3 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
554: , p5_a5 JTF_VARCHAR2_TABLE_100
555: , p5_a6 JTF_NUMBER_TABLE
556: , p5_a7 JTF_VARCHAR2_TABLE_2000
557: , p5_a8 JTF_NUMBER_TABLE
558: , p5_a9 JTF_VARCHAR2_TABLE_100
559: , p5_a10 JTF_VARCHAR2_TABLE_100
553: , p5_a4 JTF_NUMBER_TABLE
554: , p5_a5 JTF_VARCHAR2_TABLE_100
555: , p5_a6 JTF_NUMBER_TABLE
556: , p5_a7 JTF_VARCHAR2_TABLE_2000
557: , p5_a8 JTF_NUMBER_TABLE
558: , p5_a9 JTF_VARCHAR2_TABLE_100
559: , p5_a10 JTF_VARCHAR2_TABLE_100
560: , p5_a11 JTF_VARCHAR2_TABLE_500
561: , p5_a12 JTF_VARCHAR2_TABLE_500
571: , p5_a22 JTF_VARCHAR2_TABLE_500
572: , p5_a23 JTF_VARCHAR2_TABLE_500
573: , p5_a24 JTF_VARCHAR2_TABLE_500
574: , p5_a25 JTF_VARCHAR2_TABLE_500
575: , p5_a26 JTF_NUMBER_TABLE
576: , p5_a27 JTF_NUMBER_TABLE
577: , p5_a28 JTF_NUMBER_TABLE
578: , p5_a29 JTF_DATE_TABLE
579: , p5_a30 JTF_NUMBER_TABLE
572: , p5_a23 JTF_VARCHAR2_TABLE_500
573: , p5_a24 JTF_VARCHAR2_TABLE_500
574: , p5_a25 JTF_VARCHAR2_TABLE_500
575: , p5_a26 JTF_NUMBER_TABLE
576: , p5_a27 JTF_NUMBER_TABLE
577: , p5_a28 JTF_NUMBER_TABLE
578: , p5_a29 JTF_DATE_TABLE
579: , p5_a30 JTF_NUMBER_TABLE
580: , p5_a31 JTF_DATE_TABLE
573: , p5_a24 JTF_VARCHAR2_TABLE_500
574: , p5_a25 JTF_VARCHAR2_TABLE_500
575: , p5_a26 JTF_NUMBER_TABLE
576: , p5_a27 JTF_NUMBER_TABLE
577: , p5_a28 JTF_NUMBER_TABLE
578: , p5_a29 JTF_DATE_TABLE
579: , p5_a30 JTF_NUMBER_TABLE
580: , p5_a31 JTF_DATE_TABLE
581: , p5_a32 JTF_NUMBER_TABLE
575: , p5_a26 JTF_NUMBER_TABLE
576: , p5_a27 JTF_NUMBER_TABLE
577: , p5_a28 JTF_NUMBER_TABLE
578: , p5_a29 JTF_DATE_TABLE
579: , p5_a30 JTF_NUMBER_TABLE
580: , p5_a31 JTF_DATE_TABLE
581: , p5_a32 JTF_NUMBER_TABLE
582: );
583: procedure validate_row(p_api_version NUMBER
577: , p5_a28 JTF_NUMBER_TABLE
578: , p5_a29 JTF_DATE_TABLE
579: , p5_a30 JTF_NUMBER_TABLE
580: , p5_a31 JTF_DATE_TABLE
581: , p5_a32 JTF_NUMBER_TABLE
582: );
583: procedure validate_row(p_api_version NUMBER
584: , p_init_msg_list VARCHAR2
585: , x_return_status out nocopy VARCHAR2
623: , p_init_msg_list VARCHAR2
624: , x_return_status out nocopy VARCHAR2
625: , x_msg_count out nocopy NUMBER
626: , x_msg_data out nocopy VARCHAR2
627: , p5_a0 JTF_NUMBER_TABLE
628: , p5_a1 JTF_NUMBER_TABLE
629: , p5_a2 JTF_NUMBER_TABLE
630: , p5_a3 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
624: , x_return_status out nocopy VARCHAR2
625: , x_msg_count out nocopy NUMBER
626: , x_msg_data out nocopy VARCHAR2
627: , p5_a0 JTF_NUMBER_TABLE
628: , p5_a1 JTF_NUMBER_TABLE
629: , p5_a2 JTF_NUMBER_TABLE
630: , p5_a3 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_VARCHAR2_TABLE_100
625: , x_msg_count out nocopy NUMBER
626: , x_msg_data out nocopy VARCHAR2
627: , p5_a0 JTF_NUMBER_TABLE
628: , p5_a1 JTF_NUMBER_TABLE
629: , p5_a2 JTF_NUMBER_TABLE
630: , p5_a3 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_VARCHAR2_TABLE_100
633: , p5_a6 JTF_NUMBER_TABLE
627: , p5_a0 JTF_NUMBER_TABLE
628: , p5_a1 JTF_NUMBER_TABLE
629: , p5_a2 JTF_NUMBER_TABLE
630: , p5_a3 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_VARCHAR2_TABLE_100
633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_VARCHAR2_TABLE_2000
635: , p5_a8 JTF_NUMBER_TABLE
629: , p5_a2 JTF_NUMBER_TABLE
630: , p5_a3 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_VARCHAR2_TABLE_100
633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_VARCHAR2_TABLE_2000
635: , p5_a8 JTF_NUMBER_TABLE
636: , p5_a9 JTF_VARCHAR2_TABLE_100
637: , p5_a10 JTF_VARCHAR2_TABLE_100
631: , p5_a4 JTF_NUMBER_TABLE
632: , p5_a5 JTF_VARCHAR2_TABLE_100
633: , p5_a6 JTF_NUMBER_TABLE
634: , p5_a7 JTF_VARCHAR2_TABLE_2000
635: , p5_a8 JTF_NUMBER_TABLE
636: , p5_a9 JTF_VARCHAR2_TABLE_100
637: , p5_a10 JTF_VARCHAR2_TABLE_100
638: , p5_a11 JTF_VARCHAR2_TABLE_500
639: , p5_a12 JTF_VARCHAR2_TABLE_500
649: , p5_a22 JTF_VARCHAR2_TABLE_500
650: , p5_a23 JTF_VARCHAR2_TABLE_500
651: , p5_a24 JTF_VARCHAR2_TABLE_500
652: , p5_a25 JTF_VARCHAR2_TABLE_500
653: , p5_a26 JTF_NUMBER_TABLE
654: , p5_a27 JTF_NUMBER_TABLE
655: , p5_a28 JTF_NUMBER_TABLE
656: , p5_a29 JTF_DATE_TABLE
657: , p5_a30 JTF_NUMBER_TABLE
650: , p5_a23 JTF_VARCHAR2_TABLE_500
651: , p5_a24 JTF_VARCHAR2_TABLE_500
652: , p5_a25 JTF_VARCHAR2_TABLE_500
653: , p5_a26 JTF_NUMBER_TABLE
654: , p5_a27 JTF_NUMBER_TABLE
655: , p5_a28 JTF_NUMBER_TABLE
656: , p5_a29 JTF_DATE_TABLE
657: , p5_a30 JTF_NUMBER_TABLE
658: , p5_a31 JTF_DATE_TABLE
651: , p5_a24 JTF_VARCHAR2_TABLE_500
652: , p5_a25 JTF_VARCHAR2_TABLE_500
653: , p5_a26 JTF_NUMBER_TABLE
654: , p5_a27 JTF_NUMBER_TABLE
655: , p5_a28 JTF_NUMBER_TABLE
656: , p5_a29 JTF_DATE_TABLE
657: , p5_a30 JTF_NUMBER_TABLE
658: , p5_a31 JTF_DATE_TABLE
659: , p5_a32 JTF_NUMBER_TABLE
653: , p5_a26 JTF_NUMBER_TABLE
654: , p5_a27 JTF_NUMBER_TABLE
655: , p5_a28 JTF_NUMBER_TABLE
656: , p5_a29 JTF_DATE_TABLE
657: , p5_a30 JTF_NUMBER_TABLE
658: , p5_a31 JTF_DATE_TABLE
659: , p5_a32 JTF_NUMBER_TABLE
660: );
661: end okl_atl_pvt_w;
655: , p5_a28 JTF_NUMBER_TABLE
656: , p5_a29 JTF_DATE_TABLE
657: , p5_a30 JTF_NUMBER_TABLE
658: , p5_a31 JTF_DATE_TABLE
659: , p5_a32 JTF_NUMBER_TABLE
660: );
661: end okl_atl_pvt_w;