APPS.EAM_PROCESS_WO_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 8397: update wip_requirement_operations

8393: l_eam_wo_rec.status_type = 3 and
8394: ((l_old_eam_wo_rec.date_released is null and l_old_eam_wo_rec.status_type IN (17,6,7)) OR (l_old_eam_wo_rec.status_type=1)))
8395: )
8396: THEN
8397: update wip_requirement_operations
8398: set released_quantity=required_quantity,
8399: last_update_date = SYSDATE,
8400: last_updated_by = FND_GLOBAL.User_Id,
8401: last_update_login = FND_GLOBAL.Login_Id

Line 9495: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WIP_REQUIREMENT_OPERATIONS'); END IF;

9491: END IF;
9492:
9493: IF l_eam_return_status = 'S' THEN
9494:
9495: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating WIP_REQUIREMENT_OPERATIONS'); END IF;
9496:
9497: begin
9498: select operation_seq_num,first_unit_start_date
9499: bulk collect into l_wkorder_new_op_tbl,l_wkorder_new_op_dt_tbl

Line 9516: update WIP_REQUIREMENT_OPERATIONS

9512: IF l_wkorder_old_op_tbl(ii) = l_wkorder_new_op_tbl(jj) THEN
9513: IF l_wkorder_old_op_dt_tbl(ii) <> l_wkorder_new_op_dt_tbl(jj) THEN
9514:
9515: no_of_days := l_wkorder_new_op_dt_tbl(jj)-l_wkorder_old_op_dt_tbl(ii);
9516: update WIP_REQUIREMENT_OPERATIONS
9517: set date_required = date_required + no_of_days
9518: where organization_id = l_organization_id
9519: and wip_entity_id = l_wip_entity_id
9520: and operation_seq_num = l_wkorder_old_op_tbl(ii);

Line 9529: update WIP_REQUIREMENT_OPERATIONS

9525: END LOOP;
9526: -- condition for bug 5258151
9527: ELSE IF l_eam_wo_rec.transaction_type = G_OPR_CREATE and l_wkorder_new_op_tbl.count > 0 THEN
9528: FOR jj in l_wkorder_new_op_tbl.FIRST..l_wkorder_new_op_tbl.LAST LOOP
9529: update WIP_REQUIREMENT_OPERATIONS
9530: set date_required = l_wkorder_new_op_dt_tbl(jj)
9531: where organization_id = l_organization_id
9532: and wip_entity_id = l_wip_entity_id
9533: and operation_seq_num = l_wkorder_new_op_tbl(jj);

Line 9538: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating date required columns for WIP_REQUIREMENT_OPERATIONS'); END IF;

9534: END LOOP;
9535: END IF;
9536: END IF; --- end of l_wkorder_old_op_tbl.COUNT
9537:
9538: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating date required columns for WIP_REQUIREMENT_OPERATIONS'); END IF;
9539:
9540: IF l_wip_entity_id IS NOT NULL THEN
9541: select SCHEDULED_START_DATE into l_wo_new_sch_start_date
9542: from wip_discrete_jobs

Line 9547: update wip_requirement_operations

9543: where wip_entity_id = l_wip_entity_id;
9544: END IF;
9545:
9546: IF l_wo_old_sch_start_date <> l_wo_new_sch_start_date THEN
9547: update wip_requirement_operations
9548: set date_required = date_required + (l_wo_new_sch_start_date-l_wo_old_sch_start_date)
9549: where operation_seq_num = 1
9550: and organization_id = l_organization_id
9551: and wip_entity_id = l_wip_entity_id ;