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_QQL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_qql_pvt_w as
2: /* $Header: OKLIQQLB.pls 120.0 2005/09/27 05:29:45 schodava noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_qql_pvt.qqlv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 22: , a19 JTF_VARCHAR2_TABLE_100

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

Line 23: , a20 JTF_VARCHAR2_TABLE_100

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

Line 84: , a2 out nocopy JTF_VARCHAR2_TABLE_100

80: end if;
81: end rosetta_table_copy_in_p23;
82: procedure rosetta_table_copy_out_p23(t okl_qql_pvt.qqlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_VARCHAR2_TABLE_100
85: , a3 out nocopy JTF_VARCHAR2_TABLE_500
86: , a4 out nocopy JTF_VARCHAR2_TABLE_500
87: , a5 out nocopy JTF_VARCHAR2_TABLE_500
88: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a19 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 102: , a20 out nocopy JTF_VARCHAR2_TABLE_100

98: , a16 out nocopy JTF_VARCHAR2_TABLE_500
99: , a17 out nocopy JTF_VARCHAR2_TABLE_500
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_VARCHAR2_TABLE_100
102: , a20 out nocopy JTF_VARCHAR2_TABLE_100
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_NUMBER_TABLE
106: , a24 out nocopy JTF_NUMBER_TABLE

Line 119: a2 := JTF_VARCHAR2_TABLE_100();

115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_100();
120: a3 := JTF_VARCHAR2_TABLE_500();
121: a4 := JTF_VARCHAR2_TABLE_500();
122: a5 := JTF_VARCHAR2_TABLE_500();
123: a6 := JTF_VARCHAR2_TABLE_500();

Line 136: a19 := JTF_VARCHAR2_TABLE_100();

132: a15 := JTF_VARCHAR2_TABLE_500();
133: a16 := JTF_VARCHAR2_TABLE_500();
134: a17 := JTF_VARCHAR2_TABLE_500();
135: a18 := JTF_NUMBER_TABLE();
136: a19 := JTF_VARCHAR2_TABLE_100();
137: a20 := JTF_VARCHAR2_TABLE_100();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();

Line 137: a20 := JTF_VARCHAR2_TABLE_100();

133: a16 := JTF_VARCHAR2_TABLE_500();
134: a17 := JTF_VARCHAR2_TABLE_500();
135: a18 := JTF_NUMBER_TABLE();
136: a19 := JTF_VARCHAR2_TABLE_100();
137: a20 := JTF_VARCHAR2_TABLE_100();
138: a21 := JTF_NUMBER_TABLE();
139: a22 := JTF_NUMBER_TABLE();
140: a23 := JTF_NUMBER_TABLE();
141: a24 := JTF_NUMBER_TABLE();

Line 151: a2 := JTF_VARCHAR2_TABLE_100();

147: a30 := JTF_VARCHAR2_TABLE_2000();
148: else
149: a0 := JTF_NUMBER_TABLE();
150: a1 := JTF_NUMBER_TABLE();
151: a2 := JTF_VARCHAR2_TABLE_100();
152: a3 := JTF_VARCHAR2_TABLE_500();
153: a4 := JTF_VARCHAR2_TABLE_500();
154: a5 := JTF_VARCHAR2_TABLE_500();
155: a6 := JTF_VARCHAR2_TABLE_500();

Line 168: a19 := JTF_VARCHAR2_TABLE_100();

164: a15 := JTF_VARCHAR2_TABLE_500();
165: a16 := JTF_VARCHAR2_TABLE_500();
166: a17 := JTF_VARCHAR2_TABLE_500();
167: a18 := JTF_NUMBER_TABLE();
168: a19 := JTF_VARCHAR2_TABLE_100();
169: a20 := JTF_VARCHAR2_TABLE_100();
170: a21 := JTF_NUMBER_TABLE();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();

Line 169: a20 := JTF_VARCHAR2_TABLE_100();

165: a16 := JTF_VARCHAR2_TABLE_500();
166: a17 := JTF_VARCHAR2_TABLE_500();
167: a18 := JTF_NUMBER_TABLE();
168: a19 := JTF_VARCHAR2_TABLE_100();
169: a20 := JTF_VARCHAR2_TABLE_100();
170: a21 := JTF_NUMBER_TABLE();
171: a22 := JTF_NUMBER_TABLE();
172: a23 := JTF_NUMBER_TABLE();
173: a24 := JTF_NUMBER_TABLE();

Line 263: , p5_a2 JTF_VARCHAR2_TABLE_100

259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_VARCHAR2_TABLE_100
264: , p5_a3 JTF_VARCHAR2_TABLE_500
265: , p5_a4 JTF_VARCHAR2_TABLE_500
266: , p5_a5 JTF_VARCHAR2_TABLE_500
267: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 280: , p5_a19 JTF_VARCHAR2_TABLE_100

276: , p5_a15 JTF_VARCHAR2_TABLE_500
277: , p5_a16 JTF_VARCHAR2_TABLE_500
278: , p5_a17 JTF_VARCHAR2_TABLE_500
279: , p5_a18 JTF_NUMBER_TABLE
280: , p5_a19 JTF_VARCHAR2_TABLE_100
281: , p5_a20 JTF_VARCHAR2_TABLE_100
282: , p5_a21 JTF_NUMBER_TABLE
283: , p5_a22 JTF_NUMBER_TABLE
284: , p5_a23 JTF_NUMBER_TABLE

Line 281: , p5_a20 JTF_VARCHAR2_TABLE_100

277: , p5_a16 JTF_VARCHAR2_TABLE_500
278: , p5_a17 JTF_VARCHAR2_TABLE_500
279: , p5_a18 JTF_NUMBER_TABLE
280: , p5_a19 JTF_VARCHAR2_TABLE_100
281: , p5_a20 JTF_VARCHAR2_TABLE_100
282: , p5_a21 JTF_NUMBER_TABLE
283: , p5_a22 JTF_NUMBER_TABLE
284: , p5_a23 JTF_NUMBER_TABLE
285: , p5_a24 JTF_NUMBER_TABLE

Line 294: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

290: , p5_a29 JTF_VARCHAR2_TABLE_2000
291: , p5_a30 JTF_VARCHAR2_TABLE_2000
292: , p6_a0 out nocopy JTF_NUMBER_TABLE
293: , p6_a1 out nocopy JTF_NUMBER_TABLE
294: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
295: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
296: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
297: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
298: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 311: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

307: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
309: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
310: , p6_a18 out nocopy JTF_NUMBER_TABLE
311: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
312: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a21 out nocopy JTF_NUMBER_TABLE
314: , p6_a22 out nocopy JTF_NUMBER_TABLE
315: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 312: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

308: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
309: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
310: , p6_a18 out nocopy JTF_NUMBER_TABLE
311: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
312: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a21 out nocopy JTF_NUMBER_TABLE
314: , p6_a22 out nocopy JTF_NUMBER_TABLE
315: , p6_a23 out nocopy JTF_NUMBER_TABLE
316: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 428: , p5_a2 JTF_VARCHAR2_TABLE_100

424: , x_msg_count out nocopy NUMBER
425: , x_msg_data out nocopy VARCHAR2
426: , p5_a0 JTF_NUMBER_TABLE
427: , p5_a1 JTF_NUMBER_TABLE
428: , p5_a2 JTF_VARCHAR2_TABLE_100
429: , p5_a3 JTF_VARCHAR2_TABLE_500
430: , p5_a4 JTF_VARCHAR2_TABLE_500
431: , p5_a5 JTF_VARCHAR2_TABLE_500
432: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 445: , p5_a19 JTF_VARCHAR2_TABLE_100

441: , p5_a15 JTF_VARCHAR2_TABLE_500
442: , p5_a16 JTF_VARCHAR2_TABLE_500
443: , p5_a17 JTF_VARCHAR2_TABLE_500
444: , p5_a18 JTF_NUMBER_TABLE
445: , p5_a19 JTF_VARCHAR2_TABLE_100
446: , p5_a20 JTF_VARCHAR2_TABLE_100
447: , p5_a21 JTF_NUMBER_TABLE
448: , p5_a22 JTF_NUMBER_TABLE
449: , p5_a23 JTF_NUMBER_TABLE

Line 446: , p5_a20 JTF_VARCHAR2_TABLE_100

442: , p5_a16 JTF_VARCHAR2_TABLE_500
443: , p5_a17 JTF_VARCHAR2_TABLE_500
444: , p5_a18 JTF_NUMBER_TABLE
445: , p5_a19 JTF_VARCHAR2_TABLE_100
446: , p5_a20 JTF_VARCHAR2_TABLE_100
447: , p5_a21 JTF_NUMBER_TABLE
448: , p5_a22 JTF_NUMBER_TABLE
449: , p5_a23 JTF_NUMBER_TABLE
450: , p5_a24 JTF_NUMBER_TABLE

Line 459: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

455: , p5_a29 JTF_VARCHAR2_TABLE_2000
456: , p5_a30 JTF_VARCHAR2_TABLE_2000
457: , p6_a0 out nocopy JTF_NUMBER_TABLE
458: , p6_a1 out nocopy JTF_NUMBER_TABLE
459: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
461: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
462: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 476: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

472: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
473: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
474: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
475: , p6_a18 out nocopy JTF_NUMBER_TABLE
476: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a21 out nocopy JTF_NUMBER_TABLE
479: , p6_a22 out nocopy JTF_NUMBER_TABLE
480: , p6_a23 out nocopy JTF_NUMBER_TABLE

Line 477: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100

473: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
474: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
475: , p6_a18 out nocopy JTF_NUMBER_TABLE
476: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
478: , p6_a21 out nocopy JTF_NUMBER_TABLE
479: , p6_a22 out nocopy JTF_NUMBER_TABLE
480: , p6_a23 out nocopy JTF_NUMBER_TABLE
481: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 593: , p5_a2 JTF_VARCHAR2_TABLE_100

589: , x_msg_count out nocopy NUMBER
590: , x_msg_data out nocopy VARCHAR2
591: , p5_a0 JTF_NUMBER_TABLE
592: , p5_a1 JTF_NUMBER_TABLE
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_VARCHAR2_TABLE_500
595: , p5_a4 JTF_VARCHAR2_TABLE_500
596: , p5_a5 JTF_VARCHAR2_TABLE_500
597: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 610: , p5_a19 JTF_VARCHAR2_TABLE_100

606: , p5_a15 JTF_VARCHAR2_TABLE_500
607: , p5_a16 JTF_VARCHAR2_TABLE_500
608: , p5_a17 JTF_VARCHAR2_TABLE_500
609: , p5_a18 JTF_NUMBER_TABLE
610: , p5_a19 JTF_VARCHAR2_TABLE_100
611: , p5_a20 JTF_VARCHAR2_TABLE_100
612: , p5_a21 JTF_NUMBER_TABLE
613: , p5_a22 JTF_NUMBER_TABLE
614: , p5_a23 JTF_NUMBER_TABLE

Line 611: , p5_a20 JTF_VARCHAR2_TABLE_100

607: , p5_a16 JTF_VARCHAR2_TABLE_500
608: , p5_a17 JTF_VARCHAR2_TABLE_500
609: , p5_a18 JTF_NUMBER_TABLE
610: , p5_a19 JTF_VARCHAR2_TABLE_100
611: , p5_a20 JTF_VARCHAR2_TABLE_100
612: , p5_a21 JTF_NUMBER_TABLE
613: , p5_a22 JTF_NUMBER_TABLE
614: , p5_a23 JTF_NUMBER_TABLE
615: , p5_a24 JTF_NUMBER_TABLE