APPS.EAM_WO_DEFAULT_PVT dependencies on WIP_ENTITIES

Line 41: SELECT wip_entities_s.nextval

37: BEGIN
38:
39: 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_DEFAULT_PVT.get_wip_entity_id : Start ================'); END IF;
40:
41: SELECT wip_entities_s.nextval
42: INTO l_wip_entity_id
43: FROM dual;
44:
45: 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_DEFAULT_PVT.get_wip_entity_id : End wip_entity_id: '||l_wip_entity_id||' ================'); END IF;

Line 163: select count(*) into l_wip_entity_count from wip_entities

159: END IF;
160:
161: l_wip_entity_name := l_wip_entity_name_prefix || l_wip_entity_name;
162:
163: select count(*) into l_wip_entity_count from wip_entities
164: where organization_id = p_org_id and wip_entity_name =l_wip_entity_name
165: and rownum <= 1;
166:
167: EXIT WHEN l_wip_entity_count=0;