APPS.EAM_PROCESS_WO_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 8946: update wip_requirement_operations

8942: l_eam_wo_rec.status_type = 3 and
8943: ((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)))
8944: )
8945: THEN
8946: update wip_requirement_operations
8947: set released_quantity=required_quantity,
8948: last_update_date = SYSDATE,
8949: last_updated_by = FND_GLOBAL.User_Id,
8950: last_update_login = FND_GLOBAL.Login_Id

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

10097: END IF;
10098:
10099: IF l_eam_return_status = 'S' THEN
10100:
10101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Updating WIP_REQUIREMENT_OPERATIONS'); END IF;
10102:
10103: begin
10104: select operation_seq_num,first_unit_start_date
10105: bulk collect into l_wkorder_new_op_tbl,l_wkorder_new_op_dt_tbl

Line 10122: update WIP_REQUIREMENT_OPERATIONS

10118: IF l_wkorder_old_op_tbl(ii) = l_wkorder_new_op_tbl(jj) THEN
10119: IF l_wkorder_old_op_dt_tbl(ii) <> l_wkorder_new_op_dt_tbl(jj) THEN
10120:
10121: no_of_days := l_wkorder_new_op_dt_tbl(jj)-l_wkorder_old_op_dt_tbl(ii);
10122: update WIP_REQUIREMENT_OPERATIONS
10123: set date_required = date_required + no_of_days
10124: where organization_id = l_organization_id
10125: and wip_entity_id = l_wip_entity_id
10126: and operation_seq_num = l_wkorder_old_op_tbl(ii);

Line 10135: update WIP_REQUIREMENT_OPERATIONS

10131: END LOOP;
10132: -- condition for bug 5258151
10133: ELSE IF l_eam_wo_rec.transaction_type = G_OPR_CREATE and l_wkorder_new_op_tbl.count > 0 THEN
10134: FOR jj in l_wkorder_new_op_tbl.FIRST..l_wkorder_new_op_tbl.LAST LOOP
10135: update WIP_REQUIREMENT_OPERATIONS
10136: set date_required = l_wkorder_new_op_dt_tbl(jj)
10137: where organization_id = l_organization_id
10138: and wip_entity_id = l_wip_entity_id
10139: and operation_seq_num = l_wkorder_new_op_tbl(jj);

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

10140: END LOOP;
10141: END IF;
10142: END IF; --- end of l_wkorder_old_op_tbl.COUNT
10143:
10144: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Updating date required columns for WIP_REQUIREMENT_OPERATIONS'); END IF;
10145:
10146: IF l_wip_entity_id IS NOT NULL THEN
10147: select SCHEDULED_START_DATE into l_wo_new_sch_start_date
10148: from wip_discrete_jobs

Line 10153: update wip_requirement_operations

10149: where wip_entity_id = l_wip_entity_id;
10150: END IF;
10151:
10152: IF l_wo_old_sch_start_date <> l_wo_new_sch_start_date THEN
10153: update wip_requirement_operations
10154: set date_required = date_required + (l_wo_new_sch_start_date-l_wo_old_sch_start_date)
10155: where operation_seq_num = 1
10156: and organization_id = l_organization_id
10157: and wip_entity_id = l_wip_entity_id ;