DBA Data[Home] [Help]

APPS.OKL_LRV_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

2: /* $Header: OKLILRVS.pls 120.1 2005/09/30 11:00:39 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_DATE_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 20: , a17 JTF_DATE_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100

Line 22: , a19 JTF_DATE_TABLE

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

Line 45: , a3 out nocopy JTF_DATE_TABLE

41: );
42: procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE

Line 46: , a4 out nocopy JTF_DATE_TABLE

42: procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE

Line 59: , a17 out nocopy JTF_DATE_TABLE

55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_NUMBER_TABLE
59: , a17 out nocopy JTF_DATE_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a19 out nocopy JTF_DATE_TABLE

57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_NUMBER_TABLE
59: , a17 out nocopy JTF_DATE_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_VARCHAR2_TABLE_100
64: , a22 out nocopy JTF_VARCHAR2_TABLE_500
65: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 85: , a3 JTF_DATE_TABLE

81:
82: procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_DATE_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE

Line 86: , a4 JTF_DATE_TABLE

82: procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_DATE_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE

Line 99: , a17 JTF_DATE_TABLE

95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_NUMBER_TABLE
99: , a17 JTF_DATE_TABLE
100: , a18 JTF_NUMBER_TABLE
101: , a19 JTF_DATE_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_VARCHAR2_TABLE_100

Line 101: , a19 JTF_DATE_TABLE

97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_NUMBER_TABLE
99: , a17 JTF_DATE_TABLE
100: , a18 JTF_NUMBER_TABLE
101: , a19 JTF_DATE_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_VARCHAR2_TABLE_100
104: , a22 JTF_VARCHAR2_TABLE_500
105: , a23 JTF_VARCHAR2_TABLE_500

Line 124: , a3 out nocopy JTF_DATE_TABLE

120: );
121: procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_NUMBER_TABLE
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_DATE_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_NUMBER_TABLE

Line 125: , a4 out nocopy JTF_DATE_TABLE

121: procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_NUMBER_TABLE
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_DATE_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_NUMBER_TABLE
129: , a8 out nocopy JTF_NUMBER_TABLE

Line 138: , a17 out nocopy JTF_DATE_TABLE

134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_NUMBER_TABLE
138: , a17 out nocopy JTF_DATE_TABLE
139: , a18 out nocopy JTF_NUMBER_TABLE
140: , a19 out nocopy JTF_DATE_TABLE
141: , a20 out nocopy JTF_NUMBER_TABLE
142: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a19 out nocopy JTF_DATE_TABLE

136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_NUMBER_TABLE
138: , a17 out nocopy JTF_DATE_TABLE
139: , a18 out nocopy JTF_NUMBER_TABLE
140: , a19 out nocopy JTF_DATE_TABLE
141: , a20 out nocopy JTF_NUMBER_TABLE
142: , a21 out nocopy JTF_VARCHAR2_TABLE_100
143: , a22 out nocopy JTF_VARCHAR2_TABLE_500
144: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 251: , p5_a3 JTF_DATE_TABLE

247: , x_msg_data out nocopy VARCHAR2
248: , p5_a0 JTF_NUMBER_TABLE
249: , p5_a1 JTF_NUMBER_TABLE
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_DATE_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_NUMBER_TABLE

Line 252: , p5_a4 JTF_DATE_TABLE

248: , p5_a0 JTF_NUMBER_TABLE
249: , p5_a1 JTF_NUMBER_TABLE
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_DATE_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_NUMBER_TABLE
256: , p5_a8 JTF_NUMBER_TABLE

Line 265: , p5_a17 JTF_DATE_TABLE

261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_VARCHAR2_TABLE_100
264: , p5_a16 JTF_NUMBER_TABLE
265: , p5_a17 JTF_DATE_TABLE
266: , p5_a18 JTF_NUMBER_TABLE
267: , p5_a19 JTF_DATE_TABLE
268: , p5_a20 JTF_NUMBER_TABLE
269: , p5_a21 JTF_VARCHAR2_TABLE_100

Line 267: , p5_a19 JTF_DATE_TABLE

263: , p5_a15 JTF_VARCHAR2_TABLE_100
264: , p5_a16 JTF_NUMBER_TABLE
265: , p5_a17 JTF_DATE_TABLE
266: , p5_a18 JTF_NUMBER_TABLE
267: , p5_a19 JTF_DATE_TABLE
268: , p5_a20 JTF_NUMBER_TABLE
269: , p5_a21 JTF_VARCHAR2_TABLE_100
270: , p5_a22 JTF_VARCHAR2_TABLE_500
271: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 289: , p6_a3 out nocopy JTF_DATE_TABLE

285: , p5_a37 JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_NUMBER_TABLE
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_DATE_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 290: , p6_a4 out nocopy JTF_DATE_TABLE

286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_NUMBER_TABLE
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_DATE_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_NUMBER_TABLE
294: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 303: , p6_a17 out nocopy JTF_DATE_TABLE

299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
302: , p6_a16 out nocopy JTF_NUMBER_TABLE
303: , p6_a17 out nocopy JTF_DATE_TABLE
304: , p6_a18 out nocopy JTF_NUMBER_TABLE
305: , p6_a19 out nocopy JTF_DATE_TABLE
306: , p6_a20 out nocopy JTF_NUMBER_TABLE
307: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p6_a19 out nocopy JTF_DATE_TABLE

301: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
302: , p6_a16 out nocopy JTF_NUMBER_TABLE
303: , p6_a17 out nocopy JTF_DATE_TABLE
304: , p6_a18 out nocopy JTF_NUMBER_TABLE
305: , p6_a19 out nocopy JTF_DATE_TABLE
306: , p6_a20 out nocopy JTF_NUMBER_TABLE
307: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
309: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 415: , p5_a3 JTF_DATE_TABLE

411: , x_msg_data out nocopy VARCHAR2
412: , p5_a0 JTF_NUMBER_TABLE
413: , p5_a1 JTF_NUMBER_TABLE
414: , p5_a2 JTF_VARCHAR2_TABLE_100
415: , p5_a3 JTF_DATE_TABLE
416: , p5_a4 JTF_DATE_TABLE
417: , p5_a5 JTF_NUMBER_TABLE
418: , p5_a6 JTF_NUMBER_TABLE
419: , p5_a7 JTF_NUMBER_TABLE

Line 416: , p5_a4 JTF_DATE_TABLE

412: , p5_a0 JTF_NUMBER_TABLE
413: , p5_a1 JTF_NUMBER_TABLE
414: , p5_a2 JTF_VARCHAR2_TABLE_100
415: , p5_a3 JTF_DATE_TABLE
416: , p5_a4 JTF_DATE_TABLE
417: , p5_a5 JTF_NUMBER_TABLE
418: , p5_a6 JTF_NUMBER_TABLE
419: , p5_a7 JTF_NUMBER_TABLE
420: , p5_a8 JTF_NUMBER_TABLE

Line 429: , p5_a17 JTF_DATE_TABLE

425: , p5_a13 JTF_NUMBER_TABLE
426: , p5_a14 JTF_NUMBER_TABLE
427: , p5_a15 JTF_VARCHAR2_TABLE_100
428: , p5_a16 JTF_NUMBER_TABLE
429: , p5_a17 JTF_DATE_TABLE
430: , p5_a18 JTF_NUMBER_TABLE
431: , p5_a19 JTF_DATE_TABLE
432: , p5_a20 JTF_NUMBER_TABLE
433: , p5_a21 JTF_VARCHAR2_TABLE_100

Line 431: , p5_a19 JTF_DATE_TABLE

427: , p5_a15 JTF_VARCHAR2_TABLE_100
428: , p5_a16 JTF_NUMBER_TABLE
429: , p5_a17 JTF_DATE_TABLE
430: , p5_a18 JTF_NUMBER_TABLE
431: , p5_a19 JTF_DATE_TABLE
432: , p5_a20 JTF_NUMBER_TABLE
433: , p5_a21 JTF_VARCHAR2_TABLE_100
434: , p5_a22 JTF_VARCHAR2_TABLE_500
435: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 453: , p6_a3 out nocopy JTF_DATE_TABLE

449: , p5_a37 JTF_NUMBER_TABLE
450: , p6_a0 out nocopy JTF_NUMBER_TABLE
451: , p6_a1 out nocopy JTF_NUMBER_TABLE
452: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
453: , p6_a3 out nocopy JTF_DATE_TABLE
454: , p6_a4 out nocopy JTF_DATE_TABLE
455: , p6_a5 out nocopy JTF_NUMBER_TABLE
456: , p6_a6 out nocopy JTF_NUMBER_TABLE
457: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 454: , p6_a4 out nocopy JTF_DATE_TABLE

450: , p6_a0 out nocopy JTF_NUMBER_TABLE
451: , p6_a1 out nocopy JTF_NUMBER_TABLE
452: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
453: , p6_a3 out nocopy JTF_DATE_TABLE
454: , p6_a4 out nocopy JTF_DATE_TABLE
455: , p6_a5 out nocopy JTF_NUMBER_TABLE
456: , p6_a6 out nocopy JTF_NUMBER_TABLE
457: , p6_a7 out nocopy JTF_NUMBER_TABLE
458: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 467: , p6_a17 out nocopy JTF_DATE_TABLE

463: , p6_a13 out nocopy JTF_NUMBER_TABLE
464: , p6_a14 out nocopy JTF_NUMBER_TABLE
465: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a16 out nocopy JTF_NUMBER_TABLE
467: , p6_a17 out nocopy JTF_DATE_TABLE
468: , p6_a18 out nocopy JTF_NUMBER_TABLE
469: , p6_a19 out nocopy JTF_DATE_TABLE
470: , p6_a20 out nocopy JTF_NUMBER_TABLE
471: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 469: , p6_a19 out nocopy JTF_DATE_TABLE

465: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a16 out nocopy JTF_NUMBER_TABLE
467: , p6_a17 out nocopy JTF_DATE_TABLE
468: , p6_a18 out nocopy JTF_NUMBER_TABLE
469: , p6_a19 out nocopy JTF_DATE_TABLE
470: , p6_a20 out nocopy JTF_NUMBER_TABLE
471: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
473: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 541: , p5_a3 JTF_DATE_TABLE

537: , x_msg_data out nocopy VARCHAR2
538: , p5_a0 JTF_NUMBER_TABLE
539: , p5_a1 JTF_NUMBER_TABLE
540: , p5_a2 JTF_VARCHAR2_TABLE_100
541: , p5_a3 JTF_DATE_TABLE
542: , p5_a4 JTF_DATE_TABLE
543: , p5_a5 JTF_NUMBER_TABLE
544: , p5_a6 JTF_NUMBER_TABLE
545: , p5_a7 JTF_NUMBER_TABLE

Line 542: , p5_a4 JTF_DATE_TABLE

538: , p5_a0 JTF_NUMBER_TABLE
539: , p5_a1 JTF_NUMBER_TABLE
540: , p5_a2 JTF_VARCHAR2_TABLE_100
541: , p5_a3 JTF_DATE_TABLE
542: , p5_a4 JTF_DATE_TABLE
543: , p5_a5 JTF_NUMBER_TABLE
544: , p5_a6 JTF_NUMBER_TABLE
545: , p5_a7 JTF_NUMBER_TABLE
546: , p5_a8 JTF_NUMBER_TABLE

Line 555: , p5_a17 JTF_DATE_TABLE

551: , p5_a13 JTF_NUMBER_TABLE
552: , p5_a14 JTF_NUMBER_TABLE
553: , p5_a15 JTF_VARCHAR2_TABLE_100
554: , p5_a16 JTF_NUMBER_TABLE
555: , p5_a17 JTF_DATE_TABLE
556: , p5_a18 JTF_NUMBER_TABLE
557: , p5_a19 JTF_DATE_TABLE
558: , p5_a20 JTF_NUMBER_TABLE
559: , p5_a21 JTF_VARCHAR2_TABLE_100

Line 557: , p5_a19 JTF_DATE_TABLE

553: , p5_a15 JTF_VARCHAR2_TABLE_100
554: , p5_a16 JTF_NUMBER_TABLE
555: , p5_a17 JTF_DATE_TABLE
556: , p5_a18 JTF_NUMBER_TABLE
557: , p5_a19 JTF_DATE_TABLE
558: , p5_a20 JTF_NUMBER_TABLE
559: , p5_a21 JTF_VARCHAR2_TABLE_100
560: , p5_a22 JTF_VARCHAR2_TABLE_500
561: , p5_a23 JTF_VARCHAR2_TABLE_500