[Home] [Help]
PACKAGE: APPS.ASO_RESERVATION_INT
Source
1 PACKAGE aso_reservation_int AUTHID CURRENT_USER as
2 /* $Header: asoprsvs.pls 120.1 2005/06/29 12:37:56 appldev ship $ */
3 -- Start of Comments
4 -- Package name : aso_reservation_int
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12
13 -- *******************************************************
14 -- Start of Comments
15 -- *******************************************************
16 -- API Name: Create_reservation
17 -- Type : Public
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,
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,
30 X_reservation_id OUT NOCOPY /* file.sql.39 change */ NUMBER
31 );
32
33 -- *******************************************************
34 -- Start of Comments
35 -- *******************************************************
36 -- API Name: Update_reservation
37 -- Type : Public
38 -- Pre-Req :
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,
48 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
49 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
50
51 -- *******************************************************
52 -- Start of Comments
53 -- *******************************************************
54 -- API Name: Delete_reservation
55 -- Type : Public
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 --
65 -- OUT NOCOPY /* file.sql.39 change */ :
66 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
68 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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,
78 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
79 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
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,
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
93 );
94
95 End aso_reservation_int;