DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on WIP_OPERATIONS

Line 405: from wip_operations

401: PROCEDURE adjust_resources(i_wip_entity_id IN NUMBER) IS
402:
403: CURSOR all_operations IS
404: select operation_seq_num
405: from wip_operations
406: where wip_entity_id = i_wip_entity_id;
407:
408: l_wo_start_date DATE;
409: l_wo_completion_date DATE;

Line 432: update wip_operations set

428: and operation_seq_num = l_op_seq_num;
429: -- Update the Operation
430:
431: if (l_op_start_date is not null) and (l_op_completion_date is not null) then -- Fix for operations with no resources
432: update wip_operations set
433: first_unit_start_date = l_op_start_date,
434: first_unit_completion_date = l_op_completion_date,
435: last_unit_start_date = l_op_start_date,
436: last_unit_completion_date = l_op_completion_date

Line 450: from wip_operations

446: -- Update Work Order
447: BEGIN
448: select min(first_unit_start_date), max(last_unit_completion_date)
449: into l_wo_start_date, l_wo_completion_date
450: from wip_operations
451: where wip_entity_id = i_wip_entity_id;
452:
453: if (l_wo_start_date is not null and l_wo_completion_date is not null) then
454: update wip_discrete_jobs set

Line 472: from wip_operations

468: i_operation_table IN t_optime_table) IS
469:
470: CURSOR all_operations IS
471: select operation_seq_num
472: from wip_operations
473: where wip_entity_id = i_wip_entity_id;
474:
475: l_index NUMBER;
476:

Line 504: from wip_operations

500: -- Work Order
501: BEGIN
502: select min(first_unit_start_date), max(last_unit_completion_date)
503: into l_wo_start_date, l_wo_completion_date
504: from wip_operations
505: where wip_entity_id = i_wip_entity_id;
506:
507: update wip_discrete_jobs set
508: scheduled_start_date = l_wo_start_date,

Line 539: update wip_operations set

535: i_wip_entity_id IN NUMBER,
536: i_shift IN NUMBER) IS
537: BEGIN
538: -- Operations
539: update wip_operations set
540: first_unit_start_date = first_unit_start_date,
541: first_unit_completion_date = first_unit_completion_date,
542: last_unit_start_date = last_unit_start_date,
543: last_unit_completion_date = last_unit_completion_date

Line 575: from wip_operations

571: FETCH all_dependencies INTO l_from_op, l_to_op;
572: EXIT WHEN all_dependencies%NOTFOUND;
573: select first_unit_start_date, last_unit_completion_date
574: into l_start_date_from, l_end_date_from
575: from wip_operations
576: where wip_entity_id = i_wip_entity_id
577: and operation_seq_num = l_from_op;
578: select first_unit_start_date, last_unit_completion_date
579: into l_start_date_to, l_end_date_to

Line 580: from wip_operations

576: where wip_entity_id = i_wip_entity_id
577: and operation_seq_num = l_from_op;
578: select first_unit_start_date, last_unit_completion_date
579: into l_start_date_to, l_end_date_to
580: from wip_operations
581: where wip_entity_id = i_wip_entity_id
582: and operation_seq_num = l_to_op;
583: if l_start_date_to < l_end_date_from then
584: CLOSE all_dependencies;

Line 1121: UPDATE WIP_OPERATIONS

1117: /* Bug#3022963: All 3 checks should be negative for the wok order to be
1118: put from released to unreleased */
1119: IF (charges_exist_1 = '0' and charges_exist_2 = '0' and charges_exist_3 = '0') THEN
1120:
1121: UPDATE WIP_OPERATIONS
1122: SET QUANTITY_WAITING_TO_MOVE = 0,
1123: QUANTITY_SCRAPPED = 0,
1124: QUANTITY_REJECTED = 0,
1125: QUANTITY_IN_QUEUE = 0,