DBA Data[Home] [Help]

APPS.AHL_FMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 23: , a7 JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as

Line 24: , a8 JTF_NUMBER_TABLE

20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;

Line 25: , a9 JTF_NUMBER_TABLE

21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 26: , a10 JTF_NUMBER_TABLE

22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 62: , a7 out nocopy JTF_NUMBER_TABLE

58: , a3 out nocopy JTF_VARCHAR2_TABLE_100
59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as

Line 63: , a8 out nocopy JTF_NUMBER_TABLE

59: , a4 out nocopy JTF_VARCHAR2_TABLE_400
60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;

Line 64: , a9 out nocopy JTF_NUMBER_TABLE

60: , a5 out nocopy JTF_VARCHAR2_TABLE_300
61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin

Line 65: , a10 out nocopy JTF_NUMBER_TABLE

61: , a6 out nocopy JTF_VARCHAR2_TABLE_100
62: , a7 out nocopy JTF_NUMBER_TABLE
63: , a8 out nocopy JTF_NUMBER_TABLE
64: , a9 out nocopy JTF_NUMBER_TABLE
65: , a10 out nocopy JTF_NUMBER_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 77: a7 := JTF_NUMBER_TABLE();

73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else

Line 78: a8 := JTF_NUMBER_TABLE();

74: a4 := JTF_VARCHAR2_TABLE_400();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();

Line 79: a9 := JTF_NUMBER_TABLE();

75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();

Line 80: a10 := JTF_NUMBER_TABLE();

76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: else
82: a0 := JTF_VARCHAR2_TABLE_100();
83: a1 := JTF_VARCHAR2_TABLE_100();
84: a2 := JTF_VARCHAR2_TABLE_4000();

Line 89: a7 := JTF_NUMBER_TABLE();

85: a3 := JTF_VARCHAR2_TABLE_100();
86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then

Line 90: a8 := JTF_NUMBER_TABLE();

86: a4 := JTF_VARCHAR2_TABLE_400();
87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);

Line 91: a9 := JTF_NUMBER_TABLE();

87: a5 := JTF_VARCHAR2_TABLE_300();
88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);

Line 92: a10 := JTF_NUMBER_TABLE();

88: a6 := JTF_VARCHAR2_TABLE_100();
89: a7 := JTF_NUMBER_TABLE();
90: a8 := JTF_NUMBER_TABLE();
91: a9 := JTF_NUMBER_TABLE();
92: a10 := JTF_NUMBER_TABLE();
93: if t.count > 0 then
94: a0.extend(t.count);
95: a1.extend(t.count);
96: a2.extend(t.count);

Line 129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE

125: end if;
126: end if;
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100

Line 130: , a1 JTF_NUMBER_TABLE

126: end if;
127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE

Line 131: , a2 JTF_NUMBER_TABLE

127: end rosetta_table_copy_out_p1;
128:
129: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100

Line 134: , a5 JTF_NUMBER_TABLE

130: , a1 JTF_NUMBER_TABLE
131: , a2 JTF_NUMBER_TABLE
132: , a3 JTF_VARCHAR2_TABLE_100
133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as

Line 137: , a8 JTF_NUMBER_TABLE

133: , a4 JTF_VARCHAR2_TABLE_100
134: , a5 JTF_NUMBER_TABLE
135: , a6 JTF_VARCHAR2_TABLE_100
136: , a7 JTF_VARCHAR2_TABLE_100
137: , a8 JTF_NUMBER_TABLE
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if a0 is not null and a0.count > 0 then

Line 164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 165: , a1 out nocopy JTF_NUMBER_TABLE

161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE

Line 166: , a2 out nocopy JTF_NUMBER_TABLE

162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 169: , a5 out nocopy JTF_NUMBER_TABLE

165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_NUMBER_TABLE
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE
173: ) as

Line 172: , a8 out nocopy JTF_NUMBER_TABLE

168: , a4 out nocopy JTF_VARCHAR2_TABLE_100
169: , a5 out nocopy JTF_NUMBER_TABLE
170: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: , a7 out nocopy JTF_VARCHAR2_TABLE_100
172: , a8 out nocopy JTF_NUMBER_TABLE
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then

Line 177: a0 := JTF_NUMBER_TABLE();

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

Line 178: a1 := JTF_NUMBER_TABLE();

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

Line 179: a2 := JTF_NUMBER_TABLE();

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

Line 182: a5 := JTF_NUMBER_TABLE();

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

Line 185: a8 := JTF_NUMBER_TABLE();

181: a4 := JTF_VARCHAR2_TABLE_100();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();

Line 187: a0 := JTF_NUMBER_TABLE();

183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();

Line 188: a1 := JTF_NUMBER_TABLE();

184: a7 := JTF_VARCHAR2_TABLE_100();
185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();

Line 189: a2 := JTF_NUMBER_TABLE();

185: a8 := JTF_NUMBER_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();

Line 192: a5 := JTF_NUMBER_TABLE();

188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_NUMBER_TABLE();
190: a3 := JTF_VARCHAR2_TABLE_100();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then

Line 195: a8 := JTF_NUMBER_TABLE();

191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_NUMBER_TABLE();
193: a6 := JTF_VARCHAR2_TABLE_100();
194: a7 := JTF_VARCHAR2_TABLE_100();
195: a8 := JTF_NUMBER_TABLE();
196: if t.count > 0 then
197: a0.extend(t.count);
198: a1.extend(t.count);
199: a2.extend(t.count);

Line 228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE

224: end if;
225: end if;
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE

Line 229: , a1 JTF_NUMBER_TABLE

225: end if;
226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100

Line 230: , a2 JTF_NUMBER_TABLE

226: end rosetta_table_copy_out_p3;
227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100

Line 231: , a3 JTF_NUMBER_TABLE

227:
228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100

Line 232: , a4 JTF_NUMBER_TABLE

228: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
229: , a1 JTF_NUMBER_TABLE
230: , a2 JTF_NUMBER_TABLE
231: , a3 JTF_NUMBER_TABLE
232: , a4 JTF_NUMBER_TABLE
233: , a5 JTF_VARCHAR2_TABLE_100
234: , a6 JTF_VARCHAR2_TABLE_100
235: , a7 JTF_VARCHAR2_TABLE_100
236: , a8 JTF_VARCHAR2_TABLE_100

Line 265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

261: end loop;
262: end if;
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE

Line 266: , a1 out nocopy JTF_NUMBER_TABLE

262: end if;
263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , a2 out nocopy JTF_NUMBER_TABLE

263: end if;
264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , a3 out nocopy JTF_NUMBER_TABLE

264: end rosetta_table_copy_in_p5;
265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , a4 out nocopy JTF_NUMBER_TABLE

265: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
266: , a1 out nocopy JTF_NUMBER_TABLE
267: , a2 out nocopy JTF_NUMBER_TABLE
268: , a3 out nocopy JTF_NUMBER_TABLE
269: , a4 out nocopy JTF_NUMBER_TABLE
270: , a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , a6 out nocopy JTF_VARCHAR2_TABLE_100
272: , a7 out nocopy JTF_VARCHAR2_TABLE_100
273: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: a0 := JTF_NUMBER_TABLE();

275: ) as
276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();

Line 280: a1 := JTF_NUMBER_TABLE();

276: ddindx binary_integer; indx binary_integer;
277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();

Line 281: a2 := JTF_NUMBER_TABLE();

277: begin
278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();

Line 282: a3 := JTF_NUMBER_TABLE();

278: if t is null or t.count = 0 then
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();

Line 283: a4 := JTF_NUMBER_TABLE();

279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_NUMBER_TABLE();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_NUMBER_TABLE();
283: a4 := JTF_NUMBER_TABLE();
284: a5 := JTF_VARCHAR2_TABLE_100();
285: a6 := JTF_VARCHAR2_TABLE_100();
286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();

Line 290: a0 := JTF_NUMBER_TABLE();

286: a7 := JTF_VARCHAR2_TABLE_100();
287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();

Line 291: a1 := JTF_NUMBER_TABLE();

