3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;
14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_tbl_type, a0 JTF_NUMBER_TABLE
386:
387: procedure check_score_items(p_validation_mode VARCHAR2
388: , x_return_status OUT NOCOPY VARCHAR2
389: , p0_a0 NUMBER := 0-1962.0724
390: , p0_a1 DATE := fnd_api.g_miss_date
391: , p0_a2 NUMBER := 0-1962.0724
392: , p0_a3 DATE := fnd_api.g_miss_date
393: , p0_a4 NUMBER := 0-1962.0724
394: , p0_a5 NUMBER := 0-1962.0724
388: , x_return_status OUT NOCOPY VARCHAR2
389: , p0_a0 NUMBER := 0-1962.0724
390: , p0_a1 DATE := fnd_api.g_miss_date
391: , p0_a2 NUMBER := 0-1962.0724
392: , p0_a3 DATE := fnd_api.g_miss_date
393: , p0_a4 NUMBER := 0-1962.0724
394: , p0_a5 NUMBER := 0-1962.0724
395: , p0_a6 NUMBER := 0-1962.0724
396: , p0_a7 NUMBER := 0-1962.0724
395: , p0_a6 NUMBER := 0-1962.0724
396: , p0_a7 NUMBER := 0-1962.0724
397: , p0_a8 NUMBER := 0-1962.0724
398: , p0_a9 NUMBER := 0-1962.0724
399: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
400: , p0_a11 DATE := fnd_api.g_miss_date
401: , p0_a12 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
396: , p0_a7 NUMBER := 0-1962.0724
397: , p0_a8 NUMBER := 0-1962.0724
398: , p0_a9 NUMBER := 0-1962.0724
399: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
400: , p0_a11 DATE := fnd_api.g_miss_date
401: , p0_a12 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
398: , p0_a9 NUMBER := 0-1962.0724
399: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
400: , p0_a11 DATE := fnd_api.g_miss_date
401: , p0_a12 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
405: , p0_a16 NUMBER := 0-1962.0724
406: , p0_a17 DATE := fnd_api.g_miss_date
399: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
400: , p0_a11 DATE := fnd_api.g_miss_date
401: , p0_a12 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
405: , p0_a16 NUMBER := 0-1962.0724
406: , p0_a17 DATE := fnd_api.g_miss_date
407: , p0_a18 DATE := fnd_api.g_miss_date
400: , p0_a11 DATE := fnd_api.g_miss_date
401: , p0_a12 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
405: , p0_a16 NUMBER := 0-1962.0724
406: , p0_a17 DATE := fnd_api.g_miss_date
407: , p0_a18 DATE := fnd_api.g_miss_date
408: , p0_a19 NUMBER := 0-1962.0724
402: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
405: , p0_a16 NUMBER := 0-1962.0724
406: , p0_a17 DATE := fnd_api.g_miss_date
407: , p0_a18 DATE := fnd_api.g_miss_date
408: , p0_a19 NUMBER := 0-1962.0724
409: , p0_a20 NUMBER := 0-1962.0724
410: , p0_a21 NUMBER := 0-1962.0724
403: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
404: , p0_a15 DATE := fnd_api.g_miss_date
405: , p0_a16 NUMBER := 0-1962.0724
406: , p0_a17 DATE := fnd_api.g_miss_date
407: , p0_a18 DATE := fnd_api.g_miss_date
408: , p0_a19 NUMBER := 0-1962.0724
409: , p0_a20 NUMBER := 0-1962.0724
410: , p0_a21 NUMBER := 0-1962.0724
411: , p0_a22 NUMBER := 0-1962.0724
408: , p0_a19 NUMBER := 0-1962.0724
409: , p0_a20 NUMBER := 0-1962.0724
410: , p0_a21 NUMBER := 0-1962.0724
411: , p0_a22 NUMBER := 0-1962.0724
412: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
413: , p0_a24 NUMBER := 0-1962.0724
414: , p0_a25 NUMBER := 0-1962.0724
415: , p0_a26 NUMBER := 0-1962.0724
416: , p0_a27 NUMBER := 0-1962.0724
413: , p0_a24 NUMBER := 0-1962.0724
414: , p0_a25 NUMBER := 0-1962.0724
415: , p0_a26 NUMBER := 0-1962.0724
416: , p0_a27 NUMBER := 0-1962.0724
417: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
414: , p0_a25 NUMBER := 0-1962.0724
415: , p0_a26 NUMBER := 0-1962.0724
416: , p0_a27 NUMBER := 0-1962.0724
417: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
415: , p0_a26 NUMBER := 0-1962.0724
416: , p0_a27 NUMBER := 0-1962.0724
417: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
416: , p0_a27 NUMBER := 0-1962.0724
417: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a33 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a34 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a35 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a36 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a37 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a38 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a39 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436: )
429: , p0_a40 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436: )
437: as
430: , p0_a41 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436: )
437: as
438: ddp_score_rec ams_dm_score_pvt.score_rec_type;
431: , p0_a42 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a43 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a44 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436: )
437: as
438: ddp_score_rec ams_dm_score_pvt.score_rec_type;
439: ddindx binary_integer; indx binary_integer;
509: , x_msg_data OUT NOCOPY VARCHAR2
510: , x_custom_setup_id OUT NOCOPY NUMBER
511: , x_score_id OUT NOCOPY NUMBER
512: , p7_a0 NUMBER := 0-1962.0724
513: , p7_a1 DATE := fnd_api.g_miss_date
514: , p7_a2 NUMBER := 0-1962.0724
515: , p7_a3 DATE := fnd_api.g_miss_date
516: , p7_a4 NUMBER := 0-1962.0724
517: , p7_a5 NUMBER := 0-1962.0724
511: , x_score_id OUT NOCOPY NUMBER
512: , p7_a0 NUMBER := 0-1962.0724
513: , p7_a1 DATE := fnd_api.g_miss_date
514: , p7_a2 NUMBER := 0-1962.0724
515: , p7_a3 DATE := fnd_api.g_miss_date
516: , p7_a4 NUMBER := 0-1962.0724
517: , p7_a5 NUMBER := 0-1962.0724
518: , p7_a6 NUMBER := 0-1962.0724
519: , p7_a7 NUMBER := 0-1962.0724
518: , p7_a6 NUMBER := 0-1962.0724
519: , p7_a7 NUMBER := 0-1962.0724
520: , p7_a8 NUMBER := 0-1962.0724
521: , p7_a9 NUMBER := 0-1962.0724
522: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
523: , p7_a11 DATE := fnd_api.g_miss_date
524: , p7_a12 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
519: , p7_a7 NUMBER := 0-1962.0724
520: , p7_a8 NUMBER := 0-1962.0724
521: , p7_a9 NUMBER := 0-1962.0724
522: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
523: , p7_a11 DATE := fnd_api.g_miss_date
524: , p7_a12 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
521: , p7_a9 NUMBER := 0-1962.0724
522: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
523: , p7_a11 DATE := fnd_api.g_miss_date
524: , p7_a12 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
528: , p7_a16 NUMBER := 0-1962.0724
529: , p7_a17 DATE := fnd_api.g_miss_date
522: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
523: , p7_a11 DATE := fnd_api.g_miss_date
524: , p7_a12 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
528: , p7_a16 NUMBER := 0-1962.0724
529: , p7_a17 DATE := fnd_api.g_miss_date
530: , p7_a18 DATE := fnd_api.g_miss_date
523: , p7_a11 DATE := fnd_api.g_miss_date
524: , p7_a12 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
528: , p7_a16 NUMBER := 0-1962.0724
529: , p7_a17 DATE := fnd_api.g_miss_date
530: , p7_a18 DATE := fnd_api.g_miss_date
531: , p7_a19 NUMBER := 0-1962.0724
525: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
528: , p7_a16 NUMBER := 0-1962.0724
529: , p7_a17 DATE := fnd_api.g_miss_date
530: , p7_a18 DATE := fnd_api.g_miss_date
531: , p7_a19 NUMBER := 0-1962.0724
532: , p7_a20 NUMBER := 0-1962.0724
533: , p7_a21 NUMBER := 0-1962.0724
526: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a15 DATE := fnd_api.g_miss_date
528: , p7_a16 NUMBER := 0-1962.0724
529: , p7_a17 DATE := fnd_api.g_miss_date
530: , p7_a18 DATE := fnd_api.g_miss_date
531: , p7_a19 NUMBER := 0-1962.0724
532: , p7_a20 NUMBER := 0-1962.0724
533: , p7_a21 NUMBER := 0-1962.0724
534: , p7_a22 NUMBER := 0-1962.0724
531: , p7_a19 NUMBER := 0-1962.0724
532: , p7_a20 NUMBER := 0-1962.0724
533: , p7_a21 NUMBER := 0-1962.0724
534: , p7_a22 NUMBER := 0-1962.0724
535: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
536: , p7_a24 NUMBER := 0-1962.0724
537: , p7_a25 NUMBER := 0-1962.0724
538: , p7_a26 NUMBER := 0-1962.0724
539: , p7_a27 NUMBER := 0-1962.0724
536: , p7_a24 NUMBER := 0-1962.0724
537: , p7_a25 NUMBER := 0-1962.0724
538: , p7_a26 NUMBER := 0-1962.0724
539: , p7_a27 NUMBER := 0-1962.0724
540: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
537: , p7_a25 NUMBER := 0-1962.0724
538: , p7_a26 NUMBER := 0-1962.0724
539: , p7_a27 NUMBER := 0-1962.0724
540: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
538: , p7_a26 NUMBER := 0-1962.0724
539: , p7_a27 NUMBER := 0-1962.0724
540: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
539: , p7_a27 NUMBER := 0-1962.0724
540: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
540: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
541: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
542: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
543: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
546: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
547: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
548: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
549: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
550: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
551: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559: )
552: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559: )
560: as
553: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559: )
560: as
561: ddp_score_rec ams_dm_score_pvt.score_rec_type;
554: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
555: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
556: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559: )
560: as
561: ddp_score_rec ams_dm_score_pvt.score_rec_type;
562: ddindx binary_integer; indx binary_integer;
652: , x_msg_count OUT NOCOPY NUMBER
653: , x_msg_data OUT NOCOPY VARCHAR2
654: , x_object_version_number OUT NOCOPY NUMBER
655: , p7_a0 NUMBER := 0-1962.0724
656: , p7_a1 DATE := fnd_api.g_miss_date
657: , p7_a2 NUMBER := 0-1962.0724
658: , p7_a3 DATE := fnd_api.g_miss_date
659: , p7_a4 NUMBER := 0-1962.0724
660: , p7_a5 NUMBER := 0-1962.0724
654: , x_object_version_number OUT NOCOPY NUMBER
655: , p7_a0 NUMBER := 0-1962.0724
656: , p7_a1 DATE := fnd_api.g_miss_date
657: , p7_a2 NUMBER := 0-1962.0724
658: , p7_a3 DATE := fnd_api.g_miss_date
659: , p7_a4 NUMBER := 0-1962.0724
660: , p7_a5 NUMBER := 0-1962.0724
661: , p7_a6 NUMBER := 0-1962.0724
662: , p7_a7 NUMBER := 0-1962.0724
661: , p7_a6 NUMBER := 0-1962.0724
662: , p7_a7 NUMBER := 0-1962.0724
663: , p7_a8 NUMBER := 0-1962.0724
664: , p7_a9 NUMBER := 0-1962.0724
665: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a11 DATE := fnd_api.g_miss_date
667: , p7_a12 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
662: , p7_a7 NUMBER := 0-1962.0724
663: , p7_a8 NUMBER := 0-1962.0724
664: , p7_a9 NUMBER := 0-1962.0724
665: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a11 DATE := fnd_api.g_miss_date
667: , p7_a12 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
664: , p7_a9 NUMBER := 0-1962.0724
665: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a11 DATE := fnd_api.g_miss_date
667: , p7_a12 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
671: , p7_a16 NUMBER := 0-1962.0724
672: , p7_a17 DATE := fnd_api.g_miss_date
665: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
666: , p7_a11 DATE := fnd_api.g_miss_date
667: , p7_a12 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
671: , p7_a16 NUMBER := 0-1962.0724
672: , p7_a17 DATE := fnd_api.g_miss_date
673: , p7_a18 DATE := fnd_api.g_miss_date
666: , p7_a11 DATE := fnd_api.g_miss_date
667: , p7_a12 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
671: , p7_a16 NUMBER := 0-1962.0724
672: , p7_a17 DATE := fnd_api.g_miss_date
673: , p7_a18 DATE := fnd_api.g_miss_date
674: , p7_a19 NUMBER := 0-1962.0724
668: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
671: , p7_a16 NUMBER := 0-1962.0724
672: , p7_a17 DATE := fnd_api.g_miss_date
673: , p7_a18 DATE := fnd_api.g_miss_date
674: , p7_a19 NUMBER := 0-1962.0724
675: , p7_a20 NUMBER := 0-1962.0724
676: , p7_a21 NUMBER := 0-1962.0724
669: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
670: , p7_a15 DATE := fnd_api.g_miss_date
671: , p7_a16 NUMBER := 0-1962.0724
672: , p7_a17 DATE := fnd_api.g_miss_date
673: , p7_a18 DATE := fnd_api.g_miss_date
674: , p7_a19 NUMBER := 0-1962.0724
675: , p7_a20 NUMBER := 0-1962.0724
676: , p7_a21 NUMBER := 0-1962.0724
677: , p7_a22 NUMBER := 0-1962.0724
674: , p7_a19 NUMBER := 0-1962.0724
675: , p7_a20 NUMBER := 0-1962.0724
676: , p7_a21 NUMBER := 0-1962.0724
677: , p7_a22 NUMBER := 0-1962.0724
678: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a24 NUMBER := 0-1962.0724
680: , p7_a25 NUMBER := 0-1962.0724
681: , p7_a26 NUMBER := 0-1962.0724
682: , p7_a27 NUMBER := 0-1962.0724
679: , p7_a24 NUMBER := 0-1962.0724
680: , p7_a25 NUMBER := 0-1962.0724
681: , p7_a26 NUMBER := 0-1962.0724
682: , p7_a27 NUMBER := 0-1962.0724
683: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
680: , p7_a25 NUMBER := 0-1962.0724
681: , p7_a26 NUMBER := 0-1962.0724
682: , p7_a27 NUMBER := 0-1962.0724
683: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
681: , p7_a26 NUMBER := 0-1962.0724
682: , p7_a27 NUMBER := 0-1962.0724
683: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
682: , p7_a27 NUMBER := 0-1962.0724
683: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
683: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
684: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
685: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
686: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
687: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
688: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
689: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
690: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
691: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
692: , p7_a37 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
693: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
694: , p7_a39 VARCHAR2 := fnd_api.g_miss_char
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702: )
695: , p7_a40 VARCHAR2 := fnd_api.g_miss_char
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702: )
703: as
696: , p7_a41 VARCHAR2 := fnd_api.g_miss_char
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702: )
703: as
704: ddp_score_rec ams_dm_score_pvt.score_rec_type;
697: , p7_a42 VARCHAR2 := fnd_api.g_miss_char
698: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
699: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702: )
703: as
704: ddp_score_rec ams_dm_score_pvt.score_rec_type;
705: ddindx binary_integer; indx binary_integer;
790: , x_return_status OUT NOCOPY VARCHAR2
791: , x_msg_count OUT NOCOPY NUMBER
792: , x_msg_data OUT NOCOPY VARCHAR2
793: , p6_a0 NUMBER := 0-1962.0724
794: , p6_a1 DATE := fnd_api.g_miss_date
795: , p6_a2 NUMBER := 0-1962.0724
796: , p6_a3 DATE := fnd_api.g_miss_date
797: , p6_a4 NUMBER := 0-1962.0724
798: , p6_a5 NUMBER := 0-1962.0724
792: , x_msg_data OUT NOCOPY VARCHAR2
793: , p6_a0 NUMBER := 0-1962.0724
794: , p6_a1 DATE := fnd_api.g_miss_date
795: , p6_a2 NUMBER := 0-1962.0724
796: , p6_a3 DATE := fnd_api.g_miss_date
797: , p6_a4 NUMBER := 0-1962.0724
798: , p6_a5 NUMBER := 0-1962.0724
799: , p6_a6 NUMBER := 0-1962.0724
800: , p6_a7 NUMBER := 0-1962.0724
799: , p6_a6 NUMBER := 0-1962.0724
800: , p6_a7 NUMBER := 0-1962.0724
801: , p6_a8 NUMBER := 0-1962.0724
802: , p6_a9 NUMBER := 0-1962.0724
803: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
804: , p6_a11 DATE := fnd_api.g_miss_date
805: , p6_a12 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
800: , p6_a7 NUMBER := 0-1962.0724
801: , p6_a8 NUMBER := 0-1962.0724
802: , p6_a9 NUMBER := 0-1962.0724
803: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
804: , p6_a11 DATE := fnd_api.g_miss_date
805: , p6_a12 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
802: , p6_a9 NUMBER := 0-1962.0724
803: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
804: , p6_a11 DATE := fnd_api.g_miss_date
805: , p6_a12 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
809: , p6_a16 NUMBER := 0-1962.0724
810: , p6_a17 DATE := fnd_api.g_miss_date
803: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
804: , p6_a11 DATE := fnd_api.g_miss_date
805: , p6_a12 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
809: , p6_a16 NUMBER := 0-1962.0724
810: , p6_a17 DATE := fnd_api.g_miss_date
811: , p6_a18 DATE := fnd_api.g_miss_date
804: , p6_a11 DATE := fnd_api.g_miss_date
805: , p6_a12 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
809: , p6_a16 NUMBER := 0-1962.0724
810: , p6_a17 DATE := fnd_api.g_miss_date
811: , p6_a18 DATE := fnd_api.g_miss_date
812: , p6_a19 NUMBER := 0-1962.0724
806: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
809: , p6_a16 NUMBER := 0-1962.0724
810: , p6_a17 DATE := fnd_api.g_miss_date
811: , p6_a18 DATE := fnd_api.g_miss_date
812: , p6_a19 NUMBER := 0-1962.0724
813: , p6_a20 NUMBER := 0-1962.0724
814: , p6_a21 NUMBER := 0-1962.0724
807: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
808: , p6_a15 DATE := fnd_api.g_miss_date
809: , p6_a16 NUMBER := 0-1962.0724
810: , p6_a17 DATE := fnd_api.g_miss_date
811: , p6_a18 DATE := fnd_api.g_miss_date
812: , p6_a19 NUMBER := 0-1962.0724
813: , p6_a20 NUMBER := 0-1962.0724
814: , p6_a21 NUMBER := 0-1962.0724
815: , p6_a22 NUMBER := 0-1962.0724
812: , p6_a19 NUMBER := 0-1962.0724
813: , p6_a20 NUMBER := 0-1962.0724
814: , p6_a21 NUMBER := 0-1962.0724
815: , p6_a22 NUMBER := 0-1962.0724
816: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
817: , p6_a24 NUMBER := 0-1962.0724
818: , p6_a25 NUMBER := 0-1962.0724
819: , p6_a26 NUMBER := 0-1962.0724
820: , p6_a27 NUMBER := 0-1962.0724
817: , p6_a24 NUMBER := 0-1962.0724
818: , p6_a25 NUMBER := 0-1962.0724
819: , p6_a26 NUMBER := 0-1962.0724
820: , p6_a27 NUMBER := 0-1962.0724
821: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
818: , p6_a25 NUMBER := 0-1962.0724
819: , p6_a26 NUMBER := 0-1962.0724
820: , p6_a27 NUMBER := 0-1962.0724
821: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
819: , p6_a26 NUMBER := 0-1962.0724
820: , p6_a27 NUMBER := 0-1962.0724
821: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
820: , p6_a27 NUMBER := 0-1962.0724
821: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
821: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
822: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
823: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
824: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
825: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
826: , p6_a33 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
827: , p6_a34 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
828: , p6_a35 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
829: , p6_a36 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
830: , p6_a37 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
831: , p6_a38 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
832: , p6_a39 VARCHAR2 := fnd_api.g_miss_char
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840: )
833: , p6_a40 VARCHAR2 := fnd_api.g_miss_char
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840: )
841: as
834: , p6_a41 VARCHAR2 := fnd_api.g_miss_char
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840: )
841: as
842: ddp_score_rec ams_dm_score_pvt.score_rec_type;
835: , p6_a42 VARCHAR2 := fnd_api.g_miss_char
836: , p6_a43 VARCHAR2 := fnd_api.g_miss_char
837: , p6_a44 VARCHAR2 := fnd_api.g_miss_char
838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840: )
841: as
842: ddp_score_rec ams_dm_score_pvt.score_rec_type;
843: ddindx binary_integer; indx binary_integer;
923: , x_return_status OUT NOCOPY VARCHAR2
924: , x_msg_count OUT NOCOPY NUMBER
925: , x_msg_data OUT NOCOPY VARCHAR2
926: , p4_a0 NUMBER := 0-1962.0724
927: , p4_a1 DATE := fnd_api.g_miss_date
928: , p4_a2 NUMBER := 0-1962.0724
929: , p4_a3 DATE := fnd_api.g_miss_date
930: , p4_a4 NUMBER := 0-1962.0724
931: , p4_a5 NUMBER := 0-1962.0724
925: , x_msg_data OUT NOCOPY VARCHAR2
926: , p4_a0 NUMBER := 0-1962.0724
927: , p4_a1 DATE := fnd_api.g_miss_date
928: , p4_a2 NUMBER := 0-1962.0724
929: , p4_a3 DATE := fnd_api.g_miss_date
930: , p4_a4 NUMBER := 0-1962.0724
931: , p4_a5 NUMBER := 0-1962.0724
932: , p4_a6 NUMBER := 0-1962.0724
933: , p4_a7 NUMBER := 0-1962.0724
932: , p4_a6 NUMBER := 0-1962.0724
933: , p4_a7 NUMBER := 0-1962.0724
934: , p4_a8 NUMBER := 0-1962.0724
935: , p4_a9 NUMBER := 0-1962.0724
936: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
937: , p4_a11 DATE := fnd_api.g_miss_date
938: , p4_a12 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
933: , p4_a7 NUMBER := 0-1962.0724
934: , p4_a8 NUMBER := 0-1962.0724
935: , p4_a9 NUMBER := 0-1962.0724
936: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
937: , p4_a11 DATE := fnd_api.g_miss_date
938: , p4_a12 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
935: , p4_a9 NUMBER := 0-1962.0724
936: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
937: , p4_a11 DATE := fnd_api.g_miss_date
938: , p4_a12 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
942: , p4_a16 NUMBER := 0-1962.0724
943: , p4_a17 DATE := fnd_api.g_miss_date
936: , p4_a10 VARCHAR2 := fnd_api.g_miss_char
937: , p4_a11 DATE := fnd_api.g_miss_date
938: , p4_a12 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
942: , p4_a16 NUMBER := 0-1962.0724
943: , p4_a17 DATE := fnd_api.g_miss_date
944: , p4_a18 DATE := fnd_api.g_miss_date
937: , p4_a11 DATE := fnd_api.g_miss_date
938: , p4_a12 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
942: , p4_a16 NUMBER := 0-1962.0724
943: , p4_a17 DATE := fnd_api.g_miss_date
944: , p4_a18 DATE := fnd_api.g_miss_date
945: , p4_a19 NUMBER := 0-1962.0724
939: , p4_a13 VARCHAR2 := fnd_api.g_miss_char
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
942: , p4_a16 NUMBER := 0-1962.0724
943: , p4_a17 DATE := fnd_api.g_miss_date
944: , p4_a18 DATE := fnd_api.g_miss_date
945: , p4_a19 NUMBER := 0-1962.0724
946: , p4_a20 NUMBER := 0-1962.0724
947: , p4_a21 NUMBER := 0-1962.0724
940: , p4_a14 VARCHAR2 := fnd_api.g_miss_char
941: , p4_a15 DATE := fnd_api.g_miss_date
942: , p4_a16 NUMBER := 0-1962.0724
943: , p4_a17 DATE := fnd_api.g_miss_date
944: , p4_a18 DATE := fnd_api.g_miss_date
945: , p4_a19 NUMBER := 0-1962.0724
946: , p4_a20 NUMBER := 0-1962.0724
947: , p4_a21 NUMBER := 0-1962.0724
948: , p4_a22 NUMBER := 0-1962.0724
945: , p4_a19 NUMBER := 0-1962.0724
946: , p4_a20 NUMBER := 0-1962.0724
947: , p4_a21 NUMBER := 0-1962.0724
948: , p4_a22 NUMBER := 0-1962.0724
949: , p4_a23 VARCHAR2 := fnd_api.g_miss_char
950: , p4_a24 NUMBER := 0-1962.0724
951: , p4_a25 NUMBER := 0-1962.0724
952: , p4_a26 NUMBER := 0-1962.0724
953: , p4_a27 NUMBER := 0-1962.0724
950: , p4_a24 NUMBER := 0-1962.0724
951: , p4_a25 NUMBER := 0-1962.0724
952: , p4_a26 NUMBER := 0-1962.0724
953: , p4_a27 NUMBER := 0-1962.0724
954: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
951: , p4_a25 NUMBER := 0-1962.0724
952: , p4_a26 NUMBER := 0-1962.0724
953: , p4_a27 NUMBER := 0-1962.0724
954: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
952: , p4_a26 NUMBER := 0-1962.0724
953: , p4_a27 NUMBER := 0-1962.0724
954: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
953: , p4_a27 NUMBER := 0-1962.0724
954: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
954: , p4_a28 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
955: , p4_a29 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
956: , p4_a30 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
957: , p4_a31 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
958: , p4_a32 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
959: , p4_a33 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
960: , p4_a34 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
961: , p4_a35 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
962: , p4_a36 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
963: , p4_a37 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
964: , p4_a38 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
965: , p4_a39 VARCHAR2 := fnd_api.g_miss_char
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973: )
966: , p4_a40 VARCHAR2 := fnd_api.g_miss_char
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973: )
974: as
967: , p4_a41 VARCHAR2 := fnd_api.g_miss_char
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973: )
974: as
975: ddp_score_rec ams_dm_score_pvt.score_rec_type;
968: , p4_a42 VARCHAR2 := fnd_api.g_miss_char
969: , p4_a43 VARCHAR2 := fnd_api.g_miss_char
970: , p4_a44 VARCHAR2 := fnd_api.g_miss_char
971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973: )
974: as
975: ddp_score_rec ams_dm_score_pvt.score_rec_type;
976: ddindx binary_integer; indx binary_integer;