APPS.AHL_UC_UTILIZATION_PVT dependencies on MTL_PARAMETERS

Line 236: CURSOR mtl_parameters_csr(c_org_code VARCHAR2) IS

232: PROCEDURE convert_value_id(p_utilization_rec IN OUT NOCOPY
233: AHL_UC_UTILIZATION_PVT.utilization_rec_type)
234: IS
235: -- For organization id.
236: CURSOR mtl_parameters_csr(c_org_code VARCHAR2) IS
237: SELECT organization_id
238: FROM mtl_parameters
239: WHERE organization_code = c_org_code;
240:

Line 238: FROM mtl_parameters

234: IS
235: -- For organization id.
236: CURSOR mtl_parameters_csr(c_org_code VARCHAR2) IS
237: SELECT organization_id
238: FROM mtl_parameters
239: WHERE organization_code = c_org_code;
240:
241: -- For inventory_item_id.
242: CURSOR mtl_system_items_csr(c_item_number VARCHAR2,

Line 273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);

269: (p_utilization_rec.organization_id = FND_API.G_MISS_NUM)) THEN
270: -- if code is present.
271: IF ((p_utilization_rec.organization_code IS NOT NULL) AND
272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN
273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);
274: FETCH mtl_parameters_csr INTO l_organization_id;
275: IF (mtl_parameters_csr%FOUND) THEN
276: p_utilization_rec.organization_id := l_organization_id;
277: ELSE

Line 274: FETCH mtl_parameters_csr INTO l_organization_id;

270: -- if code is present.
271: IF ((p_utilization_rec.organization_code IS NOT NULL) AND
272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN
273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);
274: FETCH mtl_parameters_csr INTO l_organization_id;
275: IF (mtl_parameters_csr%FOUND) THEN
276: p_utilization_rec.organization_id := l_organization_id;
277: ELSE
278: FND_MESSAGE.set_name('AHL','AHL_UC_ORG_INVALID');

Line 275: IF (mtl_parameters_csr%FOUND) THEN

271: IF ((p_utilization_rec.organization_code IS NOT NULL) AND
272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN
273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);
274: FETCH mtl_parameters_csr INTO l_organization_id;
275: IF (mtl_parameters_csr%FOUND) THEN
276: p_utilization_rec.organization_id := l_organization_id;
277: ELSE
278: FND_MESSAGE.set_name('AHL','AHL_UC_ORG_INVALID');
279: FND_MESSAGE.set_token('ORG',p_utilization_rec.organization_code);

Line 282: CLOSE mtl_parameters_csr;

278: FND_MESSAGE.set_name('AHL','AHL_UC_ORG_INVALID');
279: FND_MESSAGE.set_token('ORG',p_utilization_rec.organization_code);
280: FND_MSG_PUB.add;
281: END IF;
282: CLOSE mtl_parameters_csr;
283: END IF;
284: END IF;
285: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
286: FND_LOG.STRING(G_LEVEL_STATEMENT,