324: IF MRP_Validate_Assignment_Set.Val_Assignment_Set_Name
325: ( g_Assignment_Set_rec.Assignment_Set_Name )
326: THEN
327:
328: MRP_Assignment_Set_Util.Clear_Dependent_Attr
329: ( p_attr_id => MRP_Assignment_Set_Util.G_ASSIGNMENT_SET_NAME
330: , p_Assignment_Set_rec => g_Assignment_Set_rec
331: , x_Assignment_Set_rec => g_Assignment_Set_rec
332: );
325: ( g_Assignment_Set_rec.Assignment_Set_Name )
326: THEN
327:
328: MRP_Assignment_Set_Util.Clear_Dependent_Attr
329: ( p_attr_id => MRP_Assignment_Set_Util.G_ASSIGNMENT_SET_NAME
330: , p_Assignment_Set_rec => g_Assignment_Set_rec
331: , x_Assignment_Set_rec => g_Assignment_Set_rec
332: );
333: ELSE
347: IF MRP_Validate_Assignment_Set.Val_Attribute1
348: ( g_Assignment_Set_rec.Attribute1 )
349: THEN
350:
351: MRP_Assignment_Set_Util.Clear_Dependent_Attr
352: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE1
353: , p_Assignment_Set_rec => g_Assignment_Set_rec
354: , x_Assignment_Set_rec => g_Assignment_Set_rec
355: );
348: ( g_Assignment_Set_rec.Attribute1 )
349: THEN
350:
351: MRP_Assignment_Set_Util.Clear_Dependent_Attr
352: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE1
353: , p_Assignment_Set_rec => g_Assignment_Set_rec
354: , x_Assignment_Set_rec => g_Assignment_Set_rec
355: );
356: ELSE
370: IF MRP_Validate_Assignment_Set.Val_Attribute10
371: ( g_Assignment_Set_rec.Attribute10 )
372: THEN
373:
374: MRP_Assignment_Set_Util.Clear_Dependent_Attr
375: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE10
376: , p_Assignment_Set_rec => g_Assignment_Set_rec
377: , x_Assignment_Set_rec => g_Assignment_Set_rec
378: );
371: ( g_Assignment_Set_rec.Attribute10 )
372: THEN
373:
374: MRP_Assignment_Set_Util.Clear_Dependent_Attr
375: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE10
376: , p_Assignment_Set_rec => g_Assignment_Set_rec
377: , x_Assignment_Set_rec => g_Assignment_Set_rec
378: );
379: ELSE
393: IF MRP_Validate_Assignment_Set.Val_Attribute11
394: ( g_Assignment_Set_rec.Attribute11 )
395: THEN
396:
397: MRP_Assignment_Set_Util.Clear_Dependent_Attr
398: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE11
399: , p_Assignment_Set_rec => g_Assignment_Set_rec
400: , x_Assignment_Set_rec => g_Assignment_Set_rec
401: );
394: ( g_Assignment_Set_rec.Attribute11 )
395: THEN
396:
397: MRP_Assignment_Set_Util.Clear_Dependent_Attr
398: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE11
399: , p_Assignment_Set_rec => g_Assignment_Set_rec
400: , x_Assignment_Set_rec => g_Assignment_Set_rec
401: );
402: ELSE
416: IF MRP_Validate_Assignment_Set.Val_Attribute12
417: ( g_Assignment_Set_rec.Attribute12 )
418: THEN
419:
420: MRP_Assignment_Set_Util.Clear_Dependent_Attr
421: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE12
422: , p_Assignment_Set_rec => g_Assignment_Set_rec
423: , x_Assignment_Set_rec => g_Assignment_Set_rec
424: );
417: ( g_Assignment_Set_rec.Attribute12 )
418: THEN
419:
420: MRP_Assignment_Set_Util.Clear_Dependent_Attr
421: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE12
422: , p_Assignment_Set_rec => g_Assignment_Set_rec
423: , x_Assignment_Set_rec => g_Assignment_Set_rec
424: );
425: ELSE
439: IF MRP_Validate_Assignment_Set.Val_Attribute13
440: ( g_Assignment_Set_rec.Attribute13 )
441: THEN
442:
443: MRP_Assignment_Set_Util.Clear_Dependent_Attr
444: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE13
445: , p_Assignment_Set_rec => g_Assignment_Set_rec
446: , x_Assignment_Set_rec => g_Assignment_Set_rec
447: );
440: ( g_Assignment_Set_rec.Attribute13 )
441: THEN
442:
443: MRP_Assignment_Set_Util.Clear_Dependent_Attr
444: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE13
445: , p_Assignment_Set_rec => g_Assignment_Set_rec
446: , x_Assignment_Set_rec => g_Assignment_Set_rec
447: );
448: ELSE
462: IF MRP_Validate_Assignment_Set.Val_Attribute14
463: ( g_Assignment_Set_rec.Attribute14 )
464: THEN
465:
466: MRP_Assignment_Set_Util.Clear_Dependent_Attr
467: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE14
468: , p_Assignment_Set_rec => g_Assignment_Set_rec
469: , x_Assignment_Set_rec => g_Assignment_Set_rec
470: );
463: ( g_Assignment_Set_rec.Attribute14 )
464: THEN
465:
466: MRP_Assignment_Set_Util.Clear_Dependent_Attr
467: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE14
468: , p_Assignment_Set_rec => g_Assignment_Set_rec
469: , x_Assignment_Set_rec => g_Assignment_Set_rec
470: );
471: ELSE
485: IF MRP_Validate_Assignment_Set.Val_Attribute15
486: ( g_Assignment_Set_rec.Attribute15 )
487: THEN
488:
489: MRP_Assignment_Set_Util.Clear_Dependent_Attr
490: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE15
491: , p_Assignment_Set_rec => g_Assignment_Set_rec
492: , x_Assignment_Set_rec => g_Assignment_Set_rec
493: );
486: ( g_Assignment_Set_rec.Attribute15 )
487: THEN
488:
489: MRP_Assignment_Set_Util.Clear_Dependent_Attr
490: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE15
491: , p_Assignment_Set_rec => g_Assignment_Set_rec
492: , x_Assignment_Set_rec => g_Assignment_Set_rec
493: );
494: ELSE
508: IF MRP_Validate_Assignment_Set.Val_Attribute2
509: ( g_Assignment_Set_rec.Attribute2 )
510: THEN
511:
512: MRP_Assignment_Set_Util.Clear_Dependent_Attr
513: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE2
514: , p_Assignment_Set_rec => g_Assignment_Set_rec
515: , x_Assignment_Set_rec => g_Assignment_Set_rec
516: );
509: ( g_Assignment_Set_rec.Attribute2 )
510: THEN
511:
512: MRP_Assignment_Set_Util.Clear_Dependent_Attr
513: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE2
514: , p_Assignment_Set_rec => g_Assignment_Set_rec
515: , x_Assignment_Set_rec => g_Assignment_Set_rec
516: );
517: ELSE
531: IF MRP_Validate_Assignment_Set.Val_Attribute3
532: ( g_Assignment_Set_rec.Attribute3 )
533: THEN
534:
535: MRP_Assignment_Set_Util.Clear_Dependent_Attr
536: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE3
537: , p_Assignment_Set_rec => g_Assignment_Set_rec
538: , x_Assignment_Set_rec => g_Assignment_Set_rec
539: );
532: ( g_Assignment_Set_rec.Attribute3 )
533: THEN
534:
535: MRP_Assignment_Set_Util.Clear_Dependent_Attr
536: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE3
537: , p_Assignment_Set_rec => g_Assignment_Set_rec
538: , x_Assignment_Set_rec => g_Assignment_Set_rec
539: );
540: ELSE
554: IF MRP_Validate_Assignment_Set.Val_Attribute4
555: ( g_Assignment_Set_rec.Attribute4 )
556: THEN
557:
558: MRP_Assignment_Set_Util.Clear_Dependent_Attr
559: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE4
560: , p_Assignment_Set_rec => g_Assignment_Set_rec
561: , x_Assignment_Set_rec => g_Assignment_Set_rec
562: );
555: ( g_Assignment_Set_rec.Attribute4 )
556: THEN
557:
558: MRP_Assignment_Set_Util.Clear_Dependent_Attr
559: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE4
560: , p_Assignment_Set_rec => g_Assignment_Set_rec
561: , x_Assignment_Set_rec => g_Assignment_Set_rec
562: );
563: ELSE
577: IF MRP_Validate_Assignment_Set.Val_Attribute5
578: ( g_Assignment_Set_rec.Attribute5 )
579: THEN
580:
581: MRP_Assignment_Set_Util.Clear_Dependent_Attr
582: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE5
583: , p_Assignment_Set_rec => g_Assignment_Set_rec
584: , x_Assignment_Set_rec => g_Assignment_Set_rec
585: );
578: ( g_Assignment_Set_rec.Attribute5 )
579: THEN
580:
581: MRP_Assignment_Set_Util.Clear_Dependent_Attr
582: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE5
583: , p_Assignment_Set_rec => g_Assignment_Set_rec
584: , x_Assignment_Set_rec => g_Assignment_Set_rec
585: );
586: ELSE
600: IF MRP_Validate_Assignment_Set.Val_Attribute6
601: ( g_Assignment_Set_rec.Attribute6 )
602: THEN
603:
604: MRP_Assignment_Set_Util.Clear_Dependent_Attr
605: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE6
606: , p_Assignment_Set_rec => g_Assignment_Set_rec
607: , x_Assignment_Set_rec => g_Assignment_Set_rec
608: );
601: ( g_Assignment_Set_rec.Attribute6 )
602: THEN
603:
604: MRP_Assignment_Set_Util.Clear_Dependent_Attr
605: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE6
606: , p_Assignment_Set_rec => g_Assignment_Set_rec
607: , x_Assignment_Set_rec => g_Assignment_Set_rec
608: );
609: ELSE
623: IF MRP_Validate_Assignment_Set.Val_Attribute7
624: ( g_Assignment_Set_rec.Attribute7 )
625: THEN
626:
627: MRP_Assignment_Set_Util.Clear_Dependent_Attr
628: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE7
629: , p_Assignment_Set_rec => g_Assignment_Set_rec
630: , x_Assignment_Set_rec => g_Assignment_Set_rec
631: );
624: ( g_Assignment_Set_rec.Attribute7 )
625: THEN
626:
627: MRP_Assignment_Set_Util.Clear_Dependent_Attr
628: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE7
629: , p_Assignment_Set_rec => g_Assignment_Set_rec
630: , x_Assignment_Set_rec => g_Assignment_Set_rec
631: );
632: ELSE
646: IF MRP_Validate_Assignment_Set.Val_Attribute8
647: ( g_Assignment_Set_rec.Attribute8 )
648: THEN
649:
650: MRP_Assignment_Set_Util.Clear_Dependent_Attr
651: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE8
652: , p_Assignment_Set_rec => g_Assignment_Set_rec
653: , x_Assignment_Set_rec => g_Assignment_Set_rec
654: );
647: ( g_Assignment_Set_rec.Attribute8 )
648: THEN
649:
650: MRP_Assignment_Set_Util.Clear_Dependent_Attr
651: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE8
652: , p_Assignment_Set_rec => g_Assignment_Set_rec
653: , x_Assignment_Set_rec => g_Assignment_Set_rec
654: );
655: ELSE
669: IF MRP_Validate_Assignment_Set.Val_Attribute9
670: ( g_Assignment_Set_rec.Attribute9 )
671: THEN
672:
673: MRP_Assignment_Set_Util.Clear_Dependent_Attr
674: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE9
675: , p_Assignment_Set_rec => g_Assignment_Set_rec
676: , x_Assignment_Set_rec => g_Assignment_Set_rec
677: );
670: ( g_Assignment_Set_rec.Attribute9 )
671: THEN
672:
673: MRP_Assignment_Set_Util.Clear_Dependent_Attr
674: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE9
675: , p_Assignment_Set_rec => g_Assignment_Set_rec
676: , x_Assignment_Set_rec => g_Assignment_Set_rec
677: );
678: ELSE
692: IF MRP_Validate_Assignment_Set.Val_Attribute_Category
693: ( g_Assignment_Set_rec.Attribute_Category )
694: THEN
695:
696: MRP_Assignment_Set_Util.Clear_Dependent_Attr
697: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE_CATEGORY
698: , p_Assignment_Set_rec => g_Assignment_Set_rec
699: , x_Assignment_Set_rec => g_Assignment_Set_rec
700: );
693: ( g_Assignment_Set_rec.Attribute_Category )
694: THEN
695:
696: MRP_Assignment_Set_Util.Clear_Dependent_Attr
697: ( p_attr_id => MRP_Assignment_Set_Util.G_ATTRIBUTE_CATEGORY
698: , p_Assignment_Set_rec => g_Assignment_Set_rec
699: , x_Assignment_Set_rec => g_Assignment_Set_rec
700: );
701: ELSE
715: IF MRP_Validate_Assignment_Set.Val_Created_By
716: ( g_Assignment_Set_rec.Created_By )
717: THEN
718:
719: MRP_Assignment_Set_Util.Clear_Dependent_Attr
720: ( p_attr_id => MRP_Assignment_Set_Util.G_CREATED_BY
721: , p_Assignment_Set_rec => g_Assignment_Set_rec
722: , x_Assignment_Set_rec => g_Assignment_Set_rec
723: );
716: ( g_Assignment_Set_rec.Created_By )
717: THEN
718:
719: MRP_Assignment_Set_Util.Clear_Dependent_Attr
720: ( p_attr_id => MRP_Assignment_Set_Util.G_CREATED_BY
721: , p_Assignment_Set_rec => g_Assignment_Set_rec
722: , x_Assignment_Set_rec => g_Assignment_Set_rec
723: );
724: ELSE
738: IF MRP_Validate_Assignment_Set.Val_Creation_Date
739: ( g_Assignment_Set_rec.Creation_Date )
740: THEN
741:
742: MRP_Assignment_Set_Util.Clear_Dependent_Attr
743: ( p_attr_id => MRP_Assignment_Set_Util.G_CREATION_DATE
744: , p_Assignment_Set_rec => g_Assignment_Set_rec
745: , x_Assignment_Set_rec => g_Assignment_Set_rec
746: );
739: ( g_Assignment_Set_rec.Creation_Date )
740: THEN
741:
742: MRP_Assignment_Set_Util.Clear_Dependent_Attr
743: ( p_attr_id => MRP_Assignment_Set_Util.G_CREATION_DATE
744: , p_Assignment_Set_rec => g_Assignment_Set_rec
745: , x_Assignment_Set_rec => g_Assignment_Set_rec
746: );
747: ELSE
761: IF MRP_Validate_Assignment_Set.Val_Description
762: ( g_Assignment_Set_rec.Description )
763: THEN
764:
765: MRP_Assignment_Set_Util.Clear_Dependent_Attr
766: ( p_attr_id => MRP_Assignment_Set_Util.G_DESCRIPTION
767: , p_Assignment_Set_rec => g_Assignment_Set_rec
768: , x_Assignment_Set_rec => g_Assignment_Set_rec
769: );
762: ( g_Assignment_Set_rec.Description )
763: THEN
764:
765: MRP_Assignment_Set_Util.Clear_Dependent_Attr
766: ( p_attr_id => MRP_Assignment_Set_Util.G_DESCRIPTION
767: , p_Assignment_Set_rec => g_Assignment_Set_rec
768: , x_Assignment_Set_rec => g_Assignment_Set_rec
769: );
770: ELSE
784: IF MRP_Validate_Assignment_Set.Val_Last_Updated_By
785: ( g_Assignment_Set_rec.Last_Updated_By )
786: THEN
787:
788: MRP_Assignment_Set_Util.Clear_Dependent_Attr
789: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATED_BY
790: , p_Assignment_Set_rec => g_Assignment_Set_rec
791: , x_Assignment_Set_rec => g_Assignment_Set_rec
792: );
785: ( g_Assignment_Set_rec.Last_Updated_By )
786: THEN
787:
788: MRP_Assignment_Set_Util.Clear_Dependent_Attr
789: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATED_BY
790: , p_Assignment_Set_rec => g_Assignment_Set_rec
791: , x_Assignment_Set_rec => g_Assignment_Set_rec
792: );
793: ELSE
807: IF MRP_Validate_Assignment_Set.Val_Last_Update_Date
808: ( g_Assignment_Set_rec.Last_Update_Date )
809: THEN
810:
811: MRP_Assignment_Set_Util.Clear_Dependent_Attr
812: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATE_DATE
813: , p_Assignment_Set_rec => g_Assignment_Set_rec
814: , x_Assignment_Set_rec => g_Assignment_Set_rec
815: );
808: ( g_Assignment_Set_rec.Last_Update_Date )
809: THEN
810:
811: MRP_Assignment_Set_Util.Clear_Dependent_Attr
812: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATE_DATE
813: , p_Assignment_Set_rec => g_Assignment_Set_rec
814: , x_Assignment_Set_rec => g_Assignment_Set_rec
815: );
816: ELSE
830: IF MRP_Validate_Assignment_Set.Val_Last_Update_Login
831: ( g_Assignment_Set_rec.Last_Update_Login )
832: THEN
833:
834: MRP_Assignment_Set_Util.Clear_Dependent_Attr
835: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATE_LOGIN
836: , p_Assignment_Set_rec => g_Assignment_Set_rec
837: , x_Assignment_Set_rec => g_Assignment_Set_rec
838: );
831: ( g_Assignment_Set_rec.Last_Update_Login )
832: THEN
833:
834: MRP_Assignment_Set_Util.Clear_Dependent_Attr
835: ( p_attr_id => MRP_Assignment_Set_Util.G_LAST_UPDATE_LOGIN
836: , p_Assignment_Set_rec => g_Assignment_Set_rec
837: , x_Assignment_Set_rec => g_Assignment_Set_rec
838: );
839: ELSE
853: IF MRP_Validate_Assignment_Set.Val_Program_Application_Id
854: ( g_Assignment_Set_rec.Program_Application_Id )
855: THEN
856:
857: MRP_Assignment_Set_Util.Clear_Dependent_Attr
858: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_APPLICATION_ID
859: , p_Assignment_Set_rec => g_Assignment_Set_rec
860: , x_Assignment_Set_rec => g_Assignment_Set_rec
861: );
854: ( g_Assignment_Set_rec.Program_Application_Id )
855: THEN
856:
857: MRP_Assignment_Set_Util.Clear_Dependent_Attr
858: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_APPLICATION_ID
859: , p_Assignment_Set_rec => g_Assignment_Set_rec
860: , x_Assignment_Set_rec => g_Assignment_Set_rec
861: );
862: ELSE
876: IF MRP_Validate_Assignment_Set.Val_Program_Id
877: ( g_Assignment_Set_rec.Program_Id )
878: THEN
879:
880: MRP_Assignment_Set_Util.Clear_Dependent_Attr
881: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_ID
882: , p_Assignment_Set_rec => g_Assignment_Set_rec
883: , x_Assignment_Set_rec => g_Assignment_Set_rec
884: );
877: ( g_Assignment_Set_rec.Program_Id )
878: THEN
879:
880: MRP_Assignment_Set_Util.Clear_Dependent_Attr
881: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_ID
882: , p_Assignment_Set_rec => g_Assignment_Set_rec
883: , x_Assignment_Set_rec => g_Assignment_Set_rec
884: );
885: ELSE
899: IF MRP_Validate_Assignment_Set.Val_Program_Update_Date
900: ( g_Assignment_Set_rec.Program_Update_Date )
901: THEN
902:
903: MRP_Assignment_Set_Util.Clear_Dependent_Attr
904: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_UPDATE_DATE
905: , p_Assignment_Set_rec => g_Assignment_Set_rec
906: , x_Assignment_Set_rec => g_Assignment_Set_rec
907: );
900: ( g_Assignment_Set_rec.Program_Update_Date )
901: THEN
902:
903: MRP_Assignment_Set_Util.Clear_Dependent_Attr
904: ( p_attr_id => MRP_Assignment_Set_Util.G_PROGRAM_UPDATE_DATE
905: , p_Assignment_Set_rec => g_Assignment_Set_rec
906: , x_Assignment_Set_rec => g_Assignment_Set_rec
907: );
908: ELSE
922: IF MRP_Validate_Assignment_Set.Val_Request_Id
923: ( g_Assignment_Set_rec.Request_Id )
924: THEN
925:
926: MRP_Assignment_Set_Util.Clear_Dependent_Attr
927: ( p_attr_id => MRP_Assignment_Set_Util.G_REQUEST_ID
928: , p_Assignment_Set_rec => g_Assignment_Set_rec
929: , x_Assignment_Set_rec => g_Assignment_Set_rec
930: );
923: ( g_Assignment_Set_rec.Request_Id )
924: THEN
925:
926: MRP_Assignment_Set_Util.Clear_Dependent_Attr
927: ( p_attr_id => MRP_Assignment_Set_Util.G_REQUEST_ID
928: , p_Assignment_Set_rec => g_Assignment_Set_rec
929: , x_Assignment_Set_rec => g_Assignment_Set_rec
930: );
931: ELSE