19: -- End of Comments
20:
21: PROCEDURE Process_Order
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
20:
21: PROCEDURE Process_Order
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
28: OE_GLOBALS.G_MISS_CONTROL_REC
21: PROCEDURE Process_Order
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
28: OE_GLOBALS.G_MISS_CONTROL_REC
29: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
28: OE_GLOBALS.G_MISS_CONTROL_REC
29: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
30: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140:
141: -- Process_order overloaded with payments parameters
142: PROCEDURE Process_Order
143: ( p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
141: -- Process_order overloaded with payments parameters
142: PROCEDURE Process_Order
143: ( p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
149: OE_GLOBALS.G_MISS_CONTROL_REC
142: PROCEDURE Process_Order
143: ( p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
149: OE_GLOBALS.G_MISS_CONTROL_REC
150: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
143: ( p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
146: , p_commit IN VARCHAR2 := FND_API.G_FALSE
147: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
148: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
149: OE_GLOBALS.G_MISS_CONTROL_REC
150: , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
151: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
296: -- End of Comments
297:
298: PROCEDURE Lock_Order
299: ( p_api_version_number IN NUMBER
300: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
301: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
302: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
304: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
297:
298: PROCEDURE Lock_Order
299: ( p_api_version_number IN NUMBER
300: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
301: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
302: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
304: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
305: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
366:
367: -- Lock_order over loaded with payment parameters
368: PROCEDURE Lock_Order
369: ( p_api_version_number IN NUMBER
370: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
372: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
373: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
374: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367: -- Lock_order over loaded with payment parameters
368: PROCEDURE Lock_Order
369: ( p_api_version_number IN NUMBER
370: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
371: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
372: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
373: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
374: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
375: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
463: -- End of Comments
464:
465: PROCEDURE Get_Order
466: ( p_api_version_number IN NUMBER
467: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
468: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
469: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
470: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
471: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
464:
465: PROCEDURE Get_Order
466: ( p_api_version_number IN NUMBER
467: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
468: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
469: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
470: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
471: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , p_header_id IN NUMBER :=
469: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
470: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
471: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , p_header_id IN NUMBER :=
473: FND_API.G_MISS_NUM
474: , p_header IN VARCHAR2 :=
475: FND_API.G_MISS_CHAR
476: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
477: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
471: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , p_header_id IN NUMBER :=
473: FND_API.G_MISS_NUM
474: , p_header IN VARCHAR2 :=
475: FND_API.G_MISS_CHAR
476: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
477: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
478: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
479: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
498:
499: -- Get_order over loaded with payment parameters
500: PROCEDURE Get_Order
501: ( p_api_version_number IN NUMBER
502: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
503: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
504: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
505: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
506: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
499: -- Get_order over loaded with payment parameters
500: PROCEDURE Get_Order
501: ( p_api_version_number IN NUMBER
502: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
503: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
504: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
505: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
506: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
507: , p_header_id IN NUMBER :=
504: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
505: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
506: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
507: , p_header_id IN NUMBER :=
508: FND_API.G_MISS_NUM
509: , p_header IN VARCHAR2 :=
510: FND_API.G_MISS_CHAR
511: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
512: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
506: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
507: , p_header_id IN NUMBER :=
508: FND_API.G_MISS_NUM
509: , p_header IN VARCHAR2 :=
510: FND_API.G_MISS_CHAR
511: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
512: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
513: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
514: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
535: );
536:
537: PROCEDURE Get_Option_Lines
538: ( p_api_version_number IN NUMBER
539: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
540: , p_top_model_line_id IN NUMBER
541: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type
542: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
543: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER