DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on OE_ORDER_TYPES_V

Line 781: from oe_Order_types_v where Order_type_id=in_order_type_id;

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

Line 1785: FROM oe_order_types_v

1781: --
1782: BEGIN
1783: SELECT name
1784: INTO out_name
1785: FROM oe_order_types_v
1786: WHERE order_type_id = in_order_type_id;
1787:
1788: EXCEPTION
1789: