APPS.XDP_ORDER_SYNC dependencies on XDP_ORDER_LINE_ITEMS

Line 62: UPDATE xdp_order_line_items

58:
59: BEGIN
60: IF p_status IN ('IN PROGRESS','ERROR') THEN
61:
62: UPDATE xdp_order_line_items
63: SET status_code = p_status ,
64: last_update_date = sysdate,
65: last_updated_by = fnd_global.user_id,
66: last_update_login = fnd_global.login_id

Line 69: UPDATE xdp_order_line_items

65: last_updated_by = fnd_global.user_id,
66: last_update_login = fnd_global.login_id
67: WHERE line_item_id = p_line_item_id ;
68: ELSE
69: UPDATE xdp_order_line_items
70: SET status_code = p_status ,
71: completion_date = sysdate ,
72: last_update_date = sysdate,
73: last_updated_by = fnd_global.user_id,

Line 167: (SELECT line_item_id FROM xdp_order_line_items

163: Update_XDP_Order_Status('IN_PROGRESS',p_Order_ID);
164:
165: -- Execute lineitems in sequence
166: FOR c_lineitem IN
167: (SELECT line_item_id FROM xdp_order_line_items
168: WHERE order_id=p_order_id ORDER BY line_sequence)
169: LOOP
170: Execute_LineItem_Sync(
171: p_order_id => p_order_id,

Line 185: xdp_order_line_items

181: BEGIN
182: SELECT 'N' INTO l_done
183: FROM dual
184: WHERE EXISTS( SELECT 'x' FROM
185: xdp_order_line_items
186: WHERE order_id = p_order_id AND
187: status_code = 'ERROR');
188: EXCEPTION
189: WHEN no_data_found THEN