1 PACKAGE AHL_RM_OPERATION_PUB AS
2 /* $Header: AHLPOPES.pls 120.0.12000000.2 2007/10/18 13:28:19 adivenka 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, default 1.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.
53 * @param p_api_version API Version Number.
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
56 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
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 -- Start of Comments --
93 --
94 -- Procedure name : Modify_Operation
95 -- Type : Public
96 -- Function : API to modify Operation details and its associations to documents, resources,
97 -- resource costing parameters, access panels and materials.
98 -- Pre-reqs :
99 --
100 -- Standard IN Parameters :
101 -- p_api_version IN NUMBER Required, default 1.0
102 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
103 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
104 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
105 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
106 -- p_module_type IN VARCHAR2 Required, default NULL
107
108 -- Standard OUT Parameters :
109 -- x_return_status OUT VARCHAR2 Required
110 -- x_msg_count OUT NUMBER Required
111 -- x_msg_data OUT VARCHAR2 Required
112 --
113 -- Procedure Parameters :
114 -- p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type Required
115 -- p_x_oper_doc_tbl IN OUT AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl
116 -- p_x_oper_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type
117 -- p_x_oper_material_tbl IN OUT AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
118 -- p_x_oper_panel_tbl IN OUT AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
119 --
120 -- Version :
121 -- Initial Version 1.0
122 --
123 -- End of Comments --
124 /*#
125 * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
126 * @param p_api_version API Version Number.
127 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
128 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
129 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130 * @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
131 * @param p_module_type For Internal use only, should always be NULL, default value NULL
132 * @param x_return_status API Return status. Standard API parameter
133 * @param x_msg_count API Return message count, if any. Standard API parameter
134 * @param x_msg_data API Return message data, if any. Standard API parameter
135 * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
136 * @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
137 * @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
138 * @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
139 * @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
140 * @rep:scope public
141 * @rep:lifecycle active
142 * @rep:displayname Modify Operation
143 */
144 PROCEDURE Modify_Operation
145 (
146 -- standard IN params
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
149 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
150 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
151 p_default IN VARCHAR2 :=FND_API.G_FALSE,
152 p_module_type IN VARCHAR2 :=NULL,
153 -- standard OUT params
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 -- procedure params
158 p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type,
159 p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
160 p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
161 p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
162 p_x_oper_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
163 );
164
165 -- Start of Comments --
166 --
167 -- Procedure name : Delete_Operation
168 -- Type : Public
169 -- Function : API to deletion of operations. All associations to documents, resources,
170 -- resource costing parameters and materials are also deleted.
171 -- Pre-reqs :
172 --
173 -- Standard IN Parameters :
174 -- p_api_version IN NUMBER Required, default 1.0
175 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
176 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
177 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
178 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
179 -- p_module_type IN VARCHAR2 Required, default NULL
180
181 -- Standard OUT Parameters :
182 -- x_return_status OUT VARCHAR2 Required
183 -- x_msg_count OUT NUMBER Required
184 -- x_msg_data OUT VARCHAR2 Required
185 --
186 -- Procedure Parameters :
187 -- p_oper_id IN NUMBER Required
188 -- p_oper_number IN VARCHAR2 Required
189 -- p_oper_revision IN NUMBER Required
190 -- p_oper_object_version IN NUMBER Required
191 --
192 -- Version :
193 -- Initial Version 1.0
194 --
195 -- End of Comments --
196 /*#
197 * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
198 * @param p_api_version API Version Number.
199 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
200 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
201 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202 * @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
203 * @param p_module_type For Internal use only, should always be NULL, default value NULL
204 * @param x_return_status API Return status. Standard API parameter
205 * @param x_msg_count API Return message count, if any. Standard API parameter
206 * @param x_msg_data API Return message data, if any. Standard API parameter
207 * @param p_oper_id Operation unique identifier
208 * @param p_oper_number Operation number
209 * @param p_oper_revision Operation revision number
210 * @param p_oper_object_version Operation object version number
211 * @rep:scope public
212 * @rep:lifecycle active
213 * @rep:displayname Delete Operation
214 */
215 PROCEDURE Delete_Operation
216 (
217 -- standard IN params
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
220 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
221 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
222 p_default IN VARCHAR2 :=FND_API.G_FALSE,
223 p_module_type IN VARCHAR2 :=NULL,
224 -- standard OUT params
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 -- procedure params
229 p_oper_id IN NUMBER,
230 p_oper_number IN VARCHAR2,
231 p_oper_revision IN NUMBER,
232 p_oper_object_version IN NUMBER
233 );
234
235 -- Start of Comments --
236 --
237 -- Procedure name : Create_Oper_Revision
238 -- Type : Public
239 -- Function : API to create a new revision of a Operation.
240 -- Pre-reqs :
241 --
242 -- Standard IN Parameters :
243 -- p_api_version IN NUMBER Required, default 1.0
244 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
245 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
246 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
247 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
248 -- p_module_type IN VARCHAR2 Required, default NULL
249
250 -- Standard OUT Parameters :
251 -- x_return_status OUT VARCHAR2 Required
252 -- x_msg_count OUT NUMBER Required
253 -- x_msg_data OUT VARCHAR2 Required
254 --
255 -- Procedure Parameters :
256 -- p_oper_id IN NUMBER Required
257 -- p_oper_number IN VARCHAR2 Required
258 -- p_oper_revision IN NUMBER Required
259 -- p_oper_object version IN NUMBER Required
260 -- x_new_operation_id OUT NUMBER Required
261 --
262 -- Version :
263 -- Initial Version 1.0
264 --
265 -- End of Comments --
266 /*#
267 * Use this procedure to create a new revision of an existing and completed Operation.
268 * @param p_api_version API Version Number.
269 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
270 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
271 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272 * @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
273 * @param p_module_type For Internal use only, should always be NULL, default value NULL
274 * @param x_return_status API Return status. Standard API parameter
275 * @param x_msg_count API Return message count, if any. Standard API parameter
276 * @param x_msg_data API Return message data, if any. Standard API parameter
277 * @param p_oper_id Operation unique identifier
278 * @param p_oper_number Operation number
279 * @param p_oper_revision Operation revision number
280 * @param p_oper_object_version Operation object version number
281 * @param x_new_oper_id Unique identifier of the new revision of the Operation
282 * @rep:scope public
283 * @rep:lifecycle active
284 * @rep:displayname Create Operation Revision
285 */
286 PROCEDURE Create_Oper_Revision
287 (
288 -- standard IN params
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
291 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
292 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
293 p_default IN VARCHAR2 :=FND_API.G_FALSE,
294 p_module_type IN VARCHAR2 :=NULL,
295 -- standard OUT params
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 -- procedure params
300 p_oper_id IN NUMBER,
301 p_oper_number IN VARCHAR2,
302 p_oper_revision IN NUMBER,
303 p_oper_object_version IN NUMBER,
304 x_new_oper_id OUT NOCOPY NUMBER
305 );
306
307 -- Start of Comments --
308 --
309 -- Procedure name : Initiate_Oper_Approval
310 -- Type : Public
311 -- Function : API to submit a Operation to complete / terminate approval workflows.
312 -- Pre-reqs :
313 --
314 -- Standard IN Parameters :
315 -- p_api_version IN NUMBER Required, default 1.0
316 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
317 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
318 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
319 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
320 -- p_module_type IN VARCHAR2 Required, default NULL
321
322 -- Standard OUT Parameters :
323 -- x_return_status OUT VARCHAR2 Required
324 -- x_msg_count OUT NUMBER Required
325 -- x_msg_data OUT VARCHAR2 Required
326 --
327 -- Procedure Parameters :
328 -- p_oper_id IN NUMBER Required
329 -- p_oper_number IN VARCHAR2 Required
330 -- p_oper_revision IN NUMBER Required
331 -- p_oper_object_version IN NUMBER Required
332 -- p_apprv_type IN VARCHAR2 Required, default 'COMPLETE'
333 --
334 -- Version :
335 -- Initial Version 1.0
336 --
337 -- End of Comments --
338 /*#
339 * Use this procedure to submit an Operation for Completion or Termination approval workflows.
340 * @param p_api_version API Version Number.
341 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
342 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
343 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344 * @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
345 * @param p_module_type For Internal use only, should always be NULL, default value NULL
346 * @param x_return_status API Return status. Standard API parameter
347 * @param x_msg_count API Return message count, if any. Standard API parameter
348 * @param x_msg_data API Return message data, if any. Standard API parameter
349 * @param p_oper_id Operation unique identifier
350 * @param p_oper_number Operation number
351 * @param p_oper_revision Operation revision number
352 * @param p_oper_object_version Operation object version number
353 * @param p_apprv_type Approval type, one of 'COMPLETE' and 'TERMINATE', default is 'COMPLETE'
354 * @rep:scope public
355 * @rep:lifecycle active
356 * @rep:displayname Initiate Operation Approval
357 */
358 PROCEDURE Initiate_Oper_Approval
359 (
360 -- standard IN params
361 p_api_version IN NUMBER,
362 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
363 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
364 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
365 p_default IN VARCHAR2 :=FND_API.G_FALSE,
366 p_module_type IN VARCHAR2 :=NULL,
367 -- standard OUT params
368 x_return_status OUT NOCOPY VARCHAR2,
369 x_msg_count OUT NOCOPY NUMBER,
370 x_msg_data OUT NOCOPY VARCHAR2,
371 -- procedure params
372 p_oper_id IN NUMBER,
373 p_oper_number IN VARCHAR2,
374 p_oper_revision IN NUMBER,
375 p_oper_object_version IN NUMBER,
376 p_apprv_type IN VARCHAR2 :='COMPLETE'
377 );
378
379 -- Start of Comments --
380 --
381 -- Procedure name : Process_Oper_Alt_Resources
382 -- Type : Public
383 -- Function : API to process alternate resources for operations.
384 -- Pre-reqs :
385 --
386 -- Standard IN Parameters :
387 -- p_api_version IN NUMBER Required, default 1.0
388 -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
389 -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
390 -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
391 -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
392 -- p_module_type IN VARCHAR2 Required, default NULL
393
394 -- Standard OUT Parameters :
395 -- x_return_status OUT VARCHAR2 Required
396 -- x_msg_count OUT NUMBER Required
397 -- x_msg_data OUT VARCHAR2 Required
398 --
399 -- Procedure Parameters :
400 -- p_operation_number IN VARCHAR2,
401 -- p_operation_revision IN NUMBER,
402 -- p_operation_id IN NUMBER,
403 -- p_resource_id IN NUMBER,
404 -- p_resource_name IN VARCHAR2,
405 --- p_x_alt_resource_tbl IN OUT AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type Required
406 --
407 -- Version :
408 -- Initial Version 1.0
409 --
410 -- End of Comments --
411 /*#
412 * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
413 * @param p_api_version API Version Number.
414 * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
415 * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
416 * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417 * @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
418 * @param p_module_type For Internal use only, should always be NULL, default value NULL
419 * @param x_return_status API Return status. Standard API parameter
420 * @param x_msg_count API Return message count, if any. Standard API parameter
421 * @param x_msg_data API Return message data, if any. Standard API parameter
422 * @param p_operation_number Operation number of the Operation to which the resource is associated
423 * @param p_operation_revision Operation revision of the Operation to which the resource is associated
424 * @param p_operation_id Operation id of the Operation to which the resource is associated
425 * @param p_resource_id Resource Id of the resource to be associated
426 * @param p_resource_name Resource Name of the resource to be associated
427 * @param p_x_alt_resource_tbl Alternate resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type
428 * @rep:scope public
429 * @rep:lifecycle active
430 * @rep:displayname Process Operation Alternate Resource
431 */
432 PROCEDURE Process_Oper_Alt_Resources
433 (
434 -- standard IN params
435 p_api_version IN NUMBER,
436 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
437 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
438 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
439 p_default IN VARCHAR2 :=FND_API.G_FALSE,
440 p_module_type IN VARCHAR2 :=NULL,
441 -- standard OUT params
442 x_return_status OUT NOCOPY VARCHAR2,
443 x_msg_count OUT NOCOPY NUMBER,
444 x_msg_data OUT NOCOPY VARCHAR2,
445 -- procedure params
446 p_operation_number IN VARCHAR2,
447 p_operation_revision IN NUMBER,
448 p_operation_id IN NUMBER,
449 p_resource_id IN NUMBER,
450 p_resource_name IN VARCHAR2,
451 p_x_alt_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type
452 );
453
454 END AHL_RM_OPERATION_PUB;
455
[Home] [Help]