eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_PRICE_LIST_LINE dependencies on QP_PRICE_LIST_LINE_UTIL

Line 285: l_PRICE_LIST_LINE_val_rec := QP_Price_List_Line_Util.Get_Values

281: -- Load display out parameters if any
282:
283: oe_debug_pub.add('before get values');
284:
285: l_PRICE_LIST_LINE_val_rec := QP_Price_List_Line_Util.Get_Values
286: ( p_PRICE_LIST_LINE_rec => l_x_PRICE_LIST_LINE_rec
287: );
288: x_accrual_uom := l_PRICE_LIST_LINE_val_rec.accrual_uom;
289: x_automatic := l_PRICE_LIST_LINE_val_rec.automatic;

Line 535: IF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_QTY THEN

531:
532: oe_debug_pub.add('prog app id in ca pll 1 is: ' || l_PRICE_LIST_LINE_rec.program_application_id);
533: oe_debug_pub.add('prog id in ca pll 1 is: ' || l_PRICE_LIST_LINE_rec.program_id);
534:
535: IF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_QTY THEN
536: l_PRICE_LIST_LINE_rec.accrual_qty := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_UOM THEN
538: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_attr_value;
539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN

Line 537: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_UOM THEN

533: oe_debug_pub.add('prog id in ca pll 1 is: ' || l_PRICE_LIST_LINE_rec.program_id);
534:
535: IF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_QTY THEN
536: l_PRICE_LIST_LINE_rec.accrual_qty := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_UOM THEN
538: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_attr_value;
539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN
540: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_attr_value;
541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN

Line 539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN

535: IF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_QTY THEN
536: l_PRICE_LIST_LINE_rec.accrual_qty := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_UOM THEN
538: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_attr_value;
539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN
540: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_attr_value;
541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN
542: l_PRICE_LIST_LINE_rec.automatic_flag := p_attr_value;
543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN

Line 541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN

537: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ACCRUAL_UOM THEN
538: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_attr_value;
539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN
540: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_attr_value;
541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN
542: l_PRICE_LIST_LINE_rec.automatic_flag := p_attr_value;
543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN
544: l_PRICE_LIST_LINE_rec.base_qty := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN

Line 543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN

539: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ARITHMETIC_OPERATOR THEN
540: l_PRICE_LIST_LINE_rec.arithmetic_operator := p_attr_value;
541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN
542: l_PRICE_LIST_LINE_rec.automatic_flag := p_attr_value;
543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN
544: l_PRICE_LIST_LINE_rec.base_qty := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN
546: l_PRICE_LIST_LINE_rec.base_uom_code := p_attr_value;
547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN

Line 545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN

541: ELSIF p_attr_id = QP_Price_List_Line_Util.G_AUTOMATIC THEN
542: l_PRICE_LIST_LINE_rec.automatic_flag := p_attr_value;
543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN
544: l_PRICE_LIST_LINE_rec.base_qty := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN
546: l_PRICE_LIST_LINE_rec.base_uom_code := p_attr_value;
547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN
548: l_PRICE_LIST_LINE_rec.comments := p_attr_value;
549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN

Line 547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN

543: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_QTY THEN
544: l_PRICE_LIST_LINE_rec.base_qty := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN
546: l_PRICE_LIST_LINE_rec.base_uom_code := p_attr_value;
547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN
548: l_PRICE_LIST_LINE_rec.comments := p_attr_value;
549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN
550: l_PRICE_LIST_LINE_rec.effective_period_uom := p_attr_value;
551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN

Line 549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN

545: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BASE_UOM THEN
546: l_PRICE_LIST_LINE_rec.base_uom_code := p_attr_value;
547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN
548: l_PRICE_LIST_LINE_rec.comments := p_attr_value;
549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN
550: l_PRICE_LIST_LINE_rec.effective_period_uom := p_attr_value;
551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
552: l_PRICE_LIST_LINE_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN

Line 551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN

547: ELSIF p_attr_id = QP_Price_List_Line_Util.G_COMMENTS THEN
548: l_PRICE_LIST_LINE_rec.comments := p_attr_value;
549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN
550: l_PRICE_LIST_LINE_rec.effective_period_uom := p_attr_value;
551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
552: l_PRICE_LIST_LINE_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN
554: l_PRICE_LIST_LINE_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN

Line 553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN

549: ELSIF p_attr_id = QP_Price_List_Line_Util.G_EFFECTIVE_PERIOD_UOM THEN
550: l_PRICE_LIST_LINE_rec.effective_period_uom := p_attr_value;
551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
552: l_PRICE_LIST_LINE_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN
554: l_PRICE_LIST_LINE_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN
556: l_PRICE_LIST_LINE_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN

Line 555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN

551: ELSIF p_attr_id = QP_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
552: l_PRICE_LIST_LINE_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN
554: l_PRICE_LIST_LINE_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN
556: l_PRICE_LIST_LINE_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN
558: l_PRICE_LIST_LINE_rec.inventory_item_id := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN

Line 557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN

553: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ESTIM_ACCRUAL_RATE THEN
554: l_PRICE_LIST_LINE_rec.estim_accrual_rate := TO_NUMBER(p_attr_value);
555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN
556: l_PRICE_LIST_LINE_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN
558: l_PRICE_LIST_LINE_rec.inventory_item_id := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN
560: l_PRICE_LIST_LINE_rec.list_header_id := TO_NUMBER(p_attr_value);
561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN

Line 559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN

555: ELSIF p_attr_id = QP_Price_List_Line_Util.G_GENERATE_USING_FORMULA THEN
556: l_PRICE_LIST_LINE_rec.generate_using_formula_id := TO_NUMBER(p_attr_value);
557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN
558: l_PRICE_LIST_LINE_rec.inventory_item_id := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN
560: l_PRICE_LIST_LINE_rec.list_header_id := TO_NUMBER(p_attr_value);
561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN
562: l_PRICE_LIST_LINE_rec.list_line_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN

Line 561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN

557: ELSIF p_attr_id = QP_Price_List_Line_Util.G_INVENTORY_ITEM THEN
558: l_PRICE_LIST_LINE_rec.inventory_item_id := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN
560: l_PRICE_LIST_LINE_rec.list_header_id := TO_NUMBER(p_attr_value);
561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN
562: l_PRICE_LIST_LINE_rec.list_line_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN
564: l_PRICE_LIST_LINE_rec.list_line_type_code := p_attr_value;
565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN

Line 563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN

559: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_HEADER THEN
560: l_PRICE_LIST_LINE_rec.list_header_id := TO_NUMBER(p_attr_value);
561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN
562: l_PRICE_LIST_LINE_rec.list_line_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN
564: l_PRICE_LIST_LINE_rec.list_line_type_code := p_attr_value;
565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN
566: l_PRICE_LIST_LINE_rec.list_price := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN

Line 565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN

561: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE THEN
562: l_PRICE_LIST_LINE_rec.list_line_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN
564: l_PRICE_LIST_LINE_rec.list_line_type_code := p_attr_value;
565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN
566: l_PRICE_LIST_LINE_rec.list_price := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN
568: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN

Line 567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN

563: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_LINE_TYPE THEN
564: l_PRICE_LIST_LINE_rec.list_line_type_code := p_attr_value;
565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN
566: l_PRICE_LIST_LINE_rec.list_price := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN
568: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN
570: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN

Line 569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN

565: ELSIF p_attr_id = QP_Price_List_Line_Util.G_LIST_PRICE THEN
566: l_PRICE_LIST_LINE_rec.list_price := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN
568: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN
570: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN
572: l_PRICE_LIST_LINE_rec.product_precedence := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN

Line 571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN

567: ELSIF p_attr_id = QP_Price_List_Line_Util.G_FROM_RLTD_MODIFIER THEN
568: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN
570: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN
572: l_PRICE_LIST_LINE_rec.product_precedence := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN
574: l_PRICE_LIST_LINE_rec.modifier_level_code := p_attr_value;
575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN

Line 573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN

569: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RLTD_MODIFIER_GROUP_NO THEN
570: l_PRICE_LIST_LINE_rec.rltd_modifier_group_no := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN
572: l_PRICE_LIST_LINE_rec.product_precedence := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN
574: l_PRICE_LIST_LINE_rec.modifier_level_code := p_attr_value;
575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
576: l_PRICE_LIST_LINE_rec.number_effective_periods := TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN

Line 575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN

571: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRODUCT_PRECEDENCE THEN
572: l_PRICE_LIST_LINE_rec.product_precedence := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN
574: l_PRICE_LIST_LINE_rec.modifier_level_code := p_attr_value;
575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
576: l_PRICE_LIST_LINE_rec.number_effective_periods := TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN
578: l_PRICE_LIST_LINE_rec.operand := TO_NUMBER(p_attr_value);
579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN

