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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: ) as

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: ) as
15: ddindx binary_integer; indx binary_integer;

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then

Line 49: , a7 out nocopy JTF_NUMBER_TABLE

45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_400
47: , a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: ) as

Line 50: , a8 out nocopy JTF_NUMBER_TABLE

46: , a4 out nocopy JTF_VARCHAR2_TABLE_400
47: , a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;

Line 51: , a9 out nocopy JTF_NUMBER_TABLE

47: , a5 out nocopy JTF_VARCHAR2_TABLE_300
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 52: , a10 out nocopy JTF_NUMBER_TABLE

48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_NUMBER_TABLE
52: , a10 out nocopy JTF_NUMBER_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then

Line 64: a7 := JTF_NUMBER_TABLE();

60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_VARCHAR2_TABLE_400();
62: a5 := JTF_VARCHAR2_TABLE_300();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_NUMBER_TABLE();
68: else

Line 65: a8 := JTF_NUMBER_TABLE();

61: a4 := JTF_VARCHAR2_TABLE_400();
62: a5 := JTF_VARCHAR2_TABLE_300();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_NUMBER_TABLE();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();

Line 66: a9 := JTF_NUMBER_TABLE();

62: a5 := JTF_VARCHAR2_TABLE_300();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_NUMBER_TABLE();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();

Line 67: a10 := JTF_NUMBER_TABLE();

63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_NUMBER_TABLE();
67: a10 := JTF_NUMBER_TABLE();
68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_4000();

Line 76: a7 := JTF_NUMBER_TABLE();

72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_VARCHAR2_TABLE_400();
74: a5 := JTF_VARCHAR2_TABLE_300();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_NUMBER_TABLE();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_NUMBER_TABLE();
80: if t.count > 0 then

Line 77: a8 := JTF_NUMBER_TABLE();

73: a4 := JTF_VARCHAR2_TABLE_400();
74: a5 := JTF_VARCHAR2_TABLE_300();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_NUMBER_TABLE();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);

Line 78: a9 := JTF_NUMBER_TABLE();

74: a5 := JTF_VARCHAR2_TABLE_300();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_NUMBER_TABLE();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 79: a10 := JTF_NUMBER_TABLE();

75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_NUMBER_TABLE();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_NUMBER_TABLE();
79: a10 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 116: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_NUMBER_TABLE

Line 117: , a1 JTF_NUMBER_TABLE

113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100

Line 120: , a4 JTF_NUMBER_TABLE

116: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_VARCHAR2_TABLE_100
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
124: , a8 JTF_VARCHAR2_TABLE_2000

Line 128: , a12 JTF_NUMBER_TABLE

124: , a8 JTF_VARCHAR2_TABLE_2000
125: , a9 JTF_VARCHAR2_TABLE_100
126: , a10 JTF_DATE_TABLE
127: , a11 JTF_DATE_TABLE
128: , a12 JTF_NUMBER_TABLE
129: , a13 JTF_VARCHAR2_TABLE_100
130: ) as
131: ddindx binary_integer; indx binary_integer;
132: begin

Line 161: procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

157: end loop;
158: end if;
159: end if;
160: end rosetta_table_copy_in_p3;
161: procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_NUMBER_TABLE

Line 162: , a1 out nocopy JTF_NUMBER_TABLE

158: end if;
159: end if;
160: end rosetta_table_copy_in_p3;
161: procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_NUMBER_TABLE
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 165: , a4 out nocopy JTF_NUMBER_TABLE

161: procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_NUMBER_TABLE
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , a7 out nocopy JTF_VARCHAR2_TABLE_100
169: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 173: , a12 out nocopy JTF_NUMBER_TABLE

169: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
170: , a9 out nocopy JTF_VARCHAR2_TABLE_100
171: , a10 out nocopy JTF_DATE_TABLE
172: , a11 out nocopy JTF_DATE_TABLE
173: , a12 out nocopy JTF_NUMBER_TABLE
174: , a13 out nocopy JTF_VARCHAR2_TABLE_100
175: ) as
176: ddindx binary_integer; indx binary_integer;
177: begin

Line 179: a0 := JTF_NUMBER_TABLE();

175: ) as
176: ddindx binary_integer; indx binary_integer;
177: begin
178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();

