DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on OE_LINE_TYPES_V

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

4053: begin
4054:
4055: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
4056: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
4057: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id;
4058: exception when no_data_found then
4059: l_enforce_price_flag := 'N';
4060: end ;
4061:

Line 4109: from oe_line_types_v where line_type_id=p_line_type_id;

4105: x_line_enforce_list_price := 'Y';
4106: ELSE
4107: begin
4108: select nvl(enforce_line_prices_flag,'N') into x_line_enforce_list_price
4109: from oe_line_types_v where line_type_id=p_line_type_id;
4110: exception when no_data_found then
4111: x_line_enforce_list_price := 'N';
4112: end ;
4113: END IF;