DBA Data[Home] [Help]

APPS.OKL_GTT_PVT_W dependencies on JTF_DATE_TABLE

Line 7: , a4 JTF_DATE_TABLE

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

Line 8: , a5 JTF_DATE_TABLE

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

Line 28: , a25 JTF_DATE_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 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: );

Line 30: , a27 JTF_DATE_TABLE

26: , a23 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_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_DATE_TABLE

33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, 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_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_100
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 38: , a5 out nocopy JTF_DATE_TABLE

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

Line 58: , a25 out nocopy JTF_DATE_TABLE

54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 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: );

Line 60: , a27 out nocopy JTF_DATE_TABLE

56: , a23 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 rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE

Line 68: , a4 JTF_DATE_TABLE

64: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_DATE_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_VARCHAR2_TABLE_100
71: , a7 JTF_VARCHAR2_TABLE_100
72: , a8 JTF_VARCHAR2_TABLE_500

Line 69: , a5 JTF_DATE_TABLE

65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_DATE_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_VARCHAR2_TABLE_100
71: , a7 JTF_VARCHAR2_TABLE_100
72: , a8 JTF_VARCHAR2_TABLE_500
73: , a9 JTF_VARCHAR2_TABLE_500

Line 89: , a25 JTF_DATE_TABLE

85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );

Line 91: , a27 JTF_DATE_TABLE

87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE

Line 98: , a4 out nocopy JTF_DATE_TABLE

94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_DATE_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_100
101: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 99: , a5 out nocopy JTF_DATE_TABLE

95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_DATE_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_100
101: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500
103: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 119: , a25 out nocopy JTF_DATE_TABLE

115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );

Line 121: , a27 out nocopy JTF_DATE_TABLE

117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );
124:
125: procedure insert_row(p_api_version NUMBER

Line 198: , p5_a4 JTF_DATE_TABLE

194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_VARCHAR2_TABLE_100
202: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 199: , p5_a5 JTF_DATE_TABLE

195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
201: , p5_a7 JTF_VARCHAR2_TABLE_100
202: , p5_a8 JTF_VARCHAR2_TABLE_500
203: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 219: , p5_a25 JTF_DATE_TABLE

215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 221: , p5_a27 JTF_DATE_TABLE

217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 227: , p6_a4 out nocopy JTF_DATE_TABLE

223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_DATE_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 228: , p6_a5 out nocopy JTF_DATE_TABLE

224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_DATE_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 248: , p6_a25 out nocopy JTF_DATE_TABLE

244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );

Line 250: , p6_a27 out nocopy JTF_DATE_TABLE

246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );
253: procedure update_row(p_api_version NUMBER
254: , p_init_msg_list VARCHAR2

Line 326: , p5_a4 JTF_DATE_TABLE

322: , p5_a0 JTF_NUMBER_TABLE
323: , p5_a1 JTF_NUMBER_TABLE
324: , p5_a2 JTF_NUMBER_TABLE
325: , p5_a3 JTF_VARCHAR2_TABLE_100
326: , p5_a4 JTF_DATE_TABLE
327: , p5_a5 JTF_DATE_TABLE
328: , p5_a6 JTF_VARCHAR2_TABLE_100
329: , p5_a7 JTF_VARCHAR2_TABLE_100
330: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 327: , p5_a5 JTF_DATE_TABLE

323: , p5_a1 JTF_NUMBER_TABLE
324: , p5_a2 JTF_NUMBER_TABLE
325: , p5_a3 JTF_VARCHAR2_TABLE_100
326: , p5_a4 JTF_DATE_TABLE
327: , p5_a5 JTF_DATE_TABLE
328: , p5_a6 JTF_VARCHAR2_TABLE_100
329: , p5_a7 JTF_VARCHAR2_TABLE_100
330: , p5_a8 JTF_VARCHAR2_TABLE_500
331: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 347: , p5_a25 JTF_DATE_TABLE

343: , p5_a21 JTF_VARCHAR2_TABLE_500
344: , p5_a22 JTF_VARCHAR2_TABLE_500
345: , p5_a23 JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 349: , p5_a27 JTF_DATE_TABLE

345: , p5_a23 JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 355: , p6_a4 out nocopy JTF_DATE_TABLE

351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
355: , p6_a4 out nocopy JTF_DATE_TABLE
356: , p6_a5 out nocopy JTF_DATE_TABLE
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
358: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
359: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 356: , p6_a5 out nocopy JTF_DATE_TABLE

352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
355: , p6_a4 out nocopy JTF_DATE_TABLE
356: , p6_a5 out nocopy JTF_DATE_TABLE
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
358: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
359: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 376: , p6_a25 out nocopy JTF_DATE_TABLE

372: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
373: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a23 out nocopy JTF_NUMBER_TABLE
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
379: , p6_a28 out nocopy JTF_NUMBER_TABLE
380: );

Line 378: , p6_a27 out nocopy JTF_DATE_TABLE

374: , p6_a23 out nocopy JTF_NUMBER_TABLE
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
379: , p6_a28 out nocopy JTF_NUMBER_TABLE
380: );
381: procedure delete_row(p_api_version NUMBER
382: , p_init_msg_list VARCHAR2

Line 425: , p5_a4 JTF_DATE_TABLE

421: , p5_a0 JTF_NUMBER_TABLE
422: , p5_a1 JTF_NUMBER_TABLE
423: , p5_a2 JTF_NUMBER_TABLE
424: , p5_a3 JTF_VARCHAR2_TABLE_100
425: , p5_a4 JTF_DATE_TABLE
426: , p5_a5 JTF_DATE_TABLE
427: , p5_a6 JTF_VARCHAR2_TABLE_100
428: , p5_a7 JTF_VARCHAR2_TABLE_100
429: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 426: , p5_a5 JTF_DATE_TABLE

422: , p5_a1 JTF_NUMBER_TABLE
423: , p5_a2 JTF_NUMBER_TABLE
424: , p5_a3 JTF_VARCHAR2_TABLE_100
425: , p5_a4 JTF_DATE_TABLE
426: , p5_a5 JTF_DATE_TABLE
427: , p5_a6 JTF_VARCHAR2_TABLE_100
428: , p5_a7 JTF_VARCHAR2_TABLE_100
429: , p5_a8 JTF_VARCHAR2_TABLE_500
430: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 446: , p5_a25 JTF_DATE_TABLE

442: , p5_a21 JTF_VARCHAR2_TABLE_500
443: , p5_a22 JTF_VARCHAR2_TABLE_500
444: , p5_a23 JTF_NUMBER_TABLE
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
449: , p5_a28 JTF_NUMBER_TABLE
450: );

Line 448: , p5_a27 JTF_DATE_TABLE

444: , p5_a23 JTF_NUMBER_TABLE
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
449: , p5_a28 JTF_NUMBER_TABLE
450: );
451: end okl_gtt_pvt_w;