APPS.OE_FREIGHT_CHOICES_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 798: select oe_price_adjustments_s.nextval into l_price_adjustment_id

794: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
795: END IF;
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: select oe_price_adjustments_s.nextval into l_price_adjustment_id
799: from dual;
800:
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;

Line 856: select oe_price_adjustments_s.nextval

852: BEGIN
853:
854: IF p_header_id is not null THEN
855:
856: select oe_price_adjustments_s.nextval
857: into l_price_adjustment_id
858: from dual;
859:
860: INSERT INTO oe_price_adjustments

Line 860: INSERT INTO oe_price_adjustments

856: select oe_price_adjustments_s.nextval
857: into l_price_adjustment_id
858: from dual;
859:
860: INSERT INTO oe_price_adjustments
861: (PRICE_ADJUSTMENT_ID
862: ,HEADER_ID
863: ,LINE_ID
864: ,PRICING_PHASE_ID

Line 906: oe_price_adjustments

902: l_count Number := 0;
903: Begin
904:
905: Select Count(*) into l_count from
906: oe_price_adjustments
907: where header_id = p_key
908: and LIST_LINE_TYPE_CODE = 'OM_CALLED_CHOOSE_SHIP_METHOD';
909:
910: Return l_count;

Line 1091: DELETE FROM OE_PRICE_ADJUSTMENTS

1087:
1088: IF deleted_costs.EXISTS(l_fte_line_rate_tab(M).source_line_id) THEN
1089: NULL;
1090: ELSE
1091: DELETE FROM OE_PRICE_ADJUSTMENTS
1092: WHERE line_ID = l_fte_line_rate_tab(M).source_line_id
1093: AND CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
1094: AND list_line_type_code = 'COST'
1095: AND ESTIMATED_FLAG = 'Y';

Line 1367: ,oe_price_adjustments opa

1363: SELECT opa.price_adjustment_id,ool.line_id,
1364: opa.adjusted_amount, opa.list_line_type_code,
1365: opa.charge_type_code
1366: FROM oe_order_lines_all ool
1367: ,oe_price_adjustments opa
1368: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
1369: AND list_line_type_code = 'COST' -- For bug 7043225
1370: AND ool.line_id = opa.line_id
1371: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG

Line 1419: DELETE FROM OE_PRICE_ADJUSTMENTS

1415:
1416: IF deleted_costs.EXISTS(g_fte_line_rate_tab(M).source_line_id) THEN
1417: NULL;
1418: ELSE
1419: DELETE FROM OE_PRICE_ADJUSTMENTS
1420: WHERE line_ID = g_fte_line_rate_tab(M).source_line_id
1421: AND CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
1422: AND list_line_type_code = 'COST'
1423: AND ESTIMATED_FLAG = 'Y';

Line 1668: DELETE FROM oe_price_adjustments

1664: -- these deleted parent lines have been registered in
1665: -- previous loop looping through p_fte_rates_tab, so
1666: -- no need to register changed line again for these lines.
1667:
1668: DELETE FROM oe_price_adjustments
1669: WHERE price_adjustment_id = l_bulk_adj_rec.price_adjustment_id(i);
1670:
1671: l_adj_index := l_adj_index + 1;
1672: