DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PVT dependencies on WIP_ENTITIES

Line 38: FROM wip_entities

34: RETURN VARCHAR2
35: IS
36: CURSOR wip_entity_name_csr(p_wip_entity_id NUMBER) IS
37: SELECT wip_entity_name
38: FROM wip_entities
39: WHERE wip_entity_id = p_wip_entity_id;
40:
41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
42: BEGIN

Line 41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;

37: SELECT wip_entity_name
38: FROM wip_entities
39: WHERE wip_entity_id = p_wip_entity_id;
40:
41: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
42: BEGIN
43: OPEN wip_entity_name_csr(p_wip_entity_id);
44: FETCH wip_entity_name_csr INTO l_wip_entity_name;
45: CLOSE wip_entity_name_csr;