DBA Data[Home] [Help]

APPS.QP_QUALIFIER_RULES_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
13: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
14: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
15: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

26:
27: -- If attr_id is missing compare old and new records and for
28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 455: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

451: IS
452: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
453: BEGIN
454:
455: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
456: l_QUALIFIER_RULES_rec.attribute1 := p_old_QUALIFIER_RULES_rec.attribute1;
457: END IF;
458:
459: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 459: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

455: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
456: l_QUALIFIER_RULES_rec.attribute1 := p_old_QUALIFIER_RULES_rec.attribute1;
457: END IF;
458:
459: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
460: l_QUALIFIER_RULES_rec.attribute10 := p_old_QUALIFIER_RULES_rec.attribute10;
461: END IF;
462:
463: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 463: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

459: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
460: l_QUALIFIER_RULES_rec.attribute10 := p_old_QUALIFIER_RULES_rec.attribute10;
461: END IF;
462:
463: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
464: l_QUALIFIER_RULES_rec.attribute11 := p_old_QUALIFIER_RULES_rec.attribute11;
465: END IF;
466:
467: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 467: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

463: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
464: l_QUALIFIER_RULES_rec.attribute11 := p_old_QUALIFIER_RULES_rec.attribute11;
465: END IF;
466:
467: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
468: l_QUALIFIER_RULES_rec.attribute12 := p_old_QUALIFIER_RULES_rec.attribute12;
469: END IF;
470:
471: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 471: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

467: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
468: l_QUALIFIER_RULES_rec.attribute12 := p_old_QUALIFIER_RULES_rec.attribute12;
469: END IF;
470:
471: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
472: l_QUALIFIER_RULES_rec.attribute13 := p_old_QUALIFIER_RULES_rec.attribute13;
473: END IF;
474:
475: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 475: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

471: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
472: l_QUALIFIER_RULES_rec.attribute13 := p_old_QUALIFIER_RULES_rec.attribute13;
473: END IF;
474:
475: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
476: l_QUALIFIER_RULES_rec.attribute14 := p_old_QUALIFIER_RULES_rec.attribute14;
477: END IF;
478:
479: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 479: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

475: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
476: l_QUALIFIER_RULES_rec.attribute14 := p_old_QUALIFIER_RULES_rec.attribute14;
477: END IF;
478:
479: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
480: l_QUALIFIER_RULES_rec.attribute15 := p_old_QUALIFIER_RULES_rec.attribute15;
481: END IF;
482:
483: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 483: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

479: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
480: l_QUALIFIER_RULES_rec.attribute15 := p_old_QUALIFIER_RULES_rec.attribute15;
481: END IF;
482:
483: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
484: l_QUALIFIER_RULES_rec.attribute2 := p_old_QUALIFIER_RULES_rec.attribute2;
485: END IF;
486:
487: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 487: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

483: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
484: l_QUALIFIER_RULES_rec.attribute2 := p_old_QUALIFIER_RULES_rec.attribute2;
485: END IF;
486:
487: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
488: l_QUALIFIER_RULES_rec.attribute3 := p_old_QUALIFIER_RULES_rec.attribute3;
489: END IF;
490:
491: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 491: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

487: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
488: l_QUALIFIER_RULES_rec.attribute3 := p_old_QUALIFIER_RULES_rec.attribute3;
489: END IF;
490:
491: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
492: l_QUALIFIER_RULES_rec.attribute4 := p_old_QUALIFIER_RULES_rec.attribute4;
493: END IF;
494:
495: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 495: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

491: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
492: l_QUALIFIER_RULES_rec.attribute4 := p_old_QUALIFIER_RULES_rec.attribute4;
493: END IF;
494:
495: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
496: l_QUALIFIER_RULES_rec.attribute5 := p_old_QUALIFIER_RULES_rec.attribute5;
497: END IF;
498:
499: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 499: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

495: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
496: l_QUALIFIER_RULES_rec.attribute5 := p_old_QUALIFIER_RULES_rec.attribute5;
497: END IF;
498:
499: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
500: l_QUALIFIER_RULES_rec.attribute6 := p_old_QUALIFIER_RULES_rec.attribute6;
501: END IF;
502:
503: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 503: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

