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_LF_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_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin

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_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then

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

42: end if;
43: end if;
44: end rosetta_table_copy_in_p1;
45: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

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

43: end if;
44: end rosetta_table_copy_in_p1;
45: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();

Line 54: a2 := JTF_VARCHAR2_TABLE_100();

50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();

Line 57: a1 := JTF_VARCHAR2_TABLE_100();

53: a1 := JTF_VARCHAR2_TABLE_100();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);

Line 58: a2 := JTF_VARCHAR2_TABLE_100();

54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_VARCHAR2_TABLE_100();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
62: a2.extend(t.count);

Line 80: , a1 JTF_VARCHAR2_TABLE_100

76: end if;
77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_100
83: , a4 JTF_NUMBER_TABLE
84: ) as

Line 81: , a2 JTF_VARCHAR2_TABLE_100

77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_100
83: , a4 JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;

Line 82: , a3 JTF_VARCHAR2_TABLE_100

78:
79: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_100
83: , a4 JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin

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

103: end if;
104: end if;
105: end rosetta_table_copy_in_p4;
106: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
107: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
108: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
110: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
111: ) as

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

104: end if;
105: end rosetta_table_copy_in_p4;
106: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
107: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
108: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
110: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
111: ) as
112: ddindx binary_integer; indx binary_integer;

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

105: end rosetta_table_copy_in_p4;
106: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
107: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
108: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
110: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin

Line 116: a1 := JTF_VARCHAR2_TABLE_100();

112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_VARCHAR2_TABLE_100();
117: a2 := JTF_VARCHAR2_TABLE_100();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_NUMBER_TABLE();
120: else

Line 117: a2 := JTF_VARCHAR2_TABLE_100();

113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_VARCHAR2_TABLE_100();
117: a2 := JTF_VARCHAR2_TABLE_100();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();

Line 118: a3 := JTF_VARCHAR2_TABLE_100();

114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_VARCHAR2_TABLE_100();
117: a2 := JTF_VARCHAR2_TABLE_100();
118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_VARCHAR2_TABLE_100();

Line 122: a1 := JTF_VARCHAR2_TABLE_100();

118: a3 := JTF_VARCHAR2_TABLE_100();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_VARCHAR2_TABLE_100();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then

Line 123: a2 := JTF_VARCHAR2_TABLE_100();

119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_VARCHAR2_TABLE_100();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
127: a0.extend(t.count);

Line 124: a3 := JTF_VARCHAR2_TABLE_100();

120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_VARCHAR2_TABLE_100();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
127: a0.extend(t.count);
128: a1.extend(t.count);

Line 153: , a3 JTF_VARCHAR2_TABLE_100

149:
150: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_NUMBER_TABLE
153: , a3 JTF_VARCHAR2_TABLE_100
154: , a4 JTF_VARCHAR2_TABLE_300
155: , a5 JTF_NUMBER_TABLE
156: , a6 JTF_VARCHAR2_TABLE_100
157: , a7 JTF_NUMBER_TABLE

Line 156: , a6 JTF_VARCHAR2_TABLE_100

152: , a2 JTF_NUMBER_TABLE
153: , a3 JTF_VARCHAR2_TABLE_100
154: , a4 JTF_VARCHAR2_TABLE_300
155: , a5 JTF_NUMBER_TABLE
156: , a6 JTF_VARCHAR2_TABLE_100
157: , a7 JTF_NUMBER_TABLE
158: , a8 JTF_VARCHAR2_TABLE_100
159: , a9 JTF_VARCHAR2_TABLE_100
160: , a10 JTF_VARCHAR2_TABLE_100

Line 158: , a8 JTF_VARCHAR2_TABLE_100

154: , a4 JTF_VARCHAR2_TABLE_300
155: , a5 JTF_NUMBER_TABLE
156: , a6 JTF_VARCHAR2_TABLE_100
157: , a7 JTF_NUMBER_TABLE
158: , a8 JTF_VARCHAR2_TABLE_100
159: , a9 JTF_VARCHAR2_TABLE_100
160: , a10 JTF_VARCHAR2_TABLE_100
161: , a11 JTF_VARCHAR2_TABLE_100
162: , a12 JTF_NUMBER_TABLE

