[Home] [Help]
PACKAGE: APPS.AHL_VWP_PROJ_PROD_PVT_W
Source
1 package ahl_vwp_proj_prod_pvt_w AUTHID CURRENT_USER as
2 /* $Header: AHLWPRDS.pls 120.8.12020000.2 2012/12/14 05:51:59 shnatu ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_proj_prod_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_2000
5 );
6 procedure rosetta_table_copy_out_p1(t ahl_vwp_proj_prod_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7 , a1 out nocopy JTF_VARCHAR2_TABLE_2000
8 );
9
10 procedure rosetta_table_copy_in_p2(t out nocopy ahl_vwp_proj_prod_pvt.task_tbl_type, a0 JTF_NUMBER_TABLE
11 , a1 JTF_NUMBER_TABLE
15 , a5 JTF_NUMBER_TABLE
12 , a2 JTF_NUMBER_TABLE
13 , a3 JTF_VARCHAR2_TABLE_100
14 , a4 JTF_NUMBER_TABLE
16 , a6 JTF_VARCHAR2_TABLE_100
17 , a7 JTF_NUMBER_TABLE
18 , a8 JTF_NUMBER_TABLE
19 , a9 JTF_NUMBER_TABLE
20 , a10 JTF_VARCHAR2_TABLE_100
21 , a11 JTF_NUMBER_TABLE
22 , a12 JTF_VARCHAR2_TABLE_100
23 , a13 JTF_NUMBER_TABLE
24 , a14 JTF_NUMBER_TABLE
25 , a15 JTF_VARCHAR2_TABLE_300
26 , a16 JTF_NUMBER_TABLE
27 , a17 JTF_VARCHAR2_TABLE_100
28 , a18 JTF_NUMBER_TABLE
29 , a19 JTF_NUMBER_TABLE
30 , a20 JTF_NUMBER_TABLE
31 , a21 JTF_VARCHAR2_TABLE_100
32 , a22 JTF_NUMBER_TABLE
33 , a23 JTF_VARCHAR2_TABLE_100
34 , a24 JTF_NUMBER_TABLE
35 , a25 JTF_NUMBER_TABLE
36 , a26 JTF_NUMBER_TABLE
37 , a27 JTF_VARCHAR2_TABLE_100
38 , a28 JTF_VARCHAR2_TABLE_100
39 , a29 JTF_VARCHAR2_TABLE_100
40 , a30 JTF_VARCHAR2_TABLE_4000
41 , a31 JTF_VARCHAR2_TABLE_100
42 , a32 JTF_VARCHAR2_TABLE_100
43 , a33 JTF_NUMBER_TABLE
44 , a34 JTF_DATE_TABLE
45 , a35 JTF_NUMBER_TABLE
46 , a36 JTF_DATE_TABLE
47 , a37 JTF_NUMBER_TABLE
48 , a38 JTF_NUMBER_TABLE
49 , a39 JTF_VARCHAR2_TABLE_100
50 , a40 JTF_VARCHAR2_TABLE_200
51 , a41 JTF_VARCHAR2_TABLE_200
52 , a42 JTF_VARCHAR2_TABLE_200
53 , a43 JTF_VARCHAR2_TABLE_200
54 , a44 JTF_VARCHAR2_TABLE_200
55 , a45 JTF_VARCHAR2_TABLE_200
56 , a46 JTF_VARCHAR2_TABLE_200
57 , a47 JTF_VARCHAR2_TABLE_200
58 , a48 JTF_VARCHAR2_TABLE_200
59 , a49 JTF_VARCHAR2_TABLE_200
60 , a50 JTF_VARCHAR2_TABLE_200
61 , a51 JTF_VARCHAR2_TABLE_200
62 , a52 JTF_VARCHAR2_TABLE_200
63 , a53 JTF_VARCHAR2_TABLE_200
64 , a54 JTF_VARCHAR2_TABLE_200
65 , a55 JTF_DATE_TABLE
66 , a56 JTF_DATE_TABLE
67 , a57 JTF_DATE_TABLE
68 , a58 JTF_VARCHAR2_TABLE_100
69 , a59 JTF_VARCHAR2_TABLE_100
70 , a60 JTF_NUMBER_TABLE
71 , a61 JTF_NUMBER_TABLE
72 , a62 JTF_VARCHAR2_TABLE_100
73 , a63 JTF_NUMBER_TABLE
74 , a64 JTF_VARCHAR2_TABLE_300
75 , a65 JTF_VARCHAR2_TABLE_100
76 , a66 JTF_DATE_TABLE
77 , a67 JTF_DATE_TABLE
78 , a68 JTF_VARCHAR2_TABLE_100
79 , a69 JTF_VARCHAR2_TABLE_100
80 , a70 JTF_VARCHAR2_TABLE_100
81 , a71 JTF_NUMBER_TABLE
82 , a72 JTF_VARCHAR2_TABLE_100
83 , a73 JTF_NUMBER_TABLE
84 , a74 JTF_VARCHAR2_TABLE_100
85 , a75 JTF_VARCHAR2_TABLE_100
86 , a76 JTF_VARCHAR2_TABLE_100
87 , a77 JTF_VARCHAR2_TABLE_100
88 , a78 JTF_DATE_TABLE
89 , a79 JTF_DATE_TABLE
90 , a80 JTF_NUMBER_TABLE
91 , a81 JTF_NUMBER_TABLE
92 , a82 JTF_NUMBER_TABLE
93 , a83 JTF_VARCHAR2_TABLE_100
94 , a84 JTF_VARCHAR2_TABLE_100
95 , a85 JTF_VARCHAR2_TABLE_100
96 , a86 JTF_VARCHAR2_TABLE_100
97 , a87 JTF_VARCHAR2_TABLE_100
98 , a88 JTF_VARCHAR2_TABLE_100
99 , a89 JTF_VARCHAR2_TABLE_100
100 , a90 JTF_VARCHAR2_TABLE_100
101 , a91 JTF_VARCHAR2_TABLE_100
102 , a92 JTF_VARCHAR2_TABLE_100
103 , a93 JTF_NUMBER_TABLE
104 , a94 JTF_VARCHAR2_TABLE_300
105 );
106 procedure rosetta_table_copy_out_p2(t ahl_vwp_proj_prod_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107 , a1 out nocopy JTF_NUMBER_TABLE
108 , a2 out nocopy JTF_NUMBER_TABLE
109 , a3 out nocopy JTF_VARCHAR2_TABLE_100
110 , a4 out nocopy JTF_NUMBER_TABLE
111 , a5 out nocopy JTF_NUMBER_TABLE
112 , a6 out nocopy JTF_VARCHAR2_TABLE_100
113 , a7 out nocopy JTF_NUMBER_TABLE
114 , a8 out nocopy JTF_NUMBER_TABLE
115 , a9 out nocopy JTF_NUMBER_TABLE
116 , a10 out nocopy JTF_VARCHAR2_TABLE_100
117 , a11 out nocopy JTF_NUMBER_TABLE
118 , a12 out nocopy JTF_VARCHAR2_TABLE_100
119 , a13 out nocopy JTF_NUMBER_TABLE
120 , a14 out nocopy JTF_NUMBER_TABLE
121 , a15 out nocopy JTF_VARCHAR2_TABLE_300
122 , a16 out nocopy JTF_NUMBER_TABLE
123 , a17 out nocopy JTF_VARCHAR2_TABLE_100
124 , a18 out nocopy JTF_NUMBER_TABLE
125 , a19 out nocopy JTF_NUMBER_TABLE
126 , a20 out nocopy JTF_NUMBER_TABLE
127 , a21 out nocopy JTF_VARCHAR2_TABLE_100
128 , a22 out nocopy JTF_NUMBER_TABLE
129 , a23 out nocopy JTF_VARCHAR2_TABLE_100
130 , a24 out nocopy JTF_NUMBER_TABLE
131 , a25 out nocopy JTF_NUMBER_TABLE
132 , a26 out nocopy JTF_NUMBER_TABLE
133 , a27 out nocopy JTF_VARCHAR2_TABLE_100
134 , a28 out nocopy JTF_VARCHAR2_TABLE_100
135 , a29 out nocopy JTF_VARCHAR2_TABLE_100
136 , a30 out nocopy JTF_VARCHAR2_TABLE_4000
137 , a31 out nocopy JTF_VARCHAR2_TABLE_100
138 , a32 out nocopy JTF_VARCHAR2_TABLE_100
139 , a33 out nocopy JTF_NUMBER_TABLE
140 , a34 out nocopy JTF_DATE_TABLE
141 , a35 out nocopy JTF_NUMBER_TABLE
142 , a36 out nocopy JTF_DATE_TABLE
143 , a37 out nocopy JTF_NUMBER_TABLE
144 , a38 out nocopy JTF_NUMBER_TABLE
145 , a39 out nocopy JTF_VARCHAR2_TABLE_100
146 , a40 out nocopy JTF_VARCHAR2_TABLE_200
147 , a41 out nocopy JTF_VARCHAR2_TABLE_200
148 , a42 out nocopy JTF_VARCHAR2_TABLE_200
149 , a43 out nocopy JTF_VARCHAR2_TABLE_200
150 , a44 out nocopy JTF_VARCHAR2_TABLE_200
151 , a45 out nocopy JTF_VARCHAR2_TABLE_200
152 , a46 out nocopy JTF_VARCHAR2_TABLE_200
153 , a47 out nocopy JTF_VARCHAR2_TABLE_200
154 , a48 out nocopy JTF_VARCHAR2_TABLE_200
155 , a49 out nocopy JTF_VARCHAR2_TABLE_200
156 , a50 out nocopy JTF_VARCHAR2_TABLE_200
157 , a51 out nocopy JTF_VARCHAR2_TABLE_200
158 , a52 out nocopy JTF_VARCHAR2_TABLE_200
159 , a53 out nocopy JTF_VARCHAR2_TABLE_200
160 , a54 out nocopy JTF_VARCHAR2_TABLE_200
161 , a55 out nocopy JTF_DATE_TABLE
162 , a56 out nocopy JTF_DATE_TABLE
163 , a57 out nocopy JTF_DATE_TABLE
164 , a58 out nocopy JTF_VARCHAR2_TABLE_100
165 , a59 out nocopy JTF_VARCHAR2_TABLE_100
166 , a60 out nocopy JTF_NUMBER_TABLE
167 , a61 out nocopy JTF_NUMBER_TABLE
168 , a62 out nocopy JTF_VARCHAR2_TABLE_100
169 , a63 out nocopy JTF_NUMBER_TABLE
170 , a64 out nocopy JTF_VARCHAR2_TABLE_300
171 , a65 out nocopy JTF_VARCHAR2_TABLE_100
172 , a66 out nocopy JTF_DATE_TABLE
173 , a67 out nocopy JTF_DATE_TABLE
174 , a68 out nocopy JTF_VARCHAR2_TABLE_100
175 , a69 out nocopy JTF_VARCHAR2_TABLE_100
176 , a70 out nocopy JTF_VARCHAR2_TABLE_100
177 , a71 out nocopy JTF_NUMBER_TABLE
178 , a72 out nocopy JTF_VARCHAR2_TABLE_100
179 , a73 out nocopy JTF_NUMBER_TABLE
180 , a74 out nocopy JTF_VARCHAR2_TABLE_100
181 , a75 out nocopy JTF_VARCHAR2_TABLE_100
182 , a76 out nocopy JTF_VARCHAR2_TABLE_100
183 , a77 out nocopy JTF_VARCHAR2_TABLE_100
184 , a78 out nocopy JTF_DATE_TABLE
185 , a79 out nocopy JTF_DATE_TABLE
186 , a80 out nocopy JTF_NUMBER_TABLE
187 , a81 out nocopy JTF_NUMBER_TABLE
188 , a82 out nocopy JTF_NUMBER_TABLE
189 , a83 out nocopy JTF_VARCHAR2_TABLE_100
190 , a84 out nocopy JTF_VARCHAR2_TABLE_100
191 , a85 out nocopy JTF_VARCHAR2_TABLE_100
192 , a86 out nocopy JTF_VARCHAR2_TABLE_100
193 , a87 out nocopy JTF_VARCHAR2_TABLE_100
194 , a88 out nocopy JTF_VARCHAR2_TABLE_100
195 , a89 out nocopy JTF_VARCHAR2_TABLE_100
196 , a90 out nocopy JTF_VARCHAR2_TABLE_100
197 , a91 out nocopy JTF_VARCHAR2_TABLE_100
198 , a92 out nocopy JTF_VARCHAR2_TABLE_100
199 , a93 out nocopy JTF_NUMBER_TABLE
200 , a94 out nocopy JTF_VARCHAR2_TABLE_300
201 );
202
203 procedure validate_before_production(p_api_version NUMBER
204 , p_init_msg_list VARCHAR2
205 , p_commit VARCHAR2
206 , p_validation_level NUMBER
207 , p_module_type VARCHAR2
208 , p_visit_id NUMBER
209 , p6_a0 out nocopy JTF_NUMBER_TABLE
210 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_2000
211 , x_return_status out nocopy VARCHAR2
212 , x_msg_count out nocopy NUMBER
213 , x_msg_data out nocopy VARCHAR2
214 );
215 procedure create_job_tasks(p_api_version NUMBER
216 , p_init_msg_list VARCHAR2
217 , p_commit VARCHAR2
218 , p_validation_level NUMBER
219 , p_module_type VARCHAR2
220 , p5_a0 in out nocopy JTF_NUMBER_TABLE
221 , p5_a1 in out nocopy JTF_NUMBER_TABLE
222 , p5_a2 in out nocopy JTF_NUMBER_TABLE
223 , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
224 , p5_a4 in out nocopy JTF_NUMBER_TABLE
225 , p5_a5 in out nocopy JTF_NUMBER_TABLE
226 , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
227 , p5_a7 in out nocopy JTF_NUMBER_TABLE
228 , p5_a8 in out nocopy JTF_NUMBER_TABLE
229 , p5_a9 in out nocopy JTF_NUMBER_TABLE
230 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
231 , p5_a11 in out nocopy JTF_NUMBER_TABLE
232 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
233 , p5_a13 in out nocopy JTF_NUMBER_TABLE
234 , p5_a14 in out nocopy JTF_NUMBER_TABLE
235 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
236 , p5_a16 in out nocopy JTF_NUMBER_TABLE
237 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
238 , p5_a18 in out nocopy JTF_NUMBER_TABLE
239 , p5_a19 in out nocopy JTF_NUMBER_TABLE
240 , p5_a20 in out nocopy JTF_NUMBER_TABLE
241 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
242 , p5_a22 in out nocopy JTF_NUMBER_TABLE
243 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_100
244 , p5_a24 in out nocopy JTF_NUMBER_TABLE
245 , p5_a25 in out nocopy JTF_NUMBER_TABLE
246 , p5_a26 in out nocopy JTF_NUMBER_TABLE
247 , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
248 , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
249 , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
250 , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
251 , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
252 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
253 , p5_a33 in out nocopy JTF_NUMBER_TABLE
254 , p5_a34 in out nocopy JTF_DATE_TABLE
255 , p5_a35 in out nocopy JTF_NUMBER_TABLE
256 , p5_a36 in out nocopy JTF_DATE_TABLE
257 , p5_a37 in out nocopy JTF_NUMBER_TABLE
258 , p5_a38 in out nocopy JTF_NUMBER_TABLE
259 , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
260 , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
261 , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200
262 , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_200
263 , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_200
264 , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
265 , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
266 , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
267 , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200
268 , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
269 , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
270 , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200
271 , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
272 , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
273 , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
274 , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
275 , p5_a55 in out nocopy JTF_DATE_TABLE
276 , p5_a56 in out nocopy JTF_DATE_TABLE
277 , p5_a57 in out nocopy JTF_DATE_TABLE
278 , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
279 , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
280 , p5_a60 in out nocopy JTF_NUMBER_TABLE
281 , p5_a61 in out nocopy JTF_NUMBER_TABLE
282 , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
283 , p5_a63 in out nocopy JTF_NUMBER_TABLE
284 , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
285 , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
286 , p5_a66 in out nocopy JTF_DATE_TABLE
287 , p5_a67 in out nocopy JTF_DATE_TABLE
288 , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
289 , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
290 , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
291 , p5_a71 in out nocopy JTF_NUMBER_TABLE
292 , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
293 , p5_a73 in out nocopy JTF_NUMBER_TABLE
294 , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
295 , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
296 , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_100
297 , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
298 , p5_a78 in out nocopy JTF_DATE_TABLE
299 , p5_a79 in out nocopy JTF_DATE_TABLE
300 , p5_a80 in out nocopy JTF_NUMBER_TABLE
301 , p5_a81 in out nocopy JTF_NUMBER_TABLE
302 , p5_a82 in out nocopy JTF_NUMBER_TABLE
303 , p5_a83 in out nocopy JTF_VARCHAR2_TABLE_100
304 , p5_a84 in out nocopy JTF_VARCHAR2_TABLE_100
305 , p5_a85 in out nocopy JTF_VARCHAR2_TABLE_100
306 , p5_a86 in out nocopy JTF_VARCHAR2_TABLE_100
307 , p5_a87 in out nocopy JTF_VARCHAR2_TABLE_100
308 , p5_a88 in out nocopy JTF_VARCHAR2_TABLE_100
309 , p5_a89 in out nocopy JTF_VARCHAR2_TABLE_100
310 , p5_a90 in out nocopy JTF_VARCHAR2_TABLE_100
311 , p5_a91 in out nocopy JTF_VARCHAR2_TABLE_100
312 , p5_a92 in out nocopy JTF_VARCHAR2_TABLE_100
313 , p5_a93 in out nocopy JTF_NUMBER_TABLE
314 , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
315 , x_return_status out nocopy VARCHAR2
316 , x_msg_count out nocopy NUMBER
317 , x_msg_data out nocopy VARCHAR2
318 );
319 procedure release_tasks(p_api_version NUMBER
320 , p_init_msg_list VARCHAR2
321 , p_commit VARCHAR2
322 , p_validation_level NUMBER
323 , p_module_type VARCHAR2
324 , p_visit_id NUMBER
325 , p6_a0 JTF_NUMBER_TABLE
326 , p6_a1 JTF_NUMBER_TABLE
327 , p6_a2 JTF_NUMBER_TABLE
328 , p6_a3 JTF_VARCHAR2_TABLE_100
329 , p6_a4 JTF_NUMBER_TABLE
330 , p6_a5 JTF_NUMBER_TABLE
331 , p6_a6 JTF_VARCHAR2_TABLE_100
332 , p6_a7 JTF_NUMBER_TABLE
333 , p6_a8 JTF_NUMBER_TABLE
334 , p6_a9 JTF_NUMBER_TABLE
335 , p6_a10 JTF_VARCHAR2_TABLE_100
336 , p6_a11 JTF_NUMBER_TABLE
337 , p6_a12 JTF_VARCHAR2_TABLE_100
338 , p6_a13 JTF_NUMBER_TABLE
339 , p6_a14 JTF_NUMBER_TABLE
340 , p6_a15 JTF_VARCHAR2_TABLE_300
341 , p6_a16 JTF_NUMBER_TABLE
342 , p6_a17 JTF_VARCHAR2_TABLE_100
343 , p6_a18 JTF_NUMBER_TABLE
344 , p6_a19 JTF_NUMBER_TABLE
345 , p6_a20 JTF_NUMBER_TABLE
346 , p6_a21 JTF_VARCHAR2_TABLE_100
347 , p6_a22 JTF_NUMBER_TABLE
348 , p6_a23 JTF_VARCHAR2_TABLE_100
349 , p6_a24 JTF_NUMBER_TABLE
350 , p6_a25 JTF_NUMBER_TABLE
351 , p6_a26 JTF_NUMBER_TABLE
352 , p6_a27 JTF_VARCHAR2_TABLE_100
353 , p6_a28 JTF_VARCHAR2_TABLE_100
354 , p6_a29 JTF_VARCHAR2_TABLE_100
355 , p6_a30 JTF_VARCHAR2_TABLE_4000
356 , p6_a31 JTF_VARCHAR2_TABLE_100
357 , p6_a32 JTF_VARCHAR2_TABLE_100
358 , p6_a33 JTF_NUMBER_TABLE
359 , p6_a34 JTF_DATE_TABLE
360 , p6_a35 JTF_NUMBER_TABLE
361 , p6_a36 JTF_DATE_TABLE
362 , p6_a37 JTF_NUMBER_TABLE
363 , p6_a38 JTF_NUMBER_TABLE
364 , p6_a39 JTF_VARCHAR2_TABLE_100
365 , p6_a40 JTF_VARCHAR2_TABLE_200
366 , p6_a41 JTF_VARCHAR2_TABLE_200
367 , p6_a42 JTF_VARCHAR2_TABLE_200
368 , p6_a43 JTF_VARCHAR2_TABLE_200
369 , p6_a44 JTF_VARCHAR2_TABLE_200
370 , p6_a45 JTF_VARCHAR2_TABLE_200
371 , p6_a46 JTF_VARCHAR2_TABLE_200
372 , p6_a47 JTF_VARCHAR2_TABLE_200
373 , p6_a48 JTF_VARCHAR2_TABLE_200
374 , p6_a49 JTF_VARCHAR2_TABLE_200
375 , p6_a50 JTF_VARCHAR2_TABLE_200
376 , p6_a51 JTF_VARCHAR2_TABLE_200
377 , p6_a52 JTF_VARCHAR2_TABLE_200
378 , p6_a53 JTF_VARCHAR2_TABLE_200
379 , p6_a54 JTF_VARCHAR2_TABLE_200
380 , p6_a55 JTF_DATE_TABLE
381 , p6_a56 JTF_DATE_TABLE
382 , p6_a57 JTF_DATE_TABLE
383 , p6_a58 JTF_VARCHAR2_TABLE_100
384 , p6_a59 JTF_VARCHAR2_TABLE_100
385 , p6_a60 JTF_NUMBER_TABLE
386 , p6_a61 JTF_NUMBER_TABLE
387 , p6_a62 JTF_VARCHAR2_TABLE_100
388 , p6_a63 JTF_NUMBER_TABLE
389 , p6_a64 JTF_VARCHAR2_TABLE_300
390 , p6_a65 JTF_VARCHAR2_TABLE_100
391 , p6_a66 JTF_DATE_TABLE
392 , p6_a67 JTF_DATE_TABLE
393 , p6_a68 JTF_VARCHAR2_TABLE_100
394 , p6_a69 JTF_VARCHAR2_TABLE_100
395 , p6_a70 JTF_VARCHAR2_TABLE_100
396 , p6_a71 JTF_NUMBER_TABLE
397 , p6_a72 JTF_VARCHAR2_TABLE_100
398 , p6_a73 JTF_NUMBER_TABLE
399 , p6_a74 JTF_VARCHAR2_TABLE_100
400 , p6_a75 JTF_VARCHAR2_TABLE_100
401 , p6_a76 JTF_VARCHAR2_TABLE_100
402 , p6_a77 JTF_VARCHAR2_TABLE_100
403 , p6_a78 JTF_DATE_TABLE
404 , p6_a79 JTF_DATE_TABLE
405 , p6_a80 JTF_NUMBER_TABLE
406 , p6_a81 JTF_NUMBER_TABLE
407 , p6_a82 JTF_NUMBER_TABLE
408 , p6_a83 JTF_VARCHAR2_TABLE_100
409 , p6_a84 JTF_VARCHAR2_TABLE_100
410 , p6_a85 JTF_VARCHAR2_TABLE_100
411 , p6_a86 JTF_VARCHAR2_TABLE_100
412 , p6_a87 JTF_VARCHAR2_TABLE_100
413 , p6_a88 JTF_VARCHAR2_TABLE_100
414 , p6_a89 JTF_VARCHAR2_TABLE_100
415 , p6_a90 JTF_VARCHAR2_TABLE_100
416 , p6_a91 JTF_VARCHAR2_TABLE_100
417 , p6_a92 JTF_VARCHAR2_TABLE_100
418 , p6_a93 JTF_NUMBER_TABLE
419 , p6_a94 JTF_VARCHAR2_TABLE_300
420 , p_release_flag VARCHAR2
421 , x_return_status out nocopy VARCHAR2
422 , x_msg_count out nocopy NUMBER
423 , x_msg_data out nocopy VARCHAR2
424 );
425 procedure update_project_task_times(p0_a0 JTF_NUMBER_TABLE
426 , p0_a1 JTF_NUMBER_TABLE
427 , p0_a2 JTF_NUMBER_TABLE
428 , p0_a3 JTF_NUMBER_TABLE
429 , p0_a4 JTF_NUMBER_TABLE
430 , p0_a5 JTF_VARCHAR2_TABLE_100
431 , p0_a6 JTF_VARCHAR2_TABLE_300
432 , p0_a7 JTF_NUMBER_TABLE
433 , p0_a8 JTF_VARCHAR2_TABLE_300
434 , p0_a9 JTF_VARCHAR2_TABLE_100
435 , p0_a10 JTF_VARCHAR2_TABLE_300
436 , p0_a11 JTF_NUMBER_TABLE
437 , p0_a12 JTF_VARCHAR2_TABLE_100
438 , p0_a13 JTF_VARCHAR2_TABLE_100
439 , p0_a14 JTF_VARCHAR2_TABLE_100
440 , p0_a15 JTF_DATE_TABLE
441 , p0_a16 JTF_NUMBER_TABLE
442 , p0_a17 JTF_NUMBER_TABLE
443 , p0_a18 JTF_DATE_TABLE
444 , p0_a19 JTF_NUMBER_TABLE
445 , p0_a20 JTF_NUMBER_TABLE
446 , p0_a21 JTF_DATE_TABLE
447 , p0_a22 JTF_NUMBER_TABLE
448 , p0_a23 JTF_NUMBER_TABLE
449 , p0_a24 JTF_DATE_TABLE
450 , p0_a25 JTF_NUMBER_TABLE
451 , p0_a26 JTF_NUMBER_TABLE
452 , p0_a27 JTF_NUMBER_TABLE
453 , p0_a28 JTF_NUMBER_TABLE
454 , p0_a29 JTF_VARCHAR2_TABLE_100
455 , p0_a30 JTF_VARCHAR2_TABLE_100
456 , p0_a31 JTF_VARCHAR2_TABLE_100
457 , p0_a32 JTF_VARCHAR2_TABLE_300
458 , p0_a33 JTF_VARCHAR2_TABLE_100
459 , p0_a34 JTF_VARCHAR2_TABLE_100
460 , p0_a35 JTF_VARCHAR2_TABLE_100
461 , p0_a36 JTF_NUMBER_TABLE
462 , p0_a37 JTF_VARCHAR2_TABLE_300
463 , p0_a38 JTF_NUMBER_TABLE
464 , p0_a39 JTF_VARCHAR2_TABLE_100
465 , p0_a40 JTF_NUMBER_TABLE
466 , p0_a41 JTF_VARCHAR2_TABLE_100
467 , p0_a42 JTF_NUMBER_TABLE
468 , p0_a43 JTF_NUMBER_TABLE
469 , p0_a44 JTF_VARCHAR2_TABLE_100
470 , p0_a45 JTF_NUMBER_TABLE
471 , p0_a46 JTF_NUMBER_TABLE
472 , p0_a47 JTF_NUMBER_TABLE
473 , p0_a48 JTF_VARCHAR2_TABLE_100
474 , p0_a49 JTF_NUMBER_TABLE
475 , p0_a50 JTF_NUMBER_TABLE
476 , p0_a51 JTF_VARCHAR2_TABLE_100
477 , p0_a52 JTF_VARCHAR2_TABLE_100
478 , p0_a53 JTF_NUMBER_TABLE
479 , p0_a54 JTF_NUMBER_TABLE
480 , p0_a55 JTF_VARCHAR2_TABLE_300
481 , p0_a56 JTF_VARCHAR2_TABLE_100
482 , p0_a57 JTF_VARCHAR2_TABLE_100
483 , p0_a58 JTF_NUMBER_TABLE
484 , p0_a59 JTF_NUMBER_TABLE
485 , p0_a60 JTF_NUMBER_TABLE
486 , p0_a61 JTF_NUMBER_TABLE
487 , p0_a62 JTF_NUMBER_TABLE
488 , p0_a63 JTF_NUMBER_TABLE
489 , p0_a64 JTF_NUMBER_TABLE
490 , p0_a65 JTF_NUMBER_TABLE
491 , p0_a66 JTF_VARCHAR2_TABLE_100
492 , p0_a67 JTF_VARCHAR2_TABLE_100
493 , p0_a68 JTF_NUMBER_TABLE
494 , p0_a69 JTF_VARCHAR2_TABLE_100
495 , p0_a70 JTF_NUMBER_TABLE
496 , p0_a71 JTF_NUMBER_TABLE
497 , p0_a72 JTF_NUMBER_TABLE
498 , p0_a73 JTF_NUMBER_TABLE
499 , p0_a74 JTF_VARCHAR2_TABLE_100
500 , p0_a75 JTF_NUMBER_TABLE
501 , p0_a76 JTF_NUMBER_TABLE
502 , p0_a77 JTF_VARCHAR2_TABLE_100
503 , p0_a78 JTF_VARCHAR2_TABLE_200
504 , p0_a79 JTF_VARCHAR2_TABLE_200
505 , p0_a80 JTF_VARCHAR2_TABLE_200
506 , p0_a81 JTF_VARCHAR2_TABLE_200
507 , p0_a82 JTF_VARCHAR2_TABLE_200
508 , p0_a83 JTF_VARCHAR2_TABLE_200
509 , p0_a84 JTF_VARCHAR2_TABLE_200
510 , p0_a85 JTF_VARCHAR2_TABLE_200
511 , p0_a86 JTF_VARCHAR2_TABLE_200
512 , p0_a87 JTF_VARCHAR2_TABLE_200
513 , p0_a88 JTF_VARCHAR2_TABLE_200
514 , p0_a89 JTF_VARCHAR2_TABLE_200
515 , p0_a90 JTF_VARCHAR2_TABLE_200
516 , p0_a91 JTF_VARCHAR2_TABLE_200
517 , p0_a92 JTF_VARCHAR2_TABLE_200
518 , p0_a93 JTF_DATE_TABLE
519 , p0_a94 JTF_NUMBER_TABLE
520 , p0_a95 JTF_DATE_TABLE
521 , p0_a96 JTF_NUMBER_TABLE
522 , p0_a97 JTF_NUMBER_TABLE
523 , p0_a98 JTF_VARCHAR2_TABLE_100
524 , p0_a99 JTF_VARCHAR2_TABLE_100
525 , p0_a100 JTF_VARCHAR2_TABLE_100
526 , p0_a101 JTF_NUMBER_TABLE
527 , p0_a102 JTF_VARCHAR2_TABLE_100
528 , p0_a103 JTF_VARCHAR2_TABLE_100
529 , p0_a104 JTF_VARCHAR2_TABLE_100
530 , p_commit VARCHAR2
531 , x_return_status out nocopy VARCHAR2
532 , x_msg_count out nocopy NUMBER
533 , x_msg_data out nocopy VARCHAR2
534 );
535 procedure push_stages_to_production(p_api_version NUMBER
536 , p_init_msg_list VARCHAR2
537 , p_commit VARCHAR2
538 , p_validation_level NUMBER
539 , p_module_type VARCHAR2
540 , p_visit_id NUMBER
541 , p6_a0 JTF_NUMBER_TABLE
542 , p6_a1 JTF_NUMBER_TABLE
543 , p6_a2 JTF_VARCHAR2_TABLE_100
544 , p6_a3 JTF_NUMBER_TABLE
545 , p6_a4 JTF_DATE_TABLE
546 , p6_a5 JTF_DATE_TABLE
547 , p6_a6 JTF_DATE_TABLE
548 , p6_a7 JTF_VARCHAR2_TABLE_100
549 , p6_a8 JTF_NUMBER_TABLE
550 , p6_a9 JTF_DATE_TABLE
551 , p6_a10 JTF_NUMBER_TABLE
552 , p6_a11 JTF_VARCHAR2_TABLE_100
553 , p6_a12 JTF_VARCHAR2_TABLE_200
554 , p6_a13 JTF_VARCHAR2_TABLE_200
555 , p6_a14 JTF_VARCHAR2_TABLE_200
556 , p6_a15 JTF_VARCHAR2_TABLE_200
557 , p6_a16 JTF_VARCHAR2_TABLE_200
558 , p6_a17 JTF_VARCHAR2_TABLE_200
559 , p6_a18 JTF_VARCHAR2_TABLE_200
560 , p6_a19 JTF_VARCHAR2_TABLE_200
561 , p6_a20 JTF_VARCHAR2_TABLE_200
562 , p6_a21 JTF_VARCHAR2_TABLE_200
563 , p6_a22 JTF_VARCHAR2_TABLE_200
564 , p6_a23 JTF_VARCHAR2_TABLE_200
565 , p6_a24 JTF_VARCHAR2_TABLE_200
566 , p6_a25 JTF_VARCHAR2_TABLE_200
567 , p6_a26 JTF_VARCHAR2_TABLE_200
568 , p_release_flag VARCHAR2
569 , x_return_status out nocopy VARCHAR2
570 , x_msg_count out nocopy NUMBER
571 , x_msg_data out nocopy VARCHAR2
572 );
573 end ahl_vwp_proj_prod_pvt_w;