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.JTF_PERZ_PROFILE_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: ) as

Line 49: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p1;
49: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
50: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
53: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 50: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

46: end if;
47: end if;
48: end rosetta_table_copy_in_p1;
49: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
50: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
53: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
54: ) as

Line 58: a0 := JTF_NUMBER_TABLE();

54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();

Line 59: a1 := JTF_NUMBER_TABLE();

55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: else

Line 64: a0 := JTF_NUMBER_TABLE();

60: a2 := JTF_VARCHAR2_TABLE_100();
61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();

Line 65: a1 := JTF_NUMBER_TABLE();

61: a3 := JTF_VARCHAR2_TABLE_100();
62: a4 := JTF_VARCHAR2_TABLE_100();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();
67: a3 := JTF_VARCHAR2_TABLE_100();
68: a4 := JTF_VARCHAR2_TABLE_100();
69: if t.count > 0 then

Line 93: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE

89: end if;
90: end if;
91: end rosetta_table_copy_out_p1;
92:
93: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_300
97: , a4 JTF_VARCHAR2_TABLE_100

Line 126: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

122: end loop;
123: end if;
124: end if;
125: end rosetta_table_copy_in_p4;
126: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
127: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
128: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
129: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
130: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 138: a0 := JTF_NUMBER_TABLE();

134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then
138: a0 := JTF_NUMBER_TABLE();
139: a1 := JTF_VARCHAR2_TABLE_100();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_VARCHAR2_TABLE_100();

Line 147: a0 := JTF_NUMBER_TABLE();

143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_VARCHAR2_TABLE_100();
145: a7 := JTF_VARCHAR2_TABLE_100();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_VARCHAR2_TABLE_100();
149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_VARCHAR2_TABLE_300();
151: a4 := JTF_VARCHAR2_TABLE_100();

Line 192: , p7_a0 JTF_NUMBER_TABLE

188: , p_profile_id NUMBER
189: , p_profile_name VARCHAR2
190: , p_profile_type VARCHAR2
191: , p_profile_desc VARCHAR2
192: , p7_a0 JTF_NUMBER_TABLE
193: , p7_a1 JTF_NUMBER_TABLE
194: , p7_a2 JTF_VARCHAR2_TABLE_100
195: , p7_a3 JTF_VARCHAR2_TABLE_100
196: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 193: , p7_a1 JTF_NUMBER_TABLE

189: , p_profile_name VARCHAR2
190: , p_profile_type VARCHAR2
191: , p_profile_desc VARCHAR2
192: , p7_a0 JTF_NUMBER_TABLE
193: , p7_a1 JTF_NUMBER_TABLE
194: , p7_a2 JTF_VARCHAR2_TABLE_100
195: , p7_a3 JTF_VARCHAR2_TABLE_100
196: , p7_a4 JTF_VARCHAR2_TABLE_100
197: , x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 264: , p5_a0 JTF_NUMBER_TABLE

260: , p_init_msg_list VARCHAR2
261: , p_profile_id NUMBER
262: , p_profile_name VARCHAR2
263: , p_profile_type VARCHAR2
264: , p5_a0 JTF_NUMBER_TABLE
265: , p5_a1 JTF_NUMBER_TABLE
266: , p5_a2 JTF_VARCHAR2_TABLE_100
267: , p5_a3 JTF_VARCHAR2_TABLE_100
268: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 265: , p5_a1 JTF_NUMBER_TABLE

261: , p_profile_id NUMBER
262: , p_profile_name VARCHAR2
263: , p_profile_type VARCHAR2
264: , p5_a0 JTF_NUMBER_TABLE
265: , p5_a1 JTF_NUMBER_TABLE
266: , p5_a2 JTF_VARCHAR2_TABLE_100
267: , p5_a3 JTF_VARCHAR2_TABLE_100
268: , p5_a4 JTF_VARCHAR2_TABLE_100
269: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 269: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

265: , p5_a1 JTF_NUMBER_TABLE
266: , p5_a2 JTF_VARCHAR2_TABLE_100
267: , p5_a3 JTF_VARCHAR2_TABLE_100
268: , p5_a4 JTF_VARCHAR2_TABLE_100
269: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
270: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
271: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
273: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 346: , p8_a0 JTF_NUMBER_TABLE

342: , p_profile_name VARCHAR2
343: , p_profile_type VARCHAR2
344: , p_profile_desc VARCHAR2
345: , p_active_flag VARCHAR2
346: , p8_a0 JTF_NUMBER_TABLE
347: , p8_a1 JTF_NUMBER_TABLE
348: , p8_a2 JTF_VARCHAR2_TABLE_100
349: , p8_a3 JTF_VARCHAR2_TABLE_100
350: , p8_a4 JTF_VARCHAR2_TABLE_100

Line 347: , p8_a1 JTF_NUMBER_TABLE

343: , p_profile_type VARCHAR2
344: , p_profile_desc VARCHAR2
345: , p_active_flag VARCHAR2
346: , p8_a0 JTF_NUMBER_TABLE
347: , p8_a1 JTF_NUMBER_TABLE
348: , p8_a2 JTF_VARCHAR2_TABLE_100
349: , p8_a3 JTF_VARCHAR2_TABLE_100
350: , p8_a4 JTF_VARCHAR2_TABLE_100
351: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER