1 PACKAGE AHL_RM_OPERATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPOPES.pls 120.1.12020000.2 2012/07/17 10:35:56 arunjk ship $ */
3 /*#
4 * Package containing APIs to create, update and delete Operations and its associated document references, resource requirements,
5 * resource costing parameters, alternate resources, access panels and material requirements. It allows users to submit Operations for completion
6 * or termination approval flows and to create Operation revisions.
7 * @rep:scope public
8 * @rep:product AHL
9 * @rep:displayname Operation
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY AHL_MAINT_OPERATION
12 */
13
14 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_RM_OPERATION_PUB';
15
16 -----------------------
17 -- Define procedures --
18 -----------------------
19 -- Start of Comments --
20 --
21 -- Procedure name : Create_Operation
22 -- Type : Public
23 -- Function : API to create Operation and its associations to documents, resources,
24 -- resource costing parameters, access panels and materials.
25 -- Pre-reqs :
26 --
27 -- Standard IN Parameters :
28 -- p_api_version IN NUMBER Required (=2.0)
29 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
30 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
31 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
32 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
33 -- p_module_type IN VARCHAR2 Required, default NULL
34
35 -- Standard OUT Parameters :
36 -- x_return_status OUT VARCHAR2 Required
37 -- x_msg_count OUT NUMBER Required
38 -- x_msg_data OUT VARCHAR2 Required
39 --
40 -- Procedure Parameters :
41 -- p_x_oper_rec IN OUT AHL_RM_OPERATION_PVT.operation_rec_type Required
42 -- p_x_oper_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
43 -- p_x_oper_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
44 -- p_x_oper_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
45 -- p_x_oper_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
46 --
47 -- Version :
48 -- Initial Version 1.0
49 --
50 -- End of Comments --
51 /*#
52 * Use this procedure to create an Operation and optionally, create associated document references, resource requirements, resource costing parameters and material requirements.
56 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
53 * @param p_api_version API Version Number (=2.0).
54 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
55 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
57 * @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
58 * @param p_module_type For Internal use only, should always be NULL, default value NULL
59 * @param x_return_status API Return status. Standard API parameter
60 * @param x_msg_count API Return message count, if any. Standard API parameter
61 * @param x_msg_data API Return message data, if any. Standard API parameter
62 * @param p_x_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
63 * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
64 * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
65 * @param p_x_oper_material_tbl Table of Material Requirements of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Operation
66 * @param p_x_oper_panel_tbl Table of Access Panels of type AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type that need to be associated to the Operation
67 * @rep:scope public
68 * @rep:lifecycle active
69 * @rep:displayname Create Operation
70 */
71 PROCEDURE Create_Operation
72 (
73 -- standard IN params
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
76 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
77 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
78 p_default IN VARCHAR2 :=FND_API.G_FALSE,
79 p_module_type IN VARCHAR2 :=NULL,
80 -- standard OUT params
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 -- procedure params
85 p_x_oper_rec IN OUT NOCOPY AHL_RM_OPERATION_PVT.operation_rec_type,
86 p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
87 p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
88 p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
89 p_x_oper_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
90 );
91
92 -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
93 -- This procedure will call the above procedure with api_version = 2.
94 PROCEDURE Create_Operation
95 (
96 -- standard IN params
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
99 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
100 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
101 p_default IN VARCHAR2 :=FND_API.G_FALSE,
102 p_module_type IN VARCHAR2 :=NULL,
103 -- standard OUT params
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 -- procedure params
108 p_x_oper_rec IN OUT NOCOPY AHL_RM_OPERATION_PVT.operation_rec_type,
109 p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
110 p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
111 p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
112 );
113
114 -- Start of Comments --
115 --
116 -- Procedure name : Modify_Operation
117 -- Type : Public
118 -- Function : API to modify Operation details and its associations to documents, resources,
119 -- resource costing parameters, access panels and materials.
120 -- Pre-reqs :
121 --
122 -- Standard IN Parameters :
123 -- p_api_version IN NUMBER Required (=2.0)
124 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
125 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
127 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
128 -- p_module_type IN VARCHAR2 Required, default NULL
129
130 -- Standard OUT Parameters :
131 -- x_return_status OUT VARCHAR2 Required
132 -- x_msg_count OUT NUMBER Required
133 -- x_msg_data OUT VARCHAR2 Required
134 --
135 -- Procedure Parameters :
136 -- p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type Required
137 -- p_x_oper_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
138 -- p_x_oper_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
139 -- p_x_oper_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
140 -- p_x_oper_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
141 --
142 -- Version :
143 -- Initial Version 1.0
144 --
145 -- End of Comments --
146 /*#
147 * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
148 * @param p_api_version API Version Number (=2.0).
149 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
153 * @param p_module_type For Internal use only, should always be NULL, default value NULL
150 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
151 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152 * @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
154 * @param x_return_status API Return status. Standard API parameter
155 * @param x_msg_count API Return message count, if any. Standard API parameter
156 * @param x_msg_data API Return message data, if any. Standard API parameter
157 * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
158 * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
159 * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
160 * @param p_x_oper_material_tbl Table of Material Requirements of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Operation
161 * @param p_x_oper_panel_tbl Table of Access Panels of type AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type that need to be associated to the Operation
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:displayname Modify Operation
165 */
166 PROCEDURE Modify_Operation
167 (
168 -- standard IN params
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
171 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
172 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
173 p_default IN VARCHAR2 :=FND_API.G_FALSE,
174 p_module_type IN VARCHAR2 :=NULL,
175 -- standard OUT params
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 -- procedure params
180 p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type,
181 p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
182 p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
183 p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
184 p_x_oper_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
185 );
186
187 -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
188 -- This procedure will call the above procedure with api_version = 2.
189 PROCEDURE Modify_Operation
190 (
191 -- standard IN params
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
194 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
195 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
196 p_default IN VARCHAR2 :=FND_API.G_FALSE,
197 p_module_type IN VARCHAR2 :=NULL,
198 -- standard OUT params
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 -- procedure params
203 p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type,
204 p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
205 p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
206 p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
207 );
208
209 -- Start of Comments --
210 --
211 -- Procedure name : Delete_Operation
212 -- Type : Public
213 -- Function : API to deletion of operations. All associations to documents, resources,
214 -- resource costing parameters and materials are also deleted.
215 -- Pre-reqs :
216 --
217 -- Standard IN Parameters :
218 -- p_api_version IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
220 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
221 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
222 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
223 -- p_module_type IN VARCHAR2 Required, default NULL
224
225 -- Standard OUT Parameters :
226 -- x_return_status OUT VARCHAR2 Required
227 -- x_msg_count OUT NUMBER Required
228 -- x_msg_data OUT VARCHAR2 Required
229 --
230 -- Procedure Parameters :
231 -- p_oper_id IN NUMBER Required
232 -- p_oper_number IN VARCHAR2 Required
233 -- p_oper_revision IN NUMBER Required
234 -- p_oper_object_version IN NUMBER Required
235 --
236 -- Version :
237 -- Initial Version 1.0
238 --
239 -- End of Comments --
240 /*#
241 * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
242 * @param p_api_version API Version Number.
243 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
244 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
245 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246 * @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
247 * @param p_module_type For Internal use only, should always be NULL, default value NULL
248 * @param x_return_status API Return status. Standard API parameter
249 * @param x_msg_count API Return message count, if any. Standard API parameter
250 * @param x_msg_data API Return message data, if any. Standard API parameter
251 * @param p_oper_id Operation unique identifier
252 * @param p_oper_number Operation number
256 * @rep:lifecycle active
253 * @param p_oper_revision Operation revision number
254 * @param p_oper_object_version Operation object version number
255 * @rep:scope public
257 * @rep:displayname Delete Operation
258 */
259 PROCEDURE Delete_Operation
260 (
261 -- standard IN params
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
264 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
265 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
266 p_default IN VARCHAR2 :=FND_API.G_FALSE,
267 p_module_type IN VARCHAR2 :=NULL,
268 -- standard OUT params
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2,
272 -- procedure params
273 p_oper_id IN NUMBER,
274 p_oper_number IN VARCHAR2,
275 p_oper_revision IN NUMBER,
276 p_oper_object_version IN NUMBER
277 );
278
279 -- Start of Comments --
280 --
281 -- Procedure name : Create_Oper_Revision
282 -- Type : Public
283 -- Function : API to create a new revision of a Operation.
284 -- Pre-reqs :
285 --
286 -- Standard IN Parameters :
287 -- p_api_version IN NUMBER Required
288 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
289 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
290 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
291 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
292 -- p_module_type IN VARCHAR2 Required, default NULL
293
294 -- Standard OUT Parameters :
295 -- x_return_status OUT VARCHAR2 Required
296 -- x_msg_count OUT NUMBER Required
297 -- x_msg_data OUT VARCHAR2 Required
298 --
299 -- Procedure Parameters :
300 -- p_oper_id IN NUMBER Required
301 -- p_oper_number IN VARCHAR2 Required
302 -- p_oper_revision IN NUMBER Required
303 -- p_oper_object version IN NUMBER Required
304 -- x_new_operation_id OUT NUMBER Required
305 --
306 -- Version :
307 -- Initial Version 1.0
308 --
309 -- End of Comments --
310 /*#
311 * Use this procedure to create a new revision of an existing and completed Operation.
312 * @param p_api_version API Version Number.
313 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
314 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
315 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316 * @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
317 * @param p_module_type For Internal use only, should always be NULL, default value NULL
318 * @param x_return_status API Return status. Standard API parameter
319 * @param x_msg_count API Return message count, if any. Standard API parameter
320 * @param x_msg_data API Return message data, if any. Standard API parameter
321 * @param p_oper_id Operation unique identifier
322 * @param p_oper_number Operation number
323 * @param p_oper_revision Operation revision number
324 * @param p_oper_object_version Operation object version number
325 * @param x_new_oper_id Unique identifier of the new revision of the Operation
326 * @rep:scope public
327 * @rep:lifecycle active
328 * @rep:displayname Create Operation Revision
329 */
330 PROCEDURE Create_Oper_Revision
331 (
332 -- standard IN params
333 p_api_version IN NUMBER,
334 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
335 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
336 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
337 p_default IN VARCHAR2 :=FND_API.G_FALSE,
338 p_module_type IN VARCHAR2 :=NULL,
339 -- standard OUT params
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2,
343 -- procedure params
344 p_oper_id IN NUMBER,
345 p_oper_number IN VARCHAR2,
346 p_oper_revision IN NUMBER,
347 p_oper_object_version IN NUMBER,
348 x_new_oper_id OUT NOCOPY NUMBER
349 );
350
351 -- Start of Comments --
352 --
353 -- Procedure name : Initiate_Oper_Approval
354 -- Type : Public
355 -- Function : API to submit a Operation to complete / terminate approval workflows.
356 -- Pre-reqs :
357 --
358 -- Standard IN Parameters :
359 -- p_api_version IN NUMBER Required
360 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
361 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
362 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
363 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
364 -- p_module_type IN VARCHAR2 Required, default NULL
365
366 -- Standard OUT Parameters :
367 -- x_return_status OUT VARCHAR2 Required
368 -- x_msg_count OUT NUMBER Required
369 -- x_msg_data OUT VARCHAR2 Required
370 --
371 -- Procedure Parameters :
372 -- p_oper_id IN NUMBER Required
373 -- p_oper_number IN VARCHAR2 Required
374 -- p_oper_revision IN NUMBER Required
375 -- p_oper_object_version IN NUMBER Required
376 -- p_apprv_type IN VARCHAR2 Required, default 'COMPLETE'
377 --
378 -- Version :
379 -- Initial Version 1.0
380 --
381 -- End of Comments --
382 /*#
386 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
383 * Use this procedure to submit an Operation for Completion or Termination approval workflows.
384 * @param p_api_version API Version Number.
385 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
387 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388 * @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
389 * @param p_module_type For Internal use only, should always be NULL, default value NULL
390 * @param x_return_status API Return status. Standard API parameter
391 * @param x_msg_count API Return message count, if any. Standard API parameter
392 * @param x_msg_data API Return message data, if any. Standard API parameter
393 * @param p_oper_id Operation unique identifier
394 * @param p_oper_number Operation number
395 * @param p_oper_revision Operation revision number
396 * @param p_oper_object_version Operation object version number
397 * @param p_apprv_type Approval type, one of 'COMPLETE' and 'TERMINATE', default is 'COMPLETE'
398 * @rep:scope public
399 * @rep:lifecycle active
400 * @rep:displayname Initiate Operation Approval
401 */
402 PROCEDURE Initiate_Oper_Approval
403 (
404 -- standard IN params
405 p_api_version IN NUMBER,
406 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
407 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
408 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409 p_default IN VARCHAR2 :=FND_API.G_FALSE,
410 p_module_type IN VARCHAR2 :=NULL,
411 -- standard OUT params
412 x_return_status OUT NOCOPY VARCHAR2,
413 x_msg_count OUT NOCOPY NUMBER,
414 x_msg_data OUT NOCOPY VARCHAR2,
415 -- procedure params
416 p_oper_id IN NUMBER,
417 p_oper_number IN VARCHAR2,
418 p_oper_revision IN NUMBER,
419 p_oper_object_version IN NUMBER,
420 p_apprv_type IN VARCHAR2 :='COMPLETE'
421 );
422
423 -- Start of Comments --
424 --
425 -- Procedure name : Process_Oper_Alt_Resources
426 -- Type : Public
427 -- Function : API to process alternate resources for operations.
428 -- Pre-reqs :
429 --
430 -- Standard IN Parameters :
431 -- p_api_version IN NUMBER Required
432 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
433 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
434 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
435 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
436 -- p_module_type IN VARCHAR2 Required, default NULL
437
438 -- Standard OUT Parameters :
439 -- x_return_status OUT VARCHAR2 Required
440 -- x_msg_count OUT NUMBER Required
441 -- x_msg_data OUT VARCHAR2 Required
442 --
443 -- Procedure Parameters :
444 -- p_operation_number IN VARCHAR2,
445 -- p_operation_revision IN NUMBER,
446 -- p_operation_id IN NUMBER,
447 -- p_resource_id IN NUMBER,
448 -- p_resource_name IN VARCHAR2,
449 --- p_x_alt_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type Required
450 --
451 -- Version :
452 -- Initial Version 1.0
453 --
454 -- End of Comments --
455 /*#
456 * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
457 * @param p_api_version API Version Number.
458 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
459 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
460 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461 * @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
462 * @param p_module_type For Internal use only, should always be NULL, default value NULL
463 * @param x_return_status API Return status. Standard API parameter
464 * @param x_msg_count API Return message count, if any. Standard API parameter
465 * @param x_msg_data API Return message data, if any. Standard API parameter
466 * @param p_operation_number Operation number of the Operation to which the resource is associated
467 * @param p_operation_revision Operation revision of the Operation to which the resource is associated
468 * @param p_operation_id Operation id of the Operation to which the resource is associated
469 * @param p_resource_id Resource Id of the resource to be associated
470 * @param p_resource_name Resource Name of the resource to be associated
471 * @param p_x_alt_resource_tbl Alternate resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type
472 * @rep:scope public
473 * @rep:lifecycle active
474 * @rep:displayname Process Operation Alternate Resource
475 */
476 PROCEDURE Process_Oper_Alt_Resources
477 (
478 -- standard IN params
479 p_api_version IN NUMBER,
480 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
481 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
482 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
483 p_default IN VARCHAR2 :=FND_API.G_FALSE,
484 p_module_type IN VARCHAR2 :=NULL,
485 -- standard OUT params
486 x_return_status OUT NOCOPY VARCHAR2,
487 x_msg_count OUT NOCOPY NUMBER,
488 x_msg_data OUT NOCOPY VARCHAR2,
489 -- procedure params
490 p_operation_number IN VARCHAR2,
491 p_operation_revision IN NUMBER,
492 p_operation_id IN NUMBER,
493 p_resource_id IN NUMBER,
494 p_resource_name IN VARCHAR2,
495 p_x_alt_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type
496 );
497
498 END AHL_RM_OPERATION_PUB;
499