DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_VARCHAR2_TABLE_100

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100

Line 21: , a8 JTF_VARCHAR2_TABLE_100

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100

Line 23: , a10 JTF_VARCHAR2_TABLE_100

19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_2000

Line 25: , a12 JTF_VARCHAR2_TABLE_100

21: , a8 JTF_VARCHAR2_TABLE_100
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_2000
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100

Line 26: , a13 JTF_VARCHAR2_TABLE_100

22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_2000
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_VARCHAR2_TABLE_200

Line 29: , a16 JTF_VARCHAR2_TABLE_100

25: , a12 JTF_VARCHAR2_TABLE_100
26: , a13 JTF_VARCHAR2_TABLE_100
27: , a14 JTF_VARCHAR2_TABLE_2000
28: , a15 JTF_NUMBER_TABLE
29: , a16 JTF_VARCHAR2_TABLE_100
30: , a17 JTF_VARCHAR2_TABLE_200
31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_VARCHAR2_TABLE_200
33: , a20 JTF_VARCHAR2_TABLE_200

Line 45: , a32 JTF_VARCHAR2_TABLE_100

41: , a28 JTF_VARCHAR2_TABLE_200
42: , a29 JTF_VARCHAR2_TABLE_200
43: , a30 JTF_VARCHAR2_TABLE_200
44: , a31 JTF_VARCHAR2_TABLE_200
45: , a32 JTF_VARCHAR2_TABLE_100
46: ) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if a0 is not null and a0.count > 0 then

Line 97: , a1 out nocopy JTF_VARCHAR2_TABLE_100

93: end if;
94: end if;
95: end rosetta_table_copy_in_p2;
96: procedure rosetta_table_copy_out_p2(t ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_NUMBER_TABLE

Line 100: , a4 out nocopy JTF_VARCHAR2_TABLE_100

96: procedure rosetta_table_copy_out_p2(t ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_100
98: , a2 out nocopy JTF_NUMBER_TABLE
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , a8 out nocopy JTF_VARCHAR2_TABLE_100

100: , a4 out nocopy JTF_VARCHAR2_TABLE_100
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_100
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a10 out nocopy JTF_VARCHAR2_TABLE_100

102: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a7 out nocopy JTF_NUMBER_TABLE
104: , a8 out nocopy JTF_VARCHAR2_TABLE_100
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_VARCHAR2_TABLE_2000

Line 108: , a12 out nocopy JTF_VARCHAR2_TABLE_100

104: , a8 out nocopy JTF_VARCHAR2_TABLE_100
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a15 out nocopy JTF_NUMBER_TABLE
112: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a13 out nocopy JTF_VARCHAR2_TABLE_100

105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE
108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a15 out nocopy JTF_NUMBER_TABLE
112: , a16 out nocopy JTF_VARCHAR2_TABLE_100
113: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 112: , a16 out nocopy JTF_VARCHAR2_TABLE_100

108: , a12 out nocopy JTF_VARCHAR2_TABLE_100
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100
110: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a15 out nocopy JTF_NUMBER_TABLE
112: , a16 out nocopy JTF_VARCHAR2_TABLE_100
113: , a17 out nocopy JTF_VARCHAR2_TABLE_200
114: , a18 out nocopy JTF_VARCHAR2_TABLE_200
115: , a19 out nocopy JTF_VARCHAR2_TABLE_200
116: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 128: , a32 out nocopy JTF_VARCHAR2_TABLE_100

124: , a28 out nocopy JTF_VARCHAR2_TABLE_200
125: , a29 out nocopy JTF_VARCHAR2_TABLE_200
126: , a30 out nocopy JTF_VARCHAR2_TABLE_200
127: , a31 out nocopy JTF_VARCHAR2_TABLE_200
128: , a32 out nocopy JTF_VARCHAR2_TABLE_100
129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then

Line 134: a1 := JTF_VARCHAR2_TABLE_100();

130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_100();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_VARCHAR2_TABLE_100();
138: a5 := JTF_NUMBER_TABLE();

Line 137: a4 := JTF_VARCHAR2_TABLE_100();

133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_VARCHAR2_TABLE_100();
135: a2 := JTF_NUMBER_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_VARCHAR2_TABLE_100();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_VARCHAR2_TABLE_2000();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_100();

Line 141: a8 := JTF_VARCHAR2_TABLE_100();

137: a4 := JTF_VARCHAR2_TABLE_100();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_VARCHAR2_TABLE_2000();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_100();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_100();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();

Line 143: a10 := JTF_VARCHAR2_TABLE_100();

139: a6 := JTF_VARCHAR2_TABLE_2000();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_VARCHAR2_TABLE_100();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_100();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_VARCHAR2_TABLE_100();
147: a14 := JTF_VARCHAR2_TABLE_2000();

Line 145: a12 := JTF_VARCHAR2_TABLE_100();

141: a8 := JTF_VARCHAR2_TABLE_100();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_100();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_VARCHAR2_TABLE_100();
147: a14 := JTF_VARCHAR2_TABLE_2000();
148: a15 := JTF_NUMBER_TABLE();
149: a16 := JTF_VARCHAR2_TABLE_100();

Line 146: a13 := JTF_VARCHAR2_TABLE_100();

142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_100();
144: a11 := JTF_NUMBER_TABLE();
145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_VARCHAR2_TABLE_100();
147: a14 := JTF_VARCHAR2_TABLE_2000();
148: a15 := JTF_NUMBER_TABLE();
149: a16 := JTF_VARCHAR2_TABLE_100();
150: a17 := JTF_VARCHAR2_TABLE_200();

Line 149: a16 := JTF_VARCHAR2_TABLE_100();

145: a12 := JTF_VARCHAR2_TABLE_100();
146: a13 := JTF_VARCHAR2_TABLE_100();
147: a14 := JTF_VARCHAR2_TABLE_2000();
148: a15 := JTF_NUMBER_TABLE();
149: a16 := JTF_VARCHAR2_TABLE_100();
150: a17 := JTF_VARCHAR2_TABLE_200();
151: a18 := JTF_VARCHAR2_TABLE_200();
152: a19 := JTF_VARCHAR2_TABLE_200();
153: a20 := JTF_VARCHAR2_TABLE_200();

Line 165: a32 := JTF_VARCHAR2_TABLE_100();

161: a28 := JTF_VARCHAR2_TABLE_200();
162: a29 := JTF_VARCHAR2_TABLE_200();
163: a30 := JTF_VARCHAR2_TABLE_200();
164: a31 := JTF_VARCHAR2_TABLE_200();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();

Line 168: a1 := JTF_VARCHAR2_TABLE_100();

164: a31 := JTF_VARCHAR2_TABLE_200();
165: a32 := JTF_VARCHAR2_TABLE_100();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();

Line 171: a4 := JTF_VARCHAR2_TABLE_100();

167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_NUMBER_TABLE();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_2000();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();

Line 175: a8 := JTF_VARCHAR2_TABLE_100();

171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_2000();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();

Line 177: a10 := JTF_VARCHAR2_TABLE_100();

173: a6 := JTF_VARCHAR2_TABLE_2000();
174: a7 := JTF_NUMBER_TABLE();
175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_VARCHAR2_TABLE_100();
181: a14 := JTF_VARCHAR2_TABLE_2000();

Line 179: a12 := JTF_VARCHAR2_TABLE_100();

175: a8 := JTF_VARCHAR2_TABLE_100();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_VARCHAR2_TABLE_100();
181: a14 := JTF_VARCHAR2_TABLE_2000();
182: a15 := JTF_NUMBER_TABLE();
183: a16 := JTF_VARCHAR2_TABLE_100();

Line 180: a13 := JTF_VARCHAR2_TABLE_100();

176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_NUMBER_TABLE();
179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_VARCHAR2_TABLE_100();
181: a14 := JTF_VARCHAR2_TABLE_2000();
182: a15 := JTF_NUMBER_TABLE();
183: a16 := JTF_VARCHAR2_TABLE_100();
184: a17 := JTF_VARCHAR2_TABLE_200();

Line 183: a16 := JTF_VARCHAR2_TABLE_100();

179: a12 := JTF_VARCHAR2_TABLE_100();
180: a13 := JTF_VARCHAR2_TABLE_100();
181: a14 := JTF_VARCHAR2_TABLE_2000();
182: a15 := JTF_NUMBER_TABLE();
183: a16 := JTF_VARCHAR2_TABLE_100();
184: a17 := JTF_VARCHAR2_TABLE_200();
185: a18 := JTF_VARCHAR2_TABLE_200();
186: a19 := JTF_VARCHAR2_TABLE_200();
187: a20 := JTF_VARCHAR2_TABLE_200();

Line 199: a32 := JTF_VARCHAR2_TABLE_100();

195: a28 := JTF_VARCHAR2_TABLE_200();
196: a29 := JTF_VARCHAR2_TABLE_200();
197: a30 := JTF_VARCHAR2_TABLE_200();
198: a31 := JTF_VARCHAR2_TABLE_200();
199: a32 := JTF_VARCHAR2_TABLE_100();
200: if t.count > 0 then
201: a0.extend(t.count);
202: a1.extend(t.count);
203: a2.extend(t.count);

Line 313: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

309: , p6_a23 in out nocopy VARCHAR2
310: , p6_a24 in out nocopy VARCHAR2
311: , p6_a25 in out nocopy VARCHAR2
312: , p7_a0 in out nocopy JTF_NUMBER_TABLE
313: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p7_a2 in out nocopy JTF_NUMBER_TABLE
315: , p7_a3 in out nocopy JTF_NUMBER_TABLE
316: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a5 in out nocopy JTF_NUMBER_TABLE

Line 316: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100

312: , p7_a0 in out nocopy JTF_NUMBER_TABLE
313: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p7_a2 in out nocopy JTF_NUMBER_TABLE
315: , p7_a3 in out nocopy JTF_NUMBER_TABLE
316: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a5 in out nocopy JTF_NUMBER_TABLE
318: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p7_a7 in out nocopy JTF_NUMBER_TABLE
320: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 320: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100

316: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p7_a5 in out nocopy JTF_NUMBER_TABLE
318: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p7_a7 in out nocopy JTF_NUMBER_TABLE
320: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a9 in out nocopy JTF_NUMBER_TABLE
322: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a11 in out nocopy JTF_NUMBER_TABLE
324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 322: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100

318: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p7_a7 in out nocopy JTF_NUMBER_TABLE
320: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a9 in out nocopy JTF_NUMBER_TABLE
322: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a11 in out nocopy JTF_NUMBER_TABLE
324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

320: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a9 in out nocopy JTF_NUMBER_TABLE
322: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a11 in out nocopy JTF_NUMBER_TABLE
324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
327: , p7_a15 in out nocopy JTF_NUMBER_TABLE
328: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

321: , p7_a9 in out nocopy JTF_NUMBER_TABLE
322: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a11 in out nocopy JTF_NUMBER_TABLE
324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
327: , p7_a15 in out nocopy JTF_NUMBER_TABLE
328: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200

Line 328: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

324: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
327: , p7_a15 in out nocopy JTF_NUMBER_TABLE
328: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
330: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
331: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
332: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 344: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100

340: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_200
341: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_200
342: , p7_a30 in out nocopy JTF_VARCHAR2_TABLE_200
343: , p7_a31 in out nocopy JTF_VARCHAR2_TABLE_200
344: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100
345: )
346:
347: as
348: ddp_x_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;

Line 535: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

531: , p6_a23 VARCHAR2
532: , p6_a24 VARCHAR2
533: , p6_a25 VARCHAR2
534: , p7_a0 in out nocopy JTF_NUMBER_TABLE
535: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p7_a2 in out nocopy JTF_NUMBER_TABLE
537: , p7_a3 in out nocopy JTF_NUMBER_TABLE
538: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p7_a5 in out nocopy JTF_NUMBER_TABLE

Line 538: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100

534: , p7_a0 in out nocopy JTF_NUMBER_TABLE
535: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p7_a2 in out nocopy JTF_NUMBER_TABLE
537: , p7_a3 in out nocopy JTF_NUMBER_TABLE
538: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p7_a5 in out nocopy JTF_NUMBER_TABLE
540: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
541: , p7_a7 in out nocopy JTF_NUMBER_TABLE
542: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 542: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100

538: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p7_a5 in out nocopy JTF_NUMBER_TABLE
540: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
541: , p7_a7 in out nocopy JTF_NUMBER_TABLE
542: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p7_a9 in out nocopy JTF_NUMBER_TABLE
544: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p7_a11 in out nocopy JTF_NUMBER_TABLE
546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 544: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100

540: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
541: , p7_a7 in out nocopy JTF_NUMBER_TABLE
542: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p7_a9 in out nocopy JTF_NUMBER_TABLE
544: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p7_a11 in out nocopy JTF_NUMBER_TABLE
546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100

542: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p7_a9 in out nocopy JTF_NUMBER_TABLE
544: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p7_a11 in out nocopy JTF_NUMBER_TABLE
546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
549: , p7_a15 in out nocopy JTF_NUMBER_TABLE
550: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

543: , p7_a9 in out nocopy JTF_NUMBER_TABLE
544: , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p7_a11 in out nocopy JTF_NUMBER_TABLE
546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
549: , p7_a15 in out nocopy JTF_NUMBER_TABLE
550: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200

Line 550: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100

546: , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_100
547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
549: , p7_a15 in out nocopy JTF_NUMBER_TABLE
550: , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
552: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
553: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
554: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200

Line 566: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100

562: , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_200
563: , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_200
564: , p7_a30 in out nocopy JTF_VARCHAR2_TABLE_200
565: , p7_a31 in out nocopy JTF_VARCHAR2_TABLE_200
566: , p7_a32 in out nocopy JTF_VARCHAR2_TABLE_100
567: )
568:
569: as
570: ddp_item_group_rec ahl_mc_itemgroup_pvt.item_group_rec_type;

