APPS.XDP_OE_ORDER dependencies on XDP_OE_ORDER_HEADERS

Line 52: INSERT INTO XDP_OE_ORDER_HEADERS (

48:
49: END IF ;
50:
51: -- Insert into the XDP OE Order Header Table
52: INSERT INTO XDP_OE_ORDER_HEADERS (
53: ORDER_NUMBER,
54: ORDER_VERSION,
55: PROVISIONING_DATE,
56: COMPLETION_DATE,

Line 156: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS

152: BEGIN
153: SELECT 'Y' INTO lv_exists_flag
154: FROM DUAL
155: WHERE EXISTS
156: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
157: WHERE ORDER_NUMBER =
158: UPPER(P_Order_Number));
159: -- AND ORDER_VERSION IS NULL);
160: EXCEPTION

Line 169: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS

165: BEGIN
166: SELECT 'Y' INTO lv_exists_flag
167: FROM DUAL
168: WHERE EXISTS
169: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
170: WHERE ORDER_NUMBER =
171: UPPER( P_Order_Number) AND
172: ORDER_VERSION = UPPER( p_Version));
173: EXCEPTION

Line 449: from xdp_oe_order_headers

445: lv_header.order_ref_name,
446: lv_header.order_ref_value,
447: lv_header.sp_order_number,
448: lv_header.sp_userid
449: from xdp_oe_order_headers
450: where order_number = p_oe_order_number
451: and order_version IS NULL;
452:
453: lv_index := 0;

Line 555: from xdp_oe_order_headers

551: lv_header.order_ref_name,
552: lv_header.order_ref_value,
553: lv_header.sp_order_number,
554: lv_header.sp_userid
555: from xdp_oe_order_headers
556: where order_number = p_oe_order_number
557: and order_version = p_oe_order_version;
558:
559: lv_index := 0;

Line 628: ** update table xdp_oe_order_headers with the value obtained from

624: RETURN_CODE => return_code,
625: ERROR_DESCRIPTION => error_description);
626:
627: /* BEN: 5/6/99 made this change:
628: ** update table xdp_oe_order_headers with the value obtained from
629: ** process_order() for the SDP_ORDER_ID column.
630: */
631:
632: l_sdp_order_id := sdp_order_id;

Line 640: update XDP_OE_ORDER_HEADERS

636: ** Code section will be removed in next change of API.
637: ** 02/27/2001. skilaru
638: IF p_oe_order_version IS NULL THEN
639:
640: update XDP_OE_ORDER_HEADERS
641: set SDP_ORDER_ID = l_sdp_order_id, STATUS='SUBMITTED'
642: where ORDER_NUMBER = p_oe_order_number
643: and ORDER_VERSION is NULL;
644:

Line 647: update XDP_OE_ORDER_HEADERS

643: and ORDER_VERSION is NULL;
644:
645: ELSE
646: **************/
647: update XDP_OE_ORDER_HEADERS
648: set SDP_ORDER_ID = l_sdp_order_id, STATUS='SUBMITTED'
649: where ORDER_NUMBER = p_oe_order_number
650: and ORDER_VERSION = p_oe_order_version;
651: -- END IF;