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 546: FROM oe_price_adjustments

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

Line 575: FROM oe_price_adjustments

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

Line 647: FROM oe_price_adjustments p

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

Line 654: FROM oe_price_adjustments p

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

Line 686: FROM oe_price_adjustments adj,

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

Line 719: FROM oe_price_adjustments adj

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

Line 750: FROM oe_price_adjustments adj,

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

Line 834: FROM oe_price_adjustments p,

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

Line 845: FROM oe_price_adjustments p

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

Line 852: FROM oe_price_adjustments

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

Line 860: FROM OE_PRICE_ADJUSTMENTS P, OE_ORDER_LINES L

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

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

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

Line 4335: FROM oe_price_adjustments prg, oe_price_adj_assocs a,

4331:
4332:
4333: SELECT 'Y'
4334: INTO l_prg
4335: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4336: oe_price_adjustments p
4337: WHERE prg.line_id = l_reference_line_rec.line_id
4338: AND prg.list_line_type_code = 'PRG'
4339: AND prg.price_adjustment_id = a.price_adjustment_id

Line 4336: oe_price_adjustments p

4332:
4333: SELECT 'Y'
4334: INTO l_prg
4335: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4336: oe_price_adjustments p
4337: WHERE prg.line_id = l_reference_line_rec.line_id
4338: AND prg.list_line_type_code = 'PRG'
4339: AND prg.price_adjustment_id = a.price_adjustment_id
4340: AND p.price_adjustment_id = a.rltd_price_adj_id

Line 4712: FROM oe_price_adjustments prg, oe_price_adj_assocs a,

4708: BEGIN
4709:
4710: SELECT 'Y'
4711: INTO l_prg_exist
4712: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4713: oe_price_adjustments p
4714: WHERE prg.line_id = l_top_model_line_id
4715: AND prg.list_line_type_code = 'PRG'
4716: AND prg.price_adjustment_id = a.price_adjustment_id

Line 4713: oe_price_adjustments p

4709:
4710: SELECT 'Y'
4711: INTO l_prg_exist
4712: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4713: oe_price_adjustments p
4714: WHERE prg.line_id = l_top_model_line_id
4715: AND prg.list_line_type_code = 'PRG'
4716: AND prg.price_adjustment_id = a.price_adjustment_id
4717: AND p.price_adjustment_id = a.rltd_price_adj_id

Line 5642: UPDATE OE_PRICE_ADJUSTMENTS

5638: THEN
5639: IF l_debug_level > 0 THEN
5640: oe_debug_pub.add('Updating the Adj record '|| TO_CHAR(l_l_line_adj_tbl(J).price_adjustment_id),2);
5641: END IF;
5642: UPDATE OE_PRICE_ADJUSTMENTS
5643: SET ADJUSTED_AMOUNT = l_tax_rec_out_tbl(I).tax_amount,
5644: OPERAND = l_tax_rec_out_tbl(I).tax_rate,
5645: tax_Rate_id = l_tax_rec_out_tbl(I).tax_rate_id,
5646: LAST_UPDATE_DATE = sysdate,

Line 5676: UPDATE OE_PRICE_ADJUSTMENTS

5672: THEN
5673: IF l_debug_level > 0 THEN
5674: oe_debug_pub.add('Updating the Adj record '|| TO_CHAR(l_l_line_adj_tbl(J).price_adjustment_id),2);
5675: END IF;
5676: UPDATE OE_PRICE_ADJUSTMENTS
5677: SET ADJUSTED_AMOUNT = l_tax_rec_out_tbl(I).tax_amount,
5678: OPERAND = l_tax_rec_out_tbl(I).tax_rate,
5679: tax_Rate_id = l_tax_rec_out_tbl(I).tax_rate_id,
5680: LAST_UPDATE_DATE = sysdate,

Line 5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5691: /* end if condition for line level freight charge */
5692: END LOOP; --l_l_line_adj_tbl for
5693: END IF; --l_l_line_adj_tbl.COUNT > 0
5694: IF l_match_flag = 'N' THEN
5695: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5696: l_adj_rec.parent_adjustment_id := NULL;
5697: l_adj_rec.price_adjustment_id := l_price_adjustment_id;
5698: l_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;
5699: l_adj_rec.last_update_date := SYSDATE;

