APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HZ_LOCATIONS

Line 3138: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN

3134: END IF;
3135:
3136: ELSIF
3137:
3138: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN
3139:
3140: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3141: p_instance_rec.inv_organization_id := NULL;
3142: l_get_instance_rec.inv_organization_id := NULL;

Line 4376: ELSIF (p_location_source_table = 'HZ_LOCATIONS') THEN

4372: FND_MSG_PUB.Add;
4373: l_return_value := FALSE;
4374: RETURN l_return_value;
4375: END;
4376: ELSIF (p_location_source_table = 'HZ_LOCATIONS') THEN
4377: BEGIN
4378: SELECT location_id
4379: INTO l_dummy
4380: FROM hz_locations

Line 4380: FROM hz_locations

4376: ELSIF (p_location_source_table = 'HZ_LOCATIONS') THEN
4377: BEGIN
4378: SELECT location_id
4379: INTO l_dummy
4380: FROM hz_locations
4381: WHERE location_id = p_location_id;
4382: l_return_value :=TRUE;
4383: EXCEPTION
4384: WHEN NO_DATA_FOUND THEN

Line 4435: FROM hz_locations

4431: WHEN NO_DATA_FOUND THEN
4432: BEGIN
4433: SELECT location_id
4434: INTO l_dummy
4435: FROM hz_locations
4436: WHERE location_id = p_location_id;
4437: l_return_value :=TRUE;
4438: EXCEPTION
4439: WHEN NO_DATA_FOUND THEN

Line 4527: IF (p_location_source_table = 'HZ_LOCATIONS') THEN

4523: RETURN l_return_value;
4524: END IF;
4525: END IF;
4526: --
4527: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4528:
4529: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4530: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4531: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

Line 4571: END IF; -- location type is HZ_LOCATIONS

4567: RETURN l_return_value;
4568: END IF; -- usage code = 'INSTALLED'
4569: END IF; -- Project id , task id provided
4570:
4571: END IF; -- location type is HZ_LOCATIONS
4572: --
4573: IF (p_location_source_table = 'VENDOR_SITE') THEN
4574:
4575: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND