APPS.INV_GENEALOGY_PUB dependencies on WIP_ENTITIES

Line 2216: FROM wip_entities

2212: ELSIF p_object_type = 5 THEN
2213: IF p_object_id IS NOT NULL THEN
2214: SELECT wip_entity_id
2215: INTO l_dummy
2216: FROM wip_entities
2217: WHERE gen_object_id = p_object_id;
2218:
2219: IF l_dummy = 0 THEN
2220: x_return_status := lg_ret_sts_error; -- R12

Line 2236: FROM wip_entities

2232: ELSE
2233: BEGIN
2234: SELECT gen_object_id
2235: INTO l_object_id
2236: FROM wip_entities
2237: WHERE wip_entity_name = LTRIM(RTRIM(p_object_number))
2238: AND organization_id = p_org_id;
2239: IF (p_debug = 1) THEN mydebug('5: l_object_id: ' || l_object_id); END IF;
2240:

Line 2356: FROM wip_entities

2352: -- Not putting p_validation around this since it belongs to EAM and will leave them to decide
2353: IF p_parent_object_id IS NOT NULL THEN
2354: SELECT wip_entity_id
2355: INTO l_dummy
2356: FROM wip_entities
2357: WHERE gen_object_id = p_parent_object_id;
2358:
2359: IF l_dummy = 0 THEN
2360: x_return_status := lg_ret_sts_error; -- R12

Line 2376: FROM wip_entities

2372: ELSE
2373: BEGIN
2374: SELECT gen_object_id
2375: INTO l_parent_object_id
2376: FROM wip_entities
2377: WHERE wip_entity_name = LTRIM(RTRIM(p_parent_object_number))
2378: AND organization_id = p_parent_org_id;
2379: IF (p_debug = 1) THEN mydebug('5: l_parent_object_id: ' || l_parent_object_id); END IF;
2380: