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

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100

Line 21: , a5 JTF_NUMBER_TABLE

17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_300

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_VARCHAR2_TABLE_100
24: , a8 JTF_VARCHAR2_TABLE_100
25: , a9 JTF_VARCHAR2_TABLE_300
26: ) as

Line 56: , a3 out nocopy JTF_NUMBER_TABLE

52: end rosetta_table_copy_in_p3;
53: procedure rosetta_table_copy_out_p3(t ahl_ltp_resrc_levl_pub.aval_resources_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
54: , a1 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , a5 out nocopy JTF_NUMBER_TABLE

54: , a1 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_VARCHAR2_TABLE_100
62: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 59: , a6 out nocopy JTF_NUMBER_TABLE

55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_VARCHAR2_TABLE_100
62: , a9 out nocopy JTF_VARCHAR2_TABLE_300
63: ) as

Line 70: a3 := JTF_NUMBER_TABLE();

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

Line 72: a5 := JTF_NUMBER_TABLE();

68: a1 := JTF_DATE_TABLE();
69: a2 := JTF_DATE_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_VARCHAR2_TABLE_300();

Line 73: a6 := JTF_NUMBER_TABLE();

69: a2 := JTF_DATE_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_VARCHAR2_TABLE_100();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_VARCHAR2_TABLE_100();
75: a8 := JTF_VARCHAR2_TABLE_100();
76: a9 := JTF_VARCHAR2_TABLE_300();
77: else

Line 81: a3 := JTF_NUMBER_TABLE();

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

Line 83: a5 := JTF_NUMBER_TABLE();

79: a1 := JTF_DATE_TABLE();
80: a2 := JTF_DATE_TABLE();
81: a3 := JTF_NUMBER_TABLE();
82: a4 := JTF_VARCHAR2_TABLE_100();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_VARCHAR2_TABLE_100();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_300();

Line 84: a6 := JTF_NUMBER_TABLE();

80: a2 := JTF_DATE_TABLE();
81: a3 := JTF_NUMBER_TABLE();
82: a4 := JTF_VARCHAR2_TABLE_100();
83: a5 := JTF_NUMBER_TABLE();
84: a6 := JTF_NUMBER_TABLE();
85: a7 := JTF_VARCHAR2_TABLE_100();
86: a8 := JTF_VARCHAR2_TABLE_100();
87: a9 := JTF_VARCHAR2_TABLE_300();
88: if t.count > 0 then

Line 122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE

118: end if;
119: end if;
120: end rosetta_table_copy_out_p3;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100

Line 123: , a1 JTF_NUMBER_TABLE

119: end if;
120: end rosetta_table_copy_out_p3;
121:
122: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 JTF_NUMBER_TABLE
123: , a1 JTF_NUMBER_TABLE
124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100

Line 128: , a6 JTF_NUMBER_TABLE

124: , a2 JTF_VARCHAR2_TABLE_100
125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;

Line 129: , a7 JTF_NUMBER_TABLE

125: , a3 JTF_VARCHAR2_TABLE_100
126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin

Line 130: , a8 JTF_NUMBER_TABLE

126: , a4 JTF_VARCHAR2_TABLE_100
127: , a5 JTF_VARCHAR2_TABLE_100
128: , a6 JTF_NUMBER_TABLE
129: , a7 JTF_NUMBER_TABLE
130: , a8 JTF_NUMBER_TABLE
131: ) as
132: ddindx binary_integer; indx binary_integer;
133: begin
134: if a0 is not null and a0.count > 0 then

Line 157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 158: , a1 out nocopy JTF_NUMBER_TABLE

154: end if;
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t ahl_ltp_resrc_levl_pub.resource_con_tbl, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_NUMBER_TABLE
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , a6 out nocopy JTF_NUMBER_TABLE

159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
165: , a8 out nocopy JTF_NUMBER_TABLE
166: ) as
167: ddindx binary_integer; indx binary_integer;

Line 164: , a7 out nocopy JTF_NUMBER_TABLE

160: , a3 out nocopy JTF_VARCHAR2_TABLE_100
161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
165: , a8 out nocopy JTF_NUMBER_TABLE
166: ) as
167: ddindx binary_integer; indx binary_integer;
168: begin