287: a8 := JTF_VARCHAR2_TABLE_100();
288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();

Line 292: a2 := JTF_NUMBER_TABLE();

288: a9 := JTF_VARCHAR2_TABLE_100();
289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();

Line 293: a3 := JTF_NUMBER_TABLE();

289: else
290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();

Line 294: a4 := JTF_NUMBER_TABLE();

290: a0 := JTF_NUMBER_TABLE();
291: a1 := JTF_NUMBER_TABLE();
292: a2 := JTF_NUMBER_TABLE();
293: a3 := JTF_NUMBER_TABLE();
294: a4 := JTF_NUMBER_TABLE();
295: a5 := JTF_VARCHAR2_TABLE_100();
296: a6 := JTF_VARCHAR2_TABLE_100();
297: a7 := JTF_VARCHAR2_TABLE_100();
298: a8 := JTF_VARCHAR2_TABLE_100();

Line 334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE

330: end if;
331: end if;
332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE

Line 338: , a4 JTF_NUMBER_TABLE

334: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_VARCHAR2_TABLE_200
336: , a2 JTF_VARCHAR2_TABLE_200
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_VARCHAR2_TABLE_300
340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200

Line 341: , a7 JTF_NUMBER_TABLE

337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_NUMBER_TABLE
339: , a5 JTF_VARCHAR2_TABLE_300
340: , a6 JTF_VARCHAR2_TABLE_300
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100

Line 346: , a12 JTF_NUMBER_TABLE

342: , a8 JTF_VARCHAR2_TABLE_200
343: , a9 JTF_VARCHAR2_TABLE_2000
344: , a10 JTF_VARCHAR2_TABLE_100
345: , a11 JTF_VARCHAR2_TABLE_100
346: , a12 JTF_NUMBER_TABLE
347: , a13 JTF_DATE_TABLE
348: , a14 JTF_DATE_TABLE
349: , a15 JTF_VARCHAR2_TABLE_100
350: , a16 JTF_VARCHAR2_TABLE_100

Line 358: , a24 JTF_NUMBER_TABLE

354: , a20 JTF_VARCHAR2_TABLE_2000
355: , a21 JTF_DATE_TABLE
356: , a22 JTF_VARCHAR2_TABLE_100
357: , a23 JTF_VARCHAR2_TABLE_500
358: , a24 JTF_NUMBER_TABLE
359: ) as
360: ddindx binary_integer; indx binary_integer;
361: begin
362: if a0 is not null and a0.count > 0 then

Line 401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

397: end loop;
398: end if;
399: end if;
400: end rosetta_table_copy_in_p7;
401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE

Line 405: , a4 out nocopy JTF_NUMBER_TABLE

401: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
402: , a1 out nocopy JTF_VARCHAR2_TABLE_200
403: , a2 out nocopy JTF_VARCHAR2_TABLE_200
404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
406: , a5 out nocopy JTF_VARCHAR2_TABLE_300
407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 408: , a7 out nocopy JTF_NUMBER_TABLE

404: , a3 out nocopy JTF_VARCHAR2_TABLE_100
405: , a4 out nocopy JTF_NUMBER_TABLE
406: , a5 out nocopy JTF_VARCHAR2_TABLE_300
407: , a6 out nocopy JTF_VARCHAR2_TABLE_300
408: , a7 out nocopy JTF_NUMBER_TABLE
409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 413: , a12 out nocopy JTF_NUMBER_TABLE

409: , a8 out nocopy JTF_VARCHAR2_TABLE_200
410: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
411: , a10 out nocopy JTF_VARCHAR2_TABLE_100
412: , a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , a12 out nocopy JTF_NUMBER_TABLE
414: , a13 out nocopy JTF_DATE_TABLE
415: , a14 out nocopy JTF_DATE_TABLE
416: , a15 out nocopy JTF_VARCHAR2_TABLE_100
417: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , a24 out nocopy JTF_NUMBER_TABLE

421: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
422: , a21 out nocopy JTF_DATE_TABLE
423: , a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , a23 out nocopy JTF_VARCHAR2_TABLE_500
425: , a24 out nocopy JTF_NUMBER_TABLE
426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then

Line 430: a0 := JTF_NUMBER_TABLE();

426: ) as
427: ddindx binary_integer; indx binary_integer;
428: begin
429: if t is null or t.count = 0 then
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_200();
432: a2 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();

Line 434: a4 := JTF_NUMBER_TABLE();

430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_VARCHAR2_TABLE_200();
432: a2 := JTF_VARCHAR2_TABLE_200();
433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
435: a5 := JTF_VARCHAR2_TABLE_300();
436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();

Line 437: a7 := JTF_NUMBER_TABLE();

433: a3 := JTF_VARCHAR2_TABLE_100();
434: a4 := JTF_NUMBER_TABLE();
435: a5 := JTF_VARCHAR2_TABLE_300();
436: a6 := JTF_VARCHAR2_TABLE_300();
437: a7 := JTF_NUMBER_TABLE();
438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();

Line 442: a12 := JTF_NUMBER_TABLE();

438: a8 := JTF_VARCHAR2_TABLE_200();
439: a9 := JTF_VARCHAR2_TABLE_2000();
440: a10 := JTF_VARCHAR2_TABLE_100();
441: a11 := JTF_VARCHAR2_TABLE_100();
442: a12 := JTF_NUMBER_TABLE();
443: a13 := JTF_DATE_TABLE();
444: a14 := JTF_DATE_TABLE();
445: a15 := JTF_VARCHAR2_TABLE_100();
446: a16 := JTF_VARCHAR2_TABLE_100();

Line 454: a24 := JTF_NUMBER_TABLE();

450: a20 := JTF_VARCHAR2_TABLE_2000();
451: a21 := JTF_DATE_TABLE();
452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();
454: a24 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();

Line 456: a0 := JTF_NUMBER_TABLE();

452: a22 := JTF_VARCHAR2_TABLE_100();
453: a23 := JTF_VARCHAR2_TABLE_500();
454: a24 := JTF_NUMBER_TABLE();
455: else
456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();

Line 460: a4 := JTF_NUMBER_TABLE();

456: a0 := JTF_NUMBER_TABLE();
457: a1 := JTF_VARCHAR2_TABLE_200();
458: a2 := JTF_VARCHAR2_TABLE_200();
459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
461: a5 := JTF_VARCHAR2_TABLE_300();
462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();

Line 463: a7 := JTF_NUMBER_TABLE();

459: a3 := JTF_VARCHAR2_TABLE_100();
460: a4 := JTF_NUMBER_TABLE();
461: a5 := JTF_VARCHAR2_TABLE_300();
462: a6 := JTF_VARCHAR2_TABLE_300();
463: a7 := JTF_NUMBER_TABLE();
464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();

Line 468: a12 := JTF_NUMBER_TABLE();

464: a8 := JTF_VARCHAR2_TABLE_200();
465: a9 := JTF_VARCHAR2_TABLE_2000();
466: a10 := JTF_VARCHAR2_TABLE_100();
467: a11 := JTF_VARCHAR2_TABLE_100();
468: a12 := JTF_NUMBER_TABLE();
469: a13 := JTF_DATE_TABLE();
470: a14 := JTF_DATE_TABLE();
471: a15 := JTF_VARCHAR2_TABLE_100();
472: a16 := JTF_VARCHAR2_TABLE_100();

Line 480: a24 := JTF_NUMBER_TABLE();

476: a20 := JTF_VARCHAR2_TABLE_2000();
477: a21 := JTF_DATE_TABLE();
478: a22 := JTF_VARCHAR2_TABLE_100();
479: a23 := JTF_VARCHAR2_TABLE_500();
480: a24 := JTF_NUMBER_TABLE();
481: if t.count > 0 then
482: a0.extend(t.count);
483: a1.extend(t.count);
484: a2.extend(t.count);

Line 564: , p12_a7 out nocopy JTF_NUMBER_TABLE

560: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )

Line 565: , p12_a8 out nocopy JTF_NUMBER_TABLE

561: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:

Line 566: , p12_a9 out nocopy JTF_NUMBER_TABLE

562: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
570: as

Line 567: , p12_a10 out nocopy JTF_NUMBER_TABLE

563: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
564: , p12_a7 out nocopy JTF_NUMBER_TABLE
565: , p12_a8 out nocopy JTF_NUMBER_TABLE
566: , p12_a9 out nocopy JTF_NUMBER_TABLE
567: , p12_a10 out nocopy JTF_NUMBER_TABLE
568: )
569:
570: as
571: ddx_mr_item_inst_tbl ahl_fmp_pvt.mr_item_instance_tbl_type;

Line 643: , p12_a0 out nocopy JTF_NUMBER_TABLE

639: , p_mr_header_id NUMBER
640: , p_components_flag VARCHAR2
641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 644: , p12_a1 out nocopy JTF_NUMBER_TABLE

640: , p_components_flag VARCHAR2
641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE

Line 645: , p12_a2 out nocopy JTF_NUMBER_TABLE

641: , p_include_donotimplmt VARCHAR2
642: , p_visit_type_code VARCHAR2
643: , p12_a0 out nocopy JTF_NUMBER_TABLE
644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 648: , p12_a5 out nocopy JTF_NUMBER_TABLE

644: , p12_a1 out nocopy JTF_NUMBER_TABLE
645: , p12_a2 out nocopy JTF_NUMBER_TABLE
646: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )

Line 651: , p12_a8 out nocopy JTF_NUMBER_TABLE

647: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
648: , p12_a5 out nocopy JTF_NUMBER_TABLE
649: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
650: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
651: , p12_a8 out nocopy JTF_NUMBER_TABLE
652: )
653:
654: as
655: ddx_applicable_mr_tbl ahl_fmp_pvt.applicable_mr_tbl_type;

Line 721: , p8_a0 out nocopy JTF_NUMBER_TABLE

717: , x_return_status out nocopy VARCHAR2
718: , x_msg_count out nocopy NUMBER
719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE

Line 722: , p8_a1 out nocopy JTF_NUMBER_TABLE

718: , x_msg_count out nocopy NUMBER
719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 723: , p8_a2 out nocopy JTF_NUMBER_TABLE

719: , x_msg_data out nocopy VARCHAR2
720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 724: , p8_a3 out nocopy JTF_NUMBER_TABLE

720: , p_item_instance_id NUMBER
721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 725: , p8_a4 out nocopy JTF_NUMBER_TABLE

721: , p8_a0 out nocopy JTF_NUMBER_TABLE
722: , p8_a1 out nocopy JTF_NUMBER_TABLE
723: , p8_a2 out nocopy JTF_NUMBER_TABLE
724: , p8_a3 out nocopy JTF_NUMBER_TABLE
725: , p8_a4 out nocopy JTF_NUMBER_TABLE
726: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 731: , p9_a0 out nocopy JTF_NUMBER_TABLE

727: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
728: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
729: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
730: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 735: , p9_a4 out nocopy JTF_NUMBER_TABLE

731: , p9_a0 out nocopy JTF_NUMBER_TABLE
732: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
733: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
736: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 738: , p9_a7 out nocopy JTF_NUMBER_TABLE

734: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
735: , p9_a4 out nocopy JTF_NUMBER_TABLE
736: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
737: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
738: , p9_a7 out nocopy JTF_NUMBER_TABLE
739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 743: , p9_a12 out nocopy JTF_NUMBER_TABLE

739: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
740: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
741: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
742: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
743: , p9_a12 out nocopy JTF_NUMBER_TABLE
744: , p9_a13 out nocopy JTF_DATE_TABLE
745: , p9_a14 out nocopy JTF_DATE_TABLE
746: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
747: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 755: , p9_a24 out nocopy JTF_NUMBER_TABLE

751: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
752: , p9_a21 out nocopy JTF_DATE_TABLE
753: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
754: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
755: , p9_a24 out nocopy JTF_NUMBER_TABLE
756: )
757:
758: as
759: ddx_applicable_activities_tbl ahl_fmp_pvt.applicable_activities_tbl_type;