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