367:
368: IF QP_Validate.Comparison_Operator(g_QUALIFIERS_rec.comparison_operator_code)
369: THEN
370: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
371: QP_Qualifiers_Util.Clear_Dependent_Attr
372: ( p_attr_id => QP_Qualifiers_Util.G_COMPARISON_OPERATOR
373: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
374: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
375: );
368: IF QP_Validate.Comparison_Operator(g_QUALIFIERS_rec.comparison_operator_code)
369: THEN
370: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
371: QP_Qualifiers_Util.Clear_Dependent_Attr
372: ( p_attr_id => QP_Qualifiers_Util.G_COMPARISON_OPERATOR
373: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
374: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
375: );
376: ELSE
389:
390: IF QP_Validate.Created_From_Rule(g_QUALIFIERS_rec.created_from_rule_id)
391: THEN
392: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
393: QP_Qualifiers_Util.Clear_Dependent_Attr
394: ( p_attr_id => QP_Qualifiers_Util.G_CREATED_FROM_RULE
395: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
396: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
397: );
390: IF QP_Validate.Created_From_Rule(g_QUALIFIERS_rec.created_from_rule_id)
391: THEN
392: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
393: QP_Qualifiers_Util.Clear_Dependent_Attr
394: ( p_attr_id => QP_Qualifiers_Util.G_CREATED_FROM_RULE
395: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
396: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
397: );
398: ELSE
411:
412: IF QP_Validate.End_Date_Active(g_QUALIFIERS_rec.end_date_active)
413: THEN
414: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
415: QP_Qualifiers_Util.Clear_Dependent_Attr
416: ( p_attr_id => QP_Qualifiers_Util.G_END_DATE_ACTIVE
417: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
418: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
419: );
412: IF QP_Validate.End_Date_Active(g_QUALIFIERS_rec.end_date_active)
413: THEN
414: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
415: QP_Qualifiers_Util.Clear_Dependent_Attr
416: ( p_attr_id => QP_Qualifiers_Util.G_END_DATE_ACTIVE
417: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
418: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
419: );
420: ELSE
433:
434: IF QP_Validate.Excluder(g_QUALIFIERS_rec.excluder_flag)
435: THEN
436: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
437: QP_Qualifiers_Util.Clear_Dependent_Attr
438: ( p_attr_id => QP_Qualifiers_Util.G_EXCLUDER
439: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
440: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
441: );
434: IF QP_Validate.Excluder(g_QUALIFIERS_rec.excluder_flag)
435: THEN
436: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
437: QP_Qualifiers_Util.Clear_Dependent_Attr
438: ( p_attr_id => QP_Qualifiers_Util.G_EXCLUDER
439: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
440: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
441: );
442: ELSE
455:
456: IF QP_Validate.List_Header(g_QUALIFIERS_rec.list_header_id)
457: THEN
458: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
459: QP_Qualifiers_Util.Clear_Dependent_Attr
460: ( p_attr_id => QP_Qualifiers_Util.G_LIST_HEADER
461: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
462: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
463: );
456: IF QP_Validate.List_Header(g_QUALIFIERS_rec.list_header_id)
457: THEN
458: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
459: QP_Qualifiers_Util.Clear_Dependent_Attr
460: ( p_attr_id => QP_Qualifiers_Util.G_LIST_HEADER
461: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
462: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
463: );
464: ELSE
477:
478: IF QP_Validate.List_Line(g_QUALIFIERS_rec.list_line_id)
479: THEN
480: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
481: QP_Qualifiers_Util.Clear_Dependent_Attr
482: ( p_attr_id => QP_Qualifiers_Util.G_LIST_LINE
483: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
484: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
485: );
478: IF QP_Validate.List_Line(g_QUALIFIERS_rec.list_line_id)
479: THEN
480: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
481: QP_Qualifiers_Util.Clear_Dependent_Attr
482: ( p_attr_id => QP_Qualifiers_Util.G_LIST_LINE
483: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
484: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
485: );
486: ELSE
499:
500: IF QP_Validate.Qualifier_Attribute(g_QUALIFIERS_rec.qualifier_attribute)
501: THEN
502: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
503: QP_Qualifiers_Util.Clear_Dependent_Attr
504: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE
505: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
506: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
507: );
500: IF QP_Validate.Qualifier_Attribute(g_QUALIFIERS_rec.qualifier_attribute)
501: THEN
502: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
503: QP_Qualifiers_Util.Clear_Dependent_Attr
504: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE
505: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
506: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
507: );
508: ELSE
521:
522: IF QP_Validate.Qualifier_Attr_Value(g_QUALIFIERS_rec.qualifier_attr_value)
523: THEN
524: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
525: QP_Qualifiers_Util.Clear_Dependent_Attr
526: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE
527: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
528: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
529: );
522: IF QP_Validate.Qualifier_Attr_Value(g_QUALIFIERS_rec.qualifier_attr_value)
523: THEN
524: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
525: QP_Qualifiers_Util.Clear_Dependent_Attr
526: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE
527: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
528: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
529: );
530: ELSE
543:
544: IF QP_Validate.Qualifier_Attr_Value_to(g_QUALIFIERS_rec.qualifier_attr_value_to)
545: THEN
546: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
547: QP_Qualifiers_Util.Clear_Dependent_Attr
548: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO
549: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
550: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
551: );
544: IF QP_Validate.Qualifier_Attr_Value_to(g_QUALIFIERS_rec.qualifier_attr_value_to)
545: THEN
546: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
547: QP_Qualifiers_Util.Clear_Dependent_Attr
548: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO
549: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
550: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
551: );
552: ELSE
566:
567: IF QP_Validate.Qualifier_Context(g_QUALIFIERS_rec.qualifier_context)
568: THEN
569: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
570: QP_Qualifiers_Util.Clear_Dependent_Attr
571: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_CONTEXT
572: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
573: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
574: );
567: IF QP_Validate.Qualifier_Context(g_QUALIFIERS_rec.qualifier_context)
568: THEN
569: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
570: QP_Qualifiers_Util.Clear_Dependent_Attr
571: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_CONTEXT
572: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
573: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
574: );
575: ELSE
592:
593: IF QP_Validate.Qualifier_Datatype(g_QUALIFIERS_rec.qualifier_datatype)
594: THEN
595: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
596: QP_Qualifiers_Util.Clear_Dependent_Attr
597: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_DATATYPE
598: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
599: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
600: );
593: IF QP_Validate.Qualifier_Datatype(g_QUALIFIERS_rec.qualifier_datatype)
594: THEN
595: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
596: QP_Qualifiers_Util.Clear_Dependent_Attr
597: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_DATATYPE
598: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
599: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
600: );
601: ELSE
614:
615: IF QP_Validate.Qualifier_Date_Format(g_QUALIFIERS_rec.qualifier_date_format)
616: THEN
617: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
618: QP_Qualifiers_Util.Clear_Dependent_Attr
619: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT
620: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
621: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
622: );
615: IF QP_Validate.Qualifier_Date_Format(g_QUALIFIERS_rec.qualifier_date_format)
616: THEN
617: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
618: QP_Qualifiers_Util.Clear_Dependent_Attr
619: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT
620: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
621: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
622: );
623: ELSE
636:
637: IF QP_Validate.Qualifier_Grouping_No(g_QUALIFIERS_rec.qualifier_grouping_no)
638: THEN
639: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
640: QP_Qualifiers_Util.Clear_Dependent_Attr
641: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO
642: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
643: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
644: );
637: IF QP_Validate.Qualifier_Grouping_No(g_QUALIFIERS_rec.qualifier_grouping_no)
638: THEN
639: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
640: QP_Qualifiers_Util.Clear_Dependent_Attr
641: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO
642: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
643: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
644: );
645: ELSE
658:
659: IF QP_Validate.Qualifier(g_QUALIFIERS_rec.qualifier_id)
660: THEN
661: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
662: QP_Qualifiers_Util.Clear_Dependent_Attr
663: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER
664: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
665: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
666: );
659: IF QP_Validate.Qualifier(g_QUALIFIERS_rec.qualifier_id)
660: THEN
661: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
662: QP_Qualifiers_Util.Clear_Dependent_Attr
663: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER
664: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
665: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
666: );
667: ELSE
680:
681: IF QP_Validate.Qualifier_Number_Format(g_QUALIFIERS_rec.qualifier_number_format)
682: THEN
683: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
684: QP_Qualifiers_Util.Clear_Dependent_Attr
685: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT
686: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
687: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
688: );
681: IF QP_Validate.Qualifier_Number_Format(g_QUALIFIERS_rec.qualifier_number_format)
682: THEN
683: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
684: QP_Qualifiers_Util.Clear_Dependent_Attr
685: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT
686: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
687: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
688: );
689: ELSE
708:
709: IF QP_Validate.Qualifier_Precedence(g_QUALIFIERS_rec.qualifier_precedence)
710: THEN
711: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
712: QP_Qualifiers_Util.Clear_Dependent_Attr
713: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE
714: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
715: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
716: );
709: IF QP_Validate.Qualifier_Precedence(g_QUALIFIERS_rec.qualifier_precedence)
710: THEN
711: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
712: QP_Qualifiers_Util.Clear_Dependent_Attr
713: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE
714: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
715: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
716: );
717: ELSE
736:
737: IF QP_Validate.Qualifier_Rule(g_QUALIFIERS_rec.qualifier_rule_id)
738: THEN
739: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
740: QP_Qualifiers_Util.Clear_Dependent_Attr
741: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_RULE
742: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
743: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
744: );
737: IF QP_Validate.Qualifier_Rule(g_QUALIFIERS_rec.qualifier_rule_id)
738: THEN
739: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
740: QP_Qualifiers_Util.Clear_Dependent_Attr
741: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFIER_RULE
742: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
743: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
744: );
745: ELSE
758:
759: IF QP_Validate.Start_Date_Active(g_QUALIFIERS_rec.start_date_active)
760: THEN
761: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
762: QP_Qualifiers_Util.Clear_Dependent_Attr
763: ( p_attr_id => QP_Qualifiers_Util.G_START_DATE_ACTIVE
764: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
765: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
766: );
759: IF QP_Validate.Start_Date_Active(g_QUALIFIERS_rec.start_date_active)
760: THEN
761: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec; -- added for nocopy hint
762: QP_Qualifiers_Util.Clear_Dependent_Attr
763: ( p_attr_id => QP_Qualifiers_Util.G_START_DATE_ACTIVE
764: , p_QUALIFIERS_rec => g_p_QUALIFIERS_rec
765: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
766: );
767: ELSE
782:
783: IF QP_Validate.Qualify_Hier_Descendent_Flag(g_QUALIFIERS_rec.qualify_hier_descendent_flag)
784: THEN
785: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec;
786: QP_Qualifiers_Util.Clear_Dependent_Attr
787: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG
788: , p_QUALIFIERS_rec => g_QUALIFIERS_rec
789: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
790: );
783: IF QP_Validate.Qualify_Hier_Descendent_Flag(g_QUALIFIERS_rec.qualify_hier_descendent_flag)
784: THEN
785: g_p_QUALIFIERS_rec := g_QUALIFIERS_rec;
786: QP_Qualifiers_Util.Clear_Dependent_Attr
787: ( p_attr_id => QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG
788: , p_QUALIFIERS_rec => g_QUALIFIERS_rec
789: , x_QUALIFIERS_rec => g_QUALIFIERS_rec
790: );
791: ELSE