[Home] [Help]
PACKAGE: APPS.GMI_RESERVATION_PUB
Source
1 PACKAGE GMI_Reservation_PUB AS
2 /* $Header: GMIPRSVS.pls 120.0 2005/05/26 00:12:50 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIPRSVS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains public procedures relating to OPM |
13 | reservation. |
14 | |
15 | - Query_Reservation |
16 | - Create_Reservation |
17 | - Update_Reservation |
18 | - Delete_Reservation |
19 | - Transfer_Reservation |
20 | |
21 | |
22 | HISTORY |
23 | 21-FEB-2000 odaboval Created |
24 | |
25 +=========================================================================+
26 API Name : GMI_Reservation_PUB
27 Type : Global
28 Function : This package contains Global procedures used to
29 OPM reservation process.
30
31 Pre-reqs : N/A
32 Parameters: Per function
33
34 Current Vers : 1.0
35
36 */
37 /*
38 Global Variable Useful in the Branching Logic :
39 organization_id NUMBER;
40 oe_line_id NUMBER;
41 */
42
43
44 PROCEDURE Query_Reservation
45 (
46 p_api_version_number IN NUMBER
47 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48 , x_return_status OUT NOCOPY VARCHAR2
49 , x_msg_count OUT NOCOPY NUMBER
50 , x_msg_data OUT NOCOPY VARCHAR2
51 , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
52 , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
53 , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
54 , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
55 , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
56 , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
57 , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
58 , x_error_code OUT NOCOPY NUMBER
59 );
60
61 PROCEDURE Create_Reservation
62 (
63 p_api_version_number IN NUMBER
64 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
65 , x_return_status OUT NOCOPY VARCHAR2
66 , x_msg_count OUT NOCOPY NUMBER
67 , x_msg_data OUT NOCOPY VARCHAR2
68 , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
69 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
70 , p_serial_number IN inv_reservation_global.serial_number_tbl_type
71 , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
72 , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
73 , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
74 , x_quantity_reserved OUT NOCOPY NUMBER
75 , x_reservation_id OUT NOCOPY NUMBER
76 );
77
78 PROCEDURE Update_Reservation
79 (
80 p_api_version_number IN NUMBER
81 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
82 , x_return_status OUT NOCOPY VARCHAR2
83 , x_msg_count OUT NOCOPY NUMBER
84 , x_msg_data OUT NOCOPY VARCHAR2
85 , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
86 , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87 , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88 , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
89 , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
90 );
91
92 PROCEDURE Delete_Reservation
93 (
94 p_api_version_number IN NUMBER
95 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98 , x_msg_data OUT NOCOPY VARCHAR2
99 , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
100 , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
101 , p_serial_number IN inv_reservation_global.serial_number_tbl_type
102 );
103
104 PROCEDURE Transfer_Reservation
105 (
106 p_api_version_number IN NUMBER
107 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
108 , x_return_status OUT NOCOPY VARCHAR2
109 , x_msg_count OUT NOCOPY NUMBER
110 , x_msg_data OUT NOCOPY VARCHAR2
111 , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
112 , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113 , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114 , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115 , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116 , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117 , x_to_reservation_id OUT NOCOPY NUMBER
118 );
119
120 END GMI_Reservation_PUB;