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_PQY_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pqy_pvt.pqy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_DATE_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_2000

22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pqy_pvt.pqy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE

Line 64: , a1 out nocopy JTF_VARCHAR2_TABLE_200

60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t okl_pqy_pvt.pqy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_200
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
68: , a5 out nocopy JTF_DATE_TABLE

Line 67: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

63: procedure rosetta_table_copy_out_p2(t okl_pqy_pvt.pqy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_VARCHAR2_TABLE_200
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
68: , a5 out nocopy JTF_DATE_TABLE
69: , a6 out nocopy JTF_DATE_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE

Line 80: a1 := JTF_VARCHAR2_TABLE_200();

76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_200();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_2000();
84: a5 := JTF_DATE_TABLE();

Line 83: a4 := JTF_VARCHAR2_TABLE_2000();

79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_VARCHAR2_TABLE_200();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_VARCHAR2_TABLE_2000();
84: a5 := JTF_DATE_TABLE();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();

Line 93: a1 := JTF_VARCHAR2_TABLE_200();

89: a10 := JTF_DATE_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_VARCHAR2_TABLE_200();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_NUMBER_TABLE();
96: a4 := JTF_VARCHAR2_TABLE_2000();
97: a5 := JTF_DATE_TABLE();

Line 96: a4 := JTF_VARCHAR2_TABLE_2000();

92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_VARCHAR2_TABLE_200();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_NUMBER_TABLE();
96: a4 := JTF_VARCHAR2_TABLE_2000();
97: a5 := JTF_DATE_TABLE();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();

Line 144: , a2 JTF_VARCHAR2_TABLE_200

140: end rosetta_table_copy_out_p2;
141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqy_pvt.pqyv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_VARCHAR2_TABLE_200
145: , a3 JTF_VARCHAR2_TABLE_2000
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_DATE_TABLE
148: , a6 JTF_DATE_TABLE

Line 145: , a3 JTF_VARCHAR2_TABLE_2000

141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqy_pvt.pqyv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_VARCHAR2_TABLE_200
145: , a3 JTF_VARCHAR2_TABLE_2000
146: , a4 JTF_VARCHAR2_TABLE_100
147: , a5 JTF_DATE_TABLE
148: , a6 JTF_DATE_TABLE
149: , a7 JTF_NUMBER_TABLE

Line 185: , a2 out nocopy JTF_VARCHAR2_TABLE_200

181: end if;
182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_pqy_pvt.pqyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_VARCHAR2_TABLE_200
186: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_DATE_TABLE
189: , a6 out nocopy JTF_DATE_TABLE

Line 186: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_pqy_pvt.pqyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_VARCHAR2_TABLE_200
186: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_DATE_TABLE
189: , a6 out nocopy JTF_DATE_TABLE
190: , a7 out nocopy JTF_NUMBER_TABLE

Line 201: a2 := JTF_VARCHAR2_TABLE_200();

197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_200();
202: a3 := JTF_VARCHAR2_TABLE_2000();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_DATE_TABLE();

Line 202: a3 := JTF_VARCHAR2_TABLE_2000();

198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_200();
202: a3 := JTF_VARCHAR2_TABLE_2000();
203: a4 := JTF_VARCHAR2_TABLE_100();
204: a5 := JTF_DATE_TABLE();
205: a6 := JTF_DATE_TABLE();
206: a7 := JTF_NUMBER_TABLE();

Line 214: a2 := JTF_VARCHAR2_TABLE_200();

210: a11 := JTF_NUMBER_TABLE();
211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_200();
215: a3 := JTF_VARCHAR2_TABLE_2000();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_DATE_TABLE();
218: a6 := JTF_DATE_TABLE();

Line 215: a3 := JTF_VARCHAR2_TABLE_2000();

211: else
212: a0 := JTF_NUMBER_TABLE();
213: a1 := JTF_NUMBER_TABLE();
214: a2 := JTF_VARCHAR2_TABLE_200();
215: a3 := JTF_VARCHAR2_TABLE_2000();
216: a4 := JTF_VARCHAR2_TABLE_100();
217: a5 := JTF_DATE_TABLE();
218: a6 := JTF_DATE_TABLE();
219: a7 := JTF_NUMBER_TABLE();

Line 356: , p5_a2 JTF_VARCHAR2_TABLE_200

352: , x_msg_count out nocopy NUMBER
353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_200
357: , p5_a3 JTF_VARCHAR2_TABLE_2000
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_DATE_TABLE
360: , p5_a6 JTF_DATE_TABLE

Line 357: , p5_a3 JTF_VARCHAR2_TABLE_2000

353: , x_msg_data out nocopy VARCHAR2
354: , p5_a0 JTF_NUMBER_TABLE
355: , p5_a1 JTF_NUMBER_TABLE
356: , p5_a2 JTF_VARCHAR2_TABLE_200
357: , p5_a3 JTF_VARCHAR2_TABLE_2000
358: , p5_a4 JTF_VARCHAR2_TABLE_100
359: , p5_a5 JTF_DATE_TABLE
360: , p5_a6 JTF_DATE_TABLE
361: , p5_a7 JTF_NUMBER_TABLE

Line 368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

364: , p5_a10 JTF_DATE_TABLE
365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_DATE_TABLE
372: , p6_a6 out nocopy JTF_DATE_TABLE

Line 369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

365: , p5_a11 JTF_NUMBER_TABLE
366: , p6_a0 out nocopy JTF_NUMBER_TABLE
367: , p6_a1 out nocopy JTF_NUMBER_TABLE
368: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
369: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
370: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
371: , p6_a5 out nocopy JTF_DATE_TABLE
372: , p6_a6 out nocopy JTF_DATE_TABLE
373: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 504: , p5_a2 JTF_VARCHAR2_TABLE_200

500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_VARCHAR2_TABLE_200
505: , p5_a3 JTF_VARCHAR2_TABLE_2000
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_DATE_TABLE
508: , p5_a6 JTF_DATE_TABLE

Line 505: , p5_a3 JTF_VARCHAR2_TABLE_2000

501: , x_msg_data out nocopy VARCHAR2
502: , p5_a0 JTF_NUMBER_TABLE
503: , p5_a1 JTF_NUMBER_TABLE
504: , p5_a2 JTF_VARCHAR2_TABLE_200
505: , p5_a3 JTF_VARCHAR2_TABLE_2000
506: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , p5_a5 JTF_DATE_TABLE
508: , p5_a6 JTF_DATE_TABLE
509: , p5_a7 JTF_NUMBER_TABLE

Line 651: , p5_a2 JTF_VARCHAR2_TABLE_200

647: , x_msg_count out nocopy NUMBER
648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_200
652: , p5_a3 JTF_VARCHAR2_TABLE_2000
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_DATE_TABLE
655: , p5_a6 JTF_DATE_TABLE

Line 652: , p5_a3 JTF_VARCHAR2_TABLE_2000

648: , x_msg_data out nocopy VARCHAR2
649: , p5_a0 JTF_NUMBER_TABLE
650: , p5_a1 JTF_NUMBER_TABLE
651: , p5_a2 JTF_VARCHAR2_TABLE_200
652: , p5_a3 JTF_VARCHAR2_TABLE_2000
653: , p5_a4 JTF_VARCHAR2_TABLE_100
654: , p5_a5 JTF_DATE_TABLE
655: , p5_a6 JTF_DATE_TABLE
656: , p5_a7 JTF_NUMBER_TABLE

Line 663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

659: , p5_a10 JTF_DATE_TABLE
660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_DATE_TABLE
667: , p6_a6 out nocopy JTF_DATE_TABLE

Line 664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

660: , p5_a11 JTF_NUMBER_TABLE
661: , p6_a0 out nocopy JTF_NUMBER_TABLE
662: , p6_a1 out nocopy JTF_NUMBER_TABLE
663: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
664: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
666: , p6_a5 out nocopy JTF_DATE_TABLE
667: , p6_a6 out nocopy JTF_DATE_TABLE
668: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 799: , p5_a2 JTF_VARCHAR2_TABLE_200

795: , x_msg_count out nocopy NUMBER
796: , x_msg_data out nocopy VARCHAR2
797: , p5_a0 JTF_NUMBER_TABLE
798: , p5_a1 JTF_NUMBER_TABLE
799: , p5_a2 JTF_VARCHAR2_TABLE_200
800: , p5_a3 JTF_VARCHAR2_TABLE_2000
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_DATE_TABLE
803: , p5_a6 JTF_DATE_TABLE

Line 800: , p5_a3 JTF_VARCHAR2_TABLE_2000

796: , x_msg_data out nocopy VARCHAR2
797: , p5_a0 JTF_NUMBER_TABLE
798: , p5_a1 JTF_NUMBER_TABLE
799: , p5_a2 JTF_VARCHAR2_TABLE_200
800: , p5_a3 JTF_VARCHAR2_TABLE_2000
801: , p5_a4 JTF_VARCHAR2_TABLE_100
802: , p5_a5 JTF_DATE_TABLE
803: , p5_a6 JTF_DATE_TABLE
804: , p5_a7 JTF_NUMBER_TABLE

Line 918: , p5_a2 JTF_VARCHAR2_TABLE_200

914: , x_msg_count out nocopy NUMBER
915: , x_msg_data out nocopy VARCHAR2
916: , p5_a0 JTF_NUMBER_TABLE
917: , p5_a1 JTF_NUMBER_TABLE
918: , p5_a2 JTF_VARCHAR2_TABLE_200
919: , p5_a3 JTF_VARCHAR2_TABLE_2000
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_DATE_TABLE
922: , p5_a6 JTF_DATE_TABLE

Line 919: , p5_a3 JTF_VARCHAR2_TABLE_2000

915: , x_msg_data out nocopy VARCHAR2
916: , p5_a0 JTF_NUMBER_TABLE
917: , p5_a1 JTF_NUMBER_TABLE
918: , p5_a2 JTF_VARCHAR2_TABLE_200
919: , p5_a3 JTF_VARCHAR2_TABLE_2000
920: , p5_a4 JTF_VARCHAR2_TABLE_100
921: , p5_a5 JTF_DATE_TABLE
922: , p5_a6 JTF_DATE_TABLE
923: , p5_a7 JTF_NUMBER_TABLE