231:
232:
233: -- Load display out parameters if any
234:
235: l_MODIFIER_LIST_val_rec := QP_Modifier_List_Util.Get_Values
236: ( p_MODIFIER_LIST_rec => l_x_MODIFIER_LIST_rec
237: );
238: x_automatic := l_MODIFIER_LIST_val_rec.automatic;
239: x_currency := l_MODIFIER_LIST_val_rec.currency;
438: );
439: OE_debug_Pub.add('returned');
440: l_old_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
441:
442: IF p_attr_id = QP_Modifier_List_Util.G_AUTOMATIC THEN
443: l_MODIFIER_LIST_rec.automatic_flag := p_attr_value;
444: ELSIF p_attr_id = QP_Modifier_List_Util.G_COMMENTS THEN
445: l_MODIFIER_LIST_rec.comments := p_attr_value;
446: ELSIF p_attr_id = QP_Modifier_List_Util.G_CURRENCY THEN
440: l_old_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
441:
442: IF p_attr_id = QP_Modifier_List_Util.G_AUTOMATIC THEN
443: l_MODIFIER_LIST_rec.automatic_flag := p_attr_value;
444: ELSIF p_attr_id = QP_Modifier_List_Util.G_COMMENTS THEN
445: l_MODIFIER_LIST_rec.comments := p_attr_value;
446: ELSIF p_attr_id = QP_Modifier_List_Util.G_CURRENCY THEN
447: l_MODIFIER_LIST_rec.currency_code := p_attr_value;
448: ELSIF p_attr_id = QP_Modifier_List_Util.G_DISCOUNT_LINES THEN
442: IF p_attr_id = QP_Modifier_List_Util.G_AUTOMATIC THEN
443: l_MODIFIER_LIST_rec.automatic_flag := p_attr_value;
444: ELSIF p_attr_id = QP_Modifier_List_Util.G_COMMENTS THEN
445: l_MODIFIER_LIST_rec.comments := p_attr_value;
446: ELSIF p_attr_id = QP_Modifier_List_Util.G_CURRENCY THEN
447: l_MODIFIER_LIST_rec.currency_code := p_attr_value;
448: ELSIF p_attr_id = QP_Modifier_List_Util.G_DISCOUNT_LINES THEN
449: l_MODIFIER_LIST_rec.discount_lines_flag := p_attr_value;
450: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE THEN
444: ELSIF p_attr_id = QP_Modifier_List_Util.G_COMMENTS THEN
445: l_MODIFIER_LIST_rec.comments := p_attr_value;
446: ELSIF p_attr_id = QP_Modifier_List_Util.G_CURRENCY THEN
447: l_MODIFIER_LIST_rec.currency_code := p_attr_value;
448: ELSIF p_attr_id = QP_Modifier_List_Util.G_DISCOUNT_LINES THEN
449: l_MODIFIER_LIST_rec.discount_lines_flag := p_attr_value;
450: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE THEN
451: l_MODIFIER_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
452: ELSIF p_attr_id = QP_Modifier_List_Util.G_FREIGHT_TERMS THEN
446: ELSIF p_attr_id = QP_Modifier_List_Util.G_CURRENCY THEN
447: l_MODIFIER_LIST_rec.currency_code := p_attr_value;
448: ELSIF p_attr_id = QP_Modifier_List_Util.G_DISCOUNT_LINES THEN
449: l_MODIFIER_LIST_rec.discount_lines_flag := p_attr_value;
450: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE THEN
451: l_MODIFIER_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
452: ELSIF p_attr_id = QP_Modifier_List_Util.G_FREIGHT_TERMS THEN
453: l_MODIFIER_LIST_rec.freight_terms_code := p_attr_value;
454: ELSIF p_attr_id = QP_Modifier_List_Util.G_GSA_INDICATOR THEN
448: ELSIF p_attr_id = QP_Modifier_List_Util.G_DISCOUNT_LINES THEN
449: l_MODIFIER_LIST_rec.discount_lines_flag := p_attr_value;
450: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE THEN
451: l_MODIFIER_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
452: ELSIF p_attr_id = QP_Modifier_List_Util.G_FREIGHT_TERMS THEN
453: l_MODIFIER_LIST_rec.freight_terms_code := p_attr_value;
454: ELSIF p_attr_id = QP_Modifier_List_Util.G_GSA_INDICATOR THEN
455: l_MODIFIER_LIST_rec.gsa_indicator := p_attr_value;
456: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_HEADER THEN
450: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE THEN
451: l_MODIFIER_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
452: ELSIF p_attr_id = QP_Modifier_List_Util.G_FREIGHT_TERMS THEN
453: l_MODIFIER_LIST_rec.freight_terms_code := p_attr_value;
454: ELSIF p_attr_id = QP_Modifier_List_Util.G_GSA_INDICATOR THEN
455: l_MODIFIER_LIST_rec.gsa_indicator := p_attr_value;
456: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_HEADER THEN
457: l_MODIFIER_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_TYPE THEN
452: ELSIF p_attr_id = QP_Modifier_List_Util.G_FREIGHT_TERMS THEN
453: l_MODIFIER_LIST_rec.freight_terms_code := p_attr_value;
454: ELSIF p_attr_id = QP_Modifier_List_Util.G_GSA_INDICATOR THEN
455: l_MODIFIER_LIST_rec.gsa_indicator := p_attr_value;
456: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_HEADER THEN
457: l_MODIFIER_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_TYPE THEN
459: l_MODIFIER_LIST_rec.list_type_code := p_attr_value;
460: ELSIF p_attr_id = QP_Modifier_List_Util.G_PRORATE THEN
454: ELSIF p_attr_id = QP_Modifier_List_Util.G_GSA_INDICATOR THEN
455: l_MODIFIER_LIST_rec.gsa_indicator := p_attr_value;
456: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_HEADER THEN
457: l_MODIFIER_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_TYPE THEN
459: l_MODIFIER_LIST_rec.list_type_code := p_attr_value;
460: ELSIF p_attr_id = QP_Modifier_List_Util.G_PRORATE THEN
461: l_MODIFIER_LIST_rec.prorate_flag := p_attr_value;
462: ELSIF p_attr_id = QP_Modifier_List_Util.G_ROUNDING_FACTOR THEN
456: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_HEADER THEN
457: l_MODIFIER_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
458: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_TYPE THEN
459: l_MODIFIER_LIST_rec.list_type_code := p_attr_value;
460: ELSIF p_attr_id = QP_Modifier_List_Util.G_PRORATE THEN
461: l_MODIFIER_LIST_rec.prorate_flag := p_attr_value;
462: ELSIF p_attr_id = QP_Modifier_List_Util.G_ROUNDING_FACTOR THEN
463: l_MODIFIER_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHIP_METHOD THEN
458: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_TYPE THEN
459: l_MODIFIER_LIST_rec.list_type_code := p_attr_value;
460: ELSIF p_attr_id = QP_Modifier_List_Util.G_PRORATE THEN
461: l_MODIFIER_LIST_rec.prorate_flag := p_attr_value;
462: ELSIF p_attr_id = QP_Modifier_List_Util.G_ROUNDING_FACTOR THEN
463: l_MODIFIER_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHIP_METHOD THEN
465: l_MODIFIER_LIST_rec.ship_method_code := p_attr_value;
466: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE THEN
460: ELSIF p_attr_id = QP_Modifier_List_Util.G_PRORATE THEN
461: l_MODIFIER_LIST_rec.prorate_flag := p_attr_value;
462: ELSIF p_attr_id = QP_Modifier_List_Util.G_ROUNDING_FACTOR THEN
463: l_MODIFIER_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHIP_METHOD THEN
465: l_MODIFIER_LIST_rec.ship_method_code := p_attr_value;
466: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE THEN
467: l_MODIFIER_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
468: ELSIF p_attr_id = QP_Modifier_List_Util.G_TERMS THEN
462: ELSIF p_attr_id = QP_Modifier_List_Util.G_ROUNDING_FACTOR THEN
463: l_MODIFIER_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
464: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHIP_METHOD THEN
465: l_MODIFIER_LIST_rec.ship_method_code := p_attr_value;
466: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE THEN
467: l_MODIFIER_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
468: ELSIF p_attr_id = QP_Modifier_List_Util.G_TERMS THEN
469: l_MODIFIER_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = QP_Modifier_List_Util.G_NAME THEN
464: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHIP_METHOD THEN
465: l_MODIFIER_LIST_rec.ship_method_code := p_attr_value;
466: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE THEN
467: l_MODIFIER_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
468: ELSIF p_attr_id = QP_Modifier_List_Util.G_TERMS THEN
469: l_MODIFIER_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = QP_Modifier_List_Util.G_NAME THEN
471: l_MODIFIER_LIST_rec.name := p_attr_value;
472: ELSIF p_attr_id = QP_Modifier_List_Util.G_DESCRIPTION THEN
466: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE THEN
467: l_MODIFIER_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
468: ELSIF p_attr_id = QP_Modifier_List_Util.G_TERMS THEN
469: l_MODIFIER_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = QP_Modifier_List_Util.G_NAME THEN
471: l_MODIFIER_LIST_rec.name := p_attr_value;
472: ELSIF p_attr_id = QP_Modifier_List_Util.G_DESCRIPTION THEN
473: l_MODIFIER_LIST_rec.Description := p_attr_value;
474: ELSIF p_attr_id = QP_Modifier_List_Util.G_VERSION_NO THEN
468: ELSIF p_attr_id = QP_Modifier_List_Util.G_TERMS THEN
469: l_MODIFIER_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = QP_Modifier_List_Util.G_NAME THEN
471: l_MODIFIER_LIST_rec.name := p_attr_value;
472: ELSIF p_attr_id = QP_Modifier_List_Util.G_DESCRIPTION THEN
473: l_MODIFIER_LIST_rec.Description := p_attr_value;
474: ELSIF p_attr_id = QP_Modifier_List_Util.G_VERSION_NO THEN
475: l_MODIFIER_LIST_rec.Version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Modifier_List_Util.G_PARENT_LIST_HEADER_ID THEN
470: ELSIF p_attr_id = QP_Modifier_List_Util.G_NAME THEN
471: l_MODIFIER_LIST_rec.name := p_attr_value;
472: ELSIF p_attr_id = QP_Modifier_List_Util.G_DESCRIPTION THEN
473: l_MODIFIER_LIST_rec.Description := p_attr_value;
474: ELSIF p_attr_id = QP_Modifier_List_Util.G_VERSION_NO THEN
475: l_MODIFIER_LIST_rec.Version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Modifier_List_Util.G_PARENT_LIST_HEADER_ID THEN
477: l_MODIFIER_LIST_rec.Parent_list_header_id := TO_NUMBER(p_attr_value);
478: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_FLAG THEN
472: ELSIF p_attr_id = QP_Modifier_List_Util.G_DESCRIPTION THEN
473: l_MODIFIER_LIST_rec.Description := p_attr_value;
474: ELSIF p_attr_id = QP_Modifier_List_Util.G_VERSION_NO THEN
475: l_MODIFIER_LIST_rec.Version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Modifier_List_Util.G_PARENT_LIST_HEADER_ID THEN
477: l_MODIFIER_LIST_rec.Parent_list_header_id := TO_NUMBER(p_attr_value);
478: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_FLAG THEN
479: l_MODIFIER_LIST_rec.active_flag := p_attr_value;
480: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_FIRST THEN
474: ELSIF p_attr_id = QP_Modifier_List_Util.G_VERSION_NO THEN
475: l_MODIFIER_LIST_rec.Version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Modifier_List_Util.G_PARENT_LIST_HEADER_ID THEN
477: l_MODIFIER_LIST_rec.Parent_list_header_id := TO_NUMBER(p_attr_value);
478: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_FLAG THEN
479: l_MODIFIER_LIST_rec.active_flag := p_attr_value;
480: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_FIRST THEN
481: l_MODIFIER_LIST_rec.start_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
482: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_FIRST THEN
476: ELSIF p_attr_id = QP_Modifier_List_Util.G_PARENT_LIST_HEADER_ID THEN
477: l_MODIFIER_LIST_rec.Parent_list_header_id := TO_NUMBER(p_attr_value);
478: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_FLAG THEN
479: l_MODIFIER_LIST_rec.active_flag := p_attr_value;
480: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_FIRST THEN
481: l_MODIFIER_LIST_rec.start_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
482: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_FIRST THEN
483: l_MODIFIER_LIST_rec.end_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_SECOND THEN
478: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_FLAG THEN
479: l_MODIFIER_LIST_rec.active_flag := p_attr_value;
480: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_FIRST THEN
481: l_MODIFIER_LIST_rec.start_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
482: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_FIRST THEN
483: l_MODIFIER_LIST_rec.end_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_SECOND THEN
485: l_MODIFIER_LIST_rec.start_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
486: ELSIF p_attr_id = QP_Modifier_List_Util.G_GLOBAL_FLAG THEN
480: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_FIRST THEN
481: l_MODIFIER_LIST_rec.start_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
482: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_FIRST THEN
483: l_MODIFIER_LIST_rec.end_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_SECOND THEN
485: l_MODIFIER_LIST_rec.start_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
486: ELSIF p_attr_id = QP_Modifier_List_Util.G_GLOBAL_FLAG THEN
487: l_MODIFIER_LIST_rec.global_flag := p_attr_value;
488: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_SECOND THEN
482: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_FIRST THEN
483: l_MODIFIER_LIST_rec.end_date_active_first := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_SECOND THEN
485: l_MODIFIER_LIST_rec.start_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
486: ELSIF p_attr_id = QP_Modifier_List_Util.G_GLOBAL_FLAG THEN
487: l_MODIFIER_LIST_rec.global_flag := p_attr_value;
488: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_SECOND THEN
489: l_MODIFIER_LIST_rec.end_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
490: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_FIRST_TYPE THEN
484: ELSIF p_attr_id = QP_Modifier_List_Util.G_START_DATE_ACTIVE_SECOND THEN
485: l_MODIFIER_LIST_rec.start_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
486: ELSIF p_attr_id = QP_Modifier_List_Util.G_GLOBAL_FLAG THEN
487: l_MODIFIER_LIST_rec.global_flag := p_attr_value;
488: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_SECOND THEN
489: l_MODIFIER_LIST_rec.end_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
490: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_FIRST_TYPE THEN
491: l_MODIFIER_LIST_rec.active_date_first_type := p_attr_value;
492: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_SECOND_TYPE THEN
486: ELSIF p_attr_id = QP_Modifier_List_Util.G_GLOBAL_FLAG THEN
487: l_MODIFIER_LIST_rec.global_flag := p_attr_value;
488: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_SECOND THEN
489: l_MODIFIER_LIST_rec.end_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
490: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_FIRST_TYPE THEN
491: l_MODIFIER_LIST_rec.active_date_first_type := p_attr_value;
492: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_SECOND_TYPE THEN
493: l_MODIFIER_LIST_rec.active_date_second_type := p_attr_value;
494: ELSIF p_attr_id = QP_Modifier_List_Util.G_ASK_FOR THEN
488: ELSIF p_attr_id = QP_Modifier_List_Util.G_END_DATE_ACTIVE_SECOND THEN
489: l_MODIFIER_LIST_rec.end_date_active_second := TO_DATE(p_attr_value,'DD/MM/YYYY');
490: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_FIRST_TYPE THEN
491: l_MODIFIER_LIST_rec.active_date_first_type := p_attr_value;
492: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_SECOND_TYPE THEN
493: l_MODIFIER_LIST_rec.active_date_second_type := p_attr_value;
494: ELSIF p_attr_id = QP_Modifier_List_Util.G_ASK_FOR THEN
495: l_MODIFIER_LIST_rec.ask_for_flag := p_attr_value;
496: -- Blanket Agreement
490: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_FIRST_TYPE THEN
491: l_MODIFIER_LIST_rec.active_date_first_type := p_attr_value;
492: ELSIF p_attr_id = QP_Modifier_List_Util.G_ACTIVE_DATE_SECOND_TYPE THEN
493: l_MODIFIER_LIST_rec.active_date_second_type := p_attr_value;
494: ELSIF p_attr_id = QP_Modifier_List_Util.G_ASK_FOR THEN
495: l_MODIFIER_LIST_rec.ask_for_flag := p_attr_value;
496: -- Blanket Agreement
497: ELSIF p_attr_id = QP_Modifier_List_Util.G_SOURCE_SYSTEM_CODE THEN
498: l_MODIFIER_LIST_rec.source_system_code := p_attr_value;
493: l_MODIFIER_LIST_rec.active_date_second_type := p_attr_value;
494: ELSIF p_attr_id = QP_Modifier_List_Util.G_ASK_FOR THEN
495: l_MODIFIER_LIST_rec.ask_for_flag := p_attr_value;
496: -- Blanket Agreement
497: ELSIF p_attr_id = QP_Modifier_List_Util.G_SOURCE_SYSTEM_CODE THEN
498: l_MODIFIER_LIST_rec.source_system_code := p_attr_value;
499: ELSIF p_attr_id = QP_Modifier_List_Util.G_PTE_CODE THEN
500: l_MODIFIER_LIST_rec.pte_code := p_attr_value;
501: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_SOURCE_CODE THEN
495: l_MODIFIER_LIST_rec.ask_for_flag := p_attr_value;
496: -- Blanket Agreement
497: ELSIF p_attr_id = QP_Modifier_List_Util.G_SOURCE_SYSTEM_CODE THEN
498: l_MODIFIER_LIST_rec.source_system_code := p_attr_value;
499: ELSIF p_attr_id = QP_Modifier_List_Util.G_PTE_CODE THEN
500: l_MODIFIER_LIST_rec.pte_code := p_attr_value;
501: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_SOURCE_CODE THEN
502: l_MODIFIER_LIST_rec.list_source_code := p_attr_value;
503: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORIG_SYSTEM_HEADER_REF THEN
497: ELSIF p_attr_id = QP_Modifier_List_Util.G_SOURCE_SYSTEM_CODE THEN
498: l_MODIFIER_LIST_rec.source_system_code := p_attr_value;
499: ELSIF p_attr_id = QP_Modifier_List_Util.G_PTE_CODE THEN
500: l_MODIFIER_LIST_rec.pte_code := p_attr_value;
501: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_SOURCE_CODE THEN
502: l_MODIFIER_LIST_rec.list_source_code := p_attr_value;
503: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORIG_SYSTEM_HEADER_REF THEN
504: l_MODIFIER_LIST_rec.orig_system_header_ref := p_attr_value;
505: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHAREABLE_FLAG THEN
499: ELSIF p_attr_id = QP_Modifier_List_Util.G_PTE_CODE THEN
500: l_MODIFIER_LIST_rec.pte_code := p_attr_value;
501: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_SOURCE_CODE THEN
502: l_MODIFIER_LIST_rec.list_source_code := p_attr_value;
503: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORIG_SYSTEM_HEADER_REF THEN
504: l_MODIFIER_LIST_rec.orig_system_header_ref := p_attr_value;
505: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHAREABLE_FLAG THEN
506: l_MODIFIER_LIST_rec.shareable_flag := p_attr_value;
507: --added for MOAC
501: ELSIF p_attr_id = QP_Modifier_List_Util.G_LIST_SOURCE_CODE THEN
502: l_MODIFIER_LIST_rec.list_source_code := p_attr_value;
503: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORIG_SYSTEM_HEADER_REF THEN
504: l_MODIFIER_LIST_rec.orig_system_header_ref := p_attr_value;
505: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHAREABLE_FLAG THEN
506: l_MODIFIER_LIST_rec.shareable_flag := p_attr_value;
507: --added for MOAC
508: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORG_ID THEN
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
504: l_MODIFIER_LIST_rec.orig_system_header_ref := p_attr_value;
505: ELSIF p_attr_id = QP_Modifier_List_Util.G_SHAREABLE_FLAG THEN
506: l_MODIFIER_LIST_rec.shareable_flag := p_attr_value;
507: --added for MOAC
508: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORG_ID THEN
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
506: l_MODIFIER_LIST_rec.shareable_flag := p_attr_value;
507: --added for MOAC
508: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORG_ID THEN
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
507: --added for MOAC
508: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORG_ID THEN
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
508: ELSIF p_attr_id = QP_Modifier_List_Util.G_ORG_ID THEN
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
509: l_MODIFIER_LIST_rec.org_id := p_attr_value;
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
510: ELSIF p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE1
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
511: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE10
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
512: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE11
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
513: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE12
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
514: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE13
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
515: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE14
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
516: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE15
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
517: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE2
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
525: OR p_attr_id = QP_Modifier_List_Util.G_CONTEXT
518: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE3
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
525: OR p_attr_id = QP_Modifier_List_Util.G_CONTEXT
526: THEN
519: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE4
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
525: OR p_attr_id = QP_Modifier_List_Util.G_CONTEXT
526: THEN
527:
520: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE5
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
525: OR p_attr_id = QP_Modifier_List_Util.G_CONTEXT
526: THEN
527:
528: l_MODIFIER_LIST_rec.attribute1 := p_attribute1;
521: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE6
522: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE7
523: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE8
524: OR p_attr_id = QP_Modifier_List_Util.G_ATTRIBUTE9
525: OR p_attr_id = QP_Modifier_List_Util.G_CONTEXT
526: THEN
527:
528: l_MODIFIER_LIST_rec.attribute1 := p_attribute1;
529: l_MODIFIER_LIST_rec.attribute10 := p_attribute10;
662: x_org_id := FND_API.G_MISS_NUM;
663:
664: -- Load display out parameters if any
665:
666: l_MODIFIER_LIST_val_rec := QP_Modifier_List_Util.Get_Values
667: ( p_MODIFIER_LIST_rec => l_x_MODIFIER_LIST_rec
668: , p_old_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
669: );
670:
2061: THEN
2062:
2063: -- Query row from DB
2064:
2065: g_MODIFIER_LIST_rec := QP_Modifier_List_Util.Query_Row
2066: ( p_list_header_id => p_list_header_id
2067: );
2068:
2069: g_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;