eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SRV_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_srv_pvt_w as
2: /* $Header: OKLISRVB.pls 120.0 2005/07/07 10:40:54 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500

Line 90: , a2 out nocopy JTF_VARCHAR2_TABLE_100

86: end if;
87: end rosetta_table_copy_in_p1;
88: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , a6 out nocopy JTF_VARCHAR2_TABLE_100

90: , a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 98: , a10 out nocopy JTF_VARCHAR2_TABLE_100

94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_NUMBER_TABLE
96: , a8 out nocopy JTF_NUMBER_TABLE
97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100
102: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a13 out nocopy JTF_VARCHAR2_TABLE_100

97: , a9 out nocopy JTF_NUMBER_TABLE
98: , a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , a11 out nocopy JTF_NUMBER_TABLE
100: , a12 out nocopy JTF_NUMBER_TABLE
101: , a13 out nocopy JTF_VARCHAR2_TABLE_100
102: , a14 out nocopy JTF_VARCHAR2_TABLE_500
103: , a15 out nocopy JTF_VARCHAR2_TABLE_500
104: , a16 out nocopy JTF_VARCHAR2_TABLE_500
105: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: a2 := JTF_VARCHAR2_TABLE_100();

124: begin
125: if t is null or t.count = 0 then
126: a0 := JTF_NUMBER_TABLE();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();

Line 132: a6 := JTF_VARCHAR2_TABLE_100();

128: a2 := JTF_VARCHAR2_TABLE_100();
129: a3 := JTF_NUMBER_TABLE();
130: a4 := JTF_DATE_TABLE();
131: a5 := JTF_DATE_TABLE();
132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();

Line 136: a10 := JTF_VARCHAR2_TABLE_100();

132: a6 := JTF_VARCHAR2_TABLE_100();
133: a7 := JTF_NUMBER_TABLE();
134: a8 := JTF_NUMBER_TABLE();
135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();
140: a14 := JTF_VARCHAR2_TABLE_500();

Line 139: a13 := JTF_VARCHAR2_TABLE_100();

135: a9 := JTF_NUMBER_TABLE();
136: a10 := JTF_VARCHAR2_TABLE_100();
137: a11 := JTF_NUMBER_TABLE();
138: a12 := JTF_NUMBER_TABLE();
139: a13 := JTF_VARCHAR2_TABLE_100();
140: a14 := JTF_VARCHAR2_TABLE_500();
141: a15 := JTF_VARCHAR2_TABLE_500();
142: a16 := JTF_VARCHAR2_TABLE_500();
143: a17 := JTF_VARCHAR2_TABLE_500();

Line 163: a2 := JTF_VARCHAR2_TABLE_100();

159: a33 := JTF_NUMBER_TABLE();
160: else
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();

Line 167: a6 := JTF_VARCHAR2_TABLE_100();

163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_DATE_TABLE();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();

Line 171: a10 := JTF_VARCHAR2_TABLE_100();

167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_NUMBER_TABLE();
169: a8 := JTF_NUMBER_TABLE();
170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();
175: a14 := JTF_VARCHAR2_TABLE_500();

Line 174: a13 := JTF_VARCHAR2_TABLE_100();

170: a9 := JTF_NUMBER_TABLE();
171: a10 := JTF_VARCHAR2_TABLE_100();
172: a11 := JTF_NUMBER_TABLE();
173: a12 := JTF_NUMBER_TABLE();
174: a13 := JTF_VARCHAR2_TABLE_100();
175: a14 := JTF_VARCHAR2_TABLE_500();
176: a15 := JTF_VARCHAR2_TABLE_500();
177: a16 := JTF_VARCHAR2_TABLE_500();
178: a17 := JTF_VARCHAR2_TABLE_500();

Line 459: , p5_a2 JTF_VARCHAR2_TABLE_100

455: , x_msg_count out nocopy NUMBER
456: , x_msg_data out nocopy VARCHAR2
457: , p5_a0 JTF_NUMBER_TABLE
458: , p5_a1 JTF_NUMBER_TABLE
459: , p5_a2 JTF_VARCHAR2_TABLE_100
460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 463: , p5_a6 JTF_VARCHAR2_TABLE_100

459: , p5_a2 JTF_VARCHAR2_TABLE_100
460: , p5_a3 JTF_NUMBER_TABLE
461: , p5_a4 JTF_DATE_TABLE
462: , p5_a5 JTF_DATE_TABLE
463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 467: , p5_a10 JTF_VARCHAR2_TABLE_100

463: , p5_a6 JTF_VARCHAR2_TABLE_100
464: , p5_a7 JTF_NUMBER_TABLE
465: , p5_a8 JTF_NUMBER_TABLE
466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE
470: , p5_a13 JTF_VARCHAR2_TABLE_100
471: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 470: , p5_a13 JTF_VARCHAR2_TABLE_100

466: , p5_a9 JTF_NUMBER_TABLE
467: , p5_a10 JTF_VARCHAR2_TABLE_100
468: , p5_a11 JTF_NUMBER_TABLE
469: , p5_a12 JTF_NUMBER_TABLE
470: , p5_a13 JTF_VARCHAR2_TABLE_100
471: , p5_a14 JTF_VARCHAR2_TABLE_500
472: , p5_a15 JTF_VARCHAR2_TABLE_500
473: , p5_a16 JTF_VARCHAR2_TABLE_500
474: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

489: , p5_a32 JTF_DATE_TABLE
490: , p5_a33 JTF_NUMBER_TABLE
491: , p6_a0 out nocopy JTF_NUMBER_TABLE
492: , p6_a1 out nocopy JTF_NUMBER_TABLE
493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

493: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
494: , p6_a3 out nocopy JTF_NUMBER_TABLE
495: , p6_a4 out nocopy JTF_DATE_TABLE
496: , p6_a5 out nocopy JTF_DATE_TABLE
497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

497: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
498: , p6_a7 out nocopy JTF_NUMBER_TABLE
499: , p6_a8 out nocopy JTF_NUMBER_TABLE
500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

500: , p6_a9 out nocopy JTF_NUMBER_TABLE
501: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a11 out nocopy JTF_NUMBER_TABLE
503: , p6_a12 out nocopy JTF_NUMBER_TABLE
504: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
505: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
507: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
508: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 811: , p5_a2 JTF_VARCHAR2_TABLE_100

807: , x_msg_count out nocopy NUMBER
808: , x_msg_data out nocopy VARCHAR2
809: , p5_a0 JTF_NUMBER_TABLE
810: , p5_a1 JTF_NUMBER_TABLE
811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 815: , p5_a6 JTF_VARCHAR2_TABLE_100

811: , p5_a2 JTF_VARCHAR2_TABLE_100
812: , p5_a3 JTF_NUMBER_TABLE
813: , p5_a4 JTF_DATE_TABLE
814: , p5_a5 JTF_DATE_TABLE
815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 819: , p5_a10 JTF_VARCHAR2_TABLE_100

815: , p5_a6 JTF_VARCHAR2_TABLE_100
816: , p5_a7 JTF_NUMBER_TABLE
817: , p5_a8 JTF_NUMBER_TABLE
818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE
822: , p5_a13 JTF_VARCHAR2_TABLE_100
823: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 822: , p5_a13 JTF_VARCHAR2_TABLE_100

818: , p5_a9 JTF_NUMBER_TABLE
819: , p5_a10 JTF_VARCHAR2_TABLE_100
820: , p5_a11 JTF_NUMBER_TABLE
821: , p5_a12 JTF_NUMBER_TABLE
822: , p5_a13 JTF_VARCHAR2_TABLE_100
823: , p5_a14 JTF_VARCHAR2_TABLE_500
824: , p5_a15 JTF_VARCHAR2_TABLE_500
825: , p5_a16 JTF_VARCHAR2_TABLE_500
826: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

841: , p5_a32 JTF_DATE_TABLE
842: , p5_a33 JTF_NUMBER_TABLE
843: , p6_a0 out nocopy JTF_NUMBER_TABLE
844: , p6_a1 out nocopy JTF_NUMBER_TABLE
845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

845: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
846: , p6_a3 out nocopy JTF_NUMBER_TABLE
847: , p6_a4 out nocopy JTF_DATE_TABLE
848: , p6_a5 out nocopy JTF_DATE_TABLE
849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

849: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
850: , p6_a7 out nocopy JTF_NUMBER_TABLE
851: , p6_a8 out nocopy JTF_NUMBER_TABLE
852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE
856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

852: , p6_a9 out nocopy JTF_NUMBER_TABLE
853: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a11 out nocopy JTF_NUMBER_TABLE
855: , p6_a12 out nocopy JTF_NUMBER_TABLE
856: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
857: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
858: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
859: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
860: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 1091: , p5_a2 JTF_VARCHAR2_TABLE_100

1087: , x_msg_count out nocopy NUMBER
1088: , x_msg_data out nocopy VARCHAR2
1089: , p5_a0 JTF_NUMBER_TABLE
1090: , p5_a1 JTF_NUMBER_TABLE
1091: , p5_a2 JTF_VARCHAR2_TABLE_100
1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1095: , p5_a6 JTF_VARCHAR2_TABLE_100

1091: , p5_a2 JTF_VARCHAR2_TABLE_100
1092: , p5_a3 JTF_NUMBER_TABLE
1093: , p5_a4 JTF_DATE_TABLE
1094: , p5_a5 JTF_DATE_TABLE
1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 1099: , p5_a10 JTF_VARCHAR2_TABLE_100

1095: , p5_a6 JTF_VARCHAR2_TABLE_100
1096: , p5_a7 JTF_NUMBER_TABLE
1097: , p5_a8 JTF_NUMBER_TABLE
1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE
1102: , p5_a13 JTF_VARCHAR2_TABLE_100
1103: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 1102: , p5_a13 JTF_VARCHAR2_TABLE_100

1098: , p5_a9 JTF_NUMBER_TABLE
1099: , p5_a10 JTF_VARCHAR2_TABLE_100
1100: , p5_a11 JTF_NUMBER_TABLE
1101: , p5_a12 JTF_NUMBER_TABLE
1102: , p5_a13 JTF_VARCHAR2_TABLE_100
1103: , p5_a14 JTF_VARCHAR2_TABLE_500
1104: , p5_a15 JTF_VARCHAR2_TABLE_500
1105: , p5_a16 JTF_VARCHAR2_TABLE_500
1106: , p5_a17 JTF_VARCHAR2_TABLE_500