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_DELAYED_REQUESTS_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 545: FROM oe_price_adjustments

541: IF l_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN
542:
543: SELECT 'DUPLICATE_DISCOUNT'
544: INTO l_duplicate
545: FROM oe_price_adjustments
546: WHERE header_id = l_header_id
547: AND discount_id = l_discount_id
548: AND price_adjustment_id <> Nvl(l_entity_id, -1)
549: AND line_id IS NULL;

Line 574: FROM oe_price_adjustments

570: ELSIF l_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
571:
572: SELECT 'DUPLICATE_DISCOUNT'
573: INTO l_duplicate
574: FROM oe_price_adjustments
575: WHERE header_id = l_header_id
576: AND discount_id = l_discount_id
577: AND line_id = l_line_id
578: AND price_adjustment_id <> Nvl(l_entity_id, -1);

Line 646: FROM oe_price_adjustments p

642: FIXED_PRICE_VIOLATE EXCEPTION;
643:
644: CURSOR all_adjustments IS
645: SELECT count(p.price_adjustment_id)
646: FROM oe_price_adjustments p
647: WHERE p.header_id = l_header_id
648: AND (p.line_id = l_line_id
649: OR p.line_id IS NULL) ;
650:

Line 653: FROM oe_price_adjustments p

649: OR p.line_id IS NULL) ;
650:
651: CURSOR hdr_line_adjustments IS
652: SELECT p.line_id
653: FROM oe_price_adjustments p
654: WHERE p.header_id = l_header_id
655: AND p.line_id IS NOT NULL
656: ORDER by p.line_id;
657:

Line 685: FROM oe_price_adjustments adj,

681: CLOSE all_adjustments;
682:
683: SELECT count(d.name)
684: INTO l_count
685: FROM oe_price_adjustments adj,
686: oe_discount_lines dln,
687: oe_discounts d
688: WHERE adj.header_id = l_header_id
689: AND Nvl(adj.line_id, l_line_id) = l_line_id

Line 718: FROM oe_price_adjustments adj

714: IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
715:
716: SELECT count(adj.price_adjustment_id)
717: INTO l_count
718: FROM oe_price_adjustments adj
719: WHERE adj.header_id = l_header_id
720: AND Nvl(adj.line_id, l_line_id) = l_line_id
721: AND exists
722: (SELECT 'fixed_price'

Line 749: FROM oe_price_adjustments adj,

745:
746:
747: SELECT d.name
748: INTO l_fixed_price
749: FROM oe_price_adjustments adj,
750: oe_discount_lines dln,
751: oe_discounts d
752: WHERE adj.header_id = l_header_id
753: AND Nvl(adj.line_id, l_line_id) = l_line_id

Line 833: FROM oe_price_adjustments p,

829:
830:
831: CURSOR all_adjustments IS
832: SELECT p.price_adjustment_id, Nvl(p.line_id, -1) line_id
833: FROM oe_price_adjustments p,
834: oe_order_lines o
835: WHERE p.header_id = l_header_id
836: AND o.header_id = l_header_id
837: AND (p.line_id = o.line_id

Line 844: FROM oe_price_adjustments p

840:
841:
842: CURSOR hdr_adj_total IS
843: SELECT Nvl(SUM(percent), 0)
844: FROM oe_price_adjustments p
845: WHERE header_id = l_header_id
846: AND line_id IS NULL;
847:
848:

Line 851: FROM oe_price_adjustments

847:
848:
849: CURSOR line_adj_total IS
850: SELECT Nvl(SUM(percent), 0) + l_percent_total
851: FROM oe_price_adjustments
852: WHERE header_id = l_header_id
853: AND line_id = l_line_id;
854:
855:

Line 859: FROM OE_PRICE_ADJUSTMENTS P, OE_ORDER_LINES L

855:
856:
857: CURSOR max_line_adj_total IS
858: SELECT NVL( MAX(SUM(PERCENT)), 0) + l_percent_total
859: FROM OE_PRICE_ADJUSTMENTS P, OE_ORDER_LINES L
860: WHERE P.HEADER_ID = l_header_id
861: AND P.LINE_ID IS NOT NULL
862: AND P.LINE_ID = L.LINE_ID
863: GROUP BY P.line_id;

Line 1533: -- Check for existing TAX records in OE_PRICE_ADJUSTMENTS table for the

1529: l_line_rec.tax_value := l_tax_value;
1530:
1531: oe_debug_pub.add('After Successfully calculating Tax',2);
1532:
1533: -- Check for existing TAX records in OE_PRICE_ADJUSTMENTS table for the
1534: -- given line record.
1535: -- Replace Query_rows with lock rows --
1536: BEGIN
1537: OE_Line_Adj_UTIL.Lock_Rows

Line 5408: -- Check for existing TAX records in OE_PRICE_ADJUSTMENTS table for

5404: END IF; -- Line Category not RETURN
5405:
5406: END IF; -- tax value is different
5407:
5408: -- Check for existing TAX records in OE_PRICE_ADJUSTMENTS table for
5409: -- the given line record.
5410:
5411: BEGIN
5412:

Line 5479: UPDATE OE_PRICE_ADJUSTMENTS

5475: IF l_debug_level > 0 THEN
5476: oe_debug_pub.add('Updating the Adj record '||
5477: to_char(l_l_line_adj_tbl(J).price_adjustment_id),2);
5478: END IF;
5479: UPDATE OE_PRICE_ADJUSTMENTS
5480: SET ADJUSTED_AMOUNT =
5481: l_tax_rec_out_tbl(I).tax_amount,
5482: OPERAND = l_tax_rec_out_tbl(I).tax_rate,
5483: tax_Rate_id = l_tax_rec_out_tbl(I).tax_rate_id,

Line 5501: select OE_PRICE_ADJUSTMENTS_S.nextval

5497: END LOOP;
5498: END IF;
5499: IF l_match_flag = 'N' THEN
5500:
5501: select OE_PRICE_ADJUSTMENTS_S.nextval
5502: INTO l_price_adjustment_id
5503: FROM DUAL;
5504:
5505: l_Line_adj_rec.price_adjustment_id := l_price_adjustment_id;

Line 5537: -- Delete the old Tax Records from oe_price_adjustments if no match

5533: END LOOP; -- For Tax_Rec_Out_Tbl
5534:
5535: END IF; -- l_tax_rec_out_tbl.count > 0
5536:
5537: -- Delete the old Tax Records from oe_price_adjustments if no match
5538: -- is found.
5539:
5540: -- IF l_match_flag = 'N' THEN -- removed for bug# 1947306
5541: IF l_l_line_adj_tbl.COUNT > 0 THEN

Line 5553: DELETE FROM OE_PRICE_ADJUSTMENTS

5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add('Deleting adj Id '||
5551: to_char(l_l_line_adj_tbl(J).price_adjustment_id),2);
5552: END IF;
5553: DELETE FROM OE_PRICE_ADJUSTMENTS
5554: WHERE PRICE_ADJUSTMENT_ID =
5555: l_l_line_adj_tbl(J).price_adjustment_id;
5556: END IF;
5557: