APPS.EAM_WO_DEFAULT_PVT dependencies on WIP_ENTITIES

Line 39: SELECT wip_entities_s.nextval

35: IS
36: l_wip_entity_id NUMBER := NULL;
37: BEGIN
38:
39: SELECT wip_entities_s.nextval
40: INTO l_wip_entity_id
41: FROM dual;
42:
43: RETURN l_wip_entity_id;

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

104: FROM dual;
105:
106: l_wip_entity_name := l_wip_entity_name_prefix || l_wip_entity_name;
107:
108: select count(*) into l_wip_entity_count from wip_entities
109: where organization_id = p_org_id and wip_entity_name =l_wip_entity_name
110: and rownum <= 1;
111:
112: EXIT WHEN l_wip_entity_count=0;