[Home] [Help]
PACKAGE: APPS.AMS_IMPORT_LIST_PVT_W
Source
1 package ams_import_list_pvt_w as
2 /* $Header: amswimps.pls 120.1 2006/01/02 01:28 rmbhanda noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy ams_import_list_pvt.ams_import_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_DATE_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_200
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_VARCHAR2_TABLE_4000
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_DATE_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_VARCHAR2_TABLE_100
29 , a26 JTF_DATE_TABLE
30 , a27 JTF_DATE_TABLE
31 , a28 JTF_VARCHAR2_TABLE_4000
32 , a29 JTF_VARCHAR2_TABLE_4000
33 , a30 JTF_NUMBER_TABLE
34 , a31 JTF_VARCHAR2_TABLE_100
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_VARCHAR2_TABLE_100
37 , a34 JTF_VARCHAR2_TABLE_100
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_1000
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_100
42 , a39 JTF_VARCHAR2_TABLE_100
43 , a40 JTF_VARCHAR2_TABLE_200
44 , a41 JTF_VARCHAR2_TABLE_200
45 , a42 JTF_VARCHAR2_TABLE_200
46 , a43 JTF_VARCHAR2_TABLE_200
47 , a44 JTF_VARCHAR2_TABLE_200
48 , a45 JTF_VARCHAR2_TABLE_200
49 , a46 JTF_VARCHAR2_TABLE_200
50 , a47 JTF_VARCHAR2_TABLE_200
51 , a48 JTF_VARCHAR2_TABLE_200
52 , a49 JTF_VARCHAR2_TABLE_200
53 , a50 JTF_VARCHAR2_TABLE_200
54 , a51 JTF_VARCHAR2_TABLE_200
55 , a52 JTF_VARCHAR2_TABLE_200
56 , a53 JTF_VARCHAR2_TABLE_200
57 , a54 JTF_VARCHAR2_TABLE_200
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_NUMBER_TABLE
60 , a57 JTF_NUMBER_TABLE
61 , a58 JTF_NUMBER_TABLE
62 , a59 JTF_VARCHAR2_TABLE_1000
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_NUMBER_TABLE
68 , a65 JTF_NUMBER_TABLE
69 , a66 JTF_VARCHAR2_TABLE_100
70 , a67 JTF_VARCHAR2_TABLE_100
71 , a68 JTF_VARCHAR2_TABLE_300
72 , a69 JTF_VARCHAR2_TABLE_300
73 , a70 JTF_VARCHAR2_TABLE_300
74 , a71 JTF_VARCHAR2_TABLE_100
75 , a72 JTF_NUMBER_TABLE
76 , a73 JTF_VARCHAR2_TABLE_100
77 , a74 JTF_NUMBER_TABLE
78 , a75 JTF_VARCHAR2_TABLE_100
79 );
80 procedure rosetta_table_copy_out_p3(t ams_import_list_pvt.ams_import_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81 , a1 out nocopy JTF_DATE_TABLE
82 , a2 out nocopy JTF_NUMBER_TABLE
83 , a3 out nocopy JTF_DATE_TABLE
84 , a4 out nocopy JTF_NUMBER_TABLE
85 , a5 out nocopy JTF_NUMBER_TABLE
86 , a6 out nocopy JTF_NUMBER_TABLE
87 , a7 out nocopy JTF_NUMBER_TABLE
88 , a8 out nocopy JTF_VARCHAR2_TABLE_200
89 , a9 out nocopy JTF_VARCHAR2_TABLE_100
90 , a10 out nocopy JTF_VARCHAR2_TABLE_100
91 , a11 out nocopy JTF_NUMBER_TABLE
92 , a12 out nocopy JTF_NUMBER_TABLE
93 , a13 out nocopy JTF_VARCHAR2_TABLE_100
94 , a14 out nocopy JTF_DATE_TABLE
95 , a15 out nocopy JTF_NUMBER_TABLE
96 , a16 out nocopy JTF_VARCHAR2_TABLE_4000
97 , a17 out nocopy JTF_NUMBER_TABLE
98 , a18 out nocopy JTF_NUMBER_TABLE
99 , a19 out nocopy JTF_NUMBER_TABLE
100 , a20 out nocopy JTF_DATE_TABLE
101 , a21 out nocopy JTF_NUMBER_TABLE
102 , a22 out nocopy JTF_DATE_TABLE
103 , a23 out nocopy JTF_NUMBER_TABLE
104 , a24 out nocopy JTF_NUMBER_TABLE
105 , a25 out nocopy JTF_VARCHAR2_TABLE_100
106 , a26 out nocopy JTF_DATE_TABLE
107 , a27 out nocopy JTF_DATE_TABLE
108 , a28 out nocopy JTF_VARCHAR2_TABLE_4000
109 , a29 out nocopy JTF_VARCHAR2_TABLE_4000
110 , a30 out nocopy JTF_NUMBER_TABLE
111 , a31 out nocopy JTF_VARCHAR2_TABLE_100
112 , a32 out nocopy JTF_NUMBER_TABLE
113 , a33 out nocopy JTF_VARCHAR2_TABLE_100
114 , a34 out nocopy JTF_VARCHAR2_TABLE_100
115 , a35 out nocopy JTF_VARCHAR2_TABLE_100
116 , a36 out nocopy JTF_VARCHAR2_TABLE_1000
117 , a37 out nocopy JTF_VARCHAR2_TABLE_100
118 , a38 out nocopy JTF_VARCHAR2_TABLE_100
119 , a39 out nocopy JTF_VARCHAR2_TABLE_100
120 , a40 out nocopy JTF_VARCHAR2_TABLE_200
121 , a41 out nocopy JTF_VARCHAR2_TABLE_200
122 , a42 out nocopy JTF_VARCHAR2_TABLE_200
123 , a43 out nocopy JTF_VARCHAR2_TABLE_200
124 , a44 out nocopy JTF_VARCHAR2_TABLE_200
125 , a45 out nocopy JTF_VARCHAR2_TABLE_200
126 , a46 out nocopy JTF_VARCHAR2_TABLE_200
127 , a47 out nocopy JTF_VARCHAR2_TABLE_200
128 , a48 out nocopy JTF_VARCHAR2_TABLE_200
129 , a49 out nocopy JTF_VARCHAR2_TABLE_200
130 , a50 out nocopy JTF_VARCHAR2_TABLE_200
131 , a51 out nocopy JTF_VARCHAR2_TABLE_200
132 , a52 out nocopy JTF_VARCHAR2_TABLE_200
133 , a53 out nocopy JTF_VARCHAR2_TABLE_200
134 , a54 out nocopy JTF_VARCHAR2_TABLE_200
135 , a55 out nocopy JTF_NUMBER_TABLE
136 , a56 out nocopy JTF_NUMBER_TABLE
137 , a57 out nocopy JTF_NUMBER_TABLE
138 , a58 out nocopy JTF_NUMBER_TABLE
139 , a59 out nocopy JTF_VARCHAR2_TABLE_1000
140 , a60 out nocopy JTF_VARCHAR2_TABLE_100
141 , a61 out nocopy JTF_VARCHAR2_TABLE_100
142 , a62 out nocopy JTF_VARCHAR2_TABLE_100
143 , a63 out nocopy JTF_NUMBER_TABLE
144 , a64 out nocopy JTF_NUMBER_TABLE
145 , a65 out nocopy JTF_NUMBER_TABLE
146 , a66 out nocopy JTF_VARCHAR2_TABLE_100
147 , a67 out nocopy JTF_VARCHAR2_TABLE_100
148 , a68 out nocopy JTF_VARCHAR2_TABLE_300
149 , a69 out nocopy JTF_VARCHAR2_TABLE_300
150 , a70 out nocopy JTF_VARCHAR2_TABLE_300
151 , a71 out nocopy JTF_VARCHAR2_TABLE_100
152 , a72 out nocopy JTF_NUMBER_TABLE
153 , a73 out nocopy JTF_VARCHAR2_TABLE_100
154 , a74 out nocopy JTF_NUMBER_TABLE
155 , a75 out nocopy JTF_VARCHAR2_TABLE_100
156 );
157
158 procedure duplicate_import_list(p_api_version_number NUMBER
159 , p_init_msg_list VARCHAR2
160 , p_commit VARCHAR2
161 , p_validation_level NUMBER
162 , x_return_status out nocopy VARCHAR2
163 , x_msg_count out nocopy NUMBER
164 , x_msg_data out nocopy VARCHAR2
165 , p_import_list_header_id NUMBER
166 , p8_a0 out nocopy NUMBER
167 , p8_a1 out nocopy DATE
168 , p8_a2 out nocopy NUMBER
169 , p8_a3 out nocopy DATE
170 , p8_a4 out nocopy NUMBER
171 , p8_a5 out nocopy NUMBER
172 , p8_a6 out nocopy NUMBER
173 , p8_a7 out nocopy NUMBER
174 , p8_a8 out nocopy VARCHAR2
175 , p8_a9 out nocopy VARCHAR2
176 , p8_a10 out nocopy VARCHAR2
177 , p8_a11 out nocopy NUMBER
178 , p8_a12 out nocopy NUMBER
179 , p8_a13 out nocopy VARCHAR2
180 , p8_a14 out nocopy DATE
181 , p8_a15 out nocopy NUMBER
182 , p8_a16 out nocopy VARCHAR2
183 , p8_a17 out nocopy NUMBER
184 , p8_a18 out nocopy NUMBER
185 , p8_a19 out nocopy NUMBER
186 , p8_a20 out nocopy DATE
187 , p8_a21 out nocopy NUMBER
188 , p8_a22 out nocopy DATE
189 , p8_a23 out nocopy NUMBER
190 , p8_a24 out nocopy NUMBER
191 , p8_a25 out nocopy VARCHAR2
192 , p8_a26 out nocopy DATE
193 , p8_a27 out nocopy DATE
194 , p8_a28 out nocopy VARCHAR2
195 , p8_a29 out nocopy VARCHAR2
196 , p8_a30 out nocopy NUMBER
197 , p8_a31 out nocopy VARCHAR2
198 , p8_a32 out nocopy NUMBER
199 , p8_a33 out nocopy VARCHAR2
200 , p8_a34 out nocopy VARCHAR2
201 , p8_a35 out nocopy VARCHAR2
202 , p8_a36 out nocopy VARCHAR2
203 , p8_a37 out nocopy VARCHAR2
204 , p8_a38 out nocopy VARCHAR2
205 , p8_a39 out nocopy VARCHAR2
206 , p8_a40 out nocopy VARCHAR2
207 , p8_a41 out nocopy VARCHAR2
208 , p8_a42 out nocopy VARCHAR2
209 , p8_a43 out nocopy VARCHAR2
210 , p8_a44 out nocopy VARCHAR2
211 , p8_a45 out nocopy VARCHAR2
212 , p8_a46 out nocopy VARCHAR2
213 , p8_a47 out nocopy VARCHAR2
214 , p8_a48 out nocopy VARCHAR2
215 , p8_a49 out nocopy VARCHAR2
216 , p8_a50 out nocopy VARCHAR2
217 , p8_a51 out nocopy VARCHAR2
218 , p8_a52 out nocopy VARCHAR2
219 , p8_a53 out nocopy VARCHAR2
220 , p8_a54 out nocopy VARCHAR2
221 , p8_a55 out nocopy NUMBER
222 , p8_a56 out nocopy NUMBER
223 , p8_a57 out nocopy NUMBER
224 , p8_a58 out nocopy NUMBER
225 , p8_a59 out nocopy VARCHAR2
226 , p8_a60 out nocopy VARCHAR2
227 , p8_a61 out nocopy VARCHAR2
228 , p8_a62 out nocopy VARCHAR2
229 , p8_a63 out nocopy NUMBER
230 , p8_a64 out nocopy NUMBER
231 , p8_a65 out nocopy NUMBER
232 , p8_a66 out nocopy VARCHAR2
233 , p8_a67 out nocopy VARCHAR2
234 , p8_a68 out nocopy VARCHAR2
235 , p8_a69 out nocopy VARCHAR2
236 , p8_a70 out nocopy VARCHAR2
237 , p8_a71 out nocopy VARCHAR2
238 , p8_a72 out nocopy NUMBER
239 , p8_a73 out nocopy VARCHAR2
240 , p8_a74 out nocopy NUMBER
241 , p8_a75 out nocopy VARCHAR2
242 , x_file_type out nocopy VARCHAR2
243 );
244 procedure create_import_list(p_api_version_number NUMBER
245 , p_init_msg_list VARCHAR2
246 , p_commit VARCHAR2
247 , p_validation_level NUMBER
248 , x_return_status out nocopy VARCHAR2
249 , x_msg_count out nocopy NUMBER
250 , x_msg_data out nocopy VARCHAR2
251 , x_import_list_header_id out nocopy NUMBER
252 , p7_a0 NUMBER := 0-1962.0724
253 , p7_a1 DATE := fnd_api.g_miss_date
254 , p7_a2 NUMBER := 0-1962.0724
255 , p7_a3 DATE := fnd_api.g_miss_date
256 , p7_a4 NUMBER := 0-1962.0724
257 , p7_a5 NUMBER := 0-1962.0724
258 , p7_a6 NUMBER := 0-1962.0724
259 , p7_a7 NUMBER := 0-1962.0724
260 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
262 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
263 , p7_a11 NUMBER := 0-1962.0724
264 , p7_a12 NUMBER := 0-1962.0724
265 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
266 , p7_a14 DATE := fnd_api.g_miss_date
267 , p7_a15 NUMBER := 0-1962.0724
268 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
269 , p7_a17 NUMBER := 0-1962.0724
270 , p7_a18 NUMBER := 0-1962.0724
271 , p7_a19 NUMBER := 0-1962.0724
272 , p7_a20 DATE := fnd_api.g_miss_date
273 , p7_a21 NUMBER := 0-1962.0724
274 , p7_a22 DATE := fnd_api.g_miss_date
275 , p7_a23 NUMBER := 0-1962.0724
276 , p7_a24 NUMBER := 0-1962.0724
277 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
278 , p7_a26 DATE := fnd_api.g_miss_date
279 , p7_a27 DATE := fnd_api.g_miss_date
280 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
281 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
282 , p7_a30 NUMBER := 0-1962.0724
283 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
284 , p7_a32 NUMBER := 0-1962.0724
285 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
286 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
287 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
288 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
289 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
290 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
291 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
292 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
293 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
294 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
295 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
296 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
297 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
298 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
299 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
300 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
301 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
302 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
303 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
304 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
305 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
306 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a55 NUMBER := 0-1962.0724
308 , p7_a56 NUMBER := 0-1962.0724
309 , p7_a57 NUMBER := 0-1962.0724
310 , p7_a58 NUMBER := 0-1962.0724
311 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
312 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
313 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
314 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
315 , p7_a63 NUMBER := 0-1962.0724
316 , p7_a64 NUMBER := 0-1962.0724
317 , p7_a65 NUMBER := 0-1962.0724
318 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
319 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
320 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
321 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
323 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
324 , p7_a72 NUMBER := 0-1962.0724
325 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
326 , p7_a74 NUMBER := 0-1962.0724
327 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
328 );
329 procedure update_import_list(p_api_version_number NUMBER
330 , p_init_msg_list VARCHAR2
331 , p_commit VARCHAR2
332 , p_validation_level NUMBER
333 , x_return_status out nocopy VARCHAR2
334 , x_msg_count out nocopy NUMBER
335 , x_msg_data out nocopy VARCHAR2
336 , x_object_version_number out nocopy NUMBER
337 , p7_a0 NUMBER := 0-1962.0724
338 , p7_a1 DATE := fnd_api.g_miss_date
339 , p7_a2 NUMBER := 0-1962.0724
340 , p7_a3 DATE := fnd_api.g_miss_date
341 , p7_a4 NUMBER := 0-1962.0724
342 , p7_a5 NUMBER := 0-1962.0724
343 , p7_a6 NUMBER := 0-1962.0724
344 , p7_a7 NUMBER := 0-1962.0724
345 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
346 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
347 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a11 NUMBER := 0-1962.0724
349 , p7_a12 NUMBER := 0-1962.0724
350 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a14 DATE := fnd_api.g_miss_date
352 , p7_a15 NUMBER := 0-1962.0724
353 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a17 NUMBER := 0-1962.0724
355 , p7_a18 NUMBER := 0-1962.0724
356 , p7_a19 NUMBER := 0-1962.0724
357 , p7_a20 DATE := fnd_api.g_miss_date
358 , p7_a21 NUMBER := 0-1962.0724
359 , p7_a22 DATE := fnd_api.g_miss_date
360 , p7_a23 NUMBER := 0-1962.0724
361 , p7_a24 NUMBER := 0-1962.0724
362 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
363 , p7_a26 DATE := fnd_api.g_miss_date
364 , p7_a27 DATE := fnd_api.g_miss_date
365 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a30 NUMBER := 0-1962.0724
368 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a32 NUMBER := 0-1962.0724
370 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
386 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
387 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
388 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
390 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
391 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a55 NUMBER := 0-1962.0724
393 , p7_a56 NUMBER := 0-1962.0724
394 , p7_a57 NUMBER := 0-1962.0724
395 , p7_a58 NUMBER := 0-1962.0724
396 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
397 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
398 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
399 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
400 , p7_a63 NUMBER := 0-1962.0724
401 , p7_a64 NUMBER := 0-1962.0724
402 , p7_a65 NUMBER := 0-1962.0724
403 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
404 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
406 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
409 , p7_a72 NUMBER := 0-1962.0724
410 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a74 NUMBER := 0-1962.0724
412 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
413 );
414 procedure validate_import_list(p_api_version_number NUMBER
415 , p_init_msg_list VARCHAR2
416 , p_validation_level NUMBER
417 , x_return_status out nocopy VARCHAR2
418 , x_msg_count out nocopy NUMBER
419 , x_msg_data out nocopy VARCHAR2
420 , p3_a0 NUMBER := 0-1962.0724
421 , p3_a1 DATE := fnd_api.g_miss_date
422 , p3_a2 NUMBER := 0-1962.0724
423 , p3_a3 DATE := fnd_api.g_miss_date
424 , p3_a4 NUMBER := 0-1962.0724
425 , p3_a5 NUMBER := 0-1962.0724
426 , p3_a6 NUMBER := 0-1962.0724
427 , p3_a7 NUMBER := 0-1962.0724
428 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
429 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
430 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
431 , p3_a11 NUMBER := 0-1962.0724
432 , p3_a12 NUMBER := 0-1962.0724
433 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
434 , p3_a14 DATE := fnd_api.g_miss_date
435 , p3_a15 NUMBER := 0-1962.0724
436 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
437 , p3_a17 NUMBER := 0-1962.0724
438 , p3_a18 NUMBER := 0-1962.0724
439 , p3_a19 NUMBER := 0-1962.0724
440 , p3_a20 DATE := fnd_api.g_miss_date
441 , p3_a21 NUMBER := 0-1962.0724
442 , p3_a22 DATE := fnd_api.g_miss_date
443 , p3_a23 NUMBER := 0-1962.0724
444 , p3_a24 NUMBER := 0-1962.0724
445 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
446 , p3_a26 DATE := fnd_api.g_miss_date
447 , p3_a27 DATE := fnd_api.g_miss_date
448 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
449 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
450 , p3_a30 NUMBER := 0-1962.0724
451 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
452 , p3_a32 NUMBER := 0-1962.0724
453 , p3_a33 VARCHAR2 := fnd_api.g_miss_char
454 , p3_a34 VARCHAR2 := fnd_api.g_miss_char
455 , p3_a35 VARCHAR2 := fnd_api.g_miss_char
456 , p3_a36 VARCHAR2 := fnd_api.g_miss_char
457 , p3_a37 VARCHAR2 := fnd_api.g_miss_char
458 , p3_a38 VARCHAR2 := fnd_api.g_miss_char
459 , p3_a39 VARCHAR2 := fnd_api.g_miss_char
460 , p3_a40 VARCHAR2 := fnd_api.g_miss_char
461 , p3_a41 VARCHAR2 := fnd_api.g_miss_char
462 , p3_a42 VARCHAR2 := fnd_api.g_miss_char
463 , p3_a43 VARCHAR2 := fnd_api.g_miss_char
464 , p3_a44 VARCHAR2 := fnd_api.g_miss_char
465 , p3_a45 VARCHAR2 := fnd_api.g_miss_char
466 , p3_a46 VARCHAR2 := fnd_api.g_miss_char
467 , p3_a47 VARCHAR2 := fnd_api.g_miss_char
468 , p3_a48 VARCHAR2 := fnd_api.g_miss_char
469 , p3_a49 VARCHAR2 := fnd_api.g_miss_char
470 , p3_a50 VARCHAR2 := fnd_api.g_miss_char
471 , p3_a51 VARCHAR2 := fnd_api.g_miss_char
472 , p3_a52 VARCHAR2 := fnd_api.g_miss_char
473 , p3_a53 VARCHAR2 := fnd_api.g_miss_char
474 , p3_a54 VARCHAR2 := fnd_api.g_miss_char
475 , p3_a55 NUMBER := 0-1962.0724
476 , p3_a56 NUMBER := 0-1962.0724
477 , p3_a57 NUMBER := 0-1962.0724
478 , p3_a58 NUMBER := 0-1962.0724
479 , p3_a59 VARCHAR2 := fnd_api.g_miss_char
480 , p3_a60 VARCHAR2 := fnd_api.g_miss_char
481 , p3_a61 VARCHAR2 := fnd_api.g_miss_char
482 , p3_a62 VARCHAR2 := fnd_api.g_miss_char
483 , p3_a63 NUMBER := 0-1962.0724
484 , p3_a64 NUMBER := 0-1962.0724
485 , p3_a65 NUMBER := 0-1962.0724
486 , p3_a66 VARCHAR2 := fnd_api.g_miss_char
487 , p3_a67 VARCHAR2 := fnd_api.g_miss_char
488 , p3_a68 VARCHAR2 := fnd_api.g_miss_char
489 , p3_a69 VARCHAR2 := fnd_api.g_miss_char
490 , p3_a70 VARCHAR2 := fnd_api.g_miss_char
491 , p3_a71 VARCHAR2 := fnd_api.g_miss_char
492 , p3_a72 NUMBER := 0-1962.0724
493 , p3_a73 VARCHAR2 := fnd_api.g_miss_char
494 , p3_a74 NUMBER := 0-1962.0724
495 , p3_a75 VARCHAR2 := fnd_api.g_miss_char
496 );
497 procedure check_ams_import_items(p_validation_mode VARCHAR2
498 , x_return_status out nocopy VARCHAR2
499 , p0_a0 NUMBER := 0-1962.0724
500 , p0_a1 DATE := fnd_api.g_miss_date
501 , p0_a2 NUMBER := 0-1962.0724
502 , p0_a3 DATE := fnd_api.g_miss_date
503 , p0_a4 NUMBER := 0-1962.0724
504 , p0_a5 NUMBER := 0-1962.0724
505 , p0_a6 NUMBER := 0-1962.0724
506 , p0_a7 NUMBER := 0-1962.0724
507 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
508 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
509 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
510 , p0_a11 NUMBER := 0-1962.0724
511 , p0_a12 NUMBER := 0-1962.0724
512 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
513 , p0_a14 DATE := fnd_api.g_miss_date
514 , p0_a15 NUMBER := 0-1962.0724
515 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
516 , p0_a17 NUMBER := 0-1962.0724
517 , p0_a18 NUMBER := 0-1962.0724
518 , p0_a19 NUMBER := 0-1962.0724
519 , p0_a20 DATE := fnd_api.g_miss_date
520 , p0_a21 NUMBER := 0-1962.0724
521 , p0_a22 DATE := fnd_api.g_miss_date
522 , p0_a23 NUMBER := 0-1962.0724
523 , p0_a24 NUMBER := 0-1962.0724
524 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
525 , p0_a26 DATE := fnd_api.g_miss_date
526 , p0_a27 DATE := fnd_api.g_miss_date
527 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
528 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
529 , p0_a30 NUMBER := 0-1962.0724
530 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
531 , p0_a32 NUMBER := 0-1962.0724
532 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
533 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
534 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
535 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
536 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
537 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
538 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
539 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
540 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
541 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
542 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
543 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
544 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
545 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
546 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
547 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
548 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
549 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
550 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
551 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
552 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
553 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
554 , p0_a55 NUMBER := 0-1962.0724
555 , p0_a56 NUMBER := 0-1962.0724
556 , p0_a57 NUMBER := 0-1962.0724
557 , p0_a58 NUMBER := 0-1962.0724
558 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
559 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
560 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
561 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
562 , p0_a63 NUMBER := 0-1962.0724
563 , p0_a64 NUMBER := 0-1962.0724
564 , p0_a65 NUMBER := 0-1962.0724
565 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
566 , p0_a67 VARCHAR2 := fnd_api.g_miss_char
567 , p0_a68 VARCHAR2 := fnd_api.g_miss_char
568 , p0_a69 VARCHAR2 := fnd_api.g_miss_char
569 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
570 , p0_a71 VARCHAR2 := fnd_api.g_miss_char
571 , p0_a72 NUMBER := 0-1962.0724
572 , p0_a73 VARCHAR2 := fnd_api.g_miss_char
573 , p0_a74 NUMBER := 0-1962.0724
574 , p0_a75 VARCHAR2 := fnd_api.g_miss_char
575 );
576 procedure validate_ams_import_rec(p_api_version_number NUMBER
577 , p_init_msg_list VARCHAR2
578 , x_return_status out nocopy VARCHAR2
579 , x_msg_count out nocopy NUMBER
580 , x_msg_data out nocopy VARCHAR2
581 , p5_a0 NUMBER := 0-1962.0724
582 , p5_a1 DATE := fnd_api.g_miss_date
583 , p5_a2 NUMBER := 0-1962.0724
584 , p5_a3 DATE := fnd_api.g_miss_date
585 , p5_a4 NUMBER := 0-1962.0724
586 , p5_a5 NUMBER := 0-1962.0724
587 , p5_a6 NUMBER := 0-1962.0724
588 , p5_a7 NUMBER := 0-1962.0724
589 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
590 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
591 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
592 , p5_a11 NUMBER := 0-1962.0724
593 , p5_a12 NUMBER := 0-1962.0724
594 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
595 , p5_a14 DATE := fnd_api.g_miss_date
596 , p5_a15 NUMBER := 0-1962.0724
597 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a17 NUMBER := 0-1962.0724
599 , p5_a18 NUMBER := 0-1962.0724
600 , p5_a19 NUMBER := 0-1962.0724
601 , p5_a20 DATE := fnd_api.g_miss_date
602 , p5_a21 NUMBER := 0-1962.0724
603 , p5_a22 DATE := fnd_api.g_miss_date
604 , p5_a23 NUMBER := 0-1962.0724
605 , p5_a24 NUMBER := 0-1962.0724
606 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a26 DATE := fnd_api.g_miss_date
608 , p5_a27 DATE := fnd_api.g_miss_date
609 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a30 NUMBER := 0-1962.0724
612 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a32 NUMBER := 0-1962.0724
614 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
621 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
623 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
624 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
625 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
626 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
627 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
628 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
629 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
630 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
631 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
632 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
633 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
634 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
635 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a55 NUMBER := 0-1962.0724
637 , p5_a56 NUMBER := 0-1962.0724
638 , p5_a57 NUMBER := 0-1962.0724
639 , p5_a58 NUMBER := 0-1962.0724
640 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
641 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
643 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a63 NUMBER := 0-1962.0724
645 , p5_a64 NUMBER := 0-1962.0724
646 , p5_a65 NUMBER := 0-1962.0724
647 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
648 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
649 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
650 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
651 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
652 , p5_a71 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a72 NUMBER := 0-1962.0724
654 , p5_a73 VARCHAR2 := fnd_api.g_miss_char
655 , p5_a74 NUMBER := 0-1962.0724
656 , p5_a75 VARCHAR2 := fnd_api.g_miss_char
657 );
658 end ams_import_list_pvt_w;