499: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
500: l_QUALIFIER_RULES_rec.attribute6 := p_old_QUALIFIER_RULES_rec.attribute6;
501: END IF;
502:
503: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
504: l_QUALIFIER_RULES_rec.attribute7 := p_old_QUALIFIER_RULES_rec.attribute7;
505: END IF;
506:
507: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 507: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

503: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
504: l_QUALIFIER_RULES_rec.attribute7 := p_old_QUALIFIER_RULES_rec.attribute7;
505: END IF;
506:
507: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
508: l_QUALIFIER_RULES_rec.attribute8 := p_old_QUALIFIER_RULES_rec.attribute8;
509: END IF;
510:
511: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 511: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

507: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
508: l_QUALIFIER_RULES_rec.attribute8 := p_old_QUALIFIER_RULES_rec.attribute8;
509: END IF;
510:
511: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
512: l_QUALIFIER_RULES_rec.attribute9 := p_old_QUALIFIER_RULES_rec.attribute9;
513: END IF;
514:
515: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN

Line 515: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN

511: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
512: l_QUALIFIER_RULES_rec.attribute9 := p_old_QUALIFIER_RULES_rec.attribute9;
513: END IF;
514:
515: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
516: l_QUALIFIER_RULES_rec.context := p_old_QUALIFIER_RULES_rec.context;
517: END IF;
518:
519: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 519: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN

515: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
516: l_QUALIFIER_RULES_rec.context := p_old_QUALIFIER_RULES_rec.context;
517: END IF;
518:
519: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN
520: l_QUALIFIER_RULES_rec.created_by := p_old_QUALIFIER_RULES_rec.created_by;
521: END IF;
522:
523: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 523: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN

519: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN
520: l_QUALIFIER_RULES_rec.created_by := p_old_QUALIFIER_RULES_rec.created_by;
521: END IF;
522:
523: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN
524: l_QUALIFIER_RULES_rec.creation_date := p_old_QUALIFIER_RULES_rec.creation_date;
525: END IF;
526:
527: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN

Line 527: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN

523: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN
524: l_QUALIFIER_RULES_rec.creation_date := p_old_QUALIFIER_RULES_rec.creation_date;
525: END IF;
526:
527: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN
528: l_QUALIFIER_RULES_rec.description := p_old_QUALIFIER_RULES_rec.description;
529: END IF;
530:
531: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 531: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

527: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN
528: l_QUALIFIER_RULES_rec.description := p_old_QUALIFIER_RULES_rec.description;
529: END IF;
530:
531: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
532: l_QUALIFIER_RULES_rec.last_updated_by := p_old_QUALIFIER_RULES_rec.last_updated_by;
533: END IF;
534:
535: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 535: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN

531: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
532: l_QUALIFIER_RULES_rec.last_updated_by := p_old_QUALIFIER_RULES_rec.last_updated_by;
533: END IF;
534:
535: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
536: l_QUALIFIER_RULES_rec.last_update_date := p_old_QUALIFIER_RULES_rec.last_update_date;
537: END IF;
538:
539: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 539: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN

535: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
536: l_QUALIFIER_RULES_rec.last_update_date := p_old_QUALIFIER_RULES_rec.last_update_date;
537: END IF;
538:
539: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
540: l_QUALIFIER_RULES_rec.last_update_login := p_old_QUALIFIER_RULES_rec.last_update_login;
541: END IF;
542:
543: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN

Line 543: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN

539: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
540: l_QUALIFIER_RULES_rec.last_update_login := p_old_QUALIFIER_RULES_rec.last_update_login;
541: END IF;
542:
543: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN
544: l_QUALIFIER_RULES_rec.name := p_old_QUALIFIER_RULES_rec.name;
545: END IF;
546:
547: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 547: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN

543: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN
544: l_QUALIFIER_RULES_rec.name := p_old_QUALIFIER_RULES_rec.name;
545: END IF;
546:
547: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN
548: l_QUALIFIER_RULES_rec.program_application_id := p_old_QUALIFIER_RULES_rec.program_application_id;
549: END IF;
550:
551: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN

Line 551: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN

547: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN
548: l_QUALIFIER_RULES_rec.program_application_id := p_old_QUALIFIER_RULES_rec.program_application_id;
549: END IF;
550:
551: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN
552: l_QUALIFIER_RULES_rec.program_id := p_old_QUALIFIER_RULES_rec.program_id;
553: END IF;
554:
555: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 555: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN

