1 package EAM_OPERATIONS_JSP AS
2 /* $Header: EAMOPSJS.pls 120.1 2005/05/30 12:05:31 appldev $
3 $Author: mkishore $ */
4
5 -- Author : YULIN
6 -- Created : 7/23/01 2:58:14 PM
7 -- Purpose : API for handover in JSP pages
8
9 -- Standard who
10 g_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
11 g_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
12 g_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
13 g_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
14 g_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
15 g_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
16
17 -------------------------------------------------------------------------
18 -- Procedure to check whether the handover operation is being
19 -- conducted properly or not , i.e. all previous ops are completed
20 -- Bug fix # 2113203 - baroy
21 -------------------------------------------------------------------------
22 procedure handover_validate
23 ( p_wip_entity_id IN NUMBER,
24 p_operation_sequence_number IN NUMBER,
25 p_organization_id IN NUMBER,
26 x_return_stat OUT NOCOPY NUMBER
27 );
28
29
30 -- removed procedure charge_resource_validate
31
32 -------------------------------------------------------------------------
33 -- Procedure to check whether the assign employee operation is being
34 -- conducted on a completed or uncompleted operation
35 -- Bug fix # 2130980 - baroy
36 -------------------------------------------------------------------------
37 procedure assign_employee_validate
38 ( p_wip_entity_id IN NUMBER,
39 p_operation_sequence_number IN NUMBER,
40 p_organization_id IN NUMBER,
41 x_return_stat OUT NOCOPY NUMBER
42 );
43
44
45
46 -------------------------------------------------------------------------
47 -- Procedure to check whether the complete/uncomplete operation is being
48 -- conducted after taking into account the operation dependancies or not
49 -- Bug fix # 2130980 - baroy
50 -------------------------------------------------------------------------
51 procedure complete_uncomplete_validate
52 ( p_wip_entity_id IN NUMBER,
53 p_operation_sequence_number IN NUMBER,
54 p_organization_id IN NUMBER,
55 x_return_stat OUT NOCOPY NUMBER
56 );
57
58
59 --------------------------------------------------------------------------
60 -- A wrapper to the operation completion logic, cache the return status
61 -- and convert it the the message that can be accepted by JSP pages
62 --------------------------------------------------------------------------
63 procedure complete_operation
64 ( p_api_version IN NUMBER := 1.0
65 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
68 ,p_record_version_number IN NUMBER := NULL
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_wip_entity_id IN NUMBER -- data
73 ,p_operation_seq_num IN NUMBER
74 ,p_actual_start_date IN DATE
75 ,p_actual_end_date IN DATE
76 ,p_actual_duration IN NUMBER
77 ,p_transaction_date IN DATE
78 ,p_transaction_type IN NUMBER
79 ,p_shutdown_start_date IN DATE
80 ,p_shutdown_end_date IN DATE
81 ,p_reconciliation_code IN VARCHAR2
82 ,p_stored_last_update_date IN DATE -- old update date, for locking only
83 ,p_qa_collection_id IN NUMBER DEFAULT NULL
84 ,p_vendor_id IN NUMBER := NULL
85 ,p_vendor_site_id IN NUMBER := NULL
86 ,p_vendor_contact_id IN NUMBER := NULL
87 ,p_reason_id IN NUMBER := NULL
88 ,p_reference IN VARCHAR2 := NULL
89 ,p_attribute_category IN VARCHAR2 := NULL
90 ,p_attribute1 IN VARCHAR2 := NULL
91 ,p_attribute2 IN VARCHAR2 := NULL
92 ,p_attribute3 IN VARCHAR2 := NULL
93 ,p_attribute4 IN VARCHAR2 := NULL
94 ,p_attribute5 IN VARCHAR2 := NULL
95 ,p_attribute6 IN VARCHAR2 := NULL
96 ,p_attribute7 IN VARCHAR2 := NULL
97 ,p_attribute8 IN VARCHAR2 := NULL
98 ,p_attribute9 IN VARCHAR2 := NULL
99 ,p_attribute10 IN VARCHAR2 := NULL
100 ,p_attribute11 IN VARCHAR2 := NULL
101 ,p_attribute12 IN VARCHAR2 := NULL
102 ,p_attribute13 IN VARCHAR2 := NULL
103 ,p_attribute14 IN VARCHAR2 := NULL
104 ,p_attribute15 IN VARCHAR2 := NULL
105 );
106
107 ------------------------------------------------------------------------------------
108 -- performing operation handover for jsp pages
109 -- use the column last_update_date for optimistic locking
110 -- Fix for Bug 2205400- Populate Actual End Date and Duration during handover
111 -- Changed the call to the API .
112 ------------------------------------------------------------------------------------
113 procedure operation_handover
114 ( p_api_version IN NUMBER := 1.0
115 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
116 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
117 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
118 ,p_record_version_number IN NUMBER := NULL
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 ,p_wip_entity_id IN NUMBER -- data
123 ,p_old_op_seq_num IN NUMBER
124 ,p_new_op_seq_num IN NUMBER
125 ,p_description IN VARCHAR2
126 ,p_assigned_department IN VARCHAR2
127 ,p_start_date IN DATE
128 ,p_completion_date IN DATE
129 ,p_shutdown_type IN NUMBER -- old update date, for locking only
130 ,p_stored_last_update_date IN DATE
131 ,p_duration IN NUMBER
132 ,p_reconciliation_value IN VARCHAR2
133 );
134
135 -----------------------------------------------------------------------------------------
136 -- copy the operation network data for the new operation
137 -----------------------------------------------------------------------------------------
138 procedure copy_operation_network
139 (
140 p_wip_entity_id IN NUMBER -- data
141 ,p_old_op_seq_num IN NUMBER
142 ,p_new_op_seq_num IN NUMBER
143 ,p_operation_start_date IN DATE
144 ,p_operation_completion_date IN DATE
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ) ;
147
148 ---------------------------------------------------------------------------------------
149 -- handover the selected resources of one operation
150 ---------------------------------------------------------------------------------------
151 procedure operation_handover_resource
152 ( p_api_version IN NUMBER := 1.0
153 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
154 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
155 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
156 ,p_record_version_number IN NUMBER := NULL
157 ,x_return_status OUT NOCOPY VARCHAR2
158 ,x_msg_count OUT NOCOPY NUMBER
159 ,x_msg_data OUT NOCOPY VARCHAR2
160 ,p_wip_entity_id IN NUMBER -- data
161 ,p_old_op_seq_num IN NUMBER
162 ,p_resource_seq_num IN NUMBER
163 ,p_new_op_seq_num IN NUMBER
164 ,p_department IN VARCHAR2
165 ,p_start_date IN DATE
166 ,p_duration IN NUMBER
167 ,p_new_op_start_date IN DATE
168 ,p_new_op_end_date IN DATE
169 ,p_employee_id IN NUMBER
170 ,p_complete_rollback IN VARCHAR2 := FND_API.G_FALSE -- Added parameter to handle rollback for Mobile Handover Page.
171 );
172
173 -------------------------------------------------------------------------
174 -- Procedure to validate insertion of Resource to an Operation in JSP
175 -- Used in Resources Page
176 -- Author : amondal
177 -------------------------------------------------------------------------
178 procedure validate_insert (p_wip_entity_id IN NUMBER
179 ,p_operation_seq_num IN NUMBER
180 ,p_department_code IN VARCHAR2
181 ,p_organization_id IN NUMBER
182 ,p_resource_code IN VARCHAR2
183 ,p_uom_code IN VARCHAR2
184 ,p_usage_rate IN NUMBER
185 ,p_assigned_units IN NUMBER
186 ,p_start_date IN DATE
187 ,p_end_date IN DATE
188 ,p_activity IN VARCHAR2
189 ,x_uom_status OUT NOCOPY NUMBER
190 ,x_operation_status OUT NOCOPY NUMBER
191 ,x_department_status OUT NOCOPY NUMBER
192 ,x_res_status OUT NOCOPY NUMBER
193 ,x_usage_status OUT NOCOPY NUMBER
194 ,x_assigned_units OUT NOCOPY NUMBER
195 ,x_assigned OUT NOCOPY NUMBER
196 ,x_dates OUT NOCOPY NUMBER
197 ,x_activity OUT NOCOPY NUMBER) ;
198
199 --------------------------------------------------------------------------
200 -- Procedure to add a Resource to an Operation
201 -- Used in Resources Page
202 -- Author : amondal
203 --------------------------------------------------------------------------
204 procedure insert_into_wor( p_api_version IN NUMBER
205 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
206 ,p_commit IN VARCHAR2 := fnd_api.g_false
207 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
208 ,p_wip_entity_id IN NUMBER
209 ,p_operation_seq_num IN NUMBER
210 ,p_organization_id IN NUMBER
211 ,p_usage_rate IN NUMBER
212 ,p_resource_code IN VARCHAR2
213 ,p_uom_code IN VARCHAR2
214 ,p_resource_seq_num IN NUMBER
215 ,p_dept_code IN VARCHAR2
216 ,p_assigned_units IN NUMBER
217 ,p_basis IN NUMBER
218 ,p_scheduled_flag IN NUMBER
219 ,p_charge_type IN NUMBER
220 ,p_schedule_sequence IN NUMBER
221 ,p_std_rate IN VARCHAR2
222 ,p_start_date IN DATE
223 ,p_end_date IN DATE
224 ,p_activity IN VARCHAR2
225 ,p_mod IN VARCHAR2 DEFAULT NULL
226 ,x_update_status OUT NOCOPY NUMBER
227 ,x_return_status OUT NOCOPY VARCHAR2
228 ,x_msg_count OUT NOCOPY NUMBER
229 ,x_msg_data OUT NOCOPY VARCHAR2);
230
231 ----------------------------------------------------------------------------
232 -- Procedure to validate materials added to an operation
233 -- Used in Add Materials Page
234 -- Author : amondal
235 ----------------------------------------------------------------------------
236 PROCEDURE material_validate (
237 p_organization_id IN NUMBER
238 ,p_wip_entity_id IN NUMBER
239 ,p_description IN VARCHAR2
240 ,p_uom IN VARCHAR2
241 ,p_concatenated_segments IN VARCHAR2
242 ,p_operation_seq_num IN VARCHAR2
243 ,p_department_code IN VARCHAR2
244 ,p_supply IN VARCHAR2
245 ,p_subinventory_code IN VARCHAR2
246 ,p_locator IN VARCHAR2
247 ,x_invalid_asset OUT NOCOPY NUMBER
248 ,x_invalid_description OUT NOCOPY NUMBER
249 ,x_invalid_uom OUT NOCOPY NUMBER
250 ,x_invalid_subinventory OUT NOCOPY NUMBER
251 ,x_invalid_locator OUT NOCOPY NUMBER
252 ,x_invalid_department OUT NOCOPY NUMBER
253 ,x_invalid_operation OUT NOCOPY NUMBER
254 ,x_invalid_supply OUT NOCOPY NUMBER
255 );
256
257 ---------------------------------------------------------------------------
258 -- Procedure to add materials to an operation
259 -- Used in Add Materials Page
260 -- Author : amondal
261 ---------------------------------------------------------------------------
262 PROCEDURE insert_into_wro(
263 p_api_version IN NUMBER
264 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
265 ,p_commit IN VARCHAR2 := fnd_api.g_false
266 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
267 ,p_wip_entity_id IN NUMBER
268 ,p_organization_id IN NUMBER
269 ,p_concatenated_segments IN VARCHAR2
270 ,p_description IN VARCHAR2
271 ,p_operation_seq_num IN NUMBER
272 ,p_supply IN VARCHAR2
273 ,p_required_date IN DATE
274 ,p_quantity IN NUMBER
275 ,p_comments IN VARCHAR2
276 ,p_supply_subinventory IN VARCHAR2
277 ,p_locator IN VARCHAR2
278 ,p_mrp_net_flag IN VARCHAR2
279 ,p_material_release IN VARCHAR2
280 ,x_invalid_update_operation OUT NOCOPY NUMBER
281 ,x_invalid_update_department OUT NOCOPY NUMBER
282 ,x_invalid_update_description OUT NOCOPY NUMBER
283 ,x_return_status OUT NOCOPY VARCHAR2
284 ,x_msg_count OUT NOCOPY NUMBER
285 ,x_msg_data OUT NOCOPY VARCHAR2
286 ,x_update_status OUT NOCOPY NUMBER
287 ,p_supply_code IN NUMBER :=NULL
288 ,p_one_step_issue IN varchar2:=fnd_api.g_false /*To identify the call from one step issue page */
289 ,p_released_quantity IN NUMBER := NULL --added for bug 3572280
290 );
291
292 ----------------------------------------------------------------------
293 -- Procedure tp delete materials from an operation
294 -- Used in Add Materials Page
295 -- Author : amondal
296 ----------------------------------------------------------------------
297 PROCEDURE delete_resources (
298 p_api_version IN NUMBER
299 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
300 ,p_commit IN VARCHAR2 := fnd_api.g_false
301 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
302 ,p_wip_entity_id IN NUMBER
303 ,p_operation_seq_num IN NUMBER
304 ,p_resource_seq_num IN NUMBER
305 ,x_return_status OUT NOCOPY VARCHAR2
306 ,x_msg_count OUT NOCOPY NUMBER
307 ,x_msg_data OUT NOCOPY VARCHAR2);
308
312 -- Author : rethakur
309 --------------------------------------------------------------------------
310 -- Procedure to add an operation to a work order
311 -- Used in Operations Page
313 --------------------------------------------------------------------------
314 procedure insert_into_wo ( p_wip_entity_id IN NUMBER
315 ,p_operation_seq_num IN NUMBER
316 ,p_standard_operation_id IN NUMBER
317 ,p_organization_id IN NUMBER
318 ,p_description IN VARCHAR2
319 ,p_department_id IN NUMBER
320 ,p_shutdown_type IN VARCHAR2
321 ,p_first_unit_start_date IN VARCHAR2
322 ,p_last_unit_completion_date IN VARCHAR2
323 ,p_duration IN NUMBER
324 ,p_long_description IN VARCHAR2 := null
325 ,x_return_status OUT NOCOPY NUMBER
326 ,x_msg_count OUT NOCOPY NUMBER );
327
328 --------------------------------------------------------------------------
329 -- Procedure to validate standard operation
330 -- Used in Operations Page
331 -- Author : rethakur
332 --------------------------------------------------------------------------
333 procedure validate_std_operation ( p_organization_id IN NUMBER
334 ,p_operation_code IN VARCHAR2
335 ,x_standard_operation_id OUT NOCOPY NUMBER
336 ,x_department_id OUT NOCOPY NUMBER
337 ,x_shutdown_type OUT NOCOPY VARCHAR2
338 ,x_return_status OUT NOCOPY NUMBER);
339
340 --------------------------------------------------------------------------
341 -- Procedure to validate shutdown type
342 -- Used in Operations Page
343 -- Author : rethakur
344 --------------------------------------------------------------------------
345 procedure validate_shutdown_type (p_meaning IN VARCHAR2
346 ,x_lookup_code OUT NOCOPY NUMBER
347 ,x_return_status OUT NOCOPY NUMBER);
348
349 --------------------------------------------------------------------------
350 -- Procedure to validate department
351 -- Used in Operations Page
352 -- Author : rethakur
353 --------------------------------------------------------------------------
354 procedure validate_dept (p_wip_entity_id IN NUMBER
355 ,p_operation_seq_num IN NUMBER
356 ,p_organization_id IN NUMBER
357 ,p_department_code IN VARCHAR2
358 ,x_department_id OUT NOCOPY NUMBER
359 ,x_return_status OUT NOCOPY NUMBER);
360
361 --------------------------------------------------------------------------
362 -- Procedure to update operations in wip_operations
363 -- Used in Operations Page
364 -- Author : rethakur
365 --------------------------------------------------------------------------
366 procedure update_wo ( p_wip_entity_id IN NUMBER
367 ,p_operation_seq_num IN NUMBER
368 ,p_organization_id IN NUMBER
369 ,p_description IN VARCHAR2
370 ,p_shutdown_type IN VARCHAR2
371 ,p_first_unit_start_date IN VARCHAR2
372 ,p_last_unit_completion_date IN VARCHAR2
373 ,p_duration IN NUMBER
377
374 ,p_long_description IN VARCHAR2 := null
375 ,x_return_status OUT NOCOPY NUMBER
376 ,x_msg_count OUT NOCOPY NUMBER ) ;
378 /*--------------------------------------------------------------------------
379 -- Validation API for new link between operaions in
380 -- Dependency definitions
381 --------------------------------------------------------------------------*/
382 PROCEDURE validate_new_link(
383 p_from_operation IN NUMBER,
384 p_to_operation IN NUMBER,
385 p_dep_direction IN NUMBER,
386 p_wip_entity_id IN NUMBER,
387 p_sche_start_date IN DATE,
388 p_sche_end_date IN DATE,
389 x_error_flag OUT NOCOPY VARCHAR2,
390 x_error_mssg OUT NOCOPY VARCHAR2 ) ;
391
392 /*--------------------------------------------------------------------------
393 -- API for creating new link between operaions in
394 -- Dependency definitions
395 --------------------------------------------------------------------------*/
396 PROCEDURE create_new_link(p_from_operation IN NUMBER,
397 p_to_operation IN NUMBER,
398 p_dep_direction IN NUMBER,
399 p_wip_entity_id IN NUMBER,
400 p_organization_id IN NUMBER,
401 p_user_id IN NUMBER,
402 p_sche_start_date IN DATE,
403 p_sche_end_date IN DATE,
404 x_error_flag OUT NOCOPY VARCHAR2,
405 x_error_mssg OUT NOCOPY VARCHAR2 );
406
407
408
409 /*--------------------------------------------------------------------------
410 -- API for creating new link between operaions in
411 -- Dependency definitions
412 --------------------------------------------------------------------------*/
413 PROCEDURE delete_link(p_from_operation IN NUMBER,
414 p_to_operation IN NUMBER,
415 p_dep_direction IN NUMBER,
416 p_wip_entity_id IN NUMBER,
417 p_organization_id IN NUMBER,
418 p_user_id IN NUMBER,
419 x_error_flag OUT NOCOPY VARCHAR2,
420 x_error_mssg OUT NOCOPY VARCHAR2 );
421
422 /*-------------------------------------------------------------------------
423 -- API for calling the scheduler (finite or infinite) when the relevant
424 -- fields in operations or resources are changed.
425 -------------------------------------------------------------------------*/
426 PROCEDURE schedule_workorders(p_organization_id IN NUMBER,
427 p_wip_entity_id IN NUMBER);
428
429 /*-------------------------------------------------------------------------
430 -- API for geting the operation_seq_num and the department_code
431 -- for the wip_entity_id.
432 -------------------------------------------------------------------------*/
433 PROCEDURE count_op_seq_num(p_organization_id IN NUMBER,
434 p_wip_entity_id IN NUMBER,
435 op_seq_num OUT NOCOPY NUMBER,
436 op_dept_code OUT NOCOPY VARCHAR2,
437 op_count OUT NOCOPY NUMBER,
438 l_return_status OUT NOCOPY VARCHAR2,
439 l_msg_data OUT NOCOPY VARCHAR2,
440 l_msg_count OUT NOCOPY NUMBER);
441 /*-------------------------------------------------------------------------
442 -- API for geting the operation_seq_num,the department_code and start/end dates
443 -- of operation for a given wip entity id. Added for bug#3544893
444 -------------------------------------------------------------------------*/
445 PROCEDURE default_operation (p_organization_id IN NUMBER,
446 p_wip_entity_id IN NUMBER,
447 x_op_seq_num OUT NOCOPY NUMBER,
448 x_op_dept_code OUT NOCOPY VARCHAR2,
449 x_op_count OUT NOCOPY NUMBER,
450 x_op_start_date OUT NOCOPY DATE,
451 x_op_end_date OUT NOCOPY DATE,
452 x_return_status OUT NOCOPY VARCHAR2,
453 x_msg_data OUT NOCOPY VARCHAR2,
454 x_msg_count OUT NOCOPY NUMBER);
455
456
457 /* ------------------------------------------------------------------------
458 API for checking whether the resources associated with a work order and
459 an operation are available in the department chosen.
460 --------------------------------------------------------------------------*/
461
462 PROCEDURE handover_department_validate(p_wip_entity_id IN NUMBER,
463 p_operation_seq_num IN NUMBER,
464 p_department IN VARCHAR2,
465 p_organization_id IN NUMBER,
466 p_resource_code IN VARCHAR2,
467 x_return_status OUT NOCOPY NUMBER);
468
469
470 /* ------------------------------------------------------------------------
471 API for checking whether the operation for a particular work order can be deleted
472 --------------------------------------------------------------------------*/
473
474
475 PROCEDURE check_op_deletion(p_wip_entity_id IN NUMBER,
476 p_operation_seq_num IN NUMBER,
477 x_return_status OUT NOCOPY NUMBER) ;
478
479
480 /* ------------------------------------------------------------------------
481 API for deeting operation from self service side
482 --------------------------------------------------------------------------*/
483
484 PROCEDURE delete_operation (
485 p_api_version IN NUMBER := 1.0
486 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
487 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
488 ,p_organization_id IN NUMBER
489 ,p_wip_entity_id IN NUMBER
490 ,p_operation_seq_num IN NUMBER
491 ,p_department_id IN NUMBER
492 ,x_return_status OUT NOCOPY VARCHAR2
493 ,x_msg_count OUT NOCOPY NUMBER
494 ,x_msg_data OUT NOCOPY VARCHAR2
495 );
496
497 /*---------------------------------------------------------------------------
498 API for updating/deleting material used in one step issue page
499 -----------------------------------------------------------------------------*/
500 PROCEDURE update_wro
501 (
502 p_commit IN VARCHAR2 := FND_API.G_FALSE
503 ,p_organization_id IN NUMBER
504 ,p_wip_entity_id IN NUMBER
505 ,p_operation_seq_num IN NUMBER
506 ,p_inventory_item_id IN NUMBER
507 ,p_update IN NUMBER
508 ,p_required_qty IN NUMBER
509 ,x_return_status OUT NOCOPY VARCHAR2
510 ,x_msg_count OUT NOCOPY NUMBER
511 ,x_msg_data OUT NOCOPY VARCHAR2
512 );
513
514
515 /*---------------------------------------------------------------------------
516 API for deleting instances . Call to WO API incorporated.
517 -----------------------------------------------------------------------------*/
518
519 PROCEDURE delete_instance (
520 p_api_version IN NUMBER
521 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
522 ,p_commit IN VARCHAR2 := fnd_api.g_false
523 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
524 ,p_wip_entity_id IN NUMBER
525 ,p_organization_id IN NUMBER
526 ,p_operation_seq_num IN NUMBER
527 ,p_resource_seq_num IN NUMBER
528 ,p_instance_id IN NUMBER
529 ,x_return_status OUT NOCOPY VARCHAR2
530 ,x_msg_count OUT NOCOPY NUMBER
531 ,x_msg_data OUT NOCOPY VARCHAR2) ;
532
533 end EAM_OPERATIONS_JSP;