APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HZ_PARTY_SITES

Line 3124: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN

3120: END IF;
3121: */
3122: ELSIF
3123:
3124: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN
3125:
3126: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3127: p_instance_rec.inv_organization_id := NULL;
3128: l_get_instance_rec.inv_organization_id := NULL;

Line 4275: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN

4271: RETURN l_return_value;
4272: END;
4273: -- End addition of code for R12
4274:
4275: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4276: BEGIN
4277: SELECT party_site_id
4278: INTO l_dummy
4279: FROM HZ_PARTY_SITES

Line 4279: FROM HZ_PARTY_SITES

4275: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4276: BEGIN
4277: SELECT party_site_id
4278: INTO l_dummy
4279: FROM HZ_PARTY_SITES
4280: WHERE party_site_id = p_location_id;
4281: l_return_value := TRUE;
4282: EXCEPTION
4283: WHEN NO_DATA_FOUND THEN

Line 4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN

4419: p_stack_err_msg BOOLEAN;
4420: BEGIN
4421:
4422: -- Get the values of installation parameters
4423: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4424: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4425: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4426: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4427: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND