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_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

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
28: ddindx binary_integer; indx binary_integer;

Line 25: , a3 JTF_VARCHAR2_TABLE_100

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
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 26: , a4 JTF_VARCHAR2_TABLE_100

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
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 51: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
55: ddindx binary_integer; indx binary_integer;

Line 52: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
55: ddindx binary_integer; indx binary_integer;
56: begin

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

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
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then

Line 60: a2 := JTF_VARCHAR2_TABLE_100();

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
64: a0 := JTF_NUMBER_TABLE();

Line 61: a3 := JTF_VARCHAR2_TABLE_100();

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
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();

Line 62: a4 := JTF_VARCHAR2_TABLE_100();

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
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_NUMBER_TABLE();
66: a2 := JTF_VARCHAR2_TABLE_100();

Line 66: a2 := 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
70: a0.extend(t.count);

Line 67: a3 := 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
70: a0.extend(t.count);
71: a1.extend(t.count);

Line 68: a4 := JTF_VARCHAR2_TABLE_100();

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
70: a0.extend(t.count);
71: a1.extend(t.count);
72: a2.extend(t.count);

Line 94: , a1 JTF_VARCHAR2_TABLE_100

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
98: , a5 JTF_VARCHAR2_TABLE_100

Line 95: , a2 JTF_VARCHAR2_TABLE_100

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
98: , a5 JTF_VARCHAR2_TABLE_100
99: , a6 JTF_VARCHAR2_TABLE_100

Line 97: , a4 JTF_VARCHAR2_TABLE_100

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
98: , a5 JTF_VARCHAR2_TABLE_100
99: , a6 JTF_VARCHAR2_TABLE_100
100: , a7 JTF_VARCHAR2_TABLE_100
101: ) as

Line 98: , a5 JTF_VARCHAR2_TABLE_100

94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_300
97: , a4 JTF_VARCHAR2_TABLE_100
98: , a5 JTF_VARCHAR2_TABLE_100
99: , a6 JTF_VARCHAR2_TABLE_100
100: , a7 JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;

Line 99: , a6 JTF_VARCHAR2_TABLE_100

95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_300
97: , a4 JTF_VARCHAR2_TABLE_100
98: , a5 JTF_VARCHAR2_TABLE_100
99: , a6 JTF_VARCHAR2_TABLE_100
100: , a7 JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;
103: begin

Line 100: , a7 JTF_VARCHAR2_TABLE_100

96: , a3 JTF_VARCHAR2_TABLE_300
97: , a4 JTF_VARCHAR2_TABLE_100
98: , a5 JTF_VARCHAR2_TABLE_100
99: , a6 JTF_VARCHAR2_TABLE_100
100: , a7 JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;
103: begin
104: if a0 is not null and a0.count > 0 then

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

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

Line 128: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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
131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
133: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134: ) as

Line 131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
133: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;

Line 132: , a6 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
131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
133: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin

Line 133: , a7 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
131: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
133: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if t is null or t.count = 0 then

Line 139: a1 := JTF_VARCHAR2_TABLE_100();

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();
143: a5 := JTF_VARCHAR2_TABLE_100();

Line 140: a2 := JTF_VARCHAR2_TABLE_100();

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();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_VARCHAR2_TABLE_100();

Line 142: a4 := JTF_VARCHAR2_TABLE_100();

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();
143: a5 := JTF_VARCHAR2_TABLE_100();
144: a6 := JTF_VARCHAR2_TABLE_100();
145: a7 := JTF_VARCHAR2_TABLE_100();
146: else

Line 143: a5 := JTF_VARCHAR2_TABLE_100();

139: a1 := JTF_VARCHAR2_TABLE_100();
140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_VARCHAR2_TABLE_100();
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();

Line 144: a6 := JTF_VARCHAR2_TABLE_100();

140: a2 := JTF_VARCHAR2_TABLE_100();
141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_VARCHAR2_TABLE_100();
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();

Line 145: a7 := JTF_VARCHAR2_TABLE_100();

141: a3 := JTF_VARCHAR2_TABLE_300();
142: a4 := JTF_VARCHAR2_TABLE_100();
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();

Line 148: a1 := 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();
152: a5 := JTF_VARCHAR2_TABLE_100();

Line 149: a2 := 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();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();

Line 151: a4 := JTF_VARCHAR2_TABLE_100();

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();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: if t.count > 0 then

Line 152: a5 := JTF_VARCHAR2_TABLE_100();

148: a1 := JTF_VARCHAR2_TABLE_100();
149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_VARCHAR2_TABLE_300();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: if t.count > 0 then
156: a0.extend(t.count);

Line 153: a6 := JTF_VARCHAR2_TABLE_100();

149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_VARCHAR2_TABLE_300();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);

Line 154: a7 := JTF_VARCHAR2_TABLE_100();

150: a3 := JTF_VARCHAR2_TABLE_300();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: if t.count > 0 then
156: a0.extend(t.count);
157: a1.extend(t.count);
158: a2.extend(t.count);

Line 194: , p7_a2 JTF_VARCHAR2_TABLE_100

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
198: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 195: , p7_a3 JTF_VARCHAR2_TABLE_100

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

Line 196: , p7_a4 JTF_VARCHAR2_TABLE_100

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
198: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
199: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 266: , p5_a2 JTF_VARCHAR2_TABLE_100

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
270: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 267: , p5_a3 JTF_VARCHAR2_TABLE_100

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

Line 268: , p5_a4 JTF_VARCHAR2_TABLE_100

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

Line 270: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 271: , p6_a2 OUT NOCOPY /* file.sql.39 change */ 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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 273: , p6_a4 OUT NOCOPY /* file.sql.39 change */ 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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
277: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
277: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
278: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 275: , p6_a6 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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
277: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
278: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
279: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 276: , p6_a7 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
274: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
277: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
278: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
279: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
280: )

Line 348: , p8_a2 JTF_VARCHAR2_TABLE_100

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

Line 349: , p8_a3 JTF_VARCHAR2_TABLE_100

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

Line 350: , p8_a4 JTF_VARCHAR2_TABLE_100

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
352: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
353: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
354: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2