APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_ENTITIES

Line 183: FROM wip_entities

179: l_responsibility_id := p_responsibility_id;
180:
181: SELECT wip_entity_name
182: INTO l_work_order_name
183: FROM wip_entities
184: WHERE wip_entity_id = p_wip_entity_id;
185:
186: -- Validate status_id
187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Validating Status'); END IF;

Line 233: FROM wip_discrete_jobs wdj, wip_entities we

229: l_date_closed,
230: l_maintenance_obj_src,
231: l_po_creation_time,
232: l_maint_obj_id
233: FROM wip_discrete_jobs wdj, wip_entities we
234: where wdj.wip_entity_id = l_wip_entity_id
235: and we.wip_entity_id = wdj.wip_entity_id
236: and we.organization_id = wdj.organization_id;
237:

Line 954: UPDATE WIP_ENTITIES

950: l_class_code) = 1 THEN
951:
952: BEGIN
953:
954: UPDATE WIP_ENTITIES
955: SET ENTITY_TYPE = 6
956: WHERE ORGANIZATION_ID = l_organization_id
957: AND WIP_ENTITY_ID = l_wip_entity_id;
958:

Line 976: UPDATE WIP_ENTITIES

972: ELSE
973:
974: BEGIN
975:
976: UPDATE WIP_ENTITIES
977: SET ENTITY_TYPE = 7
978: WHERE ORGANIZATION_ID = l_organization_id
979: AND WIP_ENTITY_ID = l_wip_entity_id;
980: