APPS.OE_HEADER_STATUS_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 30: FROM oe_order_headers_all

26: BEGIN
27:
28: SELECT cancelled_flag
29: INTO l_cancel_flag
30: FROM oe_order_headers_all
31: WHERE header_id = p_header_id;
32:
33: -- we are returning Line_Closed_Status,
34: -- so we return Y when open_flag is N

Line 119: FROM oe_order_headers_all

115: BEGIN
116:
117: SELECT nvl(booked_flag, 'N')
118: INTO x_result
119: FROM oe_order_headers_all
120: WHERE header_id = p_header_id;
121:
122: Exception
123: when others then

Line 155: FROM oe_order_headers_all

151: BEGIN
152:
153: SELECT nvl(booked_flag, 'N'), booked_date
154: INTO x_result, x_result_date
155: FROM oe_order_headers_all
156: WHERE header_id = p_header_id;
157:
158: Exception
159: when others then

Line 191: FROM oe_order_headers_all

187: BEGIN
188:
189: SELECT nvl(open_flag, 'Y')
190: INTO l_open_flag
191: FROM oe_order_headers_all
192: WHERE header_id = p_header_id;
193:
194: -- we are returning Closed Status,
195: -- so we return Y when open_flag is N