DBA Data[Home] [Help]

APPS.OKL_EVE_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

2: /* $Header: OKLIEVEB.pls 120.0 2005/07/07 10:39:26 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: ) as

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: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin

Line 79: , a3 out nocopy JTF_DATE_TABLE

75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a4 out nocopy JTF_DATE_TABLE

76: procedure rosetta_table_copy_out_p1(t okl_eve_pvt.okl_eve_tbl, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_NUMBER_TABLE
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_DATE_TABLE
80: , a4 out nocopy JTF_DATE_TABLE
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_NUMBER_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 100: , a24 out nocopy JTF_DATE_TABLE

96: , a20 out nocopy JTF_VARCHAR2_TABLE_500
97: , a21 out nocopy JTF_VARCHAR2_TABLE_500
98: , a22 out nocopy JTF_VARCHAR2_TABLE_500
99: , a23 out nocopy JTF_NUMBER_TABLE
100: , a24 out nocopy JTF_DATE_TABLE
101: , a25 out nocopy JTF_NUMBER_TABLE
102: , a26 out nocopy JTF_DATE_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as

Line 102: , a26 out nocopy JTF_DATE_TABLE

98: , a22 out nocopy JTF_VARCHAR2_TABLE_500
99: , a23 out nocopy JTF_NUMBER_TABLE
100: , a24 out nocopy JTF_DATE_TABLE
101: , a25 out nocopy JTF_NUMBER_TABLE
102: , a26 out nocopy JTF_DATE_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as
105: ddindx binary_integer; indx binary_integer;
106: begin

Line 111: a3 := JTF_DATE_TABLE();

107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();

Line 112: a4 := JTF_DATE_TABLE();

108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_DATE_TABLE();
112: a4 := JTF_DATE_TABLE();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_NUMBER_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_VARCHAR2_TABLE_500();

Line 132: a24 := JTF_DATE_TABLE();

128: a20 := JTF_VARCHAR2_TABLE_500();
129: a21 := JTF_VARCHAR2_TABLE_500();
130: a22 := JTF_VARCHAR2_TABLE_500();
131: a23 := JTF_NUMBER_TABLE();
132: a24 := JTF_DATE_TABLE();
133: a25 := JTF_NUMBER_TABLE();
134: a26 := JTF_DATE_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else

Line 134: a26 := JTF_DATE_TABLE();

130: a22 := JTF_VARCHAR2_TABLE_500();
131: a23 := JTF_NUMBER_TABLE();
132: a24 := JTF_DATE_TABLE();
133: a25 := JTF_NUMBER_TABLE();
134: a26 := JTF_DATE_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();

Line 140: a3 := JTF_DATE_TABLE();

136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();

Line 141: a4 := JTF_DATE_TABLE();

137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_NUMBER_TABLE();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_DATE_TABLE();
141: a4 := JTF_DATE_TABLE();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_NUMBER_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_VARCHAR2_TABLE_500();

Line 161: a24 := JTF_DATE_TABLE();

157: a20 := JTF_VARCHAR2_TABLE_500();
158: a21 := JTF_VARCHAR2_TABLE_500();
159: a22 := JTF_VARCHAR2_TABLE_500();
160: a23 := JTF_NUMBER_TABLE();
161: a24 := JTF_DATE_TABLE();
162: a25 := JTF_NUMBER_TABLE();
163: a26 := JTF_DATE_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then

Line 163: a26 := JTF_DATE_TABLE();

159: a22 := JTF_VARCHAR2_TABLE_500();
160: a23 := JTF_NUMBER_TABLE();
161: a24 := JTF_DATE_TABLE();
162: a25 := JTF_NUMBER_TABLE();
163: a26 := JTF_DATE_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then
166: a0.extend(t.count);
167: a1.extend(t.count);

Line 394: , p5_a3 JTF_DATE_TABLE

390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 395: , p5_a4 JTF_DATE_TABLE

391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_DATE_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_VARCHAR2_TABLE_100
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_100
399: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 415: , p5_a24 JTF_DATE_TABLE

411: , p5_a20 JTF_VARCHAR2_TABLE_500
412: , p5_a21 JTF_VARCHAR2_TABLE_500
413: , p5_a22 JTF_VARCHAR2_TABLE_500
414: , p5_a23 JTF_NUMBER_TABLE
415: , p5_a24 JTF_DATE_TABLE
416: , p5_a25 JTF_NUMBER_TABLE
417: , p5_a26 JTF_DATE_TABLE
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 417: , p5_a26 JTF_DATE_TABLE

413: , p5_a22 JTF_VARCHAR2_TABLE_500
414: , p5_a23 JTF_NUMBER_TABLE
415: , p5_a24 JTF_DATE_TABLE
416: , p5_a25 JTF_NUMBER_TABLE
417: , p5_a26 JTF_DATE_TABLE
418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p6_a3 out nocopy JTF_DATE_TABLE

418: , p5_a27 JTF_NUMBER_TABLE
419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , p6_a4 out nocopy JTF_DATE_TABLE

419: , p6_a0 out nocopy JTF_NUMBER_TABLE
420: , p6_a1 out nocopy JTF_NUMBER_TABLE
421: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a3 out nocopy JTF_DATE_TABLE
423: , p6_a4 out nocopy JTF_DATE_TABLE
424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
425: , p6_a6 out nocopy JTF_NUMBER_TABLE
426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 443: , p6_a24 out nocopy JTF_DATE_TABLE

439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a23 out nocopy JTF_NUMBER_TABLE
443: , p6_a24 out nocopy JTF_DATE_TABLE
444: , p6_a25 out nocopy JTF_NUMBER_TABLE
445: , p6_a26 out nocopy JTF_DATE_TABLE
446: , p6_a27 out nocopy JTF_NUMBER_TABLE
447: )

Line 445: , p6_a26 out nocopy JTF_DATE_TABLE

441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a23 out nocopy JTF_NUMBER_TABLE
443: , p6_a24 out nocopy JTF_DATE_TABLE
444: , p6_a25 out nocopy JTF_NUMBER_TABLE
445: , p6_a26 out nocopy JTF_DATE_TABLE
446: , p6_a27 out nocopy JTF_NUMBER_TABLE
447: )
448:
449: as

Line 698: , p5_a3 JTF_DATE_TABLE

694: , x_msg_data out nocopy VARCHAR2
695: , p5_a0 JTF_NUMBER_TABLE
696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 699: , p5_a4 JTF_DATE_TABLE

695: , p5_a0 JTF_NUMBER_TABLE
696: , p5_a1 JTF_NUMBER_TABLE
697: , p5_a2 JTF_VARCHAR2_TABLE_100
698: , p5_a3 JTF_DATE_TABLE
699: , p5_a4 JTF_DATE_TABLE
700: , p5_a5 JTF_VARCHAR2_TABLE_100
701: , p5_a6 JTF_NUMBER_TABLE
702: , p5_a7 JTF_VARCHAR2_TABLE_100
703: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 719: , p5_a24 JTF_DATE_TABLE

715: , p5_a20 JTF_VARCHAR2_TABLE_500
716: , p5_a21 JTF_VARCHAR2_TABLE_500
717: , p5_a22 JTF_VARCHAR2_TABLE_500
718: , p5_a23 JTF_NUMBER_TABLE
719: , p5_a24 JTF_DATE_TABLE
720: , p5_a25 JTF_NUMBER_TABLE
721: , p5_a26 JTF_DATE_TABLE
722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 721: , p5_a26 JTF_DATE_TABLE

717: , p5_a22 JTF_VARCHAR2_TABLE_500
718: , p5_a23 JTF_NUMBER_TABLE
719: , p5_a24 JTF_DATE_TABLE
720: , p5_a25 JTF_NUMBER_TABLE
721: , p5_a26 JTF_DATE_TABLE
722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 726: , p6_a3 out nocopy JTF_DATE_TABLE

722: , p5_a27 JTF_NUMBER_TABLE
723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 727: , p6_a4 out nocopy JTF_DATE_TABLE

723: , p6_a0 out nocopy JTF_NUMBER_TABLE
724: , p6_a1 out nocopy JTF_NUMBER_TABLE
725: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
726: , p6_a3 out nocopy JTF_DATE_TABLE
727: , p6_a4 out nocopy JTF_DATE_TABLE
728: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a6 out nocopy JTF_NUMBER_TABLE
730: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
731: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 747: , p6_a24 out nocopy JTF_DATE_TABLE

743: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
744: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
745: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
746: , p6_a23 out nocopy JTF_NUMBER_TABLE
747: , p6_a24 out nocopy JTF_DATE_TABLE
748: , p6_a25 out nocopy JTF_NUMBER_TABLE
749: , p6_a26 out nocopy JTF_DATE_TABLE
750: , p6_a27 out nocopy JTF_NUMBER_TABLE
751: )

Line 749: , p6_a26 out nocopy JTF_DATE_TABLE

745: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
746: , p6_a23 out nocopy JTF_NUMBER_TABLE
747: , p6_a24 out nocopy JTF_DATE_TABLE
748: , p6_a25 out nocopy JTF_NUMBER_TABLE
749: , p6_a26 out nocopy JTF_DATE_TABLE
750: , p6_a27 out nocopy JTF_NUMBER_TABLE
751: )
752:
753: as

Line 942: , p5_a3 JTF_DATE_TABLE

938: , x_msg_data out nocopy VARCHAR2
939: , p5_a0 JTF_NUMBER_TABLE
940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 943: , p5_a4 JTF_DATE_TABLE

939: , p5_a0 JTF_NUMBER_TABLE
940: , p5_a1 JTF_NUMBER_TABLE
941: , p5_a2 JTF_VARCHAR2_TABLE_100
942: , p5_a3 JTF_DATE_TABLE
943: , p5_a4 JTF_DATE_TABLE
944: , p5_a5 JTF_VARCHAR2_TABLE_100
945: , p5_a6 JTF_NUMBER_TABLE
946: , p5_a7 JTF_VARCHAR2_TABLE_100
947: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 963: , p5_a24 JTF_DATE_TABLE

959: , p5_a20 JTF_VARCHAR2_TABLE_500
960: , p5_a21 JTF_VARCHAR2_TABLE_500
961: , p5_a22 JTF_VARCHAR2_TABLE_500
962: , p5_a23 JTF_NUMBER_TABLE
963: , p5_a24 JTF_DATE_TABLE
964: , p5_a25 JTF_NUMBER_TABLE
965: , p5_a26 JTF_DATE_TABLE
966: , p5_a27 JTF_NUMBER_TABLE
967: )

Line 965: , p5_a26 JTF_DATE_TABLE

961: , p5_a22 JTF_VARCHAR2_TABLE_500
962: , p5_a23 JTF_NUMBER_TABLE
963: , p5_a24 JTF_DATE_TABLE
964: , p5_a25 JTF_NUMBER_TABLE
965: , p5_a26 JTF_DATE_TABLE
966: , p5_a27 JTF_NUMBER_TABLE
967: )
968:
969: as