177: l_responsibility_id := p_responsibility_id;
178:
179: SELECT wip_entity_name
180: INTO l_work_order_name
181: FROM wip_entities
182: WHERE wip_entity_id = p_wip_entity_id;
183:
184: -- Validate status_id
185: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
227: l_date_closed,
228: l_maintenance_obj_src,
229: l_po_creation_time,
230: l_maint_obj_id
231: FROM wip_discrete_jobs wdj, wip_entities we
232: where wdj.wip_entity_id = l_wip_entity_id
233: and we.wip_entity_id = wdj.wip_entity_id
234: and we.organization_id = wdj.organization_id;
235:
903: l_class_code) = 1 THEN
904:
905: BEGIN
906:
907: UPDATE WIP_ENTITIES
908: SET ENTITY_TYPE = 6
909: WHERE ORGANIZATION_ID = l_organization_id
910: AND WIP_ENTITY_ID = l_wip_entity_id;
911:
925: ELSE
926:
927: BEGIN
928:
929: UPDATE WIP_ENTITIES
930: SET ENTITY_TYPE = 7
931: WHERE ORGANIZATION_ID = l_organization_id
932: AND WIP_ENTITY_ID = l_wip_entity_id;
933: