DBA Data[Home] [Help]

APPS.XDP_OE_ORDER dependencies on XDP_TYPES

Line 10: PROCEDURE Insert_OE_Order( P_OE_Order_Header IN XDP_TYPES.OE_ORDER_HEADER,

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:

Line 11: P_OE_Order_Parameter_List IN XDP_TYPES.OE_ORDER_PARAMETER_LIST,

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:

Line 16: lv_oe_order_header XDP_TYPES.OE_ORDER_HEADER ;

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

Line 17: lv_oe_order_parameter_list XDP_TYPES.OE_ORDER_PARAMETER_LIST ;

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.

Line 192: PROCEDURE Insert_OE_Order_Line( P_OE_Order_Line IN XDP_TYPES.OE_ORDER_LINE,

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:

Line 193: P_OE_Order_Line_Detail_List IN XDP_TYPES.OE_ORDER_LINE_DETAIL_LIST,

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 ;

Line 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

Line 198: lv_oe_order_line_detail_list 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
202: -- Make a Local Copy

Line 346: lv_header XDP_TYPES.ORDER_HEADER;

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;

Line 347: lv_order_params XDP_TYPES.ORDER_PARAMETER_LIST;

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;

Line 348: lv_line XDP_TYPES.ORDER_LINE_LIST;

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:

Line 349: lv_line_details XDP_TYPES.LINE_PARAM_LIST;

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