18: -- Pre-Req :
19: -- Parameters:
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,
19: -- Parameters:
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,
39: -- Parameters:
40:
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,
40:
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,
56: -- Pre-Req :
57: -- Parameters:
58: -- IN
59: -- p_api_version_number IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
61: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
62: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
63: -- P__Rec IN _Rec_Type Required
64: --
57: -- Parameters:
58: -- IN
59: -- p_api_version_number IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
61: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
62: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
63: -- P__Rec IN _Rec_Type Required
64: --
65: -- OUT NOCOPY /* file.sql.39 change */ :
69: -- Version : Current version 2.0
70:
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,
70:
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,
80: );
81:
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,
81:
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,