DBA Data[Home] [Help]

APPS.OKL_EVE_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

2: /* $Header: OKLIEVES.pls 120.0 2005/07/07 10:39:38 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eve_pvt.okl_eve_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_DATE_TABLE

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

Line 27: , a24 JTF_DATE_TABLE

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

Line 29: , a26 JTF_DATE_TABLE

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

Line 35: , a3 out nocopy JTF_DATE_TABLE

31: );
32: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_DATE_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a4 out nocopy JTF_DATE_TABLE

32: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_DATE_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 56: , a24 out nocopy JTF_DATE_TABLE

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

Line 58: , a26 out nocopy JTF_DATE_TABLE

54: , a22 out nocopy JTF_VARCHAR2_TABLE_500
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure insert_row(p_api_version NUMBER

Line 132: , p5_a3 JTF_DATE_TABLE

128: , x_msg_data out nocopy VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_VARCHAR2_TABLE_100
132: , p5_a3 JTF_DATE_TABLE
133: , p5_a4 JTF_DATE_TABLE
134: , p5_a5 JTF_VARCHAR2_TABLE_100
135: , p5_a6 JTF_NUMBER_TABLE
136: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 133: , p5_a4 JTF_DATE_TABLE

129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_VARCHAR2_TABLE_100
132: , p5_a3 JTF_DATE_TABLE
133: , p5_a4 JTF_DATE_TABLE
134: , p5_a5 JTF_VARCHAR2_TABLE_100
135: , p5_a6 JTF_NUMBER_TABLE
136: , p5_a7 JTF_VARCHAR2_TABLE_100
137: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 153: , p5_a24 JTF_DATE_TABLE

149: , p5_a20 JTF_VARCHAR2_TABLE_500
150: , p5_a21 JTF_VARCHAR2_TABLE_500
151: , p5_a22 JTF_VARCHAR2_TABLE_500
152: , p5_a23 JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 155: , p5_a26 JTF_DATE_TABLE

151: , p5_a22 JTF_VARCHAR2_TABLE_500
152: , p5_a23 JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , p6_a3 out nocopy JTF_DATE_TABLE

156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_DATE_TABLE
161: , p6_a4 out nocopy JTF_DATE_TABLE
162: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a6 out nocopy JTF_NUMBER_TABLE
164: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , p6_a4 out nocopy JTF_DATE_TABLE

157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_DATE_TABLE
161: , p6_a4 out nocopy JTF_DATE_TABLE
162: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a6 out nocopy JTF_NUMBER_TABLE
164: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
165: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 181: , p6_a24 out nocopy JTF_DATE_TABLE

177: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
178: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a23 out nocopy JTF_NUMBER_TABLE
181: , p6_a24 out nocopy JTF_DATE_TABLE
182: , p6_a25 out nocopy JTF_NUMBER_TABLE
183: , p6_a26 out nocopy JTF_DATE_TABLE
184: , p6_a27 out nocopy JTF_NUMBER_TABLE
185: );

Line 183: , p6_a26 out nocopy JTF_DATE_TABLE

179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a23 out nocopy JTF_NUMBER_TABLE
181: , p6_a24 out nocopy JTF_DATE_TABLE
182: , p6_a25 out nocopy JTF_NUMBER_TABLE
183: , p6_a26 out nocopy JTF_DATE_TABLE
184: , p6_a27 out nocopy JTF_NUMBER_TABLE
185: );
186: procedure update_row(p_api_version NUMBER
187: , p_init_msg_list VARCHAR2

Line 256: , p5_a3 JTF_DATE_TABLE

252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 JTF_NUMBER_TABLE
254: , p5_a1 JTF_NUMBER_TABLE
255: , p5_a2 JTF_VARCHAR2_TABLE_100
256: , p5_a3 JTF_DATE_TABLE
257: , p5_a4 JTF_DATE_TABLE
258: , p5_a5 JTF_VARCHAR2_TABLE_100
259: , p5_a6 JTF_NUMBER_TABLE
260: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 257: , p5_a4 JTF_DATE_TABLE

253: , p5_a0 JTF_NUMBER_TABLE
254: , p5_a1 JTF_NUMBER_TABLE
255: , p5_a2 JTF_VARCHAR2_TABLE_100
256: , p5_a3 JTF_DATE_TABLE
257: , p5_a4 JTF_DATE_TABLE
258: , p5_a5 JTF_VARCHAR2_TABLE_100
259: , p5_a6 JTF_NUMBER_TABLE
260: , p5_a7 JTF_VARCHAR2_TABLE_100
261: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 277: , p5_a24 JTF_DATE_TABLE

273: , p5_a20 JTF_VARCHAR2_TABLE_500
274: , p5_a21 JTF_VARCHAR2_TABLE_500
275: , p5_a22 JTF_VARCHAR2_TABLE_500
276: , p5_a23 JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 279: , p5_a26 JTF_DATE_TABLE

275: , p5_a22 JTF_VARCHAR2_TABLE_500
276: , p5_a23 JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 284: , p6_a3 out nocopy JTF_DATE_TABLE

280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_DATE_TABLE
285: , p6_a4 out nocopy JTF_DATE_TABLE
286: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 285: , p6_a4 out nocopy JTF_DATE_TABLE

281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_DATE_TABLE
285: , p6_a4 out nocopy JTF_DATE_TABLE
286: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 305: , p6_a24 out nocopy JTF_DATE_TABLE

301: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
302: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a23 out nocopy JTF_NUMBER_TABLE
305: , p6_a24 out nocopy JTF_DATE_TABLE
306: , p6_a25 out nocopy JTF_NUMBER_TABLE
307: , p6_a26 out nocopy JTF_DATE_TABLE
308: , p6_a27 out nocopy JTF_NUMBER_TABLE
309: );

Line 307: , p6_a26 out nocopy JTF_DATE_TABLE

303: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a23 out nocopy JTF_NUMBER_TABLE
305: , p6_a24 out nocopy JTF_DATE_TABLE
306: , p6_a25 out nocopy JTF_NUMBER_TABLE
307: , p6_a26 out nocopy JTF_DATE_TABLE
308: , p6_a27 out nocopy JTF_NUMBER_TABLE
309: );
310: procedure delete_row(p_api_version NUMBER
311: , p_init_msg_list VARCHAR2

Line 352: , p5_a3 JTF_DATE_TABLE

348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_DATE_TABLE
353: , p5_a4 JTF_DATE_TABLE
354: , p5_a5 JTF_VARCHAR2_TABLE_100
355: , p5_a6 JTF_NUMBER_TABLE
356: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 353: , p5_a4 JTF_DATE_TABLE

349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_DATE_TABLE
353: , p5_a4 JTF_DATE_TABLE
354: , p5_a5 JTF_VARCHAR2_TABLE_100
355: , p5_a6 JTF_NUMBER_TABLE
356: , p5_a7 JTF_VARCHAR2_TABLE_100
357: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 373: , p5_a24 JTF_DATE_TABLE

369: , p5_a20 JTF_VARCHAR2_TABLE_500
370: , p5_a21 JTF_VARCHAR2_TABLE_500
371: , p5_a22 JTF_VARCHAR2_TABLE_500
372: , p5_a23 JTF_NUMBER_TABLE
373: , p5_a24 JTF_DATE_TABLE
374: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a26 JTF_DATE_TABLE
376: , p5_a27 JTF_NUMBER_TABLE
377: );

Line 375: , p5_a26 JTF_DATE_TABLE

371: , p5_a22 JTF_VARCHAR2_TABLE_500
372: , p5_a23 JTF_NUMBER_TABLE
373: , p5_a24 JTF_DATE_TABLE
374: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a26 JTF_DATE_TABLE
376: , p5_a27 JTF_NUMBER_TABLE
377: );
378: end okl_eve_pvt_w;