eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_UPDATE_ACK_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 53: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068

49: When Others then
50: oe_debug_pub.add('When Others excep=> ' || sqlerrm);
51: End;
52: -- Lock the Header Table before Updating for bug 4505695
53: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068
54: SELECT header_id
55: INTO l_header_id
56: FROM oe_order_headers_all
57: WHERE header_id = p_header_id

Line 56: FROM oe_order_headers_all

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

Line 60: UPDATE oe_order_headers_all

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

Line 111: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068

107: l_ack_code := 'AT';
108: end;
109:
110: --Lock the header table before Updating bug4505695
111: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068
112: SELECT header_id
113: INTO l_header_id
114: FROM oe_order_headers_all
115: WHERE header_id = p_header_id

Line 114: FROM oe_order_headers_all

110: --Lock the header table before Updating bug4505695
111: -- Changing oe_order_headers to oe_order_headers_all for bug#13831068
112: SELECT header_id
113: INTO l_header_id
114: FROM oe_order_headers_all
115: WHERE header_id = p_header_id
116: FOR UPDATE nowait;
117: UPDATE oe_order_headers_all
118: SET last_ack_code = l_ack_code

Line 117: UPDATE oe_order_headers_all

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