DBA Data[Home] [Help]

APPS.OE_UPDATE_ACK_UTIL dependencies on OE_ORDER_LINES

Line 165: FROM oe_order_lines

161: -- Lock the lines table before UPDATE for bug4505695
162:
163: SELECT header_id
164: INTO l_header_id
165: FROM oe_order_lines
166: WHERE line_id = p_line_id
167: FOR UPDATE nowait;
168:
169: UPDATE oe_order_lines

Line 169: UPDATE oe_order_lines

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

Line 224: FROM oe_order_lines

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

Line 228: UPDATE oe_order_lines

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