[Home] [Help]
PACKAGE: APPS.AHL_UMP_NONROUTINES_PVT
Source
1 PACKAGE AHL_UMP_NONROUTINES_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVNRTS.pls 120.4.12020000.2 2012/12/13 02:52:18 sareepar 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 --AJPRASAN::DFF Project, 18-Feb-2010, added DFF attributes to record type
65 REQUEST_CONTEXT VARCHAR2(30),
66 REQUEST_ATTRIBUTE1 VARCHAR2(150),
67 REQUEST_ATTRIBUTE2 VARCHAR2(150),
68 REQUEST_ATTRIBUTE3 VARCHAR2(150),
69 REQUEST_ATTRIBUTE4 VARCHAR2(150),
70 REQUEST_ATTRIBUTE5 VARCHAR2(150),
71 REQUEST_ATTRIBUTE6 VARCHAR2(150),
72 REQUEST_ATTRIBUTE7 VARCHAR2(150),
73 REQUEST_ATTRIBUTE8 VARCHAR2(150),
74 REQUEST_ATTRIBUTE9 VARCHAR2(150),
75 REQUEST_ATTRIBUTE10 VARCHAR2(150),
76 REQUEST_ATTRIBUTE11 VARCHAR2(150),
77 REQUEST_ATTRIBUTE12 VARCHAR2(150),
78 REQUEST_ATTRIBUTE13 VARCHAR2(150),
79 REQUEST_ATTRIBUTE14 VARCHAR2(150),
80 REQUEST_ATTRIBUTE15 VARCHAR2(150),
81 --debadey: Added QA Inspection Type Code and Description
82 QA_INSPECTION_TYPE VARCHAR2(150),
83 QA_INSPECTION_DESC VARCHAR2(150)
84 );
85
86 -----------------------
87 -- Define procedures --
88 -----------------------
89 -- Start of Comments --
90 --
91 -- Procedure name : Create_SR
92 -- Type : Private
93 -- Description : This procedure creates a CMRO non-routine (service request and its unit effectivity).
94 -- Pre-reqs :
95 --
96 -- Standard IN Parameters :
97 -- p_api_version NUMBER Required
98 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
99 -- p_commit VARCHAR2 := FND_API.G_FALSE
100 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
101 -- p_default VARCHAR2 := FND_API.G_FALSE
102 -- p_module_type VARCHAR2 := NULL
103 --
104 -- Standard OUT Parameters :
105 -- x_return_status VARCHAR2 Required
106 -- x_msg_count NUMBER Required
107 -- x_msg_data VARCHAR2 Required
108 --
109 -- Procedure IN, OUT, IN/OUT params :
110 -- p_x_nonroutine_rec NonRoutine_Rec_Type Required
111 --
112 -- Version :
113 -- Initial Version 1.0
114 --
115 -- End of Comments --
116 PROCEDURE Create_SR
117 (
118 -- Standard IN params
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121 p_commit IN VARCHAR2 := FND_API.G_FALSE,
122 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123 p_default IN VARCHAR2 := FND_API.G_FALSE,
124 p_module_type IN VARCHAR2 := NULL,
125 -- Standard OUT params
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 -- Procedure IN, OUT, IN/OUT params
130 p_x_nonroutine_rec IN OUT NOCOPY NonRoutine_Rec_Type
131 );
132
133 -- Start of Comments --
134 --
135 -- Procedure name : Update_SR
136 -- Type : Private
137 -- Description : This procedure updates a CMRO non-routine (service request and its unit effectivity).
138 -- Pre-reqs :
139 --
140 -- Standard IN Parameters :
141 -- p_api_version NUMBER Required
142 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
143 -- p_commit VARCHAR2 := FND_API.G_FALSE
144 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
145 -- p_default VARCHAR2 := FND_API.G_FALSE
146 -- p_module_type VARCHAR2 := NULL
147 --
148 -- Standard OUT Parameters :
149 -- x_return_status VARCHAR2 Required
150 -- x_msg_count NUMBER Required
151 -- x_msg_data VARCHAR2 Required
152 --
153 -- Procedure IN, OUT, IN/OUT params :
154 -- p_x_nonroutine_rec NonRoutine_Rec_Type Required
155 --
156 -- Version :
157 -- Initial Version 1.0
158 --
159 -- End of Comments --
160 PROCEDURE Update_SR
161 (
162 -- Standard IN params
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_default IN VARCHAR2 := FND_API.G_FALSE,
168 p_module_type IN VARCHAR2 := NULL,
169 -- Standard OUT params
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 -- Procedure IN, OUT, IN/OUT params
174 p_x_nonroutine_rec IN OUT NOCOPY NonRoutine_Rec_Type
175 );
176
177 -- Start of Comments --
178 --
179 -- Procedure name : Initiate_Mel_Cdl_Approval
180 -- Type : Private
181 -- Description : This procedure submits the unit effectivity of a CMRO non-routine for approval.
182 -- Pre-reqs :
183 --
184 -- Standard IN Parameters :
185 -- p_api_version NUMBER Required
186 -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
187 -- p_commit VARCHAR2 := FND_API.G_FALSE
188 -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
189 -- p_default VARCHAR2 := FND_API.G_FALSE
190 -- p_module_type VARCHAR2 := NULL
191 --
192 -- Standard OUT Parameters :
193 -- x_return_status VARCHAR2 Required
194 -- x_msg_count NUMBER Required
195 -- x_msg_data VARCHAR2 Required
196 --
197 -- Procedure IN, OUT, IN/OUT params :
198 -- p_ue_id NUMBER Required
199 -- p_ue_object_version NUMBER Required
200 --
201 -- Version :
202 -- Initial Version 1.0
203 --
204 -- End of Comments --
205 PROCEDURE Initiate_Mel_Cdl_Approval
206 (
207 -- Standard IN params
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 p_default IN VARCHAR2 := FND_API.G_FALSE,
213 p_module_type IN VARCHAR2 := NULL,
214 -- Standard OUT params
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 -- Procedure IN, OUT, IN/OUT params
219 p_ue_id IN NUMBER,
220 p_ue_object_version IN NUMBER
221 );
222
223 -----------------------
224 -- Define functions --
225 -----------------------
226 -- Start of Comments --
227 --
228 -- Function name : Get_Mel_Cdl_Header_Id
229 -- Type : Private/Public
230 -- Description : This function returns the applicable MEL/CDL for a CMRO non-routine unit effectivity. It uses the
231 -- unit effectivity's MEL/CDL type code, instance, unit and ata_sequence.
232 -- Pre-reqs :
233 --
234 -- Function params :
235 -- p_unit_effectivity_id NUMBER
236 -- p_csi_instance_id NUMBER
237 -- 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]
238 --
239 -- Return type and typical values :
240 -- NUMBER The relevant MEL/CDL header id
241 --
242 -- Version :
243 -- Initial Version 1.0
244 --
245 -- End of Comments --
246 FUNCTION Get_Mel_Cdl_Header_Id
247 (
248 p_unit_effectivity_id NUMBER,
249 p_csi_instance_id NUMBER,
250 p_mel_cdl_type_code VARCHAR2
251 )
252 RETURN NUMBER;
253
254 -----------------------
255 -- Define functions --
256 -----------------------
257 -- Start of Comments --
258 --
259 -- Function name : Get_Mel_Cdl_Status
260 -- Type : Private/Public
261 -- Description : This function returns the MEL/CDL status for a particular unit effectivity.
262 -- Pre-reqs :
263 --
264 -- Function params :
265 -- p_unit_effectivity_id NUMBER Required
266 -- p_get_code VARCHAR2 Required, Default FND_API.G_FALSE
267 --
268 -- Return type and typical values :
269 -- VARCHAR2 The relevant MEL/CDL status
270 --
271 -- Version :
272 -- Initial Version 1.0
273 --
274 -- End of Comments --
275 FUNCTION Get_Mel_Cdl_Status
276 (
277 p_unit_effectivity_id NUMBER,
278 p_get_code VARCHAR2 := FND_API.G_FALSE
279 )
280 RETURN VARCHAR2;
281
282 -----------------------
283 -- Define functions --
284 -----------------------
285 -- Start of Comments --
286 --
287 -- Function name : Check_Open_NRs
288 -- Type : Private
289 -- Description : This procedure verifies whether there are any open non-routines for a particular
290 -- MEL/CDL or Product Classification node.
291 -- Pre-reqs :
292 --
293 -- Standard IN Parameters :
294 --
295 -- Standard OUT Parameters :
296 -- x_return_status VARCHAR2 Required
297 --
298 -- Procedure IN, OUT, IN/OUT params :
299 -- p_mel_cdl_header_id NUMBER (one of p_mel_cdl_header_id or p_pc_node_id is mandatory)
300 -- p_pc_node_id NUMBER (one of p_mel_cdl_header_id or p_pc_node_id is mandatory)
301 --
302 -- Version :
303 -- Initial Version 1.0
304 --
305 -- End of Comments --
306 PROCEDURE Check_Open_NRs
307 (
308 -- Standard OUT params
309 x_return_status OUT NOCOPY VARCHAR2,
310 -- Procedure IN, OUT, IN/OUT params
311 p_mel_cdl_header_id IN NUMBER DEFAULT NULL,
312 p_pc_node_id IN NUMBER DEFAULT NULL
313 );
314
315 -- Procedure to process MEL/CDL approval when called from workflow.
316 PROCEDURE Process_MO_procedures
317 (
318 p_unit_effectivity_id IN NUMBER,
319 p_unit_deferral_id IN NUMBER,
320 p_unit_deferral_ovn IN NUMBER,
321 p_ata_sequence_id IN NUMBER,
322 p_cs_incident_id IN NUMBER,
323 p_csi_item_instance_id IN NUMBER);
324
325
326 End AHL_UMP_NONROUTINES_PVT;