APPS.OE_LINE_ACK_UTIL dependencies on OE_HEADER_ACKS

Line 64: UPDATE oe_header_acks

60: oe_debug_pub.add ('Entering Update_Header_Ack_Code with params: header id ' ||
61: p_header_id || ', first_ack_code ' || p_first_ack_code
62: || ', last_ack_code ' || p_last_ack_code || '.');
63: IF p_first_ack_code IS NOT NULL THEN
64: UPDATE oe_header_acks
65: SET first_ack_code = p_first_ack_code
66: WHERE header_id = p_header_id;
67: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
68: ELSIF p_last_ack_code IS NOT NULL THEN

Line 69: UPDATE oe_header_acks

65: SET first_ack_code = p_first_ack_code
66: WHERE header_id = p_header_id;
67: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
68: ELSIF p_last_ack_code IS NOT NULL THEN
69: UPDATE oe_header_acks
70: SET last_ack_code = p_last_ack_code
71: WHERE header_id = p_header_id;
72: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
73: ELSE