Line 180: a1 := JTF_NUMBER_TABLE();

176: ddindx binary_integer; indx binary_integer;
177: begin
178: if t is null or t.count = 0 then
179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();
184: a5 := JTF_VARCHAR2_TABLE_100();

Line 183: a4 := JTF_NUMBER_TABLE();

179: a0 := JTF_NUMBER_TABLE();
180: a1 := JTF_NUMBER_TABLE();
181: a2 := JTF_VARCHAR2_TABLE_100();
182: a3 := JTF_VARCHAR2_TABLE_100();
183: a4 := JTF_NUMBER_TABLE();
184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
187: a8 := JTF_VARCHAR2_TABLE_2000();

Line 191: a12 := JTF_NUMBER_TABLE();

187: a8 := JTF_VARCHAR2_TABLE_2000();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_DATE_TABLE();
190: a11 := JTF_DATE_TABLE();
191: a12 := JTF_NUMBER_TABLE();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();

Line 194: a0 := JTF_NUMBER_TABLE();

190: a11 := JTF_DATE_TABLE();
191: a12 := JTF_NUMBER_TABLE();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_100();
197: a3 := JTF_VARCHAR2_TABLE_100();
198: a4 := JTF_NUMBER_TABLE();

Line 195: a1 := JTF_NUMBER_TABLE();

191: a12 := JTF_NUMBER_TABLE();
192: a13 := JTF_VARCHAR2_TABLE_100();
193: else
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_100();
197: a3 := JTF_VARCHAR2_TABLE_100();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();

Line 198: a4 := JTF_NUMBER_TABLE();

194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_100();
197: a3 := JTF_VARCHAR2_TABLE_100();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_VARCHAR2_TABLE_100();
202: a8 := JTF_VARCHAR2_TABLE_2000();

Line 206: a12 := JTF_NUMBER_TABLE();

202: a8 := JTF_VARCHAR2_TABLE_2000();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_DATE_TABLE();
206: a12 := JTF_NUMBER_TABLE();
207: a13 := JTF_VARCHAR2_TABLE_100();
208: if t.count > 0 then
209: a0.extend(t.count);
210: a1.extend(t.count);

Line 250: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 JTF_NUMBER_TABLE

246: end if;
247: end if;
248: end rosetta_table_copy_out_p3;
249:
250: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 JTF_NUMBER_TABLE
251: , a1 JTF_NUMBER_TABLE
252: , a2 JTF_NUMBER_TABLE
253: , a3 JTF_VARCHAR2_TABLE_100
254: ) as

Line 251: , a1 JTF_NUMBER_TABLE

247: end if;
248: end rosetta_table_copy_out_p3;
249:
250: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 JTF_NUMBER_TABLE
251: , a1 JTF_NUMBER_TABLE
252: , a2 JTF_NUMBER_TABLE
253: , a3 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;

Line 252: , a2 JTF_NUMBER_TABLE

248: end rosetta_table_copy_out_p3;
249:
250: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 JTF_NUMBER_TABLE
251: , a1 JTF_NUMBER_TABLE
252: , a2 JTF_NUMBER_TABLE
253: , a3 JTF_VARCHAR2_TABLE_100
254: ) as
255: ddindx binary_integer; indx binary_integer;
256: begin

Line 279: procedure rosetta_table_copy_out_p5(t ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

275: end loop;
276: end if;
277: end if;
278: end rosetta_table_copy_in_p5;
279: procedure rosetta_table_copy_out_p5(t ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_NUMBER_TABLE
281: , a2 out nocopy JTF_NUMBER_TABLE
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: ) as

Line 280: , a1 out nocopy JTF_NUMBER_TABLE

276: end if;
277: end if;
278: end rosetta_table_copy_in_p5;
279: procedure rosetta_table_copy_out_p5(t ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_NUMBER_TABLE
281: , a2 out nocopy JTF_NUMBER_TABLE
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: ) as
284: ddindx binary_integer; indx binary_integer;

Line 281: , a2 out nocopy JTF_NUMBER_TABLE

277: end if;
278: end rosetta_table_copy_in_p5;
279: procedure rosetta_table_copy_out_p5(t ahl_mr_loop_chain_relns_pvt.mr_relns_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_NUMBER_TABLE
281: , a2 out nocopy JTF_NUMBER_TABLE
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin

Line 292: a0 := JTF_NUMBER_TABLE();

288: a1 := null;
289: a2 := null;
290: a3 := null;
291: elsif t.count = 0 then
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_NUMBER_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_100();
296: else

Line 293: a1 := JTF_NUMBER_TABLE();

289: a2 := null;
290: a3 := null;
291: elsif t.count = 0 then
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_NUMBER_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();

Line 294: a2 := JTF_NUMBER_TABLE();

290: a3 := null;
291: elsif t.count = 0 then
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_NUMBER_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();

Line 297: a0 := JTF_NUMBER_TABLE();

293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_NUMBER_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then

Line 298: a1 := JTF_NUMBER_TABLE();

294: a2 := JTF_NUMBER_TABLE();
295: a3 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then
302: a0.extend(t.count);

Line 299: a2 := JTF_NUMBER_TABLE();

295: a3 := JTF_VARCHAR2_TABLE_100();
296: else
297: a0 := JTF_NUMBER_TABLE();
298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then
302: a0.extend(t.count);
303: a1.extend(t.count);

Line 323: procedure rosetta_table_copy_in_p6(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 JTF_NUMBER_TABLE) as

319: end if;
320: end if;
321: end rosetta_table_copy_out_p5;
322:
323: procedure rosetta_table_copy_in_p6(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 JTF_NUMBER_TABLE) as
324: ddindx binary_integer; indx binary_integer;
325: begin
326: if a0 is not null and a0.count > 0 then
327: if a0.count > 0 then

Line 341: procedure rosetta_table_copy_out_p6(t ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

337: end loop;
338: end if;
339: end if;
340: end rosetta_table_copy_in_p6;
341: procedure rosetta_table_copy_out_p6(t ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
342: ddindx binary_integer; indx binary_integer;
343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();

Line 345: a0 := JTF_NUMBER_TABLE();

341: procedure rosetta_table_copy_out_p6(t ahl_mr_loop_chain_relns_pvt.mr_header_ids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
342: ddindx binary_integer; indx binary_integer;
343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: else
347: a0 := JTF_NUMBER_TABLE();
348: if t.count > 0 then
349: a0.extend(t.count);

Line 347: a0 := JTF_NUMBER_TABLE();

343: begin
344: if t is null or t.count = 0 then
345: a0 := JTF_NUMBER_TABLE();
346: else
347: a0 := JTF_NUMBER_TABLE();
348: if t.count > 0 then
349: a0.extend(t.count);
350: ddindx := t.first;
351: indx := 1;

Line 413: , x_mr_header_id out nocopy JTF_NUMBER_TABLE

409: , p_page_mode VARCHAR2
410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100
413: , x_mr_header_id out nocopy JTF_NUMBER_TABLE
414: , p9_a0 JTF_NUMBER_TABLE
415: , p9_a1 JTF_NUMBER_TABLE
416: , p9_a2 JTF_NUMBER_TABLE
417: , p9_a3 JTF_VARCHAR2_TABLE_100

Line 414: , p9_a0 JTF_NUMBER_TABLE

410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100
413: , x_mr_header_id out nocopy JTF_NUMBER_TABLE
414: , p9_a0 JTF_NUMBER_TABLE
415: , p9_a1 JTF_NUMBER_TABLE
416: , p9_a2 JTF_NUMBER_TABLE
417: , p9_a3 JTF_VARCHAR2_TABLE_100
418: )

Line 415: , p9_a1 JTF_NUMBER_TABLE

411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100
413: , x_mr_header_id out nocopy JTF_NUMBER_TABLE
414: , p9_a0 JTF_NUMBER_TABLE
415: , p9_a1 JTF_NUMBER_TABLE
416: , p9_a2 JTF_NUMBER_TABLE
417: , p9_a3 JTF_VARCHAR2_TABLE_100
418: )
419:

Line 416: , p9_a2 JTF_NUMBER_TABLE

412: , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100
413: , x_mr_header_id out nocopy JTF_NUMBER_TABLE
414: , p9_a0 JTF_NUMBER_TABLE
415: , p9_a1 JTF_NUMBER_TABLE
416: , p9_a2 JTF_NUMBER_TABLE
417: , p9_a3 JTF_VARCHAR2_TABLE_100
418: )
419:
420: as

Line 471: , p2_a0 out nocopy JTF_NUMBER_TABLE

467: end;
468:
469: procedure get_start_mr_relns(p_mr_header_id NUMBER
470: , p_rel_code VARCHAR2
471: , p2_a0 out nocopy JTF_NUMBER_TABLE
472: , p2_a1 out nocopy JTF_NUMBER_TABLE
473: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a4 out nocopy JTF_NUMBER_TABLE

Line 472: , p2_a1 out nocopy JTF_NUMBER_TABLE

468:
469: procedure get_start_mr_relns(p_mr_header_id NUMBER
470: , p_rel_code VARCHAR2
471: , p2_a0 out nocopy JTF_NUMBER_TABLE
472: , p2_a1 out nocopy JTF_NUMBER_TABLE
473: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a4 out nocopy JTF_NUMBER_TABLE
476: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 475: , p2_a4 out nocopy JTF_NUMBER_TABLE

471: , p2_a0 out nocopy JTF_NUMBER_TABLE
472: , p2_a1 out nocopy JTF_NUMBER_TABLE
473: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a4 out nocopy JTF_NUMBER_TABLE
476: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
477: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
479: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 483: , p2_a12 out nocopy JTF_NUMBER_TABLE

479: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_2000
480: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
481: , p2_a10 out nocopy JTF_DATE_TABLE
482: , p2_a11 out nocopy JTF_DATE_TABLE
483: , p2_a12 out nocopy JTF_NUMBER_TABLE
484: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
485: , x_return_status out nocopy VARCHAR2
486: , x_msg_count out nocopy NUMBER
487: , x_msg_data out nocopy VARCHAR2

Line 547: , p7_a7 out nocopy JTF_NUMBER_TABLE

543: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
544: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
545: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
546: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a7 out nocopy JTF_NUMBER_TABLE
548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE

Line 548: , p7_a8 out nocopy JTF_NUMBER_TABLE

544: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
545: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
546: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a7 out nocopy JTF_NUMBER_TABLE
548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE

Line 549: , p7_a9 out nocopy JTF_NUMBER_TABLE

545: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_300
546: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a7 out nocopy JTF_NUMBER_TABLE
548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE
553: , p8_a2 JTF_VARCHAR2_TABLE_100

Line 550: , p7_a10 out nocopy JTF_NUMBER_TABLE

546: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a7 out nocopy JTF_NUMBER_TABLE
548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE
553: , p8_a2 JTF_VARCHAR2_TABLE_100
554: , p8_a3 JTF_VARCHAR2_TABLE_100

Line 551: , p8_a0 JTF_NUMBER_TABLE

547: , p7_a7 out nocopy JTF_NUMBER_TABLE
548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE
553: , p8_a2 JTF_VARCHAR2_TABLE_100
554: , p8_a3 JTF_VARCHAR2_TABLE_100
555: , p8_a4 JTF_NUMBER_TABLE

Line 552: , p8_a1 JTF_NUMBER_TABLE

548: , p7_a8 out nocopy JTF_NUMBER_TABLE
549: , p7_a9 out nocopy JTF_NUMBER_TABLE
550: , p7_a10 out nocopy JTF_NUMBER_TABLE
551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE
553: , p8_a2 JTF_VARCHAR2_TABLE_100
554: , p8_a3 JTF_VARCHAR2_TABLE_100
555: , p8_a4 JTF_NUMBER_TABLE
556: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 555: , p8_a4 JTF_NUMBER_TABLE

551: , p8_a0 JTF_NUMBER_TABLE
552: , p8_a1 JTF_NUMBER_TABLE
553: , p8_a2 JTF_VARCHAR2_TABLE_100
554: , p8_a3 JTF_VARCHAR2_TABLE_100
555: , p8_a4 JTF_NUMBER_TABLE
556: , p8_a5 JTF_VARCHAR2_TABLE_100
557: , p8_a6 JTF_VARCHAR2_TABLE_100
558: , p8_a7 JTF_VARCHAR2_TABLE_100
559: , p8_a8 JTF_VARCHAR2_TABLE_2000

Line 563: , p8_a12 JTF_NUMBER_TABLE

559: , p8_a8 JTF_VARCHAR2_TABLE_2000
560: , p8_a9 JTF_VARCHAR2_TABLE_100
561: , p8_a10 JTF_DATE_TABLE
562: , p8_a11 JTF_DATE_TABLE
563: , p8_a12 JTF_NUMBER_TABLE
564: , p8_a13 JTF_VARCHAR2_TABLE_100
565: )
566:
567: as

Line 652: , p13_a7 out nocopy JTF_NUMBER_TABLE

648: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
649: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_400
650: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
651: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
652: , p13_a7 out nocopy JTF_NUMBER_TABLE
653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE

Line 653: , p13_a8 out nocopy JTF_NUMBER_TABLE

649: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_400
650: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
651: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
652: , p13_a7 out nocopy JTF_NUMBER_TABLE
653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE

Line 654: , p13_a9 out nocopy JTF_NUMBER_TABLE

650: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
651: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
652: , p13_a7 out nocopy JTF_NUMBER_TABLE
653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE
658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 655: , p13_a10 out nocopy JTF_NUMBER_TABLE

651: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
652: , p13_a7 out nocopy JTF_NUMBER_TABLE
653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE
658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
659: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 656: , p14_a0 out nocopy JTF_NUMBER_TABLE

652: , p13_a7 out nocopy JTF_NUMBER_TABLE
653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE
658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
659: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
660: , p14_a4 out nocopy JTF_NUMBER_TABLE

Line 657: , p14_a1 out nocopy JTF_NUMBER_TABLE

653: , p13_a8 out nocopy JTF_NUMBER_TABLE
654: , p13_a9 out nocopy JTF_NUMBER_TABLE
655: , p13_a10 out nocopy JTF_NUMBER_TABLE
656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE
658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
659: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
660: , p14_a4 out nocopy JTF_NUMBER_TABLE
661: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 660: , p14_a4 out nocopy JTF_NUMBER_TABLE

656: , p14_a0 out nocopy JTF_NUMBER_TABLE
657: , p14_a1 out nocopy JTF_NUMBER_TABLE
658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
659: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
660: , p14_a4 out nocopy JTF_NUMBER_TABLE
661: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
662: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
663: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
664: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 668: , p14_a12 out nocopy JTF_NUMBER_TABLE

664: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
666: , p14_a10 out nocopy JTF_DATE_TABLE
667: , p14_a11 out nocopy JTF_DATE_TABLE
668: , p14_a12 out nocopy JTF_NUMBER_TABLE
669: , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100
670: )
671:
672: as

Line 762: , p7_a0 out nocopy JTF_NUMBER_TABLE

758: , p_rel_code VARCHAR2
759: , x_return_status out nocopy VARCHAR2
760: , x_msg_count out nocopy NUMBER
761: , x_msg_data out nocopy VARCHAR2
762: , p7_a0 out nocopy JTF_NUMBER_TABLE
763: , p7_a1 out nocopy JTF_NUMBER_TABLE
764: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
766: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 763: , p7_a1 out nocopy JTF_NUMBER_TABLE

759: , x_return_status out nocopy VARCHAR2
760: , x_msg_count out nocopy NUMBER
761: , x_msg_data out nocopy VARCHAR2
762: , p7_a0 out nocopy JTF_NUMBER_TABLE
763: , p7_a1 out nocopy JTF_NUMBER_TABLE
764: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
766: , p7_a4 out nocopy JTF_NUMBER_TABLE
767: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 766: , p7_a4 out nocopy JTF_NUMBER_TABLE

762: , p7_a0 out nocopy JTF_NUMBER_TABLE
763: , p7_a1 out nocopy JTF_NUMBER_TABLE
764: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
765: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
766: , p7_a4 out nocopy JTF_NUMBER_TABLE
767: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
768: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
769: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
770: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 774: , p7_a12 out nocopy JTF_NUMBER_TABLE

770: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000
771: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
772: , p7_a10 out nocopy JTF_DATE_TABLE
773: , p7_a11 out nocopy JTF_DATE_TABLE
774: , p7_a12 out nocopy JTF_NUMBER_TABLE
775: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
776: )
777:
778: as