DBA Data[Home] [Help]

APPS.QP_QP_PRL_FORM_QUALIFIERS dependencies on QP_QUALIFIERS

Line 251: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values

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;

Line 448: IF p_attr_id = QP_Qualifiers_Util.G_COMPARISON_OPERATOR THEN

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

Line 450: ELSIF p_attr_id = QP_Qualifiers_Util.G_CREATED_FROM_RULE 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

Line 452: ELSIF p_attr_id = QP_Qualifiers_Util.G_END_DATE_ACTIVE 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

Line 454: ELSIF p_attr_id = QP_Qualifiers_Util.G_EXCLUDER 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

Line 456: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_HEADER 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

Line 458: ELSIF p_attr_id = QP_Qualifiers_Util.G_LIST_LINE 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

Line 460: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTRIBUTE 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

Line 462: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE 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

Line 464: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_ATTR_VALUE_TO 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

Line 466: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_CONTEXT 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

Line 468: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATATYPE 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

Line 470: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_DATE_FORMAT 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

Line 472: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_GROUPING_NO 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

Line 474: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER 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

Line 476: --ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_NUMBER_FORMAT 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

Line 478: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_PRECEDENCE 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

Line 480: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFIER_RULE 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

Line 482: ELSIF p_attr_id = QP_Qualifiers_Util.G_START_DATE_ACTIVE THEN

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;

Line 485: ELSIF p_attr_id = QP_Qualifiers_Util.G_QUALIFY_HIER_DESCENDENT_FLAG 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;
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

Line 487: ELSIF p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE1

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

Line 488: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE10

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

Line 489: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE11

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

Line 490: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE12

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

Line 491: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE13

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

Line 492: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE14

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

Line 493: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE15

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

Line 494: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE2

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

Line 495: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE3

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

Line 496: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE4

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

Line 497: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE5

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

Line 498: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE6

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

Line 499: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE7

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

Line 500: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE8

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:

Line 501: OR p_attr_id = QP_Qualifiers_Util.G_ATTRIBUTE9

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;

Line 502: OR p_attr_id = QP_Qualifiers_Util.G_CONTEXT

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;

Line 645: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values

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:

Line 1655: g_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row

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;

Line 1751: FROM qp_qualifiers

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;