DBA Data[Home] [Help]

APPS.OKL_ETO_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE

1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE

Line 33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 34: , a1 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE

Line 35: , a2 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE

Line 36: , a3 out nocopy JTF_NUMBER_TABLE

32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a5 out nocopy JTF_NUMBER_TABLE

34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 39: , a6 out nocopy JTF_NUMBER_TABLE

35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500
44: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 57: , a24 out nocopy JTF_NUMBER_TABLE

53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_VARCHAR2_TABLE_500
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE

Line 59: , a26 out nocopy JTF_NUMBER_TABLE

55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_VARCHAR2_TABLE_500
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:

Line 61: , a28 out nocopy JTF_NUMBER_TABLE

57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure insert_row(p_api_version NUMBER
65: , p_init_msg_list VARCHAR2

Line 133: , p5_a0 JTF_NUMBER_TABLE

129: , p_init_msg_list VARCHAR2
130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE

Line 134: , p5_a1 JTF_NUMBER_TABLE

130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE

Line 135: , p5_a2 JTF_NUMBER_TABLE

131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE

Line 136: , p5_a3 JTF_NUMBER_TABLE

132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE

Line 137: , p5_a4 JTF_NUMBER_TABLE

133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 138: , p5_a5 JTF_NUMBER_TABLE

134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 139: , p5_a6 JTF_NUMBER_TABLE

135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500
143: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 140: , p5_a7 JTF_NUMBER_TABLE

136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500
143: , p5_a10 JTF_VARCHAR2_TABLE_500
144: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 157: , p5_a24 JTF_NUMBER_TABLE

153: , p5_a20 JTF_VARCHAR2_TABLE_500
154: , p5_a21 JTF_VARCHAR2_TABLE_500
155: , p5_a22 JTF_VARCHAR2_TABLE_500
156: , p5_a23 JTF_VARCHAR2_TABLE_500
157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE

Line 159: , p5_a26 JTF_NUMBER_TABLE

155: , p5_a22 JTF_VARCHAR2_TABLE_500
156: , p5_a23 JTF_VARCHAR2_TABLE_500
157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 161: , p5_a28 JTF_NUMBER_TABLE

157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 162: , p6_a0 out nocopy JTF_NUMBER_TABLE

158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 163: , p6_a1 out nocopy JTF_NUMBER_TABLE

159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 164: , p6_a2 out nocopy JTF_NUMBER_TABLE

160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 165: , p6_a3 out nocopy JTF_NUMBER_TABLE

161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 166: , p6_a4 out nocopy JTF_NUMBER_TABLE

162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p6_a5 out nocopy JTF_NUMBER_TABLE

163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 168: , p6_a6 out nocopy JTF_NUMBER_TABLE

164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 169: , p6_a7 out nocopy JTF_NUMBER_TABLE

165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
173: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 186: , p6_a24 out nocopy JTF_NUMBER_TABLE

182: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
183: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
184: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 188: , p6_a26 out nocopy JTF_NUMBER_TABLE

184: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER

Line 190: , p6_a28 out nocopy JTF_NUMBER_TABLE

186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER
193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2

Line 261: , p5_a0 JTF_NUMBER_TABLE

257: , p_init_msg_list VARCHAR2
258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE

Line 262: , p5_a1 JTF_NUMBER_TABLE

258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE

Line 263: , p5_a2 JTF_NUMBER_TABLE

259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE

Line 264: , p5_a3 JTF_NUMBER_TABLE

260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE

Line 265: , p5_a4 JTF_NUMBER_TABLE

261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 266: , p5_a5 JTF_NUMBER_TABLE

262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 267: , p5_a6 JTF_NUMBER_TABLE

263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500
271: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 268: , p5_a7 JTF_NUMBER_TABLE

264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500
271: , p5_a10 JTF_VARCHAR2_TABLE_500
272: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 285: , p5_a24 JTF_NUMBER_TABLE

281: , p5_a20 JTF_VARCHAR2_TABLE_500
282: , p5_a21 JTF_VARCHAR2_TABLE_500
283: , p5_a22 JTF_VARCHAR2_TABLE_500
284: , p5_a23 JTF_VARCHAR2_TABLE_500
285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE

Line 287: , p5_a26 JTF_NUMBER_TABLE

283: , p5_a22 JTF_VARCHAR2_TABLE_500
284: , p5_a23 JTF_VARCHAR2_TABLE_500
285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 289: , p5_a28 JTF_NUMBER_TABLE

285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 290: , p6_a0 out nocopy JTF_NUMBER_TABLE

286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 291: , p6_a1 out nocopy JTF_NUMBER_TABLE

287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 292: , p6_a2 out nocopy JTF_NUMBER_TABLE

288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 293: , p6_a3 out nocopy JTF_NUMBER_TABLE

289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 294: , p6_a4 out nocopy JTF_NUMBER_TABLE

290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 295: , p6_a5 out nocopy JTF_NUMBER_TABLE

291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 296: , p6_a6 out nocopy JTF_NUMBER_TABLE

292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 297: , p6_a7 out nocopy JTF_NUMBER_TABLE

293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
301: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 314: , p6_a24 out nocopy JTF_NUMBER_TABLE

310: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
311: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
312: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
313: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 316: , p6_a26 out nocopy JTF_NUMBER_TABLE

312: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
313: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE
319: );
320: procedure delete_row(p_api_version NUMBER

Line 318: , p6_a28 out nocopy JTF_NUMBER_TABLE

314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE
319: );
320: procedure delete_row(p_api_version NUMBER
321: , p_init_msg_list VARCHAR2
322: , x_return_status out nocopy VARCHAR2

Line 360: , p5_a0 JTF_NUMBER_TABLE

356: , p_init_msg_list VARCHAR2
357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE

Line 361: , p5_a1 JTF_NUMBER_TABLE

357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE

Line 362: , p5_a2 JTF_NUMBER_TABLE

358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE

Line 363: , p5_a3 JTF_NUMBER_TABLE

359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE

Line 364: , p5_a4 JTF_NUMBER_TABLE

360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100

Line 365: , p5_a5 JTF_NUMBER_TABLE

361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 366: , p5_a6 JTF_NUMBER_TABLE

362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500
370: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 367: , p5_a7 JTF_NUMBER_TABLE

363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500
370: , p5_a10 JTF_VARCHAR2_TABLE_500
371: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 384: , p5_a24 JTF_NUMBER_TABLE

380: , p5_a20 JTF_VARCHAR2_TABLE_500
381: , p5_a21 JTF_VARCHAR2_TABLE_500
382: , p5_a22 JTF_VARCHAR2_TABLE_500
383: , p5_a23 JTF_VARCHAR2_TABLE_500
384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE

Line 386: , p5_a26 JTF_NUMBER_TABLE

382: , p5_a22 JTF_VARCHAR2_TABLE_500
383: , p5_a23 JTF_VARCHAR2_TABLE_500
384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE
389: );
390: end okl_eto_pvt_w;

Line 388: , p5_a28 JTF_NUMBER_TABLE

384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE
389: );
390: end okl_eto_pvt_w;