222:
223: oe_debug_pub.add('Ren: before get_values 1');
224: oe_debug_pub.add('ren : msg data 0.5 is : ' || x_msg_data);
225:
226: l_PRICING_ATTR_val_rec := Qp_pll_pricing_attr_Util.Get_Values
227: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
228: );
229: x_accumulate := l_PRICING_ATTR_val_rec.accumulate;
230: x_excluder := l_PRICING_ATTR_val_rec.excluder;
413: );
414:
415: l_old_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
416:
417: IF p_attr_id = Qp_pll_pricing_attr_Util.G_ACCUMULATE THEN
418: l_PRICING_ATTR_rec.accumulate_flag := p_attr_value;
419: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE_GROUPING_NO THEN
420: l_PRICING_ATTR_rec.attribute_grouping_no := TO_NUMBER(p_attr_value);
421: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_EXCLUDER THEN
415: l_old_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
416:
417: IF p_attr_id = Qp_pll_pricing_attr_Util.G_ACCUMULATE THEN
418: l_PRICING_ATTR_rec.accumulate_flag := p_attr_value;
419: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE_GROUPING_NO THEN
420: l_PRICING_ATTR_rec.attribute_grouping_no := TO_NUMBER(p_attr_value);
421: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_EXCLUDER THEN
422: l_PRICING_ATTR_rec.excluder_flag := p_attr_value;
423: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_LIST_LINE THEN
417: IF p_attr_id = Qp_pll_pricing_attr_Util.G_ACCUMULATE THEN
418: l_PRICING_ATTR_rec.accumulate_flag := p_attr_value;
419: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE_GROUPING_NO THEN
420: l_PRICING_ATTR_rec.attribute_grouping_no := TO_NUMBER(p_attr_value);
421: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_EXCLUDER THEN
422: l_PRICING_ATTR_rec.excluder_flag := p_attr_value;
423: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_LIST_LINE THEN
424: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
425: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
419: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE_GROUPING_NO THEN
420: l_PRICING_ATTR_rec.attribute_grouping_no := TO_NUMBER(p_attr_value);
421: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_EXCLUDER THEN
422: l_PRICING_ATTR_rec.excluder_flag := p_attr_value;
423: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_LIST_LINE THEN
424: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
425: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
426: l_PRICING_ATTR_rec.pricing_attribute := p_attr_value;
427: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_CONTEXT THEN
421: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_EXCLUDER THEN
422: l_PRICING_ATTR_rec.excluder_flag := p_attr_value;
423: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_LIST_LINE THEN
424: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
425: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
426: l_PRICING_ATTR_rec.pricing_attribute := p_attr_value;
427: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_CONTEXT THEN
428: l_PRICING_ATTR_rec.pricing_attribute_context := p_attr_value;
429: /*
423: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_LIST_LINE THEN
424: l_PRICING_ATTR_rec.list_line_id := TO_NUMBER(p_attr_value);
425: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
426: l_PRICING_ATTR_rec.pricing_attribute := p_attr_value;
427: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_CONTEXT THEN
428: l_PRICING_ATTR_rec.pricing_attribute_context := p_attr_value;
429: /*
430: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
431: l_PRICING_ATTR_rec.pricing_attribute_id := TO_NUMBER(p_attr_value);
426: l_PRICING_ATTR_rec.pricing_attribute := p_attr_value;
427: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_CONTEXT THEN
428: l_PRICING_ATTR_rec.pricing_attribute_context := p_attr_value;
429: /*
430: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
431: l_PRICING_ATTR_rec.pricing_attribute_id := TO_NUMBER(p_attr_value);
432: */
433: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_FROM THEN
434: l_PRICING_ATTR_rec.pricing_attr_value_from := p_attr_value;
429: /*
430: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE THEN
431: l_PRICING_ATTR_rec.pricing_attribute_id := TO_NUMBER(p_attr_value);
432: */
433: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_FROM THEN
434: l_PRICING_ATTR_rec.pricing_attr_value_from := p_attr_value;
435: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_TO THEN
436: l_PRICING_ATTR_rec.pricing_attr_value_to := p_attr_value;
437: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE THEN
431: l_PRICING_ATTR_rec.pricing_attribute_id := TO_NUMBER(p_attr_value);
432: */
433: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_FROM THEN
434: l_PRICING_ATTR_rec.pricing_attr_value_from := p_attr_value;
435: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_TO THEN
436: l_PRICING_ATTR_rec.pricing_attr_value_to := p_attr_value;
437: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE THEN
438: l_PRICING_ATTR_rec.product_attribute := p_attr_value;
439: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_CONTEXT THEN
433: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_FROM THEN
434: l_PRICING_ATTR_rec.pricing_attr_value_from := p_attr_value;
435: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_TO THEN
436: l_PRICING_ATTR_rec.pricing_attr_value_to := p_attr_value;
437: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE THEN
438: l_PRICING_ATTR_rec.product_attribute := p_attr_value;
439: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_CONTEXT THEN
440: l_PRICING_ATTR_rec.product_attribute_context := p_attr_value;
441: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTR_VALUE THEN
435: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTR_VALUE_TO THEN
436: l_PRICING_ATTR_rec.pricing_attr_value_to := p_attr_value;
437: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE THEN
438: l_PRICING_ATTR_rec.product_attribute := p_attr_value;
439: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_CONTEXT THEN
440: l_PRICING_ATTR_rec.product_attribute_context := p_attr_value;
441: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTR_VALUE THEN
442: l_PRICING_ATTR_rec.product_attr_value := p_attr_value;
443: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_UOM THEN
437: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE THEN
438: l_PRICING_ATTR_rec.product_attribute := p_attr_value;
439: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_CONTEXT THEN
440: l_PRICING_ATTR_rec.product_attribute_context := p_attr_value;
441: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTR_VALUE THEN
442: l_PRICING_ATTR_rec.product_attr_value := p_attr_value;
443: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_UOM THEN
444: l_PRICING_ATTR_rec.product_uom_code := p_attr_value;
445: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_FROM_RLTD_MODIFIER THEN
439: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_CONTEXT THEN
440: l_PRICING_ATTR_rec.product_attribute_context := p_attr_value;
441: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTR_VALUE THEN
442: l_PRICING_ATTR_rec.product_attr_value := p_attr_value;
443: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_UOM THEN
444: l_PRICING_ATTR_rec.product_uom_code := p_attr_value;
445: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_FROM_RLTD_MODIFIER THEN
446: l_PRICING_ATTR_rec.from_rltd_modifier_id := to_number(p_attr_value);
447: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_COMPARISON_OPERATOR_CODE THEN
441: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTR_VALUE THEN
442: l_PRICING_ATTR_rec.product_attr_value := p_attr_value;
443: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_UOM THEN
444: l_PRICING_ATTR_rec.product_uom_code := p_attr_value;
445: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_FROM_RLTD_MODIFIER THEN
446: l_PRICING_ATTR_rec.from_rltd_modifier_id := to_number(p_attr_value);
447: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_COMPARISON_OPERATOR_CODE THEN
448: l_PRICING_ATTR_rec.comparison_operator_code := p_attr_value;
449: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_DATATYPE THEN
443: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_UOM THEN
444: l_PRICING_ATTR_rec.product_uom_code := p_attr_value;
445: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_FROM_RLTD_MODIFIER THEN
446: l_PRICING_ATTR_rec.from_rltd_modifier_id := to_number(p_attr_value);
447: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_COMPARISON_OPERATOR_CODE THEN
448: l_PRICING_ATTR_rec.comparison_operator_code := p_attr_value;
449: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_DATATYPE THEN
450: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_attr_value;
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
445: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_FROM_RLTD_MODIFIER THEN
446: l_PRICING_ATTR_rec.from_rltd_modifier_id := to_number(p_attr_value);
447: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_COMPARISON_OPERATOR_CODE THEN
448: l_PRICING_ATTR_rec.comparison_operator_code := p_attr_value;
449: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_DATATYPE THEN
450: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_attr_value;
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
447: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_COMPARISON_OPERATOR_CODE THEN
448: l_PRICING_ATTR_rec.comparison_operator_code := p_attr_value;
449: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_DATATYPE THEN
450: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_attr_value;
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
449: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRICING_ATTRIBUTE_DATATYPE THEN
450: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_attr_value;
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
450: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_attr_value;
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
451: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_PRODUCT_ATTRIBUTE_DATATYPE THEN
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
452: l_PRICING_ATTR_rec.product_attribute_datatype := p_attr_value;
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
453: ELSIF p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE1
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
454: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE10
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
455: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE11
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
456: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE12
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
457: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE13
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
458: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE14
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
459: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE15
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
460: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE2
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
468: OR p_attr_id = Qp_pll_pricing_attr_Util.G_CONTEXT
461: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE3
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
468: OR p_attr_id = Qp_pll_pricing_attr_Util.G_CONTEXT
469: THEN
462: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE4
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
468: OR p_attr_id = Qp_pll_pricing_attr_Util.G_CONTEXT
469: THEN
470:
463: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE5
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
468: OR p_attr_id = Qp_pll_pricing_attr_Util.G_CONTEXT
469: THEN
470:
471: l_PRICING_ATTR_rec.attribute1 := p_attribute1;
464: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE6
465: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE7
466: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE8
467: OR p_attr_id = Qp_pll_pricing_attr_Util.G_ATTRIBUTE9
468: OR p_attr_id = Qp_pll_pricing_attr_Util.G_CONTEXT
469: THEN
470:
471: l_PRICING_ATTR_rec.attribute1 := p_attribute1;
472: l_PRICING_ATTR_rec.attribute10 := p_attribute10;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
585:
586: -- Load display out parameters if any
587:
588: l_PRICING_ATTR_val_rec := Qp_pll_pricing_attr_Util.Get_Values
589: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
590: , p_old_PRICING_ATTR_rec => l_PRICING_ATTR_rec
591: );
592:
1566: THEN
1567:
1568: -- Query row from DB
1569:
1570: g_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row
1571: ( p_pricing_attribute_id => p_pricing_attribute_id
1572: );
1573:
1574: g_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;