DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 8453: from oe_order_headers_all

8449: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8450:
8451: BEGIN
8452: Select 1 into p_result
8453: from oe_order_headers_all
8454: where blanket_number = l_blanket_number
8455: and rownum = 1;
8456: EXCEPTION
8457: WHEN NO_DATA_FOUND THEN

Line 8466: from oe_order_headers_all

8462: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8463:
8464: BEGIN
8465: Select 1 into p_result
8466: from oe_order_headers_all
8467: where blanket_number = l_blanket_number
8468: and rownum = 1;
8469: EXCEPTION
8470: WHEN NO_DATA_FOUND THEN

Line 8553: from oe_order_headers_all

8549: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8550:
8551: BEGIN
8552: Select 1 into p_result
8553: from oe_order_headers_all
8554: where blanket_number = l_blanket_number
8555: and open_flag = 'Y'
8556: and rownum = 1;
8557: EXCEPTION

Line 8567: from oe_order_headers_all

8563: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8564:
8565: BEGIN
8566: Select 1 into p_result
8567: from oe_order_headers_all
8568: where blanket_number = l_blanket_number
8569: and open_flag = 'Y'
8570: and rownum = 1;
8571: EXCEPTION