DBA Data[Home] [Help]

APPS.XDP_ORDER_SYNC dependencies on XDP_ORDER_HEADERS

Line 30: UPDATE xdp_order_headers

26:
27: BEGIN
28: IF p_status IN ('SUCCESS_WITH_OVERRIDE','ABORTED','SUCCESS') THEN
29:
30: UPDATE xdp_order_headers
31: SET status_code = p_status ,
32: completion_date = sysdate ,
33: last_update_date = sysdate,
34: last_updated_by = fnd_global.user_id,

Line 38: UPDATE xdp_order_headers

34: last_updated_by = fnd_global.user_id,
35: last_update_login = fnd_global.login_id
36: WHERE order_id = p_order_id ;
37: ELSE
38: UPDATE xdp_order_headers
39: SET status_code = p_status ,
40: last_update_date = sysdate,
41: last_updated_by = fnd_global.user_id,
42: last_update_login = fnd_global.login_id