DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 149: select oe_price_adjustments_s.nextval into l_price_adjustment_id

145: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
146: END IF;
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: select oe_price_adjustments_s.nextval into l_price_adjustment_id
150: from dual;
151:
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;

Line 448: select oe_price_adjustments_s.nextval

444: -- FTE being called.
445: IF NVL(OE_FREIGHT_RATING_UTIL.get_list_line_type_code(p_header_id),'N')
446: <> 'OM_CALLED_FREIGHT_RATES' THEN
447:
448: select oe_price_adjustments_s.nextval
449: into l_price_adjustment_id
450: from dual;
451: INSERT INTO oe_price_adjustments
452: (PRICE_ADJUSTMENT_ID