APPS.XDP_DRC_UTIL_PVT dependencies on XDP_ORDER_HEADERS

Line 62: select XDP_ORDER_HEADERS_S.NextVal into x_SDP_ORDER_ID

58: If x_return_code<>0 THEN
59: return;
60: End If;
61:
62: select XDP_ORDER_HEADERS_S.NextVal into x_SDP_ORDER_ID
63: from dual;
64:
65: insert into xdp_order_headers
66: (

Line 65: insert into xdp_order_headers

61:
62: select XDP_ORDER_HEADERS_S.NextVal into x_SDP_ORDER_ID
63: from dual;
64:
65: insert into xdp_order_headers
66: (
67: order_id,
68: external_order_number,
69: status_code,

Line 201: update xdp_order_headers

197: lv_done := 'Y';
198: end;
199:
200: If lv_done = 'Y' then
201: update xdp_order_headers
202: set status_code = 'COMPLETED',
203: state = 'COMPLETED',
204: last_update_date = sysdate,
205: last_updated_by = FND_GLOBAL.USER_ID,

Line 217: update xdp_order_headers

213: last_updated_by = FND_GLOBAL.USER_ID,
214: last_update_login = FND_GLOBAL.LOGIN_ID
215: where line_item_id = lv_line_id;
216: Else
217: update xdp_order_headers
218: set status_code = 'ERROR',
219: state = 'COMPLETED',
220: last_update_date = sysdate,
221: last_updated_by = FND_GLOBAL.USER_ID,