1 package EAM_OPERATIONS_JSP AUTHID CURRENT_USER AS
2 /* $Header: EAMOPSJS.pls 120.2 2011/06/29 10:40:15 vpasupur ship $
3 $Author: vpasupur $ */
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 */
292 --Start of bug 12631479
289 ,p_released_quantity IN NUMBER := NULL --added for bug 3572280
290 );
291
293 --This procedure is not called in R12.This was added to maintain the dual check between R12->R12.1
294 PROCEDURE insert_into_wro(
295 p_api_version IN NUMBER
296 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
297 ,p_commit IN VARCHAR2 := fnd_api.g_false
298 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
299 ,p_wip_entity_id IN NUMBER
300 ,p_organization_id IN NUMBER
301 ,p_concatenated_segments IN VARCHAR2
302 ,p_description IN VARCHAR2
303 ,p_operation_seq_num IN NUMBER
304 ,p_supply IN VARCHAR2
305 ,p_required_date IN DATE
306 ,p_quantity IN NUMBER
307 ,p_comments IN VARCHAR2
308 ,p_supply_subinventory IN VARCHAR2
309 ,p_locator IN VARCHAR2
310 ,p_mrp_net_flag IN VARCHAR2
311 ,p_material_release IN VARCHAR2
312 ,x_invalid_update_operation OUT NOCOPY NUMBER
313 ,x_invalid_update_department OUT NOCOPY NUMBER
314 ,x_invalid_update_description OUT NOCOPY NUMBER
315 ,x_return_status OUT NOCOPY VARCHAR2
316 ,x_msg_count OUT NOCOPY NUMBER
317 ,x_msg_data OUT NOCOPY VARCHAR2
318 ,x_update_status OUT NOCOPY NUMBER
319 ,p_supply_code IN NUMBER :=NULL
320 ,p_one_step_issue IN varchar2:=fnd_api.g_false /*To identify the call from one step issue page */
321 ,p_released_quantity IN NUMBER := NULL --added for bug 3572280
322 ,p_attribute_category IN VARCHAR2
323 ,p_attribute1 IN VARCHAR2
324 ,p_attribute2 IN VARCHAR2
325 ,p_attribute3 IN VARCHAR2
326 ,p_attribute4 IN VARCHAR2
327 ,p_attribute5 IN VARCHAR2
328 ,p_attribute6 IN VARCHAR2
329 ,p_attribute7 IN VARCHAR2
330 ,p_attribute8 IN VARCHAR2
331 ,p_attribute9 IN VARCHAR2
332 ,p_attribute10 IN VARCHAR2
333 ,p_attribute11 IN VARCHAR2
334 ,p_attribute12 IN VARCHAR2
335 ,p_attribute13 IN VARCHAR2
336 ,p_attribute14 IN VARCHAR2
337 ,p_attribute15 IN VARCHAR2
338
339 );
340 --End of bug 12631479
341 ----------------------------------------------------------------------
342 -- Procedure tp delete materials from an operation
343 -- Used in Add Materials Page
344 -- Author : amondal
345 ----------------------------------------------------------------------
346 PROCEDURE delete_resources (
347 p_api_version IN NUMBER
348 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
349 ,p_commit IN VARCHAR2 := fnd_api.g_false
350 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
351 ,p_wip_entity_id IN NUMBER
352 ,p_operation_seq_num IN NUMBER
353 ,p_resource_seq_num IN NUMBER
354 ,x_return_status OUT NOCOPY VARCHAR2
355 ,x_msg_count OUT NOCOPY NUMBER
356 ,x_msg_data OUT NOCOPY VARCHAR2);
357
358 --------------------------------------------------------------------------
359 -- Procedure to add an operation to a work order
360 -- Used in Operations Page
361 -- Author : rethakur
362 --------------------------------------------------------------------------
363 procedure insert_into_wo ( p_wip_entity_id IN NUMBER
364 ,p_operation_seq_num IN NUMBER
365 ,p_standard_operation_id IN NUMBER
366 ,p_organization_id IN NUMBER
367 ,p_description IN VARCHAR2
368 ,p_department_id IN NUMBER
369 ,p_shutdown_type IN VARCHAR2
370 ,p_first_unit_start_date IN VARCHAR2
371 ,p_last_unit_completion_date IN VARCHAR2
372 ,p_duration IN NUMBER
373 ,p_long_description IN VARCHAR2 := null
374 ,x_return_status OUT NOCOPY NUMBER
375 ,x_msg_count OUT NOCOPY NUMBER );
376
377 --------------------------------------------------------------------------
378 -- Procedure to validate standard operation
379 -- Used in Operations Page
380 -- Author : rethakur
381 --------------------------------------------------------------------------
382 procedure validate_std_operation ( p_organization_id IN NUMBER
383 ,p_operation_code IN VARCHAR2
384 ,x_standard_operation_id OUT NOCOPY NUMBER
385 ,x_department_id OUT NOCOPY NUMBER
386 ,x_shutdown_type OUT NOCOPY VARCHAR2
387 ,x_return_status OUT NOCOPY NUMBER);
388
389 --------------------------------------------------------------------------
390 -- Procedure to validate shutdown type
391 -- Used in Operations Page
392 -- Author : rethakur
393 --------------------------------------------------------------------------
394 procedure validate_shutdown_type (p_meaning IN VARCHAR2
395 ,x_lookup_code OUT NOCOPY NUMBER
396 ,x_return_status OUT NOCOPY NUMBER);
397
398 --------------------------------------------------------------------------
402 --------------------------------------------------------------------------
399 -- Procedure to validate department
400 -- Used in Operations Page
401 -- Author : rethakur
403 procedure validate_dept (p_wip_entity_id IN NUMBER
404 ,p_operation_seq_num IN NUMBER
405 ,p_organization_id IN NUMBER
406 ,p_department_code IN VARCHAR2
407 ,x_department_id OUT NOCOPY NUMBER
408 ,x_return_status OUT NOCOPY NUMBER);
409
410 --------------------------------------------------------------------------
411 -- Procedure to update operations in wip_operations
412 -- Used in Operations Page
413 -- Author : rethakur
414 --------------------------------------------------------------------------
415 procedure update_wo ( p_wip_entity_id IN NUMBER
416 ,p_operation_seq_num IN NUMBER
417 ,p_organization_id IN NUMBER
418 ,p_description IN VARCHAR2
419 ,p_shutdown_type IN VARCHAR2
420 ,p_first_unit_start_date IN VARCHAR2
421 ,p_last_unit_completion_date IN VARCHAR2
422 ,p_duration IN NUMBER
423 ,p_long_description IN VARCHAR2 := null
424 ,x_return_status OUT NOCOPY NUMBER
425 ,x_msg_count OUT NOCOPY NUMBER ) ;
426
427 /*--------------------------------------------------------------------------
428 -- Validation API for new link between operaions in
429 -- Dependency definitions
430 --------------------------------------------------------------------------*/
431 PROCEDURE validate_new_link(
432 p_from_operation IN NUMBER,
433 p_to_operation IN NUMBER,
434 p_dep_direction IN NUMBER,
435 p_wip_entity_id IN NUMBER,
436 p_sche_start_date IN DATE,
437 p_sche_end_date IN DATE,
438 x_error_flag OUT NOCOPY VARCHAR2,
439 x_error_mssg OUT NOCOPY VARCHAR2 ) ;
440
441 /*--------------------------------------------------------------------------
442 -- API for creating new link between operaions in
443 -- Dependency definitions
444 --------------------------------------------------------------------------*/
445 PROCEDURE create_new_link(p_from_operation IN NUMBER,
446 p_to_operation IN NUMBER,
447 p_dep_direction IN NUMBER,
448 p_wip_entity_id IN NUMBER,
449 p_organization_id IN NUMBER,
450 p_user_id IN NUMBER,
451 p_sche_start_date IN DATE,
452 p_sche_end_date IN DATE,
453 x_error_flag OUT NOCOPY VARCHAR2,
454 x_error_mssg OUT NOCOPY VARCHAR2 );
455
456
457
458 /*--------------------------------------------------------------------------
459 -- API for creating new link between operaions in
460 -- Dependency definitions
461 --------------------------------------------------------------------------*/
462 PROCEDURE delete_link(p_from_operation IN NUMBER,
463 p_to_operation IN NUMBER,
464 p_dep_direction IN NUMBER,
465 p_wip_entity_id IN NUMBER,
466 p_organization_id IN NUMBER,
467 p_user_id IN NUMBER,
468 x_error_flag OUT NOCOPY VARCHAR2,
469 x_error_mssg OUT NOCOPY VARCHAR2 );
470
471 /*-------------------------------------------------------------------------
472 -- API for calling the scheduler (finite or infinite) when the relevant
473 -- fields in operations or resources are changed.
474 -------------------------------------------------------------------------*/
475 PROCEDURE schedule_workorders(p_organization_id IN NUMBER,
476 p_wip_entity_id IN NUMBER);
477
478 /*-------------------------------------------------------------------------
479 -- API for geting the operation_seq_num and the department_code
480 -- for the wip_entity_id.
481 -------------------------------------------------------------------------*/
482 PROCEDURE count_op_seq_num(p_organization_id IN NUMBER,
483 p_wip_entity_id IN NUMBER,
484 op_seq_num OUT NOCOPY NUMBER,
485 op_dept_code OUT NOCOPY VARCHAR2,
486 op_count OUT NOCOPY NUMBER,
487 l_return_status OUT NOCOPY VARCHAR2,
488 l_msg_data OUT NOCOPY VARCHAR2,
489 l_msg_count OUT NOCOPY NUMBER);
490 /*-------------------------------------------------------------------------
491 -- API for geting the operation_seq_num,the department_code and start/end dates
492 -- of operation for a given wip entity id. Added for bug#3544893
493 -------------------------------------------------------------------------*/
494 PROCEDURE default_operation (p_organization_id IN NUMBER,
495 p_wip_entity_id IN NUMBER,
496 x_op_seq_num OUT NOCOPY NUMBER,
497 x_op_dept_code OUT NOCOPY VARCHAR2,
498 x_op_count OUT NOCOPY NUMBER,
499 x_op_start_date OUT NOCOPY DATE,
503 x_msg_count OUT NOCOPY NUMBER);
500 x_op_end_date OUT NOCOPY DATE,
501 x_return_status OUT NOCOPY VARCHAR2,
502 x_msg_data OUT NOCOPY VARCHAR2,
504
505
506 /* ------------------------------------------------------------------------
507 API for checking whether the resources associated with a work order and
508 an operation are available in the department chosen.
509 --------------------------------------------------------------------------*/
510
511 PROCEDURE handover_department_validate(p_wip_entity_id IN NUMBER,
512 p_operation_seq_num IN NUMBER,
513 p_department IN VARCHAR2,
514 p_organization_id IN NUMBER,
515 p_resource_code IN VARCHAR2,
516 x_return_status OUT NOCOPY NUMBER);
517
518
519 /* ------------------------------------------------------------------------
520 API for checking whether the operation for a particular work order can be deleted
521 --------------------------------------------------------------------------*/
522
523
524 PROCEDURE check_op_deletion(p_wip_entity_id IN NUMBER,
525 p_operation_seq_num IN NUMBER,
526 x_return_status OUT NOCOPY NUMBER) ;
527
528
529 /* ------------------------------------------------------------------------
530 API for deeting operation from self service side
531 --------------------------------------------------------------------------*/
532
533 PROCEDURE delete_operation (
534 p_api_version IN NUMBER := 1.0
535 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
536 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
537 ,p_organization_id IN NUMBER
538 ,p_wip_entity_id IN NUMBER
539 ,p_operation_seq_num IN NUMBER
540 ,p_department_id IN NUMBER
541 ,x_return_status OUT NOCOPY VARCHAR2
542 ,x_msg_count OUT NOCOPY NUMBER
543 ,x_msg_data OUT NOCOPY VARCHAR2
544 );
545
546 /*---------------------------------------------------------------------------
547 API for updating/deleting material used in one step issue page
548 -----------------------------------------------------------------------------*/
549 PROCEDURE update_wro
550 (
551 p_commit IN VARCHAR2 := FND_API.G_FALSE
552 ,p_organization_id IN NUMBER
553 ,p_wip_entity_id IN NUMBER
554 ,p_operation_seq_num IN NUMBER
555 ,p_inventory_item_id IN NUMBER
556 ,p_update IN NUMBER
557 ,p_required_qty IN NUMBER
558 ,x_return_status OUT NOCOPY VARCHAR2
559 ,x_msg_count OUT NOCOPY NUMBER
560 ,x_msg_data OUT NOCOPY VARCHAR2
561 );
562
563
564 /*---------------------------------------------------------------------------
565 API for deleting instances . Call to WO API incorporated.
566 -----------------------------------------------------------------------------*/
567
568 PROCEDURE delete_instance (
569 p_api_version IN NUMBER
570 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
571 ,p_commit IN VARCHAR2 := fnd_api.g_false
572 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
573 ,p_wip_entity_id IN NUMBER
574 ,p_organization_id IN NUMBER
575 ,p_operation_seq_num IN NUMBER
576 ,p_resource_seq_num IN NUMBER
577 ,p_instance_id IN NUMBER
578 ,x_return_status OUT NOCOPY VARCHAR2
579 ,x_msg_count OUT NOCOPY NUMBER
580 ,x_msg_data OUT NOCOPY VARCHAR2) ;
581
582 end EAM_OPERATIONS_JSP;