247:
248: oe_debug_pub.add('Ren: before get_values');
249: oe_debug_pub.add('ren : msg data 0.5 is : ' || x_msg_data);
250:
251: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values
252: ( p_QUALIFIERS_rec => l_x_QUALIFIERS_rec
253: );
254: --x_comparison_operator := l_QUALIFIERS_val_rec.comparison_operator;
255: x_created_from_rule := l_QUALIFIERS_val_rec.created_from_rule;
444: );
445:
446: l_old_QUALIFIERS_rec := l_QUALIFIERS_rec;
447:
448: IF p_attr_id = QP_Qualifiers_Util.G_COMPARISON_OPERATOR THEN
449: l_QUALIFIERS_rec.comparison_operator_code := p_attr_value;
450: ELSIF p_attr_id = QP_Qualifiers_Util.G_CREATED_FROM_RULE THEN
451: l_QUALIFIERS_rec.created_from_rule_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE THEN
446: l_old_QUALIFIERS_rec := l_QUALIFIERS_rec;
447:
448: IF p_attr_id = QP_Qualifiers_Util.G_COMPARISON_OPERATOR THEN
449: l_QUALIFIERS_rec.comparison_operator_code := p_attr_value;
450: ELSIF p_attr_id = QP_Qualifiers_Util.G_CREATED_FROM_RULE THEN
451: l_QUALIFIERS_rec.created_from_rule_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE THEN
453: l_QUALIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER THEN
448: IF p_attr_id = QP_Qualifiers_Util.G_COMPARISON_OPERATOR THEN
449: l_QUALIFIERS_rec.comparison_operator_code := p_attr_value;
450: ELSIF p_attr_id = QP_Qualifiers_Util.G_CREATED_FROM_RULE THEN
451: l_QUALIFIERS_rec.created_from_rule_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE THEN
453: l_QUALIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER THEN
455: l_QUALIFIERS_rec.excluder_flag := p_attr_value;
456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER THEN
450: ELSIF p_attr_id = QP_Qualifiers_Util.G_CREATED_FROM_RULE THEN
451: l_QUALIFIERS_rec.created_from_rule_id := TO_NUMBER(p_attr_value);
452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE THEN
453: l_QUALIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER THEN
455: l_QUALIFIERS_rec.excluder_flag := p_attr_value;
456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER THEN
457: l_QUALIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE THEN
452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE THEN
453: l_QUALIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER THEN
455: l_QUALIFIERS_rec.excluder_flag := p_attr_value;
456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER THEN
457: l_QUALIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE THEN
459: l_QUALIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE THEN
454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER THEN
455: l_QUALIFIERS_rec.excluder_flag := p_attr_value;
456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER THEN
457: l_QUALIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE THEN
459: l_QUALIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE THEN
461: l_QUALIFIERS_rec.qualifier_attribute := p_attr_value;
462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE THEN
456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER THEN
457: l_QUALIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE THEN
459: l_QUALIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE THEN
461: l_QUALIFIERS_rec.qualifier_attribute := p_attr_value;
462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE THEN
463: l_QUALIFIERS_rec.qualifier_attr_value := p_attr_value;
464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO THEN
458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE THEN
459: l_QUALIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE THEN
461: l_QUALIFIERS_rec.qualifier_attribute := p_attr_value;
462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE THEN
463: l_QUALIFIERS_rec.qualifier_attr_value := p_attr_value;
464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO THEN
465: l_QUALIFIERS_rec.qualifier_attr_value_to := p_attr_value;
466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT THEN
460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE THEN
461: l_QUALIFIERS_rec.qualifier_attribute := p_attr_value;
462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE THEN
463: l_QUALIFIERS_rec.qualifier_attr_value := p_attr_value;
464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO THEN
465: l_QUALIFIERS_rec.qualifier_attr_value_to := p_attr_value;
466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT THEN
467: l_QUALIFIERS_rec.qualifier_context := p_attr_value;
468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE THEN
462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE THEN
463: l_QUALIFIERS_rec.qualifier_attr_value := p_attr_value;
464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO THEN
465: l_QUALIFIERS_rec.qualifier_attr_value_to := p_attr_value;
466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT THEN
467: l_QUALIFIERS_rec.qualifier_context := p_attr_value;
468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE THEN
469: l_QUALIFIERS_rec.qualifier_datatype := p_attr_value;
470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT THEN
464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO THEN
465: l_QUALIFIERS_rec.qualifier_attr_value_to := p_attr_value;
466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT THEN
467: l_QUALIFIERS_rec.qualifier_context := p_attr_value;
468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE THEN
469: l_QUALIFIERS_rec.qualifier_datatype := p_attr_value;
470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT THEN
471: -- l_QUALIFIERS_rec.qualifier_date_format := p_attr_value;
472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO THEN
466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT THEN
467: l_QUALIFIERS_rec.qualifier_context := p_attr_value;
468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE THEN
469: l_QUALIFIERS_rec.qualifier_datatype := p_attr_value;
470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT THEN
471: -- l_QUALIFIERS_rec.qualifier_date_format := p_attr_value;
472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO THEN
473: l_QUALIFIERS_rec.qualifier_grouping_no := TO_NUMBER(p_attr_value);
474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER THEN
468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE THEN
469: l_QUALIFIERS_rec.qualifier_datatype := p_attr_value;
470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT THEN
471: -- l_QUALIFIERS_rec.qualifier_date_format := p_attr_value;
472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO THEN
473: l_QUALIFIERS_rec.qualifier_grouping_no := TO_NUMBER(p_attr_value);
474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER THEN
475: l_QUALIFIERS_rec.qualifier_id := TO_NUMBER(p_attr_value);
476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT THEN
470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT THEN
471: -- l_QUALIFIERS_rec.qualifier_date_format := p_attr_value;
472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO THEN
473: l_QUALIFIERS_rec.qualifier_grouping_no := TO_NUMBER(p_attr_value);
474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER THEN
475: l_QUALIFIERS_rec.qualifier_id := TO_NUMBER(p_attr_value);
476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT THEN
477: -- l_QUALIFIERS_rec.qualifier_number_format := p_attr_value;
478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE THEN
472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO THEN
473: l_QUALIFIERS_rec.qualifier_grouping_no := TO_NUMBER(p_attr_value);
474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER THEN
475: l_QUALIFIERS_rec.qualifier_id := TO_NUMBER(p_attr_value);
476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT THEN
477: -- l_QUALIFIERS_rec.qualifier_number_format := p_attr_value;
478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE THEN
479: l_QUALIFIERS_rec.qualifier_precedence := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_RULE THEN
474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER THEN
475: l_QUALIFIERS_rec.qualifier_id := TO_NUMBER(p_attr_value);
476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT THEN
477: -- l_QUALIFIERS_rec.qualifier_number_format := p_attr_value;
478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE THEN
479: l_QUALIFIERS_rec.qualifier_precedence := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_RULE THEN
481: l_QUALIFIERS_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
482: ELSIF p_attr_id = QP_Qualifiers_Util.G_START_DATE_ACTIVE THEN
476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT THEN
477: -- l_QUALIFIERS_rec.qualifier_number_format := p_attr_value;
478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE THEN
479: l_QUALIFIERS_rec.qualifier_precedence := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_RULE THEN
481: l_QUALIFIERS_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
482: ELSIF p_attr_id = QP_Qualifiers_Util.G_START_DATE_ACTIVE THEN
483: l_QUALIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: -- Added for TCA
478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE THEN
479: l_QUALIFIERS_rec.qualifier_precedence := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_RULE THEN
481: l_QUALIFIERS_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
482: ELSIF p_attr_id = QP_Qualifiers_Util.G_START_DATE_ACTIVE THEN
483: l_QUALIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: -- Added for TCA
485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG THEN
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
481: l_QUALIFIERS_rec.qualifier_rule_id := TO_NUMBER(p_attr_value);
482: ELSIF p_attr_id = QP_Qualifiers_Util.G_START_DATE_ACTIVE THEN
483: l_QUALIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: -- Added for TCA
485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG THEN
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
483: l_QUALIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: -- Added for TCA
485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG THEN
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
484: -- Added for TCA
485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG THEN
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG THEN
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
486: l_QUALIFIERS_rec.qualify_hier_descendent_flag := p_attr_value;
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT
495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT
503: THEN
496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT
503: THEN
504:
497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT
503: THEN
504:
505: l_QUALIFIERS_rec.attribute1 := p_attribute1;
498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6
499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7
500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8
501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9
502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT
503: THEN
504:
505: l_QUALIFIERS_rec.attribute1 := p_attribute1;
506: l_QUALIFIERS_rec.attribute10 := p_attribute10;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA
642:
643: -- Load display out parameters if any
644:
645: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values
646: ( p_QUALIFIERS_rec => l_x_QUALIFIERS_rec
647: , p_old_QUALIFIERS_rec => l_QUALIFIERS_rec
648: );
649:
1651: THEN
1652:
1653: -- Query row from DB
1654:
1655: g_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
1656: ( p_qualifier_id => p_qualifier_id
1657: );
1658:
1659: g_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1747:
1748: IF p_group_condition = 'AND' THEN
1749: SELECT NVL(MAX(ABS(qualifier_grouping_no)),-1)
1750: INTO l_max_grouping_no
1751: FROM qp_qualifiers
1752: WHERE list_header_id = l_list_header_id;
1753:
1754: /* In the case where grp no is 0, we need to add more than max) */
1755: l_max_grouping_no := l_max_grouping_no + 1;