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_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_user_access_pvt.user_access_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
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

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
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

Line 15: , a2 JTF_NUMBER_TABLE

11: end;
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

Line 34: , a21 JTF_NUMBER_TABLE

30: , a17 JTF_VARCHAR2_TABLE_200
31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_VARCHAR2_TABLE_200
33: , a20 JTF_VARCHAR2_TABLE_200
34: , a21 JTF_NUMBER_TABLE
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if a0 is not null and a0.count > 0 then

Line 74: procedure rosetta_table_copy_out_p1(t cn_user_access_pvt.user_access_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

70: end loop;
71: end if;
72: end if;
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

Line 75: , a1 out nocopy JTF_NUMBER_TABLE

71: end if;
72: end if;
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

Line 76: , a2 out nocopy JTF_NUMBER_TABLE

72: end if;
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

Line 95: , a21 out nocopy JTF_NUMBER_TABLE

91: , a17 out nocopy JTF_VARCHAR2_TABLE_200
92: , a18 out nocopy JTF_VARCHAR2_TABLE_200
93: , a19 out nocopy JTF_VARCHAR2_TABLE_200
94: , a20 out nocopy JTF_VARCHAR2_TABLE_200
95: , a21 out nocopy JTF_NUMBER_TABLE
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
99: if t is null or t.count = 0 then

Line 100: a0 := JTF_NUMBER_TABLE();

96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin
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();

Line 101: a1 := JTF_NUMBER_TABLE();

97: ddindx binary_integer; indx binary_integer;
98: begin
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();

Line 102: a2 := JTF_NUMBER_TABLE();

98: begin
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();

Line 121: a21 := JTF_NUMBER_TABLE();

117: a17 := JTF_VARCHAR2_TABLE_200();
118: a18 := JTF_VARCHAR2_TABLE_200();
119: a19 := JTF_VARCHAR2_TABLE_200();
120: a20 := JTF_VARCHAR2_TABLE_200();
121: a21 := JTF_NUMBER_TABLE();
122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_NUMBER_TABLE();

Line 123: a0 := JTF_NUMBER_TABLE();

119: a19 := JTF_VARCHAR2_TABLE_200();
120: a20 := JTF_VARCHAR2_TABLE_200();
121: a21 := JTF_NUMBER_TABLE();
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();

Line 124: a1 := JTF_NUMBER_TABLE();

120: a20 := JTF_VARCHAR2_TABLE_200();
121: a21 := JTF_NUMBER_TABLE();
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();

Line 125: a2 := JTF_NUMBER_TABLE();

121: a21 := JTF_NUMBER_TABLE();
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();

Line 144: a21 := JTF_NUMBER_TABLE();

140: a17 := JTF_VARCHAR2_TABLE_200();
141: a18 := JTF_VARCHAR2_TABLE_200();
142: a19 := JTF_VARCHAR2_TABLE_200();
143: a20 := JTF_VARCHAR2_TABLE_200();
144: a21 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);
148: a2.extend(t.count);

Line 203: procedure rosetta_table_copy_in_p3(t out nocopy cn_user_access_pvt.user_access_sum_tbl_type, a0 JTF_NUMBER_TABLE

199: end if;
200: end if;
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;

Line 226: procedure rosetta_table_copy_out_p3(t cn_user_access_pvt.user_access_sum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

222: end loop;
223: end if;
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;

Line 233: a0 := JTF_NUMBER_TABLE();

229: ) as
230: ddindx binary_integer; indx binary_integer;
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();

Line 237: a0 := JTF_NUMBER_TABLE();

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();
240: if t.count > 0 then
241: a0.extend(t.count);

Line 441: , p3_a0 out nocopy JTF_NUMBER_TABLE

437:
438: procedure get_accesses(p_range_low NUMBER
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:

Line 473: , p1_a0 out nocopy JTF_NUMBER_TABLE

469: );
470: end;
471:
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

Line 474: , p1_a1 out nocopy JTF_NUMBER_TABLE

470: end;
471:
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

Line 475: , p1_a2 out nocopy JTF_NUMBER_TABLE

471:
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

Line 494: , p1_a21 out nocopy JTF_NUMBER_TABLE

490: , p1_a17 out nocopy JTF_VARCHAR2_TABLE_200
491: , p1_a18 out nocopy JTF_VARCHAR2_TABLE_200
492: , p1_a19 out nocopy JTF_VARCHAR2_TABLE_200
493: , p1_a20 out nocopy JTF_VARCHAR2_TABLE_200
494: , p1_a21 out nocopy JTF_NUMBER_TABLE
495: )
496:
497: as
498: ddx_result_tbl cn_user_access_pvt.user_access_tbl_type;