Line 159: , a9 JTF_VARCHAR2_TABLE_100

155: , a5 JTF_NUMBER_TABLE
156: , a6 JTF_VARCHAR2_TABLE_100
157: , a7 JTF_NUMBER_TABLE
158: , a8 JTF_VARCHAR2_TABLE_100
159: , a9 JTF_VARCHAR2_TABLE_100
160: , a10 JTF_VARCHAR2_TABLE_100
161: , a11 JTF_VARCHAR2_TABLE_100
162: , a12 JTF_NUMBER_TABLE
163: ) as

Line 160: , a10 JTF_VARCHAR2_TABLE_100

156: , a6 JTF_VARCHAR2_TABLE_100
157: , a7 JTF_NUMBER_TABLE
158: , a8 JTF_VARCHAR2_TABLE_100
159: , a9 JTF_VARCHAR2_TABLE_100
160: , a10 JTF_VARCHAR2_TABLE_100
161: , a11 JTF_VARCHAR2_TABLE_100
162: , a12 JTF_NUMBER_TABLE
163: ) as
164: ddindx binary_integer; indx binary_integer;

Line 161: , a11 JTF_VARCHAR2_TABLE_100

157: , a7 JTF_NUMBER_TABLE
158: , a8 JTF_VARCHAR2_TABLE_100
159: , a9 JTF_VARCHAR2_TABLE_100
160: , a10 JTF_VARCHAR2_TABLE_100
161: , a11 JTF_VARCHAR2_TABLE_100
162: , a12 JTF_NUMBER_TABLE
163: ) as
164: ddindx binary_integer; indx binary_integer;
165: begin

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

192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
194: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
195: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
196: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
197: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
198: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

195: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
196: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
197: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
198: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

197: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
198: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

198: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
206: ) as

Line 203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

199: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
206: ) as
207: ddindx binary_integer; indx binary_integer;

Line 204: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

200: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
201: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
206: ) as
207: ddindx binary_integer; indx binary_integer;
208: begin

Line 213: a3 := JTF_VARCHAR2_TABLE_100();

209: if t is null or t.count = 0 then
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_NUMBER_TABLE();
212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_VARCHAR2_TABLE_100();
214: a4 := JTF_VARCHAR2_TABLE_300();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_NUMBER_TABLE();

Line 216: a6 := JTF_VARCHAR2_TABLE_100();

212: a2 := JTF_NUMBER_TABLE();
213: a3 := JTF_VARCHAR2_TABLE_100();
214: a4 := JTF_VARCHAR2_TABLE_300();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_VARCHAR2_TABLE_100();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();

Line 218: a8 := JTF_VARCHAR2_TABLE_100();

214: a4 := JTF_VARCHAR2_TABLE_300();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_VARCHAR2_TABLE_100();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: a12 := JTF_NUMBER_TABLE();

Line 219: a9 := JTF_VARCHAR2_TABLE_100();

215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_VARCHAR2_TABLE_100();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: a12 := JTF_NUMBER_TABLE();
223: else

Line 220: a10 := JTF_VARCHAR2_TABLE_100();

216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_VARCHAR2_TABLE_100();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: a12 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();

Line 221: a11 := JTF_VARCHAR2_TABLE_100();

217: a7 := JTF_NUMBER_TABLE();
218: a8 := JTF_VARCHAR2_TABLE_100();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: a12 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();

Line 227: a3 := JTF_VARCHAR2_TABLE_100();

223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_VARCHAR2_TABLE_100();
228: a4 := JTF_VARCHAR2_TABLE_300();
229: a5 := JTF_NUMBER_TABLE();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();

Line 230: a6 := JTF_VARCHAR2_TABLE_100();

226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_VARCHAR2_TABLE_100();
228: a4 := JTF_VARCHAR2_TABLE_300();
229: a5 := JTF_NUMBER_TABLE();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();

Line 232: a8 := JTF_VARCHAR2_TABLE_100();

