APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HZ_PARTY_SITES

Line 3176: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN

3172: END IF;
3173: */
3174: ELSIF
3175:
3176: l_get_instance_rec.location_type_code = 'HZ_PARTY_SITES' THEN
3177:
3178: IF p_instance_rec.inv_organization_id = FND_API.G_MISS_NUM THEN
3179: p_instance_rec.inv_organization_id := NULL;
3180: l_get_instance_rec.inv_organization_id := NULL;

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

4357: RETURN l_return_value;
4358: END;
4359: -- End addition of code for R12
4360:
4361: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4362: BEGIN
4363: SELECT party_site_id
4364: INTO l_dummy
4365: FROM HZ_PARTY_SITES

Line 4365: FROM HZ_PARTY_SITES

4361: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4362: BEGIN
4363: SELECT party_site_id
4364: INTO l_dummy
4365: FROM HZ_PARTY_SITES
4366: WHERE party_site_id = p_location_id;
4367: l_return_value := TRUE;
4368: EXCEPTION
4369: WHEN NO_DATA_FOUND THEN

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

4505: p_stack_err_msg BOOLEAN;
4506: BEGIN
4507:
4508: -- Get the values of installation parameters
4509: IF (p_location_source_table = 'HZ_PARTY_SITES') THEN
4510: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4511: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND
4512: ((p_sales_ord_line_id IS NULL) OR (p_sales_ord_line_id = FND_API.G_MISS_NUM)) AND
4513: ((p_po_line_id IS NULL) OR (p_po_line_id = FND_API.G_MISS_NUM)) AND