[Home] [Help]
PACKAGE: APPS.AHL_UMP_NONROUTINES_PVT
Source
1 PACKAGE AHL_UMP_NONROUTINES_PVT AS
2 /* $Header: AHLVNRTS.pls 120.2 2008/02/29 07:45:09 sracha ship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL'; -- Use for all FND_MESSAGE.SET_NAME calls
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_NONROUTINES_PVT'; -- Use for all debug messages, FND_API.COMPATIBLE_API_CALL, etc
6
7 -------------------------------
8 -- Define records and tables --
9 -------------------------------
10 TYPE NonRoutine_Rec_Type IS RECORD
11 (
12 INCIDENT_ID NUMBER,
13 INCIDENT_NUMBER VARCHAR2(30),
14 INCIDENT_OBJECT_VERSION_NUMBER NUMBER,
15 INCIDENT_DATE DATE,
16 TYPE_ID NUMBER,
17 TYPE_NAME VARCHAR2(30),
18 STATUS_ID NUMBER,
19 STATUS_NAME VARCHAR2(30),
20 SEVERITY_ID NUMBER,
21 SEVERITY_NAME VARCHAR2(30),
22 URGENCY_ID NUMBER,
23 URGENCY_NAME VARCHAR2(30),
24 CUSTOMER_TYPE VARCHAR2(30),
25 CUSTOMER_ID NUMBER,
26 CUSTOMER_NUMBER VARCHAR2(30),
27 CUSTOMER_NAME VARCHAR2(360),
28 CONTACT_TYPE VARCHAR2(30),
29 CONTACT_ID NUMBER,
30 CONTACT_NUMBER VARCHAR2(30),
31 CONTACT_NAME VARCHAR2(360),
32 INSTANCE_ID NUMBER,
33 INSTANCE_NUMBER VARCHAR2(30),
34 PROBLEM_CODE VARCHAR2(50),
35 PROBLEM_MEANING VARCHAR2(80),
36 PROBLEM_SUMMARY VARCHAR2(240),
37 RESOLUTION_CODE VARCHAR2(50),
38 RESOLUTION_MEANING VARCHAR2(240),
39 EXPECTED_RESOLUTION_DATE DATE,
40 ACTUAL_RESOLUTION_DATE DATE,
41
42 UNIT_EFFECTIVITY_ID NUMBER,
43 UE_OBJECT_VERSION_NUMBER NUMBER,
44 LOG_SERIES_CODE VARCHAR2(30),
45 LOG_SERIES_MEANING VARCHAR2(80),
46 LOG_SERIES_NUMBER NUMBER,
47 FLIGHT_NUMBER VARCHAR2(30),
48 MEL_CDL_TYPE_CODE VARCHAR2(30),
49 MEL_CDL_TYPE_MEANING VARCHAR2(80),
50 POSITION_PATH_ID NUMBER,
51 ATA_CODE VARCHAR2(30),
52 ATA_MEANING VARCHAR2(80),
53 CLEAR_STATION_ORG_ID NUMBER,
54 CLEAR_STATION_ORG VARCHAR2(3),
55 CLEAR_STATION_DEPT_ID NUMBER,
56 CLEAR_STATION_DEPT VARCHAR2(10),
57 UNIT_CONFIG_HEADER_ID NUMBER,
58 UNIT_NAME VARCHAR2(80),
59 INVENTORY_ITEM_ID NUMBER,
60 ITEM_NUMBER VARCHAR2(40),
61 SERIAL_NUMBER VARCHAR2(30),
62 ATA_SEQUENCE_ID NUMBER,
63 MEL_CDL_QUAL_FLAG VARCHAR2(1)
64 );
65
66 -----------------------
67 -- Define procedures --
68 -----------------------
69 -- Start of Comments --
70 --
71 -- Procedure name : Create_SR
72 -- Type : Private
73 -- Description : This procedure creates a CMRO non-routine (service request and its unit effectivity).
74 -- Pre-reqs :
75 --
76 -- Standard IN Parameters :
77 -- p_api_version NUMBER Required
78 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
79 -- p_commit VARCHAR2 := FND_API.G_FALSE
80 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
81 -- p_default VARCHAR2 := FND_API.G_FALSE
82 -- p_module_type VARCHAR2 := NULL
83 --
84 -- Standard OUT Parameters :
85 -- x_return_status VARCHAR2 Required
86 -- x_msg_count NUMBER Required
87 -- x_msg_data VARCHAR2 Required
88 --
89 -- Procedure IN, OUT, IN/OUT params :
90 -- p_x_nonroutine_rec NonRoutine_Rec_Type Required
91 --
92 -- Version :
93 -- Initial Version 1.0
94 --
95 -- End of Comments --
96 PROCEDURE Create_SR
97 (
98 -- Standard IN params
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 p_default IN VARCHAR2 := FND_API.G_FALSE,
104 p_module_type IN VARCHAR2 := NULL,
105 -- Standard OUT params
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 -- Procedure IN, OUT, IN/OUT params
110 p_x_nonroutine_rec IN OUT NOCOPY NonRoutine_Rec_Type
111 );
112
113 -- Start of Comments --
114 --
115 -- Procedure name : Update_SR
116 -- Type : Private
117 -- Description : This procedure updates a CMRO non-routine (service request and its unit effectivity).
118 -- Pre-reqs :
119 --
120 -- Standard IN Parameters :
121 -- p_api_version NUMBER Required
122 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
123 -- p_commit VARCHAR2 := FND_API.G_FALSE
124 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
125 -- p_default VARCHAR2 := FND_API.G_FALSE
126 -- p_module_type VARCHAR2 := NULL
127 --
128 -- Standard OUT Parameters :
129 -- x_return_status VARCHAR2 Required
130 -- x_msg_count NUMBER Required
131 -- x_msg_data VARCHAR2 Required
132 --
133 -- Procedure IN, OUT, IN/OUT params :
134 -- p_x_nonroutine_rec NonRoutine_Rec_Type Required
135 --
136 -- Version :
137 -- Initial Version 1.0
138 --
139 -- End of Comments --
140 PROCEDURE Update_SR
141 (
142 -- Standard IN params
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 p_default IN VARCHAR2 := FND_API.G_FALSE,
148 p_module_type IN VARCHAR2 := NULL,
149 -- Standard OUT params
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 -- Procedure IN, OUT, IN/OUT params
154 p_x_nonroutine_rec IN OUT NOCOPY NonRoutine_Rec_Type
155 );
156
157 -- Start of Comments --
158 --
159 -- Procedure name : Initiate_Mel_Cdl_Approval
160 -- Type : Private
161 -- Description : This procedure submits the unit effectivity of a CMRO non-routine for approval.
162 -- Pre-reqs :
163 --
164 -- Standard IN Parameters :
165 -- p_api_version NUMBER Required
166 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
167 -- p_commit VARCHAR2 := FND_API.G_FALSE
168 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
169 -- p_default VARCHAR2 := FND_API.G_FALSE
170 -- p_module_type VARCHAR2 := NULL
171 --
172 -- Standard OUT Parameters :
173 -- x_return_status VARCHAR2 Required
174 -- x_msg_count NUMBER Required
175 -- x_msg_data VARCHAR2 Required
176 --
177 -- Procedure IN, OUT, IN/OUT params :
178 -- p_ue_id NUMBER Required
179 -- p_ue_object_version NUMBER Required
180 --
181 -- Version :
182 -- Initial Version 1.0
183 --
184 -- End of Comments --
185 PROCEDURE Initiate_Mel_Cdl_Approval
186 (
187 -- Standard IN params
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 p_default IN VARCHAR2 := FND_API.G_FALSE,
193 p_module_type IN VARCHAR2 := NULL,
194 -- Standard OUT params
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 -- Procedure IN, OUT, IN/OUT params
199 p_ue_id IN NUMBER,
200 p_ue_object_version IN NUMBER
201 );
202
203 -----------------------
204 -- Define functions --
205 -----------------------
206 -- Start of Comments --
207 --
208 -- Function name : Get_Mel_Cdl_Header_Id
209 -- Type : Private/Public
210 -- Description : This function returns the applicable MEL/CDL for a CMRO non-routine unit effectivity. It uses the
211 -- unit effectivity's MEL/CDL type code, instance, unit and ata_sequence.
212 -- Pre-reqs :
213 --
214 -- Function params :
215 -- p_unit_effectivity_id NUMBER
216 -- p_csi_instance_id NUMBER
217 -- p_mel_cdl_type_code VARCHAR2 [One of p_unit_effectivity_id or (p_csi_instance_id and p_mel_cdl_type_code) is mandatory]
218 --
219 -- Return type and typical values :
220 -- NUMBER The relevant MEL/CDL header id
221 --
222 -- Version :
223 -- Initial Version 1.0
224 --
225 -- End of Comments --
226 FUNCTION Get_Mel_Cdl_Header_Id
227 (
228 p_unit_effectivity_id NUMBER,
229 p_csi_instance_id NUMBER,
230 p_mel_cdl_type_code VARCHAR2
231 )
232 RETURN NUMBER;
233
234 -----------------------
235 -- Define functions --
236 -----------------------
237 -- Start of Comments --
238 --
239 -- Function name : Get_Mel_Cdl_Status
240 -- Type : Private/Public
241 -- Description : This function returns the MEL/CDL status for a particular unit effectivity.
242 -- Pre-reqs :
243 --
244 -- Function params :
245 -- p_unit_effectivity_id NUMBER Required
246 -- p_get_code VARCHAR2 Required, Default FND_API.G_FALSE
247 --
248 -- Return type and typical values :
249 -- VARCHAR2 The relevant MEL/CDL status
250 --
251 -- Version :
252 -- Initial Version 1.0
253 --
254 -- End of Comments --
255 FUNCTION Get_Mel_Cdl_Status
256 (
257 p_unit_effectivity_id NUMBER,
258 p_get_code VARCHAR2 := FND_API.G_FALSE
259 )
260 RETURN VARCHAR2;
261
262 -----------------------
263 -- Define functions --
264 -----------------------
265 -- Start of Comments --
266 --
267 -- Function name : Check_Open_NRs
268 -- Type : Private
269 -- Description : This procedure verifies whether there are any open non-routines for a particular
270 -- MEL/CDL or Product Classification node.
271 -- Pre-reqs :
272 --
273 -- Standard IN Parameters :
274 --
275 -- Standard OUT Parameters :
276 -- x_return_status VARCHAR2 Required
277 --
278 -- Procedure IN, OUT, IN/OUT params :
279 -- p_mel_cdl_header_id NUMBER (one of p_mel_cdl_header_id or p_pc_node_id is mandatory)
280 -- p_pc_node_id NUMBER (one of p_mel_cdl_header_id or p_pc_node_id is mandatory)
281 --
282 -- Version :
283 -- Initial Version 1.0
284 --
285 -- End of Comments --
286 PROCEDURE Check_Open_NRs
287 (
288 -- Standard OUT params
289 x_return_status OUT NOCOPY VARCHAR2,
290 -- Procedure IN, OUT, IN/OUT params
291 p_mel_cdl_header_id IN NUMBER DEFAULT NULL,
292 p_pc_node_id IN NUMBER DEFAULT NULL
293 );
294
295 -- Procedure to process MEL/CDL approval when called from workflow.
296 PROCEDURE Process_MO_procedures
297 (
298 p_unit_effectivity_id IN NUMBER,
299 p_unit_deferral_id IN NUMBER,
300 p_unit_deferral_ovn IN NUMBER,
301 p_ata_sequence_id IN NUMBER,
302 p_cs_incident_id IN NUMBER,
303 p_csi_item_instance_id IN NUMBER);
304
305
306 End AHL_UMP_NONROUTINES_PVT;