228: a4 := JTF_VARCHAR2_TABLE_300();
229: a5 := JTF_NUMBER_TABLE();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();

Line 233: a9 := JTF_VARCHAR2_TABLE_100();

229: a5 := JTF_NUMBER_TABLE();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: if t.count > 0 then

Line 234: a10 := JTF_VARCHAR2_TABLE_100();

230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: if t.count > 0 then
238: a0.extend(t.count);

Line 235: a11 := JTF_VARCHAR2_TABLE_100();

231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: if t.count > 0 then
238: a0.extend(t.count);
239: a1.extend(t.count);

Line 285: , p6_a2 JTF_VARCHAR2_TABLE_100

281: , p_profile_name VARCHAR2
282: , p_profile_type VARCHAR2
283: , p6_a0 JTF_NUMBER_TABLE
284: , p6_a1 JTF_NUMBER_TABLE
285: , p6_a2 JTF_VARCHAR2_TABLE_100
286: , p6_a3 JTF_VARCHAR2_TABLE_100
287: , p6_a4 JTF_VARCHAR2_TABLE_100
288: , p_application_id NUMBER
289: , p_parent_id NUMBER

Line 286: , p6_a3 JTF_VARCHAR2_TABLE_100

282: , p_profile_type VARCHAR2
283: , p6_a0 JTF_NUMBER_TABLE
284: , p6_a1 JTF_NUMBER_TABLE
285: , p6_a2 JTF_VARCHAR2_TABLE_100
286: , p6_a3 JTF_VARCHAR2_TABLE_100
287: , p6_a4 JTF_VARCHAR2_TABLE_100
288: , p_application_id NUMBER
289: , p_parent_id NUMBER
290: , p_object_type_id NUMBER

Line 287: , p6_a4 JTF_VARCHAR2_TABLE_100

283: , p6_a0 JTF_NUMBER_TABLE
284: , p6_a1 JTF_NUMBER_TABLE
285: , p6_a2 JTF_VARCHAR2_TABLE_100
286: , p6_a3 JTF_VARCHAR2_TABLE_100
287: , p6_a4 JTF_VARCHAR2_TABLE_100
288: , p_application_id NUMBER
289: , p_parent_id NUMBER
290: , p_object_type_id NUMBER
291: , p_object_type VARCHAR2

Line 297: , p15_a1 JTF_VARCHAR2_TABLE_100

293: , p_object_name VARCHAR2
294: , p_object_description VARCHAR2
295: , p_active_flag VARCHAR2
296: , p15_a0 JTF_NUMBER_TABLE
297: , p15_a1 JTF_VARCHAR2_TABLE_100
298: , p15_a2 JTF_VARCHAR2_TABLE_100
299: , p15_a3 JTF_VARCHAR2_TABLE_100
300: , p15_a4 JTF_NUMBER_TABLE
301: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 298: , p15_a2 JTF_VARCHAR2_TABLE_100

294: , p_object_description VARCHAR2
295: , p_active_flag VARCHAR2
296: , p15_a0 JTF_NUMBER_TABLE
297: , p15_a1 JTF_VARCHAR2_TABLE_100
298: , p15_a2 JTF_VARCHAR2_TABLE_100
299: , p15_a3 JTF_VARCHAR2_TABLE_100
300: , p15_a4 JTF_NUMBER_TABLE
301: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
302: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 299: , p15_a3 JTF_VARCHAR2_TABLE_100

295: , p_active_flag VARCHAR2
296: , p15_a0 JTF_NUMBER_TABLE
297: , p15_a1 JTF_VARCHAR2_TABLE_100
298: , p15_a2 JTF_VARCHAR2_TABLE_100
299: , p15_a3 JTF_VARCHAR2_TABLE_100
300: , p15_a4 JTF_NUMBER_TABLE
301: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
302: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 396: , p6_a1 JTF_VARCHAR2_TABLE_100

392: , p_object_type_id NUMBER
393: , p_object_type VARCHAR2
394: , p_object_type_desc VARCHAR2
395: , p6_a0 JTF_NUMBER_TABLE
396: , p6_a1 JTF_VARCHAR2_TABLE_100
397: , p6_a2 JTF_VARCHAR2_TABLE_100
398: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
399: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
400: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 397: , p6_a2 JTF_VARCHAR2_TABLE_100

