APPS.EAM_SCHED_BOTTOM_UP_PVT dependencies on WIP_OPERATION_RESOURCES

Line 154: UPDATE wip_operation_resources

150: IF ( NVL( l_change_date, 'N' ) = 'Y' ) THEN
151:
152: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating WOR ') ; END IF ;
153:
154: UPDATE wip_operation_resources
155: SET start_date = l_res_start_date ,
156: completion_date = l_res_end_date ,
157: last_update_date = sysdate ,
158: last_updated_by = FND_GLOBAL.user_id ,

Line 502: FROM wip_operation_resources

498: SELECT start_date,
499: completion_date,
500: operation_seq_num,
501: resource_seq_num
502: FROM wip_operation_resources
503: WHERE wip_entity_id = c_wip_entity_id;
504:
505: CURSOR get_inst_usage_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
506: SELECT MIN(start_date) as min_inst_usg_date

Line 700: UPDATE wip_operation_resources

696:
697:
698: --/* Adjust WORU and WOR dates
699: IF c_resusagemin_date < c_opresource_rec.start_date THEN
700: UPDATE wip_operation_resources
701: SET start_date = c_resusagemin_date,
702: last_update_date = sysdate ,
703: last_updated_by = FND_GLOBAL.user_id ,
704: last_update_login = FND_GLOBAL.login_id

Line 714: UPDATE wip_operation_resources

710:
711: END IF;
712:
713: IF c_resusagemax_date > c_opresource_rec.completion_date THEN
714: UPDATE wip_operation_resources
715: SET completion_date = c_resusagemax_date,
716: last_update_date = sysdate ,
717: last_updated_by = FND_GLOBAL.user_id ,
718: last_update_login = FND_GLOBAL.login_id

Line 740: from wip_operation_resources

736: END IF ;
737:
738: select min(start_date), max(completion_date)
739: into l_min_res_date, l_max_res_date
740: from wip_operation_resources
741: where wip_entity_id = p_wip_entity_id
742: and operation_seq_num = c_operation_rec.operation_seq_num;
743:
744: IF l_min_res_date <> c_operation_rec.first_unit_start_date THEN /*Bug 7336817*/

Line 1275: UPDATE wip_operation_resources

1271: IF ( NVL(l_update,'Y') = 'Y' ) THEN
1272:
1273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating dates in from WOR ' ) ; END IF ;
1274:
1275: UPDATE wip_operation_resources
1276: SET start_date = l_min_start_date,
1277: completion_date = l_max_completion_date ,
1278: last_update_date = sysdate ,
1279: last_updated_by = FND_GLOBAL.user_id ,