DBA Data[Home] [Help]

APPS.OKL_ETV_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_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_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_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_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_etv_pvt_w as
2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_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_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIETVS.pls 120.0 2005/07/07 10:39:13 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_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_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_etv_pvt.okl_etv_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_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500

Line 24: , a21 JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE

Line 30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE

Line 31: , a1 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , a2 out nocopy JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 33: , a3 out nocopy JTF_NUMBER_TABLE

29: );
30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 34: , a4 out nocopy JTF_NUMBER_TABLE

30: procedure rosetta_table_copy_out_p1(t okl_etv_pvt.okl_etv_tbl, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
38: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 51: , a21 out nocopy JTF_NUMBER_TABLE

47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE

Line 53: , a23 out nocopy JTF_NUMBER_TABLE

49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:

Line 55: , a25 out nocopy JTF_NUMBER_TABLE

51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure insert_row(p_api_version NUMBER
59: , p_init_msg_list VARCHAR2

Line 121: , p5_a0 JTF_NUMBER_TABLE

117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE

Line 122: , p5_a1 JTF_NUMBER_TABLE

118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 123: , p5_a2 JTF_NUMBER_TABLE

119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 124: , p5_a3 JTF_NUMBER_TABLE

120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500
128: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 125: , p5_a4 JTF_NUMBER_TABLE

121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_NUMBER_TABLE
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_NUMBER_TABLE
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_VARCHAR2_TABLE_100
127: , p5_a6 JTF_VARCHAR2_TABLE_500
128: , p5_a7 JTF_VARCHAR2_TABLE_500
129: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 142: , p5_a21 JTF_NUMBER_TABLE

138: , p5_a17 JTF_VARCHAR2_TABLE_500
139: , p5_a18 JTF_VARCHAR2_TABLE_500
140: , p5_a19 JTF_VARCHAR2_TABLE_500
141: , p5_a20 JTF_VARCHAR2_TABLE_500
142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE

Line 144: , p5_a23 JTF_NUMBER_TABLE

140: , p5_a19 JTF_VARCHAR2_TABLE_500
141: , p5_a20 JTF_VARCHAR2_TABLE_500
142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 146: , p5_a25 JTF_NUMBER_TABLE

142: , p5_a21 JTF_NUMBER_TABLE
143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 147: , p6_a0 out nocopy JTF_NUMBER_TABLE

143: , p5_a22 JTF_DATE_TABLE
144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 148: , p6_a1 out nocopy JTF_NUMBER_TABLE

144: , p5_a23 JTF_NUMBER_TABLE
145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , p6_a2 out nocopy JTF_NUMBER_TABLE

145: , p5_a24 JTF_DATE_TABLE
146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 150: , p6_a3 out nocopy JTF_NUMBER_TABLE

146: , p5_a25 JTF_NUMBER_TABLE
147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
154: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 151: , p6_a4 out nocopy JTF_NUMBER_TABLE

147: , p6_a0 out nocopy JTF_NUMBER_TABLE
148: , p6_a1 out nocopy JTF_NUMBER_TABLE
149: , p6_a2 out nocopy JTF_NUMBER_TABLE
150: , p6_a3 out nocopy JTF_NUMBER_TABLE
151: , p6_a4 out nocopy JTF_NUMBER_TABLE
152: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
154: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
155: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 168: , p6_a21 out nocopy JTF_NUMBER_TABLE

164: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
165: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 170: , p6_a23 out nocopy JTF_NUMBER_TABLE

166: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
167: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE
173: );
174: procedure update_row(p_api_version NUMBER

Line 172: , p6_a25 out nocopy JTF_NUMBER_TABLE

168: , p6_a21 out nocopy JTF_NUMBER_TABLE
169: , p6_a22 out nocopy JTF_DATE_TABLE
170: , p6_a23 out nocopy JTF_NUMBER_TABLE
171: , p6_a24 out nocopy JTF_DATE_TABLE
172: , p6_a25 out nocopy JTF_NUMBER_TABLE
173: );
174: procedure update_row(p_api_version NUMBER
175: , p_init_msg_list VARCHAR2
176: , x_return_status out nocopy VARCHAR2

Line 237: , p5_a0 JTF_NUMBER_TABLE

233: , p_init_msg_list VARCHAR2
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE

Line 238: , p5_a1 JTF_NUMBER_TABLE

234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 239: , p5_a2 JTF_NUMBER_TABLE

235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 240: , p5_a3 JTF_NUMBER_TABLE

236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500
244: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 241: , p5_a4 JTF_NUMBER_TABLE

237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_NUMBER_TABLE
241: , p5_a4 JTF_NUMBER_TABLE
242: , p5_a5 JTF_VARCHAR2_TABLE_100
243: , p5_a6 JTF_VARCHAR2_TABLE_500
244: , p5_a7 JTF_VARCHAR2_TABLE_500
245: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 258: , p5_a21 JTF_NUMBER_TABLE

254: , p5_a17 JTF_VARCHAR2_TABLE_500
255: , p5_a18 JTF_VARCHAR2_TABLE_500
256: , p5_a19 JTF_VARCHAR2_TABLE_500
257: , p5_a20 JTF_VARCHAR2_TABLE_500
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE

Line 260: , p5_a23 JTF_NUMBER_TABLE

256: , p5_a19 JTF_VARCHAR2_TABLE_500
257: , p5_a20 JTF_VARCHAR2_TABLE_500
258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 262: , p5_a25 JTF_NUMBER_TABLE

258: , p5_a21 JTF_NUMBER_TABLE
259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 263: , p6_a0 out nocopy JTF_NUMBER_TABLE

259: , p5_a22 JTF_DATE_TABLE
260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 264: , p6_a1 out nocopy JTF_NUMBER_TABLE

260: , p5_a23 JTF_NUMBER_TABLE
261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p6_a2 out nocopy JTF_NUMBER_TABLE

261: , p5_a24 JTF_DATE_TABLE
262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 266: , p6_a3 out nocopy JTF_NUMBER_TABLE

262: , p5_a25 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 267: , p6_a4 out nocopy JTF_NUMBER_TABLE

263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_NUMBER_TABLE
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_NUMBER_TABLE
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 284: , p6_a21 out nocopy JTF_NUMBER_TABLE

280: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 286: , p6_a23 out nocopy JTF_NUMBER_TABLE

282: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE
289: );
290: procedure delete_row(p_api_version NUMBER

Line 288: , p6_a25 out nocopy JTF_NUMBER_TABLE

284: , p6_a21 out nocopy JTF_NUMBER_TABLE
285: , p6_a22 out nocopy JTF_DATE_TABLE
286: , p6_a23 out nocopy JTF_NUMBER_TABLE
287: , p6_a24 out nocopy JTF_DATE_TABLE
288: , p6_a25 out nocopy JTF_NUMBER_TABLE
289: );
290: procedure delete_row(p_api_version NUMBER
291: , p_init_msg_list VARCHAR2
292: , x_return_status out nocopy VARCHAR2

Line 327: , p5_a0 JTF_NUMBER_TABLE

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_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE

Line 328: , p5_a1 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_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 329: , p5_a2 JTF_NUMBER_TABLE

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_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 330: , p5_a3 JTF_NUMBER_TABLE

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_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500
334: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 331: , p5_a4 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_NUMBER_TABLE
331: , p5_a4 JTF_NUMBER_TABLE
332: , p5_a5 JTF_VARCHAR2_TABLE_100
333: , p5_a6 JTF_VARCHAR2_TABLE_500
334: , p5_a7 JTF_VARCHAR2_TABLE_500
335: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 348: , p5_a21 JTF_NUMBER_TABLE

344: , p5_a17 JTF_VARCHAR2_TABLE_500
345: , p5_a18 JTF_VARCHAR2_TABLE_500
346: , p5_a19 JTF_VARCHAR2_TABLE_500
347: , p5_a20 JTF_VARCHAR2_TABLE_500
348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE

Line 350: , p5_a23 JTF_NUMBER_TABLE

346: , p5_a19 JTF_VARCHAR2_TABLE_500
347: , p5_a20 JTF_VARCHAR2_TABLE_500
348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE
353: );
354: end okl_etv_pvt_w;

Line 352: , p5_a25 JTF_NUMBER_TABLE

348: , p5_a21 JTF_NUMBER_TABLE
349: , p5_a22 JTF_DATE_TABLE
350: , p5_a23 JTF_NUMBER_TABLE
351: , p5_a24 JTF_DATE_TABLE
352: , p5_a25 JTF_NUMBER_TABLE
353: );
354: end okl_etv_pvt_w;