Line 5735: FROM OE_PRICE_ADJUSTMENTS

5731: IF l_debug_level > 0 THEN
5732: oe_debug_pub.add('Deleting adj Id '|| TO_CHAR(l_l_line_adj_tbl(J).price_adjustment_id),2);
5733: END IF;
5734: DELETE
5735: FROM OE_PRICE_ADJUSTMENTS
5736: WHERE PRICE_ADJUSTMENT_ID = l_l_line_adj_tbl(J).price_adjustment_id;
5737: END IF;
5738: END LOOP;
5739: END IF;

Line 5749: /* getting total tax value from oe_price_adjustments table for header_id */

5745: IF l_tax_rec_out_tbl(j).trx_id = p_entity_id_tbl(i).entity_id AND l_tax_rec_out_tbl(j).line_id IS NULL THEN
5746: l_total_tax := l_total_tax + l_tax_rec_out_tbl(j).tax_amount;
5747: END IF;
5748: END LOOP;
5749: /* getting total tax value from oe_price_adjustments table for header_id */
5750: SELECT SUM(ADJUSTED_AMOUNT)
5751: INTO l_old_total_tax
5752: FROM oe_price_adjustments
5753: WHERE header_id = p_entity_id_tbl(i).entity_id

Line 5752: FROM oe_price_adjustments

5748: END LOOP;
5749: /* getting total tax value from oe_price_adjustments table for header_id */
5750: SELECT SUM(ADJUSTED_AMOUNT)
5751: INTO l_old_total_tax
5752: FROM oe_price_adjustments
5753: WHERE header_id = p_entity_id_tbl(i).entity_id
5754: AND line_id IS NULL
5755: AND list_line_type_code = 'TAX' ;
5756: IF ( (l_old_total_tax IS NOT NULL AND l_total_tax IS NOT NULL AND l_old_total_tax = l_total_tax) OR (l_old_total_tax IS NULL AND l_total_tax IS NULL ) ) THEN

Line 5875: UPDATE OE_PRICE_ADJUSTMENTS

5871: THEN
5872: IF l_debug_level > 0 THEN
5873: oe_debug_pub.add('Updating the Adj record '|| TO_CHAR(l_l_header_adj_tbl(J).price_adjustment_id),2);
5874: END IF;
5875: UPDATE OE_PRICE_ADJUSTMENTS
5876: SET ADJUSTED_AMOUNT = l_tax_rec_out_tbl(I).tax_amount,
5877: OPERAND = l_tax_rec_out_tbl(I).tax_rate,
5878: tax_Rate_id = l_tax_rec_out_tbl(I).tax_rate_id,
5879: LAST_UPDATE_DATE = sysdate,

Line 5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

5889: END IF;
5890: /* end if condition for Header level freight charge */
5891: END LOOP; --l_l_header_adj_tbl for
5892: IF l_match_flag = 'N' AND l_tax_rec_out_tbl(i).line_id IS NULL THEN --TaxER
5893: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
5894: --TaxER start
5895: l_h_adj_rec.parent_adjustment_id := NULL;
5896: l_h_adj_rec.price_adjustment_id := l_price_adjustment_id;
5897: l_h_adj_rec.header_id := l_tax_rec_out_tbl(i).trx_id;

Line 5935: FROM OE_PRICE_ADJUSTMENTS

5931: IF l_debug_level > 0 THEN
5932: oe_debug_pub.add('Deleting adj Id '|| TO_CHAR(l_l_header_adj_tbl(J).price_adjustment_id),2);
5933: END IF;
5934: DELETE
5935: FROM OE_PRICE_ADJUSTMENTS
5936: WHERE PRICE_ADJUSTMENT_ID = l_l_header_adj_tbl(J).price_adjustment_id;
5937: END IF;
5938: END LOOP;
5939: END IF;