Line 165: , a8 out nocopy JTF_NUMBER_TABLE

161: , a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , a5 out nocopy JTF_VARCHAR2_TABLE_100
163: , a6 out nocopy JTF_NUMBER_TABLE
164: , a7 out nocopy JTF_NUMBER_TABLE
165: , a8 out nocopy JTF_NUMBER_TABLE
166: ) as
167: ddindx binary_integer; indx binary_integer;
168: begin
169: if t is null or t.count = 0 then

Line 170: a0 := JTF_NUMBER_TABLE();

166: ) as
167: ddindx binary_integer; indx binary_integer;
168: begin
169: if t is null or t.count = 0 then
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();

Line 171: a1 := JTF_NUMBER_TABLE();

167: ddindx binary_integer; indx binary_integer;
168: begin
169: if t is null or t.count = 0 then
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();

Line 176: a6 := JTF_NUMBER_TABLE();

172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();

Line 177: a7 := JTF_NUMBER_TABLE();

173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();

Line 178: a8 := JTF_NUMBER_TABLE();

174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();

Line 180: a0 := JTF_NUMBER_TABLE();

176: a6 := JTF_NUMBER_TABLE();
177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();

Line 181: a1 := JTF_NUMBER_TABLE();

177: a7 := JTF_NUMBER_TABLE();
178: a8 := JTF_NUMBER_TABLE();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_NUMBER_TABLE();
182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();

Line 186: a6 := JTF_NUMBER_TABLE();

182: a2 := JTF_VARCHAR2_TABLE_100();
183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);

Line 187: a7 := JTF_NUMBER_TABLE();

183: a3 := JTF_VARCHAR2_TABLE_100();
184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
191: a1.extend(t.count);

Line 188: a8 := JTF_NUMBER_TABLE();

184: a4 := JTF_VARCHAR2_TABLE_100();
185: a5 := JTF_VARCHAR2_TABLE_100();
186: a6 := JTF_NUMBER_TABLE();
187: a7 := JTF_NUMBER_TABLE();
188: a8 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);
191: a1.extend(t.count);
192: a2.extend(t.count);

Line 243: , p6_a3 out nocopy JTF_NUMBER_TABLE

239: , p5_a13 VARCHAR2
240: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a1 out nocopy JTF_DATE_TABLE
242: , p6_a2 out nocopy JTF_DATE_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 245: , p6_a5 out nocopy JTF_NUMBER_TABLE

241: , p6_a1 out nocopy JTF_DATE_TABLE
242: , p6_a2 out nocopy JTF_DATE_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 246: , p6_a6 out nocopy JTF_NUMBER_TABLE

242: , p6_a2 out nocopy JTF_DATE_TABLE
243: , p6_a3 out nocopy JTF_NUMBER_TABLE
244: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a5 out nocopy JTF_NUMBER_TABLE
246: , p6_a6 out nocopy JTF_NUMBER_TABLE
247: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
250: , x_return_status out nocopy VARCHAR2

Line 340: , p6_a0 out nocopy JTF_NUMBER_TABLE

336: , p5_a10 NUMBER
337: , p5_a11 NUMBER
338: , p5_a12 VARCHAR2
339: , p5_a13 VARCHAR2
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: , p6_a1 out nocopy JTF_NUMBER_TABLE

337: , p5_a11 NUMBER
338: , p5_a12 VARCHAR2
339: , p5_a13 VARCHAR2
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 346: , p6_a6 out nocopy JTF_NUMBER_TABLE

342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , x_return_status out nocopy VARCHAR2
350: , x_msg_count out nocopy NUMBER

Line 347: , p6_a7 out nocopy JTF_NUMBER_TABLE

343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , x_return_status out nocopy VARCHAR2
350: , x_msg_count out nocopy NUMBER
351: , x_msg_data out nocopy VARCHAR2

Line 348: , p6_a8 out nocopy JTF_NUMBER_TABLE

344: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a6 out nocopy JTF_NUMBER_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , x_return_status out nocopy VARCHAR2
350: , x_msg_count out nocopy NUMBER
351: , x_msg_data out nocopy VARCHAR2
352: )