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_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

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
27: , a5 JTF_NUMBER_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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
30: ) as

Line 28: , a6 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;
32: begin

Line 29: , a7 JTF_VARCHAR2_TABLE_100

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;
32: begin
33: if a0 is not null and a0.count > 0 then

Line 56: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
60: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 59: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
63: ) as

Line 61: , a6 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;
65: begin

Line 62: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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;
65: begin
66: if t is null or t.count = 0 then

Line 68: a1 := JTF_VARCHAR2_TABLE_100();

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();
72: a5 := JTF_NUMBER_TABLE();

Line 71: a4 := JTF_VARCHAR2_TABLE_100();

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();
75: else

Line 73: a6 := 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();
77: a1 := JTF_VARCHAR2_TABLE_100();

Line 74: a7 := JTF_VARCHAR2_TABLE_100();

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();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_NUMBER_TABLE();

Line 77: a1 := JTF_VARCHAR2_TABLE_100();

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();
81: a5 := JTF_NUMBER_TABLE();

Line 80: a4 := JTF_VARCHAR2_TABLE_100();

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();
84: if t.count > 0 then

Line 82: a6 := 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);
86: a1.extend(t.count);

Line 83: a7 := JTF_VARCHAR2_TABLE_100();

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);
86: a1.extend(t.count);
87: a2.extend(t.count);

Line 123: , p7_a2 JTF_VARCHAR2_TABLE_100

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
127: , p_perz_ddf_context VARCHAR2

Line 124: , p7_a3 JTF_VARCHAR2_TABLE_100

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
127: , p_perz_ddf_context VARCHAR2
128: , p_gui_object_name VARCHAR2

Line 125: , p7_a4 JTF_VARCHAR2_TABLE_100

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
127: , p_perz_ddf_context VARCHAR2
128: , p_gui_object_name VARCHAR2
129: , p_gui_object_id NUMBER

Line 219: , p11_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
223: , p11_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 222: , p11_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
226: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 224: , p11_a6 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
228: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 225: , p11_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
228: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
229: )