APPS.XDP_CANCEL_ORDER dependencies on XDP_ORDER_HEADERS

Line 69: -- Get the SFM Order Id from the XDP_ORDER_HEADERS table

65: return;
66: END IF;
67:
68: ----------------------------------------------------------------------
69: -- Get the SFM Order Id from the XDP_ORDER_HEADERS table
70: ----------------------------------------------------------------------
71: BEGIN
72: IF l_order_version IS NOT NULL THEN
73: SELECT order_id

Line 75: FROM xdp_order_headers

71: BEGIN
72: IF l_order_version IS NOT NULL THEN
73: SELECT order_id
74: INTO lv_sfm_order_id
75: FROM xdp_order_headers
76: WHERE external_order_number = to_char(l_order_number) and
77: external_order_version = to_char(l_order_version);
78: ELSE
79: SELECT order_id

Line 81: FROM xdp_order_headers

77: external_order_version = to_char(l_order_version);
78: ELSE
79: SELECT order_id
80: INTO lv_sfm_order_id
81: FROM xdp_order_headers
82: WHERE external_order_number = (l_order_number) and
83: external_order_version IS NULL;
84: END IF;
85: EXCEPTION

Line 104: FROM xdp_order_headers

100: order_type
101: INTO lv_state,
102: lv_msg_id,
103: lv_order_type
104: FROM xdp_order_headers
105: WHERE order_id = lv_sfm_order_id;
106:
107: ----------------------------------------------------------------------
108: -- If the state is as listed below then return a success