1 PACKAGE AHL_FMP_MR_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPMRHS.pls 120.3.12020000.2 2012/12/07 00:44:00 sareepar ship $ */
3 /*#
4 * Package containing APIs to create, update and delete Maintenance Requirement(MR) and its associations to Document References,
5 * Routes, Effectivities, and Visit Types. It includes APIs to setup Route dependencies within a Maintenance Requirement, define
6 * Effectivity details and Interval Thresholds for a Maintenance Requirement Effectivity, setup relationships between Maintenance
7 * Requirements, create new revision of a Maintenance Requirement and initiate approval workflows for Maintenance Requirement
8 * Completion or Termination.
9 * @rep:scope public
10 * @rep:product AHL
11 * @rep:displayname Maintenance Requirement
12 * @rep:lifecycle active
13 * @rep:category BUSINESS_ENTITY AHL_MAINT_REQUIREMENT
14 */
15
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_FMP_MR_PUB';
17
18 -----------------------
19 -- Define procedures --
20 -----------------------
21 -- Start of Comments --
22 --
23 -- Procedure name : Create_Mr
24 -- Type : Public
25 -- Function : API to create Maintenance Requirement and its associations to documents,
26 -- routes, visit types, effectivities and relationships.
27 -- Pre-reqs :
28 --
29 -- Standard IN Parameters :
30 -- p_api_version IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
32 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
33 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
34 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
35 -- p_module_type IN VARCHAR2 Required, default NULL
36
37 -- Standard OUT Parameters :
38 -- x_return_status OUT VARCHAR2 Required
39 -- x_msg_count OUT NUMBER Required
40 -- x_msg_data OUT VARCHAR2 Required
41 --
42 -- Procedure Parameters :
43 -- p_x_mr_header_rec IN OUT AHL_FMP_MR_HEADER_PVT.mr_header_rec Required
44 -- p_x_mr_doc_tbl IN OUT AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl
45 -- p_x_mr_route_tbl IN OUT AHL_FMP_MR_ROUTE_PVT.mr_route_tbl
46 -- p_x_mr_visit_type_tbl IN OUT AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type
47 -- p_x_effectivity_tbl IN OUT AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type
48 -- p_x_mr_relation_tbl IN OUT AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
49 -- p_x_accomtriggers_tbl IN OUT AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
50 --
51 -- Version :
52 -- Initial Version 1.0
53 --
54 -- End of Comments --
55 /*#
56 * Use this procedure to create a Maintenance Requirement and optionally, create associations to Document References, Routes,
57 * Visit Types, Effectivities and Relationships to other Maintenance Requirements.
58 * @param p_api_version API Version Number.
59 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
60 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
61 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
62 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
63 * @param p_module_type For Internal use only, should always be NULL, default value NULL
64 * @param x_return_status API Return status. Standard API parameter
65 * @param x_msg_count API Return message count, if any. Standard API parameter
66 * @param x_msg_data API Return message data, if any. Standard API parameter
67 * @param p_x_mr_header_rec Maintenance requirement record of type AHL_FMP_MR_HEADER_PVT.mr_header_rec
68 * @param p_x_mr_doc_tbl Table of type AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl to contain Document References to be associated to the Maintenance Requirement
69 * @param p_x_mr_route_tbl Table of type AHL_FMP_MR_ROUTE_PVT.mr_route_tbl to contain Routes to be associated to the Maintenance Requirement
70 * @param p_x_mr_visit_type_tbl Table of type AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type to contain Visit Types to be associated to the Maintenance Requirement
71 * @param p_x_effectivity_tbl Table of type AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type to contain Effectivities to be associated to the Maintenance Requirement
72 * @param p_x_mr_relation_tbl Table of type AHL_FMP_MR_RELATION_PVT.mr_relation_tbl to contain other Maintenance Requirements to be related to the Maintenance Requirement
73 * @param p_x_accomtriggers_tbl Table of type AHL_FMP_MR_RELATION_PVT.mr_relation_tbl to contain other Maintenance Requirements which can initiate/initiatedby/terminate/terminatedby the Maintenance Requirement
74 * @rep:scope public
75 * @rep:lifecycle active
76 * @rep:displayname Create Maintenance Requirement
77 */
78 PROCEDURE Create_Mr
79 (
80 -- standard IN params
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
83 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
84 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
85 p_default IN VARCHAR2 :=FND_API.G_FALSE,
86 p_module_type IN VARCHAR2 :=NULL,
87 -- standard OUT params
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 -- procedure params
92 p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.mr_header_rec,
93 p_x_mr_doc_tbl IN OUT NOCOPY AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl,
94 p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.mr_route_tbl,
95 p_x_mr_visit_type_tbl IN OUT NOCOPY AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type,
96 p_x_effectivity_tbl IN OUT NOCOPY AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type,
97 p_x_mr_relation_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl,
98 -- pdoki added for SBE Project
99 p_x_accomtriggers_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
100 );
101
102
103 -- Overloaded procedure retained for backaward compatibility
104 -- This procedure will call the above procedure with api_version = 2.
105 PROCEDURE Create_Mr
106 (
107 -- standard IN params
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
110 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
111 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
112 p_default IN VARCHAR2 :=FND_API.G_FALSE,
113 p_module_type IN VARCHAR2 :=NULL,
114 -- standard OUT params
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 -- procedure params
119 p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.mr_header_rec,
120 p_x_mr_doc_tbl IN OUT NOCOPY AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl,
121 p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.mr_route_tbl,
122 p_x_mr_visit_type_tbl IN OUT NOCOPY AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type,
123 p_x_effectivity_tbl IN OUT NOCOPY AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type,
124 p_x_mr_relation_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
125 );
126
127 -- Start of Comments --
128 --
129 -- Procedure name : Modify_Mr
130 -- Type : Public
131 -- Function : API to modify Maintenance Requirement and its associations to documents,
132 -- routes, visit types, effectivities and relationships.
133 -- Pre-reqs :
134 --
135 -- Standard IN Parameters :
136 -- p_api_version IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
138 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
140 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
141 -- p_module_type IN VARCHAR2 Required, default NULL
142
143 -- Standard OUT Parameters :
144 -- x_return_status OUT VARCHAR2 Required
145 -- x_msg_count OUT NUMBER Required
146 -- x_msg_data OUT VARCHAR2 Required
147 --
148 -- Procedure Parameters :
149 -- p_x_mr_header_rec IN OUT AHL_FMP_MR_HEADER_PVT.mr_header_rec
150 -- p_x_mr_doc_tbl IN OUT AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl
151 -- p_x_mr_route_tbl IN OUT AHL_FMP_MR_ROUTE_PVT.mr_route_tbl
152 -- p_x_mr_visit_type_tbl IN OUT AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type
153 -- p_x_effectivity_tbl IN OUT AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type
154 -- p_x_mr_relation_tbl IN OUT AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
155 -- p_x_accomtriggers_tbl IN OUT AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
156 --
157 -- Version :
158 -- Initial Version 1.0
159 --
160 -- End of Comments --
161 /*#
162 * Use this procedure to modify a Maintenance Requirement and optionally, create, modify, delete associated Document References,
163 * Routes, Visit Types, Effectivities and Relationships to other Maintenance Requirements.
164 * @param p_api_version API Version Number.
165 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
166 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
167 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
168 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
169 * @param p_module_type For Internal use only, should always be NULL, default value NULL
170 * @param x_return_status API Return status. Standard API parameter
171 * @param x_msg_count API Return message count, if any. Standard API parameter
172 * @param x_msg_data API Return message data, if any. Standard API parameter
173 * @param p_mr_header_rec Maintenance requirement record of type AHL_FMP_MR_HEADER_PVT.mr_header_rec
174 * @param p_x_mr_doc_tbl Table of type AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl to contain Document References to be associated to the Maintenance Requirement
175 * @param p_x_mr_route_tbl Table of type AHL_FMP_MR_ROUTE_PVT.mr_route_tbl to contain Routes to be associated to the Maintenance Requirement
176 * @param p_x_mr_visit_type_tbl Table of type AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type to contain Visit Types to be associated to the Maintenance Requirement
177 * @param p_x_effectivity_tbl Table of type AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type to contain Effectivities to be associated to the Maintenance Requirement
178 * @param p_x_mr_relation_tbl Table of type AHL_FMP_MR_RELATION_PVT.mr_relation_tbl to contain other Maintenance Requirements to be related to the Maintenance Requirement
179 * @param p_x_accomtriggers_tbl Table of type AHL_FMP_MR_RELATION_PVT.mr_relation_tbl to contain other Maintenance Requirements which can initiate/initiatedby/terminate/terminatedby the Maintenance Requirement
180 * @rep:scope public
181 * @rep:lifecycle active
182 * @rep:displayname Modify Maintenance Requirement
183 */
184 PROCEDURE Modify_Mr
185 (
186 -- standard IN params
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
189 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
190 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
191 p_default IN VARCHAR2 :=FND_API.G_FALSE,
192 p_module_type IN VARCHAR2 :=NULL,
193 -- standard OUT params
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 -- procedure params
198 p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.mr_header_rec,
199 p_x_mr_doc_tbl IN OUT NOCOPY AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl,
200 p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.mr_route_tbl,
201 p_x_mr_visit_type_tbl IN OUT NOCOPY AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type,
202 p_x_effectivity_tbl IN OUT NOCOPY AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type,
203 p_x_mr_relation_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl,
204 -- pdoki added for SBE Project
205 p_x_accomtriggers_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
206 );
207
208
209 -- Overloaded procedure retained for backaward compatibility.
210 -- This procedure will call the above procedure with api_version = 2.
211 PROCEDURE Modify_Mr
212 (
213 -- standard IN params
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
216 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
218 p_default IN VARCHAR2 :=FND_API.G_FALSE,
219 p_module_type IN VARCHAR2 :=NULL,
220 -- standard OUT params
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 -- procedure params
225 p_mr_header_rec IN AHL_FMP_MR_HEADER_PVT.mr_header_rec,
226 p_x_mr_doc_tbl IN OUT NOCOPY AHL_FMP_MR_DOC_ASSO_PVT.doc_association_tbl,
227 p_x_mr_route_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_PVT.mr_route_tbl,
228 p_x_mr_visit_type_tbl IN OUT NOCOPY AHL_FMP_MR_VISIT_TYPES_PVT.mr_visit_type_tbl_type,
229 p_x_effectivity_tbl IN OUT NOCOPY AHL_FMP_MR_EFFECTIVITY_PVT.effectivity_tbl_type,
230 p_x_mr_relation_tbl IN OUT NOCOPY AHL_FMP_MR_RELATION_PVT.mr_relation_tbl
231 );
232
233 -- Start of Comments --
234 --
235 -- Procedure name : Delete_Mr
236 -- Type : Public
237 -- Function : API to delete Maintenance Requirement and all its associations to documents,
238 -- routes, visit types, effectivities and relationships.
239 -- Pre-reqs :
240 --
241 -- Standard IN Parameters :
242 -- p_api_version IN NUMBER Required
243 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
244 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
245 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
247 -- p_module_type IN VARCHAR2 Required, default NULL
248
249 -- Standard OUT Parameters :
250 -- x_return_status OUT VARCHAR2 Required
251 -- x_msg_count OUT NUMBER Required
252 -- x_msg_data OUT VARCHAR2 Required
253 --
254 -- Procedure Parameters :
255 -- p_mr_header_id IN NUMBER Required
256 -- p_mr_title IN VARCHAR2 Required
257 -- p_mr_version_number IN NUMBER Required
258 -- p_mr_object_version IN NUMBER Required
259 --
260 -- Version :
261 -- Initial Version 1.0
262 --
263 -- End of Comments --
264 /*#
265 * Use this procedure to delete Maintenance Requirement. All associations to Documents, Routes, Visit Types, Effectivities and
266 * relationships with other Maintenance Requirements are also deleted.
267 * @param p_api_version API Version Number.
268 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
269 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
270 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
271 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
272 * @param p_module_type For Internal use only, should always be NULL, default value NULL
273 * @param x_return_status API Return status. Standard API parameter
274 * @param x_msg_count API Return message count, if any. Standard API parameter
275 * @param x_msg_data API Return message data, if any. Standard API parameter
276 * @param p_mr_header_id Maintenance requirement unique identifier
277 * @param p_mr_title Maintenance requirement title
278 * @param p_mr_version_number Maintenance requirement revision number
279 * @param p_mr_object_version Maintenance requirement object version number
280 * @rep:scope public
281 * @rep:lifecycle active
282 * @rep:displayname Delete Maintenance Requirement
283 */
284 PROCEDURE Delete_Mr
285 (
286 -- standard IN params
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
289 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
290 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291 p_default IN VARCHAR2 :=FND_API.G_FALSE,
292 p_module_type IN VARCHAR2 :=NULL,
293 -- standard OUT params
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 -- procedure params
298 p_mr_header_id IN NUMBER,
299 p_mr_title IN VARCHAR2,
300 p_mr_version_number IN NUMBER,
301 p_mr_object_version IN NUMBER
302 );
303
304 -- Start of Comments --
305 --
306 -- Procedure name : Create_Mr_Revision
307 -- Type : Public
308 -- Function : API to create a new revision of a Maintenance Requirement.
309 -- Pre-reqs :
310 --
311 -- Standard IN Parameters :
312 -- p_api_version IN NUMBER Required
313 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
314 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
315 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
316 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
317 -- p_module_type IN VARCHAR2 Required, default NULL
318
319 -- Standard OUT Parameters :
320 -- x_return_status OUT VARCHAR2 Required
321 -- x_msg_count OUT NUMBER Required
322 -- x_msg_data OUT VARCHAR2 Required
323 --
324 -- Procedure Parameters :
325 -- p_mr_header_id IN NUMBER Required
326 -- p_mr_title IN VARCHAR2 Required
327 -- p_mr_version_number IN NUMBER Required
328 -- p_mr_object version IN NUMBER Required
329 -- x_new_mr_header_id OUT NUMBER Required
330 --
331 -- Version :
332 -- Initial Version 1.0
333 --
334 -- End of Comments --
335 /*#
336 * Use this procedure to create a new revision of an existing and completed Maintenance Requirement.
337 * @param p_api_version API Version Number.
338 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
339 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
340 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
341 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
342 * @param p_module_type For Internal use only, should always be NULL, default value NULL
343 * @param x_return_status API Return status. Standard API parameter
344 * @param x_msg_count API Return message count, if any. Standard API parameter
345 * @param x_msg_data API Return message data, if any. Standard API parameter
346 * @param p_mr_header_id Maintenance requirement unique identifier
347 * @param p_mr_title Maintenance requirement title
348 * @param p_mr_version_number Maintenance requirement revision number
349 * @param p_mr_object_version Maintenance requirement object version number
350 * @param x_new_mr_header_id Unique identifier of the new revision of the maintenance requirement
351 * @rep:scope public
352 * @rep:lifecycle active
353 * @rep:displayname Create Maintenance Requirement Revision
354 */
355 PROCEDURE Create_Mr_Revision
356 (
357 -- standard IN params
358 p_api_version IN NUMBER,
359 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
360 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
361 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
362 p_default IN VARCHAR2 :=FND_API.G_FALSE,
363 p_module_type IN VARCHAR2 :=NULL,
364 -- standard OUT params
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 -- procedure params
369 p_mr_header_id IN NUMBER,
370 p_mr_title IN VARCHAR2,
371 p_mr_version_number IN NUMBER,
372 p_mr_object_version IN NUMBER,
373 x_new_mr_header_id OUT NOCOPY NUMBER
374 );
375
376 -- Start of Comments --
377 --
378 -- Procedure name : Initiate_Mr_Approval
379 -- Type : Public
380 -- Function : API to submit a Maintenance Requirement to complete / terminate approval workflows.
381 -- Pre-reqs :
382 --
383 -- Standard IN Parameters :
384 -- p_api_version IN NUMBER Required
385 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
386 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
387 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
388 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
389 -- p_module_type IN VARCHAR2 Required, default NULL
390
391 -- Standard OUT Parameters :
392 -- x_return_status OUT VARCHAR2 Required
393 -- x_msg_count OUT NUMBER Required
394 -- x_msg_data OUT VARCHAR2 Required
395 --
396 -- Procedure Parameters :
397 -- p_mr_header_id IN NUMBER Required
398 -- p_mr_title IN VARCHAR2 Required
399 -- p_mr_version_number IN NUMBER Required
400 -- p_mr_object_version IN NUMBER Required
401 -- p_apprv_type IN VARCHAR2 Required, default 'COMPLETE'
402 --
403 -- Version :
404 -- Initial Version 1.0
405 --
406 -- End of Comments --
407 /*#
408 * Use this procedure to submit a Maintenance Requirement for Completion or Termination approval workflows.
409 * @param p_api_version API Version Number.
410 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
411 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
412 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
413 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
414 * @param p_module_type For Internal use only, should always be NULL, default value NULL
415 * @param x_return_status API Return status. Standard API parameter
416 * @param x_msg_count API Return message count, if any. Standard API parameter
417 * @param x_msg_data API Return message data, if any. Standard API parameter
418 * @param p_mr_header_id Maintenance requirement unique identifier
419 * @param p_mr_title Maintenance requirement title
420 * @param p_mr_version_number Maintenance requirement revision number
421 * @param p_mr_object_version Maintenance requirement object version number
422 * @param p_apprv_type Approval type, one of 'COMPLETE' and 'TERMINATE'
423 * @rep:scope public
424 * @rep:lifecycle active
425 * @rep:displayname Initiate Maintenance Requirement Approval
426 */
427 PROCEDURE Initiate_Mr_Approval
428 (
429 -- standard IN params
430 p_api_version IN NUMBER,
431 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
432 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
433 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
434 p_default IN VARCHAR2 :=FND_API.G_FALSE,
435 p_module_type IN VARCHAR2 :=NULL,
436 -- standard OUT params
437 x_return_status OUT NOCOPY VARCHAR2,
438 x_msg_count OUT NOCOPY NUMBER,
439 x_msg_data OUT NOCOPY VARCHAR2,
440 -- procedure params
441 p_mr_header_id IN NUMBER,
442 p_mr_title IN VARCHAR2,
443 p_mr_version_number IN NUMBER,
444 p_mr_object_version IN NUMBER,
445 p_apprv_type IN VARCHAR2 :='COMPLETE'
446 );
447
448 -- Start of Comments --
449 --
450 -- Procedure name : Process_Mr_Route_Seq
451 -- Type : Public
452 -- Function : API to process dependencies among routes associated with a Maintenance Requirement.
453 -- Pre-reqs :
454 --
455 -- Standard IN Parameters :
456 -- p_api_version IN NUMBER Required
457 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
458 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
459 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
460 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
461 -- p_module_type IN VARCHAR2 Required, default NULL
462
463 -- Standard OUT Parameters :
464 -- x_return_status OUT VARCHAR2 Required
465 -- x_msg_count OUT NUMBER Required
466 -- x_msg_data OUT VARCHAR2 Required
467 --
468 -- Procedure Parameters :
469 -- p_x_mr_route_seq_tbl IN OUT AHL_FMP_MR_ROUTE_SEQNCE_PVT.mr_route_seq_tbl Required
470 --
471 -- Version :
472 -- Initial Version 1.0
473 --
474 -- End of Comments --
475 /*#
476 * Use this procedure to create, modify and delete dependencies within the Maintenance Requirement Routes.
477 * @param p_api_version API Version Number.
478 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
479 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
480 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
481 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
482 * @param p_module_type For Internal use only, should always be NULL, default value NULL
483 * @param x_return_status API Return status. Standard API parameter
484 * @param x_msg_count API Return message count, if any. Standard API parameter
485 * @param x_msg_data API Return message data, if any. Standard API parameter
486 * @param p_x_mr_route_seq_tbl Maintenance requirement route dependencies table of type AHL_FMP_MR_ROUTE_SEQNCE_PVT.mr_route_seq_tbl
487 * @rep:scope public
488 * @rep:lifecycle active
489 * @rep:displayname Process Maintenance Requirement Route Dependencies
490 */
491 PROCEDURE Process_Mr_Route_Seq
492 (
493 -- standard IN params
494 p_api_version IN NUMBER,
495 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
496 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
497 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
498 p_default IN VARCHAR2 :=FND_API.G_FALSE,
499 p_module_type IN VARCHAR2 :=NULL,
500 -- standard OUT params
501 x_return_status OUT NOCOPY VARCHAR2,
502 x_msg_count OUT NOCOPY NUMBER,
503 x_msg_data OUT NOCOPY VARCHAR2,
504 -- procedure params
505 p_x_mr_route_seq_tbl IN OUT NOCOPY AHL_FMP_MR_ROUTE_SEQNCE_PVT.mr_route_seq_tbl
506 );
507
508 -- Start of Comments --
509 --
510 -- Procedure name : Process_Mr_Effectivities
511 -- Type : Public
512 -- Function : API to process details of Maintenance Requirement effectivities, viz. effectivity
513 -- details and interval thresholds.
514 -- Pre-reqs :
515 --
516 -- Standard IN Parameters :
517 -- p_api_version IN NUMBER Required
518 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
519 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
520 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
521 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
522 -- p_module_type IN VARCHAR2 Required, default NULL
523
524 -- Standard OUT Parameters :
525 -- x_return_status OUT VARCHAR2 Required
526 -- x_msg_count OUT NUMBER Required
527 -- x_msg_data OUT VARCHAR2 Required
528 --
529 -- Procedure Parameters :
530 -- p_mr_header_id IN NUMBER Required
531 -- p_mr_title IN VARCHAR2 Required
532 -- p_mr_version_number IN NUMBER Required
533 -- p_mr_effectivity_id IN NUMBER Required
534 -- p_mr_effectivity_name IN VARCHAR2 Required
535 -- p_x_mr_effectivity_detail_tbl IN OUT AHL_FMP_EFFECTIVITY_DTL_PVT.effectivity_detail_tbl_type
536 -- p_x_mr_threshold_rec IN OUT AHL_FMP_MR_INTERVAL_PVT.threshold_rec_type
537 -- p_x_mr_interval_tbl IN OUT AHL_FMP_MR_INTERVAL_PVT.interval_tbl_type
538 --
539 -- Version :
540 -- Initial Version 1.0
541 --
542 -- End of Comments --
543 /*#
544 * Use this procedure to create, modify and delete Effectivity Details and Interval thresholds for a Maintenance
545 * Requirement Effectivity.
546 * @param p_api_version API Version Number.
547 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
548 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
549 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
550 * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
551 * @param p_module_type For Internal use only, should always be NULL, default value NULL
552 * @param x_return_status API Return status. Standard API parameter
553 * @param x_msg_count API Return message count, if any. Standard API parameter
554 * @param x_msg_data API Return message data, if any. Standard API parameter
555 * @param p_mr_header_id Maintenance requirement unique identifier
556 * @param p_mr_title Maintenance requirement title
557 * @param p_mr_version_number Maintenance requirement revision number
558 * @param p_super_user Flag to indicate user has super user permissions
559 * @param p_mr_effectivity_id Maintenance requirement effectivity unique identifier
560 * @param p_mr_effectivity_name Maintenance requirement effectivity name
561 * @param p_x_mr_effectivity_detail_tbl Maintenance requirement effectivity details table of type AHL_FMP_EFFECTIVITY_DTL_PVT.effectivity_detail_tbl_type
562 * @param p_x_effty_ext_detail_tbl Maintenance requirement extended effectivity details table of type AHL_FMP_EFFECTIVITY_DTL_PVT.effty_ext_detail_tbl_type
563 * @param p_x_mr_threshold_rec Maintenance requirement effectivity threshold record of type AHL_FMP_MR_INTERVAL_PVT.threshold_rec_type
564 * @param p_x_mr_interval_tbl Maintenance requirement effectivity interval threshold table of type AHL_FMP_MR_INTERVAL_PVT.threshold_tbl_type
565 * @rep:scope public
566 * @rep:lifecycle active
567 * @rep:displayname Process Maintenance Requirement Effectivities
568 */
569 PROCEDURE Process_Mr_Effectivities
570 (
571 -- standard IN params
572 p_api_version IN NUMBER,
573 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
574 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
575 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
576 p_default IN VARCHAR2 :=FND_API.G_FALSE,
577 p_module_type IN VARCHAR2 :=NULL,
578 -- standard OUT params
579 x_return_status OUT NOCOPY VARCHAR2,
580 x_msg_count OUT NOCOPY NUMBER,
581 x_msg_data OUT NOCOPY VARCHAR2,
582 -- procedure params
583 p_mr_header_id IN NUMBER,
584 p_mr_title IN VARCHAR2,
585 p_mr_version_number IN NUMBER,
586 p_super_user IN VARCHAR2 :='N',
587 p_mr_effectivity_id IN NUMBER,
588 p_mr_effectivity_name IN VARCHAR2,
589 p_x_mr_effectivity_detail_tbl IN OUT NOCOPY AHL_FMP_EFFECTIVITY_DTL_PVT.effectivity_detail_tbl_type,
590 p_x_effty_ext_detail_tbl IN OUT NOCOPY AHL_FMP_EFFECTIVITY_DTL_PVT.effty_ext_detail_tbl_type,
591 p_x_mr_threshold_rec IN OUT NOCOPY AHL_FMP_MR_INTERVAL_PVT.threshold_rec_type,
592 p_x_mr_interval_tbl IN OUT NOCOPY AHL_FMP_MR_INTERVAL_PVT.interval_tbl_type
593 );
594
595 END AHL_FMP_MR_PUB;