[Home] [Help]
PACKAGE: APPS.AHL_UA_FLIGHT_SCHEDULES_PVT
Source
1 PACKAGE AHL_UA_FLIGHT_SCHEDULES_PVT AS
2 /* $Header: AHLVUFSS.pls 120.0 2005/05/26 01:22:15 appldev noship $ */
3
4 TYPE FLIGHT_SCHEDULE_REC_TYPE IS RECORD
5 (
6 UNIT_SCHEDULE_ID NUMBER,
7 FLIGHT_NUMBER VARCHAR2(30),
8 SEGMENT VARCHAR2(30),
9 EST_DEPARTURE_TIME DATE,
10 ACTUAL_DEPARTURE_TIME DATE,
11 DEPARTURE_DEPT_ID NUMBER,
12 DEPARTURE_DEPT_CODE VARCHAR2(10),
13 DEPARTURE_ORG_ID NUMBER,
14 DEPARTURE_ORG_CODE VARCHAR2(3),
15 EST_ARRIVAL_TIME DATE,
16 ACTUAL_ARRIVAL_TIME DATE,
17 ARRIVAL_DEPT_ID NUMBER,
18 ARRIVAL_DEPT_CODE VARCHAR2(10),
19 ARRIVAL_ORG_ID NUMBER,
20 ARRIVAL_ORG_CODE VARCHAR2(3),
21 PRECEDING_US_ID NUMBER,
22 UNIT_CONFIG_HEADER_ID NUMBER,
23 UNIT_CONFIG_NAME VARCHAR2(80),
24 CSI_INSTANCE_ID NUMBER,
25 INSTANCE_NUMBER VARCHAR2(30),
26 ITEM_NUMBER VARCHAR2(40),
27 SERIAL_NUMBER VARCHAR2(30),
28 VISIT_RESCHEDULE_MODE VARCHAR2(30), -- Visit synchronization rule.
29 VISIT_RESCHEDULE_MEANING VARCHAR2(80),
30 OBJECT_VERSION_NUMBER NUMBER,
31 IS_UPDATE_ALLOWED VARCHAR2(1), -- flag to indicate if update is allowed
32 IS_DELETE_ALLOWED VARCHAR2(1), -- flag to indicate if update is allowed
33 CONFLICT_MESSAGE VARCHAR2(2000),
34 ATTRIBUTE_CATEGORY VARCHAR2(30),
35 ATTRIBUTE1 VARCHAR2(150),
36 ATTRIBUTE2 VARCHAR2(150),
37 ATTRIBUTE3 VARCHAR2(150),
38 ATTRIBUTE4 VARCHAR2(150),
39 ATTRIBUTE5 VARCHAR2(150),
40 ATTRIBUTE6 VARCHAR2(150),
41 ATTRIBUTE7 VARCHAR2(150),
42 ATTRIBUTE8 VARCHAR2(150),
43 ATTRIBUTE9 VARCHAR2(150),
44 ATTRIBUTE10 VARCHAR2(150),
45 ATTRIBUTE11 VARCHAR2(150),
46 ATTRIBUTE12 VARCHAR2(150),
47 ATTRIBUTE13 VARCHAR2(150),
48 ATTRIBUTE14 VARCHAR2(150),
49 ATTRIBUTE15 VARCHAR2(150),
50 DML_OPERATION VARCHAR2(1)
51 );
52
53 -- Table of flight schedule recs
54 TYPE FLIGHT_SCHEDULES_TBL_TYPE IS TABLE OF FLIGHT_SCHEDULE_REC_TYPE INDEX BY BINARY_INTEGER;
55
56 ------------------------------------------------------------------------------------------------
57 -- Procedure to process(Create/Update/Delete) Flight schedule records
58 ------------------------------------------------------------------------------------------------
59 -- Start of Comments
60 -- Procedure name : Process_Flight_Schedules
61 -- Type : Private
62 -- Pre-reqs :
63 -- Function :
64 -- Parameters :
65 --
66 -- Standard IN Parameters :
67 -- p_api_version NUMBER Required
68 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
69 -- p_commit VARCHAR2 Default FND_API.G_FALSE
70 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
71 -- p_default VARCHAR2 Default FND_API.G_TRUE
72 -- p_module_type VARCHAR2 Default NULL
73 --
74 -- Standard OUT Parameters :
75 -- x_return_status VARCHAR2 Required
76 -- x_msg_count NUMBER Required
77 -- x_msg_data VARCHAR2 Required
78 --
79 -- Process_Flight_Schedules IN parameters:
80 -- None
81 --
82 -- Process_Flight_Schedules IN OUT parameters:
83 -- p_x_flight_schedules_tbl FLIGHT_SCHEDULES_TBL_TYPE Required
84 --
85 -- Process_Flight_Schedules OUT parameters:
86 -- None.
87 --
88 -- Version :
89 -- Current version 1.0
90 --
91 -- End of Comments
92 PROCEDURE Process_Flight_Schedules(
93 p_api_version IN NUMBER :=1.0,
94 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
95 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
96 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
97 p_default IN VARCHAR2 :=FND_API.G_FALSE,
98 p_module_type IN VARCHAR2 :=NULL,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_x_flight_schedules_tbl IN OUT NOCOPY FLIGHT_SCHEDULES_TBL_TYPE
103 );
104
105 ------------------------------------------------------------------------------------------------
106 -- Procedure to validate a Flight Schedule
107 ------------------------------------------------------------------------------------------------
108 -- Start of Comments
109 -- Procedure name : Validate_Flight_Schedule
110 -- Type : Private
111 -- Pre-reqs :
112 -- Function :
113 -- Parameters :
114 --
115 -- Standard IN Parameters :
116 -- p_api_version NUMBER Required
117 --
118 -- Standard OUT Parameters :
119 -- x_return_status VARCHAR2 Required
120 -- x_msg_count NUMBER Required
121 -- x_msg_data VARCHAR2 Required
122 --
123 -- Validate_Flight_Schedule IN parameters:
124 -- p_unit_config_id NUMBER Required
125 -- p_unit_schedule_id NUMBER Required
126 --
127 -- Validate_Flight_Schedule IN OUT parameters:
128 -- None
129 --
130 -- Validate_Flight_Schedule OUT parameters:
131 -- None.
132 --
133 -- Version :
134 -- Current version 1.0
135 --
136 -- End of Comments
137
138 PROCEDURE Validate_Flight_Schedule(
139 p_api_version IN NUMBER :=1.0,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_unit_config_id IN NUMBER,
144 p_unit_schedule_id IN NUMBER
145 );
146
147
148 ------------------------------------------------------------------------------------------------
149 -- Function to check if delete is allowed for a Flight schedule record
150 ------------------------------------------------------------------------------------------------
151 -- Start of Comments
152 -- Function name : is_delete_allowed
153 -- Type : Private
154 -- Pre-reqs :
155 -- Function :
156 -- Return Value : VARCHAR2
157 -- Parameters :
158 --
159 -- Standard IN Parameters :
160 -- None
161 --
162 -- Standard OUT Parameters :
163 -- None
164 --
165 -- is_delete_allowed IN parameters:
166 -- p_unit_schedule_id NUMBER Required
167 -- p_is_super_user VARCHAR2 Required
168 --
169 -- is_delete_allowed IN OUT parameters:
170 -- None
171 --
172 -- is_delete_allowed OUT parameters:
173 -- None.
174 --
175 -- Version :
176 -- Current version 1.0
177 --
178 -- End of Comments
179
180 FUNCTION is_delete_allowed
181 (
182 p_unit_schedule_id IN NUMBER,
183 p_is_super_user IN VARCHAR2
184 )
185 RETURN VARCHAR2;
186
187 ------------------------------------------------------------------------------------------------
188 -- Function to check if update is allowed for a Flight schedule record
189 ------------------------------------------------------------------------------------------------
190 -- Start of Comments
191 -- Function name : is_update_allowed
192 -- Type : Private
193 -- Pre-reqs :
194 -- Function :
195 -- Return Value : VARCHAR2
196 -- Parameters :
197 --
198 -- Standard IN Parameters :
199 -- None
200 --
201 -- Standard OUT Parameters :
202 -- None
203 --
204 -- is_update_allowed IN parameters:
205 -- p_unit_schedule_id NUMBER Required
206 -- p_is_super_user VARCHAR2 Required
207 --
208 -- is_update_allowed IN OUT parameters:
209 -- None
210 --
211 -- is_update_allowed OUT parameters:
212 -- None.
213 --
214 -- Version :
215 -- Current version 1.0
216 --
217 -- End of Comments
218
219 FUNCTION is_update_allowed
220 (
221 p_unit_schedule_id IN NUMBER,
222 p_is_super_user IN VARCHAR2
223 )
224 RETURN VARCHAR2;
225
226 ------------------------------------------------------------------------------------------------
227 -- Function to check if the current user is super user or not
228 ------------------------------------------------------------------------------------------------
229 -- Start of Comments
230 -- Function name : is_super_user
231 -- Type : Private
232 -- Pre-reqs :
233 -- Function :
234 -- Return Value : VARCHAR2
235 -- Parameters :
236 --
237 -- Standard IN Parameters :
238 -- None
239 --
240 -- Standard OUT Parameters :
241 -- None
242 --
243 -- is_super_user IN parameters:
244 -- None
245 --
246 -- is_super_user IN OUT parameters:
247 -- None
248 --
249 -- is_super_user OUT parameters:
250 -- None.
251 --
252 -- Version :
253 -- Current version 1.0
254 --
255 -- End of Comments
256 FUNCTION is_super_user
257
258 RETURN VARCHAR2;
259
260 END AHL_UA_FLIGHT_SCHEDULES_PVT;
261