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_DDF_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_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_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_ddf_pub.ddf_out_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 27: , a5 JTF_NUMBER_TABLE

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: ) as
31: ddindx binary_integer; indx binary_integer;

Line 55: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
56: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
58: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 57: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

53: end if;
54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
56: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
58: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
60: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
61: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 58: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

54: end rosetta_table_copy_in_p1;
55: procedure rosetta_table_copy_out_p1(t jtf_perz_ddf_pub.ddf_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
56: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
58: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
60: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
61: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
62: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 60: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

56: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
58: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
60: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
61: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
62: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
63: ) as
64: ddindx binary_integer; indx binary_integer;

Line 67: a0 := JTF_NUMBER_TABLE();

63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();

Line 69: a2 := JTF_NUMBER_TABLE();

65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_VARCHAR2_TABLE_100();

Line 70: a3 := JTF_NUMBER_TABLE();

66: if t is null or t.count = 0 then
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_VARCHAR2_TABLE_100();

Line 72: a5 := JTF_NUMBER_TABLE();

68: a1 := JTF_VARCHAR2_TABLE_100();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: else
76: a0 := JTF_NUMBER_TABLE();

Line 76: a0 := JTF_NUMBER_TABLE();

72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_VARCHAR2_TABLE_100();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_VARCHAR2_TABLE_100();

Line 78: a2 := JTF_NUMBER_TABLE();

74: a7 := JTF_VARCHAR2_TABLE_100();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_VARCHAR2_TABLE_100();

Line 79: a3 := JTF_NUMBER_TABLE();

75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();

Line 81: a5 := JTF_NUMBER_TABLE();

77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_VARCHAR2_TABLE_100();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_VARCHAR2_TABLE_100();
83: a7 := JTF_VARCHAR2_TABLE_100();
84: if t.count > 0 then
85: a0.extend(t.count);

Line 121: , p7_a0 JTF_NUMBER_TABLE

117: , p_application_id NUMBER
118: , p_profile_id NUMBER
119: , p_profile_name VARCHAR2
120: , p_profile_type VARCHAR2
121: , p7_a0 JTF_NUMBER_TABLE
122: , p7_a1 JTF_NUMBER_TABLE
123: , p7_a2 JTF_VARCHAR2_TABLE_100
124: , p7_a3 JTF_VARCHAR2_TABLE_100
125: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 122: , p7_a1 JTF_NUMBER_TABLE

118: , p_profile_id NUMBER
119: , p_profile_name VARCHAR2
120: , p_profile_type VARCHAR2
121: , p7_a0 JTF_NUMBER_TABLE
122: , p7_a1 JTF_NUMBER_TABLE
123: , p7_a2 JTF_VARCHAR2_TABLE_100
124: , p7_a3 JTF_VARCHAR2_TABLE_100
125: , p7_a4 JTF_VARCHAR2_TABLE_100
126: , p_perz_ddf_id NUMBER

Line 218: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

214: , p_gui_object_name VARCHAR2
215: , p_gui_object_id NUMBER
216: , p_ddf_value VARCHAR2
217: , p_ddf_value_type VARCHAR2
218: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
219: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
220: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
222: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 220: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

216: , p_ddf_value VARCHAR2
217: , p_ddf_value_type VARCHAR2
218: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
219: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
220: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
222: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 221: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

217: , p_ddf_value_type VARCHAR2
218: , p11_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
219: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
220: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
222: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
225: , p11_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 223: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

219: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
220: , p11_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , p11_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
222: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
224: , p11_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
225: , p11_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
227: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER