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.OE_OE_FORM_PRICE_LLINE dependencies on OE_PRICE_LIST_LINE_UTIL

Line 261: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values

257: oe_debug_pub.add('get display values');
258:
259: -- Load display out parameters if any
260:
261: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values
262: ( p_Price_List_Line_rec => l_x_Price_LLine_rec
263: );
264: x_customer_item := l_Price_LLine_val_rec.customer_item;
265: x_inventory_item := l_Price_LLine_val_rec.inventory_item;

Line 488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN

484:
485: l_old_Price_LLine_rec := l_Price_LLine_rec;
486:
487: oe_debug_pub.add('price list line id before **** is : ');
488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN
489: oe_debug_pub.add('price list line id 1111 is : ');
490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');

Line 491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN

487: oe_debug_pub.add('price list line id before **** is : ');
488: IF p_attr_id = OE_Price_List_Line_Util.G_COMMENTS THEN
489: oe_debug_pub.add('price list line id 1111 is : ');
490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');
493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');

Line 494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN

490: l_Price_LLine_rec.comments := p_attr_value;
491: ELSIF p_attr_id = OE_Price_List_Line_Util.G_CUSTOMER_ITEM THEN
492: oe_debug_pub.add('price list line id 2222 is : ');
493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');
496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');

Line 497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN

493: l_Price_LLine_rec.customer_item_id := TO_NUMBER(p_attr_value);
494: ELSIF p_attr_id = OE_Price_List_Line_Util.G_END_DATE_ACTIVE THEN
495: oe_debug_pub.add('price list line id 3333 is : ');
496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');
499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');

Line 500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN

496: l_Price_LLine_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
497: ELSIF p_attr_id = OE_Price_List_Line_Util.G_INVENTORY_ITEM THEN
498: oe_debug_pub.add('price list line id 4444 is : ');
499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');
502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);
503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');

Line 503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN

499: l_Price_LLine_rec.inventory_item_id := TO_NUMBER(p_attr_value);
500: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_PRICE THEN
501: oe_debug_pub.add('price list line id 5555 is : ');
502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);
503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');
505: l_Price_LLine_rec.method_code := p_attr_value;
506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');

Line 506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN

502: l_Price_LLine_rec.list_price := TO_NUMBER(p_attr_value);
503: ELSIF p_attr_id = OE_Price_List_Line_Util.G_METHOD THEN
504: oe_debug_pub.add('price list line id 6666 is : ');
505: l_Price_LLine_rec.method_code := p_attr_value;
506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');
508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);
509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');

Line 509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN

505: l_Price_LLine_rec.method_code := p_attr_value;
506: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST THEN
507: oe_debug_pub.add('price list line id 7777 is : ');
508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);
509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');
511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);
512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');

Line 512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN

508: l_Price_LLine_rec.price_list_id := TO_NUMBER(p_attr_value);
509: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICE_LIST_LINE THEN
510: oe_debug_pub.add('price list line id 8888 is : ');
511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);
512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');
514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;
515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');

Line 515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN

511: l_Price_LLine_rec.price_list_line_id := TO_NUMBER(p_attr_value);
512: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE1 THEN
513: oe_debug_pub.add('price list line id 9999 is : ');
514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;
515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');
517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;
518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');

Line 518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN

514: l_Price_LLine_rec.pricing_attribute1 := p_attr_value;
515: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE10 THEN
516: oe_debug_pub.add('price list line id 1010 is : ');
517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;
518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');
520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;
521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');

Line 521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN

517: l_Price_LLine_rec.pricing_attribute10 := p_attr_value;
518: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE11 THEN
519: oe_debug_pub.add('price list line id 1212 is : ');
520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;
521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');
523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;
524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');

Line 524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN

520: l_Price_LLine_rec.pricing_attribute11 := p_attr_value;
521: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE12 THEN
522: oe_debug_pub.add('price list line id 1313 is : ');
523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;
524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');
526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;
527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');

Line 527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN

523: l_Price_LLine_rec.pricing_attribute12 := p_attr_value;
524: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE13 THEN
525: oe_debug_pub.add('price list line id 1414 is : ');
526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;
527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');
529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;
530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');

Line 530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN

526: l_Price_LLine_rec.pricing_attribute13 := p_attr_value;
527: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE14 THEN
528: oe_debug_pub.add('price list line id 1515 is : ');
529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;
530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');
532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;
533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');

