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
14:
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
14:
15:
12: Return_Code OUT NOCOPY NUMBER,
13: Error_Description OUT NOCOPY VARCHAR2 ) IS
14:
15:
16: lv_oe_order_header XDP_TYPES.OE_ORDER_HEADER ;
17: lv_oe_order_parameter_list XDP_TYPES.OE_ORDER_PARAMETER_LIST ;
18: lv_param_count BINARY_INTEGER ;
19: lv_temp BINARY_INTEGER ;
20: BEGIN
13: Error_Description OUT NOCOPY VARCHAR2 ) IS
14:
15:
16: lv_oe_order_header XDP_TYPES.OE_ORDER_HEADER ;
17: lv_oe_order_parameter_list XDP_TYPES.OE_ORDER_PARAMETER_LIST ;
18: lv_param_count BINARY_INTEGER ;
19: lv_temp BINARY_INTEGER ;
20: BEGIN
21: -- Make a Local copy.
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
196:
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
196:
197: lv_oe_order_line 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
196:
197: lv_oe_order_line XDP_TYPES.OE_ORDER_LINE ;
198: lv_oe_order_line_detail_list XDP_TYPES.OE_ORDER_LINE_DETAIL_LIST ;
199: lv_detail_count BINARY_INTEGER ;
200: lv_temp BINARY_INTEGER ;
201: BEGIN
194: Return_Code OUT NOCOPY NUMBER,
195: Error_Description OUT NOCOPY VARCHAR2 ) IS
196:
197: lv_oe_order_line XDP_TYPES.OE_ORDER_LINE ;
198: lv_oe_order_line_detail_list XDP_TYPES.OE_ORDER_LINE_DETAIL_LIST ;
199: lv_detail_count BINARY_INTEGER ;
200: lv_temp BINARY_INTEGER ;
201: BEGIN
202: -- Make a Local Copy
342: P_OE_Order_Version IN VARCHAR2,
343: SDP_Order_ID OUT NOCOPY NUMBER,
344: Return_Code OUT NOCOPY NUMBER,
345: Error_Description OUT NOCOPY VARCHAR2) IS
346: lv_header XDP_TYPES.ORDER_HEADER;
347: lv_order_params XDP_TYPES.ORDER_PARAMETER_LIST;
348: lv_line XDP_TYPES.ORDER_LINE_LIST;
349: lv_line_details XDP_TYPES.LINE_PARAM_LIST;
350: lv_index NUMBER;
343: SDP_Order_ID OUT NOCOPY NUMBER,
344: Return_Code OUT NOCOPY NUMBER,
345: Error_Description OUT NOCOPY VARCHAR2) IS
346: lv_header XDP_TYPES.ORDER_HEADER;
347: lv_order_params XDP_TYPES.ORDER_PARAMETER_LIST;
348: lv_line XDP_TYPES.ORDER_LINE_LIST;
349: lv_line_details XDP_TYPES.LINE_PARAM_LIST;
350: lv_index NUMBER;
351: l_sdp_order_id NUMBER;
344: Return_Code OUT NOCOPY NUMBER,
345: Error_Description OUT NOCOPY VARCHAR2) IS
346: lv_header XDP_TYPES.ORDER_HEADER;
347: lv_order_params XDP_TYPES.ORDER_PARAMETER_LIST;
348: lv_line XDP_TYPES.ORDER_LINE_LIST;
349: lv_line_details XDP_TYPES.LINE_PARAM_LIST;
350: lv_index NUMBER;
351: l_sdp_order_id NUMBER;
352:
345: Error_Description OUT NOCOPY VARCHAR2) IS
346: lv_header XDP_TYPES.ORDER_HEADER;
347: lv_order_params XDP_TYPES.ORDER_PARAMETER_LIST;
348: lv_line XDP_TYPES.ORDER_LINE_LIST;
349: lv_line_details XDP_TYPES.LINE_PARAM_LIST;
350: lv_index NUMBER;
351: l_sdp_order_id NUMBER;
352:
353: CURSOR lc_param IS