DBA Data[Home] [Help]

APPS.OE_UPDATE_ACK_UTIL dependencies on OE_ORDER_LINES_ALL

Line 166: FROM oe_order_lines_all

162: -- Lock the lines table before UPDATE for bug4505695
163: -- Changing oe_order_lines to oe_order_line_all for bug#13831068
164: SELECT header_id
165: INTO l_header_id
166: FROM oe_order_lines_all
167: WHERE line_id = p_line_id
168: FOR UPDATE nowait;
169:
170: UPDATE oe_order_lines_all

Line 170: UPDATE oe_order_lines_all

166: FROM oe_order_lines_all
167: WHERE line_id = p_line_id
168: FOR UPDATE nowait;
169:
170: UPDATE oe_order_lines_all
171: SET first_ack_code = l_ack_code
172: , first_ack_date = sysdate
173: , lock_control = lock_control + 1
174: WHERE line_id = p_line_id;

Line 225: FROM oe_order_lines_all

221: -- Lock the lines table before UPDATE for bug 4505695
222: -- Changing oe_order_lines to oe_order_line_all for bug#13831068
223: SELECT header_id
224: INTO l_header_id
225: FROM oe_order_lines_all
226: WHERE line_id = p_line_id
227: FOR UPDATE nowait;
228:
229: UPDATE oe_order_lines_all

Line 229: UPDATE oe_order_lines_all

225: FROM oe_order_lines_all
226: WHERE line_id = p_line_id
227: FOR UPDATE nowait;
228:
229: UPDATE oe_order_lines_all
230: SET last_ack_code = l_ack_code
231: , last_ack_date = sysdate
232: , lock_control = lock_control + 1
233: , first_ack_code = nvl(first_ack_code, l_ack_code)