[Home] [Help]
PACKAGE: APPS.AHL_AMP_WORKBENCH_PVT_W
Source
1 package ahl_amp_workbench_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWAMPS.pls 120.0.12020000.2 2012/12/11 05:49:14 prakkum noship $ */
3 procedure rosetta_table_copy_in_p6(t out nocopy ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_300
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_DATE_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_DATE_TABLE
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_VARCHAR2_TABLE_100
35 , a32 JTF_DATE_TABLE
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_DATE_TABLE
39 , a36 JTF_NUMBER_TABLE
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_DATE_TABLE
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_DATE_TABLE
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_VARCHAR2_TABLE_100
47 , a44 JTF_DATE_TABLE
48 , a45 JTF_NUMBER_TABLE
49 , a46 JTF_VARCHAR2_TABLE_100
50 , a47 JTF_DATE_TABLE
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_VARCHAR2_TABLE_100
53 , a50 JTF_DATE_TABLE
54 , a51 JTF_NUMBER_TABLE
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_DATE_TABLE
57 , a54 JTF_NUMBER_TABLE
58 , a55 JTF_VARCHAR2_TABLE_100
59 , a56 JTF_DATE_TABLE
60 , a57 JTF_NUMBER_TABLE
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_DATE_TABLE
63 , a60 JTF_NUMBER_TABLE
64 , a61 JTF_VARCHAR2_TABLE_100
65 , a62 JTF_DATE_TABLE
66 , a63 JTF_NUMBER_TABLE
67 , a64 JTF_VARCHAR2_TABLE_100
68 , a65 JTF_DATE_TABLE
69 , a66 JTF_NUMBER_TABLE
70 , a67 JTF_VARCHAR2_TABLE_100
71 , a68 JTF_DATE_TABLE
72 , a69 JTF_NUMBER_TABLE
73 , a70 JTF_NUMBER_TABLE
74 );
75 procedure rosetta_table_copy_out_p6(t ahl_amp_workbench_pvt.sch_graph_results_tbl, a0 out nocopy JTF_NUMBER_TABLE
76 , a1 out nocopy JTF_NUMBER_TABLE
77 , a2 out nocopy JTF_VARCHAR2_TABLE_300
78 , a3 out nocopy JTF_NUMBER_TABLE
79 , a4 out nocopy JTF_VARCHAR2_TABLE_100
80 , a5 out nocopy JTF_NUMBER_TABLE
81 , a6 out nocopy JTF_VARCHAR2_TABLE_300
82 , a7 out nocopy JTF_VARCHAR2_TABLE_100
83 , a8 out nocopy JTF_DATE_TABLE
84 , a9 out nocopy JTF_NUMBER_TABLE
85 , a10 out nocopy JTF_VARCHAR2_TABLE_100
86 , a11 out nocopy JTF_DATE_TABLE
87 , a12 out nocopy JTF_NUMBER_TABLE
88 , a13 out nocopy JTF_VARCHAR2_TABLE_100
89 , a14 out nocopy JTF_DATE_TABLE
90 , a15 out nocopy JTF_NUMBER_TABLE
91 , a16 out nocopy JTF_VARCHAR2_TABLE_100
92 , a17 out nocopy JTF_DATE_TABLE
93 , a18 out nocopy JTF_NUMBER_TABLE
94 , a19 out nocopy JTF_VARCHAR2_TABLE_100
95 , a20 out nocopy JTF_DATE_TABLE
96 , a21 out nocopy JTF_NUMBER_TABLE
97 , a22 out nocopy JTF_VARCHAR2_TABLE_100
98 , a23 out nocopy JTF_DATE_TABLE
99 , a24 out nocopy JTF_NUMBER_TABLE
100 , a25 out nocopy JTF_VARCHAR2_TABLE_100
101 , a26 out nocopy JTF_DATE_TABLE
102 , a27 out nocopy JTF_NUMBER_TABLE
103 , a28 out nocopy JTF_VARCHAR2_TABLE_100
104 , a29 out nocopy JTF_DATE_TABLE
105 , a30 out nocopy JTF_NUMBER_TABLE
106 , a31 out nocopy JTF_VARCHAR2_TABLE_100
107 , a32 out nocopy JTF_DATE_TABLE
108 , a33 out nocopy JTF_NUMBER_TABLE
109 , a34 out nocopy JTF_VARCHAR2_TABLE_100
110 , a35 out nocopy JTF_DATE_TABLE
111 , a36 out nocopy JTF_NUMBER_TABLE
112 , a37 out nocopy JTF_VARCHAR2_TABLE_100
113 , a38 out nocopy JTF_DATE_TABLE
114 , a39 out nocopy JTF_NUMBER_TABLE
115 , a40 out nocopy JTF_VARCHAR2_TABLE_100
116 , a41 out nocopy JTF_DATE_TABLE
117 , a42 out nocopy JTF_NUMBER_TABLE
118 , a43 out nocopy JTF_VARCHAR2_TABLE_100
119 , a44 out nocopy JTF_DATE_TABLE
120 , a45 out nocopy JTF_NUMBER_TABLE
121 , a46 out nocopy JTF_VARCHAR2_TABLE_100
122 , a47 out nocopy JTF_DATE_TABLE
123 , a48 out nocopy JTF_NUMBER_TABLE
124 , a49 out nocopy JTF_VARCHAR2_TABLE_100
125 , a50 out nocopy JTF_DATE_TABLE
126 , a51 out nocopy JTF_NUMBER_TABLE
127 , a52 out nocopy JTF_VARCHAR2_TABLE_100
128 , a53 out nocopy JTF_DATE_TABLE
129 , a54 out nocopy JTF_NUMBER_TABLE
130 , a55 out nocopy JTF_VARCHAR2_TABLE_100
131 , a56 out nocopy JTF_DATE_TABLE
132 , a57 out nocopy JTF_NUMBER_TABLE
133 , a58 out nocopy JTF_VARCHAR2_TABLE_100
134 , a59 out nocopy JTF_DATE_TABLE
135 , a60 out nocopy JTF_NUMBER_TABLE
136 , a61 out nocopy JTF_VARCHAR2_TABLE_100
137 , a62 out nocopy JTF_DATE_TABLE
138 , a63 out nocopy JTF_NUMBER_TABLE
139 , a64 out nocopy JTF_VARCHAR2_TABLE_100
140 , a65 out nocopy JTF_DATE_TABLE
141 , a66 out nocopy JTF_NUMBER_TABLE
142 , a67 out nocopy JTF_VARCHAR2_TABLE_100
143 , a68 out nocopy JTF_DATE_TABLE
144 , a69 out nocopy JTF_NUMBER_TABLE
145 , a70 out nocopy JTF_NUMBER_TABLE
146 );
147
148 procedure rosetta_table_copy_in_p7(t out nocopy ahl_amp_workbench_pvt.sch_visits_tbl, a0 JTF_NUMBER_TABLE
149 , a1 JTF_DATE_TABLE
150 , a2 JTF_DATE_TABLE
151 );
152 procedure rosetta_table_copy_out_p7(t ahl_amp_workbench_pvt.sch_visits_tbl, a0 out nocopy JTF_NUMBER_TABLE
153 , a1 out nocopy JTF_DATE_TABLE
154 , a2 out nocopy JTF_DATE_TABLE
155 );
156
157 procedure rosetta_table_copy_in_p8(t out nocopy ahl_amp_workbench_pvt.resource_input_tbl_type, a0 JTF_NUMBER_TABLE
158 , a1 JTF_NUMBER_TABLE
159 );
160 procedure rosetta_table_copy_out_p8(t ahl_amp_workbench_pvt.resource_input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
161 , a1 out nocopy JTF_NUMBER_TABLE
162 );
163
164 procedure rosetta_table_copy_in_p9(t out nocopy ahl_amp_workbench_pvt.resource_output_tbl_type, a0 JTF_DATE_TABLE
165 , a1 JTF_NUMBER_TABLE
166 , a2 JTF_NUMBER_TABLE
167 , a3 JTF_NUMBER_TABLE
168 , a4 JTF_NUMBER_TABLE
169 , a5 JTF_NUMBER_TABLE
170 , a6 JTF_NUMBER_TABLE
171 );
172 procedure rosetta_table_copy_out_p9(t ahl_amp_workbench_pvt.resource_output_tbl_type, a0 out nocopy JTF_DATE_TABLE
173 , a1 out nocopy JTF_NUMBER_TABLE
174 , a2 out nocopy JTF_NUMBER_TABLE
175 , a3 out nocopy JTF_NUMBER_TABLE
176 , a4 out nocopy JTF_NUMBER_TABLE
177 , a5 out nocopy JTF_NUMBER_TABLE
178 , a6 out nocopy JTF_NUMBER_TABLE
179 );
180
181 procedure get_org_sch_graph(p_api_version NUMBER
182 , p_init_msg_list VARCHAR2
183 , p_validation_level NUMBER
184 , x_return_status out nocopy VARCHAR2
185 , x_msg_count out nocopy NUMBER
186 , x_msg_data out nocopy VARCHAR2
187 , p6_a0 NUMBER
188 , p6_a1 NUMBER
189 , p6_a2 NUMBER
190 , p6_a3 VARCHAR2
191 , p6_a4 VARCHAR2
192 , p6_a5 DATE
193 , p6_a6 DATE
194 , p6_a7 NUMBER
195 , p6_a8 VARCHAR2
196 , p7_a0 out nocopy JTF_NUMBER_TABLE
197 , p7_a1 out nocopy JTF_NUMBER_TABLE
198 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
199 , p7_a3 out nocopy JTF_NUMBER_TABLE
200 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
201 , p7_a5 out nocopy JTF_NUMBER_TABLE
202 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
203 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
204 , p7_a8 out nocopy JTF_DATE_TABLE
205 , p7_a9 out nocopy JTF_NUMBER_TABLE
206 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
207 , p7_a11 out nocopy JTF_DATE_TABLE
208 , p7_a12 out nocopy JTF_NUMBER_TABLE
209 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
210 , p7_a14 out nocopy JTF_DATE_TABLE
211 , p7_a15 out nocopy JTF_NUMBER_TABLE
212 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
213 , p7_a17 out nocopy JTF_DATE_TABLE
214 , p7_a18 out nocopy JTF_NUMBER_TABLE
215 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
216 , p7_a20 out nocopy JTF_DATE_TABLE
217 , p7_a21 out nocopy JTF_NUMBER_TABLE
218 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
219 , p7_a23 out nocopy JTF_DATE_TABLE
220 , p7_a24 out nocopy JTF_NUMBER_TABLE
221 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
222 , p7_a26 out nocopy JTF_DATE_TABLE
223 , p7_a27 out nocopy JTF_NUMBER_TABLE
224 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
225 , p7_a29 out nocopy JTF_DATE_TABLE
226 , p7_a30 out nocopy JTF_NUMBER_TABLE
227 , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
228 , p7_a32 out nocopy JTF_DATE_TABLE
229 , p7_a33 out nocopy JTF_NUMBER_TABLE
230 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
231 , p7_a35 out nocopy JTF_DATE_TABLE
232 , p7_a36 out nocopy JTF_NUMBER_TABLE
233 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
234 , p7_a38 out nocopy JTF_DATE_TABLE
235 , p7_a39 out nocopy JTF_NUMBER_TABLE
236 , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
237 , p7_a41 out nocopy JTF_DATE_TABLE
238 , p7_a42 out nocopy JTF_NUMBER_TABLE
239 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
240 , p7_a44 out nocopy JTF_DATE_TABLE
241 , p7_a45 out nocopy JTF_NUMBER_TABLE
242 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
243 , p7_a47 out nocopy JTF_DATE_TABLE
244 , p7_a48 out nocopy JTF_NUMBER_TABLE
245 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
246 , p7_a50 out nocopy JTF_DATE_TABLE
247 , p7_a51 out nocopy JTF_NUMBER_TABLE
248 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
249 , p7_a53 out nocopy JTF_DATE_TABLE
250 , p7_a54 out nocopy JTF_NUMBER_TABLE
251 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
252 , p7_a56 out nocopy JTF_DATE_TABLE
253 , p7_a57 out nocopy JTF_NUMBER_TABLE
254 , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
255 , p7_a59 out nocopy JTF_DATE_TABLE
256 , p7_a60 out nocopy JTF_NUMBER_TABLE
257 , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
258 , p7_a62 out nocopy JTF_DATE_TABLE
259 , p7_a63 out nocopy JTF_NUMBER_TABLE
260 , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
261 , p7_a65 out nocopy JTF_DATE_TABLE
262 , p7_a66 out nocopy JTF_NUMBER_TABLE
263 , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
264 , p7_a68 out nocopy JTF_DATE_TABLE
265 , p7_a69 out nocopy JTF_NUMBER_TABLE
266 , p7_a70 out nocopy JTF_NUMBER_TABLE
267 );
268 procedure get_visits_for_date_org(p_api_version NUMBER
269 , p_init_msg_list VARCHAR2
270 , p_validation_level NUMBER
271 , x_return_status out nocopy VARCHAR2
272 , x_msg_count out nocopy NUMBER
273 , x_msg_data out nocopy VARCHAR2
274 , p6_a0 NUMBER
275 , p6_a1 NUMBER
276 , p6_a2 NUMBER
277 , p6_a3 VARCHAR2
278 , p6_a4 VARCHAR2
279 , p6_a5 DATE
280 , p6_a6 DATE
281 , p6_a7 NUMBER
282 , p6_a8 VARCHAR2
283 , p7_a0 out nocopy NUMBER
284 , p7_a1 out nocopy NUMBER
285 , p7_a2 out nocopy VARCHAR2
286 , p7_a3 out nocopy NUMBER
287 , p7_a4 out nocopy VARCHAR2
288 , p7_a5 out nocopy NUMBER
289 , p7_a6 out nocopy VARCHAR2
290 , p7_a7 out nocopy VARCHAR2
291 , p7_a8 out nocopy DATE
292 , p7_a9 out nocopy NUMBER
293 , p7_a10 out nocopy VARCHAR2
294 , p7_a11 out nocopy DATE
295 , p7_a12 out nocopy NUMBER
296 , p7_a13 out nocopy VARCHAR2
297 , p7_a14 out nocopy DATE
298 , p7_a15 out nocopy NUMBER
299 , p7_a16 out nocopy VARCHAR2
300 , p7_a17 out nocopy DATE
301 , p7_a18 out nocopy NUMBER
302 , p7_a19 out nocopy VARCHAR2
303 , p7_a20 out nocopy DATE
304 , p7_a21 out nocopy NUMBER
305 , p7_a22 out nocopy VARCHAR2
306 , p7_a23 out nocopy DATE
307 , p7_a24 out nocopy NUMBER
308 , p7_a25 out nocopy VARCHAR2
309 , p7_a26 out nocopy DATE
310 , p7_a27 out nocopy NUMBER
311 , p7_a28 out nocopy VARCHAR2
312 , p7_a29 out nocopy DATE
313 , p7_a30 out nocopy NUMBER
314 , p7_a31 out nocopy VARCHAR2
315 , p7_a32 out nocopy DATE
316 , p7_a33 out nocopy NUMBER
317 , p7_a34 out nocopy VARCHAR2
318 , p7_a35 out nocopy DATE
319 , p7_a36 out nocopy NUMBER
320 , p7_a37 out nocopy VARCHAR2
321 , p7_a38 out nocopy DATE
322 , p7_a39 out nocopy NUMBER
323 , p7_a40 out nocopy VARCHAR2
324 , p7_a41 out nocopy DATE
325 , p7_a42 out nocopy NUMBER
326 , p7_a43 out nocopy VARCHAR2
327 , p7_a44 out nocopy DATE
331 , p7_a48 out nocopy NUMBER
328 , p7_a45 out nocopy NUMBER
329 , p7_a46 out nocopy VARCHAR2
330 , p7_a47 out nocopy DATE
332 , p7_a49 out nocopy VARCHAR2
333 , p7_a50 out nocopy DATE
334 , p7_a51 out nocopy NUMBER
335 , p7_a52 out nocopy VARCHAR2
336 , p7_a53 out nocopy DATE
337 , p7_a54 out nocopy NUMBER
338 , p7_a55 out nocopy VARCHAR2
339 , p7_a56 out nocopy DATE
340 , p7_a57 out nocopy NUMBER
341 , p7_a58 out nocopy VARCHAR2
342 , p7_a59 out nocopy DATE
343 , p7_a60 out nocopy NUMBER
344 , p7_a61 out nocopy VARCHAR2
345 , p7_a62 out nocopy DATE
346 , p7_a63 out nocopy NUMBER
347 , p7_a64 out nocopy VARCHAR2
348 , p7_a65 out nocopy DATE
349 , p7_a66 out nocopy NUMBER
350 , p7_a67 out nocopy VARCHAR2
351 , p7_a68 out nocopy DATE
352 , p7_a69 out nocopy NUMBER
353 , p7_a70 out nocopy NUMBER
354 , p8_a0 out nocopy JTF_NUMBER_TABLE
355 , p8_a1 out nocopy JTF_DATE_TABLE
356 , p8_a2 out nocopy JTF_DATE_TABLE
357 );
358 procedure get_flt_sch_graph(p_api_version NUMBER
359 , p_init_msg_list VARCHAR2
360 , p_validation_level NUMBER
361 , x_return_status out nocopy VARCHAR2
362 , x_msg_count out nocopy NUMBER
363 , x_msg_data out nocopy VARCHAR2
364 , p6_a0 NUMBER
365 , p6_a1 NUMBER
366 , p6_a2 VARCHAR2
367 , p6_a3 VARCHAR2
368 , p6_a4 NUMBER
369 , p6_a5 VARCHAR2
370 , p6_a6 DATE
371 , p6_a7 DATE
372 , p6_a8 NUMBER
373 , p7_a0 out nocopy JTF_NUMBER_TABLE
374 , p7_a1 out nocopy JTF_NUMBER_TABLE
375 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
376 , p7_a3 out nocopy JTF_NUMBER_TABLE
377 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
378 , p7_a5 out nocopy JTF_NUMBER_TABLE
379 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_300
380 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
381 , p7_a8 out nocopy JTF_DATE_TABLE
382 , p7_a9 out nocopy JTF_NUMBER_TABLE
383 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
384 , p7_a11 out nocopy JTF_DATE_TABLE
385 , p7_a12 out nocopy JTF_NUMBER_TABLE
386 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
387 , p7_a14 out nocopy JTF_DATE_TABLE
388 , p7_a15 out nocopy JTF_NUMBER_TABLE
389 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
390 , p7_a17 out nocopy JTF_DATE_TABLE
391 , p7_a18 out nocopy JTF_NUMBER_TABLE
392 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
393 , p7_a20 out nocopy JTF_DATE_TABLE
394 , p7_a21 out nocopy JTF_NUMBER_TABLE
395 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
396 , p7_a23 out nocopy JTF_DATE_TABLE
397 , p7_a24 out nocopy JTF_NUMBER_TABLE
398 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
399 , p7_a26 out nocopy JTF_DATE_TABLE
400 , p7_a27 out nocopy JTF_NUMBER_TABLE
401 , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
402 , p7_a29 out nocopy JTF_DATE_TABLE
403 , p7_a30 out nocopy JTF_NUMBER_TABLE
404 , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
405 , p7_a32 out nocopy JTF_DATE_TABLE
406 , p7_a33 out nocopy JTF_NUMBER_TABLE
407 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
408 , p7_a35 out nocopy JTF_DATE_TABLE
409 , p7_a36 out nocopy JTF_NUMBER_TABLE
410 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
411 , p7_a38 out nocopy JTF_DATE_TABLE
412 , p7_a39 out nocopy JTF_NUMBER_TABLE
413 , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
414 , p7_a41 out nocopy JTF_DATE_TABLE
415 , p7_a42 out nocopy JTF_NUMBER_TABLE
416 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
417 , p7_a44 out nocopy JTF_DATE_TABLE
418 , p7_a45 out nocopy JTF_NUMBER_TABLE
419 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_100
420 , p7_a47 out nocopy JTF_DATE_TABLE
421 , p7_a48 out nocopy JTF_NUMBER_TABLE
422 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
423 , p7_a50 out nocopy JTF_DATE_TABLE
424 , p7_a51 out nocopy JTF_NUMBER_TABLE
425 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
426 , p7_a53 out nocopy JTF_DATE_TABLE
427 , p7_a54 out nocopy JTF_NUMBER_TABLE
428 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
429 , p7_a56 out nocopy JTF_DATE_TABLE
430 , p7_a57 out nocopy JTF_NUMBER_TABLE
431 , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
432 , p7_a59 out nocopy JTF_DATE_TABLE
433 , p7_a60 out nocopy JTF_NUMBER_TABLE
434 , p7_a61 out nocopy JTF_VARCHAR2_TABLE_100
435 , p7_a62 out nocopy JTF_DATE_TABLE
436 , p7_a63 out nocopy JTF_NUMBER_TABLE
437 , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
438 , p7_a65 out nocopy JTF_DATE_TABLE
439 , p7_a66 out nocopy JTF_NUMBER_TABLE
440 , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
441 , p7_a68 out nocopy JTF_DATE_TABLE
442 , p7_a69 out nocopy JTF_NUMBER_TABLE
443 , p7_a70 out nocopy JTF_NUMBER_TABLE
444 );
445 procedure get_visits_for_date_flt(p_api_version NUMBER
446 , p_init_msg_list VARCHAR2
447 , p_validation_level NUMBER
448 , x_return_status out nocopy VARCHAR2
449 , x_msg_count out nocopy NUMBER
450 , x_msg_data out nocopy VARCHAR2
451 , p6_a0 NUMBER
452 , p6_a1 NUMBER
453 , p6_a2 VARCHAR2
454 , p6_a3 VARCHAR2
455 , p6_a4 NUMBER
456 , p6_a5 VARCHAR2
457 , p6_a6 DATE
458 , p6_a7 DATE
459 , p6_a8 NUMBER
460 , p7_a0 out nocopy NUMBER
461 , p7_a1 out nocopy NUMBER
462 , p7_a2 out nocopy VARCHAR2
463 , p7_a3 out nocopy NUMBER
464 , p7_a4 out nocopy VARCHAR2
465 , p7_a5 out nocopy NUMBER
466 , p7_a6 out nocopy VARCHAR2
467 , p7_a7 out nocopy VARCHAR2
468 , p7_a8 out nocopy DATE
469 , p7_a9 out nocopy NUMBER
473 , p7_a13 out nocopy VARCHAR2
470 , p7_a10 out nocopy VARCHAR2
471 , p7_a11 out nocopy DATE
472 , p7_a12 out nocopy NUMBER
474 , p7_a14 out nocopy DATE
475 , p7_a15 out nocopy NUMBER
476 , p7_a16 out nocopy VARCHAR2
477 , p7_a17 out nocopy DATE
478 , p7_a18 out nocopy NUMBER
479 , p7_a19 out nocopy VARCHAR2
480 , p7_a20 out nocopy DATE
481 , p7_a21 out nocopy NUMBER
482 , p7_a22 out nocopy VARCHAR2
483 , p7_a23 out nocopy DATE
484 , p7_a24 out nocopy NUMBER
485 , p7_a25 out nocopy VARCHAR2
486 , p7_a26 out nocopy DATE
487 , p7_a27 out nocopy NUMBER
488 , p7_a28 out nocopy VARCHAR2
489 , p7_a29 out nocopy DATE
490 , p7_a30 out nocopy NUMBER
491 , p7_a31 out nocopy VARCHAR2
492 , p7_a32 out nocopy DATE
493 , p7_a33 out nocopy NUMBER
494 , p7_a34 out nocopy VARCHAR2
495 , p7_a35 out nocopy DATE
496 , p7_a36 out nocopy NUMBER
497 , p7_a37 out nocopy VARCHAR2
498 , p7_a38 out nocopy DATE
499 , p7_a39 out nocopy NUMBER
500 , p7_a40 out nocopy VARCHAR2
501 , p7_a41 out nocopy DATE
502 , p7_a42 out nocopy NUMBER
503 , p7_a43 out nocopy VARCHAR2
504 , p7_a44 out nocopy DATE
505 , p7_a45 out nocopy NUMBER
506 , p7_a46 out nocopy VARCHAR2
507 , p7_a47 out nocopy DATE
508 , p7_a48 out nocopy NUMBER
509 , p7_a49 out nocopy VARCHAR2
510 , p7_a50 out nocopy DATE
511 , p7_a51 out nocopy NUMBER
512 , p7_a52 out nocopy VARCHAR2
513 , p7_a53 out nocopy DATE
514 , p7_a54 out nocopy NUMBER
515 , p7_a55 out nocopy VARCHAR2
516 , p7_a56 out nocopy DATE
517 , p7_a57 out nocopy NUMBER
518 , p7_a58 out nocopy VARCHAR2
519 , p7_a59 out nocopy DATE
520 , p7_a60 out nocopy NUMBER
521 , p7_a61 out nocopy VARCHAR2
522 , p7_a62 out nocopy DATE
523 , p7_a63 out nocopy NUMBER
524 , p7_a64 out nocopy VARCHAR2
525 , p7_a65 out nocopy DATE
526 , p7_a66 out nocopy NUMBER
527 , p7_a67 out nocopy VARCHAR2
528 , p7_a68 out nocopy DATE
529 , p7_a69 out nocopy NUMBER
530 , p7_a70 out nocopy NUMBER
531 , p8_a0 out nocopy JTF_NUMBER_TABLE
532 , p8_a1 out nocopy JTF_DATE_TABLE
533 , p8_a2 out nocopy JTF_DATE_TABLE
534 );
535 procedure get_mc_graph_data(p_api_version NUMBER
536 , p_init_msg_list VARCHAR2
537 , p_commit VARCHAR2
538 , p_validation_level NUMBER
539 , p_default VARCHAR2
540 , p_module_type VARCHAR2
541 , x_return_status out nocopy VARCHAR2
542 , x_msg_count out nocopy NUMBER
543 , x_msg_data out nocopy VARCHAR2
544 , p_organization_id NUMBER
545 , p_department_id NUMBER
546 , p_start_date DATE
547 , p_no_of_days NUMBER
548 , p_max_range NUMBER
549 , p14_a0 in out nocopy JTF_NUMBER_TABLE
550 , p14_a1 in out nocopy JTF_NUMBER_TABLE
551 , p15_a0 in out nocopy JTF_DATE_TABLE
552 , p15_a1 in out nocopy JTF_NUMBER_TABLE
553 , p15_a2 in out nocopy JTF_NUMBER_TABLE
554 , p15_a3 in out nocopy JTF_NUMBER_TABLE
555 , p15_a4 in out nocopy JTF_NUMBER_TABLE
556 , p15_a5 in out nocopy JTF_NUMBER_TABLE
557 , p15_a6 in out nocopy JTF_NUMBER_TABLE
558 , x_plan_date out nocopy DATE
559 );
560 end ahl_amp_workbench_pvt_w;