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 ) ;
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