DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 150: select oe_price_adjustments_s.nextval into l_price_adjustment_id

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

Line 449: select oe_price_adjustments_s.nextval

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