APPS.XDP_INTERFACES dependencies on XDP_ORDER_HEADERS_S

Line 144: -- Private API which will update xdp_order_headers status_code

140: return_code OUT NOCOPY NUMBER,
141: error_description OUT NOCOPY VARCHAR2);
142:
143: --
144: -- Private API which will update xdp_order_headers status_code
145: --
146: --
147: PROCEDURE UPDATE_XDP_ORDER_STATUS
148: (p_order_id IN NUMBER ,

Line 280: SELECT XDP_ORDER_HEADERS_S.NextVal

276: l_workitem_name VARCHAR2(200);
277: l_order_id NUMBER;
278: BEGIN
279:
280: SELECT XDP_ORDER_HEADERS_S.NextVal
281: INTO l_order_id
282: FROM dual;
283:
284: l_ORDER_HEADER.order_number := 'DRC-'||TO_CHAR(l_order_id+1);

Line 1318: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;

1314: lv_state,
1315: lv_msg_id
1316: FROM xdp_order_headers
1317: WHERE order_id = p_sdp_order_id
1318: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1319:
1320: -- Order has already been canceled
1321: IF lv_state IN ('CANCELED','ABORTED') THEN
1322:

Line 1694: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;

1690: lv_state,
1691: lv_msg_id
1692: FROM xdp_order_headers
1693: WHERE order_id = p_sdp_order_id
1694: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE NOWAIT;
1695:
1696: -- Order has already been canceled
1697: IF lv_state IN ('CANCELED','ABORTED') THEN
1698: return_code := -191315;

Line 1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;

1858: select status_code
1859: into lv_state
1860: from xdp_order_headers
1861: where order_id = p_sdp_order_id
1862: FOR UPDATE of XDP_ORDER_HEADERS.STATUS_CODE ;
1863:
1864: if lv_state IN ('CANCELED','ABORTED') then
1865: return_code := -191315;
1866: FND_MESSAGE.SET_NAME('XDP', 'XDP_ORDER_STATE_CANCEL');

Line 3821: -- Private API which will update xdp_order_headers status_code

3817: END CANCEL_WORKITEM;
3818:
3819:
3820: --
3821: -- Private API which will update xdp_order_headers status_code
3822: --
3823: --
3824: PROCEDURE update_xdp_order_status
3825: (p_order_id IN NUMBER ,