[Home] [Help]
PACKAGE: APPS.AHL_UA_UNIT_SCHEDULES_PVT
Source
1 PACKAGE AHL_UA_UNIT_SCHEDULES_PVT AS
2 /* $Header: AHLVUUSS.pls 120.0 2005/05/26 01:05:03 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UA_UNIT_SCHEDULES_PVT';
5
6 -------------------------------
7 -- Define records and tables --
8 -------------------------------
9 TYPE Unit_Schedules_Search_Rec_Type IS RECORD
10 (
11 UNIT_NAME VARCHAR2(30),
12 ITEM_NUMBER VARCHAR2(40),
13 SERIAL_NUMBER VARCHAR2(30),
14 START_DATE_TIME DATE,
15 TIME_INCREMENT NUMBER,
16 TIME_UOM VARCHAR2(30)
17 );
18
19 TYPE Unit_Schedules_Result_Rec_Type IS RECORD
20 (
21 RESULT_ROW_NUM NUMBER,
22 RESULT_COL_NUM NUMBER,
23 UNIT_CONFIG_HEADER_ID NUMBER,
24 UNIT_NAME VARCHAR2(80),
25 SCHEDULE_ID NUMBER,
26 SCHEDULE_TYPE VARCHAR2(2)
27 );
28
29 TYPE Unit_Schedules_Result_Tbl_Type IS TABLE OF Unit_Schedules_Result_Rec_Type INDEX BY BINARY_INTEGER;
30
31 TYPE MEvent_Header_Rec_Type IS RECORD
32 (
33 UNIT_CONFIG_HEADER_ID NUMBER,
34 UNIT_NAME VARCHAR2(30),
35 START_TIME DATE,
36 END_TIME DATE,
37 ITEM_NUMBER VARCHAR2(30),
38 SERIAL_NUMBER VARCHAR2(240),
39 EVENT_COUNT NUMBER,
40 HAS_CONFLICT VARCHAR2(1),
41 HAS_MOPPORTUNITY VARCHAR2(1)
42 );
43
44 TYPE Unit_Schedule_Rec_type IS RECORD
45 (
46 EVENT_SEQ NUMBER,
47 UNIT_SCHEDULE_ID NUMBER,
48 FLIGHT_NUMBER VARCHAR2(30),
49 SEGMENT VARCHAR2(30),
50 DEPARTURE_ORG_ID NUMBER,
51 DEPARTURE_ORG_NAME VARCHAR2(240),
52 DEPARTURE_DEP_ID NUMBER,
53 DEPARTURE_DEP_NAME VARCHAR2(240),
54 ARRIVAL_ORG_ID NUMBER,
55 ARRIVAL_ORG_NAME VARCHAR2(240),
56 ARRIVAL_DEP_ID NUMBER,
57 ARRIVAL_DEP_NAME VARCHAR2(240),
58 DEPARTURE_TIME DATE,
59 ARRIVAL_TIME DATE,
60 PREV_EVENT_TYPE VARCHAR2(12),
61 PREV_EVENT_ID NUMBER,
62 PREV_EVENT_ORG_ID NUMBER,
63 IS_PREV_ORG_VALID VARCHAR2(1),
64 PREV_EVENT_ORG_NAME VARCHAR2(240),
65 PREV_EVENT_DEP_ID NUMBER,
66 PRVE_EVENT_DEP_NAME VARCHAR2(240),
67 PREV_EVENT_END_TIME DATE,
68 PREV_UNIT_SCHEDULE_ID NUMBER,
69 PREV_FLIGHT_NUMBER VARCHAR2(30),
70 HAS_MOPPORTUNITY VARCHAR2(1),
71 HAS_CONFLICT VARCHAR2(1),
72 CONFLICT_MESSAGE VARCHAR2(2000),
73 IS_ORG_VALID VARCHAR2(1)
74 );
75
76 TYPE Unit_Schedule_Tbl_Type IS TABLE OF Unit_Schedule_Rec_type INDEX BY BINARY_INTEGER;
77
78 TYPE Visit_Schedule_Rec_Type IS RECORD
79 (
80 EVENT_SEQ NUMBER,
81 VISIT_ID NUMBER,
82 VISIT_NUMBER VARCHAR2(30),
83 VISIT_TYPE VARCHAR2(30),
84 VISIT_NAME VARCHAR2(80),
85 VISIT_STATUS_CODE VARCHAR2(30),
86 VISIT_STATUS VARCHAR2(80),
87 VISIT_ORG_ID NUMBER,
88 VISIT_ORG_NAME VARCHAR2(240),
89 VISIT_DEP_ID NUMBER,
90 VISIT_DEP_NAME VARCHAR2(240),
91 START_TIME DATE,
92 END_TIME DATE,
93 PREV_EVENT_TYPE VARCHAR2(12),
94 PREV_EVENT_ID NUMBER,
95 PREV_EVENT_ORG_ID NUMBER,
96 IS_PREV_ORG_VALID VARCHAR2(1),
97 PREV_EVENT_ORG_NAME VARCHAR2(240),
98 PREV_EVENT_DEP_ID NUMBER,
99 PRVE_EVENT_DEP_NAME VARCHAR2(240),
100 PREV_EVENT_END_TIME DATE,
101 PREV_UNIT_SCHEDULE_ID NUMBER,
102 PREV_FLIGHT_NUMBER VARCHAR2(30),
103 HAS_MOPPORTUNITY VARCHAR2(1),
104 HAS_CONFLICT VARCHAR2(1),
105 CONFLICT_MESSAGE VARCHAR2(2000),
106 CAN_CANCEL VARCHAR2(1),
107 IS_ORG_VALID VARCHAR2(1)
108 );
109
110 TYPE Visit_Schedule_Tbl_Type IS TABLE OF Visit_Schedule_Rec_type INDEX BY BINARY_INTEGER;
111
112 -----------------------
113 -- Define procedures --
114 -----------------------
115 -- Start of Comments --
116 --
117 -- Procedure name : Search_Unit_Schedules
118 -- Type : Private
119 -- Function : API to perform search on unit schedules and store detailed and return
120 -- summary search results. Search results are stored in global temporary
121 -- table AHL_SRCH_UNIT_SCHEDULES that can be queried later to retrieve other
122 -- relevant details.
123 -- Pre-reqs :
124 --
125 -- Standard IN Parameters :
126 -- p_api_version IN NUMBER Required
127 --
128 -- Standard OUT Parameters :
129 -- x_return_status OUT VARCHAR2 Required
130 -- x_msg_count OUT NUMBER Required
131 -- x_msg_data OUT VARCHAR2 Required
132 --
133 -- Search_Unit_Schedules Parameters :
134 -- p_unit_schedules_search IN Unit_Schedules_Search_Rec_Type Required
135 -- x_unit_schedules_results OUT Unit_Schedules_Result_Tbl_Type
136 --
137 -- Version :
138 -- Initial Version 1.0
139 --
140 -- End of Comments --
141 PROCEDURE Search_Unit_Schedules
142 (
143 p_api_version IN NUMBER,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_unit_schedules_search IN Unit_Schedules_Search_Rec_Type,
148 x_unit_schedules_results OUT NOCOPY Unit_Schedules_Result_Tbl_Type
149 );
150
151 -- Start of Comments --
152 --
153 -- Procedure name : Get_MEvent_Details
154 -- Type : Private
155 -- Function : API to get context information, list of visits, list of flights,
156 -- conflict and Maintenance Oppurtunity information, conflict messages
157 -- Pre-reqs :
158 --
159 -- Standard IN Parameters :
160 -- p_api_version IN NUMBER Required
161 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
162 -- p_module_type IN VARCHAR2
163 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165 --
166 -- Standard OUT Parameters :
167 -- x_return_status OUT VARCHAR2 Required
168 -- x_msg_count OUT NUMBER Required
169 -- x_msg_data OUT VARCHAR2 Required
170 --
171 -- Get_MEvent_Details Parameters :
172 -- p_x_ MEvent_header_rec IN OUT MEvent_Rec_Type Required
173 -- x_Unit_Schedule_tbl OUT Unit_Schedules_Tbl_Type
174 -- x_Visit_Schedule_tbl OUT Visit_Schedules_Tbl_Type
175 --
176 -- Version :
177 -- Initial Version 1.0
178 --
179 -- End of Comments --
180 PROCEDURE Get_MEvent_Details
181 (
182 p_api_version IN NUMBER,
183 p_module_type IN VARCHAR2,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_x_MEvent_Header_Rec IN OUT NOCOPY MEvent_Header_Rec_Type,
188 x_Unit_Schedule_tbl OUT NOCOPY Unit_Schedule_Tbl_Type,
189 x_Visit_Schedule_tbl OUT NOCOPY Visit_Schedule_Tbl_Type
190 );
191
192 -- Start of Comments --
193 --
194 -- Procedure name : Get_Prec_Succ_Event_Info
195 -- Type : Private
196 -- Function : API to retrieve previous and next event (flight / visit) information, for a
197 -- particular unit configuration for a time period from start time to end time
198 -- Pre-reqs :
199 --
200 -- Standard IN Parameters :
201 -- p_api_version IN NUMBER Required
202 --
203 -- Standard OUT Parameters :
204 -- x_return_status OUT VARCHAR2 Required
205 -- x_msg_count OUT NUMBER Required
206 -- x_msg_data OUT VARCHAR2 Required
207 --
208 -- Get_MEvent_Details Parameters :
209 -- p_unit_config_id IN NUMBER Required
210 -- p_start_date_time IN DATE Required
211 -- p_end_date_time IN DATE Required
212 -- p_use_actuals IN VARCHAR2
213 -- x_prec_visit OUT AHL_VWP_VISITS_PVT.Visit_Rec_Type
214 -- x_prec_flight_schedule OUT AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type
215 -- x_is_prec_conflict OUT VARCHAR2
216 -- x_succ_visit OUT AHL_VWP_VISITS_PVT.Visit_Rec_Type
217 -- x_succ_flight_schedule OUT AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type
218 -- x_is_succ_conflict OUT VARCHAR2
219 --
220 -- Version :
221 -- Initial Version 1.0
222 --
223 -- End of Comments --
224 PROCEDURE Get_Prec_Succ_Event_Info
225 (
226 p_api_version IN NUMBER,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_unit_config_id IN NUMBER,
231 p_start_date_time IN DATE,
232 p_end_date_time IN DATE,
233 x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
234 x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
235 x_is_prec_conflict OUT NOCOPY VARCHAR2,
236 x_is_prec_org_in_ou OUT NOCOPY VARCHAR2,
237 x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
238 x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
239 x_is_succ_conflict OUT NOCOPY VARCHAR2,
240 x_is_succ_org_in_ou OUT NOCOPY VARCHAR2
241 );
242
243 End AHL_UA_UNIT_SCHEDULES_PVT;