Line 533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN

529: l_Price_LLine_rec.pricing_attribute14 := p_attr_value;
530: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE15 THEN
531: oe_debug_pub.add('price list line id 1616 is : ');
532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;
533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');
535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;
536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');

Line 536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN

532: l_Price_LLine_rec.pricing_attribute15 := p_attr_value;
533: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE2 THEN
534: oe_debug_pub.add('price list line id 1818 is : ');
535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;
536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');
538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;
539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');

Line 539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN

535: l_Price_LLine_rec.pricing_attribute2 := p_attr_value;
536: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE3 THEN
537: oe_debug_pub.add('price list line id 1919 is : ');
538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;
539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');
541: l_Price_LLine_rec.pricing_attribute4 := p_attr_value;
542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN
543: oe_debug_pub.add('price list line id 2121 is : ');

Line 542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN

538: l_Price_LLine_rec.pricing_attribute3 := p_attr_value;
539: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE4 THEN
540: oe_debug_pub.add('price list line id 2020 is : ');
541: l_Price_LLine_rec.pricing_attribute4 := p_attr_value;
542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN
543: oe_debug_pub.add('price list line id 2121 is : ');
544: l_Price_LLine_rec.pricing_attribute5 := p_attr_value;
545:
546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN

Line 546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN

542: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE5 THEN
543: oe_debug_pub.add('price list line id 2121 is : ');
544: l_Price_LLine_rec.pricing_attribute5 := p_attr_value;
545:
546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN
547: oe_debug_pub.add('price list line id 2323 is : ');
548: l_Price_LLine_rec.creation_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
549:
550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN

Line 550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN

546: ELSIF p_attr_id = OE_Price_List_line_Util.G_CREATION_DATE THEN
547: oe_debug_pub.add('price list line id 2323 is : ');
548: l_Price_LLine_rec.creation_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
549:
550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN
551: oe_debug_pub.add('price list line id 2424 is : ');
552: l_Price_LLine_rec.pricing_attribute6 := p_attr_value;
553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');

Line 553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN

549:
550: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE6 THEN
551: oe_debug_pub.add('price list line id 2424 is : ');
552: l_Price_LLine_rec.pricing_attribute6 := p_attr_value;
553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');
555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;
556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');

Line 556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN

552: l_Price_LLine_rec.pricing_attribute6 := p_attr_value;
553: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE7 THEN
554: oe_debug_pub.add('price list line id 2525 is : ');
555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;
556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');
558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;
559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');

Line 559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN

555: l_Price_LLine_rec.pricing_attribute7 := p_attr_value;
556: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE8 THEN
557: oe_debug_pub.add('price list line id 2626 is : ');
558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;
559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');
561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;
562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');

Line 562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN

558: l_Price_LLine_rec.pricing_attribute8 := p_attr_value;
559: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_ATTRIBUTE9 THEN
560: oe_debug_pub.add('price list line id 2727 is : ');
561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;
562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');
564: l_Price_LLine_rec.pricing_context := p_attr_value;
565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');

Line 565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN

561: l_Price_LLine_rec.pricing_attribute9 := p_attr_value;
562: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_CONTEXT THEN
563: oe_debug_pub.add('price list line id 2828 is : ');
564: l_Price_LLine_rec.pricing_context := p_attr_value;
565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');
567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);
568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');

Line 568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN

564: l_Price_LLine_rec.pricing_context := p_attr_value;
565: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRICING_RULE THEN
566: oe_debug_pub.add('price list line id 2929 is : ');
567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);
568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');
570: l_Price_LLine_rec.reprice_flag := p_attr_value;
571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');

Line 571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN

567: l_Price_LLine_rec.pricing_rule_id := TO_NUMBER(p_attr_value);
568: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REPRICE THEN
569: oe_debug_pub.add('price list line id 3030 is : ');
570: l_Price_LLine_rec.reprice_flag := p_attr_value;
571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');
573: l_Price_LLine_rec.revision := p_attr_value;
574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');

Line 574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN

570: l_Price_LLine_rec.reprice_flag := p_attr_value;
571: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION THEN
572: oe_debug_pub.add('price list line id 3131 is : ');
573: l_Price_LLine_rec.revision := p_attr_value;
574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');
576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');

