327: x_service_period := l_x_MODIFIERS_rec.service_period; -- service project
328:
329: -- Load display out parameters if any
330:
331: l_MODIFIERS_val_rec := QP_Modifiers_Util.Get_Values
332: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
333: );
334: x_automatic := l_MODIFIERS_val_rec.automatic;
335: -- x_base_uom := l_MODIFIERS_val_rec.base_uom;
600: l_old_MODIFIERS_rec := l_MODIFIERS_rec;
601:
602:
603:
604: IF p_attr_id = QP_Modifiers_Util.G_ARITHMETIC_OPERATOR THEN
605: l_MODIFIERS_rec.arithmetic_operator := p_attr_value;
606: ELSIF p_attr_id = QP_Modifiers_Util.G_AUTOMATIC THEN
607: l_MODIFIERS_rec.automatic_flag := p_attr_value;
608: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_QTY THEN
602:
603:
604: IF p_attr_id = QP_Modifiers_Util.G_ARITHMETIC_OPERATOR THEN
605: l_MODIFIERS_rec.arithmetic_operator := p_attr_value;
606: ELSIF p_attr_id = QP_Modifiers_Util.G_AUTOMATIC THEN
607: l_MODIFIERS_rec.automatic_flag := p_attr_value;
608: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_QTY THEN
609: -- l_MODIFIERS_rec.base_qty := TO_NUMBER(p_attr_value);
610: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_PHASE THEN
604: IF p_attr_id = QP_Modifiers_Util.G_ARITHMETIC_OPERATOR THEN
605: l_MODIFIERS_rec.arithmetic_operator := p_attr_value;
606: ELSIF p_attr_id = QP_Modifiers_Util.G_AUTOMATIC THEN
607: l_MODIFIERS_rec.automatic_flag := p_attr_value;
608: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_QTY THEN
609: -- l_MODIFIERS_rec.base_qty := TO_NUMBER(p_attr_value);
610: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_PHASE THEN
611: l_MODIFIERS_rec.pricing_phase_id := TO_NUMBER(p_attr_value);
612: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_UOM THEN
606: ELSIF p_attr_id = QP_Modifiers_Util.G_AUTOMATIC THEN
607: l_MODIFIERS_rec.automatic_flag := p_attr_value;
608: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_QTY THEN
609: -- l_MODIFIERS_rec.base_qty := TO_NUMBER(p_attr_value);
610: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_PHASE THEN
611: l_MODIFIERS_rec.pricing_phase_id := TO_NUMBER(p_attr_value);
612: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_UOM THEN
613: -- l_MODIFIERS_rec.base_uom_code := p_attr_value;
614: ELSIF p_attr_id = QP_Modifiers_Util.G_COMMENTS THEN
608: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_QTY THEN
609: -- l_MODIFIERS_rec.base_qty := TO_NUMBER(p_attr_value);
610: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_PHASE THEN
611: l_MODIFIERS_rec.pricing_phase_id := TO_NUMBER(p_attr_value);
612: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_UOM THEN
613: -- l_MODIFIERS_rec.base_uom_code := p_attr_value;
614: ELSIF p_attr_id = QP_Modifiers_Util.G_COMMENTS THEN
615: l_MODIFIERS_rec.comments := p_attr_value;
616: ELSIF p_attr_id = QP_Modifiers_Util.G_EFFECTIVE_PERIOD_UOM THEN
610: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_PHASE THEN
611: l_MODIFIERS_rec.pricing_phase_id := TO_NUMBER(p_attr_value);
612: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_UOM THEN
613: -- l_MODIFIERS_rec.base_uom_code := p_attr_value;
614: ELSIF p_attr_id = QP_Modifiers_Util.G_COMMENTS THEN
615: l_MODIFIERS_rec.comments := p_attr_value;
616: ELSIF p_attr_id = QP_Modifiers_Util.G_EFFECTIVE_PERIOD_UOM THEN
617: l_MODIFIERS_rec.effective_period_uom := p_attr_value;
618: ELSIF p_attr_id = QP_Modifiers_Util.G_END_DATE_ACTIVE THEN
612: -- ELSIF p_attr_id = QP_Modifiers_Util.G_BASE_UOM THEN
613: -- l_MODIFIERS_rec.base_uom_code := p_attr_value;
614: ELSIF p_attr_id = QP_Modifiers_Util.G_COMMENTS THEN
615: l_MODIFIERS_rec.comments := p_attr_value;
616: ELSIF p_attr_id = QP_Modifiers_Util.G_EFFECTIVE_PERIOD_UOM THEN
617: l_MODIFIERS_rec.effective_period_uom := p_attr_value;
618: ELSIF p_attr_id = QP_Modifiers_Util.G_END_DATE_ACTIVE THEN
619: l_MODIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
620: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_ACCRUAL_RATE THEN
614: ELSIF p_attr_id = QP_Modifiers_Util.G_COMMENTS THEN
615: l_MODIFIERS_rec.comments := p_attr_value;
616: ELSIF p_attr_id = QP_Modifiers_Util.G_EFFECTIVE_PERIOD_UOM THEN
617: l_MODIFIERS_rec.effective_period_uom := p_attr_value;
618: ELSIF p_attr_id = QP_Modifiers_Util.G_END_DATE_ACTIVE THEN
619: l_MODIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
620: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_ACCRUAL_RATE THEN
621: l_MODIFIERS_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
622: ELSIF p_attr_id = QP_Modifiers_Util.G_GENERATE_USING_FORMULA THEN
616: ELSIF p_attr_id = QP_Modifiers_Util.G_EFFECTIVE_PERIOD_UOM THEN
617: l_MODIFIERS_rec.effective_period_uom := p_attr_value;
618: ELSIF p_attr_id = QP_Modifiers_Util.G_END_DATE_ACTIVE THEN
619: l_MODIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
620: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_ACCRUAL_RATE THEN
621: l_MODIFIERS_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
622: ELSIF p_attr_id = QP_Modifiers_Util.G_GENERATE_USING_FORMULA THEN
623: l_MODIFIERS_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
624: -- ELSIF p_attr_id = QP_Modifiers_Util.G_GL_CLASS THEN
618: ELSIF p_attr_id = QP_Modifiers_Util.G_END_DATE_ACTIVE THEN
619: l_MODIFIERS_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
620: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_ACCRUAL_RATE THEN
621: l_MODIFIERS_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
622: ELSIF p_attr_id = QP_Modifiers_Util.G_GENERATE_USING_FORMULA THEN
623: l_MODIFIERS_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
624: -- ELSIF p_attr_id = QP_Modifiers_Util.G_GL_CLASS THEN
625: -- l_MODIFIERS_rec.gl_class_id := TO_NUMBER(p_attr_value);
626: ELSIF p_attr_id = QP_Modifiers_Util.G_INVENTORY_ITEM THEN
620: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_ACCRUAL_RATE THEN
621: l_MODIFIERS_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
622: ELSIF p_attr_id = QP_Modifiers_Util.G_GENERATE_USING_FORMULA THEN
623: l_MODIFIERS_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
624: -- ELSIF p_attr_id = QP_Modifiers_Util.G_GL_CLASS THEN
625: -- l_MODIFIERS_rec.gl_class_id := TO_NUMBER(p_attr_value);
626: ELSIF p_attr_id = QP_Modifiers_Util.G_INVENTORY_ITEM THEN
627: l_MODIFIERS_rec.inventory_item_id := TO_NUMBER(p_attr_value);
628: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_HEADER THEN
622: ELSIF p_attr_id = QP_Modifiers_Util.G_GENERATE_USING_FORMULA THEN
623: l_MODIFIERS_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
624: -- ELSIF p_attr_id = QP_Modifiers_Util.G_GL_CLASS THEN
625: -- l_MODIFIERS_rec.gl_class_id := TO_NUMBER(p_attr_value);
626: ELSIF p_attr_id = QP_Modifiers_Util.G_INVENTORY_ITEM THEN
627: l_MODIFIERS_rec.inventory_item_id := TO_NUMBER(p_attr_value);
628: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_HEADER THEN
629: l_MODIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
630: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE THEN
624: -- ELSIF p_attr_id = QP_Modifiers_Util.G_GL_CLASS THEN
625: -- l_MODIFIERS_rec.gl_class_id := TO_NUMBER(p_attr_value);
626: ELSIF p_attr_id = QP_Modifiers_Util.G_INVENTORY_ITEM THEN
627: l_MODIFIERS_rec.inventory_item_id := TO_NUMBER(p_attr_value);
628: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_HEADER THEN
629: l_MODIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
630: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE THEN
631: l_MODIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
632: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_TYPE THEN
626: ELSIF p_attr_id = QP_Modifiers_Util.G_INVENTORY_ITEM THEN
627: l_MODIFIERS_rec.inventory_item_id := TO_NUMBER(p_attr_value);
628: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_HEADER THEN
629: l_MODIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
630: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE THEN
631: l_MODIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
632: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_TYPE THEN
633: l_MODIFIERS_rec.list_line_type_code := p_attr_value;
634: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE THEN
628: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_HEADER THEN
629: l_MODIFIERS_rec.list_header_id := TO_NUMBER(p_attr_value);
630: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE THEN
631: l_MODIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
632: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_TYPE THEN
633: l_MODIFIERS_rec.list_line_type_code := p_attr_value;
634: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE THEN
635: l_MODIFIERS_rec.list_price := TO_NUMBER(p_attr_value);
636: -- ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE_UOM THEN
630: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE THEN
631: l_MODIFIERS_rec.list_line_id := TO_NUMBER(p_attr_value);
632: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_TYPE THEN
633: l_MODIFIERS_rec.list_line_type_code := p_attr_value;
634: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE THEN
635: l_MODIFIERS_rec.list_price := TO_NUMBER(p_attr_value);
636: -- ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE_UOM THEN
637: -- l_MODIFIERS_rec.list_price_uom_code := p_attr_value;
638: ELSIF p_attr_id = QP_Modifiers_Util.G_MODIFIER_LEVEL THEN
632: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_TYPE THEN
633: l_MODIFIERS_rec.list_line_type_code := p_attr_value;
634: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE THEN
635: l_MODIFIERS_rec.list_price := TO_NUMBER(p_attr_value);
636: -- ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE_UOM THEN
637: -- l_MODIFIERS_rec.list_price_uom_code := p_attr_value;
638: ELSIF p_attr_id = QP_Modifiers_Util.G_MODIFIER_LEVEL THEN
639: l_MODIFIERS_rec.modifier_level_code := p_attr_value;
640: -- ELSIF p_attr_id = QP_Modifiers_Util.G_NEW_PRICE THEN
634: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE THEN
635: l_MODIFIERS_rec.list_price := TO_NUMBER(p_attr_value);
636: -- ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE_UOM THEN
637: -- l_MODIFIERS_rec.list_price_uom_code := p_attr_value;
638: ELSIF p_attr_id = QP_Modifiers_Util.G_MODIFIER_LEVEL THEN
639: l_MODIFIERS_rec.modifier_level_code := p_attr_value;
640: -- ELSIF p_attr_id = QP_Modifiers_Util.G_NEW_PRICE THEN
641: -- l_MODIFIERS_rec.new_price := TO_NUMBER(p_attr_value);
642: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
636: -- ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_PRICE_UOM THEN
637: -- l_MODIFIERS_rec.list_price_uom_code := p_attr_value;
638: ELSIF p_attr_id = QP_Modifiers_Util.G_MODIFIER_LEVEL THEN
639: l_MODIFIERS_rec.modifier_level_code := p_attr_value;
640: -- ELSIF p_attr_id = QP_Modifiers_Util.G_NEW_PRICE THEN
641: -- l_MODIFIERS_rec.new_price := TO_NUMBER(p_attr_value);
642: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
643: l_MODIFIERS_rec.number_effective_periods := TO_NUMBER(p_attr_value);
644: ELSIF p_attr_id = QP_Modifiers_Util.G_OPERAND THEN
638: ELSIF p_attr_id = QP_Modifiers_Util.G_MODIFIER_LEVEL THEN
639: l_MODIFIERS_rec.modifier_level_code := p_attr_value;
640: -- ELSIF p_attr_id = QP_Modifiers_Util.G_NEW_PRICE THEN
641: -- l_MODIFIERS_rec.new_price := TO_NUMBER(p_attr_value);
642: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
643: l_MODIFIERS_rec.number_effective_periods := TO_NUMBER(p_attr_value);
644: ELSIF p_attr_id = QP_Modifiers_Util.G_OPERAND THEN
645: l_MODIFIERS_rec.operand := TO_NUMBER(p_attr_value);
646: ELSIF p_attr_id = QP_Modifiers_Util.G_ORGANIZATION THEN
640: -- ELSIF p_attr_id = QP_Modifiers_Util.G_NEW_PRICE THEN
641: -- l_MODIFIERS_rec.new_price := TO_NUMBER(p_attr_value);
642: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
643: l_MODIFIERS_rec.number_effective_periods := TO_NUMBER(p_attr_value);
644: ELSIF p_attr_id = QP_Modifiers_Util.G_OPERAND THEN
645: l_MODIFIERS_rec.operand := TO_NUMBER(p_attr_value);
646: ELSIF p_attr_id = QP_Modifiers_Util.G_ORGANIZATION THEN
647: l_MODIFIERS_rec.organization_id := TO_NUMBER(p_attr_value);
648: ELSIF p_attr_id = QP_Modifiers_Util.G_OVERRIDE THEN
642: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
643: l_MODIFIERS_rec.number_effective_periods := TO_NUMBER(p_attr_value);
644: ELSIF p_attr_id = QP_Modifiers_Util.G_OPERAND THEN
645: l_MODIFIERS_rec.operand := TO_NUMBER(p_attr_value);
646: ELSIF p_attr_id = QP_Modifiers_Util.G_ORGANIZATION THEN
647: l_MODIFIERS_rec.organization_id := TO_NUMBER(p_attr_value);
648: ELSIF p_attr_id = QP_Modifiers_Util.G_OVERRIDE THEN
649: l_MODIFIERS_rec.override_flag := p_attr_value;
650: ELSIF p_attr_id = QP_Modifiers_Util.G_PERCENT_PRICE THEN
644: ELSIF p_attr_id = QP_Modifiers_Util.G_OPERAND THEN
645: l_MODIFIERS_rec.operand := TO_NUMBER(p_attr_value);
646: ELSIF p_attr_id = QP_Modifiers_Util.G_ORGANIZATION THEN
647: l_MODIFIERS_rec.organization_id := TO_NUMBER(p_attr_value);
648: ELSIF p_attr_id = QP_Modifiers_Util.G_OVERRIDE THEN
649: l_MODIFIERS_rec.override_flag := p_attr_value;
650: ELSIF p_attr_id = QP_Modifiers_Util.G_PERCENT_PRICE THEN
651: l_MODIFIERS_rec.percent_price := TO_NUMBER(p_attr_value);
652: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BREAK_TYPE THEN
646: ELSIF p_attr_id = QP_Modifiers_Util.G_ORGANIZATION THEN
647: l_MODIFIERS_rec.organization_id := TO_NUMBER(p_attr_value);
648: ELSIF p_attr_id = QP_Modifiers_Util.G_OVERRIDE THEN
649: l_MODIFIERS_rec.override_flag := p_attr_value;
650: ELSIF p_attr_id = QP_Modifiers_Util.G_PERCENT_PRICE THEN
651: l_MODIFIERS_rec.percent_price := TO_NUMBER(p_attr_value);
652: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BREAK_TYPE THEN
653: l_MODIFIERS_rec.price_break_type_code := p_attr_value;
654: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BY_FORMULA THEN
648: ELSIF p_attr_id = QP_Modifiers_Util.G_OVERRIDE THEN
649: l_MODIFIERS_rec.override_flag := p_attr_value;
650: ELSIF p_attr_id = QP_Modifiers_Util.G_PERCENT_PRICE THEN
651: l_MODIFIERS_rec.percent_price := TO_NUMBER(p_attr_value);
652: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BREAK_TYPE THEN
653: l_MODIFIERS_rec.price_break_type_code := p_attr_value;
654: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BY_FORMULA THEN
655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
650: ELSIF p_attr_id = QP_Modifiers_Util.G_PERCENT_PRICE THEN
651: l_MODIFIERS_rec.percent_price := TO_NUMBER(p_attr_value);
652: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BREAK_TYPE THEN
653: l_MODIFIERS_rec.price_break_type_code := p_attr_value;
654: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BY_FORMULA THEN
655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
652: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BREAK_TYPE THEN
653: l_MODIFIERS_rec.price_break_type_code := p_attr_value;
654: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BY_FORMULA THEN
655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
654: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICE_BY_FORMULA THEN
655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
655: l_MODIFIERS_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
656: ELSIF p_attr_id = QP_Modifiers_Util.G_PRIMARY_UOM THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN
657: l_MODIFIERS_rec.primary_uom_flag := p_attr_value;
658: ELSIF p_attr_id = QP_Modifiers_Util.G_PRINT_ON_INVOICE THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN
664: l_MODIFIERS_rec.rebate_trxn_type_code := p_attr_value;
665: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATED_ITEM THEN
659: OE_Debug_Pub.add(to_char(QP_Modifiers_Util.G_PRINT_ON_INVOICE)||to_char(p_attr_id));
660: l_MODIFIERS_rec.print_on_invoice_flag := p_attr_value;
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN
664: l_MODIFIERS_rec.rebate_trxn_type_code := p_attr_value;
665: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATED_ITEM THEN
666: l_MODIFIERS_rec.related_item_id := TO_NUMBER(p_attr_value);
667: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATIONSHIP_TYPE THEN
661: -- ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_SUBTYPE THEN
662: -- l_MODIFIERS_rec.rebate_subtype_code := p_attr_value;
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN
664: l_MODIFIERS_rec.rebate_trxn_type_code := p_attr_value;
665: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATED_ITEM THEN
666: l_MODIFIERS_rec.related_item_id := TO_NUMBER(p_attr_value);
667: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATIONSHIP_TYPE THEN
668: l_MODIFIERS_rec.relationship_type_id := TO_NUMBER(p_attr_value);
669: ELSIF p_attr_id = QP_Modifiers_Util.G_REPRICE THEN
663: ELSIF p_attr_id = QP_Modifiers_Util.G_REBATE_TRANSACTION_TYPE THEN
664: l_MODIFIERS_rec.rebate_trxn_type_code := p_attr_value;
665: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATED_ITEM THEN
666: l_MODIFIERS_rec.related_item_id := TO_NUMBER(p_attr_value);
667: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATIONSHIP_TYPE THEN
668: l_MODIFIERS_rec.relationship_type_id := TO_NUMBER(p_attr_value);
669: ELSIF p_attr_id = QP_Modifiers_Util.G_REPRICE THEN
670: l_MODIFIERS_rec.reprice_flag := p_attr_value;
671: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION THEN
665: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATED_ITEM THEN
666: l_MODIFIERS_rec.related_item_id := TO_NUMBER(p_attr_value);
667: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATIONSHIP_TYPE THEN
668: l_MODIFIERS_rec.relationship_type_id := TO_NUMBER(p_attr_value);
669: ELSIF p_attr_id = QP_Modifiers_Util.G_REPRICE THEN
670: l_MODIFIERS_rec.reprice_flag := p_attr_value;
671: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION THEN
672: l_MODIFIERS_rec.revision := p_attr_value;
673: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_DATE THEN
667: ELSIF p_attr_id = QP_Modifiers_Util.G_RELATIONSHIP_TYPE THEN
668: l_MODIFIERS_rec.relationship_type_id := TO_NUMBER(p_attr_value);
669: ELSIF p_attr_id = QP_Modifiers_Util.G_REPRICE THEN
670: l_MODIFIERS_rec.reprice_flag := p_attr_value;
671: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION THEN
672: l_MODIFIERS_rec.revision := p_attr_value;
673: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_DATE THEN
674: l_MODIFIERS_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
675: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_REASON THEN
669: ELSIF p_attr_id = QP_Modifiers_Util.G_REPRICE THEN
670: l_MODIFIERS_rec.reprice_flag := p_attr_value;
671: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION THEN
672: l_MODIFIERS_rec.revision := p_attr_value;
673: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_DATE THEN
674: l_MODIFIERS_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
675: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_REASON THEN
676: l_MODIFIERS_rec.revision_reason_code := p_attr_value;
677: ELSIF p_attr_id = QP_Modifiers_Util.G_START_DATE_ACTIVE THEN
671: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION THEN
672: l_MODIFIERS_rec.revision := p_attr_value;
673: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_DATE THEN
674: l_MODIFIERS_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
675: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_REASON THEN
676: l_MODIFIERS_rec.revision_reason_code := p_attr_value;
677: ELSIF p_attr_id = QP_Modifiers_Util.G_START_DATE_ACTIVE THEN
678: l_MODIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
679: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_ATTRIBUTE THEN
673: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_DATE THEN
674: l_MODIFIERS_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
675: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_REASON THEN
676: l_MODIFIERS_rec.revision_reason_code := p_attr_value;
677: ELSIF p_attr_id = QP_Modifiers_Util.G_START_DATE_ACTIVE THEN
678: l_MODIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
679: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_ATTRIBUTE THEN
680: l_MODIFIERS_rec.substitution_attribute := p_attr_value;
681: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_CONTEXT THEN
675: ELSIF p_attr_id = QP_Modifiers_Util.G_REVISION_REASON THEN
676: l_MODIFIERS_rec.revision_reason_code := p_attr_value;
677: ELSIF p_attr_id = QP_Modifiers_Util.G_START_DATE_ACTIVE THEN
678: l_MODIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
679: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_ATTRIBUTE THEN
680: l_MODIFIERS_rec.substitution_attribute := p_attr_value;
681: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_CONTEXT THEN
682: l_MODIFIERS_rec.substitution_context := p_attr_value;
683: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_VALUE THEN
677: ELSIF p_attr_id = QP_Modifiers_Util.G_START_DATE_ACTIVE THEN
678: l_MODIFIERS_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
679: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_ATTRIBUTE THEN
680: l_MODIFIERS_rec.substitution_attribute := p_attr_value;
681: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_CONTEXT THEN
682: l_MODIFIERS_rec.substitution_context := p_attr_value;
683: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_VALUE THEN
684: l_MODIFIERS_rec.substitution_value := p_attr_value;
685: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_FLAG THEN
679: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_ATTRIBUTE THEN
680: l_MODIFIERS_rec.substitution_attribute := p_attr_value;
681: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_CONTEXT THEN
682: l_MODIFIERS_rec.substitution_context := p_attr_value;
683: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_VALUE THEN
684: l_MODIFIERS_rec.substitution_value := p_attr_value;
685: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_FLAG THEN
686: l_MODIFIERS_rec.accrual_flag := p_attr_value;
687: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_GROUP_SEQUENCE THEN
681: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_CONTEXT THEN
682: l_MODIFIERS_rec.substitution_context := p_attr_value;
683: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_VALUE THEN
684: l_MODIFIERS_rec.substitution_value := p_attr_value;
685: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_FLAG THEN
686: l_MODIFIERS_rec.accrual_flag := p_attr_value;
687: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_GROUP_SEQUENCE THEN
688: l_MODIFIERS_rec.pricing_group_sequence := TO_NUMBER(p_attr_value);
689: ELSIF p_attr_id = QP_Modifiers_Util.G_INCOMPATIBILITY_GRP_CODE THEN
683: ELSIF p_attr_id = QP_Modifiers_Util.G_SUBSTITUTION_VALUE THEN
684: l_MODIFIERS_rec.substitution_value := p_attr_value;
685: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_FLAG THEN
686: l_MODIFIERS_rec.accrual_flag := p_attr_value;
687: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_GROUP_SEQUENCE THEN
688: l_MODIFIERS_rec.pricing_group_sequence := TO_NUMBER(p_attr_value);
689: ELSIF p_attr_id = QP_Modifiers_Util.G_INCOMPATIBILITY_GRP_CODE THEN
690: l_MODIFIERS_rec.incompatibility_grp_code := p_attr_value;
691: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_NO THEN
685: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_FLAG THEN
686: l_MODIFIERS_rec.accrual_flag := p_attr_value;
687: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_GROUP_SEQUENCE THEN
688: l_MODIFIERS_rec.pricing_group_sequence := TO_NUMBER(p_attr_value);
689: ELSIF p_attr_id = QP_Modifiers_Util.G_INCOMPATIBILITY_GRP_CODE THEN
690: l_MODIFIERS_rec.incompatibility_grp_code := p_attr_value;
691: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_NO THEN
692: l_MODIFIERS_rec.list_line_no := p_attr_value;
693: ELSIF p_attr_id = QP_Modifiers_Util.G_PRODUCT_PRECEDENCE THEN
687: ELSIF p_attr_id = QP_Modifiers_Util.G_PRICING_GROUP_SEQUENCE THEN
688: l_MODIFIERS_rec.pricing_group_sequence := TO_NUMBER(p_attr_value);
689: ELSIF p_attr_id = QP_Modifiers_Util.G_INCOMPATIBILITY_GRP_CODE THEN
690: l_MODIFIERS_rec.incompatibility_grp_code := p_attr_value;
691: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_NO THEN
692: l_MODIFIERS_rec.list_line_no := p_attr_value;
693: ELSIF p_attr_id = QP_Modifiers_Util.G_PRODUCT_PRECEDENCE THEN
694: l_MODIFIERS_rec.product_precedence := TO_NUMBER(p_attr_value);
695: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_START_DATE THEN
689: ELSIF p_attr_id = QP_Modifiers_Util.G_INCOMPATIBILITY_GRP_CODE THEN
690: l_MODIFIERS_rec.incompatibility_grp_code := p_attr_value;
691: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_NO THEN
692: l_MODIFIERS_rec.list_line_no := p_attr_value;
693: ELSIF p_attr_id = QP_Modifiers_Util.G_PRODUCT_PRECEDENCE THEN
694: l_MODIFIERS_rec.product_precedence := TO_NUMBER(p_attr_value);
695: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_START_DATE THEN
696: l_MODIFIERS_rec.expiration_period_start_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
697: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EXPIRATION_PERIODS THEN
691: ELSIF p_attr_id = QP_Modifiers_Util.G_LIST_LINE_NO THEN
692: l_MODIFIERS_rec.list_line_no := p_attr_value;
693: ELSIF p_attr_id = QP_Modifiers_Util.G_PRODUCT_PRECEDENCE THEN
694: l_MODIFIERS_rec.product_precedence := TO_NUMBER(p_attr_value);
695: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_START_DATE THEN
696: l_MODIFIERS_rec.expiration_period_start_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
697: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EXPIRATION_PERIODS THEN
698: l_MODIFIERS_rec.number_expiration_periods := TO_NUMBER(p_attr_value);
699: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_UOM THEN
693: ELSIF p_attr_id = QP_Modifiers_Util.G_PRODUCT_PRECEDENCE THEN
694: l_MODIFIERS_rec.product_precedence := TO_NUMBER(p_attr_value);
695: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_START_DATE THEN
696: l_MODIFIERS_rec.expiration_period_start_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
697: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EXPIRATION_PERIODS THEN
698: l_MODIFIERS_rec.number_expiration_periods := TO_NUMBER(p_attr_value);
699: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_UOM THEN
700: l_MODIFIERS_rec.expiration_period_uom := p_attr_value;
701: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_DATE THEN
695: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_START_DATE THEN
696: l_MODIFIERS_rec.expiration_period_start_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
697: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EXPIRATION_PERIODS THEN
698: l_MODIFIERS_rec.number_expiration_periods := TO_NUMBER(p_attr_value);
699: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_UOM THEN
700: l_MODIFIERS_rec.expiration_period_uom := p_attr_value;
701: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_DATE THEN
702: l_MODIFIERS_rec.expiration_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
703: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_GL_VALUE THEN
697: ELSIF p_attr_id = QP_Modifiers_Util.G_NUMBER_EXPIRATION_PERIODS THEN
698: l_MODIFIERS_rec.number_expiration_periods := TO_NUMBER(p_attr_value);
699: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_UOM THEN
700: l_MODIFIERS_rec.expiration_period_uom := p_attr_value;
701: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_DATE THEN
702: l_MODIFIERS_rec.expiration_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
703: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_GL_VALUE THEN
704: l_MODIFIERS_rec.estim_gl_value := TO_NUMBER(p_attr_value);
705: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_PRICE_LIST_LINE THEN
699: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_PERIOD_UOM THEN
700: l_MODIFIERS_rec.expiration_period_uom := p_attr_value;
701: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_DATE THEN
702: l_MODIFIERS_rec.expiration_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
703: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_GL_VALUE THEN
704: l_MODIFIERS_rec.estim_gl_value := TO_NUMBER(p_attr_value);
705: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_PRICE_LIST_LINE THEN
706: l_MODIFIERS_rec.benefit_price_list_line_id := TO_NUMBER(p_attr_value);
707: -- ELSIF p_attr_id = QP_Modifiers_Util.G_RECURRING_FLAG THEN
701: ELSIF p_attr_id = QP_Modifiers_Util.G_EXPIRATION_DATE THEN
702: l_MODIFIERS_rec.expiration_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
703: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_GL_VALUE THEN
704: l_MODIFIERS_rec.estim_gl_value := TO_NUMBER(p_attr_value);
705: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_PRICE_LIST_LINE THEN
706: l_MODIFIERS_rec.benefit_price_list_line_id := TO_NUMBER(p_attr_value);
707: -- ELSIF p_attr_id = QP_Modifiers_Util.G_RECURRING_FLAG THEN
708: -- l_MODIFIERS_rec.recurring_flag := p_attr_value;
709: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_LIMIT THEN
703: ELSIF p_attr_id = QP_Modifiers_Util.G_ESTIM_GL_VALUE THEN
704: l_MODIFIERS_rec.estim_gl_value := TO_NUMBER(p_attr_value);
705: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_PRICE_LIST_LINE THEN
706: l_MODIFIERS_rec.benefit_price_list_line_id := TO_NUMBER(p_attr_value);
707: -- ELSIF p_attr_id = QP_Modifiers_Util.G_RECURRING_FLAG THEN
708: -- l_MODIFIERS_rec.recurring_flag := p_attr_value;
709: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_LIMIT THEN
710: l_MODIFIERS_rec.benefit_limit := TO_NUMBER(p_attr_value);
711: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_TYPE THEN
705: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_PRICE_LIST_LINE THEN
706: l_MODIFIERS_rec.benefit_price_list_line_id := TO_NUMBER(p_attr_value);
707: -- ELSIF p_attr_id = QP_Modifiers_Util.G_RECURRING_FLAG THEN
708: -- l_MODIFIERS_rec.recurring_flag := p_attr_value;
709: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_LIMIT THEN
710: l_MODIFIERS_rec.benefit_limit := TO_NUMBER(p_attr_value);
711: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_TYPE THEN
712: l_MODIFIERS_rec.charge_type_code := p_attr_value;
713: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_SUBTYPE THEN
707: -- ELSIF p_attr_id = QP_Modifiers_Util.G_RECURRING_FLAG THEN
708: -- l_MODIFIERS_rec.recurring_flag := p_attr_value;
709: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_LIMIT THEN
710: l_MODIFIERS_rec.benefit_limit := TO_NUMBER(p_attr_value);
711: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_TYPE THEN
712: l_MODIFIERS_rec.charge_type_code := p_attr_value;
713: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_SUBTYPE THEN
714: l_MODIFIERS_rec.charge_subtype_code := p_attr_value;
715: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_QTY THEN
709: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_LIMIT THEN
710: l_MODIFIERS_rec.benefit_limit := TO_NUMBER(p_attr_value);
711: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_TYPE THEN
712: l_MODIFIERS_rec.charge_type_code := p_attr_value;
713: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_SUBTYPE THEN
714: l_MODIFIERS_rec.charge_subtype_code := p_attr_value;
715: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_QTY THEN
716: l_MODIFIERS_rec.benefit_qty := TO_NUMBER(p_attr_value);
717: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_UOM THEN
711: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_TYPE THEN
712: l_MODIFIERS_rec.charge_type_code := p_attr_value;
713: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_SUBTYPE THEN
714: l_MODIFIERS_rec.charge_subtype_code := p_attr_value;
715: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_QTY THEN
716: l_MODIFIERS_rec.benefit_qty := TO_NUMBER(p_attr_value);
717: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_UOM THEN
718: l_MODIFIERS_rec.benefit_uom_code := p_attr_value;
719: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_CONVERSION_RATE THEN
713: ELSIF p_attr_id = QP_Modifiers_Util.G_CHARGE_SUBTYPE THEN
714: l_MODIFIERS_rec.charge_subtype_code := p_attr_value;
715: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_QTY THEN
716: l_MODIFIERS_rec.benefit_qty := TO_NUMBER(p_attr_value);
717: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_UOM THEN
718: l_MODIFIERS_rec.benefit_uom_code := p_attr_value;
719: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_CONVERSION_RATE THEN
720: l_MODIFIERS_rec.accrual_conversion_rate := TO_NUMBER(p_attr_value);
721: ELSIF p_attr_id = QP_Modifiers_Util.G_PRORATION_TYPE THEN
715: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_QTY THEN
716: l_MODIFIERS_rec.benefit_qty := TO_NUMBER(p_attr_value);
717: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_UOM THEN
718: l_MODIFIERS_rec.benefit_uom_code := p_attr_value;
719: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_CONVERSION_RATE THEN
720: l_MODIFIERS_rec.accrual_conversion_rate := TO_NUMBER(p_attr_value);
721: ELSIF p_attr_id = QP_Modifiers_Util.G_PRORATION_TYPE THEN
722: l_MODIFIERS_rec.proration_type_code := p_attr_value;
723: ELSIF p_attr_id = QP_Modifiers_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
717: ELSIF p_attr_id = QP_Modifiers_Util.G_BENEFIT_UOM THEN
718: l_MODIFIERS_rec.benefit_uom_code := p_attr_value;
719: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_CONVERSION_RATE THEN
720: l_MODIFIERS_rec.accrual_conversion_rate := TO_NUMBER(p_attr_value);
721: ELSIF p_attr_id = QP_Modifiers_Util.G_PRORATION_TYPE THEN
722: l_MODIFIERS_rec.proration_type_code := p_attr_value;
723: ELSIF p_attr_id = QP_Modifiers_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
724: l_MODIFIERS_rec.include_on_returns_flag := p_attr_value;
725: ELSIF p_attr_id = QP_Modifiers_Util.G_FROM_RLTD_MODIFIER THEN
719: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCRUAL_CONVERSION_RATE THEN
720: l_MODIFIERS_rec.accrual_conversion_rate := TO_NUMBER(p_attr_value);
721: ELSIF p_attr_id = QP_Modifiers_Util.G_PRORATION_TYPE THEN
722: l_MODIFIERS_rec.proration_type_code := p_attr_value;
723: ELSIF p_attr_id = QP_Modifiers_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
724: l_MODIFIERS_rec.include_on_returns_flag := p_attr_value;
725: ELSIF p_attr_id = QP_Modifiers_Util.G_FROM_RLTD_MODIFIER THEN
726: l_MODIFIERS_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
727: ELSIF p_attr_id = QP_Modifiers_Util.G_TO_RLTD_MODIFIER THEN
721: ELSIF p_attr_id = QP_Modifiers_Util.G_PRORATION_TYPE THEN
722: l_MODIFIERS_rec.proration_type_code := p_attr_value;
723: ELSIF p_attr_id = QP_Modifiers_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
724: l_MODIFIERS_rec.include_on_returns_flag := p_attr_value;
725: ELSIF p_attr_id = QP_Modifiers_Util.G_FROM_RLTD_MODIFIER THEN
726: l_MODIFIERS_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
727: ELSIF p_attr_id = QP_Modifiers_Util.G_TO_RLTD_MODIFIER THEN
728: l_MODIFIERS_rec.to_rltd_modifier_id := TO_NUMBER(p_attr_value);
729: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_NO THEN
723: ELSIF p_attr_id = QP_Modifiers_Util.G_INCLUDE_ON_RETURNS_FLAG THEN
724: l_MODIFIERS_rec.include_on_returns_flag := p_attr_value;
725: ELSIF p_attr_id = QP_Modifiers_Util.G_FROM_RLTD_MODIFIER THEN
726: l_MODIFIERS_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
727: ELSIF p_attr_id = QP_Modifiers_Util.G_TO_RLTD_MODIFIER THEN
728: l_MODIFIERS_rec.to_rltd_modifier_id := TO_NUMBER(p_attr_value);
729: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_NO THEN
730: l_MODIFIERS_rec.rltd_modifier_grp_no := TO_NUMBER(p_attr_value);
731: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_TYPE THEN
725: ELSIF p_attr_id = QP_Modifiers_Util.G_FROM_RLTD_MODIFIER THEN
726: l_MODIFIERS_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
727: ELSIF p_attr_id = QP_Modifiers_Util.G_TO_RLTD_MODIFIER THEN
728: l_MODIFIERS_rec.to_rltd_modifier_id := TO_NUMBER(p_attr_value);
729: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_NO THEN
730: l_MODIFIERS_rec.rltd_modifier_grp_no := TO_NUMBER(p_attr_value);
731: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_TYPE THEN
732: l_MODIFIERS_rec.rltd_modifier_grp_type := p_attr_value;
733: ELSIF p_attr_id = QP_Modifiers_Util.G_NET_AMOUNT THEN
727: ELSIF p_attr_id = QP_Modifiers_Util.G_TO_RLTD_MODIFIER THEN
728: l_MODIFIERS_rec.to_rltd_modifier_id := TO_NUMBER(p_attr_value);
729: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_NO THEN
730: l_MODIFIERS_rec.rltd_modifier_grp_no := TO_NUMBER(p_attr_value);
731: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_TYPE THEN
732: l_MODIFIERS_rec.rltd_modifier_grp_type := p_attr_value;
733: ELSIF p_attr_id = QP_Modifiers_Util.G_NET_AMOUNT THEN
734: l_MODIFIERS_rec.net_amount_flag := p_attr_value;
735: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCUM_ATTRIBUTE THEN
729: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_NO THEN
730: l_MODIFIERS_rec.rltd_modifier_grp_no := TO_NUMBER(p_attr_value);
731: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_TYPE THEN
732: l_MODIFIERS_rec.rltd_modifier_grp_type := p_attr_value;
733: ELSIF p_attr_id = QP_Modifiers_Util.G_NET_AMOUNT THEN
734: l_MODIFIERS_rec.net_amount_flag := p_attr_value;
735: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCUM_ATTRIBUTE THEN
736: l_MODIFIERS_rec.accum_attribute := p_attr_value;
737: ELSIF p_attr_id = QP_Modifiers_Util.G_continuous_price_break_flag THEN
731: ELSIF p_attr_id = QP_Modifiers_Util.G_RLTD_MODIFIER_GRP_TYPE THEN
732: l_MODIFIERS_rec.rltd_modifier_grp_type := p_attr_value;
733: ELSIF p_attr_id = QP_Modifiers_Util.G_NET_AMOUNT THEN
734: l_MODIFIERS_rec.net_amount_flag := p_attr_value;
735: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCUM_ATTRIBUTE THEN
736: l_MODIFIERS_rec.accum_attribute := p_attr_value;
737: ELSIF p_attr_id = QP_Modifiers_Util.G_continuous_price_break_flag THEN
738: l_MODIFIERS_rec.continuous_price_break_flag := p_attr_value; --Continuous
739: --Price Breaks
733: ELSIF p_attr_id = QP_Modifiers_Util.G_NET_AMOUNT THEN
734: l_MODIFIERS_rec.net_amount_flag := p_attr_value;
735: ELSIF p_attr_id = QP_Modifiers_Util.G_ACCUM_ATTRIBUTE THEN
736: l_MODIFIERS_rec.accum_attribute := p_attr_value;
737: ELSIF p_attr_id = QP_Modifiers_Util.G_continuous_price_break_flag THEN
738: l_MODIFIERS_rec.continuous_price_break_flag := p_attr_value; --Continuous
739: --Price Breaks
740: -- service project
741: ELSIF p_attr_id = QP_Modifiers_Util.G_service_period THEN
737: ELSIF p_attr_id = QP_Modifiers_Util.G_continuous_price_break_flag THEN
738: l_MODIFIERS_rec.continuous_price_break_flag := p_attr_value; --Continuous
739: --Price Breaks
740: -- service project
741: ELSIF p_attr_id = QP_Modifiers_Util.G_service_period THEN
742: l_MODIFIERS_rec.service_period := p_attr_value;
743: ELSIF p_attr_id = QP_Modifiers_Util.G_service_duration THEN
744: l_MODIFIERS_rec.service_duration := p_attr_value;
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
739: --Price Breaks
740: -- service project
741: ELSIF p_attr_id = QP_Modifiers_Util.G_service_period THEN
742: l_MODIFIERS_rec.service_period := p_attr_value;
743: ELSIF p_attr_id = QP_Modifiers_Util.G_service_duration THEN
744: l_MODIFIERS_rec.service_duration := p_attr_value;
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
743: ELSIF p_attr_id = QP_Modifiers_Util.G_service_duration THEN
744: l_MODIFIERS_rec.service_duration := p_attr_value;
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
744: l_MODIFIERS_rec.service_duration := p_attr_value;
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
745: oe_debug_pub.add('JP Service Project - ' || p_attr_value);
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
746: -- service project
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
747: ELSIF p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE1
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
748: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE10
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
749: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE11
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
750: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE12
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
751: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE13
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
752: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE14
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
753: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE15
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
754: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE2
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
762: OR p_attr_id = QP_Modifiers_Util.G_CONTEXT
755: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE3
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
762: OR p_attr_id = QP_Modifiers_Util.G_CONTEXT
763: THEN
756: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE4
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
762: OR p_attr_id = QP_Modifiers_Util.G_CONTEXT
763: THEN
764:
757: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE5
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
762: OR p_attr_id = QP_Modifiers_Util.G_CONTEXT
763: THEN
764:
765: l_MODIFIERS_rec.attribute1 := p_attribute1;
758: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE6
759: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE7
760: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE8
761: OR p_attr_id = QP_Modifiers_Util.G_ATTRIBUTE9
762: OR p_attr_id = QP_Modifiers_Util.G_CONTEXT
763: THEN
764:
765: l_MODIFIERS_rec.attribute1 := p_attribute1;
766: l_MODIFIERS_rec.attribute10 := p_attribute10;
950:
951:
952: -- Load display out parameters if any
953:
954: l_MODIFIERS_val_rec := QP_Modifiers_Util.Get_Values
955: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
956: , p_old_MODIFIERS_rec => l_MODIFIERS_rec
957: );
958:
2322: THEN
2323:
2324: -- Query row from DB
2325:
2326: g_MODIFIERS_rec := QP_Modifiers_Util.Query_Row
2327: ( p_list_line_id => p_list_line_id
2328: );
2329:
2330: g_MODIFIERS_rec.db_flag := FND_API.G_TRUE;