DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 8650: from oe_order_headers_all

8646: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8647:
8648: BEGIN
8649: Select 1 into p_result
8650: from oe_order_headers_all
8651: where blanket_number = l_blanket_number
8652: and rownum = 1;
8653: EXCEPTION
8654: WHEN NO_DATA_FOUND THEN

Line 8663: from oe_order_headers_all

8659: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8660:
8661: BEGIN
8662: Select 1 into p_result
8663: from oe_order_headers_all
8664: where blanket_number = l_blanket_number
8665: and rownum = 1;
8666: EXCEPTION
8667: WHEN NO_DATA_FOUND THEN

Line 8750: from oe_order_headers_all

8746: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8747:
8748: BEGIN
8749: Select 1 into p_result
8750: from oe_order_headers_all
8751: where blanket_number = l_blanket_number
8752: and open_flag = 'Y'
8753: and rownum = 1;
8754: EXCEPTION

Line 8764: from oe_order_headers_all

8760: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8761:
8762: BEGIN
8763: Select 1 into p_result
8764: from oe_order_headers_all
8765: where blanket_number = l_blanket_number
8766: and open_flag = 'Y'
8767: and rownum = 1;
8768: EXCEPTION