551: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN
552: l_QUALIFIER_RULES_rec.program_id := p_old_QUALIFIER_RULES_rec.program_id;
553: END IF;
554:
555: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
556: l_QUALIFIER_RULES_rec.program_update_date := p_old_QUALIFIER_RULES_rec.program_update_date;
557: END IF;
558:
559: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 559: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

555: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
556: l_QUALIFIER_RULES_rec.program_update_date := p_old_QUALIFIER_RULES_rec.program_update_date;
557: END IF;
558:
559: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
560: l_QUALIFIER_RULES_rec.qualifier_rule_id := p_old_QUALIFIER_RULES_rec.qualifier_rule_id;
561: END IF;
562:
563: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN

Line 563: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN

559: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
560: l_QUALIFIER_RULES_rec.qualifier_rule_id := p_old_QUALIFIER_RULES_rec.qualifier_rule_id;
561: END IF;
562:
563: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN
564: l_QUALIFIER_RULES_rec.request_id := p_old_QUALIFIER_RULES_rec.request_id;
565: END IF;
566:
567: RETURN l_QUALIFIER_RULES_rec;

Line 580: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

576: IS
577: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
578: BEGIN
579:
580: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
581: l_QUALIFIER_RULES_rec.attribute1 := NULL;
582: END IF;
583:
584: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 584: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

580: IF l_QUALIFIER_RULES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
581: l_QUALIFIER_RULES_rec.attribute1 := NULL;
582: END IF;
583:
584: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
585: l_QUALIFIER_RULES_rec.attribute10 := NULL;
586: END IF;
587:
588: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 588: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

584: IF l_QUALIFIER_RULES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
585: l_QUALIFIER_RULES_rec.attribute10 := NULL;
586: END IF;
587:
588: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
589: l_QUALIFIER_RULES_rec.attribute11 := NULL;
590: END IF;
591:
592: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 592: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

588: IF l_QUALIFIER_RULES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
589: l_QUALIFIER_RULES_rec.attribute11 := NULL;
590: END IF;
591:
592: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
593: l_QUALIFIER_RULES_rec.attribute12 := NULL;
594: END IF;
595:
596: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 596: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

592: IF l_QUALIFIER_RULES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
593: l_QUALIFIER_RULES_rec.attribute12 := NULL;
594: END IF;
595:
596: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
597: l_QUALIFIER_RULES_rec.attribute13 := NULL;
598: END IF;
599:
600: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 600: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

596: IF l_QUALIFIER_RULES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
597: l_QUALIFIER_RULES_rec.attribute13 := NULL;
598: END IF;
599:
600: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
601: l_QUALIFIER_RULES_rec.attribute14 := NULL;
602: END IF;
603:
604: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 604: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

600: IF l_QUALIFIER_RULES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
601: l_QUALIFIER_RULES_rec.attribute14 := NULL;
602: END IF;
603:
604: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
605: l_QUALIFIER_RULES_rec.attribute15 := NULL;
606: END IF;
607:
608: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 608: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

604: IF l_QUALIFIER_RULES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
605: l_QUALIFIER_RULES_rec.attribute15 := NULL;
606: END IF;
607:
608: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
609: l_QUALIFIER_RULES_rec.attribute2 := NULL;
610: END IF;
611:
612: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 612: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

608: IF l_QUALIFIER_RULES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
609: l_QUALIFIER_RULES_rec.attribute2 := NULL;
610: END IF;
611:
612: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
613: l_QUALIFIER_RULES_rec.attribute3 := NULL;
614: END IF;
615:
616: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 616: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

612: IF l_QUALIFIER_RULES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
613: l_QUALIFIER_RULES_rec.attribute3 := NULL;
614: END IF;
615:
616: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
617: l_QUALIFIER_RULES_rec.attribute4 := NULL;
618: END IF;
619:
620: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 620: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

616: IF l_QUALIFIER_RULES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
617: l_QUALIFIER_RULES_rec.attribute4 := NULL;
618: END IF;
619:
620: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
621: l_QUALIFIER_RULES_rec.attribute5 := NULL;
622: END IF;
623:
624: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 624: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

620: IF l_QUALIFIER_RULES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
621: l_QUALIFIER_RULES_rec.attribute5 := NULL;
622: END IF;
623:
624: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
625: l_QUALIFIER_RULES_rec.attribute6 := NULL;
626: END IF;
627:
628: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 628: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

