DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on OE_ORDER_TYPES_V

Line 777: from oe_Order_types_v where Order_type_id=in_order_type_id;

773: out_enforce_price_flag out nocopy varchar2)
774: IS
775: Begin
776: select nvl(enforce_line_prices_flag,'N') into out_enforce_price_flag
777: from oe_Order_types_v where Order_type_id=in_order_type_id;
778: g_enforce_price_flag:= out_enforce_price_flag;
779: exception when no_data_found then
780: out_enforce_price_flag := 'N';
781: g_enforce_price_flag:= out_enforce_price_flag;

Line 1775: FROM oe_order_types_v

1771: --
1772: BEGIN
1773: SELECT name
1774: INTO out_name
1775: FROM oe_order_types_v
1776: WHERE order_type_id = in_order_type_id;
1777:
1778: EXCEPTION
1779: