APPS.OE_UPDATE_ACK_UTIL dependencies on OE_ORDER_HEADERS

Line 55: FROM oe_order_headers

51: End;
52: -- Lock the Header Table before Updating for bug 4505695
53: SELECT header_id
54: INTO l_header_id
55: FROM oe_order_headers
56: WHERE header_id = p_header_id
57: FOR UPDATE nowait;
58:
59: UPDATE oe_order_headers

Line 59: UPDATE oe_order_headers

55: FROM oe_order_headers
56: WHERE header_id = p_header_id
57: FOR UPDATE nowait;
58:
59: UPDATE oe_order_headers
60: SET first_ack_code = l_ack_code
61: , first_ack_date = sysdate
62: , lock_control = lock_control + 1
63: , xml_message_id = l_em_message_id

Line 113: FROM oe_order_headers

109: --Lock the header table before Updating bug4505695
110:
111: SELECT header_id
112: INTO l_header_id
113: FROM oe_order_headers
114: WHERE header_id = p_header_id
115: FOR UPDATE nowait;
116: UPDATE oe_order_headers
117: SET last_ack_code = l_ack_code

Line 116: UPDATE oe_order_headers

112: INTO l_header_id
113: FROM oe_order_headers
114: WHERE header_id = p_header_id
115: FOR UPDATE nowait;
116: UPDATE oe_order_headers
117: SET last_ack_code = l_ack_code
118: , last_ack_date = sysdate
119: , lock_control = lock_control + 1
120: , xml_message_id = l_em_message_id