Line 802: , p10_a3 JTF_VARCHAR2_TABLE_100

798: , p_object_version_number NUMBER
799: , p10_a0 JTF_NUMBER_TABLE
800: , p10_a1 JTF_NUMBER_TABLE
801: , p10_a2 JTF_NUMBER_TABLE
802: , p10_a3 JTF_VARCHAR2_TABLE_100
803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100

Line 803: , p10_a4 JTF_VARCHAR2_TABLE_100

799: , p10_a0 JTF_NUMBER_TABLE
800: , p10_a1 JTF_NUMBER_TABLE
801: , p10_a2 JTF_NUMBER_TABLE
802: , p10_a3 JTF_VARCHAR2_TABLE_100
803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100

Line 804: , p10_a5 JTF_VARCHAR2_TABLE_100

800: , p10_a1 JTF_NUMBER_TABLE
801: , p10_a2 JTF_NUMBER_TABLE
802: , p10_a3 JTF_VARCHAR2_TABLE_100
803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100
808: , p10_a9 JTF_VARCHAR2_TABLE_100

Line 805: , p10_a6 JTF_VARCHAR2_TABLE_100

801: , p10_a2 JTF_NUMBER_TABLE
802: , p10_a3 JTF_VARCHAR2_TABLE_100
803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100
808: , p10_a9 JTF_VARCHAR2_TABLE_100
809: , p10_a10 JTF_NUMBER_TABLE

