APPS.AHL_MC_ITEMGROUP_PUB dependencies on MTL_PARAMETERS

Line 475: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS

471: PROCEDURE Convert_InTo_ID(p_x_item_assoc_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_association_rec_type) IS
472:
473:
474: -- For organization id.
475: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
476: SELECT organization_id
477: FROM mtl_parameters
478: WHERE organization_code = p_org_code;
479:

Line 477: FROM mtl_parameters

473:
474: -- For organization id.
475: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS
476: SELECT organization_id
477: FROM mtl_parameters
478: WHERE organization_code = p_org_code;
479:
480: -- For inventory_item_id.
481: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,

Line 533: OPEN mtl_parameters_csr (l_item_assoc_rec.inventory_org_code);

529: THEN
530: -- if code is present.
531: IF (l_item_assoc_rec.inventory_org_code IS NOT NULL) AND
532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
533: OPEN mtl_parameters_csr (l_item_assoc_rec.inventory_org_code);
534: FETCH mtl_parameters_csr INTO l_inventory_org_id;
535: IF (mtl_parameters_csr%FOUND) THEN
536: l_item_assoc_rec.inventory_org_id := l_inventory_org_id;
537: ELSE

Line 534: FETCH mtl_parameters_csr INTO l_inventory_org_id;

530: -- if code is present.
531: IF (l_item_assoc_rec.inventory_org_code IS NOT NULL) AND
532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
533: OPEN mtl_parameters_csr (l_item_assoc_rec.inventory_org_code);
534: FETCH mtl_parameters_csr INTO l_inventory_org_id;
535: IF (mtl_parameters_csr%FOUND) THEN
536: l_item_assoc_rec.inventory_org_id := l_inventory_org_id;
537: ELSE
538: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');

Line 535: IF (mtl_parameters_csr%FOUND) THEN

531: IF (l_item_assoc_rec.inventory_org_code IS NOT NULL) AND
532: (l_item_assoc_rec.inventory_org_code <> FND_API.G_MISS_CHAR) THEN
533: OPEN mtl_parameters_csr (l_item_assoc_rec.inventory_org_code);
534: FETCH mtl_parameters_csr INTO l_inventory_org_id;
535: IF (mtl_parameters_csr%FOUND) THEN
536: l_item_assoc_rec.inventory_org_id := l_inventory_org_id;
537: ELSE
538: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
539: FND_MESSAGE.Set_Token('ORG',l_item_assoc_rec.inventory_org_code);

Line 542: CLOSE mtl_parameters_csr;

538: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_INVALID');
539: FND_MESSAGE.Set_Token('ORG',l_item_assoc_rec.inventory_org_code);
540: FND_MSG_PUB.ADD;
541: END IF;
542: CLOSE mtl_parameters_csr;
543: ELSIF (l_item_assoc_rec.operation_flag = 'C') THEN
544: -- Both ID and code are missing.
545: FND_MESSAGE.Set_Name('AHL','AHL_MC_ORG_NULL');
546: FND_MSG_PUB.ADD;