APPS.OE_FREIGHT_CHOICES_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 797: select oe_price_adjustments_s.nextval into l_price_adjustment_id

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

Line 855: select oe_price_adjustments_s.nextval

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

Line 859: INSERT INTO oe_price_adjustments

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

Line 905: oe_price_adjustments

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

Line 1090: DELETE FROM OE_PRICE_ADJUSTMENTS

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

Line 1366: ,oe_price_adjustments opa

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

Line 1418: DELETE FROM OE_PRICE_ADJUSTMENTS

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

Line 1667: DELETE FROM oe_price_adjustments

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