[Home] [Help]
PACKAGE: APPS.AS_OPPORTUNITY_PUB_W
Source
1 package as_opportunity_pub_w as
2 /* $Header: asxwop1s.pls 120.1 2005/08/01 05:38 appldev ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy as_opportunity_pub.header_tbl_type, a0 JTF_DATE_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_VARCHAR2_TABLE_300
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_300
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_VARCHAR2_TABLE_400
22 , a19 JTF_VARCHAR2_TABLE_400
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_VARCHAR2_TABLE_300
25 , a22 JTF_VARCHAR2_TABLE_300
26 , a23 JTF_VARCHAR2_TABLE_300
27 , a24 JTF_VARCHAR2_TABLE_300
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_VARCHAR2_TABLE_100
30 , a27 JTF_VARCHAR2_TABLE_100
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_NUMBER_TABLE
35 , a32 JTF_VARCHAR2_TABLE_100
36 , a33 JTF_VARCHAR2_TABLE_300
37 , a34 JTF_NUMBER_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_VARCHAR2_TABLE_100
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_DATE_TABLE
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_VARCHAR2_TABLE_100
44 , a41 JTF_VARCHAR2_TABLE_100
45 , a42 JTF_VARCHAR2_TABLE_100
46 , a43 JTF_VARCHAR2_TABLE_100
47 , a44 JTF_NUMBER_TABLE
48 , a45 JTF_VARCHAR2_TABLE_400
49 , a46 JTF_VARCHAR2_TABLE_300
50 , a47 JTF_NUMBER_TABLE
51 , a48 JTF_VARCHAR2_TABLE_400
52 , a49 JTF_NUMBER_TABLE
53 , a50 JTF_NUMBER_TABLE
54 , a51 JTF_NUMBER_TABLE
55 , a52 JTF_VARCHAR2_TABLE_100
56 , a53 JTF_VARCHAR2_TABLE_100
57 , a54 JTF_VARCHAR2_TABLE_100
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_NUMBER_TABLE
60 , a57 JTF_VARCHAR2_TABLE_100
61 , a58 JTF_VARCHAR2_TABLE_100
62 , a59 JTF_VARCHAR2_TABLE_100
63 , a60 JTF_VARCHAR2_TABLE_100
64 , a61 JTF_VARCHAR2_TABLE_100
65 , a62 JTF_VARCHAR2_TABLE_100
66 , a63 JTF_NUMBER_TABLE
67 , a64 JTF_VARCHAR2_TABLE_100
68 , a65 JTF_NUMBER_TABLE
69 , a66 JTF_NUMBER_TABLE
70 , a67 JTF_VARCHAR2_TABLE_100
71 , a68 JTF_NUMBER_TABLE
72 , a69 JTF_NUMBER_TABLE
73 , a70 JTF_NUMBER_TABLE
74 , a71 JTF_VARCHAR2_TABLE_100
75 , a72 JTF_VARCHAR2_TABLE_100
76 , a73 JTF_DATE_TABLE
77 , a74 JTF_VARCHAR2_TABLE_100
78 , a75 JTF_VARCHAR2_TABLE_100
79 , a76 JTF_VARCHAR2_TABLE_100
80 , a77 JTF_VARCHAR2_TABLE_100
81 , a78 JTF_VARCHAR2_TABLE_100
82 , a79 JTF_VARCHAR2_TABLE_100
83 , a80 JTF_NUMBER_TABLE
84 , a81 JTF_VARCHAR2_TABLE_100
85 , a82 JTF_VARCHAR2_TABLE_100
86 , a83 JTF_VARCHAR2_TABLE_200
87 , a84 JTF_VARCHAR2_TABLE_200
88 , a85 JTF_VARCHAR2_TABLE_200
89 , a86 JTF_VARCHAR2_TABLE_200
90 , a87 JTF_VARCHAR2_TABLE_200
91 , a88 JTF_VARCHAR2_TABLE_200
92 , a89 JTF_VARCHAR2_TABLE_200
93 , a90 JTF_VARCHAR2_TABLE_200
94 , a91 JTF_VARCHAR2_TABLE_200
95 , a92 JTF_VARCHAR2_TABLE_200
96 , a93 JTF_VARCHAR2_TABLE_200
97 , a94 JTF_VARCHAR2_TABLE_200
98 , a95 JTF_VARCHAR2_TABLE_200
99 , a96 JTF_VARCHAR2_TABLE_200
100 , a97 JTF_VARCHAR2_TABLE_200
101 , a98 JTF_VARCHAR2_TABLE_100
102 , a99 JTF_NUMBER_TABLE
103 );
104 procedure rosetta_table_copy_out_p2(t as_opportunity_pub.header_tbl_type, a0 out nocopy JTF_DATE_TABLE
105 , a1 out nocopy JTF_NUMBER_TABLE
106 , a2 out nocopy JTF_DATE_TABLE
107 , a3 out nocopy JTF_NUMBER_TABLE
108 , a4 out nocopy JTF_NUMBER_TABLE
109 , a5 out nocopy JTF_NUMBER_TABLE
110 , a6 out nocopy JTF_NUMBER_TABLE
111 , a7 out nocopy JTF_NUMBER_TABLE
112 , a8 out nocopy JTF_DATE_TABLE
113 , a9 out nocopy JTF_NUMBER_TABLE
114 , a10 out nocopy JTF_VARCHAR2_TABLE_100
115 , a11 out nocopy JTF_VARCHAR2_TABLE_300
116 , a12 out nocopy JTF_VARCHAR2_TABLE_100
117 , a13 out nocopy JTF_VARCHAR2_TABLE_100
118 , a14 out nocopy JTF_VARCHAR2_TABLE_300
119 , a15 out nocopy JTF_NUMBER_TABLE
120 , a16 out nocopy JTF_VARCHAR2_TABLE_100
121 , a17 out nocopy JTF_NUMBER_TABLE
122 , a18 out nocopy JTF_VARCHAR2_TABLE_400
123 , a19 out nocopy JTF_VARCHAR2_TABLE_400
124 , a20 out nocopy JTF_NUMBER_TABLE
125 , a21 out nocopy JTF_VARCHAR2_TABLE_300
126 , a22 out nocopy JTF_VARCHAR2_TABLE_300
127 , a23 out nocopy JTF_VARCHAR2_TABLE_300
128 , a24 out nocopy JTF_VARCHAR2_TABLE_300
129 , a25 out nocopy JTF_VARCHAR2_TABLE_100
130 , a26 out nocopy JTF_VARCHAR2_TABLE_100
131 , a27 out nocopy JTF_VARCHAR2_TABLE_100
132 , a28 out nocopy JTF_VARCHAR2_TABLE_100
133 , a29 out nocopy JTF_NUMBER_TABLE
134 , a30 out nocopy JTF_VARCHAR2_TABLE_100
135 , a31 out nocopy JTF_NUMBER_TABLE
136 , a32 out nocopy JTF_VARCHAR2_TABLE_100
137 , a33 out nocopy JTF_VARCHAR2_TABLE_300
138 , a34 out nocopy JTF_NUMBER_TABLE
139 , a35 out nocopy JTF_NUMBER_TABLE
140 , a36 out nocopy JTF_VARCHAR2_TABLE_100
141 , a37 out nocopy JTF_VARCHAR2_TABLE_100
142 , a38 out nocopy JTF_DATE_TABLE
143 , a39 out nocopy JTF_VARCHAR2_TABLE_100
144 , a40 out nocopy JTF_VARCHAR2_TABLE_100
145 , a41 out nocopy JTF_VARCHAR2_TABLE_100
146 , a42 out nocopy JTF_VARCHAR2_TABLE_100
147 , a43 out nocopy JTF_VARCHAR2_TABLE_100
148 , a44 out nocopy JTF_NUMBER_TABLE
149 , a45 out nocopy JTF_VARCHAR2_TABLE_400
150 , a46 out nocopy JTF_VARCHAR2_TABLE_300
151 , a47 out nocopy JTF_NUMBER_TABLE
152 , a48 out nocopy JTF_VARCHAR2_TABLE_400
153 , a49 out nocopy JTF_NUMBER_TABLE
154 , a50 out nocopy JTF_NUMBER_TABLE
155 , a51 out nocopy JTF_NUMBER_TABLE
156 , a52 out nocopy JTF_VARCHAR2_TABLE_100
157 , a53 out nocopy JTF_VARCHAR2_TABLE_100
158 , a54 out nocopy JTF_VARCHAR2_TABLE_100
159 , a55 out nocopy JTF_NUMBER_TABLE
160 , a56 out nocopy JTF_NUMBER_TABLE
161 , a57 out nocopy JTF_VARCHAR2_TABLE_100
162 , a58 out nocopy JTF_VARCHAR2_TABLE_100
163 , a59 out nocopy JTF_VARCHAR2_TABLE_100
164 , a60 out nocopy JTF_VARCHAR2_TABLE_100
165 , a61 out nocopy JTF_VARCHAR2_TABLE_100
166 , a62 out nocopy JTF_VARCHAR2_TABLE_100
167 , a63 out nocopy JTF_NUMBER_TABLE
168 , a64 out nocopy JTF_VARCHAR2_TABLE_100
169 , a65 out nocopy JTF_NUMBER_TABLE
170 , a66 out nocopy JTF_NUMBER_TABLE
171 , a67 out nocopy JTF_VARCHAR2_TABLE_100
172 , a68 out nocopy JTF_NUMBER_TABLE
173 , a69 out nocopy JTF_NUMBER_TABLE
174 , a70 out nocopy JTF_NUMBER_TABLE
175 , a71 out nocopy JTF_VARCHAR2_TABLE_100
176 , a72 out nocopy JTF_VARCHAR2_TABLE_100
177 , a73 out nocopy JTF_DATE_TABLE
178 , a74 out nocopy JTF_VARCHAR2_TABLE_100
179 , a75 out nocopy JTF_VARCHAR2_TABLE_100
180 , a76 out nocopy JTF_VARCHAR2_TABLE_100
181 , a77 out nocopy JTF_VARCHAR2_TABLE_100
182 , a78 out nocopy JTF_VARCHAR2_TABLE_100
183 , a79 out nocopy JTF_VARCHAR2_TABLE_100
184 , a80 out nocopy JTF_NUMBER_TABLE
185 , a81 out nocopy JTF_VARCHAR2_TABLE_100
186 , a82 out nocopy JTF_VARCHAR2_TABLE_100
187 , a83 out nocopy JTF_VARCHAR2_TABLE_200
188 , a84 out nocopy JTF_VARCHAR2_TABLE_200
189 , a85 out nocopy JTF_VARCHAR2_TABLE_200
190 , a86 out nocopy JTF_VARCHAR2_TABLE_200
191 , a87 out nocopy JTF_VARCHAR2_TABLE_200
192 , a88 out nocopy JTF_VARCHAR2_TABLE_200
193 , a89 out nocopy JTF_VARCHAR2_TABLE_200
194 , a90 out nocopy JTF_VARCHAR2_TABLE_200
195 , a91 out nocopy JTF_VARCHAR2_TABLE_200
196 , a92 out nocopy JTF_VARCHAR2_TABLE_200
197 , a93 out nocopy JTF_VARCHAR2_TABLE_200
198 , a94 out nocopy JTF_VARCHAR2_TABLE_200
199 , a95 out nocopy JTF_VARCHAR2_TABLE_200
200 , a96 out nocopy JTF_VARCHAR2_TABLE_200
201 , a97 out nocopy JTF_VARCHAR2_TABLE_200
202 , a98 out nocopy JTF_VARCHAR2_TABLE_100
203 , a99 out nocopy JTF_NUMBER_TABLE
204 );
205
206 procedure rosetta_table_copy_in_p6(t out nocopy as_opportunity_pub.line_tbl_type, a0 JTF_DATE_TABLE
207 , a1 JTF_NUMBER_TABLE
208 , a2 JTF_DATE_TABLE
209 , a3 JTF_NUMBER_TABLE
210 , a4 JTF_NUMBER_TABLE
211 , a5 JTF_NUMBER_TABLE
212 , a6 JTF_NUMBER_TABLE
213 , a7 JTF_NUMBER_TABLE
214 , a8 JTF_DATE_TABLE
215 , a9 JTF_NUMBER_TABLE
216 , a10 JTF_NUMBER_TABLE
217 , a11 JTF_NUMBER_TABLE
218 , a12 JTF_NUMBER_TABLE
219 , a13 JTF_VARCHAR2_TABLE_100
220 , a14 JTF_VARCHAR2_TABLE_100
221 , a15 JTF_NUMBER_TABLE
222 , a16 JTF_VARCHAR2_TABLE_100
223 , a17 JTF_NUMBER_TABLE
224 , a18 JTF_VARCHAR2_TABLE_100
225 , a19 JTF_NUMBER_TABLE
226 , a20 JTF_VARCHAR2_TABLE_2000
227 , a21 JTF_NUMBER_TABLE
228 , a22 JTF_VARCHAR2_TABLE_100
229 , a23 JTF_VARCHAR2_TABLE_100
230 , a24 JTF_NUMBER_TABLE
231 , a25 JTF_DATE_TABLE
232 , a26 JTF_NUMBER_TABLE
233 , a27 JTF_NUMBER_TABLE
234 , a28 JTF_VARCHAR2_TABLE_100
235 , a29 JTF_NUMBER_TABLE
236 , a30 JTF_VARCHAR2_TABLE_100
237 , a31 JTF_VARCHAR2_TABLE_100
238 , a32 JTF_DATE_TABLE
239 , a33 JTF_VARCHAR2_TABLE_100
240 , a34 JTF_VARCHAR2_TABLE_100
241 , a35 JTF_NUMBER_TABLE
242 , a36 JTF_NUMBER_TABLE
243 , a37 JTF_NUMBER_TABLE
244 , a38 JTF_VARCHAR2_TABLE_100
245 , a39 JTF_VARCHAR2_TABLE_100
246 , a40 JTF_VARCHAR2_TABLE_100
247 , a41 JTF_VARCHAR2_TABLE_100
248 , a42 JTF_NUMBER_TABLE
249 , a43 JTF_NUMBER_TABLE
250 , a44 JTF_DATE_TABLE
251 , a45 JTF_VARCHAR2_TABLE_100
252 , a46 JTF_NUMBER_TABLE
253 , a47 JTF_NUMBER_TABLE
254 , a48 JTF_NUMBER_TABLE
255 , a49 JTF_NUMBER_TABLE
256 , a50 JTF_VARCHAR2_TABLE_100
257 , a51 JTF_VARCHAR2_TABLE_200
258 , a52 JTF_VARCHAR2_TABLE_200
259 , a53 JTF_VARCHAR2_TABLE_200
260 , a54 JTF_VARCHAR2_TABLE_200
261 , a55 JTF_VARCHAR2_TABLE_200
262 , a56 JTF_VARCHAR2_TABLE_200
263 , a57 JTF_VARCHAR2_TABLE_200
264 , a58 JTF_VARCHAR2_TABLE_200
265 , a59 JTF_VARCHAR2_TABLE_200
266 , a60 JTF_VARCHAR2_TABLE_200
267 , a61 JTF_VARCHAR2_TABLE_200
268 , a62 JTF_VARCHAR2_TABLE_200
269 , a63 JTF_VARCHAR2_TABLE_200
270 , a64 JTF_VARCHAR2_TABLE_200
271 , a65 JTF_VARCHAR2_TABLE_200
272 , a66 JTF_NUMBER_TABLE
273 , a67 JTF_NUMBER_TABLE
274 , a68 JTF_NUMBER_TABLE
275 );
276 procedure rosetta_table_copy_out_p6(t as_opportunity_pub.line_tbl_type, a0 out nocopy JTF_DATE_TABLE
277 , a1 out nocopy JTF_NUMBER_TABLE
278 , a2 out nocopy JTF_DATE_TABLE
279 , a3 out nocopy JTF_NUMBER_TABLE
280 , a4 out nocopy JTF_NUMBER_TABLE
281 , a5 out nocopy JTF_NUMBER_TABLE
282 , a6 out nocopy JTF_NUMBER_TABLE
283 , a7 out nocopy JTF_NUMBER_TABLE
284 , a8 out nocopy JTF_DATE_TABLE
285 , a9 out nocopy JTF_NUMBER_TABLE
286 , a10 out nocopy JTF_NUMBER_TABLE
287 , a11 out nocopy JTF_NUMBER_TABLE
288 , a12 out nocopy JTF_NUMBER_TABLE
289 , a13 out nocopy JTF_VARCHAR2_TABLE_100
290 , a14 out nocopy JTF_VARCHAR2_TABLE_100
291 , a15 out nocopy JTF_NUMBER_TABLE
292 , a16 out nocopy JTF_VARCHAR2_TABLE_100
293 , a17 out nocopy JTF_NUMBER_TABLE
294 , a18 out nocopy JTF_VARCHAR2_TABLE_100
295 , a19 out nocopy JTF_NUMBER_TABLE
296 , a20 out nocopy JTF_VARCHAR2_TABLE_2000
297 , a21 out nocopy JTF_NUMBER_TABLE
298 , a22 out nocopy JTF_VARCHAR2_TABLE_100
299 , a23 out nocopy JTF_VARCHAR2_TABLE_100
300 , a24 out nocopy JTF_NUMBER_TABLE
301 , a25 out nocopy JTF_DATE_TABLE
302 , a26 out nocopy JTF_NUMBER_TABLE
303 , a27 out nocopy JTF_NUMBER_TABLE
304 , a28 out nocopy JTF_VARCHAR2_TABLE_100
305 , a29 out nocopy JTF_NUMBER_TABLE
306 , a30 out nocopy JTF_VARCHAR2_TABLE_100
307 , a31 out nocopy JTF_VARCHAR2_TABLE_100
308 , a32 out nocopy JTF_DATE_TABLE
309 , a33 out nocopy JTF_VARCHAR2_TABLE_100
310 , a34 out nocopy JTF_VARCHAR2_TABLE_100
311 , a35 out nocopy JTF_NUMBER_TABLE
312 , a36 out nocopy JTF_NUMBER_TABLE
313 , a37 out nocopy JTF_NUMBER_TABLE
314 , a38 out nocopy JTF_VARCHAR2_TABLE_100
315 , a39 out nocopy JTF_VARCHAR2_TABLE_100
316 , a40 out nocopy JTF_VARCHAR2_TABLE_100
317 , a41 out nocopy JTF_VARCHAR2_TABLE_100
318 , a42 out nocopy JTF_NUMBER_TABLE
319 , a43 out nocopy JTF_NUMBER_TABLE
323 , a47 out nocopy JTF_NUMBER_TABLE
320 , a44 out nocopy JTF_DATE_TABLE
321 , a45 out nocopy JTF_VARCHAR2_TABLE_100
322 , a46 out nocopy JTF_NUMBER_TABLE
324 , a48 out nocopy JTF_NUMBER_TABLE
325 , a49 out nocopy JTF_NUMBER_TABLE
326 , a50 out nocopy JTF_VARCHAR2_TABLE_100
327 , a51 out nocopy JTF_VARCHAR2_TABLE_200
328 , a52 out nocopy JTF_VARCHAR2_TABLE_200
329 , a53 out nocopy JTF_VARCHAR2_TABLE_200
330 , a54 out nocopy JTF_VARCHAR2_TABLE_200
331 , a55 out nocopy JTF_VARCHAR2_TABLE_200
332 , a56 out nocopy JTF_VARCHAR2_TABLE_200
333 , a57 out nocopy JTF_VARCHAR2_TABLE_200
334 , a58 out nocopy JTF_VARCHAR2_TABLE_200
335 , a59 out nocopy JTF_VARCHAR2_TABLE_200
336 , a60 out nocopy JTF_VARCHAR2_TABLE_200
337 , a61 out nocopy JTF_VARCHAR2_TABLE_200
338 , a62 out nocopy JTF_VARCHAR2_TABLE_200
339 , a63 out nocopy JTF_VARCHAR2_TABLE_200
340 , a64 out nocopy JTF_VARCHAR2_TABLE_200
341 , a65 out nocopy JTF_VARCHAR2_TABLE_200
342 , a66 out nocopy JTF_NUMBER_TABLE
343 , a67 out nocopy JTF_NUMBER_TABLE
344 , a68 out nocopy JTF_NUMBER_TABLE
345 );
346
347 procedure rosetta_table_copy_in_p9(t out nocopy as_opportunity_pub.line_out_tbl_type, a0 JTF_NUMBER_TABLE
348 , a1 JTF_VARCHAR2_TABLE_100
349 );
350 procedure rosetta_table_copy_out_p9(t as_opportunity_pub.line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
351 , a1 out nocopy JTF_VARCHAR2_TABLE_100
352 );
353
354 procedure rosetta_table_copy_in_p12(t out nocopy as_opportunity_pub.sales_credit_tbl_type, a0 JTF_DATE_TABLE
355 , a1 JTF_NUMBER_TABLE
356 , a2 JTF_DATE_TABLE
357 , a3 JTF_NUMBER_TABLE
358 , a4 JTF_NUMBER_TABLE
359 , a5 JTF_NUMBER_TABLE
360 , a6 JTF_NUMBER_TABLE
361 , a7 JTF_NUMBER_TABLE
362 , a8 JTF_DATE_TABLE
363 , a9 JTF_NUMBER_TABLE
364 , a10 JTF_NUMBER_TABLE
365 , a11 JTF_NUMBER_TABLE
366 , a12 JTF_NUMBER_TABLE
367 , a13 JTF_NUMBER_TABLE
368 , a14 JTF_NUMBER_TABLE
369 , a15 JTF_VARCHAR2_TABLE_100
370 , a16 JTF_VARCHAR2_TABLE_100
371 , a17 JTF_NUMBER_TABLE
372 , a18 JTF_VARCHAR2_TABLE_100
373 , a19 JTF_NUMBER_TABLE
374 , a20 JTF_VARCHAR2_TABLE_400
375 , a21 JTF_VARCHAR2_TABLE_100
376 , a22 JTF_NUMBER_TABLE
377 , a23 JTF_NUMBER_TABLE
378 , a24 JTF_NUMBER_TABLE
379 , a25 JTF_NUMBER_TABLE
380 , a26 JTF_NUMBER_TABLE
381 , a27 JTF_NUMBER_TABLE
382 , a28 JTF_NUMBER_TABLE
383 , a29 JTF_VARCHAR2_TABLE_100
384 , a30 JTF_VARCHAR2_TABLE_100
385 , a31 JTF_VARCHAR2_TABLE_100
386 , a32 JTF_DATE_TABLE
387 , a33 JTF_NUMBER_TABLE
388 , a34 JTF_VARCHAR2_TABLE_100
389 , a35 JTF_VARCHAR2_TABLE_100
390 , a36 JTF_NUMBER_TABLE
391 , a37 JTF_VARCHAR2_TABLE_100
392 , a38 JTF_NUMBER_TABLE
393 , a39 JTF_NUMBER_TABLE
394 , a40 JTF_NUMBER_TABLE
395 , a41 JTF_VARCHAR2_TABLE_100
396 , a42 JTF_VARCHAR2_TABLE_200
397 , a43 JTF_VARCHAR2_TABLE_200
398 , a44 JTF_VARCHAR2_TABLE_200
399 , a45 JTF_VARCHAR2_TABLE_200
400 , a46 JTF_VARCHAR2_TABLE_200
401 , a47 JTF_VARCHAR2_TABLE_200
402 , a48 JTF_VARCHAR2_TABLE_200
403 , a49 JTF_VARCHAR2_TABLE_200
404 , a50 JTF_VARCHAR2_TABLE_200
405 , a51 JTF_VARCHAR2_TABLE_200
406 , a52 JTF_VARCHAR2_TABLE_200
407 , a53 JTF_VARCHAR2_TABLE_200
408 , a54 JTF_VARCHAR2_TABLE_200
409 , a55 JTF_VARCHAR2_TABLE_200
410 , a56 JTF_VARCHAR2_TABLE_200
411 , a57 JTF_NUMBER_TABLE
412 , a58 JTF_NUMBER_TABLE
413 , a59 JTF_NUMBER_TABLE
414 , a60 JTF_VARCHAR2_TABLE_100
415 );
416 procedure rosetta_table_copy_out_p12(t as_opportunity_pub.sales_credit_tbl_type, a0 out nocopy JTF_DATE_TABLE
417 , a1 out nocopy JTF_NUMBER_TABLE
418 , a2 out nocopy JTF_DATE_TABLE
419 , a3 out nocopy JTF_NUMBER_TABLE
420 , a4 out nocopy JTF_NUMBER_TABLE
421 , a5 out nocopy JTF_NUMBER_TABLE
422 , a6 out nocopy JTF_NUMBER_TABLE
423 , a7 out nocopy JTF_NUMBER_TABLE
424 , a8 out nocopy JTF_DATE_TABLE
425 , a9 out nocopy JTF_NUMBER_TABLE
426 , a10 out nocopy JTF_NUMBER_TABLE
427 , a11 out nocopy JTF_NUMBER_TABLE
428 , a12 out nocopy JTF_NUMBER_TABLE
429 , a13 out nocopy JTF_NUMBER_TABLE
430 , a14 out nocopy JTF_NUMBER_TABLE
431 , a15 out nocopy JTF_VARCHAR2_TABLE_100
432 , a16 out nocopy JTF_VARCHAR2_TABLE_100
433 , a17 out nocopy JTF_NUMBER_TABLE
434 , a18 out nocopy JTF_VARCHAR2_TABLE_100
435 , a19 out nocopy JTF_NUMBER_TABLE
436 , a20 out nocopy JTF_VARCHAR2_TABLE_400
437 , a21 out nocopy JTF_VARCHAR2_TABLE_100
438 , a22 out nocopy JTF_NUMBER_TABLE
439 , a23 out nocopy JTF_NUMBER_TABLE
440 , a24 out nocopy JTF_NUMBER_TABLE
441 , a25 out nocopy JTF_NUMBER_TABLE
442 , a26 out nocopy JTF_NUMBER_TABLE
443 , a27 out nocopy JTF_NUMBER_TABLE
444 , a28 out nocopy JTF_NUMBER_TABLE
445 , a29 out nocopy JTF_VARCHAR2_TABLE_100
446 , a30 out nocopy JTF_VARCHAR2_TABLE_100
447 , a31 out nocopy JTF_VARCHAR2_TABLE_100
448 , a32 out nocopy JTF_DATE_TABLE
449 , a33 out nocopy JTF_NUMBER_TABLE
450 , a34 out nocopy JTF_VARCHAR2_TABLE_100
451 , a35 out nocopy JTF_VARCHAR2_TABLE_100
452 , a36 out nocopy JTF_NUMBER_TABLE
456 , a40 out nocopy JTF_NUMBER_TABLE
453 , a37 out nocopy JTF_VARCHAR2_TABLE_100
454 , a38 out nocopy JTF_NUMBER_TABLE
455 , a39 out nocopy JTF_NUMBER_TABLE
457 , a41 out nocopy JTF_VARCHAR2_TABLE_100
458 , a42 out nocopy JTF_VARCHAR2_TABLE_200
459 , a43 out nocopy JTF_VARCHAR2_TABLE_200
460 , a44 out nocopy JTF_VARCHAR2_TABLE_200
461 , a45 out nocopy JTF_VARCHAR2_TABLE_200
462 , a46 out nocopy JTF_VARCHAR2_TABLE_200
463 , a47 out nocopy JTF_VARCHAR2_TABLE_200
464 , a48 out nocopy JTF_VARCHAR2_TABLE_200
465 , a49 out nocopy JTF_VARCHAR2_TABLE_200
466 , a50 out nocopy JTF_VARCHAR2_TABLE_200
467 , a51 out nocopy JTF_VARCHAR2_TABLE_200
468 , a52 out nocopy JTF_VARCHAR2_TABLE_200
469 , a53 out nocopy JTF_VARCHAR2_TABLE_200
470 , a54 out nocopy JTF_VARCHAR2_TABLE_200
471 , a55 out nocopy JTF_VARCHAR2_TABLE_200
472 , a56 out nocopy JTF_VARCHAR2_TABLE_200
473 , a57 out nocopy JTF_NUMBER_TABLE
474 , a58 out nocopy JTF_NUMBER_TABLE
475 , a59 out nocopy JTF_NUMBER_TABLE
476 , a60 out nocopy JTF_VARCHAR2_TABLE_100
477 );
478
479 procedure rosetta_table_copy_in_p15(t out nocopy as_opportunity_pub.sales_credit_out_tbl_type, a0 JTF_NUMBER_TABLE
480 , a1 JTF_VARCHAR2_TABLE_100
481 );
482 procedure rosetta_table_copy_out_p15(t as_opportunity_pub.sales_credit_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
483 , a1 out nocopy JTF_VARCHAR2_TABLE_100
484 );
485
486 procedure rosetta_table_copy_in_p20(t out nocopy as_opportunity_pub.obstacle_tbl_type, a0 JTF_DATE_TABLE
487 , a1 JTF_NUMBER_TABLE
488 , a2 JTF_DATE_TABLE
489 , a3 JTF_NUMBER_TABLE
490 , a4 JTF_NUMBER_TABLE
491 , a5 JTF_NUMBER_TABLE
492 , a6 JTF_NUMBER_TABLE
493 , a7 JTF_NUMBER_TABLE
494 , a8 JTF_DATE_TABLE
495 , a9 JTF_NUMBER_TABLE
496 , a10 JTF_NUMBER_TABLE
497 , a11 JTF_VARCHAR2_TABLE_100
498 , a12 JTF_VARCHAR2_TABLE_100
499 , a13 JTF_VARCHAR2_TABLE_100
500 , a14 JTF_VARCHAR2_TABLE_300
501 , a15 JTF_VARCHAR2_TABLE_100
502 , a16 JTF_VARCHAR2_TABLE_100
503 , a17 JTF_NUMBER_TABLE
504 , a18 JTF_VARCHAR2_TABLE_100
505 , a19 JTF_VARCHAR2_TABLE_200
506 , a20 JTF_VARCHAR2_TABLE_200
507 , a21 JTF_VARCHAR2_TABLE_200
508 , a22 JTF_VARCHAR2_TABLE_200
509 , a23 JTF_VARCHAR2_TABLE_200
510 , a24 JTF_VARCHAR2_TABLE_200
511 , a25 JTF_VARCHAR2_TABLE_200
512 , a26 JTF_VARCHAR2_TABLE_200
513 , a27 JTF_VARCHAR2_TABLE_200
514 , a28 JTF_VARCHAR2_TABLE_200
515 , a29 JTF_VARCHAR2_TABLE_200
516 , a30 JTF_VARCHAR2_TABLE_200
517 , a31 JTF_VARCHAR2_TABLE_200
518 , a32 JTF_VARCHAR2_TABLE_200
519 , a33 JTF_VARCHAR2_TABLE_200
520 );
521 procedure rosetta_table_copy_out_p20(t as_opportunity_pub.obstacle_tbl_type, a0 out nocopy JTF_DATE_TABLE
522 , a1 out nocopy JTF_NUMBER_TABLE
523 , a2 out nocopy JTF_DATE_TABLE
524 , a3 out nocopy JTF_NUMBER_TABLE
525 , a4 out nocopy JTF_NUMBER_TABLE
526 , a5 out nocopy JTF_NUMBER_TABLE
527 , a6 out nocopy JTF_NUMBER_TABLE
528 , a7 out nocopy JTF_NUMBER_TABLE
529 , a8 out nocopy JTF_DATE_TABLE
530 , a9 out nocopy JTF_NUMBER_TABLE
531 , a10 out nocopy JTF_NUMBER_TABLE
532 , a11 out nocopy JTF_VARCHAR2_TABLE_100
533 , a12 out nocopy JTF_VARCHAR2_TABLE_100
534 , a13 out nocopy JTF_VARCHAR2_TABLE_100
535 , a14 out nocopy JTF_VARCHAR2_TABLE_300
536 , a15 out nocopy JTF_VARCHAR2_TABLE_100
537 , a16 out nocopy JTF_VARCHAR2_TABLE_100
538 , a17 out nocopy JTF_NUMBER_TABLE
539 , a18 out nocopy JTF_VARCHAR2_TABLE_100
540 , a19 out nocopy JTF_VARCHAR2_TABLE_200
541 , a20 out nocopy JTF_VARCHAR2_TABLE_200
542 , a21 out nocopy JTF_VARCHAR2_TABLE_200
543 , a22 out nocopy JTF_VARCHAR2_TABLE_200
544 , a23 out nocopy JTF_VARCHAR2_TABLE_200
545 , a24 out nocopy JTF_VARCHAR2_TABLE_200
546 , a25 out nocopy JTF_VARCHAR2_TABLE_200
547 , a26 out nocopy JTF_VARCHAR2_TABLE_200
548 , a27 out nocopy JTF_VARCHAR2_TABLE_200
549 , a28 out nocopy JTF_VARCHAR2_TABLE_200
550 , a29 out nocopy JTF_VARCHAR2_TABLE_200
551 , a30 out nocopy JTF_VARCHAR2_TABLE_200
552 , a31 out nocopy JTF_VARCHAR2_TABLE_200
553 , a32 out nocopy JTF_VARCHAR2_TABLE_200
554 , a33 out nocopy JTF_VARCHAR2_TABLE_200
555 );
556
557 procedure rosetta_table_copy_in_p23(t out nocopy as_opportunity_pub.obstacle_out_tbl_type, a0 JTF_NUMBER_TABLE
558 , a1 JTF_VARCHAR2_TABLE_100
559 );
560 procedure rosetta_table_copy_out_p23(t as_opportunity_pub.obstacle_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
561 , a1 out nocopy JTF_VARCHAR2_TABLE_100
562 );
563
564 procedure rosetta_table_copy_in_p26(t out nocopy as_opportunity_pub.competitor_tbl_type, a0 JTF_DATE_TABLE
565 , a1 JTF_NUMBER_TABLE
566 , a2 JTF_DATE_TABLE
567 , a3 JTF_NUMBER_TABLE
568 , a4 JTF_NUMBER_TABLE
569 , a5 JTF_NUMBER_TABLE
570 , a6 JTF_NUMBER_TABLE
571 , a7 JTF_NUMBER_TABLE
572 , a8 JTF_DATE_TABLE
573 , a9 JTF_NUMBER_TABLE
574 , a10 JTF_VARCHAR2_TABLE_100
575 , a11 JTF_NUMBER_TABLE
576 , a12 JTF_NUMBER_TABLE
577 , a13 JTF_NUMBER_TABLE
578 , a14 JTF_VARCHAR2_TABLE_100
579 , a15 JTF_VARCHAR2_TABLE_300
580 , a16 JTF_NUMBER_TABLE
584 , a20 JTF_VARCHAR2_TABLE_100
581 , a17 JTF_VARCHAR2_TABLE_100
582 , a18 JTF_VARCHAR2_TABLE_100
583 , a19 JTF_VARCHAR2_TABLE_300
585 , a21 JTF_VARCHAR2_TABLE_100
586 , a22 JTF_NUMBER_TABLE
587 , a23 JTF_VARCHAR2_TABLE_100
588 , a24 JTF_VARCHAR2_TABLE_200
589 , a25 JTF_VARCHAR2_TABLE_200
590 , a26 JTF_VARCHAR2_TABLE_200
591 , a27 JTF_VARCHAR2_TABLE_200
592 , a28 JTF_VARCHAR2_TABLE_200
593 , a29 JTF_VARCHAR2_TABLE_200
594 , a30 JTF_VARCHAR2_TABLE_200
595 , a31 JTF_VARCHAR2_TABLE_200
596 , a32 JTF_VARCHAR2_TABLE_200
597 , a33 JTF_VARCHAR2_TABLE_200
598 , a34 JTF_VARCHAR2_TABLE_200
599 , a35 JTF_VARCHAR2_TABLE_200
600 , a36 JTF_VARCHAR2_TABLE_200
601 , a37 JTF_VARCHAR2_TABLE_200
602 , a38 JTF_VARCHAR2_TABLE_200
603 );
604 procedure rosetta_table_copy_out_p26(t as_opportunity_pub.competitor_tbl_type, a0 out nocopy JTF_DATE_TABLE
605 , a1 out nocopy JTF_NUMBER_TABLE
606 , a2 out nocopy JTF_DATE_TABLE
607 , a3 out nocopy JTF_NUMBER_TABLE
608 , a4 out nocopy JTF_NUMBER_TABLE
609 , a5 out nocopy JTF_NUMBER_TABLE
610 , a6 out nocopy JTF_NUMBER_TABLE
611 , a7 out nocopy JTF_NUMBER_TABLE
612 , a8 out nocopy JTF_DATE_TABLE
613 , a9 out nocopy JTF_NUMBER_TABLE
614 , a10 out nocopy JTF_VARCHAR2_TABLE_100
615 , a11 out nocopy JTF_NUMBER_TABLE
616 , a12 out nocopy JTF_NUMBER_TABLE
617 , a13 out nocopy JTF_NUMBER_TABLE
618 , a14 out nocopy JTF_VARCHAR2_TABLE_100
619 , a15 out nocopy JTF_VARCHAR2_TABLE_300
620 , a16 out nocopy JTF_NUMBER_TABLE
621 , a17 out nocopy JTF_VARCHAR2_TABLE_100
622 , a18 out nocopy JTF_VARCHAR2_TABLE_100
623 , a19 out nocopy JTF_VARCHAR2_TABLE_300
624 , a20 out nocopy JTF_VARCHAR2_TABLE_100
625 , a21 out nocopy JTF_VARCHAR2_TABLE_100
626 , a22 out nocopy JTF_NUMBER_TABLE
627 , a23 out nocopy JTF_VARCHAR2_TABLE_100
628 , a24 out nocopy JTF_VARCHAR2_TABLE_200
629 , a25 out nocopy JTF_VARCHAR2_TABLE_200
630 , a26 out nocopy JTF_VARCHAR2_TABLE_200
631 , a27 out nocopy JTF_VARCHAR2_TABLE_200
632 , a28 out nocopy JTF_VARCHAR2_TABLE_200
633 , a29 out nocopy JTF_VARCHAR2_TABLE_200
634 , a30 out nocopy JTF_VARCHAR2_TABLE_200
635 , a31 out nocopy JTF_VARCHAR2_TABLE_200
636 , a32 out nocopy JTF_VARCHAR2_TABLE_200
637 , a33 out nocopy JTF_VARCHAR2_TABLE_200
638 , a34 out nocopy JTF_VARCHAR2_TABLE_200
639 , a35 out nocopy JTF_VARCHAR2_TABLE_200
640 , a36 out nocopy JTF_VARCHAR2_TABLE_200
641 , a37 out nocopy JTF_VARCHAR2_TABLE_200
642 , a38 out nocopy JTF_VARCHAR2_TABLE_200
643 );
644
645 procedure rosetta_table_copy_in_p29(t out nocopy as_opportunity_pub.competitor_out_tbl_type, a0 JTF_NUMBER_TABLE
646 , a1 JTF_VARCHAR2_TABLE_100
647 );
648 procedure rosetta_table_copy_out_p29(t as_opportunity_pub.competitor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
649 , a1 out nocopy JTF_VARCHAR2_TABLE_100
650 );
651
652 procedure rosetta_table_copy_in_p32(t out nocopy as_opportunity_pub.order_tbl_type, a0 JTF_DATE_TABLE
653 , a1 JTF_NUMBER_TABLE
654 , a2 JTF_DATE_TABLE
655 , a3 JTF_NUMBER_TABLE
656 , a4 JTF_NUMBER_TABLE
657 , a5 JTF_NUMBER_TABLE
658 , a6 JTF_NUMBER_TABLE
659 , a7 JTF_NUMBER_TABLE
660 , a8 JTF_DATE_TABLE
661 , a9 JTF_NUMBER_TABLE
662 , a10 JTF_NUMBER_TABLE
663 , a11 JTF_NUMBER_TABLE
664 , a12 JTF_NUMBER_TABLE
665 , a13 JTF_DATE_TABLE
666 , a14 JTF_NUMBER_TABLE
667 , a15 JTF_VARCHAR2_TABLE_100
668 , a16 JTF_VARCHAR2_TABLE_100
669 , a17 JTF_NUMBER_TABLE
670 , a18 JTF_VARCHAR2_TABLE_100
671 , a19 JTF_VARCHAR2_TABLE_100
672 , a20 JTF_NUMBER_TABLE
673 , a21 JTF_VARCHAR2_TABLE_100
674 , a22 JTF_VARCHAR2_TABLE_200
675 , a23 JTF_VARCHAR2_TABLE_200
676 , a24 JTF_VARCHAR2_TABLE_200
677 , a25 JTF_VARCHAR2_TABLE_200
678 , a26 JTF_VARCHAR2_TABLE_200
679 , a27 JTF_VARCHAR2_TABLE_200
680 , a28 JTF_VARCHAR2_TABLE_200
681 , a29 JTF_VARCHAR2_TABLE_200
682 , a30 JTF_VARCHAR2_TABLE_200
683 , a31 JTF_VARCHAR2_TABLE_200
684 , a32 JTF_VARCHAR2_TABLE_200
685 , a33 JTF_VARCHAR2_TABLE_200
686 , a34 JTF_VARCHAR2_TABLE_200
687 , a35 JTF_VARCHAR2_TABLE_200
688 , a36 JTF_VARCHAR2_TABLE_200
689 );
690 procedure rosetta_table_copy_out_p32(t as_opportunity_pub.order_tbl_type, a0 out nocopy JTF_DATE_TABLE
691 , a1 out nocopy JTF_NUMBER_TABLE
692 , a2 out nocopy JTF_DATE_TABLE
693 , a3 out nocopy JTF_NUMBER_TABLE
694 , a4 out nocopy JTF_NUMBER_TABLE
695 , a5 out nocopy JTF_NUMBER_TABLE
696 , a6 out nocopy JTF_NUMBER_TABLE
697 , a7 out nocopy JTF_NUMBER_TABLE
698 , a8 out nocopy JTF_DATE_TABLE
699 , a9 out nocopy JTF_NUMBER_TABLE
700 , a10 out nocopy JTF_NUMBER_TABLE
701 , a11 out nocopy JTF_NUMBER_TABLE
702 , a12 out nocopy JTF_NUMBER_TABLE
703 , a13 out nocopy JTF_DATE_TABLE
704 , a14 out nocopy JTF_NUMBER_TABLE
705 , a15 out nocopy JTF_VARCHAR2_TABLE_100
706 , a16 out nocopy JTF_VARCHAR2_TABLE_100
707 , a17 out nocopy JTF_NUMBER_TABLE
708 , a18 out nocopy JTF_VARCHAR2_TABLE_100
709 , a19 out nocopy JTF_VARCHAR2_TABLE_100
710 , a20 out nocopy JTF_NUMBER_TABLE
714 , a24 out nocopy JTF_VARCHAR2_TABLE_200
711 , a21 out nocopy JTF_VARCHAR2_TABLE_100
712 , a22 out nocopy JTF_VARCHAR2_TABLE_200
713 , a23 out nocopy JTF_VARCHAR2_TABLE_200
715 , a25 out nocopy JTF_VARCHAR2_TABLE_200
716 , a26 out nocopy JTF_VARCHAR2_TABLE_200
717 , a27 out nocopy JTF_VARCHAR2_TABLE_200
718 , a28 out nocopy JTF_VARCHAR2_TABLE_200
719 , a29 out nocopy JTF_VARCHAR2_TABLE_200
720 , a30 out nocopy JTF_VARCHAR2_TABLE_200
721 , a31 out nocopy JTF_VARCHAR2_TABLE_200
722 , a32 out nocopy JTF_VARCHAR2_TABLE_200
723 , a33 out nocopy JTF_VARCHAR2_TABLE_200
724 , a34 out nocopy JTF_VARCHAR2_TABLE_200
725 , a35 out nocopy JTF_VARCHAR2_TABLE_200
726 , a36 out nocopy JTF_VARCHAR2_TABLE_200
727 );
728
729 procedure rosetta_table_copy_in_p35(t out nocopy as_opportunity_pub.order_out_tbl_type, a0 JTF_NUMBER_TABLE
730 , a1 JTF_VARCHAR2_TABLE_100
731 );
732 procedure rosetta_table_copy_out_p35(t as_opportunity_pub.order_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
733 , a1 out nocopy JTF_VARCHAR2_TABLE_100
734 );
735
736 procedure rosetta_table_copy_in_p38(t out nocopy as_opportunity_pub.contact_tbl_type, a0 JTF_DATE_TABLE
737 , a1 JTF_NUMBER_TABLE
738 , a2 JTF_DATE_TABLE
739 , a3 JTF_NUMBER_TABLE
740 , a4 JTF_NUMBER_TABLE
741 , a5 JTF_NUMBER_TABLE
742 , a6 JTF_NUMBER_TABLE
743 , a7 JTF_NUMBER_TABLE
744 , a8 JTF_DATE_TABLE
745 , a9 JTF_NUMBER_TABLE
746 , a10 JTF_NUMBER_TABLE
747 , a11 JTF_NUMBER_TABLE
748 , a12 JTF_NUMBER_TABLE
749 , a13 JTF_NUMBER_TABLE
750 , a14 JTF_VARCHAR2_TABLE_100
751 , a15 JTF_VARCHAR2_TABLE_100
752 , a16 JTF_VARCHAR2_TABLE_100
753 , a17 JTF_VARCHAR2_TABLE_300
754 , a18 JTF_NUMBER_TABLE
755 , a19 JTF_VARCHAR2_TABLE_100
756 , a20 JTF_VARCHAR2_TABLE_100
757 , a21 JTF_VARCHAR2_TABLE_100
758 , a22 JTF_VARCHAR2_TABLE_100
759 , a23 JTF_VARCHAR2_TABLE_100
760 , a24 JTF_NUMBER_TABLE
761 , a25 JTF_VARCHAR2_TABLE_100
762 , a26 JTF_VARCHAR2_TABLE_100
763 , a27 JTF_NUMBER_TABLE
764 , a28 JTF_VARCHAR2_TABLE_100
765 , a29 JTF_VARCHAR2_TABLE_200
766 , a30 JTF_VARCHAR2_TABLE_200
767 , a31 JTF_VARCHAR2_TABLE_200
768 , a32 JTF_VARCHAR2_TABLE_200
769 , a33 JTF_VARCHAR2_TABLE_200
770 , a34 JTF_VARCHAR2_TABLE_200
771 , a35 JTF_VARCHAR2_TABLE_200
772 , a36 JTF_VARCHAR2_TABLE_200
773 , a37 JTF_VARCHAR2_TABLE_200
774 , a38 JTF_VARCHAR2_TABLE_200
775 , a39 JTF_VARCHAR2_TABLE_200
776 , a40 JTF_VARCHAR2_TABLE_200
777 , a41 JTF_VARCHAR2_TABLE_200
778 , a42 JTF_VARCHAR2_TABLE_200
779 , a43 JTF_VARCHAR2_TABLE_200
780 );
781 procedure rosetta_table_copy_out_p38(t as_opportunity_pub.contact_tbl_type, a0 out nocopy JTF_DATE_TABLE
782 , a1 out nocopy JTF_NUMBER_TABLE
783 , a2 out nocopy JTF_DATE_TABLE
784 , a3 out nocopy JTF_NUMBER_TABLE
785 , a4 out nocopy JTF_NUMBER_TABLE
786 , a5 out nocopy JTF_NUMBER_TABLE
787 , a6 out nocopy JTF_NUMBER_TABLE
788 , a7 out nocopy JTF_NUMBER_TABLE
789 , a8 out nocopy JTF_DATE_TABLE
790 , a9 out nocopy JTF_NUMBER_TABLE
791 , a10 out nocopy JTF_NUMBER_TABLE
792 , a11 out nocopy JTF_NUMBER_TABLE
793 , a12 out nocopy JTF_NUMBER_TABLE
794 , a13 out nocopy JTF_NUMBER_TABLE
795 , a14 out nocopy JTF_VARCHAR2_TABLE_100
796 , a15 out nocopy JTF_VARCHAR2_TABLE_100
797 , a16 out nocopy JTF_VARCHAR2_TABLE_100
798 , a17 out nocopy JTF_VARCHAR2_TABLE_300
799 , a18 out nocopy JTF_NUMBER_TABLE
800 , a19 out nocopy JTF_VARCHAR2_TABLE_100
801 , a20 out nocopy JTF_VARCHAR2_TABLE_100
802 , a21 out nocopy JTF_VARCHAR2_TABLE_100
803 , a22 out nocopy JTF_VARCHAR2_TABLE_100
804 , a23 out nocopy JTF_VARCHAR2_TABLE_100
805 , a24 out nocopy JTF_NUMBER_TABLE
806 , a25 out nocopy JTF_VARCHAR2_TABLE_100
807 , a26 out nocopy JTF_VARCHAR2_TABLE_100
808 , a27 out nocopy JTF_NUMBER_TABLE
809 , a28 out nocopy JTF_VARCHAR2_TABLE_100
810 , a29 out nocopy JTF_VARCHAR2_TABLE_200
811 , a30 out nocopy JTF_VARCHAR2_TABLE_200
812 , a31 out nocopy JTF_VARCHAR2_TABLE_200
813 , a32 out nocopy JTF_VARCHAR2_TABLE_200
814 , a33 out nocopy JTF_VARCHAR2_TABLE_200
815 , a34 out nocopy JTF_VARCHAR2_TABLE_200
816 , a35 out nocopy JTF_VARCHAR2_TABLE_200
817 , a36 out nocopy JTF_VARCHAR2_TABLE_200
818 , a37 out nocopy JTF_VARCHAR2_TABLE_200
819 , a38 out nocopy JTF_VARCHAR2_TABLE_200
820 , a39 out nocopy JTF_VARCHAR2_TABLE_200
821 , a40 out nocopy JTF_VARCHAR2_TABLE_200
822 , a41 out nocopy JTF_VARCHAR2_TABLE_200
823 , a42 out nocopy JTF_VARCHAR2_TABLE_200
824 , a43 out nocopy JTF_VARCHAR2_TABLE_200
825 );
826
827 procedure rosetta_table_copy_in_p41(t out nocopy as_opportunity_pub.contact_out_tbl_type, a0 JTF_NUMBER_TABLE
828 , a1 JTF_VARCHAR2_TABLE_100
829 );
830 procedure rosetta_table_copy_out_p41(t as_opportunity_pub.contact_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
831 , a1 out nocopy JTF_VARCHAR2_TABLE_100
832 );
833
834 procedure rosetta_table_copy_in_p44(t out nocopy as_opportunity_pub.competitor_prod_tbl_type, a0 JTF_VARCHAR2_TABLE_200
835 , a1 JTF_VARCHAR2_TABLE_200
836 , a2 JTF_VARCHAR2_TABLE_200
837 , a3 JTF_VARCHAR2_TABLE_200
841 , a7 JTF_VARCHAR2_TABLE_200
838 , a4 JTF_VARCHAR2_TABLE_200
839 , a5 JTF_VARCHAR2_TABLE_200
840 , a6 JTF_VARCHAR2_TABLE_200
842 , a8 JTF_VARCHAR2_TABLE_200
843 , a9 JTF_VARCHAR2_TABLE_200
844 , a10 JTF_VARCHAR2_TABLE_200
845 , a11 JTF_VARCHAR2_TABLE_200
846 , a12 JTF_VARCHAR2_TABLE_200
847 , a13 JTF_VARCHAR2_TABLE_200
848 , a14 JTF_VARCHAR2_TABLE_200
849 , a15 JTF_VARCHAR2_TABLE_100
850 , a16 JTF_NUMBER_TABLE
851 , a17 JTF_DATE_TABLE
852 , a18 JTF_NUMBER_TABLE
853 , a19 JTF_NUMBER_TABLE
854 , a20 JTF_VARCHAR2_TABLE_100
855 , a21 JTF_NUMBER_TABLE
856 , a22 JTF_NUMBER_TABLE
857 , a23 JTF_NUMBER_TABLE
858 , a24 JTF_NUMBER_TABLE
859 , a25 JTF_NUMBER_TABLE
860 , a26 JTF_NUMBER_TABLE
861 , a27 JTF_DATE_TABLE
862 , a28 JTF_NUMBER_TABLE
863 , a29 JTF_DATE_TABLE
864 );
865 procedure rosetta_table_copy_out_p44(t as_opportunity_pub.competitor_prod_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
866 , a1 out nocopy JTF_VARCHAR2_TABLE_200
867 , a2 out nocopy JTF_VARCHAR2_TABLE_200
868 , a3 out nocopy JTF_VARCHAR2_TABLE_200
869 , a4 out nocopy JTF_VARCHAR2_TABLE_200
870 , a5 out nocopy JTF_VARCHAR2_TABLE_200
871 , a6 out nocopy JTF_VARCHAR2_TABLE_200
872 , a7 out nocopy JTF_VARCHAR2_TABLE_200
873 , a8 out nocopy JTF_VARCHAR2_TABLE_200
874 , a9 out nocopy JTF_VARCHAR2_TABLE_200
875 , a10 out nocopy JTF_VARCHAR2_TABLE_200
876 , a11 out nocopy JTF_VARCHAR2_TABLE_200
877 , a12 out nocopy JTF_VARCHAR2_TABLE_200
878 , a13 out nocopy JTF_VARCHAR2_TABLE_200
879 , a14 out nocopy JTF_VARCHAR2_TABLE_200
880 , a15 out nocopy JTF_VARCHAR2_TABLE_100
881 , a16 out nocopy JTF_NUMBER_TABLE
882 , a17 out nocopy JTF_DATE_TABLE
883 , a18 out nocopy JTF_NUMBER_TABLE
884 , a19 out nocopy JTF_NUMBER_TABLE
885 , a20 out nocopy JTF_VARCHAR2_TABLE_100
886 , a21 out nocopy JTF_NUMBER_TABLE
887 , a22 out nocopy JTF_NUMBER_TABLE
888 , a23 out nocopy JTF_NUMBER_TABLE
889 , a24 out nocopy JTF_NUMBER_TABLE
890 , a25 out nocopy JTF_NUMBER_TABLE
891 , a26 out nocopy JTF_NUMBER_TABLE
892 , a27 out nocopy JTF_DATE_TABLE
893 , a28 out nocopy JTF_NUMBER_TABLE
894 , a29 out nocopy JTF_DATE_TABLE
895 );
896
897 procedure rosetta_table_copy_in_p47(t out nocopy as_opportunity_pub.competitor_prod_out_tbl_type, a0 JTF_NUMBER_TABLE
898 , a1 JTF_VARCHAR2_TABLE_100
899 );
900 procedure rosetta_table_copy_out_p47(t as_opportunity_pub.competitor_prod_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
901 , a1 out nocopy JTF_VARCHAR2_TABLE_100
902 );
903
904 procedure rosetta_table_copy_in_p50(t out nocopy as_opportunity_pub.decision_factor_tbl_type, a0 JTF_VARCHAR2_TABLE_200
905 , a1 JTF_VARCHAR2_TABLE_200
906 , a2 JTF_VARCHAR2_TABLE_200
907 , a3 JTF_VARCHAR2_TABLE_200
908 , a4 JTF_VARCHAR2_TABLE_200
909 , a5 JTF_VARCHAR2_TABLE_200
910 , a6 JTF_VARCHAR2_TABLE_200
911 , a7 JTF_VARCHAR2_TABLE_200
912 , a8 JTF_VARCHAR2_TABLE_200
913 , a9 JTF_VARCHAR2_TABLE_200
914 , a10 JTF_VARCHAR2_TABLE_200
915 , a11 JTF_VARCHAR2_TABLE_200
916 , a12 JTF_VARCHAR2_TABLE_200
917 , a13 JTF_VARCHAR2_TABLE_200
918 , a14 JTF_VARCHAR2_TABLE_200
919 , a15 JTF_VARCHAR2_TABLE_100
920 , a16 JTF_DATE_TABLE
921 , a17 JTF_NUMBER_TABLE
922 , a18 JTF_NUMBER_TABLE
923 , a19 JTF_NUMBER_TABLE
924 , a20 JTF_NUMBER_TABLE
925 , a21 JTF_VARCHAR2_TABLE_300
926 , a22 JTF_VARCHAR2_TABLE_100
927 , a23 JTF_NUMBER_TABLE
928 , a24 JTF_NUMBER_TABLE
929 , a25 JTF_NUMBER_TABLE
930 , a26 JTF_NUMBER_TABLE
931 , a27 JTF_DATE_TABLE
932 , a28 JTF_NUMBER_TABLE
933 , a29 JTF_DATE_TABLE
934 );
935 procedure rosetta_table_copy_out_p50(t as_opportunity_pub.decision_factor_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
936 , a1 out nocopy JTF_VARCHAR2_TABLE_200
937 , a2 out nocopy JTF_VARCHAR2_TABLE_200
938 , a3 out nocopy JTF_VARCHAR2_TABLE_200
939 , a4 out nocopy JTF_VARCHAR2_TABLE_200
940 , a5 out nocopy JTF_VARCHAR2_TABLE_200
941 , a6 out nocopy JTF_VARCHAR2_TABLE_200
942 , a7 out nocopy JTF_VARCHAR2_TABLE_200
943 , a8 out nocopy JTF_VARCHAR2_TABLE_200
944 , a9 out nocopy JTF_VARCHAR2_TABLE_200
945 , a10 out nocopy JTF_VARCHAR2_TABLE_200
946 , a11 out nocopy JTF_VARCHAR2_TABLE_200
947 , a12 out nocopy JTF_VARCHAR2_TABLE_200
948 , a13 out nocopy JTF_VARCHAR2_TABLE_200
949 , a14 out nocopy JTF_VARCHAR2_TABLE_200
950 , a15 out nocopy JTF_VARCHAR2_TABLE_100
951 , a16 out nocopy JTF_DATE_TABLE
952 , a17 out nocopy JTF_NUMBER_TABLE
953 , a18 out nocopy JTF_NUMBER_TABLE
954 , a19 out nocopy JTF_NUMBER_TABLE
955 , a20 out nocopy JTF_NUMBER_TABLE
956 , a21 out nocopy JTF_VARCHAR2_TABLE_300
957 , a22 out nocopy JTF_VARCHAR2_TABLE_100
958 , a23 out nocopy JTF_NUMBER_TABLE
959 , a24 out nocopy JTF_NUMBER_TABLE
960 , a25 out nocopy JTF_NUMBER_TABLE
961 , a26 out nocopy JTF_NUMBER_TABLE
962 , a27 out nocopy JTF_DATE_TABLE
963 , a28 out nocopy JTF_NUMBER_TABLE
964 , a29 out nocopy JTF_DATE_TABLE
965 );
966
967 procedure rosetta_table_copy_in_p53(t out nocopy as_opportunity_pub.decision_factor_out_tbl_type, a0 JTF_NUMBER_TABLE
971 , a1 out nocopy JTF_VARCHAR2_TABLE_100
968 , a1 JTF_VARCHAR2_TABLE_100
969 );
970 procedure rosetta_table_copy_out_p53(t as_opportunity_pub.decision_factor_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972 );
973
974 procedure create_opp_header(p_api_version_number NUMBER
975 , p_init_msg_list VARCHAR2
976 , p_commit VARCHAR2
977 , p_validation_level NUMBER
978 , p_check_access_flag VARCHAR2
979 , p_admin_flag VARCHAR2
980 , p_admin_group_id NUMBER
981 , p_identity_salesforce_id NUMBER
982 , p_salesgroup_id NUMBER
983 , p_partner_cont_party_id NUMBER
984 , p11_a0 JTF_VARCHAR2_TABLE_100
985 , p11_a1 JTF_VARCHAR2_TABLE_300
986 , x_return_status out nocopy VARCHAR2
987 , x_msg_count out nocopy NUMBER
988 , x_msg_data out nocopy VARCHAR2
989 , x_lead_id out nocopy NUMBER
990 , p4_a0 DATE := fnd_api.g_miss_date
991 , p4_a1 NUMBER := 0-1962.0724
992 , p4_a2 DATE := fnd_api.g_miss_date
993 , p4_a3 NUMBER := 0-1962.0724
994 , p4_a4 NUMBER := 0-1962.0724
995 , p4_a5 NUMBER := 0-1962.0724
996 , p4_a6 NUMBER := 0-1962.0724
997 , p4_a7 NUMBER := 0-1962.0724
998 , p4_a8 DATE := fnd_api.g_miss_date
999 , p4_a9 NUMBER := 0-1962.0724
1000 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
1001 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
1002 , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1003 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1004 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1005 , p4_a15 NUMBER := 0-1962.0724
1006 , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1007 , p4_a17 NUMBER := 0-1962.0724
1008 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1009 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1010 , p4_a20 NUMBER := 0-1962.0724
1011 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1012 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1013 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1014 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1015 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1016 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1017 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1018 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
1019 , p4_a29 NUMBER := 0-1962.0724
1020 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
1021 , p4_a31 NUMBER := 0-1962.0724
1022 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
1023 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
1024 , p4_a34 NUMBER := 0-1962.0724
1025 , p4_a35 NUMBER := 0-1962.0724
1026 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
1027 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
1028 , p4_a38 DATE := fnd_api.g_miss_date
1029 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
1030 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
1031 , p4_a41 VARCHAR2 := fnd_api.g_miss_char
1032 , p4_a42 VARCHAR2 := fnd_api.g_miss_char
1033 , p4_a43 VARCHAR2 := fnd_api.g_miss_char
1034 , p4_a44 NUMBER := 0-1962.0724
1035 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
1036 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
1037 , p4_a47 NUMBER := 0-1962.0724
1038 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
1039 , p4_a49 NUMBER := 0-1962.0724
1040 , p4_a50 NUMBER := 0-1962.0724
1041 , p4_a51 NUMBER := 0-1962.0724
1042 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
1043 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
1044 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
1045 , p4_a55 NUMBER := 0-1962.0724
1046 , p4_a56 NUMBER := 0-1962.0724
1047 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
1048 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
1049 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
1050 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
1051 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
1052 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
1053 , p4_a63 NUMBER := 0-1962.0724
1054 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
1055 , p4_a65 NUMBER := 0-1962.0724
1056 , p4_a66 NUMBER := 0-1962.0724
1057 , p4_a67 VARCHAR2 := fnd_api.g_miss_char
1058 , p4_a68 NUMBER := 0-1962.0724
1059 , p4_a69 NUMBER := 0-1962.0724
1060 , p4_a70 NUMBER := 0-1962.0724
1061 , p4_a71 VARCHAR2 := fnd_api.g_miss_char
1062 , p4_a72 VARCHAR2 := fnd_api.g_miss_char
1063 , p4_a73 DATE := fnd_api.g_miss_date
1064 , p4_a74 VARCHAR2 := fnd_api.g_miss_char
1065 , p4_a75 VARCHAR2 := fnd_api.g_miss_char
1066 , p4_a76 VARCHAR2 := fnd_api.g_miss_char
1067 , p4_a77 VARCHAR2 := fnd_api.g_miss_char
1068 , p4_a78 VARCHAR2 := fnd_api.g_miss_char
1069 , p4_a79 VARCHAR2 := fnd_api.g_miss_char
1070 , p4_a80 NUMBER := 0-1962.0724
1071 , p4_a81 VARCHAR2 := fnd_api.g_miss_char
1072 , p4_a82 VARCHAR2 := fnd_api.g_miss_char
1073 , p4_a83 VARCHAR2 := fnd_api.g_miss_char
1074 , p4_a84 VARCHAR2 := fnd_api.g_miss_char
1075 , p4_a85 VARCHAR2 := fnd_api.g_miss_char
1076 , p4_a86 VARCHAR2 := fnd_api.g_miss_char
1077 , p4_a87 VARCHAR2 := fnd_api.g_miss_char
1078 , p4_a88 VARCHAR2 := fnd_api.g_miss_char
1079 , p4_a89 VARCHAR2 := fnd_api.g_miss_char
1080 , p4_a90 VARCHAR2 := fnd_api.g_miss_char
1081 , p4_a91 VARCHAR2 := fnd_api.g_miss_char
1082 , p4_a92 VARCHAR2 := fnd_api.g_miss_char
1083 , p4_a93 VARCHAR2 := fnd_api.g_miss_char
1084 , p4_a94 VARCHAR2 := fnd_api.g_miss_char
1085 , p4_a95 VARCHAR2 := fnd_api.g_miss_char
1086 , p4_a96 VARCHAR2 := fnd_api.g_miss_char
1087 , p4_a97 VARCHAR2 := fnd_api.g_miss_char
1091 procedure update_opp_header(p_api_version_number NUMBER
1088 , p4_a98 VARCHAR2 := fnd_api.g_miss_char
1089 , p4_a99 NUMBER := 0-1962.0724
1090 );
1092 , p_init_msg_list VARCHAR2
1093 , p_commit VARCHAR2
1094 , p_validation_level NUMBER
1095 , p_check_access_flag VARCHAR2
1096 , p_admin_flag VARCHAR2
1097 , p_admin_group_id NUMBER
1098 , p_identity_salesforce_id NUMBER
1099 , p_partner_cont_party_id NUMBER
1100 , p10_a0 JTF_VARCHAR2_TABLE_100
1101 , p10_a1 JTF_VARCHAR2_TABLE_300
1102 , x_return_status out nocopy VARCHAR2
1103 , x_msg_count out nocopy NUMBER
1104 , x_msg_data out nocopy VARCHAR2
1105 , x_lead_id out nocopy NUMBER
1106 , p4_a0 DATE := fnd_api.g_miss_date
1107 , p4_a1 NUMBER := 0-1962.0724
1108 , p4_a2 DATE := fnd_api.g_miss_date
1109 , p4_a3 NUMBER := 0-1962.0724
1110 , p4_a4 NUMBER := 0-1962.0724
1111 , p4_a5 NUMBER := 0-1962.0724
1112 , p4_a6 NUMBER := 0-1962.0724
1113 , p4_a7 NUMBER := 0-1962.0724
1114 , p4_a8 DATE := fnd_api.g_miss_date
1115 , p4_a9 NUMBER := 0-1962.0724
1116 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
1117 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
1118 , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1119 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1120 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1121 , p4_a15 NUMBER := 0-1962.0724
1122 , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1123 , p4_a17 NUMBER := 0-1962.0724
1124 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1125 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1126 , p4_a20 NUMBER := 0-1962.0724
1127 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1128 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1129 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1130 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1131 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1132 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1133 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1134 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
1135 , p4_a29 NUMBER := 0-1962.0724
1136 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
1137 , p4_a31 NUMBER := 0-1962.0724
1138 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
1139 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
1140 , p4_a34 NUMBER := 0-1962.0724
1141 , p4_a35 NUMBER := 0-1962.0724
1142 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
1143 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
1144 , p4_a38 DATE := fnd_api.g_miss_date
1145 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
1146 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
1147 , p4_a41 VARCHAR2 := fnd_api.g_miss_char
1148 , p4_a42 VARCHAR2 := fnd_api.g_miss_char
1149 , p4_a43 VARCHAR2 := fnd_api.g_miss_char
1150 , p4_a44 NUMBER := 0-1962.0724
1151 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
1152 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
1153 , p4_a47 NUMBER := 0-1962.0724
1154 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
1155 , p4_a49 NUMBER := 0-1962.0724
1156 , p4_a50 NUMBER := 0-1962.0724
1157 , p4_a51 NUMBER := 0-1962.0724
1158 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
1159 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
1160 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
1161 , p4_a55 NUMBER := 0-1962.0724
1162 , p4_a56 NUMBER := 0-1962.0724
1163 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
1164 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
1165 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
1166 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
1167 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
1168 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
1169 , p4_a63 NUMBER := 0-1962.0724
1170 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
1171 , p4_a65 NUMBER := 0-1962.0724
1172 , p4_a66 NUMBER := 0-1962.0724
1173 , p4_a67 VARCHAR2 := fnd_api.g_miss_char
1174 , p4_a68 NUMBER := 0-1962.0724
1175 , p4_a69 NUMBER := 0-1962.0724
1176 , p4_a70 NUMBER := 0-1962.0724
1177 , p4_a71 VARCHAR2 := fnd_api.g_miss_char
1178 , p4_a72 VARCHAR2 := fnd_api.g_miss_char
1179 , p4_a73 DATE := fnd_api.g_miss_date
1180 , p4_a74 VARCHAR2 := fnd_api.g_miss_char
1181 , p4_a75 VARCHAR2 := fnd_api.g_miss_char
1182 , p4_a76 VARCHAR2 := fnd_api.g_miss_char
1183 , p4_a77 VARCHAR2 := fnd_api.g_miss_char
1184 , p4_a78 VARCHAR2 := fnd_api.g_miss_char
1185 , p4_a79 VARCHAR2 := fnd_api.g_miss_char
1186 , p4_a80 NUMBER := 0-1962.0724
1187 , p4_a81 VARCHAR2 := fnd_api.g_miss_char
1188 , p4_a82 VARCHAR2 := fnd_api.g_miss_char
1189 , p4_a83 VARCHAR2 := fnd_api.g_miss_char
1190 , p4_a84 VARCHAR2 := fnd_api.g_miss_char
1191 , p4_a85 VARCHAR2 := fnd_api.g_miss_char
1192 , p4_a86 VARCHAR2 := fnd_api.g_miss_char
1193 , p4_a87 VARCHAR2 := fnd_api.g_miss_char
1194 , p4_a88 VARCHAR2 := fnd_api.g_miss_char
1195 , p4_a89 VARCHAR2 := fnd_api.g_miss_char
1196 , p4_a90 VARCHAR2 := fnd_api.g_miss_char
1197 , p4_a91 VARCHAR2 := fnd_api.g_miss_char
1198 , p4_a92 VARCHAR2 := fnd_api.g_miss_char
1199 , p4_a93 VARCHAR2 := fnd_api.g_miss_char
1200 , p4_a94 VARCHAR2 := fnd_api.g_miss_char
1201 , p4_a95 VARCHAR2 := fnd_api.g_miss_char
1202 , p4_a96 VARCHAR2 := fnd_api.g_miss_char
1203 , p4_a97 VARCHAR2 := fnd_api.g_miss_char
1204 , p4_a98 VARCHAR2 := fnd_api.g_miss_char
1205 , p4_a99 NUMBER := 0-1962.0724
1206 );
1207 procedure delete_opp_header(p_api_version_number NUMBER
1211 , p_check_access_flag VARCHAR2
1208 , p_init_msg_list VARCHAR2
1209 , p_commit VARCHAR2
1210 , p_validation_level NUMBER
1212 , p_admin_flag VARCHAR2
1213 , p_admin_group_id NUMBER
1214 , p_identity_salesforce_id NUMBER
1215 , p_partner_cont_party_id NUMBER
1216 , p10_a0 JTF_VARCHAR2_TABLE_100
1217 , p10_a1 JTF_VARCHAR2_TABLE_300
1218 , x_return_status out nocopy VARCHAR2
1219 , x_msg_count out nocopy NUMBER
1220 , x_msg_data out nocopy VARCHAR2
1221 , x_lead_id out nocopy NUMBER
1222 , p4_a0 DATE := fnd_api.g_miss_date
1223 , p4_a1 NUMBER := 0-1962.0724
1224 , p4_a2 DATE := fnd_api.g_miss_date
1225 , p4_a3 NUMBER := 0-1962.0724
1226 , p4_a4 NUMBER := 0-1962.0724
1227 , p4_a5 NUMBER := 0-1962.0724
1228 , p4_a6 NUMBER := 0-1962.0724
1229 , p4_a7 NUMBER := 0-1962.0724
1230 , p4_a8 DATE := fnd_api.g_miss_date
1231 , p4_a9 NUMBER := 0-1962.0724
1232 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
1233 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
1234 , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1235 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1236 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1237 , p4_a15 NUMBER := 0-1962.0724
1238 , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1239 , p4_a17 NUMBER := 0-1962.0724
1240 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1241 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1242 , p4_a20 NUMBER := 0-1962.0724
1243 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1244 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1245 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1246 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1247 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1248 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1249 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1250 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
1251 , p4_a29 NUMBER := 0-1962.0724
1252 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
1253 , p4_a31 NUMBER := 0-1962.0724
1254 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
1255 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
1256 , p4_a34 NUMBER := 0-1962.0724
1257 , p4_a35 NUMBER := 0-1962.0724
1258 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
1259 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
1260 , p4_a38 DATE := fnd_api.g_miss_date
1261 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
1262 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
1263 , p4_a41 VARCHAR2 := fnd_api.g_miss_char
1264 , p4_a42 VARCHAR2 := fnd_api.g_miss_char
1265 , p4_a43 VARCHAR2 := fnd_api.g_miss_char
1266 , p4_a44 NUMBER := 0-1962.0724
1267 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
1268 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
1269 , p4_a47 NUMBER := 0-1962.0724
1270 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
1271 , p4_a49 NUMBER := 0-1962.0724
1272 , p4_a50 NUMBER := 0-1962.0724
1273 , p4_a51 NUMBER := 0-1962.0724
1274 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
1275 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
1276 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
1277 , p4_a55 NUMBER := 0-1962.0724
1278 , p4_a56 NUMBER := 0-1962.0724
1279 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
1280 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
1281 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
1282 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
1283 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
1284 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
1285 , p4_a63 NUMBER := 0-1962.0724
1286 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
1287 , p4_a65 NUMBER := 0-1962.0724
1288 , p4_a66 NUMBER := 0-1962.0724
1289 , p4_a67 VARCHAR2 := fnd_api.g_miss_char
1290 , p4_a68 NUMBER := 0-1962.0724
1291 , p4_a69 NUMBER := 0-1962.0724
1292 , p4_a70 NUMBER := 0-1962.0724
1293 , p4_a71 VARCHAR2 := fnd_api.g_miss_char
1294 , p4_a72 VARCHAR2 := fnd_api.g_miss_char
1295 , p4_a73 DATE := fnd_api.g_miss_date
1296 , p4_a74 VARCHAR2 := fnd_api.g_miss_char
1297 , p4_a75 VARCHAR2 := fnd_api.g_miss_char
1298 , p4_a76 VARCHAR2 := fnd_api.g_miss_char
1299 , p4_a77 VARCHAR2 := fnd_api.g_miss_char
1300 , p4_a78 VARCHAR2 := fnd_api.g_miss_char
1301 , p4_a79 VARCHAR2 := fnd_api.g_miss_char
1302 , p4_a80 NUMBER := 0-1962.0724
1303 , p4_a81 VARCHAR2 := fnd_api.g_miss_char
1304 , p4_a82 VARCHAR2 := fnd_api.g_miss_char
1305 , p4_a83 VARCHAR2 := fnd_api.g_miss_char
1306 , p4_a84 VARCHAR2 := fnd_api.g_miss_char
1307 , p4_a85 VARCHAR2 := fnd_api.g_miss_char
1308 , p4_a86 VARCHAR2 := fnd_api.g_miss_char
1309 , p4_a87 VARCHAR2 := fnd_api.g_miss_char
1310 , p4_a88 VARCHAR2 := fnd_api.g_miss_char
1311 , p4_a89 VARCHAR2 := fnd_api.g_miss_char
1312 , p4_a90 VARCHAR2 := fnd_api.g_miss_char
1313 , p4_a91 VARCHAR2 := fnd_api.g_miss_char
1314 , p4_a92 VARCHAR2 := fnd_api.g_miss_char
1315 , p4_a93 VARCHAR2 := fnd_api.g_miss_char
1316 , p4_a94 VARCHAR2 := fnd_api.g_miss_char
1317 , p4_a95 VARCHAR2 := fnd_api.g_miss_char
1318 , p4_a96 VARCHAR2 := fnd_api.g_miss_char
1319 , p4_a97 VARCHAR2 := fnd_api.g_miss_char
1320 , p4_a98 VARCHAR2 := fnd_api.g_miss_char
1321 , p4_a99 NUMBER := 0-1962.0724
1322 );
1323 procedure create_opp_lines(p_api_version_number NUMBER
1324 , p_init_msg_list VARCHAR2
1325 , p_commit VARCHAR2
1326 , p_validation_level NUMBER
1327 , p4_a0 JTF_DATE_TABLE
1331 , p4_a4 JTF_NUMBER_TABLE
1328 , p4_a1 JTF_NUMBER_TABLE
1329 , p4_a2 JTF_DATE_TABLE
1330 , p4_a3 JTF_NUMBER_TABLE
1332 , p4_a5 JTF_NUMBER_TABLE
1333 , p4_a6 JTF_NUMBER_TABLE
1334 , p4_a7 JTF_NUMBER_TABLE
1335 , p4_a8 JTF_DATE_TABLE
1336 , p4_a9 JTF_NUMBER_TABLE
1337 , p4_a10 JTF_NUMBER_TABLE
1338 , p4_a11 JTF_NUMBER_TABLE
1339 , p4_a12 JTF_NUMBER_TABLE
1340 , p4_a13 JTF_VARCHAR2_TABLE_100
1341 , p4_a14 JTF_VARCHAR2_TABLE_100
1342 , p4_a15 JTF_NUMBER_TABLE
1343 , p4_a16 JTF_VARCHAR2_TABLE_100
1344 , p4_a17 JTF_NUMBER_TABLE
1345 , p4_a18 JTF_VARCHAR2_TABLE_100
1346 , p4_a19 JTF_NUMBER_TABLE
1347 , p4_a20 JTF_VARCHAR2_TABLE_2000
1348 , p4_a21 JTF_NUMBER_TABLE
1349 , p4_a22 JTF_VARCHAR2_TABLE_100
1350 , p4_a23 JTF_VARCHAR2_TABLE_100
1351 , p4_a24 JTF_NUMBER_TABLE
1352 , p4_a25 JTF_DATE_TABLE
1353 , p4_a26 JTF_NUMBER_TABLE
1354 , p4_a27 JTF_NUMBER_TABLE
1355 , p4_a28 JTF_VARCHAR2_TABLE_100
1356 , p4_a29 JTF_NUMBER_TABLE
1357 , p4_a30 JTF_VARCHAR2_TABLE_100
1358 , p4_a31 JTF_VARCHAR2_TABLE_100
1359 , p4_a32 JTF_DATE_TABLE
1360 , p4_a33 JTF_VARCHAR2_TABLE_100
1361 , p4_a34 JTF_VARCHAR2_TABLE_100
1362 , p4_a35 JTF_NUMBER_TABLE
1363 , p4_a36 JTF_NUMBER_TABLE
1364 , p4_a37 JTF_NUMBER_TABLE
1365 , p4_a38 JTF_VARCHAR2_TABLE_100
1366 , p4_a39 JTF_VARCHAR2_TABLE_100
1367 , p4_a40 JTF_VARCHAR2_TABLE_100
1368 , p4_a41 JTF_VARCHAR2_TABLE_100
1369 , p4_a42 JTF_NUMBER_TABLE
1370 , p4_a43 JTF_NUMBER_TABLE
1371 , p4_a44 JTF_DATE_TABLE
1372 , p4_a45 JTF_VARCHAR2_TABLE_100
1373 , p4_a46 JTF_NUMBER_TABLE
1374 , p4_a47 JTF_NUMBER_TABLE
1375 , p4_a48 JTF_NUMBER_TABLE
1376 , p4_a49 JTF_NUMBER_TABLE
1377 , p4_a50 JTF_VARCHAR2_TABLE_100
1378 , p4_a51 JTF_VARCHAR2_TABLE_200
1379 , p4_a52 JTF_VARCHAR2_TABLE_200
1380 , p4_a53 JTF_VARCHAR2_TABLE_200
1381 , p4_a54 JTF_VARCHAR2_TABLE_200
1382 , p4_a55 JTF_VARCHAR2_TABLE_200
1383 , p4_a56 JTF_VARCHAR2_TABLE_200
1384 , p4_a57 JTF_VARCHAR2_TABLE_200
1385 , p4_a58 JTF_VARCHAR2_TABLE_200
1386 , p4_a59 JTF_VARCHAR2_TABLE_200
1387 , p4_a60 JTF_VARCHAR2_TABLE_200
1388 , p4_a61 JTF_VARCHAR2_TABLE_200
1389 , p4_a62 JTF_VARCHAR2_TABLE_200
1390 , p4_a63 JTF_VARCHAR2_TABLE_200
1391 , p4_a64 JTF_VARCHAR2_TABLE_200
1392 , p4_a65 JTF_VARCHAR2_TABLE_200
1393 , p4_a66 JTF_NUMBER_TABLE
1394 , p4_a67 JTF_NUMBER_TABLE
1395 , p4_a68 JTF_NUMBER_TABLE
1396 , p_check_access_flag VARCHAR2
1397 , p_admin_flag VARCHAR2
1398 , p_admin_group_id NUMBER
1399 , p_identity_salesforce_id NUMBER
1400 , p_salesgroup_id NUMBER
1401 , p_partner_cont_party_id NUMBER
1402 , p12_a0 JTF_VARCHAR2_TABLE_100
1403 , p12_a1 JTF_VARCHAR2_TABLE_300
1404 , p13_a0 out nocopy JTF_NUMBER_TABLE
1405 , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
1406 , x_return_status out nocopy VARCHAR2
1407 , x_msg_count out nocopy NUMBER
1408 , x_msg_data out nocopy VARCHAR2
1409 , p5_a0 DATE := fnd_api.g_miss_date
1410 , p5_a1 NUMBER := 0-1962.0724
1411 , p5_a2 DATE := fnd_api.g_miss_date
1412 , p5_a3 NUMBER := 0-1962.0724
1413 , p5_a4 NUMBER := 0-1962.0724
1414 , p5_a5 NUMBER := 0-1962.0724
1415 , p5_a6 NUMBER := 0-1962.0724
1416 , p5_a7 NUMBER := 0-1962.0724
1417 , p5_a8 DATE := fnd_api.g_miss_date
1418 , p5_a9 NUMBER := 0-1962.0724
1419 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1421 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1422 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a15 NUMBER := 0-1962.0724
1425 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a17 NUMBER := 0-1962.0724
1427 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1428 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1429 , p5_a20 NUMBER := 0-1962.0724
1430 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1431 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1432 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1433 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1434 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1435 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1436 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1437 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1438 , p5_a29 NUMBER := 0-1962.0724
1439 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1440 , p5_a31 NUMBER := 0-1962.0724
1441 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a34 NUMBER := 0-1962.0724
1444 , p5_a35 NUMBER := 0-1962.0724
1445 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1446 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1447 , p5_a38 DATE := fnd_api.g_miss_date
1448 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1449 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1450 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1451 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1452 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1453 , p5_a44 NUMBER := 0-1962.0724
1454 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1455 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1456 , p5_a47 NUMBER := 0-1962.0724
1457 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1458 , p5_a49 NUMBER := 0-1962.0724
1462 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1459 , p5_a50 NUMBER := 0-1962.0724
1460 , p5_a51 NUMBER := 0-1962.0724
1461 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1463 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1464 , p5_a55 NUMBER := 0-1962.0724
1465 , p5_a56 NUMBER := 0-1962.0724
1466 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1467 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1468 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1469 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1470 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1471 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1472 , p5_a63 NUMBER := 0-1962.0724
1473 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1474 , p5_a65 NUMBER := 0-1962.0724
1475 , p5_a66 NUMBER := 0-1962.0724
1476 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
1477 , p5_a68 NUMBER := 0-1962.0724
1478 , p5_a69 NUMBER := 0-1962.0724
1479 , p5_a70 NUMBER := 0-1962.0724
1480 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
1481 , p5_a72 VARCHAR2 := fnd_api.g_miss_char
1482 , p5_a73 DATE := fnd_api.g_miss_date
1483 , p5_a74 VARCHAR2 := fnd_api.g_miss_char
1484 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
1485 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1486 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
1487 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
1488 , p5_a79 VARCHAR2 := fnd_api.g_miss_char
1489 , p5_a80 NUMBER := 0-1962.0724
1490 , p5_a81 VARCHAR2 := fnd_api.g_miss_char
1491 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1492 , p5_a83 VARCHAR2 := fnd_api.g_miss_char
1493 , p5_a84 VARCHAR2 := fnd_api.g_miss_char
1494 , p5_a85 VARCHAR2 := fnd_api.g_miss_char
1495 , p5_a86 VARCHAR2 := fnd_api.g_miss_char
1496 , p5_a87 VARCHAR2 := fnd_api.g_miss_char
1497 , p5_a88 VARCHAR2 := fnd_api.g_miss_char
1498 , p5_a89 VARCHAR2 := fnd_api.g_miss_char
1499 , p5_a90 VARCHAR2 := fnd_api.g_miss_char
1500 , p5_a91 VARCHAR2 := fnd_api.g_miss_char
1501 , p5_a92 VARCHAR2 := fnd_api.g_miss_char
1502 , p5_a93 VARCHAR2 := fnd_api.g_miss_char
1503 , p5_a94 VARCHAR2 := fnd_api.g_miss_char
1504 , p5_a95 VARCHAR2 := fnd_api.g_miss_char
1505 , p5_a96 VARCHAR2 := fnd_api.g_miss_char
1506 , p5_a97 VARCHAR2 := fnd_api.g_miss_char
1507 , p5_a98 VARCHAR2 := fnd_api.g_miss_char
1508 , p5_a99 NUMBER := 0-1962.0724
1509 );
1510 procedure update_opp_lines(p_api_version_number NUMBER
1511 , p_init_msg_list VARCHAR2
1512 , p_commit VARCHAR2
1513 , p_validation_level NUMBER
1514 , p_identity_salesforce_id NUMBER
1515 , p5_a0 JTF_DATE_TABLE
1516 , p5_a1 JTF_NUMBER_TABLE
1517 , p5_a2 JTF_DATE_TABLE
1518 , p5_a3 JTF_NUMBER_TABLE
1519 , p5_a4 JTF_NUMBER_TABLE
1520 , p5_a5 JTF_NUMBER_TABLE
1521 , p5_a6 JTF_NUMBER_TABLE
1522 , p5_a7 JTF_NUMBER_TABLE
1523 , p5_a8 JTF_DATE_TABLE
1524 , p5_a9 JTF_NUMBER_TABLE
1525 , p5_a10 JTF_NUMBER_TABLE
1526 , p5_a11 JTF_NUMBER_TABLE
1527 , p5_a12 JTF_NUMBER_TABLE
1528 , p5_a13 JTF_VARCHAR2_TABLE_100
1529 , p5_a14 JTF_VARCHAR2_TABLE_100
1530 , p5_a15 JTF_NUMBER_TABLE
1531 , p5_a16 JTF_VARCHAR2_TABLE_100
1532 , p5_a17 JTF_NUMBER_TABLE
1533 , p5_a18 JTF_VARCHAR2_TABLE_100
1534 , p5_a19 JTF_NUMBER_TABLE
1535 , p5_a20 JTF_VARCHAR2_TABLE_2000
1536 , p5_a21 JTF_NUMBER_TABLE
1537 , p5_a22 JTF_VARCHAR2_TABLE_100
1538 , p5_a23 JTF_VARCHAR2_TABLE_100
1539 , p5_a24 JTF_NUMBER_TABLE
1540 , p5_a25 JTF_DATE_TABLE
1541 , p5_a26 JTF_NUMBER_TABLE
1542 , p5_a27 JTF_NUMBER_TABLE
1543 , p5_a28 JTF_VARCHAR2_TABLE_100
1544 , p5_a29 JTF_NUMBER_TABLE
1545 , p5_a30 JTF_VARCHAR2_TABLE_100
1546 , p5_a31 JTF_VARCHAR2_TABLE_100
1547 , p5_a32 JTF_DATE_TABLE
1548 , p5_a33 JTF_VARCHAR2_TABLE_100
1549 , p5_a34 JTF_VARCHAR2_TABLE_100
1550 , p5_a35 JTF_NUMBER_TABLE
1551 , p5_a36 JTF_NUMBER_TABLE
1552 , p5_a37 JTF_NUMBER_TABLE
1553 , p5_a38 JTF_VARCHAR2_TABLE_100
1554 , p5_a39 JTF_VARCHAR2_TABLE_100
1555 , p5_a40 JTF_VARCHAR2_TABLE_100
1556 , p5_a41 JTF_VARCHAR2_TABLE_100
1557 , p5_a42 JTF_NUMBER_TABLE
1558 , p5_a43 JTF_NUMBER_TABLE
1559 , p5_a44 JTF_DATE_TABLE
1560 , p5_a45 JTF_VARCHAR2_TABLE_100
1561 , p5_a46 JTF_NUMBER_TABLE
1562 , p5_a47 JTF_NUMBER_TABLE
1563 , p5_a48 JTF_NUMBER_TABLE
1564 , p5_a49 JTF_NUMBER_TABLE
1565 , p5_a50 JTF_VARCHAR2_TABLE_100
1566 , p5_a51 JTF_VARCHAR2_TABLE_200
1567 , p5_a52 JTF_VARCHAR2_TABLE_200
1568 , p5_a53 JTF_VARCHAR2_TABLE_200
1569 , p5_a54 JTF_VARCHAR2_TABLE_200
1570 , p5_a55 JTF_VARCHAR2_TABLE_200
1571 , p5_a56 JTF_VARCHAR2_TABLE_200
1572 , p5_a57 JTF_VARCHAR2_TABLE_200
1573 , p5_a58 JTF_VARCHAR2_TABLE_200
1574 , p5_a59 JTF_VARCHAR2_TABLE_200
1575 , p5_a60 JTF_VARCHAR2_TABLE_200
1576 , p5_a61 JTF_VARCHAR2_TABLE_200
1577 , p5_a62 JTF_VARCHAR2_TABLE_200
1578 , p5_a63 JTF_VARCHAR2_TABLE_200
1579 , p5_a64 JTF_VARCHAR2_TABLE_200
1580 , p5_a65 JTF_VARCHAR2_TABLE_200
1581 , p5_a66 JTF_NUMBER_TABLE
1582 , p5_a67 JTF_NUMBER_TABLE
1583 , p5_a68 JTF_NUMBER_TABLE
1584 , p_check_access_flag VARCHAR2
1585 , p_admin_flag VARCHAR2
1586 , p_admin_group_id NUMBER
1587 , p_partner_cont_party_id NUMBER
1588 , p11_a0 JTF_VARCHAR2_TABLE_100
1589 , p11_a1 JTF_VARCHAR2_TABLE_300
1593 , x_msg_count out nocopy NUMBER
1590 , p12_a0 out nocopy JTF_NUMBER_TABLE
1591 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
1592 , x_return_status out nocopy VARCHAR2
1594 , x_msg_data out nocopy VARCHAR2
1595 , p6_a0 DATE := fnd_api.g_miss_date
1596 , p6_a1 NUMBER := 0-1962.0724
1597 , p6_a2 DATE := fnd_api.g_miss_date
1598 , p6_a3 NUMBER := 0-1962.0724
1599 , p6_a4 NUMBER := 0-1962.0724
1600 , p6_a5 NUMBER := 0-1962.0724
1601 , p6_a6 NUMBER := 0-1962.0724
1602 , p6_a7 NUMBER := 0-1962.0724
1603 , p6_a8 DATE := fnd_api.g_miss_date
1604 , p6_a9 NUMBER := 0-1962.0724
1605 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1606 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1607 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1608 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1609 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1610 , p6_a15 NUMBER := 0-1962.0724
1611 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1612 , p6_a17 NUMBER := 0-1962.0724
1613 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1614 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1615 , p6_a20 NUMBER := 0-1962.0724
1616 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1617 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1618 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1619 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1620 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
1621 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
1622 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
1623 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
1624 , p6_a29 NUMBER := 0-1962.0724
1625 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
1626 , p6_a31 NUMBER := 0-1962.0724
1627 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
1628 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
1629 , p6_a34 NUMBER := 0-1962.0724
1630 , p6_a35 NUMBER := 0-1962.0724
1631 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1632 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1633 , p6_a38 DATE := fnd_api.g_miss_date
1634 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1635 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1636 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1637 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1638 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1639 , p6_a44 NUMBER := 0-1962.0724
1640 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1641 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1642 , p6_a47 NUMBER := 0-1962.0724
1643 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1644 , p6_a49 NUMBER := 0-1962.0724
1645 , p6_a50 NUMBER := 0-1962.0724
1646 , p6_a51 NUMBER := 0-1962.0724
1647 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
1648 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
1649 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
1650 , p6_a55 NUMBER := 0-1962.0724
1651 , p6_a56 NUMBER := 0-1962.0724
1652 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
1653 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
1654 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
1655 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
1656 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
1657 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
1658 , p6_a63 NUMBER := 0-1962.0724
1659 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
1660 , p6_a65 NUMBER := 0-1962.0724
1661 , p6_a66 NUMBER := 0-1962.0724
1662 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
1663 , p6_a68 NUMBER := 0-1962.0724
1664 , p6_a69 NUMBER := 0-1962.0724
1665 , p6_a70 NUMBER := 0-1962.0724
1666 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
1667 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1668 , p6_a73 DATE := fnd_api.g_miss_date
1669 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
1670 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
1671 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
1672 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
1673 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
1674 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
1675 , p6_a80 NUMBER := 0-1962.0724
1676 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
1677 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
1678 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
1679 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
1680 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
1681 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
1682 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
1683 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
1684 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
1685 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
1686 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
1687 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
1688 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
1689 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
1690 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
1691 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
1692 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
1693 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
1694 , p6_a99 NUMBER := 0-1962.0724
1695 );
1696 procedure delete_opp_lines(p_api_version_number NUMBER
1697 , p_init_msg_list VARCHAR2
1698 , p_commit VARCHAR2
1699 , p_validation_level NUMBER
1700 , p_identity_salesforce_id NUMBER
1701 , p5_a0 JTF_DATE_TABLE
1702 , p5_a1 JTF_NUMBER_TABLE
1703 , p5_a2 JTF_DATE_TABLE
1704 , p5_a3 JTF_NUMBER_TABLE
1705 , p5_a4 JTF_NUMBER_TABLE
1706 , p5_a5 JTF_NUMBER_TABLE
1707 , p5_a6 JTF_NUMBER_TABLE
1708 , p5_a7 JTF_NUMBER_TABLE
1709 , p5_a8 JTF_DATE_TABLE
1713 , p5_a12 JTF_NUMBER_TABLE
1710 , p5_a9 JTF_NUMBER_TABLE
1711 , p5_a10 JTF_NUMBER_TABLE
1712 , p5_a11 JTF_NUMBER_TABLE
1714 , p5_a13 JTF_VARCHAR2_TABLE_100
1715 , p5_a14 JTF_VARCHAR2_TABLE_100
1716 , p5_a15 JTF_NUMBER_TABLE
1717 , p5_a16 JTF_VARCHAR2_TABLE_100
1718 , p5_a17 JTF_NUMBER_TABLE
1719 , p5_a18 JTF_VARCHAR2_TABLE_100
1720 , p5_a19 JTF_NUMBER_TABLE
1721 , p5_a20 JTF_VARCHAR2_TABLE_2000
1722 , p5_a21 JTF_NUMBER_TABLE
1723 , p5_a22 JTF_VARCHAR2_TABLE_100
1724 , p5_a23 JTF_VARCHAR2_TABLE_100
1725 , p5_a24 JTF_NUMBER_TABLE
1726 , p5_a25 JTF_DATE_TABLE
1727 , p5_a26 JTF_NUMBER_TABLE
1728 , p5_a27 JTF_NUMBER_TABLE
1729 , p5_a28 JTF_VARCHAR2_TABLE_100
1730 , p5_a29 JTF_NUMBER_TABLE
1731 , p5_a30 JTF_VARCHAR2_TABLE_100
1732 , p5_a31 JTF_VARCHAR2_TABLE_100
1733 , p5_a32 JTF_DATE_TABLE
1734 , p5_a33 JTF_VARCHAR2_TABLE_100
1735 , p5_a34 JTF_VARCHAR2_TABLE_100
1736 , p5_a35 JTF_NUMBER_TABLE
1737 , p5_a36 JTF_NUMBER_TABLE
1738 , p5_a37 JTF_NUMBER_TABLE
1739 , p5_a38 JTF_VARCHAR2_TABLE_100
1740 , p5_a39 JTF_VARCHAR2_TABLE_100
1741 , p5_a40 JTF_VARCHAR2_TABLE_100
1742 , p5_a41 JTF_VARCHAR2_TABLE_100
1743 , p5_a42 JTF_NUMBER_TABLE
1744 , p5_a43 JTF_NUMBER_TABLE
1745 , p5_a44 JTF_DATE_TABLE
1746 , p5_a45 JTF_VARCHAR2_TABLE_100
1747 , p5_a46 JTF_NUMBER_TABLE
1748 , p5_a47 JTF_NUMBER_TABLE
1749 , p5_a48 JTF_NUMBER_TABLE
1750 , p5_a49 JTF_NUMBER_TABLE
1751 , p5_a50 JTF_VARCHAR2_TABLE_100
1752 , p5_a51 JTF_VARCHAR2_TABLE_200
1753 , p5_a52 JTF_VARCHAR2_TABLE_200
1754 , p5_a53 JTF_VARCHAR2_TABLE_200
1755 , p5_a54 JTF_VARCHAR2_TABLE_200
1756 , p5_a55 JTF_VARCHAR2_TABLE_200
1757 , p5_a56 JTF_VARCHAR2_TABLE_200
1758 , p5_a57 JTF_VARCHAR2_TABLE_200
1759 , p5_a58 JTF_VARCHAR2_TABLE_200
1760 , p5_a59 JTF_VARCHAR2_TABLE_200
1761 , p5_a60 JTF_VARCHAR2_TABLE_200
1762 , p5_a61 JTF_VARCHAR2_TABLE_200
1763 , p5_a62 JTF_VARCHAR2_TABLE_200
1764 , p5_a63 JTF_VARCHAR2_TABLE_200
1765 , p5_a64 JTF_VARCHAR2_TABLE_200
1766 , p5_a65 JTF_VARCHAR2_TABLE_200
1767 , p5_a66 JTF_NUMBER_TABLE
1768 , p5_a67 JTF_NUMBER_TABLE
1769 , p5_a68 JTF_NUMBER_TABLE
1770 , p_check_access_flag VARCHAR2
1771 , p_admin_flag VARCHAR2
1772 , p_admin_group_id NUMBER
1773 , p_partner_cont_party_id NUMBER
1774 , p11_a0 JTF_VARCHAR2_TABLE_100
1775 , p11_a1 JTF_VARCHAR2_TABLE_300
1776 , p12_a0 out nocopy JTF_NUMBER_TABLE
1777 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
1778 , x_return_status out nocopy VARCHAR2
1779 , x_msg_count out nocopy NUMBER
1780 , x_msg_data out nocopy VARCHAR2
1781 , p6_a0 DATE := fnd_api.g_miss_date
1782 , p6_a1 NUMBER := 0-1962.0724
1783 , p6_a2 DATE := fnd_api.g_miss_date
1784 , p6_a3 NUMBER := 0-1962.0724
1785 , p6_a4 NUMBER := 0-1962.0724
1786 , p6_a5 NUMBER := 0-1962.0724
1787 , p6_a6 NUMBER := 0-1962.0724
1788 , p6_a7 NUMBER := 0-1962.0724
1789 , p6_a8 DATE := fnd_api.g_miss_date
1790 , p6_a9 NUMBER := 0-1962.0724
1791 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
1792 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
1793 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
1794 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
1795 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
1796 , p6_a15 NUMBER := 0-1962.0724
1797 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
1798 , p6_a17 NUMBER := 0-1962.0724
1799 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
1800 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
1801 , p6_a20 NUMBER := 0-1962.0724
1802 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
1803 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
1804 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
1805 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
1806 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
1807 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
1808 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
1809 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
1810 , p6_a29 NUMBER := 0-1962.0724
1811 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
1812 , p6_a31 NUMBER := 0-1962.0724
1813 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
1814 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
1815 , p6_a34 NUMBER := 0-1962.0724
1816 , p6_a35 NUMBER := 0-1962.0724
1817 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
1818 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
1819 , p6_a38 DATE := fnd_api.g_miss_date
1820 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
1821 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
1822 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
1823 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
1824 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
1825 , p6_a44 NUMBER := 0-1962.0724
1826 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
1827 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
1828 , p6_a47 NUMBER := 0-1962.0724
1829 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
1830 , p6_a49 NUMBER := 0-1962.0724
1831 , p6_a50 NUMBER := 0-1962.0724
1832 , p6_a51 NUMBER := 0-1962.0724
1833 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
1834 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
1835 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
1836 , p6_a55 NUMBER := 0-1962.0724
1837 , p6_a56 NUMBER := 0-1962.0724
1841 , p6_a60 VARCHAR2 := fnd_api.g_miss_char
1838 , p6_a57 VARCHAR2 := fnd_api.g_miss_char
1839 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
1840 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
1842 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
1843 , p6_a62 VARCHAR2 := fnd_api.g_miss_char
1844 , p6_a63 NUMBER := 0-1962.0724
1845 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
1846 , p6_a65 NUMBER := 0-1962.0724
1847 , p6_a66 NUMBER := 0-1962.0724
1848 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
1849 , p6_a68 NUMBER := 0-1962.0724
1850 , p6_a69 NUMBER := 0-1962.0724
1851 , p6_a70 NUMBER := 0-1962.0724
1852 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
1853 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
1854 , p6_a73 DATE := fnd_api.g_miss_date
1855 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
1856 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
1857 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
1858 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
1859 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
1860 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
1861 , p6_a80 NUMBER := 0-1962.0724
1862 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
1863 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
1864 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
1865 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
1866 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
1867 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
1868 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
1869 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
1870 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
1871 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
1872 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
1873 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
1874 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
1875 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
1876 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
1877 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
1878 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
1879 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
1880 , p6_a99 NUMBER := 0-1962.0724
1881 );
1882 procedure create_sales_credits(p_api_version_number NUMBER
1883 , p_init_msg_list VARCHAR2
1884 , p_commit VARCHAR2
1885 , p_validation_level NUMBER
1886 , p_identity_salesforce_id NUMBER
1887 , p5_a0 JTF_DATE_TABLE
1888 , p5_a1 JTF_NUMBER_TABLE
1889 , p5_a2 JTF_DATE_TABLE
1890 , p5_a3 JTF_NUMBER_TABLE
1891 , p5_a4 JTF_NUMBER_TABLE
1892 , p5_a5 JTF_NUMBER_TABLE
1893 , p5_a6 JTF_NUMBER_TABLE
1894 , p5_a7 JTF_NUMBER_TABLE
1895 , p5_a8 JTF_DATE_TABLE
1896 , p5_a9 JTF_NUMBER_TABLE
1897 , p5_a10 JTF_NUMBER_TABLE
1898 , p5_a11 JTF_NUMBER_TABLE
1899 , p5_a12 JTF_NUMBER_TABLE
1900 , p5_a13 JTF_NUMBER_TABLE
1901 , p5_a14 JTF_NUMBER_TABLE
1902 , p5_a15 JTF_VARCHAR2_TABLE_100
1903 , p5_a16 JTF_VARCHAR2_TABLE_100
1904 , p5_a17 JTF_NUMBER_TABLE
1905 , p5_a18 JTF_VARCHAR2_TABLE_100
1906 , p5_a19 JTF_NUMBER_TABLE
1907 , p5_a20 JTF_VARCHAR2_TABLE_400
1908 , p5_a21 JTF_VARCHAR2_TABLE_100
1909 , p5_a22 JTF_NUMBER_TABLE
1910 , p5_a23 JTF_NUMBER_TABLE
1911 , p5_a24 JTF_NUMBER_TABLE
1912 , p5_a25 JTF_NUMBER_TABLE
1913 , p5_a26 JTF_NUMBER_TABLE
1914 , p5_a27 JTF_NUMBER_TABLE
1915 , p5_a28 JTF_NUMBER_TABLE
1916 , p5_a29 JTF_VARCHAR2_TABLE_100
1917 , p5_a30 JTF_VARCHAR2_TABLE_100
1918 , p5_a31 JTF_VARCHAR2_TABLE_100
1919 , p5_a32 JTF_DATE_TABLE
1920 , p5_a33 JTF_NUMBER_TABLE
1921 , p5_a34 JTF_VARCHAR2_TABLE_100
1922 , p5_a35 JTF_VARCHAR2_TABLE_100
1923 , p5_a36 JTF_NUMBER_TABLE
1924 , p5_a37 JTF_VARCHAR2_TABLE_100
1925 , p5_a38 JTF_NUMBER_TABLE
1926 , p5_a39 JTF_NUMBER_TABLE
1927 , p5_a40 JTF_NUMBER_TABLE
1928 , p5_a41 JTF_VARCHAR2_TABLE_100
1929 , p5_a42 JTF_VARCHAR2_TABLE_200
1930 , p5_a43 JTF_VARCHAR2_TABLE_200
1931 , p5_a44 JTF_VARCHAR2_TABLE_200
1932 , p5_a45 JTF_VARCHAR2_TABLE_200
1933 , p5_a46 JTF_VARCHAR2_TABLE_200
1934 , p5_a47 JTF_VARCHAR2_TABLE_200
1935 , p5_a48 JTF_VARCHAR2_TABLE_200
1936 , p5_a49 JTF_VARCHAR2_TABLE_200
1937 , p5_a50 JTF_VARCHAR2_TABLE_200
1938 , p5_a51 JTF_VARCHAR2_TABLE_200
1939 , p5_a52 JTF_VARCHAR2_TABLE_200
1940 , p5_a53 JTF_VARCHAR2_TABLE_200
1941 , p5_a54 JTF_VARCHAR2_TABLE_200
1942 , p5_a55 JTF_VARCHAR2_TABLE_200
1943 , p5_a56 JTF_VARCHAR2_TABLE_200
1944 , p5_a57 JTF_NUMBER_TABLE
1945 , p5_a58 JTF_NUMBER_TABLE
1946 , p5_a59 JTF_NUMBER_TABLE
1947 , p5_a60 JTF_VARCHAR2_TABLE_100
1948 , p_check_access_flag VARCHAR2
1949 , p_admin_flag VARCHAR2
1950 , p_admin_group_id NUMBER
1951 , p_partner_cont_party_id NUMBER
1952 , p10_a0 JTF_VARCHAR2_TABLE_100
1953 , p10_a1 JTF_VARCHAR2_TABLE_300
1954 , p11_a0 out nocopy JTF_NUMBER_TABLE
1955 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
1956 , x_return_status out nocopy VARCHAR2
1957 , x_msg_count out nocopy NUMBER
1958 , x_msg_data out nocopy VARCHAR2
1959 );
1960 procedure update_sales_credits(p_api_version_number NUMBER
1961 , p_init_msg_list VARCHAR2
1962 , p_commit VARCHAR2
1963 , p_validation_level NUMBER
1964 , p_identity_salesforce_id NUMBER
1965 , p5_a0 JTF_DATE_TABLE
1966 , p5_a1 JTF_NUMBER_TABLE
1967 , p5_a2 JTF_DATE_TABLE
1971 , p5_a6 JTF_NUMBER_TABLE
1968 , p5_a3 JTF_NUMBER_TABLE
1969 , p5_a4 JTF_NUMBER_TABLE
1970 , p5_a5 JTF_NUMBER_TABLE
1972 , p5_a7 JTF_NUMBER_TABLE
1973 , p5_a8 JTF_DATE_TABLE
1974 , p5_a9 JTF_NUMBER_TABLE
1975 , p5_a10 JTF_NUMBER_TABLE
1976 , p5_a11 JTF_NUMBER_TABLE
1977 , p5_a12 JTF_NUMBER_TABLE
1978 , p5_a13 JTF_NUMBER_TABLE
1979 , p5_a14 JTF_NUMBER_TABLE
1980 , p5_a15 JTF_VARCHAR2_TABLE_100
1981 , p5_a16 JTF_VARCHAR2_TABLE_100
1982 , p5_a17 JTF_NUMBER_TABLE
1983 , p5_a18 JTF_VARCHAR2_TABLE_100
1984 , p5_a19 JTF_NUMBER_TABLE
1985 , p5_a20 JTF_VARCHAR2_TABLE_400
1986 , p5_a21 JTF_VARCHAR2_TABLE_100
1987 , p5_a22 JTF_NUMBER_TABLE
1988 , p5_a23 JTF_NUMBER_TABLE
1989 , p5_a24 JTF_NUMBER_TABLE
1990 , p5_a25 JTF_NUMBER_TABLE
1991 , p5_a26 JTF_NUMBER_TABLE
1992 , p5_a27 JTF_NUMBER_TABLE
1993 , p5_a28 JTF_NUMBER_TABLE
1994 , p5_a29 JTF_VARCHAR2_TABLE_100
1995 , p5_a30 JTF_VARCHAR2_TABLE_100
1996 , p5_a31 JTF_VARCHAR2_TABLE_100
1997 , p5_a32 JTF_DATE_TABLE
1998 , p5_a33 JTF_NUMBER_TABLE
1999 , p5_a34 JTF_VARCHAR2_TABLE_100
2000 , p5_a35 JTF_VARCHAR2_TABLE_100
2001 , p5_a36 JTF_NUMBER_TABLE
2002 , p5_a37 JTF_VARCHAR2_TABLE_100
2003 , p5_a38 JTF_NUMBER_TABLE
2004 , p5_a39 JTF_NUMBER_TABLE
2005 , p5_a40 JTF_NUMBER_TABLE
2006 , p5_a41 JTF_VARCHAR2_TABLE_100
2007 , p5_a42 JTF_VARCHAR2_TABLE_200
2008 , p5_a43 JTF_VARCHAR2_TABLE_200
2009 , p5_a44 JTF_VARCHAR2_TABLE_200
2010 , p5_a45 JTF_VARCHAR2_TABLE_200
2011 , p5_a46 JTF_VARCHAR2_TABLE_200
2012 , p5_a47 JTF_VARCHAR2_TABLE_200
2013 , p5_a48 JTF_VARCHAR2_TABLE_200
2014 , p5_a49 JTF_VARCHAR2_TABLE_200
2015 , p5_a50 JTF_VARCHAR2_TABLE_200
2016 , p5_a51 JTF_VARCHAR2_TABLE_200
2017 , p5_a52 JTF_VARCHAR2_TABLE_200
2018 , p5_a53 JTF_VARCHAR2_TABLE_200
2019 , p5_a54 JTF_VARCHAR2_TABLE_200
2020 , p5_a55 JTF_VARCHAR2_TABLE_200
2021 , p5_a56 JTF_VARCHAR2_TABLE_200
2022 , p5_a57 JTF_NUMBER_TABLE
2023 , p5_a58 JTF_NUMBER_TABLE
2024 , p5_a59 JTF_NUMBER_TABLE
2025 , p5_a60 JTF_VARCHAR2_TABLE_100
2026 , p_check_access_flag VARCHAR2
2027 , p_admin_flag VARCHAR2
2028 , p_admin_group_id NUMBER
2029 , p_partner_cont_party_id NUMBER
2030 , p10_a0 JTF_VARCHAR2_TABLE_100
2031 , p10_a1 JTF_VARCHAR2_TABLE_300
2032 , p11_a0 out nocopy JTF_NUMBER_TABLE
2036 , x_msg_data out nocopy VARCHAR2
2033 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
2034 , x_return_status out nocopy VARCHAR2
2035 , x_msg_count out nocopy NUMBER
2037 );
2038 end as_opportunity_pub_w;