APPS.OKL_CAU_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cau_pvt.cauv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_cau_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLECAUS.pls 115.1 2002/12/24 20:17:49 bvaghela noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cau_pvt.cauv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLECAUS.pls 115.1 2002/12/24 20:17:49 bvaghela noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cau_pvt.cauv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500

Line 23: , a20 JTF_NUMBER_TABLE

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

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_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

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 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_p2(t okl_cau_pvt.cauv_tbl_type, 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_p2(t okl_cau_pvt.cauv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_200
32: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 30: procedure rosetta_table_copy_out_p2(t okl_cau_pvt.cauv_tbl_type, 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_p2(t okl_cau_pvt.cauv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_200
32: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: , a3 out nocopy JTF_NUMBER_TABLE

29: );
30: procedure rosetta_table_copy_out_p2(t okl_cau_pvt.cauv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_200
32: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_500
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 50: , a20 out nocopy JTF_NUMBER_TABLE

46: , a16 out nocopy JTF_VARCHAR2_TABLE_500
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_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

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_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

Line 53: , a23 out nocopy JTF_NUMBER_TABLE

49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 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:

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 rosetta_table_copy_in_p5(t out nocopy okl_cau_pvt.cau_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_200

Line 58: procedure rosetta_table_copy_in_p5(t out nocopy okl_cau_pvt.cau_tbl_type, a0 JTF_NUMBER_TABLE

54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_cau_pvt.cau_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_200
60: , a2 JTF_VARCHAR2_TABLE_2000
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100

Line 61: , a3 JTF_NUMBER_TABLE

57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_cau_pvt.cau_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_200
60: , a2 JTF_VARCHAR2_TABLE_2000
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_500
64: , a6 JTF_VARCHAR2_TABLE_500
65: , a7 JTF_VARCHAR2_TABLE_500

Line 78: , a20 JTF_NUMBER_TABLE

74: , a16 JTF_VARCHAR2_TABLE_500
75: , a17 JTF_VARCHAR2_TABLE_500
76: , a18 JTF_VARCHAR2_TABLE_500
77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_NUMBER_TABLE
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE

Line 79: , a21 JTF_NUMBER_TABLE

75: , a17 JTF_VARCHAR2_TABLE_500
76: , a18 JTF_VARCHAR2_TABLE_500
77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_NUMBER_TABLE
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE

Line 81: , a23 JTF_NUMBER_TABLE

77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_NUMBER_TABLE
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_cau_pvt.cau_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 83: , a25 JTF_NUMBER_TABLE

79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_cau_pvt.cau_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_VARCHAR2_TABLE_200
87: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 85: procedure rosetta_table_copy_out_p5(t okl_cau_pvt.cau_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_cau_pvt.cau_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_VARCHAR2_TABLE_200
87: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , a3 out nocopy JTF_NUMBER_TABLE

84: );
85: procedure rosetta_table_copy_out_p5(t okl_cau_pvt.cau_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_VARCHAR2_TABLE_200
87: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_500
91: , a6 out nocopy JTF_VARCHAR2_TABLE_500
92: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 105: , a20 out nocopy JTF_NUMBER_TABLE

101: , a16 out nocopy JTF_VARCHAR2_TABLE_500
102: , a17 out nocopy JTF_VARCHAR2_TABLE_500
103: , a18 out nocopy JTF_VARCHAR2_TABLE_500
104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE

Line 106: , a21 out nocopy JTF_NUMBER_TABLE

102: , a17 out nocopy JTF_VARCHAR2_TABLE_500
103: , a18 out nocopy JTF_VARCHAR2_TABLE_500
104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE

Line 108: , a23 out nocopy JTF_NUMBER_TABLE

104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:

Line 110: , a25 out nocopy JTF_NUMBER_TABLE

106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:
113: procedure insert_row(p_api_version NUMBER
114: , p_init_msg_list VARCHAR2

Line 176: , p5_a0 JTF_NUMBER_TABLE

172: , p_init_msg_list VARCHAR2
173: , x_return_status out nocopy VARCHAR2
174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_VARCHAR2_TABLE_200
178: , p5_a2 JTF_VARCHAR2_TABLE_2000
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 179: , p5_a3 JTF_NUMBER_TABLE

175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_VARCHAR2_TABLE_200
178: , p5_a2 JTF_VARCHAR2_TABLE_2000
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_500
182: , p5_a6 JTF_VARCHAR2_TABLE_500
183: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 196: , p5_a20 JTF_NUMBER_TABLE

192: , p5_a16 JTF_VARCHAR2_TABLE_500
193: , p5_a17 JTF_VARCHAR2_TABLE_500
194: , p5_a18 JTF_VARCHAR2_TABLE_500
195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_NUMBER_TABLE
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE

Line 197: , p5_a21 JTF_NUMBER_TABLE

193: , p5_a17 JTF_VARCHAR2_TABLE_500
194: , p5_a18 JTF_VARCHAR2_TABLE_500
195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_NUMBER_TABLE
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE

Line 199: , p5_a23 JTF_NUMBER_TABLE

195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_NUMBER_TABLE
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 201: , p5_a25 JTF_NUMBER_TABLE

197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
204: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
205: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 202: , p6_a0 out nocopy JTF_NUMBER_TABLE

198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
204: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , p6_a3 out nocopy JTF_NUMBER_TABLE

201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
204: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
208: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
209: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 222: , p6_a20 out nocopy JTF_NUMBER_TABLE

218: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
219: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
220: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_NUMBER_TABLE
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE

Line 223: , p6_a21 out nocopy JTF_NUMBER_TABLE

219: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
220: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_NUMBER_TABLE
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 225: , p6_a23 out nocopy JTF_NUMBER_TABLE

221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_NUMBER_TABLE
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER

Line 227: , p6_a25 out nocopy JTF_NUMBER_TABLE

223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER
230: , p_init_msg_list VARCHAR2
231: , x_return_status out nocopy VARCHAR2

Line 266: , p5_a0 JTF_NUMBER_TABLE

262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_VARCHAR2_TABLE_200
268: , p5_a2 JTF_VARCHAR2_TABLE_2000
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 269: , p5_a3 JTF_NUMBER_TABLE

265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_VARCHAR2_TABLE_200
268: , p5_a2 JTF_VARCHAR2_TABLE_2000
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_500
272: , p5_a6 JTF_VARCHAR2_TABLE_500
273: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 286: , p5_a20 JTF_NUMBER_TABLE

282: , p5_a16 JTF_VARCHAR2_TABLE_500
283: , p5_a17 JTF_VARCHAR2_TABLE_500
284: , p5_a18 JTF_VARCHAR2_TABLE_500
285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_NUMBER_TABLE
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE

Line 287: , p5_a21 JTF_NUMBER_TABLE

283: , p5_a17 JTF_VARCHAR2_TABLE_500
284: , p5_a18 JTF_VARCHAR2_TABLE_500
285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_NUMBER_TABLE
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE

Line 289: , p5_a23 JTF_NUMBER_TABLE

285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_NUMBER_TABLE
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER

Line 291: , p5_a25 JTF_NUMBER_TABLE

287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2

Line 356: , p5_a0 JTF_NUMBER_TABLE

352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_VARCHAR2_TABLE_200
358: , p5_a2 JTF_VARCHAR2_TABLE_2000
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 359: , p5_a3 JTF_NUMBER_TABLE

355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_VARCHAR2_TABLE_200
358: , p5_a2 JTF_VARCHAR2_TABLE_2000
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_500
362: , p5_a6 JTF_VARCHAR2_TABLE_500
363: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 376: , p5_a20 JTF_NUMBER_TABLE

372: , p5_a16 JTF_VARCHAR2_TABLE_500
373: , p5_a17 JTF_VARCHAR2_TABLE_500
374: , p5_a18 JTF_VARCHAR2_TABLE_500
375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_NUMBER_TABLE
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE

Line 377: , p5_a21 JTF_NUMBER_TABLE

373: , p5_a17 JTF_VARCHAR2_TABLE_500
374: , p5_a18 JTF_VARCHAR2_TABLE_500
375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_NUMBER_TABLE
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE

Line 379: , p5_a23 JTF_NUMBER_TABLE

375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_NUMBER_TABLE
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 381: , p5_a25 JTF_NUMBER_TABLE

377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
384: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 382: , p6_a0 out nocopy JTF_NUMBER_TABLE

378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
384: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 385: , p6_a3 out nocopy JTF_NUMBER_TABLE

381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
384: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 402: , p6_a20 out nocopy JTF_NUMBER_TABLE

398: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_NUMBER_TABLE
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE

Line 403: , p6_a21 out nocopy JTF_NUMBER_TABLE

399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_NUMBER_TABLE
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 405: , p6_a23 out nocopy JTF_NUMBER_TABLE

401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_NUMBER_TABLE
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER

Line 407: , p6_a25 out nocopy JTF_NUMBER_TABLE

403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER
410: , p_init_msg_list VARCHAR2
411: , x_return_status out nocopy VARCHAR2

Line 446: , p5_a0 JTF_NUMBER_TABLE

442: , p_init_msg_list VARCHAR2
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_VARCHAR2_TABLE_200
448: , p5_a2 JTF_VARCHAR2_TABLE_2000
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 449: , p5_a3 JTF_NUMBER_TABLE

445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_VARCHAR2_TABLE_200
448: , p5_a2 JTF_VARCHAR2_TABLE_2000
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
451: , p5_a5 JTF_VARCHAR2_TABLE_500
452: , p5_a6 JTF_VARCHAR2_TABLE_500
453: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 466: , p5_a20 JTF_NUMBER_TABLE

462: , p5_a16 JTF_VARCHAR2_TABLE_500
463: , p5_a17 JTF_VARCHAR2_TABLE_500
464: , p5_a18 JTF_VARCHAR2_TABLE_500
465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_NUMBER_TABLE
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE

Line 467: , p5_a21 JTF_NUMBER_TABLE

463: , p5_a17 JTF_VARCHAR2_TABLE_500
464: , p5_a18 JTF_VARCHAR2_TABLE_500
465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_NUMBER_TABLE
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE

Line 469: , p5_a23 JTF_NUMBER_TABLE

465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_NUMBER_TABLE
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER

Line 471: , p5_a25 JTF_NUMBER_TABLE

467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2

Line 510: , p5_a0 JTF_NUMBER_TABLE

506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_VARCHAR2_TABLE_200
512: , p5_a2 JTF_VARCHAR2_TABLE_2000
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 513: , p5_a3 JTF_NUMBER_TABLE

509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_VARCHAR2_TABLE_200
512: , p5_a2 JTF_VARCHAR2_TABLE_2000
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_500
516: , p5_a6 JTF_VARCHAR2_TABLE_500
517: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 530: , p5_a20 JTF_NUMBER_TABLE

526: , p5_a16 JTF_VARCHAR2_TABLE_500
527: , p5_a17 JTF_VARCHAR2_TABLE_500
528: , p5_a18 JTF_VARCHAR2_TABLE_500
529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_NUMBER_TABLE
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE

Line 531: , p5_a21 JTF_NUMBER_TABLE

527: , p5_a17 JTF_VARCHAR2_TABLE_500
528: , p5_a18 JTF_VARCHAR2_TABLE_500
529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_NUMBER_TABLE
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE

Line 533: , p5_a23 JTF_NUMBER_TABLE

529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_NUMBER_TABLE
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_cau_pvt_w;

Line 535: , p5_a25 JTF_NUMBER_TABLE

531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_cau_pvt_w;