Line 577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN

573: ELSIF p_attr_id = QP_Price_List_Line_Util.G_MODIFIER_LEVEL THEN
574: l_PRICE_LIST_LINE_rec.modifier_level_code := p_attr_value;
575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
576: l_PRICE_LIST_LINE_rec.number_effective_periods := TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN
578: l_PRICE_LIST_LINE_rec.operand := TO_NUMBER(p_attr_value);
579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN
580: l_PRICE_LIST_LINE_rec.organization_id := TO_NUMBER(p_attr_value);
581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN

Line 579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN

575: ELSIF p_attr_id = QP_Price_List_Line_Util.G_NUMBER_EFFECTIVE_PERIODS THEN
576: l_PRICE_LIST_LINE_rec.number_effective_periods := TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN
578: l_PRICE_LIST_LINE_rec.operand := TO_NUMBER(p_attr_value);
579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN
580: l_PRICE_LIST_LINE_rec.organization_id := TO_NUMBER(p_attr_value);
581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN
582: l_PRICE_LIST_LINE_rec.override_flag := p_attr_value;
583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN

Line 581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN

577: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OPERAND THEN
578: l_PRICE_LIST_LINE_rec.operand := TO_NUMBER(p_attr_value);
579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN
580: l_PRICE_LIST_LINE_rec.organization_id := TO_NUMBER(p_attr_value);
581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN
582: l_PRICE_LIST_LINE_rec.override_flag := p_attr_value;
583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN
584: l_PRICE_LIST_LINE_rec.percent_price := TO_NUMBER(p_attr_value);
585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN

Line 583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN

579: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ORGANIZATION THEN
580: l_PRICE_LIST_LINE_rec.organization_id := TO_NUMBER(p_attr_value);
581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN
582: l_PRICE_LIST_LINE_rec.override_flag := p_attr_value;
583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN
584: l_PRICE_LIST_LINE_rec.percent_price := TO_NUMBER(p_attr_value);
585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN
586: l_PRICE_LIST_LINE_rec.price_break_type_code := p_attr_value;
587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN

Line 585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN

581: ELSIF p_attr_id = QP_Price_List_Line_Util.G_OVERRIDE THEN
582: l_PRICE_LIST_LINE_rec.override_flag := p_attr_value;
583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN
584: l_PRICE_LIST_LINE_rec.percent_price := TO_NUMBER(p_attr_value);
585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN
586: l_PRICE_LIST_LINE_rec.price_break_type_code := p_attr_value;
587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN
588: l_PRICE_LIST_LINE_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN

Line 587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN

583: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PERCENT_PRICE THEN
584: l_PRICE_LIST_LINE_rec.percent_price := TO_NUMBER(p_attr_value);
585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN
586: l_PRICE_LIST_LINE_rec.price_break_type_code := p_attr_value;
587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN
588: l_PRICE_LIST_LINE_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN
590: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_attr_value;
591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN

Line 589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN

585: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BREAK_TYPE THEN
586: l_PRICE_LIST_LINE_rec.price_break_type_code := p_attr_value;
587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN
588: l_PRICE_LIST_LINE_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN
590: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_attr_value;
591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN
592: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_attr_value;
593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN

Line 591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN

587: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRICE_BY_FORMULA THEN
588: l_PRICE_LIST_LINE_rec.price_by_formula_id := TO_NUMBER(p_attr_value);
589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN
590: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_attr_value;
591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN
592: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_attr_value;
593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN
594: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_attr_value;
595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN

Line 593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN

589: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRIMARY_UOM THEN
590: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_attr_value;
591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN
592: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_attr_value;
593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN
594: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_attr_value;
595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN
596: l_PRICE_LIST_LINE_rec.recurring_value := TO_NUMBER(p_attr_value); -- block pricing
597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN

Line 595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN

591: ELSIF p_attr_id = QP_Price_List_Line_Util.G_PRINT_ON_INVOICE THEN
592: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_attr_value;
593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN
594: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_attr_value;
595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN
596: l_PRICE_LIST_LINE_rec.recurring_value := TO_NUMBER(p_attr_value); -- block pricing
597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN
598: l_PRICE_LIST_LINE_rec.related_item_id := TO_NUMBER(p_attr_value);
599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN

Line 597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN

593: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REBATE_TRANSACTION_TYPE THEN
594: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_attr_value;
595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN
596: l_PRICE_LIST_LINE_rec.recurring_value := TO_NUMBER(p_attr_value); -- block pricing
597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN
598: l_PRICE_LIST_LINE_rec.related_item_id := TO_NUMBER(p_attr_value);
599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN
600: l_PRICE_LIST_LINE_rec.relationship_type_id := TO_NUMBER(p_attr_value);
601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN

Line 599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN

595: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RECURRING_VALUE THEN
596: l_PRICE_LIST_LINE_rec.recurring_value := TO_NUMBER(p_attr_value); -- block pricing
597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN
598: l_PRICE_LIST_LINE_rec.related_item_id := TO_NUMBER(p_attr_value);
599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN
600: l_PRICE_LIST_LINE_rec.relationship_type_id := TO_NUMBER(p_attr_value);
601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN
602: l_PRICE_LIST_LINE_rec.reprice_flag := p_attr_value;
603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN

Line 601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN

597: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATED_ITEM THEN
598: l_PRICE_LIST_LINE_rec.related_item_id := TO_NUMBER(p_attr_value);
599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN
600: l_PRICE_LIST_LINE_rec.relationship_type_id := TO_NUMBER(p_attr_value);
601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN
602: l_PRICE_LIST_LINE_rec.reprice_flag := p_attr_value;
603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN
604: l_PRICE_LIST_LINE_rec.revision := p_attr_value;
605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN

Line 603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN

599: ELSIF p_attr_id = QP_Price_List_Line_Util.G_RELATIONSHIP_TYPE THEN
600: l_PRICE_LIST_LINE_rec.relationship_type_id := TO_NUMBER(p_attr_value);
601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN
602: l_PRICE_LIST_LINE_rec.reprice_flag := p_attr_value;
603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN
604: l_PRICE_LIST_LINE_rec.revision := p_attr_value;
605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN
606: l_PRICE_LIST_LINE_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN

Line 605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN

601: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REPRICE THEN
602: l_PRICE_LIST_LINE_rec.reprice_flag := p_attr_value;
603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN
604: l_PRICE_LIST_LINE_rec.revision := p_attr_value;
605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN
606: l_PRICE_LIST_LINE_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN
608: l_PRICE_LIST_LINE_rec.revision_reason_code := p_attr_value;
609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN

Line 607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN

603: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION THEN
604: l_PRICE_LIST_LINE_rec.revision := p_attr_value;
605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN
606: l_PRICE_LIST_LINE_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN
608: l_PRICE_LIST_LINE_rec.revision_reason_code := p_attr_value;
609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
610: l_PRICE_LIST_LINE_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN

Line 609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN

605: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_DATE THEN
606: l_PRICE_LIST_LINE_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN
608: l_PRICE_LIST_LINE_rec.revision_reason_code := p_attr_value;
609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
610: l_PRICE_LIST_LINE_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN
612: l_PRICE_LIST_LINE_rec.substitution_attribute := p_attr_value;
613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN

Line 611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN

607: ELSIF p_attr_id = QP_Price_List_Line_Util.G_REVISION_REASON THEN
608: l_PRICE_LIST_LINE_rec.revision_reason_code := p_attr_value;
609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
610: l_PRICE_LIST_LINE_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN
612: l_PRICE_LIST_LINE_rec.substitution_attribute := p_attr_value;
613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN
614: l_PRICE_LIST_LINE_rec.substitution_context := p_attr_value;
615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN

Line 613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN

609: ELSIF p_attr_id = QP_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
610: l_PRICE_LIST_LINE_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN
612: l_PRICE_LIST_LINE_rec.substitution_attribute := p_attr_value;
613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN
614: l_PRICE_LIST_LINE_rec.substitution_context := p_attr_value;
615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN
616: l_PRICE_LIST_LINE_rec.substitution_value := p_attr_value;
617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN

Line 615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN

611: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_ATTRIBUTE THEN
612: l_PRICE_LIST_LINE_rec.substitution_attribute := p_attr_value;
613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN
614: l_PRICE_LIST_LINE_rec.substitution_context := p_attr_value;
615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN
616: l_PRICE_LIST_LINE_rec.substitution_value := p_attr_value;
617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN
618: l_PRICE_LIST_LINE_rec.customer_item_id := p_attr_value;
619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN

Line 617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN

613: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_CONTEXT THEN
614: l_PRICE_LIST_LINE_rec.substitution_context := p_attr_value;
615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN
616: l_PRICE_LIST_LINE_rec.substitution_value := p_attr_value;
617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN
618: l_PRICE_LIST_LINE_rec.customer_item_id := p_attr_value;
619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN
620: l_PRICE_LIST_LINE_rec.break_uom_code := p_attr_value;
621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN

Line 619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN

615: ELSIF p_attr_id = QP_Price_List_Line_Util.G_SUBSTITUTION_VALUE THEN
616: l_PRICE_LIST_LINE_rec.substitution_value := p_attr_value;
617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN
618: l_PRICE_LIST_LINE_rec.customer_item_id := p_attr_value;
619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN
620: l_PRICE_LIST_LINE_rec.break_uom_code := p_attr_value;
621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN
622: l_PRICE_LIST_LINE_rec.break_uom_context := p_attr_value;
623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN

Line 621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN

617: ELSIF p_attr_id = QP_Price_List_Line_Util.G_CUSTOMER_ITEM_ID THEN
618: l_PRICE_LIST_LINE_rec.customer_item_id := p_attr_value;
619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN
620: l_PRICE_LIST_LINE_rec.break_uom_code := p_attr_value;
621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN
622: l_PRICE_LIST_LINE_rec.break_uom_context := p_attr_value;
623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN
624: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_attr_value;
625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN

Line 623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN

619: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CODE THEN
620: l_PRICE_LIST_LINE_rec.break_uom_code := p_attr_value;
621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN
622: l_PRICE_LIST_LINE_rec.break_uom_context := p_attr_value;
623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN
624: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_attr_value;
625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN
626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1

Line 625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN

621: ELSIF p_attr_id = QP_Price_List_line_Util.G_BREAK_UOM_CONTEXT THEN
622: l_PRICE_LIST_LINE_rec.break_uom_context := p_attr_value;
623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN
624: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_attr_value;
625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN
626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11

Line 627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1

623: ELSIF p_attr_id = QP_Price_List_Line_Util.G_BREAK_UOM_ATTRIBUTE THEN
624: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_attr_value;
625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN
626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13

Line 628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10

624: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_attr_value;
625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN
626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14

Line 629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11

625: ELSIF p_attr_id = QP_Price_List_Line_Util.G_continuous_price_break_flag THEN
626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15

Line 630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12

626: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_attr_value; --Continuous Price Breaks
627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2

Line 631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13

627: ELSIF p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE1
628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3

Line 632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14

628: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE10
629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4

Line 633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15

629: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE11
630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5

Line 634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2

630: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE12
631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6

Line 635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3

631: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE13
632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7

Line 636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4

632: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE14
633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8

Line 637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5

633: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE15
634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9

Line 638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6

634: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE2
635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9
642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT

Line 639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7

635: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE3
636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9
642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT
643: THEN

Line 640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8

636: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE4
637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9
642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT
643: THEN
644:

Line 641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9

637: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE5
638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9
642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT
643: THEN
644:
645: l_PRICE_LIST_LINE_rec.attribute1 := p_attribute1;

Line 642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT

638: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE6
639: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE7
640: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE8
641: OR p_attr_id = QP_Price_List_Line_Util.G_ATTRIBUTE9
642: OR p_attr_id = QP_Price_List_Line_Util.G_CONTEXT
643: THEN
644:
645: l_PRICE_LIST_LINE_rec.attribute1 := p_attribute1;
646: l_PRICE_LIST_LINE_rec.attribute10 := p_attribute10;

Line 808: l_PRICE_LIST_LINE_val_rec := QP_Price_List_Line_Util.Get_Values

804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
805:
806: -- Load display out parameters if any
807:
808: l_PRICE_LIST_LINE_val_rec := QP_Price_List_Line_Util.Get_Values
809: ( p_PRICE_LIST_LINE_rec => l_x_PRICE_LIST_LINE_rec
810: , p_old_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
811: );
812:

Line 1981: g_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Query_Row

1977: -- Query row from DB
1978:
1979: oe_debug_pub.add('gpll - query row from db ca 1');
1980:
1981: g_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Query_Row
1982: ( p_list_line_id => p_list_line_id
1983: );
1984:
1985: g_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;