[Home] [Help]
PACKAGE: APPS.AHL_UA_FLIGHT_SCHEDULES_PVT
Source
1 PACKAGE AHL_UA_FLIGHT_SCHEDULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVUFSS.pls 120.0.12020000.2 2012/12/07 16:05:59 sareepar ship $ */
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 -- MANESING::Auto Visit Forecasting, 17-Oct-2011
35 -- added variables for flight category and spaces
36 FLIGHT_CATEGORY_CODE VARCHAR2(30),
37 FLIGHT_CATEGORY_MEANING VARCHAR2(80),
38 DEPARTURE_SPACE_ID NUMBER,
39 DEPARTURE_SPACE_NAME VARCHAR2(80),
40 ARRIVAL_SPACE_ID NUMBER,
41 ARRIVAL_SPACE_NAME VARCHAR2(80),
42 ATTRIBUTE_CATEGORY VARCHAR2(30),
43 ATTRIBUTE1 VARCHAR2(150),
44 ATTRIBUTE2 VARCHAR2(150),
45 ATTRIBUTE3 VARCHAR2(150),
46 ATTRIBUTE4 VARCHAR2(150),
47 ATTRIBUTE5 VARCHAR2(150),
48 ATTRIBUTE6 VARCHAR2(150),
49 ATTRIBUTE7 VARCHAR2(150),
50 ATTRIBUTE8 VARCHAR2(150),
51 ATTRIBUTE9 VARCHAR2(150),
52 ATTRIBUTE10 VARCHAR2(150),
53 ATTRIBUTE11 VARCHAR2(150),
54 ATTRIBUTE12 VARCHAR2(150),
55 ATTRIBUTE13 VARCHAR2(150),
56 ATTRIBUTE14 VARCHAR2(150),
57 ATTRIBUTE15 VARCHAR2(150),
58 DML_OPERATION VARCHAR2(1)
59 );
60
61 -- Table of flight schedule recs
62 TYPE FLIGHT_SCHEDULES_TBL_TYPE IS TABLE OF FLIGHT_SCHEDULE_REC_TYPE INDEX BY BINARY_INTEGER;
63
64 ------------------------------------------------------------------------------------------------
65 -- Procedure to process(Create/Update/Delete) Flight schedule records
66 ------------------------------------------------------------------------------------------------
67 -- Start of Comments
68 -- Procedure name : Process_Flight_Schedules
69 -- Type : Private
70 -- Pre-reqs :
71 -- Function :
72 -- Parameters :
73 --
74 -- Standard IN Parameters :
75 -- p_api_version NUMBER Required
76 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
77 -- p_commit VARCHAR2 Default FND_API.G_FALSE
78 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
79 -- p_default VARCHAR2 Default FND_API.G_TRUE
80 -- p_module_type VARCHAR2 Default NULL
81 --
82 -- Standard OUT Parameters :
83 -- x_return_status VARCHAR2 Required
84 -- x_msg_count NUMBER Required
85 -- x_msg_data VARCHAR2 Required
86 --
87 -- Process_Flight_Schedules IN parameters:
88 -- None
89 --
90 -- Process_Flight_Schedules IN OUT parameters:
91 -- p_x_flight_schedules_tbl FLIGHT_SCHEDULES_TBL_TYPE Required
92 --
93 -- Process_Flight_Schedules OUT parameters:
94 -- None.
95 --
96 -- Version :
97 -- Current version 1.0
98 --
99 -- End of Comments
100 PROCEDURE Process_Flight_Schedules(
101 p_api_version IN NUMBER :=1.0,
102 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
103 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
104 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
105 p_default IN VARCHAR2 :=FND_API.G_FALSE,
106 p_module_type IN VARCHAR2 :=NULL,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_x_flight_schedules_tbl IN OUT NOCOPY FLIGHT_SCHEDULES_TBL_TYPE
111 );
112
113 ------------------------------------------------------------------------------------------------
114 -- Procedure to validate a Flight Schedule
115 ------------------------------------------------------------------------------------------------
116 -- Start of Comments
117 -- Procedure name : Validate_Flight_Schedule
118 -- Type : Private
119 -- Pre-reqs :
120 -- Function :
121 -- Parameters :
122 --
123 -- Standard IN Parameters :
124 -- p_api_version NUMBER Required
125 --
126 -- Standard OUT Parameters :
127 -- x_return_status VARCHAR2 Required
128 -- x_msg_count NUMBER Required
129 -- x_msg_data VARCHAR2 Required
130 --
131 -- Validate_Flight_Schedule IN parameters:
132 -- p_unit_config_id NUMBER Required
133 -- p_unit_schedule_id NUMBER Required
134 --
135 -- Validate_Flight_Schedule IN OUT parameters:
136 -- None
137 --
138 -- Validate_Flight_Schedule OUT parameters:
139 -- None.
140 --
141 -- Version :
142 -- Current version 1.0
143 --
144 -- End of Comments
145
146 PROCEDURE Validate_Flight_Schedule(
147 p_api_version IN NUMBER :=1.0,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_unit_config_id IN NUMBER,
152 p_unit_schedule_id IN NUMBER
153 );
154
155
156 ------------------------------------------------------------------------------------------------
157 -- Function to check if delete is allowed for a Flight schedule record
158 ------------------------------------------------------------------------------------------------
159 -- Start of Comments
160 -- Function name : is_delete_allowed
161 -- Type : Private
162 -- Pre-reqs :
163 -- Function :
164 -- Return Value : VARCHAR2
165 -- Parameters :
166 --
167 -- Standard IN Parameters :
168 -- None
169 --
170 -- Standard OUT Parameters :
171 -- None
172 --
173 -- is_delete_allowed IN parameters:
174 -- p_unit_schedule_id NUMBER Required
175 -- p_is_super_user VARCHAR2 Required
176 --
177 -- is_delete_allowed IN OUT parameters:
178 -- None
179 --
180 -- is_delete_allowed OUT parameters:
181 -- None.
182 --
183 -- Version :
184 -- Current version 1.0
185 --
186 -- End of Comments
187
188 FUNCTION is_delete_allowed
189 (
190 p_unit_schedule_id IN NUMBER,
191 p_is_super_user IN VARCHAR2
192 )
193 RETURN VARCHAR2;
194
195 ------------------------------------------------------------------------------------------------
196 -- Function to check if update is allowed for a Flight schedule record
197 ------------------------------------------------------------------------------------------------
198 -- Start of Comments
199 -- Function name : is_update_allowed
200 -- Type : Private
201 -- Pre-reqs :
202 -- Function :
203 -- Return Value : VARCHAR2
204 -- Parameters :
205 --
206 -- Standard IN Parameters :
207 -- None
208 --
209 -- Standard OUT Parameters :
210 -- None
211 --
212 -- is_update_allowed IN parameters:
213 -- p_unit_schedule_id NUMBER Required
214 -- p_is_super_user VARCHAR2 Required
215 --
216 -- is_update_allowed IN OUT parameters:
217 -- None
218 --
219 -- is_update_allowed OUT parameters:
220 -- None.
221 --
222 -- Version :
223 -- Current version 1.0
224 --
225 -- End of Comments
226
227 FUNCTION is_update_allowed
228 (
229 p_unit_schedule_id IN NUMBER,
230 p_is_super_user IN VARCHAR2
231 )
232 RETURN VARCHAR2;
233
234 ------------------------------------------------------------------------------------------------
235 -- Function to check if the current user is super user or not
236 ------------------------------------------------------------------------------------------------
237 -- Start of Comments
238 -- Function name : is_super_user
239 -- Type : Private
240 -- Pre-reqs :
241 -- Function :
242 -- Return Value : VARCHAR2
243 -- Parameters :
244 --
245 -- Standard IN Parameters :
246 -- None
247 --
248 -- Standard OUT Parameters :
249 -- None
250 --
251 -- is_super_user IN parameters:
252 -- None
253 --
254 -- is_super_user IN OUT parameters:
255 -- None
256 --
257 -- is_super_user OUT parameters:
258 -- None.
259 --
260 -- Version :
261 -- Current version 1.0
262 --
263 -- End of Comments
264 FUNCTION is_super_user
265
266 RETURN VARCHAR2;
267
268 END AHL_UA_FLIGHT_SCHEDULES_PVT;
269