Line 806: , p10_a7 JTF_VARCHAR2_TABLE_100

802: , p10_a3 JTF_VARCHAR2_TABLE_100
803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100
808: , p10_a9 JTF_VARCHAR2_TABLE_100
809: , p10_a10 JTF_NUMBER_TABLE
810: , p10_a11 JTF_NUMBER_TABLE

Line 807: , p10_a8 JTF_VARCHAR2_TABLE_100

803: , p10_a4 JTF_VARCHAR2_TABLE_100
804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100
808: , p10_a9 JTF_VARCHAR2_TABLE_100
809: , p10_a10 JTF_NUMBER_TABLE
810: , p10_a11 JTF_NUMBER_TABLE
811: , p10_a12 JTF_NUMBER_TABLE

Line 808: , p10_a9 JTF_VARCHAR2_TABLE_100

804: , p10_a5 JTF_VARCHAR2_TABLE_100
805: , p10_a6 JTF_VARCHAR2_TABLE_100
806: , p10_a7 JTF_VARCHAR2_TABLE_100
807: , p10_a8 JTF_VARCHAR2_TABLE_100
808: , p10_a9 JTF_VARCHAR2_TABLE_100
809: , p10_a10 JTF_NUMBER_TABLE
810: , p10_a11 JTF_NUMBER_TABLE
811: , p10_a12 JTF_NUMBER_TABLE
812: , p10_a13 JTF_VARCHAR2_TABLE_100

Line 812: , p10_a13 JTF_VARCHAR2_TABLE_100

808: , p10_a9 JTF_VARCHAR2_TABLE_100
809: , p10_a10 JTF_NUMBER_TABLE
810: , p10_a11 JTF_NUMBER_TABLE
811: , p10_a12 JTF_NUMBER_TABLE
812: , p10_a13 JTF_VARCHAR2_TABLE_100
813: , p10_a14 JTF_NUMBER_TABLE
814: , p10_a15 JTF_DATE_TABLE
815: , p10_a16 JTF_DATE_TABLE
816: , p10_a17 JTF_NUMBER_TABLE

Line 818: , p10_a19 JTF_VARCHAR2_TABLE_100

814: , p10_a15 JTF_DATE_TABLE
815: , p10_a16 JTF_DATE_TABLE
816: , p10_a17 JTF_NUMBER_TABLE
817: , p10_a18 JTF_NUMBER_TABLE
818: , p10_a19 JTF_VARCHAR2_TABLE_100
819: , p10_a20 JTF_VARCHAR2_TABLE_200
820: , p10_a21 JTF_VARCHAR2_TABLE_200
821: , p10_a22 JTF_VARCHAR2_TABLE_200
822: , p10_a23 JTF_VARCHAR2_TABLE_200

Line 834: , p10_a35 JTF_VARCHAR2_TABLE_100

830: , p10_a31 JTF_VARCHAR2_TABLE_200
831: , p10_a32 JTF_VARCHAR2_TABLE_200
832: , p10_a33 JTF_VARCHAR2_TABLE_200
833: , p10_a34 JTF_VARCHAR2_TABLE_200
834: , p10_a35 JTF_VARCHAR2_TABLE_100
835: , p10_a36 JTF_NUMBER_TABLE
836: )
837:
838: as