Line 577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN

573: l_Price_LLine_rec.revision := p_attr_value;
574: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_DATE THEN
575: oe_debug_pub.add('price list line id 3232 is : ');
576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');
579: l_Price_LLine_rec.revision_reason_code := p_attr_value;
580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');

Line 580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN

576: l_Price_LLine_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
577: ELSIF p_attr_id = OE_Price_List_Line_Util.G_REVISION_REASON THEN
578: oe_debug_pub.add('price list line id 3434 is : ');
579: l_Price_LLine_rec.revision_reason_code := p_attr_value;
580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');
582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');

Line 583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN

579: l_Price_LLine_rec.revision_reason_code := p_attr_value;
580: ELSIF p_attr_id = OE_Price_List_Line_Util.G_START_DATE_ACTIVE THEN
581: oe_debug_pub.add('price list line id 3535 is : ');
582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');
585: l_Price_LLine_rec.unit_code := p_attr_value;
586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');

Line 586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN

582: l_Price_LLine_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
583: ELSIF p_attr_id = OE_Price_List_Line_Util.G_UNIT THEN
584: oe_debug_pub.add('price list line id 3636 is : ');
585: l_Price_LLine_rec.unit_code := p_attr_value;
586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');
588: l_Price_Lline_rec.primary := p_attr_value;
589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN
590: oe_debug_pub.add('price list line id 3737 is : ');

Line 589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN

585: l_Price_LLine_rec.unit_code := p_attr_value;
586: ELSIF p_attr_id = OE_Price_List_Line_Util.G_PRIMARY THEN
587: oe_debug_pub.add('price list line id 3737 is : ');
588: l_Price_Lline_rec.primary := p_attr_value;
589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN
590: oe_debug_pub.add('price list line id 3737 is : ');
591: l_Price_Lline_rec.list_line_type_code := p_attr_value;
592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1

Line 593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1

589: ELSIF p_attr_id = OE_Price_List_Line_Util.G_LIST_LINE_TYPE_CODE THEN
590: oe_debug_pub.add('price list line id 3737 is : ');
591: l_Price_Lline_rec.list_line_type_code := p_attr_value;
592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13

Line 594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10

590: oe_debug_pub.add('price list line id 3737 is : ');
591: l_Price_Lline_rec.list_line_type_code := p_attr_value;
592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14

Line 595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11

591: l_Price_Lline_rec.list_line_type_code := p_attr_value;
592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15

Line 596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12

592:
593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2

Line 597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13

593: ELSIF p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE1
594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3

Line 598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14

594: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE10
595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4

Line 599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15

595: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE11
596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5

Line 600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2

596: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE12
597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6

Line 601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3

597: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE13
598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7

Line 602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4

598: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE14
599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8

Line 603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5

599: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE15
600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9

Line 604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6

600: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE2
601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9
608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT

Line 605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7

601: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE3
602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9
608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT
609: THEN

Line 606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8

602: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE4
603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9
608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT
609: THEN
610:

Line 607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9

603: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE5
604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9
608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT
609: THEN
610:
611: l_Price_LLine_rec.attribute1 := p_attribute1;

Line 608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT

604: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE6
605: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE7
606: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE8
607: OR p_attr_id = OE_Price_List_Line_Util.G_ATTRIBUTE9
608: OR p_attr_id = OE_Price_List_Line_Util.G_CONTEXT
609: THEN
610:
611: l_Price_LLine_rec.attribute1 := p_attribute1;
612: l_Price_LLine_rec.attribute10 := p_attribute10;

Line 767: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values

763: x_list_line_type_code := FND_API.G_MISS_CHAR;
764:
765: -- Load display out parameters if any
766:
767: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values
768: ( p_Price_List_Line_rec => l_x_Price_LLine_rec
769: , p_old_Price_List_Line_rec => l_Price_LLine_rec
770: );
771:

Line 1901: g_Price_LLine_rec := OE_Price_List_Line_Util.Query_Row

1897: THEN
1898:
1899: -- Query row from DB
1900:
1901: g_Price_LLine_rec := OE_Price_List_Line_Util.Query_Row
1902: ( p_price_list_line_id => p_price_list_line_id
1903: , p_price_list_id => g_Price_LLine_rec.price_list_id
1904: );
1905: