APPS.INV_GENEALOGY_PUB dependencies on WIP_ENTITIES

Line 2239: FROM wip_entities

2235: ELSIF p_object_type = 5 THEN
2236: IF p_object_id IS NOT NULL THEN
2237: SELECT wip_entity_id
2238: INTO l_dummy
2239: FROM wip_entities
2240: WHERE gen_object_id = p_object_id;
2241:
2242: IF l_dummy = 0 THEN
2243: x_return_status := lg_ret_sts_error; -- R12

Line 2259: FROM wip_entities

2255: ELSE
2256: BEGIN
2257: SELECT gen_object_id
2258: INTO l_object_id
2259: FROM wip_entities
2260: WHERE wip_entity_name = LTRIM(RTRIM(p_object_number))
2261: AND organization_id = p_org_id;
2262: IF (p_debug = 1) THEN mydebug('5: l_object_id: ' || l_object_id); END IF;
2263:

Line 2379: FROM wip_entities

2375: -- Not putting p_validation around this since it belongs to EAM and will leave them to decide
2376: IF p_parent_object_id IS NOT NULL THEN
2377: SELECT wip_entity_id
2378: INTO l_dummy
2379: FROM wip_entities
2380: WHERE gen_object_id = p_parent_object_id;
2381:
2382: IF l_dummy = 0 THEN
2383: x_return_status := lg_ret_sts_error; -- R12

Line 2399: FROM wip_entities

2395: ELSE
2396: BEGIN
2397: SELECT gen_object_id
2398: INTO l_parent_object_id
2399: FROM wip_entities
2400: WHERE wip_entity_name = LTRIM(RTRIM(p_parent_object_number))
2401: AND organization_id = p_parent_org_id;
2402: IF (p_debug = 1) THEN mydebug('5: l_parent_object_id: ' || l_parent_object_id); END IF;
2403: