1 PACKAGE AHL_UA_COMMON_PVT AS
2 /* $Header: AHLVUACS.pls 120.0 2005/05/26 02:00:11 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UA_COMMON_PVT';
5
6 -------------------------------
7 -- Define records and tables --
8 -------------------------------
9 TYPE Event_Schedule_Rec_Type IS RECORD
10 (
11 EVENT_ID NUMBER,
12 EVENT_TYPE VARCHAR2 (10),
13 EVENT_START_TIME DATE,
14 EVENT_END_TIME DATE
15 );
16
17 TYPE Event_Schedule_Tbl_Type IS TABLE OF Event_Schedule_Rec_Type INDEX BY BINARY_INTEGER;
18
19 -----------------------
20 -- Define procedures --
21 -----------------------
22 -- Start of Comments --
23 --
24 -- Procedure name : Get_All_Events
25 -- Type : Private
26 -- Function : API to retrieve all sorted events (sorted on start times) for a particular
27 -- unit configuration for a time period from start time to end time.
28 -- Pre-reqs :
29 --
30 -- Standard IN Parameters :
31 -- p_api_version IN NUMBER Required
32 --
33 -- Standard OUT Parameters :
34 -- x_return_status OUT VARCHAR2 Required
35 -- x_msg_count OUT NUMBER Required
36 -- x_msg_data OUT VARCHAR2 Required
37 --
38 -- Get_All_Events Parameters :
39 -- p_unit_config_id IN NUMBER Required
40 -- p_start_date_time IN DATE Required
41 -- p_end_date_time IN DATE Required
42 -- p_use_actuals IN VARCHAR2
43 -- x_event_schedules OUT Event_Schedule_Tbl_Type
44 --
45 -- Version :
46 -- Initial Version 1.0
47 --
48 -- End of Comments --
49 PROCEDURE Get_All_Events
50 (
51 p_api_version IN NUMBER,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_unit_config_id IN NUMBER,
56 p_start_date_time IN DATE,
57 p_end_date_time IN DATE,
58 p_use_actuals IN VARCHAR2,
59 x_event_schedules OUT NOCOPY Event_Schedule_Tbl_Type
60 );
61
62 -- Start of Comments --
63 --
64 -- Procedure name : Get_Prec_Flight_Info
65 -- Type : Private
66 -- Function : API to retrieve previous flight schedule, for a particular unit configuration for
67 -- a time period from start time to end time.
68 -- Pre-reqs :
69 --
70 -- Standard IN Parameters :
71 -- p_api_version IN NUMBER Required
72 --
73 -- Standard OUT Parameters :
74 -- x_return_status OUT VARCHAR2 Required
75 -- x_msg_count OUT NUMBER Required
76 -- x_msg_data OUT VARCHAR2 Required
77 --
78 -- Get_Prec_Flight_Info Parameters :
79 -- p_unit_config_id IN NUMBER Required
80 -- p_start_date_time IN DATE Required
81 -- p_use_actuals IN VARCHAR2
82 -- x_prec_flight_schedule OUT AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type
83 -- x_is_conflict OUT VARCHAR2
84 --
85 -- Version :
86 -- Initial Version 1.0
87 --
88 -- End of Comments --
89 PROCEDURE Get_Prec_Flight_Info
90 (
91 p_api_version IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_unit_config_id IN NUMBER,
96 p_start_date_time IN DATE,
97 p_use_actuals IN VARCHAR2,
98 x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
99 x_is_conflict OUT NOCOPY VARCHAR2
100 );
101
102 -- Start of Comments --
103 --
104 -- Procedure name : Get_Prec_Visit_Info
105 -- Type : Private
106 -- Function : API to retrieve a previous visit,for a particular unit configuration for
107 -- a given start time.
108 -- Pre-reqs :
109 --
110 -- Standard IN Parameters :
111 -- p_api_version IN NUMBER Required
112 --
113 -- Standard OUT Parameters :
114 -- x_return_status OUT VARCHAR2 Required
115 -- x_msg_count OUT NUMBER Required
116 -- x_msg_data OUT VARCHAR2 Required
117 --
118 -- Get_Prec_Visit_Info Parameters :
119 -- p_unit_config_id IN NUMBER
120 -- p_start_date_time IN DATE,
121 -- x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
122 -- x_is_conflict OUT NOCOPY VARCHAR2
123 --
124 -- Version :
125 -- Initial Version 1.0
126 --
127 -- End of Comments --
128 PROCEDURE Get_Prec_Visit_Info
129 (
130 p_api_version IN NUMBER,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_unit_config_id IN NUMBER,
135 p_start_date_time IN DATE,
136 x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
137 x_is_conflict OUT NOCOPY VARCHAR2
138 );
139
140 -- Start of Comments --
141 --
142 -- Procedure name : Get_Succ_Flight_Info
143 -- Type : Private
144 -- Function : API to retrieve previous flight schedule, for a particular unit configuration for
145 -- a time period from start time to end time.
146 -- Pre-reqs :
147 --
148 -- Standard IN Parameters :
149 -- p_api_version IN NUMBER Required
150 --
151 -- Standard OUT Parameters :
152 -- x_return_status OUT VARCHAR2 Required
153 -- x_msg_count OUT NUMBER Required
154 -- x_msg_data OUT VARCHAR2 Required
155 --
156 -- Get_Succ_Flight_Info Parameters :
157 -- p_unit_config_id IN NUMBER Required
158 -- p_start_date_time IN DATE Required
159 -- p_use_actuals IN VARCHAR2
160 -- x_Succ_flight_schedule OUT AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type
161 -- x_is_conflict OUT VARCHAR2
162 --
163 -- Version :
164 -- Initial Version 1.0
165 --
166 -- End of Comments --
167 PROCEDURE Get_Succ_Flight_Info
168 (
169 p_api_version IN NUMBER,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_unit_config_id IN NUMBER,
174 p_end_date_time IN DATE,
175 p_use_actuals IN VARCHAR2,
176 x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
177 x_is_conflict OUT NOCOPY VARCHAR2
178 );
179
180 -- Start of Comments --
181 --
182 -- Procedure name : Get_Succ_Visit_Info
183 -- Type : Private
184 -- Function : API to retrieve a succeeding visit,for a particular unit configuration for
185 -- a given end time.
186 -- Pre-reqs :
187 --
188 -- Standard IN Parameters :
189 -- p_api_version IN NUMBER Required
190 --
191 -- Standard OUT Parameters :
192 -- x_return_status OUT VARCHAR2 Required
193 -- x_msg_count OUT NUMBER Required
194 -- x_msg_data OUT VARCHAR2 Required
195 --
196 -- Get_Prec_Visit_Info Parameters :
197 -- p_unit_config_id IN NUMBER
198 -- p_end_date_time IN DATE,
199 -- x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
200 -- x_is_conflict OUT NOCOPY VARCHAR2
201 --
202 -- Version :
203 -- Initial Version 1.0
204 --
205 -- End of Comments --
206 PROCEDURE Get_Succ_Visit_Info
207 (
208 p_api_version IN NUMBER,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_unit_config_id IN NUMBER,
213 p_end_date_time IN DATE,
214 x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
215 x_is_conflict OUT NOCOPY VARCHAR2
216 );
217 -- Start of Comments --
218 --
219 -- Procedure name : Get_Prec_Event_Info
220 -- Type : Private
221 -- Function : API to retrieve the preceding visit or flight schedule, for a particular unit
222 -- configuration for a given start time. If there are more than one flight schedule
223 -- or visit ending at the same time then a conflict is shown.
224 -- Pre-reqs :
225 --
226 -- Standard IN Parameters :
227 -- p_api_version IN NUMBER Required
228 --
229 -- Standard OUT Parameters :
230 -- x_return_status OUT VARCHAR2 Required
231 -- x_msg_count OUT NUMBER Required
232 -- x_msg_data OUT VARCHAR2 Required
233 --
234 -- Get_Prec_Event_Info Parameters :
235 -- p_unit_config_id IN NUMBER,
236 -- p_start_date_time IN DATE,
237 -- p_use_actuals IN VARCHAR2,
238 -- x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
239 -- x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
240 -- x_is_conflict OUT NOCOPY VARCHAR2
241 --
242 -- Version :
243 -- Initial Version 1.0
244 --
245 -- End of Comments --
246 PROCEDURE Get_Prec_Event_Info
247 (
248 p_api_version IN NUMBER,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2,
252 p_unit_config_id IN NUMBER,
253 p_start_date_time IN DATE,
254 p_use_actuals IN VARCHAR2,
255 x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
256 x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
257 x_is_conflict OUT NOCOPY VARCHAR2,
258 x_is_org_in_user_ou OUT NOCOPY VARCHAR2
259 );
260
261 -- Start of Comments --
262 --
263 -- Procedure name : Get_Succ_Event_Info
264 -- Type : Private
265 -- Function : API to retrieve the succeeding visit or flight schedule, for a particular unit
266 -- configuration for a given end time. If there are more than one flight schedule
267 -- or visit ending at the same time then a conflict is shown.
268 -- Pre-reqs :
269 --
270 -- Standard IN Parameters :
271 -- p_api_version IN NUMBER Required
272 --
273 -- Standard OUT Parameters :
274 -- x_return_status OUT VARCHAR2 Required
275 -- x_msg_count OUT NUMBER Required
276 -- x_msg_data OUT VARCHAR2 Required
277 --
278 -- Get_Prec_Event_Info Parameters :
279 -- p_unit_config_id IN NUMBER,
280 -- p_end_date_time IN DATE,
281 -- p_use_actuals IN VARCHAR2,
282 -- x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
283 -- x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
284 -- x_is_conflict OUT NOCOPY VARCHAR2
285 --
286 -- Version :
287 -- Initial Version 1.0
288 --
289 -- End of Comments --
290
291 PROCEDURE Get_Succ_Event_Info
292 (
293 p_api_version IN NUMBER,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_unit_config_id IN NUMBER,
298 p_end_date_time IN DATE,
299 p_use_actuals IN VARCHAR2,
300 x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
301 x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
302 x_is_conflict OUT NOCOPY VARCHAR2,
303 x_is_org_in_user_ou OUT NOCOPY VARCHAR2
304 );
305
306 End AHL_UA_COMMON_PVT;