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_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: PACKAGE BODY ahl_mr_loop_chain_relns_pvt_w AS
2: /* $Header: AHLWLCRB.pls 120.0.12020000.2 2012/12/14 10:32:22 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: PACKAGE BODY ahl_mr_loop_chain_relns_pvt_w AS
2: /* $Header: AHLWLCRB.pls 120.0.12020000.2 2012/12/14 10:32:22 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWLCRB.pls 120.0.12020000.2 2012/12/14 10:32:22 shnatu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
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

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_4000
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

Line 42: procedure rosetta_table_copy_out_p1(t ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 43: , a1 out nocopy JTF_VARCHAR2_TABLE_100

39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_400
47: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 45: , a3 out nocopy JTF_VARCHAR2_TABLE_100

41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 48: , a6 out nocopy JTF_VARCHAR2_TABLE_100

44: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 57: a0 := JTF_VARCHAR2_TABLE_100();

53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_4000();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_VARCHAR2_TABLE_400();

Line 58: a1 := JTF_VARCHAR2_TABLE_100();

54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_4000();
60: a3 := JTF_VARCHAR2_TABLE_100();
61: a4 := JTF_VARCHAR2_TABLE_400();
62: a5 := JTF_VARCHAR2_TABLE_300();

Line 60: a3 := JTF_VARCHAR2_TABLE_100();

56: if t is null or t.count = 0 then
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_4000();
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();

Line 63: a6 := JTF_VARCHAR2_TABLE_100();

59: a2 := JTF_VARCHAR2_TABLE_4000();
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();

Line 69: a0 := JTF_VARCHAR2_TABLE_100();

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();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_VARCHAR2_TABLE_400();

Line 70: a1 := JTF_VARCHAR2_TABLE_100();

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();
72: a3 := JTF_VARCHAR2_TABLE_100();
73: a4 := JTF_VARCHAR2_TABLE_400();
74: a5 := JTF_VARCHAR2_TABLE_300();

Line 72: a3 := JTF_VARCHAR2_TABLE_100();

68: else
69: a0 := JTF_VARCHAR2_TABLE_100();
70: a1 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_VARCHAR2_TABLE_4000();
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();

Line 75: a6 := JTF_VARCHAR2_TABLE_100();

71: a2 := JTF_VARCHAR2_TABLE_4000();
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();

Line 118: , a2 JTF_VARCHAR2_TABLE_100

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
122: , a6 JTF_VARCHAR2_TABLE_100

Line 119: , a3 JTF_VARCHAR2_TABLE_100

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
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100

Line 121: , a5 JTF_VARCHAR2_TABLE_100

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
125: , a9 JTF_VARCHAR2_TABLE_100

Line 122: , a6 JTF_VARCHAR2_TABLE_100

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
125: , a9 JTF_VARCHAR2_TABLE_100
126: , a10 JTF_DATE_TABLE

Line 123: , a7 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
125: , a9 JTF_VARCHAR2_TABLE_100
126: , a10 JTF_DATE_TABLE
127: , a11 JTF_DATE_TABLE

Line 125: , a9 JTF_VARCHAR2_TABLE_100

121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
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

Line 129: , a13 JTF_VARCHAR2_TABLE_100

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
133: if a0 is not null and a0.count > 0 then

Line 163: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
170: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
170: , a9 out nocopy JTF_VARCHAR2_TABLE_100
171: , a10 out nocopy JTF_DATE_TABLE

Line 168: , a7 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
170: , a9 out nocopy JTF_VARCHAR2_TABLE_100
171: , a10 out nocopy JTF_DATE_TABLE
172: , a11 out nocopy JTF_DATE_TABLE

Line 170: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 174: , a13 out nocopy JTF_VARCHAR2_TABLE_100

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
178: if t is null or t.count = 0 then

Line 181: a2 := JTF_VARCHAR2_TABLE_100();

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();
185: a6 := JTF_VARCHAR2_TABLE_100();

Line 182: a3 := JTF_VARCHAR2_TABLE_100();

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();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();

Line 184: a5 := JTF_VARCHAR2_TABLE_100();

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();
188: a9 := JTF_VARCHAR2_TABLE_100();

Line 185: a6 := JTF_VARCHAR2_TABLE_100();

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();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_DATE_TABLE();

Line 186: a7 := 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();
188: a9 := JTF_VARCHAR2_TABLE_100();
189: a10 := JTF_DATE_TABLE();
190: a11 := JTF_DATE_TABLE();

Line 188: a9 := JTF_VARCHAR2_TABLE_100();

184: a5 := JTF_VARCHAR2_TABLE_100();
185: a6 := JTF_VARCHAR2_TABLE_100();
186: a7 := JTF_VARCHAR2_TABLE_100();
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();

Line 192: a13 := JTF_VARCHAR2_TABLE_100();

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();
196: a2 := JTF_VARCHAR2_TABLE_100();

Line 196: a2 := JTF_VARCHAR2_TABLE_100();

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();
200: a6 := JTF_VARCHAR2_TABLE_100();

Line 197: a3 := 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();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_VARCHAR2_TABLE_100();

Line 199: a5 := JTF_VARCHAR2_TABLE_100();

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();
203: a9 := JTF_VARCHAR2_TABLE_100();

Line 200: a6 := JTF_VARCHAR2_TABLE_100();

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();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_DATE_TABLE();

Line 201: a7 := 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();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_DATE_TABLE();
205: a11 := JTF_DATE_TABLE();

Line 203: a9 := JTF_VARCHAR2_TABLE_100();

199: a5 := JTF_VARCHAR2_TABLE_100();
200: a6 := JTF_VARCHAR2_TABLE_100();
201: a7 := JTF_VARCHAR2_TABLE_100();
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();

Line 207: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 253: , a3 JTF_VARCHAR2_TABLE_100

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
257: if a0 is not null and a0.count=0 then

Line 282: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
286: if t is null then

Line 295: a3 := JTF_VARCHAR2_TABLE_100();

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();
299: a2 := JTF_NUMBER_TABLE();

Line 300: 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);
304: a2.extend(t.count);

Line 364: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 JTF_VARCHAR2_TABLE_100) as

360: end if;
361: end if;
362: end rosetta_table_copy_out_p6;
363:
364: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 JTF_VARCHAR2_TABLE_100) as
365: ddindx binary_integer; indx binary_integer;
366: begin
367: if a0 is not null and a0.count > 0 then
368: if a0.count > 0 then

Line 382: procedure rosetta_table_copy_out_p7(t ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

378: end loop;
379: end if;
380: end if;
381: end rosetta_table_copy_in_p7;
382: procedure rosetta_table_copy_out_p7(t ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then
386: a0 := JTF_VARCHAR2_TABLE_100();

Line 386: a0 := JTF_VARCHAR2_TABLE_100();

382: procedure rosetta_table_copy_out_p7(t ahl_mr_loop_chain_relns_pvt.err_msg_data, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if t is null or t.count = 0 then
386: a0 := JTF_VARCHAR2_TABLE_100();
387: else
388: a0 := JTF_VARCHAR2_TABLE_100();
389: if t.count > 0 then
390: a0.extend(t.count);

Line 388: a0 := JTF_VARCHAR2_TABLE_100();

384: begin
385: if t is null or t.count = 0 then
386: a0 := JTF_VARCHAR2_TABLE_100();
387: else
388: a0 := JTF_VARCHAR2_TABLE_100();
389: if t.count > 0 then
390: a0.extend(t.count);
391: ddindx := t.first;
392: indx := 1;

Line 412: , x_msg_data out nocopy JTF_VARCHAR2_TABLE_100

408: , p_validation_level NUMBER
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

Line 417: , p9_a3 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
421: ddx_msg_data ahl_mr_loop_chain_relns_pvt.err_msg_data;

Line 473: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
477: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 474: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
477: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 476: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
480: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 477: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
480: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
481: , p2_a10 out nocopy JTF_DATE_TABLE

Line 478: , p2_a7 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
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

Line 480: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 484: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
488: )

Line 540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

536: , p_validation_level NUMBER
537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_4000
543: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
544: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 543: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

539: , x_msg_data out nocopy VARCHAR2
540: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
541: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 546: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

542: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 553: , p8_a2 JTF_VARCHAR2_TABLE_100

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
557: , p8_a6 JTF_VARCHAR2_TABLE_100

Line 554: , p8_a3 JTF_VARCHAR2_TABLE_100

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
557: , p8_a6 JTF_VARCHAR2_TABLE_100
558: , p8_a7 JTF_VARCHAR2_TABLE_100

Line 556: , p8_a5 JTF_VARCHAR2_TABLE_100

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
560: , p8_a9 JTF_VARCHAR2_TABLE_100

Line 557: , p8_a6 JTF_VARCHAR2_TABLE_100

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
560: , p8_a9 JTF_VARCHAR2_TABLE_100
561: , p8_a10 JTF_DATE_TABLE

Line 558: , p8_a7 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
560: , p8_a9 JTF_VARCHAR2_TABLE_100
561: , p8_a10 JTF_DATE_TABLE
562: , p8_a11 JTF_DATE_TABLE

Line 560: , p8_a9 JTF_VARCHAR2_TABLE_100

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

Line 564: , p8_a13 JTF_VARCHAR2_TABLE_100

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
568: ddx_mr_item_instances ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type;

Line 645: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100

641: , p_mr_header_id NUMBER
642: , p_ue_id NUMBER
643: , p_calling_module VARCHAR2
644: , p_item_instance_id NUMBER
645: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
646: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
647: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_4000
648: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100
649: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 646: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100

642: , p_ue_id NUMBER
643: , p_calling_module VARCHAR2
644: , p_item_instance_id NUMBER
645: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
646: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
647: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 648: , p13_a3 out nocopy JTF_VARCHAR2_TABLE_100

644: , p_item_instance_id NUMBER
645: , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
646: , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
647: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 651: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100

647: , p13_a2 out nocopy JTF_VARCHAR2_TABLE_4000
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

Line 658: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
662: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 659: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
662: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
663: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 661: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
665: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 662: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
665: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
666: , p14_a10 out nocopy JTF_DATE_TABLE

Line 663: , p14_a7 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
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

Line 665: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 669: , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
673: ddx_mr_item_instances ahl_mr_loop_chain_relns_pvt.mr_item_instance_tbl_type;

Line 764: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
768: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 765: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
768: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
769: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 767: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
771: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 768: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
771: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
772: , p7_a10 out nocopy JTF_DATE_TABLE

Line 769: , p7_a7 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
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

Line 771: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 775: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
779: ddx_start_mr_relns ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type;