APPS.XDPSTATUS dependencies on XDP_ORDER_HEADERS

Line 2310: from XDP_ORDER_HEADERS

2306:
2307: is
2308: cursor c_GetOrderStat is
2309: select Status_code
2310: from XDP_ORDER_HEADERS
2311: where ORDER_ID = OrderID;
2312: -- for update;
2313:
2314: cursor c_GetLines is

Line 2399: UPDATE xdp_order_headers

2395:
2396: BEGIN
2397: IF p_status IN ('SUCCESS_WITH_OVERRIDE','ABORTED','SUCCESS') THEN
2398:
2399: UPDATE xdp_order_headers
2400: SET status_code = p_status ,
2401: completion_date = sysdate ,
2402: last_update_date = sysdate,
2403: last_updated_by = fnd_global.user_id,

Line 2407: UPDATE xdp_order_headers

2403: last_updated_by = fnd_global.user_id,
2404: last_update_login = fnd_global.login_id
2405: WHERE order_id = p_order_id ;
2406: ELSE
2407: UPDATE xdp_order_headers
2408: SET status_code = p_status ,
2409: last_update_date = sysdate,
2410: last_updated_by = fnd_global.user_id,
2411: last_update_login = fnd_global.login_id

Line 2542: FROM xdp_order_headers oh

2538: l_status BOOLEAN := FALSE ;
2539:
2540: CURSOR c_order IS
2541: SELECT 'Y'
2542: FROM xdp_order_headers oh
2543: WHERE order_id = p_order_id
2544: AND (EXISTS (SELECT 'Y'
2545: FROM xdp_order_line_items oli
2546: WHERE oli.order_id = oh.ordeR_id

Line 2886: FROM xdp_order_headers

2882: RETURN VARCHAR2 IS
2883:
2884: CURSOR cur_order IS
2885: SELECT status_code
2886: FROM xdp_order_headers
2887: WHERE order_id = p_order_id;
2888:
2889: CURSOR cur_lines IS
2890: SELECT status_code, line_item_id