DBA Data[Home] [Help]

APPS.WIP_CLOSE_UTILITIES dependencies on WIP_ENTITIES

Line 46: UPDATE WIP_ENTITIES

42: END IF;
43:
44: -- reset back to 6 (eam rel) if 7 (eam close), set to 5 (osfm rel)
45: -- if 8 (osfm close), otherwise, set it back to 1 (discrete)
46: UPDATE WIP_ENTITIES
47: SET ENTITY_TYPE = decode(ENTITY_TYPE, 7, 6, 8, 5, 1)
48: WHERE WIP_ENTITY_ID = P_wip_entity_id;
49:
50: RETURN(1);