DBA Data[Home] [Help]

APPS.XDP_INTERFACES dependencies on XDP_TYPES

Line 212: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,

208: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2);
209:
210:
211: PROCEDURE Process_Old_Order(
212: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
213: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
214: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
215: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
216: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',

Line 213: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,

209:
210:
211: PROCEDURE Process_Old_Order(
212: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
213: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
214: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
215: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
216: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
217: SDP_ORDER_ID OUT NOCOPY NUMBER,

Line 214: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,

210:
211: PROCEDURE Process_Old_Order(
212: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
213: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
214: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
215: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
216: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
217: SDP_ORDER_ID OUT NOCOPY NUMBER,
218: RETURN_CODE IN OUT NOCOPY NUMBER,

Line 215: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,

211: PROCEDURE Process_Old_Order(
212: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
213: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
214: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
215: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
216: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
217: SDP_ORDER_ID OUT NOCOPY NUMBER,
218: RETURN_CODE IN OUT NOCOPY NUMBER,
219: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2);

Line 227: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,

223: -- a service activation order
224: -- -------------------------------------------
225:
226: PROCEDURE Process_Order(
227: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
228: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
229: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
230: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
231: SDP_ORDER_ID OUT NOCOPY NUMBER,

Line 228: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,

224: -- -------------------------------------------
225:
226: PROCEDURE Process_Order(
227: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
228: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
229: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
230: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
231: SDP_ORDER_ID OUT NOCOPY NUMBER,
232: RETURN_CODE IN OUT NOCOPY NUMBER,

Line 229: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,

225:
226: PROCEDURE Process_Order(
227: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
228: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
229: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
230: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
231: SDP_ORDER_ID OUT NOCOPY NUMBER,
232: RETURN_CODE IN OUT NOCOPY NUMBER,
233: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)

Line 230: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,

226: PROCEDURE Process_Order(
227: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
228: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
229: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
230: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
231: SDP_ORDER_ID OUT NOCOPY NUMBER,
232: RETURN_CODE IN OUT NOCOPY NUMBER,
233: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
234: IS

Line 235: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;

231: SDP_ORDER_ID OUT NOCOPY NUMBER,
232: RETURN_CODE IN OUT NOCOPY NUMBER,
233: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
234: IS
235: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
236: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
237: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
238: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
239:

Line 236: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;

232: RETURN_CODE IN OUT NOCOPY NUMBER,
233: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
234: IS
235: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
236: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
237: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
238: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
239:
240: -- PL/SQL Block

Line 237: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;

233: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
234: IS
235: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
236: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
237: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
238: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
239:
240: -- PL/SQL Block
241: BEGIN

Line 238: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;

234: IS
235: lv_ORDER_HEADER XDP_TYPES.ORDER_HEADER;
236: lv_ORDER_PARAMETER XDP_TYPES.ORDER_PARAMETER_LIST;
237: lv_ORDER_LINE_LIST XDP_TYPES.ORDER_LINE_LIST;
238: lv_LINE_PARAMETER_LIST XDP_TYPES.LINE_PARAM_LIST;
239:
240: -- PL/SQL Block
241: BEGIN
242: lv_order_header := P_ORDER_HEADER ;

Line 266: p_task_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,

262: END Process_Order;
263:
264: PROCEDURE Process_DRC_Order(
265: p_workitem_id IN NUMBER,
266: p_task_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,
267: x_order_id OUT NOCOPY NUMBER,
268: x_return_code OUT NOCOPY NUMBER,
269: x_error_description OUT NOCOPY VARCHAR2)
270: IS

Line 271: l_order_header xdp_types.order_header;

267: x_order_id OUT NOCOPY NUMBER,
268: x_return_code OUT NOCOPY NUMBER,
269: x_error_description OUT NOCOPY VARCHAR2)
270: IS
271: l_order_header xdp_types.order_header;
272: l_order_parameter xdp_types.order_parameter_list;
273: l_order_line_list xdp_types.order_line_list;
274: l_line_parameter_list xdp_types.line_param_list;
275:

Line 272: l_order_parameter xdp_types.order_parameter_list;

268: x_return_code OUT NOCOPY NUMBER,
269: x_error_description OUT NOCOPY VARCHAR2)
270: IS
271: l_order_header xdp_types.order_header;
272: l_order_parameter xdp_types.order_parameter_list;
273: l_order_line_list xdp_types.order_line_list;
274: l_line_parameter_list xdp_types.line_param_list;
275:
276: l_workitem_name VARCHAR2(200);

Line 273: l_order_line_list xdp_types.order_line_list;

269: x_error_description OUT NOCOPY VARCHAR2)
270: IS
271: l_order_header xdp_types.order_header;
272: l_order_parameter xdp_types.order_parameter_list;
273: l_order_line_list xdp_types.order_line_list;
274: l_line_parameter_list xdp_types.line_param_list;
275:
276: l_workitem_name VARCHAR2(200);
277: l_order_id NUMBER;

Line 274: l_line_parameter_list xdp_types.line_param_list;

270: IS
271: l_order_header xdp_types.order_header;
272: l_order_parameter xdp_types.order_parameter_list;
273: l_order_line_list xdp_types.order_line_list;
274: l_line_parameter_list xdp_types.line_param_list;
275:
276: l_workitem_name VARCHAR2(200);
277: l_order_id NUMBER;
278: BEGIN

Line 2236: p_order_header OUT NOCOPY XDP_TYPES.ORDER_HEADER,

2232: -- information
2233: --
2234: PROCEDURE Get_Order_Status(
2235: P_SDP_ORDER_ID IN NUMBER,
2236: p_order_header OUT NOCOPY XDP_TYPES.ORDER_HEADER,
2237: P_Order_lines OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
2238: RETURN_CODE OUT NOCOPY NUMBER,
2239: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2)
2240: IS

Line 2237: P_Order_lines OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,

2233: --
2234: PROCEDURE Get_Order_Status(
2235: P_SDP_ORDER_ID IN NUMBER,
2236: p_order_header OUT NOCOPY XDP_TYPES.ORDER_HEADER,
2237: P_Order_lines OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
2238: RETURN_CODE OUT NOCOPY NUMBER,
2239: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2)
2240: IS
2241:

Line 2772: FUNCTION TO_NEW_ORDER_HEADER(p_order_header IN XDP_TYPES.ORDER_HEADER)

2768: From here on are the procedures used to convert the old process order api to
2769: new process order api
2770: */
2771:
2772: FUNCTION TO_NEW_ORDER_HEADER(p_order_header IN XDP_TYPES.ORDER_HEADER)
2773: RETURN XDP_TYPES.SERVICE_ORDER_HEADER
2774: IS
2775: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2776: BEGIN

Line 2773: RETURN XDP_TYPES.SERVICE_ORDER_HEADER

2769: new process order api
2770: */
2771:
2772: FUNCTION TO_NEW_ORDER_HEADER(p_order_header IN XDP_TYPES.ORDER_HEADER)
2773: RETURN XDP_TYPES.SERVICE_ORDER_HEADER
2774: IS
2775: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2776: BEGIN
2777: lv_order_header.order_number := p_order_header.order_number;

Line 2775: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;

2771:
2772: FUNCTION TO_NEW_ORDER_HEADER(p_order_header IN XDP_TYPES.ORDER_HEADER)
2773: RETURN XDP_TYPES.SERVICE_ORDER_HEADER
2774: IS
2775: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2776: BEGIN
2777: lv_order_header.order_number := p_order_header.order_number;
2778: lv_order_header.order_version := p_order_header.order_version;
2779: lv_order_header.required_fulfillment_date := p_order_header.provisioning_date;

Line 2835: p_order_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,

2831:
2832: END TO_NEW_ORDER_HEADER;
2833:
2834: PROCEDURE TO_NEW_ORDER_PARAM_LIST(
2835: p_order_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,
2836: x_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST)
2837: IS
2838: lv_param_index BINARY_INTEGER;
2839: BEGIN

Line 2836: x_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST)

2832: END TO_NEW_ORDER_HEADER;
2833:
2834: PROCEDURE TO_NEW_ORDER_PARAM_LIST(
2835: p_order_parameter IN XDP_TYPES.ORDER_PARAMETER_LIST,
2836: x_order_param_list IN OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST)
2837: IS
2838: lv_param_index BINARY_INTEGER;
2839: BEGIN
2840: IF p_order_parameter.COUNT > 0 THEN

Line 2852: p_line_item IN XDP_TYPES.LINE_ITEM,

2848: END IF;
2849: END;
2850:
2851: FUNCTION TO_NEW_LINE_ITEM(
2852: p_line_item IN XDP_TYPES.LINE_ITEM,
2853: p_default_action_code IN VARCHAR2)
2854: RETURN XDP_TYPES.SERVICE_LINE_ITEM
2855: IS
2856: x_order_line_item XDP_TYPES.SERVICE_LINE_ITEM;

Line 2854: RETURN XDP_TYPES.SERVICE_LINE_ITEM

2850:
2851: FUNCTION TO_NEW_LINE_ITEM(
2852: p_line_item IN XDP_TYPES.LINE_ITEM,
2853: p_default_action_code IN VARCHAR2)
2854: RETURN XDP_TYPES.SERVICE_LINE_ITEM
2855: IS
2856: x_order_line_item XDP_TYPES.SERVICE_LINE_ITEM;
2857: BEGIN
2858: x_order_line_item.line_number := p_line_item.line_number;

Line 2856: x_order_line_item XDP_TYPES.SERVICE_LINE_ITEM;

2852: p_line_item IN XDP_TYPES.LINE_ITEM,
2853: p_default_action_code IN VARCHAR2)
2854: RETURN XDP_TYPES.SERVICE_LINE_ITEM
2855: IS
2856: x_order_line_item XDP_TYPES.SERVICE_LINE_ITEM;
2857: BEGIN
2858: x_order_line_item.line_number := p_line_item.line_number;
2859: x_order_line_item.line_source := NULL; -- MAYA
2860:

Line 2937: p_line_list IN XDP_TYPES.ORDER_LINE_LIST,

2933: RETURN x_order_line_item;
2934: END;
2935:
2936: PROCEDURE TO_NEW_LINE_LIST(
2937: p_line_list IN XDP_TYPES.ORDER_LINE_LIST,
2938: x_order_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2939: p_default_action_code IN VARCHAR2)
2940: IS
2941: lv_param_index BINARY_INTEGER;

Line 2938: x_order_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,

2934: END;
2935:
2936: PROCEDURE TO_NEW_LINE_LIST(
2937: p_line_list IN XDP_TYPES.ORDER_LINE_LIST,
2938: x_order_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
2939: p_default_action_code IN VARCHAR2)
2940: IS
2941: lv_param_index BINARY_INTEGER;
2942: BEGIN

Line 2954: p_line_parameter_list IN XDP_TYPES.LINE_PARAM_LIST,

2950: END IF;
2951: END;
2952:
2953: PROCEDURE TO_NEW_LINE_PARAM_LIST(
2954: p_line_parameter_list IN XDP_TYPES.LINE_PARAM_LIST,
2955: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
2956: IS
2957: lv_param_index BINARY_INTEGER;
2958: BEGIN

Line 2955: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)

2951: END;
2952:
2953: PROCEDURE TO_NEW_LINE_PARAM_LIST(
2954: p_line_parameter_list IN XDP_TYPES.LINE_PARAM_LIST,
2955: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
2956: IS
2957: lv_param_index BINARY_INTEGER;
2958: BEGIN
2959: IF p_line_parameter_list.COUNT > 0 THEN

Line 2976: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,

2972:
2973: /* This is the wrapper over the old API */
2974:
2975: PROCEDURE Process_Old_Order(
2976: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
2977: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
2978: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
2979: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
2980: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',

Line 2977: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,

2973: /* This is the wrapper over the old API */
2974:
2975: PROCEDURE Process_Old_Order(
2976: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
2977: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
2978: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
2979: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
2980: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
2981: SDP_ORDER_ID OUT NOCOPY NUMBER,

Line 2978: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,

2974:
2975: PROCEDURE Process_Old_Order(
2976: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
2977: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
2978: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
2979: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
2980: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
2981: SDP_ORDER_ID OUT NOCOPY NUMBER,
2982: RETURN_CODE IN OUT NOCOPY NUMBER,

Line 2979: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,

2975: PROCEDURE Process_Old_Order(
2976: P_ORDER_HEADER IN XDP_TYPES.ORDER_HEADER,
2977: P_ORDER_PARAMETER IN XDP_TYPES.ORDER_PARAMETER_LIST,
2978: P_ORDER_LINE_LIST IN XDP_TYPES.ORDER_LINE_LIST,
2979: P_LINE_PARAMETER_LIST IN XDP_TYPES.LINE_PARAM_LIST,
2980: P_execution_mode IN VARCHAR2 DEFAULT 'ASYNC',
2981: SDP_ORDER_ID OUT NOCOPY NUMBER,
2982: RETURN_CODE IN OUT NOCOPY NUMBER,
2983: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)

Line 2985: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;

2981: SDP_ORDER_ID OUT NOCOPY NUMBER,
2982: RETURN_CODE IN OUT NOCOPY NUMBER,
2983: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
2984: IS
2985: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2986: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
2987: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
2988: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2989: BEGIN

Line 2986: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;

2982: RETURN_CODE IN OUT NOCOPY NUMBER,
2983: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
2984: IS
2985: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2986: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
2987: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
2988: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2989: BEGIN
2990: lv_order_header := TO_NEW_ORDER_HEADER(P_ORDER_HEADER);

Line 2987: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;

2983: ERROR_DESCRIPTION IN OUT NOCOPY VARCHAR2)
2984: IS
2985: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2986: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
2987: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
2988: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2989: BEGIN
2990: lv_order_header := TO_NEW_ORDER_HEADER(P_ORDER_HEADER);
2991: TO_NEW_ORDER_PARAM_LIST(P_ORDER_PARAMETER,lv_order_param_list);

Line 2988: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;

2984: IS
2985: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
2986: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;
2987: lv_order_line_list XDP_TYPES.SERVICE_ORDER_LINE_LIST;
2988: lv_line_param_list XDP_TYPES.SERVICE_LINE_PARAM_LIST;
2989: BEGIN
2990: lv_order_header := TO_NEW_ORDER_HEADER(P_ORDER_HEADER);
2991: TO_NEW_ORDER_PARAM_LIST(P_ORDER_PARAMETER,lv_order_param_list);
2992: TO_NEW_LINE_LIST(P_ORDER_LINE_LIST,lv_order_line_list,p_order_header.order_action);

Line 3031: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS,

3027: */
3028:
3029: PROCEDURE Get_Order_Status(
3030: p_order_id IN NUMBER,
3031: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS,
3032: x_return_code OUT NOCOPY NUMBER,
3033: x_error_description OUT NOCOPY VARCHAR2)
3034: IS
3035: CURSOR lc_order_param IS

Line 3084: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,

3080: */
3081:
3082: PROCEDURE Get_Order_Header(
3083: p_order_id IN NUMBER,
3084: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3085: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3086: x_return_code OUT NOCOPY NUMBER,
3087: x_error_description OUT NOCOPY VARCHAR2)
3088: IS

Line 3085: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,

3081:
3082: PROCEDURE Get_Order_Header(
3083: p_order_id IN NUMBER,
3084: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3085: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3086: x_return_code OUT NOCOPY NUMBER,
3087: x_error_description OUT NOCOPY VARCHAR2)
3088: IS
3089: CURSOR lc_order_param IS

Line 3228: x_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,

3224: --
3225:
3226: PROCEDURE Get_Order_Lines(
3227: p_order_id IN NUMBER,
3228: x_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3229: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
3230: IS
3231: CURSOR lc_line IS
3232: SELECT

Line 3229: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)

3225:
3226: PROCEDURE Get_Order_Lines(
3227: p_order_id IN NUMBER,
3228: x_line_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3229: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST)
3230: IS
3231: CURSOR lc_line IS
3232: SELECT
3233: line_number,

Line 3369: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS,

3365: Procedure Get_Order_Status(
3366: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3367: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3368: p_order_version IN VARCHAR2 DEFAULT '1',
3369: x_order_status OUT NOCOPY XDP_TYPES.SERVICE_ORDER_STATUS,
3370: x_return_code OUT NOCOPY NUMBER,
3371: x_error_description OUT NOCOPY VARCHAR2)
3372: IS
3373: l_order_id NUMBER;

Line 3404: Data is stored in four data structures as defined in XDP_TYPES

3400:
3401: /*
3402: This is the internal API for geting order details. It is used
3403: by public API to retrieve order detail information.
3404: Data is stored in four data structures as defined in XDP_TYPES
3405: */
3406: Procedure Get_Order_Details(
3407: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3408: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 3410: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,

3406: Procedure Get_Order_Details(
3407: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3408: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3409: p_order_version IN VARCHAR2 DEFAULT '1',
3410: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3411: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3412: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3413: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3414: x_return_code OUT NOCOPY NUMBER,

Line 3411: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,

3407: p_order_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
3408: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3409: p_order_version IN VARCHAR2 DEFAULT '1',
3410: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3411: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3412: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3413: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3414: x_return_code OUT NOCOPY NUMBER,
3415: x_error_description OUT NOCOPY VARCHAR2)

Line 3412: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,

3408: p_order_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
3409: p_order_version IN VARCHAR2 DEFAULT '1',
3410: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3411: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3412: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3413: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3414: x_return_code OUT NOCOPY NUMBER,
3415: x_error_description OUT NOCOPY VARCHAR2)
3416: IS

Line 3413: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,

3409: p_order_version IN VARCHAR2 DEFAULT '1',
3410: x_order_header OUT NOCOPY XDP_TYPES.SERVICE_ORDER_HEADER,
3411: x_order_param_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_PARAM_LIST,
3412: x_line_item_list OUT NOCOPY XDP_TYPES.SERVICE_ORDER_LINE_LIST,
3413: x_line_param_list OUT NOCOPY XDP_TYPES.SERVICE_LINE_PARAM_LIST,
3414: x_return_code OUT NOCOPY NUMBER,
3415: x_error_description OUT NOCOPY VARCHAR2)
3416: IS
3417: l_order_id NUMBER;