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.CN_USER_ACCESS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200
21: , a8 JTF_VARCHAR2_TABLE_200

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_200
20: , a7 JTF_VARCHAR2_TABLE_200
21: , a8 JTF_VARCHAR2_TABLE_200
22: , a9 JTF_VARCHAR2_TABLE_200

Line 77: , a3 out nocopy JTF_VARCHAR2_TABLE_100

73: end rosetta_table_copy_in_p1;
74: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_NUMBER_TABLE
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , a6 out nocopy JTF_VARCHAR2_TABLE_200
81: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 78: , a4 out nocopy JTF_VARCHAR2_TABLE_100

74: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_NUMBER_TABLE
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , a6 out nocopy JTF_VARCHAR2_TABLE_200
81: , a7 out nocopy JTF_VARCHAR2_TABLE_200
82: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 79: , a5 out nocopy JTF_VARCHAR2_TABLE_100

75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_NUMBER_TABLE
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100
79: , a5 out nocopy JTF_VARCHAR2_TABLE_100
80: , a6 out nocopy JTF_VARCHAR2_TABLE_200
81: , a7 out nocopy JTF_VARCHAR2_TABLE_200
82: , a8 out nocopy JTF_VARCHAR2_TABLE_200
83: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 103: a3 := JTF_VARCHAR2_TABLE_100();

99: if t is null or t.count = 0 then
100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_100();
106: a6 := JTF_VARCHAR2_TABLE_200();
107: a7 := JTF_VARCHAR2_TABLE_200();

Line 104: a4 := JTF_VARCHAR2_TABLE_100();

100: a0 := JTF_NUMBER_TABLE();
101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_100();
106: a6 := JTF_VARCHAR2_TABLE_200();
107: a7 := JTF_VARCHAR2_TABLE_200();
108: a8 := JTF_VARCHAR2_TABLE_200();

Line 105: a5 := JTF_VARCHAR2_TABLE_100();

101: a1 := JTF_NUMBER_TABLE();
102: a2 := JTF_NUMBER_TABLE();
103: a3 := JTF_VARCHAR2_TABLE_100();
104: a4 := JTF_VARCHAR2_TABLE_100();
105: a5 := JTF_VARCHAR2_TABLE_100();
106: a6 := JTF_VARCHAR2_TABLE_200();
107: a7 := JTF_VARCHAR2_TABLE_200();
108: a8 := JTF_VARCHAR2_TABLE_200();
109: a9 := JTF_VARCHAR2_TABLE_200();

Line 126: a3 := JTF_VARCHAR2_TABLE_100();

122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_200();
130: a7 := JTF_VARCHAR2_TABLE_200();

Line 127: a4 := JTF_VARCHAR2_TABLE_100();

123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_200();
130: a7 := JTF_VARCHAR2_TABLE_200();
131: a8 := JTF_VARCHAR2_TABLE_200();

Line 128: a5 := JTF_VARCHAR2_TABLE_100();

124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();
126: a3 := JTF_VARCHAR2_TABLE_100();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_200();
130: a7 := JTF_VARCHAR2_TABLE_200();
131: a8 := JTF_VARCHAR2_TABLE_200();
132: a9 := JTF_VARCHAR2_TABLE_200();

Line 205: , a2 JTF_VARCHAR2_TABLE_100

201: end rosetta_table_copy_out_p1;
202:
203: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE
204: , a1 JTF_VARCHAR2_TABLE_300
205: , a2 JTF_VARCHAR2_TABLE_100
206: ) as
207: ddindx binary_integer; indx binary_integer;
208: begin
209: if a0 is not null and a0.count > 0 then

Line 228: , a2 out nocopy JTF_VARCHAR2_TABLE_100

224: end if;
225: end rosetta_table_copy_in_p3;
226: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
227: , a1 out nocopy JTF_VARCHAR2_TABLE_300
228: , a2 out nocopy JTF_VARCHAR2_TABLE_100
229: ) as
230: ddindx binary_integer; indx binary_integer;
231: begin
232: if t is null or t.count = 0 then

Line 235: a2 := JTF_VARCHAR2_TABLE_100();

231: begin
232: if t is null or t.count = 0 then
233: a0 := JTF_NUMBER_TABLE();
234: a1 := JTF_VARCHAR2_TABLE_300();
235: a2 := JTF_VARCHAR2_TABLE_100();
236: else
237: a0 := JTF_NUMBER_TABLE();
238: a1 := JTF_VARCHAR2_TABLE_300();
239: a2 := JTF_VARCHAR2_TABLE_100();

Line 239: a2 := JTF_VARCHAR2_TABLE_100();

235: a2 := JTF_VARCHAR2_TABLE_100();
236: else
237: a0 := JTF_NUMBER_TABLE();
238: a1 := JTF_VARCHAR2_TABLE_300();
239: a2 := JTF_VARCHAR2_TABLE_100();
240: if t.count > 0 then
241: a0.extend(t.count);
242: a1.extend(t.count);
243: a2.extend(t.count);

Line 443: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

439: , p_range_high NUMBER
440: , x_total_rows out nocopy NUMBER
441: , p3_a0 out nocopy JTF_NUMBER_TABLE
442: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_300
443: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
444: )
445:
446: as
447: ddx_result_tbl cn_user_access_pvt.user_access_sum_tbl_type;

Line 476: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

472: procedure get_access_details(p_user_id NUMBER
473: , p1_a0 out nocopy JTF_NUMBER_TABLE
474: , p1_a1 out nocopy JTF_NUMBER_TABLE
475: , p1_a2 out nocopy JTF_NUMBER_TABLE
476: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
477: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
479: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
480: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 477: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

473: , p1_a0 out nocopy JTF_NUMBER_TABLE
474: , p1_a1 out nocopy JTF_NUMBER_TABLE
475: , p1_a2 out nocopy JTF_NUMBER_TABLE
476: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
477: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
479: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
480: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
481: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 478: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

474: , p1_a1 out nocopy JTF_NUMBER_TABLE
475: , p1_a2 out nocopy JTF_NUMBER_TABLE
476: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
477: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
478: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
479: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_200
480: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_200
481: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_200
482: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_200