APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HZ_LOCATIONS

Line 3086: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN

3082: END IF;
3083:
3084: ELSIF
3085:
3086: l_get_instance_rec.location_type_code = 'HZ_LOCATIONS' THEN
3087:
3088: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3089: p_instance_rec.inv_organization_id := NULL;
3090: l_get_instance_rec.inv_organization_id := NULL;

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

4286: FND_MSG_PUB.Add;
4287: l_return_value := FALSE;
4288: RETURN l_return_value;
4289: END;
4290: ELSIF (p_location_source_table = 'HZ_LOCATIONS') THEN
4291: BEGIN
4292: SELECT location_id
4293: INTO l_dummy
4294: FROM hz_locations

Line 4294: FROM hz_locations

4290: ELSIF (p_location_source_table = 'HZ_LOCATIONS') THEN
4291: BEGIN
4292: SELECT location_id
4293: INTO l_dummy
4294: FROM hz_locations
4295: WHERE location_id = p_location_id;
4296: l_return_value :=TRUE;
4297: EXCEPTION
4298: WHEN NO_DATA_FOUND THEN

Line 4349: FROM hz_locations

4345: WHEN NO_DATA_FOUND THEN
4346: BEGIN
4347: SELECT location_id
4348: INTO l_dummy
4349: FROM hz_locations
4350: WHERE location_id = p_location_id;
4351: l_return_value :=TRUE;
4352: EXCEPTION
4353: WHEN NO_DATA_FOUND THEN

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

4437: RETURN l_return_value;
4438: END IF;
4439: END IF;
4440: --
4441: IF (p_location_source_table = 'HZ_LOCATIONS') THEN
4442:
4443: IF --((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4444: --((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4445: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND

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

4481: RETURN l_return_value;
4482: END IF; -- usage code = 'INSTALLED'
4483: END IF; -- Project id , task id provided
4484:
4485: END IF; -- location type is HZ_LOCATIONS
4486: --
4487: IF (p_location_source_table = 'VENDOR_SITE') THEN
4488:
4489: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND