1: package okl_gtp_pvt_w as
2: /* $Header: OKLIGTPS.pls 120.1 2005/10/30 04:00:48 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_gtp_pvt_w as
2: /* $Header: OKLIGTPS.pls 120.1 2005/10/30 04:00:48 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtp_pvt.gtp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_VARCHAR2_TABLE_200
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_VARCHAR2_TABLE_200
22: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_gtp_pvt.gtp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_VARCHAR2_TABLE_200
22: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_500
26: , a7 out nocopy JTF_VARCHAR2_TABLE_500
27: , a8 out nocopy JTF_NUMBER_TABLE
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_500
26: , a7 out nocopy JTF_VARCHAR2_TABLE_500
27: , a8 out nocopy JTF_NUMBER_TABLE
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_VARCHAR2_TABLE_500
27: , a8 out nocopy JTF_NUMBER_TABLE
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_NUMBER_TABLE
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_NUMBER_TABLE
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_NUMBER_TABLE
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_NUMBER_TABLE
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
38: , a2 JTF_VARCHAR2_TABLE_200
39: , a3 JTF_VARCHAR2_TABLE_2000
40: , a4 JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtp_pvt.gtpv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
38: , a2 JTF_VARCHAR2_TABLE_200
39: , a3 JTF_VARCHAR2_TABLE_2000
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_500
43: , a7 JTF_VARCHAR2_TABLE_500
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_NUMBER_TABLE
46: , a10 JTF_DATE_TABLE
47: , a11 JTF_NUMBER_TABLE
48: , a12 JTF_DATE_TABLE
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_500
43: , a7 JTF_VARCHAR2_TABLE_500
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_NUMBER_TABLE
46: , a10 JTF_DATE_TABLE
47: , a11 JTF_NUMBER_TABLE
48: , a12 JTF_DATE_TABLE
49: , a13 JTF_NUMBER_TABLE
43: , a7 JTF_VARCHAR2_TABLE_500
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_NUMBER_TABLE
46: , a10 JTF_DATE_TABLE
47: , a11 JTF_NUMBER_TABLE
48: , a12 JTF_DATE_TABLE
49: , a13 JTF_NUMBER_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
45: , a9 JTF_NUMBER_TABLE
46: , a10 JTF_DATE_TABLE
47: , a11 JTF_NUMBER_TABLE
48: , a12 JTF_DATE_TABLE
49: , a13 JTF_NUMBER_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
46: , a10 JTF_DATE_TABLE
47: , a11 JTF_NUMBER_TABLE
48: , a12 JTF_DATE_TABLE
49: , a13 JTF_NUMBER_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_200
48: , a12 JTF_DATE_TABLE
49: , a13 JTF_NUMBER_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_200
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a13 JTF_NUMBER_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_gtp_pvt.gtpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_200
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_500
59: , a7 out nocopy JTF_VARCHAR2_TABLE_500
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_DATE_TABLE
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_DATE_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_500
59: , a7 out nocopy JTF_VARCHAR2_TABLE_500
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_DATE_TABLE
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_DATE_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
59: , a7 out nocopy JTF_VARCHAR2_TABLE_500
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_DATE_TABLE
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_DATE_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: );
61: , a9 out nocopy JTF_NUMBER_TABLE
62: , a10 out nocopy JTF_DATE_TABLE
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_DATE_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: );
68:
69: procedure insert_row(p_api_version NUMBER
62: , a10 out nocopy JTF_DATE_TABLE
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_DATE_TABLE
65: , a13 out nocopy JTF_NUMBER_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: );
68:
69: procedure insert_row(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2
106: , p_init_msg_list VARCHAR2
107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_NUMBER_TABLE
112: , p5_a2 JTF_VARCHAR2_TABLE_200
113: , p5_a3 JTF_VARCHAR2_TABLE_2000
114: , p5_a4 JTF_VARCHAR2_TABLE_100
107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_NUMBER_TABLE
112: , p5_a2 JTF_VARCHAR2_TABLE_200
113: , p5_a3 JTF_VARCHAR2_TABLE_2000
114: , p5_a4 JTF_VARCHAR2_TABLE_100
115: , p5_a5 JTF_VARCHAR2_TABLE_100
114: , p5_a4 JTF_VARCHAR2_TABLE_100
115: , p5_a5 JTF_VARCHAR2_TABLE_100
116: , p5_a6 JTF_VARCHAR2_TABLE_500
117: , p5_a7 JTF_VARCHAR2_TABLE_500
118: , p5_a8 JTF_NUMBER_TABLE
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
115: , p5_a5 JTF_VARCHAR2_TABLE_100
116: , p5_a6 JTF_VARCHAR2_TABLE_500
117: , p5_a7 JTF_VARCHAR2_TABLE_500
118: , p5_a8 JTF_NUMBER_TABLE
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
117: , p5_a7 JTF_VARCHAR2_TABLE_500
118: , p5_a8 JTF_NUMBER_TABLE
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
129: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_NUMBER_TABLE
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
129: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_NUMBER_TABLE
135: , p6_a10 out nocopy JTF_DATE_TABLE
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_DATE_TABLE
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_NUMBER_TABLE
135: , p6_a10 out nocopy JTF_DATE_TABLE
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_DATE_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_NUMBER_TABLE
135: , p6_a10 out nocopy JTF_DATE_TABLE
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_DATE_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: );
134: , p6_a9 out nocopy JTF_NUMBER_TABLE
135: , p6_a10 out nocopy JTF_DATE_TABLE
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_DATE_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: );
141: procedure update_row(p_api_version NUMBER
142: , p_init_msg_list VARCHAR2
135: , p6_a10 out nocopy JTF_DATE_TABLE
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_DATE_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: );
141: procedure update_row(p_api_version NUMBER
142: , p_init_msg_list VARCHAR2
143: , x_return_status out nocopy VARCHAR2
178: , p_init_msg_list VARCHAR2
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_VARCHAR2_TABLE_100
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_VARCHAR2_TABLE_100
187: , p5_a5 JTF_VARCHAR2_TABLE_100
186: , p5_a4 JTF_VARCHAR2_TABLE_100
187: , p5_a5 JTF_VARCHAR2_TABLE_100
188: , p5_a6 JTF_VARCHAR2_TABLE_500
189: , p5_a7 JTF_VARCHAR2_TABLE_500
190: , p5_a8 JTF_NUMBER_TABLE
191: , p5_a9 JTF_NUMBER_TABLE
192: , p5_a10 JTF_DATE_TABLE
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
187: , p5_a5 JTF_VARCHAR2_TABLE_100
188: , p5_a6 JTF_VARCHAR2_TABLE_500
189: , p5_a7 JTF_VARCHAR2_TABLE_500
190: , p5_a8 JTF_NUMBER_TABLE
191: , p5_a9 JTF_NUMBER_TABLE
192: , p5_a10 JTF_DATE_TABLE
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
189: , p5_a7 JTF_VARCHAR2_TABLE_500
190: , p5_a8 JTF_NUMBER_TABLE
191: , p5_a9 JTF_NUMBER_TABLE
192: , p5_a10 JTF_DATE_TABLE
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
196: , p5_a14 JTF_NUMBER_TABLE
197: , p6_a0 out nocopy JTF_NUMBER_TABLE
191: , p5_a9 JTF_NUMBER_TABLE
192: , p5_a10 JTF_DATE_TABLE
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
196: , p5_a14 JTF_NUMBER_TABLE
197: , p6_a0 out nocopy JTF_NUMBER_TABLE
198: , p6_a1 out nocopy JTF_NUMBER_TABLE
199: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
192: , p5_a10 JTF_DATE_TABLE
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
196: , p5_a14 JTF_NUMBER_TABLE
197: , p6_a0 out nocopy JTF_NUMBER_TABLE
198: , p6_a1 out nocopy JTF_NUMBER_TABLE
199: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
200: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
193: , p5_a11 JTF_NUMBER_TABLE
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
196: , p5_a14 JTF_NUMBER_TABLE
197: , p6_a0 out nocopy JTF_NUMBER_TABLE
198: , p6_a1 out nocopy JTF_NUMBER_TABLE
199: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
200: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
194: , p5_a12 JTF_DATE_TABLE
195: , p5_a13 JTF_NUMBER_TABLE
196: , p5_a14 JTF_NUMBER_TABLE
197: , p6_a0 out nocopy JTF_NUMBER_TABLE
198: , p6_a1 out nocopy JTF_NUMBER_TABLE
199: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
200: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
202: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
202: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
203: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
204: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
205: , p6_a8 out nocopy JTF_NUMBER_TABLE
206: , p6_a9 out nocopy JTF_NUMBER_TABLE
207: , p6_a10 out nocopy JTF_DATE_TABLE
208: , p6_a11 out nocopy JTF_NUMBER_TABLE
209: , p6_a12 out nocopy JTF_DATE_TABLE
202: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
203: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
204: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
205: , p6_a8 out nocopy JTF_NUMBER_TABLE
206: , p6_a9 out nocopy JTF_NUMBER_TABLE
207: , p6_a10 out nocopy JTF_DATE_TABLE
208: , p6_a11 out nocopy JTF_NUMBER_TABLE
209: , p6_a12 out nocopy JTF_DATE_TABLE
210: , p6_a13 out nocopy JTF_NUMBER_TABLE
204: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
205: , p6_a8 out nocopy JTF_NUMBER_TABLE
206: , p6_a9 out nocopy JTF_NUMBER_TABLE
207: , p6_a10 out nocopy JTF_DATE_TABLE
208: , p6_a11 out nocopy JTF_NUMBER_TABLE
209: , p6_a12 out nocopy JTF_DATE_TABLE
210: , p6_a13 out nocopy JTF_NUMBER_TABLE
211: , p6_a14 out nocopy JTF_NUMBER_TABLE
212: );
206: , p6_a9 out nocopy JTF_NUMBER_TABLE
207: , p6_a10 out nocopy JTF_DATE_TABLE
208: , p6_a11 out nocopy JTF_NUMBER_TABLE
209: , p6_a12 out nocopy JTF_DATE_TABLE
210: , p6_a13 out nocopy JTF_NUMBER_TABLE
211: , p6_a14 out nocopy JTF_NUMBER_TABLE
212: );
213: procedure delete_row(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2
207: , p6_a10 out nocopy JTF_DATE_TABLE
208: , p6_a11 out nocopy JTF_NUMBER_TABLE
209: , p6_a12 out nocopy JTF_DATE_TABLE
210: , p6_a13 out nocopy JTF_NUMBER_TABLE
211: , p6_a14 out nocopy JTF_NUMBER_TABLE
212: );
213: procedure delete_row(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
235: , p_init_msg_list VARCHAR2
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p5_a0 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_200
242: , p5_a3 JTF_VARCHAR2_TABLE_2000
243: , p5_a4 JTF_VARCHAR2_TABLE_100
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p5_a0 JTF_NUMBER_TABLE
240: , p5_a1 JTF_NUMBER_TABLE
241: , p5_a2 JTF_VARCHAR2_TABLE_200
242: , p5_a3 JTF_VARCHAR2_TABLE_2000
243: , p5_a4 JTF_VARCHAR2_TABLE_100
244: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a4 JTF_VARCHAR2_TABLE_100
244: , p5_a5 JTF_VARCHAR2_TABLE_100
245: , p5_a6 JTF_VARCHAR2_TABLE_500
246: , p5_a7 JTF_VARCHAR2_TABLE_500
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
244: , p5_a5 JTF_VARCHAR2_TABLE_100
245: , p5_a6 JTF_VARCHAR2_TABLE_500
246: , p5_a7 JTF_VARCHAR2_TABLE_500
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
246: , p5_a7 JTF_VARCHAR2_TABLE_500
247: , p5_a8 JTF_NUMBER_TABLE
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
253: , p5_a14 JTF_NUMBER_TABLE
254: );
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
253: , p5_a14 JTF_NUMBER_TABLE
254: );
255: end okl_gtp_pvt_w;
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
253: , p5_a14 JTF_NUMBER_TABLE
254: );
255: end okl_gtp_pvt_w;