1 PACKAGE AHL_UA_FLIGHT_SCHEDULES_PUB AS
2 /* $Header: AHLPUFSS.pls 120.2 2005/09/14 02:11:12 tamdas noship $ */
3 /*#
4 * Package containing APIs to process flight schedules and following transit visits. It allows users to create, update
5 * and delete flight schedules for active units. It also allows users to create a transit visit following a flight schedule.
6 * @rep:scope public
7 * @rep:product AHL
8 * @rep:displayname Unit Flight Schedules
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY AHL_UNIT_SCHEDULES
11 */
12
13 -- Flag to indicate that search criteria dates must be applied only to the flight arrival dates
14 G_APPLY_TO_ARRIVAL CONSTANT VARCHAR2(1) := 'A';
15
16 -- Flag to indicate that search criteria dates must be applied only to the flight departure dates
17 G_APPLY_TO_DEPARTURE CONSTANT VARCHAR2(1) := 'D';
18
19 TYPE FLIGHT_SEARCH_REC_TYPE IS RECORD
20 (
21 UNIT_SCHEDULE_ID NUMBER,
22 UNIT_NAME VARCHAR2(30),
23 FLIGHT_NUMBER VARCHAR2(80),
24 ITEM_NUMBER VARCHAR2(40),
25 SERIAL_NUMBER VARCHAR2(30),
26 ARRIVAL_ORG_CODE VARCHAR2(3),
27 ARRIVAL_DEPT_CODE VARCHAR2(10),
28 DEPARTURE_ORG_CODE VARCHAR2(3),
29 DEPARTURE_DEPT_CODE VARCHAR2(10),
30 START_DATE DATE,
31 END_DATE DATE,
32 DATE_APPLY_TO_FLAG VARCHAR2(1)
33 );
34
35 TYPE FLIGHT_VISIT_SCH_REC_TYPE IS RECORD
36 (
37 UNIT_SCHEDULE_ID NUMBER,
38 FLIGHT_NUMBER VARCHAR2(30),
39 SEGMENT VARCHAR2(30),
40 EST_DEPARTURE_TIME DATE,
41 ACTUAL_DEPARTURE_TIME DATE,
42 DEPARTURE_DEPT_ID NUMBER,
43 DEPARTURE_DEPT_CODE VARCHAR2(10),
44 DEPARTURE_ORG_ID NUMBER,
45 DEPARTURE_ORG_CODE VARCHAR2(3),
46 EST_ARRIVAL_TIME DATE,
47 ACTUAL_ARRIVAL_TIME DATE,
48 ARRIVAL_DEPT_ID NUMBER,
49 ARRIVAL_DEPT_CODE VARCHAR2(10),
50 ARRIVAL_ORG_ID NUMBER,
51 ARRIVAL_ORG_CODE VARCHAR2(3),
52 PRECEDING_US_ID NUMBER,
53 UNIT_CONFIG_HEADER_ID NUMBER,
54 UNIT_CONFIG_NAME VARCHAR2(80),
55 CSI_INSTANCE_ID NUMBER,
56 INSTANCE_NUMBER VARCHAR2(30),
57 ITEM_NUMBER VARCHAR2(40),
58 SERIAL_NUMBER VARCHAR2(30),
59 VISIT_RESCHEDULE_MODE VARCHAR2(30),
60 VISIT_RESCHEDULE_MEANING VARCHAR2(80),
61 OBJECT_VERSION_NUMBER NUMBER,
62 IS_UPDATE_ALLOWED VARCHAR2(1),
63 IS_DELETE_ALLOWED VARCHAR2(1),
64 VISIT_ID NUMBER,
65 VISIT_TYPE_CODE VARCHAR2(30),
66 VISIT_TYPE_MEANING VARCHAR2(80),
67 VISIT_CREATE_TYPE VARCHAR2(30),
68 VISIT_CREATE_MEANING VARCHAR2(80),
69 ATTRIBUTE_CATEGORY VARCHAR2(30),
70 ATTRIBUTE1 VARCHAR2(150),
71 ATTRIBUTE2 VARCHAR2(150),
72 ATTRIBUTE3 VARCHAR2(150),
73 ATTRIBUTE4 VARCHAR2(150),
74 ATTRIBUTE5 VARCHAR2(150),
75 ATTRIBUTE6 VARCHAR2(150),
76 ATTRIBUTE7 VARCHAR2(150),
77 ATTRIBUTE8 VARCHAR2(150),
78 ATTRIBUTE9 VARCHAR2(150),
79 ATTRIBUTE10 VARCHAR2(150),
80 ATTRIBUTE11 VARCHAR2(150),
81 ATTRIBUTE12 VARCHAR2(150),
82 ATTRIBUTE13 VARCHAR2(150),
83 ATTRIBUTE14 VARCHAR2(150),
84 ATTRIBUTE15 VARCHAR2(150),
85 DML_OPERATION VARCHAR2(1)
86 );
87
88 -- Table of flight schedule recs
89 TYPE FLIGHT_VISIT_SCH_TBL_TYPE IS TABLE OF FLIGHT_VISIT_SCH_REC_TYPE INDEX BY BINARY_INTEGER;
90
91 -----------------------
92 -- Define procedures --
93 -----------------------
94 -- Start of Comments --
95 --
96 -- Procedure name : Get_Flight_Schedule_Details
97 -- Type : Private
98 -- Function : API to retrieve flight schedule details for the given search criteria.
99 -- Pre-reqs :
100 --
101 -- Standard IN Parameters :
102 -- p_api_version IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
104 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
105 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
106 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
107 -- p_module_type IN VARCHAR2 Required, default NULL
108
109 -- Standard OUT Parameters :
110 -- x_return_status OUT VARCHAR2 Required
111 -- x_msg_count OUT NUMBER Required
112 -- x_msg_data OUT VARCHAR2 Required
113 --
114 -- Procedure Parameters :
115 -- p_flight_search_rec IN FLIGHT_SEARCH_REC Required
116 -- x_flight_schedule_tbl OUT AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
117 --
118 -- Version :
119 -- Initial Version 1.0
120 --
121 -- End of Comments --
122 /*#
123 * Use this procedure to retrieve flight schedule details for the given search criteria.
124 * @param p_api_version API Version Number.
125 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
126 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
127 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
128 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
129 * @param p_module_type For Internal use only, should always be NULL, default value NULL
130 * @param x_return_status API Return status. Standard API parameter
131 * @param x_msg_count API Return message count, if any. Standard API parameter
132 * @param x_msg_data API Return message data, if any. Standard API parameter
133 * @param p_flight_search_rec Search criteria record of type FLIGHT_SEARCH_REC_TYPE
134 * @param x_flight_schedules_tbl Flight schedules details table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
135 * @rep:scope private
136 * @rep:lifecycle active
137 * @rep:displayname Get Flight Schedule Details
138 */
139 PROCEDURE Get_Flight_Schedule_Details
140 (
141 -- standard IN params
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
144 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
145 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
146 p_default IN VARCHAR2 :=FND_API.G_FALSE,
147 p_module_type IN VARCHAR2 :=NULL,
148 -- standard OUT params
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 -- procedure params
153 p_flight_search_rec IN FLIGHT_SEARCH_REC_TYPE,
154 x_flight_schedules_tbl OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
155 );
156
157 -- Start of Comments --
158 --
159 -- Procedure name : Process_Flight_Schedules
160 -- Type : Private
161 -- Function : API to retrieve flight schedule details for the given search criteria.
162 -- Pre-reqs :
163 --
164 -- Standard IN Parameters :
165 -- p_api_version IN NUMBER Required
166 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
167 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
168 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
169 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
170 -- p_module_type IN VARCHAR2 Required, default NULL
171
172 -- Standard OUT Parameters :
173 -- x_return_status OUT VARCHAR2 Required
174 -- x_msg_count OUT NUMBER Required
175 -- x_msg_data OUT VARCHAR2 Required
176 --
177 -- Procedure Parameters :
178 -- p_x_flight_schedules_tbl IN OUT AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE Required
179 --
180 -- Version :
181 -- Initial Version 1.0
182 --
183 -- End of Comments --
184 /*#
185 * Use this procedure to create, update and delete flight schedules.
186 * @param p_api_version API Version Number.
187 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
188 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
189 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
190 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
191 * @param p_module_type For Internal use only, should always be NULL, default value NULL
192 * @param x_return_status API Return status. Standard API parameter
193 * @param x_msg_count API Return message count, if any. Standard API parameter
194 * @param x_msg_data API Return message data, if any. Standard API parameter
195 * @param p_x_flight_schedules_tbl Flight schedules table of type AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
196 * @rep:scope public
197 * @rep:lifecycle active
198 * @rep:displayname Process Flight Schedules
199 */
200 PROCEDURE Process_Flight_Schedules
201 (
202 -- standard IN params
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
205 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
206 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
207 p_default IN VARCHAR2 :=FND_API.G_FALSE,
208 p_module_type IN VARCHAR2 :=NULL,
209 -- standard OUT params
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 -- procedure params
214 p_x_flight_schedules_tbl IN OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE
215 );
216
217 -- Start of Comments --
218 --
219 -- Procedure name : Process_Flight_Schedules
220 -- Type : Private
221 -- Function : API to retrieve flight schedule details for the given search criteria.
222 -- Pre-reqs :
223 --
224 -- Standard IN Parameters :
225 -- p_api_version IN NUMBER Required
226 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
227 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
228 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
229 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
230 -- p_module_type IN VARCHAR2 Required, default NULL
231
232 -- Standard OUT Parameters :
233 -- x_return_status OUT VARCHAR2 Required
234 -- x_msg_count OUT NUMBER Required
235 -- x_msg_data OUT VARCHAR2 Required
236 --
237 -- Procedure Parameters :
238 -- p_x_flight_visit_sch_tbl IN OUT FLIGHT_VISIT_SCH_TBL_TYPE Required
239 --
240 -- Version :
241 -- Initial Version 1.0
242 --
243 -- End of Comments --
244 /*#
245 * Use this procedure to create flight schedules with following transit visits, using parameters from the created flight schedules. It can also be used to update and delete flight schedules.
246 * @param p_api_version API Version Number.
247 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
248 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
249 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
250 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
251 * @param p_module_type For Internal use only, should always be NULL, default value NULL
252 * @param x_return_status API Return status. Standard API parameter
253 * @param x_msg_count API Return message count, if any. Standard API parameter
254 * @param x_msg_data API Return message data, if any. Standard API parameter
255 * @param p_x_flight_visit_sch_tbl Flight and Visit schedules table of type FLIGHT_VISIT_SCH_TBL_TYPE
256 * @rep:scope public
257 * @rep:lifecycle active
258 * @rep:displayname Process Flight and Visit Schedules
259 */
260 PROCEDURE Process_FlightVisit_Sch
261 (
262 -- standard IN params
263 p_api_version IN NUMBER,
264 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
265 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
266 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
267 p_default IN VARCHAR2 :=FND_API.G_FALSE,
268 p_module_type IN VARCHAR2 :=NULL,
269 -- standard OUT params
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 -- procedure params
274 p_x_flight_visit_sch_tbl IN OUT NOCOPY FLIGHT_VISIT_SCH_TBL_TYPE
275 );
276
277 END AHL_UA_FLIGHT_SCHEDULES_PUB;
278