5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
280: , x_msg_count out nocopy NUMBER
281: , x_msg_data out nocopy VARCHAR2
282: , x_contact_point_id out nocopy NUMBER
283: , p7_a0 NUMBER := 0-1962.0724
284: , p7_a1 DATE := fnd_api.g_miss_date
285: , p7_a2 NUMBER := 0-1962.0724
286: , p7_a3 DATE := fnd_api.g_miss_date
287: , p7_a4 NUMBER := 0-1962.0724
288: , p7_a5 NUMBER := 0-1962.0724
282: , x_contact_point_id out nocopy NUMBER
283: , p7_a0 NUMBER := 0-1962.0724
284: , p7_a1 DATE := fnd_api.g_miss_date
285: , p7_a2 NUMBER := 0-1962.0724
286: , p7_a3 DATE := fnd_api.g_miss_date
287: , p7_a4 NUMBER := 0-1962.0724
288: , p7_a5 NUMBER := 0-1962.0724
289: , p7_a6 NUMBER := 0-1962.0724
290: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a3 DATE := fnd_api.g_miss_date
287: , p7_a4 NUMBER := 0-1962.0724
288: , p7_a5 NUMBER := 0-1962.0724
289: , p7_a6 NUMBER := 0-1962.0724
290: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a8 NUMBER := 0-1962.0724
292: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a5 NUMBER := 0-1962.0724
289: , p7_a6 NUMBER := 0-1962.0724
290: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a8 NUMBER := 0-1962.0724
292: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
289: , p7_a6 NUMBER := 0-1962.0724
290: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a8 NUMBER := 0-1962.0724
292: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a8 NUMBER := 0-1962.0724
292: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a12 NUMBER := 0-1962.0724
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a30 NUMBER := 0-1962.0724
306: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a30 NUMBER := 0-1962.0724
314: )
307: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a30 NUMBER := 0-1962.0724
314: )
315:
308: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a30 NUMBER := 0-1962.0724
314: )
315:
316: as
389: , x_msg_count out nocopy NUMBER
390: , x_msg_data out nocopy VARCHAR2
391: , x_object_version_number out nocopy NUMBER
392: , p7_a0 NUMBER := 0-1962.0724
393: , p7_a1 DATE := fnd_api.g_miss_date
394: , p7_a2 NUMBER := 0-1962.0724
395: , p7_a3 DATE := fnd_api.g_miss_date
396: , p7_a4 NUMBER := 0-1962.0724
397: , p7_a5 NUMBER := 0-1962.0724
391: , x_object_version_number out nocopy NUMBER
392: , p7_a0 NUMBER := 0-1962.0724
393: , p7_a1 DATE := fnd_api.g_miss_date
394: , p7_a2 NUMBER := 0-1962.0724
395: , p7_a3 DATE := fnd_api.g_miss_date
396: , p7_a4 NUMBER := 0-1962.0724
397: , p7_a5 NUMBER := 0-1962.0724
398: , p7_a6 NUMBER := 0-1962.0724
399: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a3 DATE := fnd_api.g_miss_date
396: , p7_a4 NUMBER := 0-1962.0724
397: , p7_a5 NUMBER := 0-1962.0724
398: , p7_a6 NUMBER := 0-1962.0724
399: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
400: , p7_a8 NUMBER := 0-1962.0724
401: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
397: , p7_a5 NUMBER := 0-1962.0724
398: , p7_a6 NUMBER := 0-1962.0724
399: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
400: , p7_a8 NUMBER := 0-1962.0724
401: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
398: , p7_a6 NUMBER := 0-1962.0724
399: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
400: , p7_a8 NUMBER := 0-1962.0724
401: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
399: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
400: , p7_a8 NUMBER := 0-1962.0724
401: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
401: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
402: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
403: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
404: , p7_a12 NUMBER := 0-1962.0724
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
405: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
406: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
407: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
408: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
409: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
410: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
411: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
412: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
413: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
422: , p7_a30 NUMBER := 0-1962.0724
415: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
422: , p7_a30 NUMBER := 0-1962.0724
423: )
416: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
422: , p7_a30 NUMBER := 0-1962.0724
423: )
424:
417: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
422: , p7_a30 NUMBER := 0-1962.0724
423: )
424:
425: as
497: , x_return_status out nocopy VARCHAR2
498: , x_msg_count out nocopy NUMBER
499: , x_msg_data out nocopy VARCHAR2
500: , p4_a0 NUMBER := 0-1962.0724
501: , p4_a1 DATE := fnd_api.g_miss_date
502: , p4_a2 NUMBER := 0-1962.0724
503: , p4_a3 DATE := fnd_api.g_miss_date
504: , p4_a4 NUMBER := 0-1962.0724
505: , p4_a5 NUMBER := 0-1962.0724
499: , x_msg_data out nocopy VARCHAR2
500: , p4_a0 NUMBER := 0-1962.0724
501: , p4_a1 DATE := fnd_api.g_miss_date
502: , p4_a2 NUMBER := 0-1962.0724
503: , p4_a3 DATE := fnd_api.g_miss_date
504: , p4_a4 NUMBER := 0-1962.0724
505: , p4_a5 NUMBER := 0-1962.0724
506: , p4_a6 NUMBER := 0-1962.0724
507: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
503: , p4_a3 DATE := fnd_api.g_miss_date
504: , p4_a4 NUMBER := 0-1962.0724
505: , p4_a5 NUMBER := 0-1962.0724
506: , p4_a6 NUMBER := 0-1962.0724
507: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
508: , p4_a8 NUMBER := 0-1962.0724
509: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
505: , p4_a5 NUMBER := 0-1962.0724
506: , p4_a6 NUMBER := 0-1962.0724
507: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
508: , p4_a8 NUMBER := 0-1962.0724
509: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
506: , p4_a6 NUMBER := 0-1962.0724
507: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
508: , p4_a8 NUMBER := 0-1962.0724
509: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
507: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
508: , p4_a8 NUMBER := 0-1962.0724
509: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
509: , p4_a9 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
510: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
511: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
512: , p4_a12 NUMBER := 0-1962.0724
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
513: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
514: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
515: , p4_a15 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
516: , p4_a16 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
517: , p4_a17 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
518: , p4_a18 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
519: , p4_a19 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
520: , p4_a20 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
521: , p4_a21 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
529: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
522: , p4_a22 VARCHAR2 := fnd_api.g_miss_char
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
529: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
530: , p4_a30 NUMBER := 0-1962.0724
523: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
529: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
530: , p4_a30 NUMBER := 0-1962.0724
531: )
524: , p4_a24 VARCHAR2 := fnd_api.g_miss_char
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
529: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
530: , p4_a30 NUMBER := 0-1962.0724
531: )
532:
525: , p4_a25 VARCHAR2 := fnd_api.g_miss_char
526: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
527: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
528: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
529: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
530: , p4_a30 NUMBER := 0-1962.0724
531: )
532:
533: as
597:
598: procedure check_cnt_point_items(p_validation_mode VARCHAR2
599: , x_return_status out nocopy VARCHAR2
600: , p0_a0 NUMBER := 0-1962.0724
601: , p0_a1 DATE := fnd_api.g_miss_date
602: , p0_a2 NUMBER := 0-1962.0724
603: , p0_a3 DATE := fnd_api.g_miss_date
604: , p0_a4 NUMBER := 0-1962.0724
605: , p0_a5 NUMBER := 0-1962.0724
599: , x_return_status out nocopy VARCHAR2
600: , p0_a0 NUMBER := 0-1962.0724
601: , p0_a1 DATE := fnd_api.g_miss_date
602: , p0_a2 NUMBER := 0-1962.0724
603: , p0_a3 DATE := fnd_api.g_miss_date
604: , p0_a4 NUMBER := 0-1962.0724
605: , p0_a5 NUMBER := 0-1962.0724
606: , p0_a6 NUMBER := 0-1962.0724
607: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a3 DATE := fnd_api.g_miss_date
604: , p0_a4 NUMBER := 0-1962.0724
605: , p0_a5 NUMBER := 0-1962.0724
606: , p0_a6 NUMBER := 0-1962.0724
607: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a8 NUMBER := 0-1962.0724
609: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a5 NUMBER := 0-1962.0724
606: , p0_a6 NUMBER := 0-1962.0724
607: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a8 NUMBER := 0-1962.0724
609: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a6 NUMBER := 0-1962.0724
607: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a8 NUMBER := 0-1962.0724
609: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a8 NUMBER := 0-1962.0724
609: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a12 NUMBER := 0-1962.0724
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
618: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
619: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
620: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
621: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
629: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
622: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
629: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
630: , p0_a30 NUMBER := 0-1962.0724
623: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
629: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
630: , p0_a30 NUMBER := 0-1962.0724
631: )
624: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
629: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
630: , p0_a30 NUMBER := 0-1962.0724
631: )
632:
625: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
626: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
627: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
628: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
629: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
630: , p0_a30 NUMBER := 0-1962.0724
631: )
632:
633: as
686: , x_return_status out nocopy VARCHAR2
687: , x_msg_count out nocopy NUMBER
688: , x_msg_data out nocopy VARCHAR2
689: , p6_a0 NUMBER := 0-1962.0724
690: , p6_a1 DATE := fnd_api.g_miss_date
691: , p6_a2 NUMBER := 0-1962.0724
692: , p6_a3 DATE := fnd_api.g_miss_date
693: , p6_a4 NUMBER := 0-1962.0724
694: , p6_a5 NUMBER := 0-1962.0724
688: , x_msg_data out nocopy VARCHAR2
689: , p6_a0 NUMBER := 0-1962.0724
690: , p6_a1 DATE := fnd_api.g_miss_date
691: , p6_a2 NUMBER := 0-1962.0724
692: , p6_a3 DATE := fnd_api.g_miss_date
693: , p6_a4 NUMBER := 0-1962.0724
694: , p6_a5 NUMBER := 0-1962.0724
695: , p6_a6 NUMBER := 0-1962.0724
696: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
692: , p6_a3 DATE := fnd_api.g_miss_date
693: , p6_a4 NUMBER := 0-1962.0724
694: , p6_a5 NUMBER := 0-1962.0724
695: , p6_a6 NUMBER := 0-1962.0724
696: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
697: , p6_a8 NUMBER := 0-1962.0724
698: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
694: , p6_a5 NUMBER := 0-1962.0724
695: , p6_a6 NUMBER := 0-1962.0724
696: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
697: , p6_a8 NUMBER := 0-1962.0724
698: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
695: , p6_a6 NUMBER := 0-1962.0724
696: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
697: , p6_a8 NUMBER := 0-1962.0724
698: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
696: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
697: , p6_a8 NUMBER := 0-1962.0724
698: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
698: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
699: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
700: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
701: , p6_a12 NUMBER := 0-1962.0724
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
702: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
703: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
704: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
705: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
706: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
707: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
708: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
709: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
710: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
718: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
711: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
718: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
719: , p6_a30 NUMBER := 0-1962.0724
712: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
718: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
719: , p6_a30 NUMBER := 0-1962.0724
720: )
713: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
718: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
719: , p6_a30 NUMBER := 0-1962.0724
720: )
721:
714: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
715: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
716: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
717: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
718: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
719: , p6_a30 NUMBER := 0-1962.0724
720: )
721:
722: as