APPS.EAM_SCHED_BOTTOM_UP_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 670: UPDATE wip_op_resource_instances

666: FETCH get_woru_max_date INTO c_instusagemax_date;
667: close get_woru_max_date;
668:
669: IF c_instusagemin_date < c_instdates_rec.start_date THEN
670: UPDATE wip_op_resource_instances
671: SET start_date = c_instusagemin_date,
672: last_update_date = sysdate ,
673: last_updated_by = FND_GLOBAL.user_id ,
674: last_update_login = FND_GLOBAL.login_id

Line 683: UPDATE wip_op_resource_instances

679: AND (serial_number IS NULL OR (serial_number = c_instdates_rec.serial_number));
680: END IF;
681:
682: IF c_instusagemax_date > c_instdates_rec.completion_date THEN
683: UPDATE wip_op_resource_instances
684: SET completion_date = c_instusagemax_date,
685: last_update_date = sysdate ,
686: last_updated_by = FND_GLOBAL.user_id ,
687: last_update_login = FND_GLOBAL.login_id

Line 1036: DELETE FROM wip_op_resource_instances

1032: -- If there are no rows in WORU for an employee then delete from WORI also
1033:
1034: IF (l_count=0 ) THEN
1035:
1036: DELETE FROM wip_op_resource_instances
1037: WHERE wip_entity_id =p_eam_res_usage_rec.wip_entity_id
1038: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
1039: AND organization_id = p_eam_res_usage_rec.organization_id
1040: AND resource_seq_num =p_eam_res_usage_rec.resource_seq_num

Line 1055: * Purpose : Updates/Deletes record from wip_op_resource_instances table . Returns changed

1051: * Parameters IN : p_eam_res_usage_rec
1052: p_eam_res_inst_tbl
1053: * Parameters OUT : x_eam_res_inst_tbl
1054: x_return_status
1055: * Purpose : Updates/Deletes record from wip_op_resource_instances table . Returns changed
1056: instance records in x_eam_res_inst_tbl.
1057: ************************************************************************************************************************/
1058:
1059: procedure update_wori ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type

Line 1128: UPDATE wip_op_resource_instances

1124:
1125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Update WORI' ) ; END IF ;
1126:
1127:
1128: UPDATE wip_op_resource_instances
1129: SET start_date = l_min_start_date,
1130: completion_date = l_max_completion_date ,
1131: last_update_date = sysdate ,
1132: last_updated_by = FND_GLOBAL.user_id ,

Line 1214: * Purpose : Updates/Deletes record from wip_op_resource_instances table . Returns changed

1210: * Parameters IN : p_eam_res_usage_rec
1211: p_eam_res_tbl
1212: * Parameters OUT : x_eam_res_tbl
1213: x_return_status
1214: * Purpose : Updates/Deletes record from wip_op_resource_instances table . Returns changed
1215: instance records in x_eam_res_tbl.
1216: ************************************************************************************************************************/
1217:
1218: procedure update_wor ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type