APPS.AHL_MM_MTL_MGT_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 2087: FROM ORG_ORGANIZATION_DEFINITIONS

2083:
2084: -- step 3 - Get Source Operationg Unit
2085: SELECT OPERATING_UNIT
2086: INTO L_SOURCE_OU
2087: FROM ORG_ORGANIZATION_DEFINITIONS
2088: WHERE ORGANIZATION_ID = P_SOURCE_ORG;
2089: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2090: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'L_SOURCE_OU = ' || L_SOURCE_OU);
2091: end if;

Line 2097: FROM ORG_ORGANIZATION_DEFINITIONS

2093:
2094: -- step 4 - Get destination Operationg Unit
2095: SELECT OPERATING_UNIT
2096: INTO L_DESTINATION_OU
2097: FROM ORG_ORGANIZATION_DEFINITIONS
2098: where ORGANIZATION_ID = l_demand_org_id;
2099: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2100: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'L_DESTINATION_OU = ' || L_DESTINATION_OU);
2101: end if;

Line 5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;

5221: l_location_control_dest NUMBER;
5222: l_temp_number NUMBER;
5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;
5229: --log

Line 5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;

5222: l_temp_number NUMBER;
5223: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
5224: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
5225: l_src_organization_name Org_Organization_definitions.organization_name%TYPE;
5226: l_dest_organization_name Org_Organization_definitions.organization_name%TYPE;
5227: BEGIN
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;
5229: --log
5230: G_DEBUG_LINE_NUM := 300;

Line 5250: FROM Org_Organization_definitions

5246: -- get the source org name instead of the org id for error message purpose
5247: BEGIN
5248: SELECT organization_name
5249: INTO l_src_organization_name
5250: FROM Org_Organization_definitions
5251: WHERE organization_id = p_x_mtltfr_rec.source_org_id;
5252: EXCEPTION
5253: WHEN OTHERS
5254: THEN

Line 5262: FROM Org_Organization_definitions

5258: -- get the dest org name instead of the org id for error message purpose
5259: BEGIN
5260: SELECT organization_name
5261: INTO l_dest_organization_name
5262: FROM Org_Organization_definitions
5263: WHERE organization_id = p_x_mtltfr_rec.dest_org_id;
5264: EXCEPTION
5265: WHEN OTHERS
5266: THEN