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