eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XDP_OE_ORDER dependencies on XDP_OE_ORDER

Line 1: PACKAGE BODY XDP_OE_ORDER AS

1: PACKAGE BODY XDP_OE_ORDER AS
2: /* $Header: XDPOEORB.pls 120.1 2005/06/16 01:52:04 appldev $ */
3:
4:
5: /*----------------------------------------

Line 7: Purpose : Insert into XDP OE Order Header

3:
4:
5: /*----------------------------------------
6: Procedure : Insert_OE_Order
7: Purpose : Insert into XDP OE Order Header
8: ----------------------------------------*/
9: -- API to Insert into XDP OE Order Header Table
10: PROCEDURE Insert_OE_Order( P_OE_Order_Header IN XDP_TYPES.OE_ORDER_HEADER,
11: P_OE_Order_Parameter_List IN XDP_TYPES.OE_ORDER_PARAMETER_LIST,

Line 9: -- API to Insert into XDP OE Order Header Table

5: /*----------------------------------------
6: Procedure : Insert_OE_Order
7: Purpose : Insert into XDP OE Order Header
8: ----------------------------------------*/
9: -- API to Insert into XDP OE Order Header Table
10: PROCEDURE Insert_OE_Order( P_OE_Order_Header IN XDP_TYPES.OE_ORDER_HEADER,
11: P_OE_Order_Parameter_List IN XDP_TYPES.OE_ORDER_PARAMETER_LIST,
12: Return_Code OUT NOCOPY NUMBER,
13: Error_Description OUT NOCOPY VARCHAR2 ) IS

Line 32: Error_Description := 'Error: XDP OE Order Number cannot be NULL' ;

28:
29: -- Check if the Order Number is passed.
30: IF( lv_oe_order_header.ORDER_NUMBER IS NULL ) THEN
31: Return_Code := -111 ;
32: Error_Description := 'Error: XDP OE Order Number cannot be NULL' ;
33: RETURN ;
34: END IF ;
35:
36: -- Check if the Order Number already exists

Line 51: -- Insert into the XDP OE Order Header Table

47: lv_oe_order_header.PROVISIONING_DATE := SYSDATE ;
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,

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 111: -- Insert any XDP OE Order Parameters.

107: IF( lv_oe_order_parameter_list.COUNT = 0 ) THEN
108: -- No Parameters.
109: NULL ;
110: ELSE
111: -- Insert any XDP OE Order Parameters.
112: lv_param_count := lv_oe_order_parameter_list.FIRST ;
113: FOR lv_temp IN 1..lv_oe_order_parameter_list.COUNT
114: LOOP
115: INSERT INTO XDP_OE_ORDER_PARAMETERS (

Line 115: INSERT INTO XDP_OE_ORDER_PARAMETERS (

111: -- Insert any XDP OE Order Parameters.
112: lv_param_count := lv_oe_order_parameter_list.FIRST ;
113: FOR lv_temp IN 1..lv_oe_order_parameter_list.COUNT
114: LOOP
115: INSERT INTO XDP_OE_ORDER_PARAMETERS (
116: ORDER_NUMBER,
117: ORDER_VERSION,
118: PARAMETER_NAME,
119: PARAMETER_VALUE

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 189: Purpose : Insert into XDP OE Order Line and Line Details

185:
186:
187: /*----------------------------------------
188: Procedure : Insert_OE_Order_Line
189: Purpose : Insert into XDP OE Order Line and Line Details
190: ----------------------------------------*/
191: -- API to Insert into XDP OE Order Line and Line Details Table
192: PROCEDURE Insert_OE_Order_Line( P_OE_Order_Line IN XDP_TYPES.OE_ORDER_LINE,
193: P_OE_Order_Line_Detail_List IN XDP_TYPES.OE_ORDER_LINE_DETAIL_LIST,

Line 191: -- API to Insert into XDP OE Order Line and Line Details Table

187: /*----------------------------------------
188: Procedure : Insert_OE_Order_Line
189: Purpose : Insert into XDP OE Order Line and Line Details
190: ----------------------------------------*/
191: -- API to Insert into XDP OE Order Line and Line Details Table
192: PROCEDURE Insert_OE_Order_Line( P_OE_Order_Line IN XDP_TYPES.OE_ORDER_LINE,
193: P_OE_Order_Line_Detail_List IN XDP_TYPES.OE_ORDER_LINE_DETAIL_LIST,
194: Return_Code OUT NOCOPY NUMBER,
195: Error_Description OUT NOCOPY VARCHAR2 ) IS

Line 213: Error_Description := 'Error: XDP OE Order Number cannot be NULL' ;

209:
210: -- Check if Mandatory fields have Values.
211: IF( lv_oe_order_line.ORDER_NUMBER IS NULL ) THEN
212: Return_Code := -111 ;
213: Error_Description := 'Error: XDP OE Order Number cannot be NULL' ;
214: RETURN ;
215: END IF ;
216:
217: IF( lv_oe_order_line.LINE_NUMBER IS NULL ) THEN

Line 219: Error_Description := 'Error: XDP OE Order Line Number cannot be NULL' ;

215: END IF ;
216:
217: IF( lv_oe_order_line.LINE_NUMBER IS NULL ) THEN
218: Return_Code := -111 ;
219: Error_Description := 'Error: XDP OE Order Line Number cannot be NULL' ;
220: RETURN ;
221: END IF ;
222:
223: IF( lv_oe_order_line.LINE_ITEM_NAME IS NULL ) THEN

Line 225: Error_Description := 'Error: XDP OE Order Line Item Name cannot be NULL' ;

221: END IF ;
222:
223: IF( lv_oe_order_line.LINE_ITEM_NAME IS NULL ) THEN
224: Return_Code := -111 ;
225: Error_Description := 'Error: XDP OE Order Line Item Name cannot be NULL' ;
226: RETURN ;
227: END IF ;
228:
229: IF( lv_oe_order_line.PROVISIONING_REQUIRED_FLAG IS NULL ) THEN

Line 233: -- Check if this is a Valid XDP OE Order

229: IF( lv_oe_order_line.PROVISIONING_REQUIRED_FLAG IS NULL ) THEN
230: lv_oe_order_line.PROVISIONING_REQUIRED_FLAG := 'Y' ;
231: END IF ;
232:
233: -- Check if this is a Valid XDP OE Order
234: IF ( OE_Order_Exists(UPPER( lv_oe_order_line.ORDER_NUMBER ),
235: lv_oe_order_line.ORDER_VERSION ) = 'N' ) THEN
236:
237: Return_Code := -111 ;

Line 244: INSERT INTO XDP_OE_ORDER_LINES (

240: RETURN ;
241: END IF ;
242:
243: -- Insert the XDP Order Line
244: INSERT INTO XDP_OE_ORDER_LINES (
245: ORDER_NUMBER,
246: ORDER_VERSION,
247: LINE_NUMBER,
248: LINE_ITEM_NAME,

Line 301: INSERT INTO XDP_OE_ORDER_LINE_DETS (

297: -- Insert any Line Details
298: lv_detail_count := lv_oe_order_line_detail_list.FIRST ;
299: FOR lv_temp IN 1..lv_oe_order_line_detail_list.COUNT
300: LOOP
301: INSERT INTO XDP_OE_ORDER_LINE_DETS (
302: ORDER_NUMBER,
303: ORDER_VERSION,
304: LINE_NUMBER,
305: PARAMETER_NAME,

Line 333: Purpose : Subimt an Order for Processing from XDP OE Order Tables

329: END Insert_OE_Order_Line ;
330:
331: /*----------------------------------------
332: Procedure : Submit_OE_Order
333: Purpose : Subimt an Order for Processing from XDP OE Order Tables
334:
335: Orginally this was XDP_Submit_OE_Order Procedure. This has now been
336: moved into this Package.
337: ----------------------------------------*/

Line 338: -- API to Submit an Order for Processing from XDP OE Order Tables

334:
335: Orginally this was XDP_Submit_OE_Order Procedure. This has now been
336: moved into this Package.
337: ----------------------------------------*/
338: -- API to Submit an Order for Processing from XDP OE Order Tables
339: PROCEDURE Submit_OE_Order( P_OE_Order_Number IN VARCHAR2,
340: -- Order version made mandatory 03/27/2001. skilaru
341: -- P_OE_Order_Version IN VARCHAR2 DEFAULT NULL,
342: P_OE_Order_Version IN VARCHAR2,

Line 355: FROM XDP_OE_ORDER_PARAMETERS

351: l_sdp_order_id NUMBER;
352:
353: CURSOR lc_param IS
354: SELECT PARAMETER_NAME, PARAMETER_VALUE
355: FROM XDP_OE_ORDER_PARAMETERS
356: WHERE ORDER_NUMBER = p_oe_order_number
357: AND ORDER_VERSION = p_oe_order_version ;
358:
359: /* p_oe_order_version made mandatory. This cursor is never opened.

Line 365: -- FROM XDP_OE_ORDER_PARAMETERS

361: ** 02/27/2001. skilaru
362: */
363: -- CURSOR lc_param2 IS
364: -- SELECT PARAMETER_NAME, PARAMETER_VALUE
365: -- FROM XDP_OE_ORDER_PARAMETERS
366: -- WHERE ORDER_NUMBER = p_oe_order_number
367: -- AND ORDER_VERSION IS NULL;
368:
369: CURSOR lc_line IS

Line 371: FROM XDP_OE_ORDER_LINES

367: -- AND ORDER_VERSION IS NULL;
368:
369: CURSOR lc_line IS
370: SELECT *
371: FROM XDP_OE_ORDER_LINES
372: WHERE ORDER_NUMBER = p_oe_order_number
373: AND ORDER_VERSION = p_oe_order_version;
374:
375: /* p_oe_order_version made mandatory. This cursor is never opened.

Line 381: -- FROM XDP_OE_ORDER_LINES

377: ** 02/27/2001. skilaru
378: */
379: -- CURSOR lc_line2 IS
380: -- SELECT *
381: -- FROM XDP_OE_ORDER_LINES
382: -- WHERE ORDER_NUMBER = p_oe_order_number
383: -- AND ORDER_VERSION IS NULL;
384:
385: CURSOR lc_line_param IS

Line 387: from xdp_oe_order_line_dets

383: -- AND ORDER_VERSION IS NULL;
384:
385: CURSOR lc_line_param IS
386: select *
387: from xdp_oe_order_line_dets
388: where order_number = p_oe_order_number
389: and order_version = p_oe_order_version;
390:
391: /* p_oe_order_version made mandatory. This cursor is never opened.

Line 397: -- from xdp_oe_order_line_dets

393: ** 02/27/2001. skilaru
394: */
395: -- CURSOR lc_line_param2 IS
396: -- select *
397: -- from xdp_oe_order_line_dets
398: -- where order_number = p_oe_order_number
399: -- and order_version IS NULL;
400:
401: BEGIN

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;

Line 659: END XDP_OE_ORDER ;

655: return_code := SQLCODE;
656: error_description := SUBSTR(SQLERRM,1,280);
657: END Submit_OE_Order;
658:
659: END XDP_OE_ORDER ;