DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_LINE_TYPES_V

Line 3974: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id;

3970: begin
3971:
3972: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
3973: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
3974: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id;
3975: exception when no_data_found then
3976: l_enforce_price_flag := 'N';
3977: end ;
3978:

Line 4026: from oe_line_types_v where line_type_id=p_line_type_id;

4022: x_line_enforce_list_price := 'Y';
4023: ELSE
4024: begin
4025: select nvl(enforce_line_prices_flag,'N') into x_line_enforce_list_price
4026: from oe_line_types_v where line_type_id=p_line_type_id;
4027: exception when no_data_found then
4028: x_line_enforce_list_price := 'N';
4029: end ;
4030: END IF;