624: IF l_QUALIFIER_RULES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
625: l_QUALIFIER_RULES_rec.attribute6 := NULL;
626: END IF;
627:
628: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
629: l_QUALIFIER_RULES_rec.attribute7 := NULL;
630: END IF;
631:
632: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 632: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

628: IF l_QUALIFIER_RULES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
629: l_QUALIFIER_RULES_rec.attribute7 := NULL;
630: END IF;
631:
632: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
633: l_QUALIFIER_RULES_rec.attribute8 := NULL;
634: END IF;
635:
636: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 636: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

632: IF l_QUALIFIER_RULES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
633: l_QUALIFIER_RULES_rec.attribute8 := NULL;
634: END IF;
635:
636: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
637: l_QUALIFIER_RULES_rec.attribute9 := NULL;
638: END IF;
639:
640: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN

Line 640: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN

636: IF l_QUALIFIER_RULES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
637: l_QUALIFIER_RULES_rec.attribute9 := NULL;
638: END IF;
639:
640: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
641: l_QUALIFIER_RULES_rec.context := NULL;
642: END IF;
643:
644: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 644: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN

640: IF l_QUALIFIER_RULES_rec.context = FND_API.G_MISS_CHAR THEN
641: l_QUALIFIER_RULES_rec.context := NULL;
642: END IF;
643:
644: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN
645: l_QUALIFIER_RULES_rec.created_by := NULL;
646: END IF;
647:
648: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 648: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN

644: IF l_QUALIFIER_RULES_rec.created_by = FND_API.G_MISS_NUM THEN
645: l_QUALIFIER_RULES_rec.created_by := NULL;
646: END IF;
647:
648: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN
649: l_QUALIFIER_RULES_rec.creation_date := NULL;
650: END IF;
651:
652: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN

Line 652: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN

648: IF l_QUALIFIER_RULES_rec.creation_date = FND_API.G_MISS_DATE THEN
649: l_QUALIFIER_RULES_rec.creation_date := NULL;
650: END IF;
651:
652: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN
653: l_QUALIFIER_RULES_rec.description := NULL;
654: END IF;
655:
656: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 656: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

652: IF l_QUALIFIER_RULES_rec.description = FND_API.G_MISS_CHAR THEN
653: l_QUALIFIER_RULES_rec.description := NULL;
654: END IF;
655:
656: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
657: l_QUALIFIER_RULES_rec.last_updated_by := NULL;
658: END IF;
659:
660: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 660: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN

656: IF l_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
657: l_QUALIFIER_RULES_rec.last_updated_by := NULL;
658: END IF;
659:
660: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
661: l_QUALIFIER_RULES_rec.last_update_date := NULL;
662: END IF;
663:
664: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 664: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN

660: IF l_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN
661: l_QUALIFIER_RULES_rec.last_update_date := NULL;
662: END IF;
663:
664: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
665: l_QUALIFIER_RULES_rec.last_update_login := NULL;
666: END IF;
667:
668: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN

Line 668: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN

664: IF l_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN
665: l_QUALIFIER_RULES_rec.last_update_login := NULL;
666: END IF;
667:
668: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN
669: l_QUALIFIER_RULES_rec.name := NULL;
670: END IF;
671:
672: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 672: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN

668: IF l_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR THEN
669: l_QUALIFIER_RULES_rec.name := NULL;
670: END IF;
671:
672: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN
673: l_QUALIFIER_RULES_rec.program_application_id := NULL;
674: END IF;
675:
676: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN

Line 676: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN

672: IF l_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM THEN
673: l_QUALIFIER_RULES_rec.program_application_id := NULL;
674: END IF;
675:
676: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN
677: l_QUALIFIER_RULES_rec.program_id := NULL;
678: END IF;
679:
680: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 680: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN

676: IF l_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM THEN
677: l_QUALIFIER_RULES_rec.program_id := NULL;
678: END IF;
679:
680: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
681: l_QUALIFIER_RULES_rec.program_update_date := NULL;
682: END IF;
683:
684: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

Line 684: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

680: IF l_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN
681: l_QUALIFIER_RULES_rec.program_update_date := NULL;
682: END IF;
683:
684: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
685: l_QUALIFIER_RULES_rec.qualifier_rule_id := NULL;
686: END IF;
687:
688: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN

Line 688: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN

684: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
685: l_QUALIFIER_RULES_rec.qualifier_rule_id := NULL;
686: END IF;
687:
688: IF l_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM THEN
689: l_QUALIFIER_RULES_rec.request_id := NULL;
690: END IF;
691:
692: RETURN l_QUALIFIER_RULES_rec;

Line 748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744: , 'Update_Row'
745: );
746: END IF;
747:
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749:
750: END Update_Row;
751:
752: -- Procedure Insert_Row

Line 836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

832: , 'Insert_Row'
833: );
834: END IF;
835:
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837:
838: END Insert_Row;
839:
840: -- Procedure Delete_Row

Line 871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

867: , 'Delete_Row'
868: );
869: END IF;
870:
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872:
873: END Delete_Row;
874:
875: -- Function Query_Row

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: , 'Query_Row'
955: );
956: END IF;
957:
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959:
960: END Query_Row;
961:
962: -- Procedure lock_Row

Line 1105: x_return_status := FND_API.G_RET_STS_SUCCESS;

1101: x_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec;
1102:
1103: -- Set return status
1104:
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;
1106: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108: ELSE
1109:

Line 1106: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1102:
1103: -- Set return status
1104:
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;
1106: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108: ELSE
1109:
1110: -- Row has changed by another user.

Line 1113: x_return_status := FND_API.G_RET_STS_ERROR;

1109:
1110: -- Row has changed by another user.
1111: oe_debug_pub.add('row changed');
1112:
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1117: THEN

Line 1114: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;

1110: -- Row has changed by another user.
1111: oe_debug_pub.add('row changed');
1112:
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1117: THEN
1118:

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: EXCEPTION
1127:
1128: WHEN NO_DATA_FOUND THEN
1129:
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1134: THEN

Line 1131: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;

1127:
1128: WHEN NO_DATA_FOUND THEN
1129:
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1134: THEN
1135:

Line 1143: x_return_status := FND_API.G_RET_STS_ERROR;

1139:
1140: END IF;
1141: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1142:
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1145:
1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1147: THEN

Line 1144: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;

1140: END IF;
1141: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1142:
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1145:
1146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1147: THEN
1148:

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152:
1153: END IF;
1154: WHEN OTHERS THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN

Line 1157: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1153: END IF;
1154: WHEN OTHERS THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: x_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg

Line 1181: p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND

1177: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
1178: BEGIN
1179:
1180: IF p_QUALIFIER_RULES_rec.qualifier_rule_id IS NOT NULL AND
1181: p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
1182: NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,
1183: p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
1184: THEN
1185: l_QUALIFIER_RULES_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule

Line 1206: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1202: BEGIN
1203:
1204: -- initialize return_status.
1205:
1206: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1207:
1208: -- initialize l_QUALIFIER_RULES_rec.
1209:
1210: l_QUALIFIER_RULES_rec := p_QUALIFIER_RULES_rec;

Line 1212: IF p_QUALIFIER_RULES_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR

1208: -- initialize l_QUALIFIER_RULES_rec.
1209:
1210: l_QUALIFIER_RULES_rec := p_QUALIFIER_RULES_rec;
1211:
1212: IF p_QUALIFIER_RULES_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
1213: THEN
1214:
1215: IF p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1216:

Line 1215: IF p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN

1211:
1212: IF p_QUALIFIER_RULES_val_rec.qualifier_rule <> FND_API.G_MISS_CHAR
1213: THEN
1214:
1215: IF p_QUALIFIER_RULES_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1216:
1217: l_QUALIFIER_RULES_rec.qualifier_rule_id := p_QUALIFIER_RULES_rec.qualifier_rule_id;
1218:
1219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1234: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN

1230: l_QUALIFIER_RULES_rec.qualifier_rule_id := QP_Value_To_Id.qualifier_rule
1231: ( p_qualifier_rule => p_QUALIFIER_RULES_val_rec.qualifier_rule
1232: );
1233:
1234: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1235: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1236: END IF;
1237:
1238: END IF;

Line 1235: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;

1231: ( p_qualifier_rule => p_QUALIFIER_RULES_val_rec.qualifier_rule
1232: );
1233:
1234: IF l_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM THEN
1235: l_QUALIFIER_RULES_rec.return_status := FND_API.G_RET_STS_ERROR;
1236: END IF;
1237:
1238: END IF;
1239: