20: PROCEDURE Create_reservation(
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_line_rec IN aso_quote_pub.qte_line_rec_type,
25: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
26: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
27: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
28: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
21: P_Api_Version_Number IN NUMBER,
22: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
23: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_line_rec IN aso_quote_pub.qte_line_rec_type,
25: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
26: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
27: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
28: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29: X_quantity_reserved OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: PROCEDURE Update_reservation(
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_line_rec IN aso_quote_pub.qte_line_rec_type,
46: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
47: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
48: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
49: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
42: P_Api_Version_Number IN NUMBER,
43: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
44: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_line_rec IN aso_quote_pub.qte_line_rec_type,
46: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
47: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
48: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
49: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
50:
71: PROCEDURE Delete_reservation(
72: P_Api_Version_Number IN NUMBER,
73: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
74: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_line_rec IN aso_quote_pub.qte_line_rec_type,
76: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
77: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
78: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
79: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: P_Api_Version_Number IN NUMBER,
73: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
74: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_line_rec IN aso_quote_pub.qte_line_rec_type,
76: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
77: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
78: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
79: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80: );
82: PROCEDURE Transfer_Reservation(
83: P_Api_Version_Number IN NUMBER,
84: P_Init_msg_list In VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: P_Header_rec IN ASO_QUOTE_PUB.qte_header_rec_type,
87: P_Line_rec IN ASO_QUOTE_PUB.qte_line_rec_type,
88: P_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type,
89: X_New_Reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
90: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
83: P_Api_Version_Number IN NUMBER,
84: P_Init_msg_list In VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: P_Header_rec IN ASO_QUOTE_PUB.qte_header_rec_type,
87: P_Line_rec IN ASO_QUOTE_PUB.qte_line_rec_type,
88: P_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type,
89: X_New_Reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
90: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
84: P_Init_msg_list In VARCHAR2 := FND_API.G_FALSE,
85: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
86: P_Header_rec IN ASO_QUOTE_PUB.qte_header_rec_type,
87: P_Line_rec IN ASO_QUOTE_PUB.qte_line_rec_type,
88: P_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type,
89: X_New_Reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
90: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
92: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2