[Home] [Help]
PACKAGE: APPS.CAC_SYNC_TASK_W
Source
1 package cac_sync_task_w as
2 /* $Header: cacvstws.pls 120.3 2005/09/27 07:37:15 rhshriva noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy cac_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_2000
11 , a8 JTF_VARCHAR2_TABLE_4000
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_DATE_TABLE
16 , a13 JTF_DATE_TABLE
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_300
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_2000
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_VARCHAR2_TABLE_300
30 , a27 JTF_VARCHAR2_TABLE_2000
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_DATE_TABLE
34 , a31 JTF_DATE_TABLE
35 , a32 JTF_VARCHAR2_TABLE_100
36 , a33 JTF_VARCHAR2_TABLE_100
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_NUMBER_TABLE
44 , a41 JTF_VARCHAR2_TABLE_4000
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_VARCHAR2_TABLE_100
47 , a44 JTF_VARCHAR2_TABLE_100
48 );
49 procedure rosetta_table_copy_out_p3(t cac_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_NUMBER_TABLE
51 , a2 out nocopy JTF_NUMBER_TABLE
52 , a3 out nocopy JTF_DATE_TABLE
53 , a4 out nocopy JTF_NUMBER_TABLE
54 , a5 out nocopy JTF_VARCHAR2_TABLE_100
55 , a6 out nocopy JTF_VARCHAR2_TABLE_100
56 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
57 , a8 out nocopy JTF_VARCHAR2_TABLE_4000
58 , a9 out nocopy JTF_VARCHAR2_TABLE_100
59 , a10 out nocopy JTF_DATE_TABLE
60 , a11 out nocopy JTF_DATE_TABLE
61 , a12 out nocopy JTF_DATE_TABLE
62 , a13 out nocopy JTF_DATE_TABLE
63 , a14 out nocopy JTF_DATE_TABLE
64 , a15 out nocopy JTF_DATE_TABLE
65 , a16 out nocopy JTF_NUMBER_TABLE
66 , a17 out nocopy JTF_NUMBER_TABLE
67 , a18 out nocopy JTF_VARCHAR2_TABLE_100
68 , a19 out nocopy JTF_DATE_TABLE
69 , a20 out nocopy JTF_VARCHAR2_TABLE_100
70 , a21 out nocopy JTF_VARCHAR2_TABLE_300
71 , a22 out nocopy JTF_NUMBER_TABLE
72 , a23 out nocopy JTF_VARCHAR2_TABLE_2000
73 , a24 out nocopy JTF_NUMBER_TABLE
74 , a25 out nocopy JTF_NUMBER_TABLE
75 , a26 out nocopy JTF_VARCHAR2_TABLE_300
76 , a27 out nocopy JTF_VARCHAR2_TABLE_2000
77 , a28 out nocopy JTF_VARCHAR2_TABLE_100
78 , a29 out nocopy JTF_NUMBER_TABLE
79 , a30 out nocopy JTF_DATE_TABLE
80 , a31 out nocopy JTF_DATE_TABLE
81 , a32 out nocopy JTF_VARCHAR2_TABLE_100
82 , a33 out nocopy JTF_VARCHAR2_TABLE_100
83 , a34 out nocopy JTF_VARCHAR2_TABLE_100
84 , a35 out nocopy JTF_VARCHAR2_TABLE_100
85 , a36 out nocopy JTF_VARCHAR2_TABLE_100
86 , a37 out nocopy JTF_VARCHAR2_TABLE_100
87 , a38 out nocopy JTF_VARCHAR2_TABLE_100
88 , a39 out nocopy JTF_NUMBER_TABLE
89 , a40 out nocopy JTF_NUMBER_TABLE
90 , a41 out nocopy JTF_VARCHAR2_TABLE_4000
91 , a42 out nocopy JTF_NUMBER_TABLE
92 , a43 out nocopy JTF_VARCHAR2_TABLE_100
93 , a44 out nocopy JTF_VARCHAR2_TABLE_100
94 );
95
96 procedure rosetta_table_copy_in_p4(t out nocopy cac_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
97 , a1 JTF_DATE_TABLE
98 , a2 JTF_NUMBER_TABLE
99 , a3 JTF_NUMBER_TABLE
100 , a4 JTF_DATE_TABLE
101 , a5 JTF_NUMBER_TABLE
102 , a6 JTF_VARCHAR2_TABLE_100
103 , a7 JTF_VARCHAR2_TABLE_100
104 , a8 JTF_VARCHAR2_TABLE_2000
105 , a9 JTF_VARCHAR2_TABLE_4000
106 , a10 JTF_VARCHAR2_TABLE_100
107 , a11 JTF_DATE_TABLE
108 , a12 JTF_DATE_TABLE
109 , a13 JTF_DATE_TABLE
110 , a14 JTF_DATE_TABLE
111 , a15 JTF_DATE_TABLE
112 , a16 JTF_DATE_TABLE
113 , a17 JTF_NUMBER_TABLE
114 , a18 JTF_NUMBER_TABLE
115 , a19 JTF_VARCHAR2_TABLE_100
116 , a20 JTF_DATE_TABLE
117 , a21 JTF_VARCHAR2_TABLE_100
118 , a22 JTF_VARCHAR2_TABLE_300
119 , a23 JTF_NUMBER_TABLE
120 , a24 JTF_VARCHAR2_TABLE_2000
121 , a25 JTF_NUMBER_TABLE
122 , a26 JTF_NUMBER_TABLE
123 , a27 JTF_VARCHAR2_TABLE_300
124 , a28 JTF_VARCHAR2_TABLE_2000
125 , a29 JTF_VARCHAR2_TABLE_100
126 , a30 JTF_NUMBER_TABLE
127 , a31 JTF_DATE_TABLE
128 , a32 JTF_DATE_TABLE
129 , a33 JTF_VARCHAR2_TABLE_100
130 , a34 JTF_VARCHAR2_TABLE_100
131 , a35 JTF_VARCHAR2_TABLE_100
132 , a36 JTF_VARCHAR2_TABLE_100
133 , a37 JTF_VARCHAR2_TABLE_100
134 , a38 JTF_VARCHAR2_TABLE_100
135 , a39 JTF_VARCHAR2_TABLE_100
136 , a40 JTF_NUMBER_TABLE
137 , a41 JTF_NUMBER_TABLE
138 , a42 JTF_VARCHAR2_TABLE_4000
139 , a43 JTF_NUMBER_TABLE
140 , a44 JTF_VARCHAR2_TABLE_100
141 , a45 JTF_VARCHAR2_TABLE_100
142 );
143 procedure rosetta_table_copy_out_p4(t cac_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
144 , a1 out nocopy JTF_DATE_TABLE
145 , a2 out nocopy JTF_NUMBER_TABLE
146 , a3 out nocopy JTF_NUMBER_TABLE
147 , a4 out nocopy JTF_DATE_TABLE
148 , a5 out nocopy JTF_NUMBER_TABLE
149 , a6 out nocopy JTF_VARCHAR2_TABLE_100
150 , a7 out nocopy JTF_VARCHAR2_TABLE_100
151 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
152 , a9 out nocopy JTF_VARCHAR2_TABLE_4000
153 , a10 out nocopy JTF_VARCHAR2_TABLE_100
154 , a11 out nocopy JTF_DATE_TABLE
155 , a12 out nocopy JTF_DATE_TABLE
156 , a13 out nocopy JTF_DATE_TABLE
157 , a14 out nocopy JTF_DATE_TABLE
158 , a15 out nocopy JTF_DATE_TABLE
159 , a16 out nocopy JTF_DATE_TABLE
160 , a17 out nocopy JTF_NUMBER_TABLE
161 , a18 out nocopy JTF_NUMBER_TABLE
162 , a19 out nocopy JTF_VARCHAR2_TABLE_100
163 , a20 out nocopy JTF_DATE_TABLE
164 , a21 out nocopy JTF_VARCHAR2_TABLE_100
165 , a22 out nocopy JTF_VARCHAR2_TABLE_300
166 , a23 out nocopy JTF_NUMBER_TABLE
167 , a24 out nocopy JTF_VARCHAR2_TABLE_2000
168 , a25 out nocopy JTF_NUMBER_TABLE
169 , a26 out nocopy JTF_NUMBER_TABLE
170 , a27 out nocopy JTF_VARCHAR2_TABLE_300
171 , a28 out nocopy JTF_VARCHAR2_TABLE_2000
172 , a29 out nocopy JTF_VARCHAR2_TABLE_100
173 , a30 out nocopy JTF_NUMBER_TABLE
174 , a31 out nocopy JTF_DATE_TABLE
175 , a32 out nocopy JTF_DATE_TABLE
176 , a33 out nocopy JTF_VARCHAR2_TABLE_100
177 , a34 out nocopy JTF_VARCHAR2_TABLE_100
178 , a35 out nocopy JTF_VARCHAR2_TABLE_100
179 , a36 out nocopy JTF_VARCHAR2_TABLE_100
180 , a37 out nocopy JTF_VARCHAR2_TABLE_100
181 , a38 out nocopy JTF_VARCHAR2_TABLE_100
182 , a39 out nocopy JTF_VARCHAR2_TABLE_100
183 , a40 out nocopy JTF_NUMBER_TABLE
184 , a41 out nocopy JTF_NUMBER_TABLE
185 , a42 out nocopy JTF_VARCHAR2_TABLE_4000
186 , a43 out nocopy JTF_NUMBER_TABLE
187 , a44 out nocopy JTF_VARCHAR2_TABLE_100
188 , a45 out nocopy JTF_VARCHAR2_TABLE_100
189 );
190
191 procedure rosetta_table_copy_in_p6(t out nocopy cac_sync_task.attendee_tbl, a0 JTF_NUMBER_TABLE
192 , a1 JTF_VARCHAR2_TABLE_2000
193 , a2 JTF_NUMBER_TABLE
194 , a3 JTF_NUMBER_TABLE
195 , a4 JTF_VARCHAR2_TABLE_2000
196 , a5 JTF_VARCHAR2_TABLE_200
197 , a6 JTF_VARCHAR2_TABLE_100
198 , a7 JTF_VARCHAR2_TABLE_200
199 , a8 JTF_VARCHAR2_TABLE_100
200 , a9 JTF_VARCHAR2_TABLE_100
201 , a10 JTF_VARCHAR2_TABLE_100
202 , a11 JTF_VARCHAR2_TABLE_100
203 , a12 JTF_VARCHAR2_TABLE_2000
204 , a13 JTF_VARCHAR2_TABLE_100
205 );
206 procedure rosetta_table_copy_out_p6(t cac_sync_task.attendee_tbl, a0 out nocopy JTF_NUMBER_TABLE
207 , a1 out nocopy JTF_VARCHAR2_TABLE_2000
208 , a2 out nocopy JTF_NUMBER_TABLE
209 , a3 out nocopy JTF_NUMBER_TABLE
210 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
211 , a5 out nocopy JTF_VARCHAR2_TABLE_200
212 , a6 out nocopy JTF_VARCHAR2_TABLE_100
213 , a7 out nocopy JTF_VARCHAR2_TABLE_200
214 , a8 out nocopy JTF_VARCHAR2_TABLE_100
215 , a9 out nocopy JTF_VARCHAR2_TABLE_100
216 , a10 out nocopy JTF_VARCHAR2_TABLE_100
217 , a11 out nocopy JTF_VARCHAR2_TABLE_100
218 , a12 out nocopy JTF_VARCHAR2_TABLE_2000
219 , a13 out nocopy JTF_VARCHAR2_TABLE_100
220 );
221
222 procedure get_count(p_request_type VARCHAR2
223 , p_syncanchor date
224 , p_principal_id NUMBER
225 , x_total out nocopy NUMBER
226 , x_totalnew out nocopy NUMBER
227 , x_totalmodified out nocopy NUMBER
228 , x_totaldeleted out nocopy NUMBER
229 );
230 procedure get_list(p_request_type VARCHAR2
231 , p_syncanchor date
232 , p_principal_id NUMBER
233 , p_sync_type VARCHAR2
234 , p4_a0 out nocopy JTF_NUMBER_TABLE
235 , p4_a1 out nocopy JTF_NUMBER_TABLE
236 , p4_a2 out nocopy JTF_NUMBER_TABLE
237 , p4_a3 out nocopy JTF_DATE_TABLE
238 , p4_a4 out nocopy JTF_NUMBER_TABLE
239 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
240 , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
241 , p4_a7 out nocopy JTF_VARCHAR2_TABLE_2000
242 , p4_a8 out nocopy JTF_VARCHAR2_TABLE_4000
243 , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
244 , p4_a10 out nocopy JTF_DATE_TABLE
245 , p4_a11 out nocopy JTF_DATE_TABLE
246 , p4_a12 out nocopy JTF_DATE_TABLE
247 , p4_a13 out nocopy JTF_DATE_TABLE
248 , p4_a14 out nocopy JTF_DATE_TABLE
249 , p4_a15 out nocopy JTF_DATE_TABLE
250 , p4_a16 out nocopy JTF_NUMBER_TABLE
251 , p4_a17 out nocopy JTF_NUMBER_TABLE
252 , p4_a18 out nocopy JTF_VARCHAR2_TABLE_100
253 , p4_a19 out nocopy JTF_DATE_TABLE
254 , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
255 , p4_a21 out nocopy JTF_VARCHAR2_TABLE_300
256 , p4_a22 out nocopy JTF_NUMBER_TABLE
257 , p4_a23 out nocopy JTF_VARCHAR2_TABLE_2000
258 , p4_a24 out nocopy JTF_NUMBER_TABLE
259 , p4_a25 out nocopy JTF_NUMBER_TABLE
260 , p4_a26 out nocopy JTF_VARCHAR2_TABLE_300
261 , p4_a27 out nocopy JTF_VARCHAR2_TABLE_2000
262 , p4_a28 out nocopy JTF_VARCHAR2_TABLE_100
263 , p4_a29 out nocopy JTF_NUMBER_TABLE
264 , p4_a30 out nocopy JTF_DATE_TABLE
265 , p4_a31 out nocopy JTF_DATE_TABLE
266 , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267 , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268 , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269 , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270 , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271 , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272 , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100
273 , p4_a39 out nocopy JTF_NUMBER_TABLE
274 , p4_a40 out nocopy JTF_NUMBER_TABLE
275 , p4_a41 out nocopy JTF_VARCHAR2_TABLE_4000
276 , p4_a42 out nocopy JTF_NUMBER_TABLE
277 , p4_a43 out nocopy JTF_VARCHAR2_TABLE_100
278 , p4_a44 out nocopy JTF_VARCHAR2_TABLE_100
279 , p5_a0 out nocopy JTF_NUMBER_TABLE
280 , p5_a1 out nocopy JTF_DATE_TABLE
281 , p5_a2 out nocopy JTF_NUMBER_TABLE
282 , p5_a3 out nocopy JTF_NUMBER_TABLE
283 , p5_a4 out nocopy JTF_DATE_TABLE
284 , p5_a5 out nocopy JTF_NUMBER_TABLE
285 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
286 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
287 , p5_a8 out nocopy JTF_VARCHAR2_TABLE_2000
288 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_4000
289 , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
290 , p5_a11 out nocopy JTF_DATE_TABLE
291 , p5_a12 out nocopy JTF_DATE_TABLE
292 , p5_a13 out nocopy JTF_DATE_TABLE
293 , p5_a14 out nocopy JTF_DATE_TABLE
294 , p5_a15 out nocopy JTF_DATE_TABLE
295 , p5_a16 out nocopy JTF_DATE_TABLE
296 , p5_a17 out nocopy JTF_NUMBER_TABLE
297 , p5_a18 out nocopy JTF_NUMBER_TABLE
298 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
299 , p5_a20 out nocopy JTF_DATE_TABLE
300 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
301 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
302 , p5_a23 out nocopy JTF_NUMBER_TABLE
303 , p5_a24 out nocopy JTF_VARCHAR2_TABLE_2000
304 , p5_a25 out nocopy JTF_NUMBER_TABLE
305 , p5_a26 out nocopy JTF_NUMBER_TABLE
306 , p5_a27 out nocopy JTF_VARCHAR2_TABLE_300
307 , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
308 , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
309 , p5_a30 out nocopy JTF_NUMBER_TABLE
310 , p5_a31 out nocopy JTF_DATE_TABLE
311 , p5_a32 out nocopy JTF_DATE_TABLE
312 , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313 , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314 , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315 , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316 , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317 , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318 , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
319 , p5_a40 out nocopy JTF_NUMBER_TABLE
320 , p5_a41 out nocopy JTF_NUMBER_TABLE
321 , p5_a42 out nocopy JTF_VARCHAR2_TABLE_4000
322 , p5_a43 out nocopy JTF_NUMBER_TABLE
323 , p5_a44 out nocopy JTF_VARCHAR2_TABLE_100
324 , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
325 , p6_a0 out nocopy JTF_NUMBER_TABLE
326 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_2000
327 , p6_a2 out nocopy JTF_NUMBER_TABLE
328 , p6_a3 out nocopy JTF_NUMBER_TABLE
329 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
330 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
331 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
332 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
338 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
339 );
340 procedure create_ids(p_num_req NUMBER
341 , p1_a0 in out nocopy JTF_NUMBER_TABLE
342 , p1_a1 in out nocopy JTF_NUMBER_TABLE
343 , p1_a2 in out nocopy JTF_NUMBER_TABLE
344 , p1_a3 in out nocopy JTF_DATE_TABLE
345 , p1_a4 in out nocopy JTF_NUMBER_TABLE
346 , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347 , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
348 , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
349 , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
350 , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
351 , p1_a10 in out nocopy JTF_DATE_TABLE
352 , p1_a11 in out nocopy JTF_DATE_TABLE
353 , p1_a12 in out nocopy JTF_DATE_TABLE
354 , p1_a13 in out nocopy JTF_DATE_TABLE
355 , p1_a14 in out nocopy JTF_DATE_TABLE
356 , p1_a15 in out nocopy JTF_DATE_TABLE
357 , p1_a16 in out nocopy JTF_NUMBER_TABLE
358 , p1_a17 in out nocopy JTF_NUMBER_TABLE
359 , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
360 , p1_a19 in out nocopy JTF_DATE_TABLE
361 , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
362 , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
363 , p1_a22 in out nocopy JTF_NUMBER_TABLE
364 , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
365 , p1_a24 in out nocopy JTF_NUMBER_TABLE
366 , p1_a25 in out nocopy JTF_NUMBER_TABLE
367 , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
368 , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
369 , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
370 , p1_a29 in out nocopy JTF_NUMBER_TABLE
371 , p1_a30 in out nocopy JTF_DATE_TABLE
372 , p1_a31 in out nocopy JTF_DATE_TABLE
373 , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374 , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375 , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
379 , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
376 , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377 , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378 , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
380 , p1_a39 in out nocopy JTF_NUMBER_TABLE
381 , p1_a40 in out nocopy JTF_NUMBER_TABLE
382 , p1_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
383 , p1_a42 in out nocopy JTF_NUMBER_TABLE
384 , p1_a43 in out nocopy JTF_VARCHAR2_TABLE_100
385 , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
386 );
387 procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
388 , p0_a1 in out nocopy JTF_NUMBER_TABLE
389 , p0_a2 in out nocopy JTF_NUMBER_TABLE
390 , p0_a3 in out nocopy JTF_DATE_TABLE
391 , p0_a4 in out nocopy JTF_NUMBER_TABLE
392 , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
393 , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
394 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
395 , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
396 , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
397 , p0_a10 in out nocopy JTF_DATE_TABLE
398 , p0_a11 in out nocopy JTF_DATE_TABLE
399 , p0_a12 in out nocopy JTF_DATE_TABLE
400 , p0_a13 in out nocopy JTF_DATE_TABLE
401 , p0_a14 in out nocopy JTF_DATE_TABLE
402 , p0_a15 in out nocopy JTF_DATE_TABLE
403 , p0_a16 in out nocopy JTF_NUMBER_TABLE
404 , p0_a17 in out nocopy JTF_NUMBER_TABLE
405 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
406 , p0_a19 in out nocopy JTF_DATE_TABLE
407 , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
408 , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
409 , p0_a22 in out nocopy JTF_NUMBER_TABLE
410 , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
411 , p0_a24 in out nocopy JTF_NUMBER_TABLE
412 , p0_a25 in out nocopy JTF_NUMBER_TABLE
413 , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
414 , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
415 , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
416 , p0_a29 in out nocopy JTF_NUMBER_TABLE
417 , p0_a30 in out nocopy JTF_DATE_TABLE
418 , p0_a31 in out nocopy JTF_DATE_TABLE
419 , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420 , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421 , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422 , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423 , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424 , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425 , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
426 , p0_a39 in out nocopy JTF_NUMBER_TABLE
427 , p0_a40 in out nocopy JTF_NUMBER_TABLE
428 , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
429 , p0_a42 in out nocopy JTF_NUMBER_TABLE
430 , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
431 , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
432 , p1_a0 in out nocopy JTF_NUMBER_TABLE
433 , p1_a1 in out nocopy JTF_DATE_TABLE
434 , p1_a2 in out nocopy JTF_NUMBER_TABLE
435 , p1_a3 in out nocopy JTF_NUMBER_TABLE
436 , p1_a4 in out nocopy JTF_DATE_TABLE
437 , p1_a5 in out nocopy JTF_NUMBER_TABLE
438 , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
439 , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_100
440 , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
441 , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_4000
442 , p1_a10 in out nocopy JTF_VARCHAR2_TABLE_100
443 , p1_a11 in out nocopy JTF_DATE_TABLE
444 , p1_a12 in out nocopy JTF_DATE_TABLE
445 , p1_a13 in out nocopy JTF_DATE_TABLE
446 , p1_a14 in out nocopy JTF_DATE_TABLE
447 , p1_a15 in out nocopy JTF_DATE_TABLE
448 , p1_a16 in out nocopy JTF_DATE_TABLE
449 , p1_a17 in out nocopy JTF_NUMBER_TABLE
450 , p1_a18 in out nocopy JTF_NUMBER_TABLE
451 , p1_a19 in out nocopy JTF_VARCHAR2_TABLE_100
452 , p1_a20 in out nocopy JTF_DATE_TABLE
453 , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_100
454 , p1_a22 in out nocopy JTF_VARCHAR2_TABLE_300
455 , p1_a23 in out nocopy JTF_NUMBER_TABLE
456 , p1_a24 in out nocopy JTF_VARCHAR2_TABLE_2000
457 , p1_a25 in out nocopy JTF_NUMBER_TABLE
458 , p1_a26 in out nocopy JTF_NUMBER_TABLE
459 , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_300
460 , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_2000
461 , p1_a29 in out nocopy JTF_VARCHAR2_TABLE_100
462 , p1_a30 in out nocopy JTF_NUMBER_TABLE
463 , p1_a31 in out nocopy JTF_DATE_TABLE
464 , p1_a32 in out nocopy JTF_DATE_TABLE
465 , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466 , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467 , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468 , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469 , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470 , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471 , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100
472 , p1_a40 in out nocopy JTF_NUMBER_TABLE
473 , p1_a41 in out nocopy JTF_NUMBER_TABLE
474 , p1_a42 in out nocopy JTF_VARCHAR2_TABLE_4000
475 , p1_a43 in out nocopy JTF_NUMBER_TABLE
479 procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
476 , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
477 , p1_a45 in out nocopy JTF_VARCHAR2_TABLE_100
478 );
480 , p0_a1 in out nocopy JTF_NUMBER_TABLE
481 , p0_a2 in out nocopy JTF_NUMBER_TABLE
482 , p0_a3 in out nocopy JTF_DATE_TABLE
483 , p0_a4 in out nocopy JTF_NUMBER_TABLE
484 , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
485 , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
486 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
487 , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
488 , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
489 , p0_a10 in out nocopy JTF_DATE_TABLE
490 , p0_a11 in out nocopy JTF_DATE_TABLE
491 , p0_a12 in out nocopy JTF_DATE_TABLE
492 , p0_a13 in out nocopy JTF_DATE_TABLE
493 , p0_a14 in out nocopy JTF_DATE_TABLE
494 , p0_a15 in out nocopy JTF_DATE_TABLE
495 , p0_a16 in out nocopy JTF_NUMBER_TABLE
496 , p0_a17 in out nocopy JTF_NUMBER_TABLE
497 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
498 , p0_a19 in out nocopy JTF_DATE_TABLE
499 , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
500 , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
501 , p0_a22 in out nocopy JTF_NUMBER_TABLE
502 , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
503 , p0_a24 in out nocopy JTF_NUMBER_TABLE
504 , p0_a25 in out nocopy JTF_NUMBER_TABLE
505 , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
506 , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
507 , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
508 , p0_a29 in out nocopy JTF_NUMBER_TABLE
509 , p0_a30 in out nocopy JTF_DATE_TABLE
510 , p0_a31 in out nocopy JTF_DATE_TABLE
511 , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512 , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513 , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514 , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515 , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516 , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517 , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
518 , p0_a39 in out nocopy JTF_NUMBER_TABLE
519 , p0_a40 in out nocopy JTF_NUMBER_TABLE
520 , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
521 , p0_a42 in out nocopy JTF_NUMBER_TABLE
522 , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
523 , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
524 );
525 end cac_sync_task_w;