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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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:
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.
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
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:
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
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:
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
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:
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
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
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
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;
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:
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)
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;
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: