DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
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

Line 15: , a2 JTF_NUMBER_TABLE

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
19: , a6 JTF_VARCHAR2_TABLE_2000

Line 16: , a3 JTF_NUMBER_TABLE

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
19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE

Line 18: , a5 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
22: , a9 JTF_NUMBER_TABLE

Line 20: , a7 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
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE

Line 22: , a9 JTF_NUMBER_TABLE

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
26: , a13 JTF_VARCHAR2_TABLE_100

Line 24: , a11 JTF_NUMBER_TABLE

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
28: , a15 JTF_NUMBER_TABLE

Line 28: , a15 JTF_NUMBER_TABLE

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
31: , a18 JTF_VARCHAR2_TABLE_200
32: , a19 JTF_VARCHAR2_TABLE_200

Line 96: procedure rosetta_table_copy_out_p2(t ahl_mc_itemgroup_pvt.item_association_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

92: end loop;
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

Line 98: , a2 out nocopy JTF_NUMBER_TABLE

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
102: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 99: , a3 out nocopy JTF_NUMBER_TABLE

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
102: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
103: , a7 out nocopy JTF_NUMBER_TABLE

Line 101: , a5 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
105: , a9 out nocopy JTF_NUMBER_TABLE

Line 103: , a7 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
105: , a9 out nocopy JTF_NUMBER_TABLE
106: , a10 out nocopy JTF_VARCHAR2_TABLE_100
107: , a11 out nocopy JTF_NUMBER_TABLE

Line 105: , a9 out nocopy JTF_NUMBER_TABLE

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
109: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , a11 out nocopy JTF_NUMBER_TABLE

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
111: , a15 out nocopy JTF_NUMBER_TABLE

Line 111: , a15 out nocopy JTF_NUMBER_TABLE

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
114: , a18 out nocopy JTF_VARCHAR2_TABLE_200
115: , a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 133: a0 := JTF_NUMBER_TABLE();

129: ) as
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();

Line 135: a2 := JTF_NUMBER_TABLE();

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();
139: a6 := JTF_VARCHAR2_TABLE_2000();

Line 136: a3 := JTF_NUMBER_TABLE();

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();
139: a6 := JTF_VARCHAR2_TABLE_2000();
140: a7 := JTF_NUMBER_TABLE();

Line 138: a5 := 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();
142: a9 := JTF_NUMBER_TABLE();

Line 140: a7 := 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();
142: a9 := JTF_NUMBER_TABLE();
143: a10 := JTF_VARCHAR2_TABLE_100();
144: a11 := JTF_NUMBER_TABLE();

Line 142: a9 := JTF_NUMBER_TABLE();

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();
146: a13 := JTF_VARCHAR2_TABLE_100();

Line 144: a11 := JTF_NUMBER_TABLE();

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();
148: a15 := JTF_NUMBER_TABLE();

Line 148: a15 := JTF_NUMBER_TABLE();

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();
151: a18 := JTF_VARCHAR2_TABLE_200();
152: a19 := JTF_VARCHAR2_TABLE_200();

Line 167: a0 := JTF_NUMBER_TABLE();

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();
170: a3 := JTF_NUMBER_TABLE();
171: a4 := JTF_VARCHAR2_TABLE_100();

Line 169: a2 := JTF_NUMBER_TABLE();

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();
173: a6 := JTF_VARCHAR2_TABLE_2000();

Line 170: a3 := JTF_NUMBER_TABLE();

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();
173: a6 := JTF_VARCHAR2_TABLE_2000();
174: a7 := JTF_NUMBER_TABLE();

Line 172: a5 := 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();
176: a9 := JTF_NUMBER_TABLE();

Line 174: a7 := 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();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_NUMBER_TABLE();

Line 176: a9 := JTF_NUMBER_TABLE();

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();
180: a13 := JTF_VARCHAR2_TABLE_100();

Line 178: a11 := JTF_NUMBER_TABLE();

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();
182: a15 := JTF_NUMBER_TABLE();

Line 182: a15 := JTF_NUMBER_TABLE();

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();
185: a18 := JTF_VARCHAR2_TABLE_200();
186: a19 := JTF_VARCHAR2_TABLE_200();

Line 312: , p7_a0 in out nocopy JTF_NUMBER_TABLE

308: , p6_a22 in out nocopy VARCHAR2
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

Line 314: , p7_a2 in out nocopy JTF_NUMBER_TABLE

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
318: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 315: , p7_a3 in out nocopy JTF_NUMBER_TABLE

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
318: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
319: , p7_a7 in out nocopy JTF_NUMBER_TABLE

Line 317: , p7_a5 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
321: , p7_a9 in out nocopy JTF_NUMBER_TABLE

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

Line 321: , p7_a9 in out nocopy JTF_NUMBER_TABLE

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
325: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 323: , p7_a11 in out nocopy JTF_NUMBER_TABLE

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
327: , p7_a15 in out nocopy JTF_NUMBER_TABLE

Line 327: , p7_a15 in out nocopy JTF_NUMBER_TABLE

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
330: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
331: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200

Line 534: , p7_a0 in out nocopy JTF_NUMBER_TABLE

530: , p6_a22 VARCHAR2
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

Line 536: , p7_a2 in out nocopy JTF_NUMBER_TABLE

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
540: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 537: , p7_a3 in out nocopy JTF_NUMBER_TABLE

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
540: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_2000
541: , p7_a7 in out nocopy JTF_NUMBER_TABLE

Line 539: , p7_a5 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
543: , p7_a9 in out nocopy JTF_NUMBER_TABLE

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

Line 543: , p7_a9 in out nocopy JTF_NUMBER_TABLE

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
547: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 545: , p7_a11 in out nocopy JTF_NUMBER_TABLE

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
549: , p7_a15 in out nocopy JTF_NUMBER_TABLE

Line 549: , p7_a15 in out nocopy JTF_NUMBER_TABLE

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
552: , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
553: , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200

Line 799: , p10_a0 JTF_NUMBER_TABLE

795: , x_msg_count out nocopy NUMBER
796: , x_msg_data out nocopy VARCHAR2
797: , p_item_group_id NUMBER
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

Line 800: , p10_a1 JTF_NUMBER_TABLE

796: , x_msg_data out nocopy VARCHAR2
797: , p_item_group_id NUMBER
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

Line 801: , p10_a2 JTF_NUMBER_TABLE

797: , p_item_group_id NUMBER
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

Line 809: , p10_a10 JTF_NUMBER_TABLE

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
813: , p10_a14 JTF_NUMBER_TABLE

Line 810: , p10_a11 JTF_NUMBER_TABLE

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
813: , p10_a14 JTF_NUMBER_TABLE
814: , p10_a15 JTF_DATE_TABLE

Line 811: , p10_a12 JTF_NUMBER_TABLE

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
813: , p10_a14 JTF_NUMBER_TABLE
814: , p10_a15 JTF_DATE_TABLE
815: , p10_a16 JTF_DATE_TABLE

Line 813: , p10_a14 JTF_NUMBER_TABLE

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
817: , p10_a18 JTF_NUMBER_TABLE

Line 816: , p10_a17 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
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

Line 817: , p10_a18 JTF_NUMBER_TABLE

813: , p10_a14 JTF_NUMBER_TABLE
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

Line 835: , p10_a36 JTF_NUMBER_TABLE

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
839: ddp_nodes_tbl ahl_mc_node_pvt.node_tbl_type;