393: , p_object_type VARCHAR2
394: , p_object_type_desc VARCHAR2
395: , p6_a0 JTF_NUMBER_TABLE
396: , p6_a1 JTF_VARCHAR2_TABLE_100
397: , p6_a2 JTF_VARCHAR2_TABLE_100
398: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
399: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
400: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
401: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 462: , p11_a1 JTF_VARCHAR2_TABLE_100

458: , p_object_name VARCHAR2
459: , p_object_type_id NUMBER
460: , p_object_type VARCHAR2
461: , p11_a0 JTF_NUMBER_TABLE
462: , p11_a1 JTF_VARCHAR2_TABLE_100
463: , p11_a2 JTF_VARCHAR2_TABLE_100
464: , p11_a3 JTF_VARCHAR2_TABLE_100
465: , p11_a4 JTF_NUMBER_TABLE
466: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 463: , p11_a2 JTF_VARCHAR2_TABLE_100

459: , p_object_type_id NUMBER
460: , p_object_type VARCHAR2
461: , p11_a0 JTF_NUMBER_TABLE
462: , p11_a1 JTF_VARCHAR2_TABLE_100
463: , p11_a2 JTF_VARCHAR2_TABLE_100
464: , p11_a3 JTF_VARCHAR2_TABLE_100
465: , p11_a4 JTF_NUMBER_TABLE
466: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
467: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 464: , p11_a3 JTF_VARCHAR2_TABLE_100

460: , p_object_type VARCHAR2
461: , p11_a0 JTF_NUMBER_TABLE
462: , p11_a1 JTF_VARCHAR2_TABLE_100
463: , p11_a2 JTF_VARCHAR2_TABLE_100
464: , p11_a3 JTF_VARCHAR2_TABLE_100
465: , p11_a4 JTF_NUMBER_TABLE
466: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
467: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
468: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

538: , p_object_type_id NUMBER
539: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
540: , x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
543: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
544: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
546: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 543: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

539: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
540: , x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
542: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
543: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
544: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
546: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547: )

Line 605: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

601: , p_get_children_flag VARCHAR2
602: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
603: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
604: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
605: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
606: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

604: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
605: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
606: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

606: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
607: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
613: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

607: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
613: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
615: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

608: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
613: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
615: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
616: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 613: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

609: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
610: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
611: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
612: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
613: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
614: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
615: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
616: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
617: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 698: , p12_a1 JTF_VARCHAR2_TABLE_100

694: , p_active_flag VARCHAR2
695: , p_object_type_id NUMBER
696: , p_object_type VARCHAR2
697: , p12_a0 JTF_NUMBER_TABLE
698: , p12_a1 JTF_VARCHAR2_TABLE_100
699: , p12_a2 JTF_VARCHAR2_TABLE_100
700: , p12_a3 JTF_VARCHAR2_TABLE_100
701: , p12_a4 JTF_NUMBER_TABLE
702: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 699: , p12_a2 JTF_VARCHAR2_TABLE_100

695: , p_object_type_id NUMBER
696: , p_object_type VARCHAR2
697: , p12_a0 JTF_NUMBER_TABLE
698: , p12_a1 JTF_VARCHAR2_TABLE_100
699: , p12_a2 JTF_VARCHAR2_TABLE_100
700: , p12_a3 JTF_VARCHAR2_TABLE_100
701: , p12_a4 JTF_NUMBER_TABLE
702: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
703: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 700: , p12_a3 JTF_VARCHAR2_TABLE_100

696: , p_object_type VARCHAR2
697: , p12_a0 JTF_NUMBER_TABLE
698: , p12_a1 JTF_VARCHAR2_TABLE_100
699: , p12_a2 JTF_VARCHAR2_TABLE_100
700: , p12_a3 JTF_VARCHAR2_TABLE_100
701: , p12_a4 JTF_NUMBER_TABLE
702: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
703: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
704: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER